Deepak Reddy

Description: The logistics BI solution is an initiative to bring about the reporting capabilities into ITG global logistics department. The logistics department works to manage transport management within the organization. The solution allows the user to view rates, books, and track the shipments.

Responsibilities:

• Conversant with all phases of Software Development Life Cycle ( SDLC ) involving Systems Analysis, Design, Development and Implementation.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning. Used Power BI Gateways to keep the dashboards and reports up to date.
• Experienced in Data Modeling used to define and analyze data requirements needed to support the business processes within the scope of corresponding information systems in organizations.
• Proficient in using tools like MS SQL Profiler, Database Engine Tuning Advisor, Windows performance for monitoring and tuning SQL Server performance.
• Created schemas like the Star Schema and the Snowflake Schema while working on the model view.
• Maintained and tested the Database schema, Stored Procedure, Trigger, Integration test of SQL Server. Reviewed the packages in SSIS , reports in SSRS .
• ETL for data cleansing, data auditing, and data profiling. Collaborates and implements ETL best practices.
• Calculated ratio and expenses on PowerBI reports using the DAX function and T- SQL.
• Extensively used custom R-Visuals, Clustered Bar Charts, Clustered Column charts, Donut Charts, Hierarchy slicers, Waterfall charts, Scatter charts, Area charts, and KPI s in Power BI reports .
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services ( SSRS ).
• There is now report interoperability across Power BI, SSRS, and Python reports.
• Created Tableau Dashboard for the top key Performance Indicators for the top management by connecting various data sources like Excel, Flat files, and SQL Database .
• Developing and maintaining/modifying complex T-SQL queries , stored procedures and SSIS packages to load the data into warehouse.
• Developed Dynamic Row level security with power bi and integration with Power BI service portal develop and deploy SSIS packages, configuration files, and scheduled jobs to run the packages to generate data in CSV files.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects.
• Knowledge on using SQL, Python, and PySpark , worked Data bricks notebooks were generated, and automated notebooks were made using tasks.
• Strong development skills with Azure Data Lake, Azure Data Factory, SQL Data Warehouse Azure Blob, Azure Storage Explorer
• Understanding of Big Data Hadoop, Spark, Sqoop, Hive, HDFS, and Map Reduce .
• Used JIRA as a sprint tracking platform, followed the Agile process, and took part in daily SCRUM meetings, sprint planning, showcases, and retrospective.

Environment : Power bi, Excel, KPI, SSAS, SSRS, Python, T SQL, SQL, PySaprk, Azure Data Lake, Azure Data Factory, Jira, Agile, Scrum, DAX, Power Pivot, Gateways, star, Snowflake, Ms SQL, Tableau, Excel, Flat.

Description: On Capital IQ platforms of S&P group where a client can view all the information which is pertinent for any sort of investment. These platforms shares financial, market data and transactional information for equities, indices, fixed income and other investing options.

Responsibilities:

• Hands-on experience in the areas of Application Design, Code Development, Testing, Support, Upgrade, Maintenance, and Implementation of Business Intelligence projects.
• Involved in performance tuning by checking the loads on Indexes by using SQL profiler and Tuning advisor
• Strong Dashboard design experience and passionate practitioner of effective data visualization with best practices around visualization and design.
• Extensive experience in Business Intelligence in MS SQL Server Integration Services SSIS, MS SQL Server Reporting Services SSRS .
• Good at developing reports using different Reports Tools SSRS, Tableau , and MS Power BI.
• Created Star schema dimensional modelling for the data mart and created dimension and fact tables based on the business requirement.
• Design and implement the ETL processes using SSIS which involves collection of data from sources like SQL Server.
• Created many calculated columns and measures using DAX in Power BI based on report requirements complex T-SQL queries, stored procedures and SSIS packages to load the data into warehouse.
• Designed and built OLAP cubes to meet reporting needs.
• Developed and implemented data models and data warehouses using Snowflake .
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2012/2008.
• Knowledge in creating KPI's , Perspectives, Partitions using SSAS . Created Power view reports using the Tabular SSAS models in Excel.
• Created jobs for automatically running Stored Procedures for day-end operations using SQL Server agent such as index rebuild, data loads and summary reports.
• Designed SSRS reports with dynamic sorting, defining data source and subtotals for the report. Developed in deploying SQL Databases in AZURE .
• Experience on Structured data analysis utilizing SQL, Tableau, Excel, and Python.
• Automated Power Query refresh using power shell script and windows task scheduler.
• Construction and documentation a number of technologies were utilized, including Confluence for all project-related documents, JIRA for regular development activities, and QC for defect management.
• Experience in AGILE Methodology projects.

Environment : Power BI, DAX, OLAP, SSRS, SSAS, SSIS, KPI, Excel, Power View, Azure, SQL, Tableau, Python, Shell Scripts, Jira, Agile, T SQL, Snowflake, ETL, Tableau, MS SQL, Star, Power Query.