SUMMARY

• 13 years of extensive experience working with MSBI/Power BI and T - SQL using SQL Server 2008R2/ 2012/ 2014/ 2016 .
• Worked in different domains like Insurance, Entertainment, Banking. Experienced working with agile methodology involving in Analysis, Design and Development of MSBI solutions.
• Having hands on experience in Microsoft Azure Cloud applications, includes Azure Data Factory, Data Lake, Azure Datawarehouse, Azure SQL Server, Power BI.
• Expert in Understanding the Technical Specification and creating and modifying the SSIS packages according to the Business requirements. Experienced working with Database Architecture for Design and Development of Data models and Data warehouse
• Experience in Writing TSQL (DDL, DML AND DCL), developing/creating new database objects such as Tables, Views, Indexes, Complex stored procedures, function (UDF), cursors, and triggers, locking issues, BCP, common table expressions (CTEs), Backups, Recovery and SQLServer Agent profiler using SQLSERVER 2014/2012 /2008 R2.
• Extensive knowledge in dealing with RDBMS including E/R Diagrams, Normalization, Constraints, Joins, Keys and Data Import/Export.
• Experience in developing SSIS packages for data migration between different heterogeneous sources such as flat file, excel, Oracle, Sybase, DB2, MS access
• Good Knowledge of Normalization, Performance Tuning, Development Life Cycle source control and ticketing systems and Version Control tools while Design and Development of Data warehouse.
• Configured Check Points, Break points, Event Handlers and Logging to the SSIS packages.
• Worked on change requests, identifying the defects and working on resolution, processing on SSIS Packages.
• Experience in Developing and Extending SSAS Cubes MDX & Tabular, Building the Dimensions, Deploying, Processing SSAS objects, Cubes with Snowflake Schemas and Star Schema using SQL Server Analysis Services (SSAS)
• Dimensions and Calculated Measures, Partitioning and building MDX queries.
• Handled Performance Tuning and Optimization on SSIS and MDX, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Implemented complex query techniques of passing Multi-Valued parameters and cascading parameters in MDX.
• Highly skilled in developing OLAP cubes using SSAS measures, measure groups and dimension members in SQL Server Analysis Services using Dynamic Analysis expression (DAX), mathematical formulae, and user-defined functions.
• Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS. Developed the SSAS 2012 Tabular model reports from Data warehouse using SSDT.
• Excellent hands on experience in creating groups and measures, KPIs.
• Created reports such as Parameterized, Cascading, drill through/Drill down Reports, Charts and specialized in producing Sub Reports using Relational data warehouse and OLAP Cubes.
• Experience in developing several Details, Summary reports including line and pie charts, trend analysis reports and sub-reports per business requirements using SSRS.
• Experience in generating on-demand and scheduled reports for business analysis using SSRS.
• Used recently introduced Power BI to create self-service BI capabilities and use tabular models.
• Responsible for building reports in Power BI from the Scratch.
• Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.
• Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.
• Include slowly changing dimensions SCD and few data warehousing technique implementations.
• Reduce points on MDX, keep more on SSAS Tabular model with Power BI

TECHNICAL SKILLS

Data Warehousing & BI: SQL Server Business Intelligence Studio (SSIS, SSRS, SSAS, DTS), Datastage

Reporting Tools: SSRS 2014/2012/2008/ , Excel, Tableau, Power BI.

Database: MS SQL Server 2016/2014/2008 R2/2005, Oracle, MS-ACCESS.

Azure: Azure Data Factory, Azure Data Warehouse, Power BI, Azure Data Lake

Programming: Python, C#, TSQL.

Productivity Applications: MS Word, MS Excel, MS Access, MS Project, Visio

Operating System: Windows 2012R2, LINUX.

Application Servers: Microsoft IIS 6.0/5.0/4.0, Apache.

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Sr. MS Datawarehouse/Power BI Developer

Responsibilities:

• Import data from different data source to create Power BI reports and dashboards
• Involved in creating dynamic well-organized, accurate and insightful Power BI reports/dashboards to support strategic decisions.
• Expertise in data transformations such as adding calculated columns, manage relationships, create different measures, remove rows, replace values, split column, Date & Time Column, etc.
• Created different reports in Power BI Desktop and publish to Power BI online.
• Handled SQL Server and SSIS, SSAS, SSRS. Converted SSRS reports into Power BI visualizations.
• Developed complex calculated measures using Data Analysis Expression language ( DAX ).
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging
• Worked on Power BI desktop and power BI service to publish the reports.
• Created reports like Drill-Down, Drill-Through, Chart, Sub Reports Bar charts, Line charts, Pie charts using SQL Server Reporting Services (SSRS).
• Defined the report layout in SSRS. Created complex stored procedures for Reporting services, Analyzed Reports and Fixed Bugs in stored procedures.
• Implemented SSIS packages to load the Data into Staging, ODS and dimensional model.
• Designed and developed SSIS packages using various control flow and data flow items to transform and load the data from various databases and into server integrations services (SSIS).
• Configured package with checkpoints, package logging, error handling and event handling to redirect error rows and fix the error in SSIS.
• Developed Lookup Transformation package for data matching, compare source and destination data based on id and get the new and updated records and then used conditional split to select that new records before inserting into the database.
• Created Dimensions with the cube wizard and T-SQL programming. Refreshing the cube to get the latest information updated for OLAP databases. Deployment of Cubes to the production server.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Migrate and Convert existing ETL packages from Legacy systems into new Azure Data Factory, to load data into Azure Data Warehouse.
• Generated daily, weekly and monthly reports for the managers.
• Provided 24X7 production support to ensure timely and error free delivery of reports.
• Supported and developed DataStage jobs to load respective Dimensions and Fact tables.
• Used DataStage Designer and Director to schedule and monitor resulting executable versions

Environment: Windows2010 Advanced Server, ASP.Net, MS SQL Server 2005/2008/2012/2014 , TSQL, Pl/SQL, Visual Studio 2008, Oracle 11g, SSRS, SSIS, Datastage.

Confidential

SQL/BI Developer

Responsibilities:

• Created reports like Drill-Down, Drill-Through, Chart, Sub Reports Bar charts, Line charts, Pie charts using SQL Server Reporting Services (SSRS).
• Defined the report layout in SSRS. Created complex stored procedures for Reporting services, Analyzed Reports and Fixed Bugs in stored procedures.
• Implemented SSIS packages to load the Data into Staging, ODS and dimensional model.
• Designed and developed SSIS packages using various control flow and data flow items to transform and load the data from various databases and into server integrations services (SSIS).
• Configured package with checkpoints, package logging, error handling and event handling to redirect error rows and fix the error in SSIS.
• Developed Lookup Transformation package for data matching, compare source and destination data based on id and get the new and updated records and then used conditional split to select that new records before inserting into the database.
• Created Dimensions with the cube wizard and T-SQL programming. Refreshing the cube to get the latest information updated for OLAP databases. Deployment of Cubes to the production server.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Created Clustered and Non-Clustered Indexes on tables for performance optimization of complex stored procedures.
• Generated daily, weekly and monthly reports for the managers.
• Designed and created OLAP cubes on data warehouse.
• Designed a partitioning strategy to refresh cubes effectively.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• SSAS cube development in 2008 R2 for financial planning and operational performance metrics.
• Extracted data using SSIS from OLTP to OLAP. Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view.
• Designed and implemented data access stored procedures and triggers for automating tasks and job scheduling.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Implemented complex query techniques of passing Multi-Valued parameters and cascading parameters in MDX.
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
• Design web-based resource areas in collaboration with IT guidelines.

Environment: SQL Server 2008R2, SQL Services Integration Services 2008R2, T-SQL, XML, MS SQL Reporting Services 2008R2, SQL Profiler, MS Office, DB2, Windows Server 2008.