OBJECTIVE:

To Pursue a challenging position, to utilize my skills and abilities in the field of Information Technology that offers professional growth while being resourceful, Innovative and flexible.

PROFESSIONAL SUMMARY:

• 8+ Years of expert - level skills in Confidential Data Management technologies such as SQL Server 2014/2012/2005 , SSIS, SSAS, SSRS and Power BI.
• Award-winning, accomplished Business Intelligence Professional with extensive background in development of cutting-edge business intelligence solutions at Confidential .
• Expertise in design and development of Analytics Software solutions, driven by high-availability databases containing large volumes of data, for the Windows Phone Apps and Stores.
• Experience with T-SQL in constructing Triggers, Tables, User Defined Functions, Views, Indexes and Stored Procedures.
• Excellent Knowledge in RDBMS Concepts and Experience in Normalization of tables up to Third Normalization Form.
• Expertise in T-SQL; Writing complex Stored Procedures, Functions, Common Table Expressions, Merge statements, Triggers, Creating Indexes, Analyzing Execution plans, Scheduling SQL jobs, Import and Export data into/from other sources.
• Expertise in designing ETL/data migration using SQL Server Integration Service tools/mechanism like Control/Data flow components, Logging, Event handler, Checkpoint, Transactions.
• Experience in providing system and user defined variables, Logging, Error handling by using Event Handler and Performance Tuning in SSIS packages by using Row transformations, Block and Unblock transformations.
• Experienced in merging data from various heterogeneous data sources, Populating Dimension and Fact tables in data warehouses and data marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Extensive knowledge of Designing, Developing and deploying various kinds of reports of SSRS reports using relational and multidimensional data.
• Expertise in creating various SSRS reports like Charts, Filters, Sub reports, Drilldown and Drill-Through, Cascade, Parameterized reports involving conditional formatting
• Experience in creating Ad-hoc Reports, Subscription Reports by using Report Builder in SSRS
• Good knowledge of Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modelling, Star Schema Modeling, Snow-Flake Modeling for FACT and Dimension Tables using Analysis Services.
• Developed OLAP Cubes by using SQL Server Analysis (SSAS), and defined data sources, Data Source views, Dimensions, Measures, Hierarchies, Attributes, and Calculations using Multi Expression (MDX), Perspective and Roles.
• Experience with Visual Studio Team Foundation server and Source Depot.
• Experience in monitoring and tuning SQL Server database performance using tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
• Adept at analysis of business requirements and preparation of Functional Requirement Specifications while working in Agile/Scrum environments.
• Proven skills in development and execution of project release plans, ensuring delivery of solutions within time and budget constraints.
• An excellent communicator with ability to work effectively with offshore teams. Demonstrates keen analytical ability and information analysis skills.

TECHNICAL SKILLS:

Business Intelligence: SSAS, SSIS, SSRS, Power BI Suite

Databases: SQL Server 2012/16, SQL Server 2008/2005

Languages: C#.NET, DAX, PHP, SCOPE, PowerShell,USQL

Modeling Tool: ERWIN, Kimball Modeling, Data modelling

Framework: Confidential .net

Applications & IDE: Visual Studio.NET, Business Intelligence Development Studio, MSOffice

PROFESSIONAL EXPERIENCE:

Confidential

Senior Technical Lead

Responsibilities:

• Designing the Architecture for ETL, Cube and Reports development based on Business requirement.
• Developed Power BI reports that provided advanced slice and dice functionality to meet the unique information requirements of different users.
• Developed a tabular model to improve user query response time, and created multiple perspectives,hierarchies, attributes and KPIs to provide flexibility in tabular usage.
• Developed stored procedures, calculated members, perspectives based on the user’s requirements.
• Developed SSIS packages to pull the data from different sources and involved in the ETL processes.(Source: DB, Logs)
• Developed Excel/SSRS/PowerBI based reports hitting OLAP/SQL with Slicing and Dicing functionalities.
• Performance tuning of both SQL and cube.
• Designing the Architecture for ETL, Cube and Reports development based on Business requirement.
• Developed stored procedures, calculated members, perspectives based on the user’s requirements.
• Developed SSIS packages to pull the data from different sources and involved in the ETL processes. (Source: DB, Logs)
• Create detail design, work on development and perform code reviews.
• Developed Power BI reports that provided advanced slice and dice functionality to meet the unique information requirements of different users.
• Developed a tabular model to improve user query response time, and created multiple perspectives, hierarchies, attributes and KPIs to provide flexibility in tabular usage.
• Created multiple dimensions, perspectives, hierarchies, and dynamic measures (DAX) to analyze performances of each KPI.
• Primarily worked on producing Monthly and Daily reports in Power BI.
• Involved in the Unit testing, Quality Assurance testing and User Approval testing of Power BI reports and modifying the code accordingly to match user’s business requirements.
• Created Tabular Models as a source to Power BI dashboards and scheduled jobs to refresh it in a timely manner.
• Made changes to the existing Power BI Dashboard on a regular basis as per requests from Business.

Technologies: SQL Server: Analysis Services, Reporting Services, Integration Services,, Tabular, Power BI,ADLA,ADLS, USQL,AZURE.

Confidential

Senior Technical Lead

Responsibilities:

• Designing the Architecture for ETL, Cube and Reports development based on Business requirement.
• Developed Power BI reports that provided advanced slice and dice functionality to meet the unique information requirements of different users.
• Developed a tabular model to improve user query response time, and created multiple perspectives,hierarchies, attributes and KPIs to provide flexibility in tabular usage.
• Developed stored procedures, calculated members, perspectives based on the user’s requirements.
• Developed SSIS packages to pull the data from different sources and involved in the ETL processes.(Source: DB, Logs)
• Developed Excel/SSRS/PowerBI based reports hitting OLAP/SQL with Slicing and Dicing functionalities.
• Performance tuning of both SQL and cube.
• Assess existing and available data warehousing technologies and methods to ensure our Data warehouse/BI architecture meets the needs of the business unit and enterprise and allows for business growth. Provide recommendations on evolution of the architecture.
• Research, define and deploy BI improvement opportunities and streamline the business intelligence processes
• Create detail design, work on development and perform code reviews.
• Analysis & implementation of better performance strategies.
• Generating the release impact reports for major releases so that the business can be compared easily and can make out decisions for the better performance.
• Developed Tabular Model infrastructure in SSAS for various Lines of Business and created over different interactive Dashboards using various visualizations in Power BI Desktop.
• Created multiple dimensions, perspectives, hierarchies, and dynamic measures (DAX) to analyze performances of each KPI.
• Primarily worked on producing Monthly and Daily reports in Power BI.
• Involved in the Unit testing, Quality Assurance testing and User Approval testing of Power BI reports and modifying the code accordingly to match user’s business requirements.
• Created Tabular Models as a source to Power BI dashboards and scheduled jobs to refresh it in a timely manner.
• Made changes to the existing Power BI Dashboard on a regular basis as per requests from Business.

Technologies: SQL Server: Analysis Services, Reporting Services, Integration Services, PowerBI

Confidential

Specialist Data warehouse

Responsibilities:

• Designing and developing SSIS packages for the ETL loads
• Design and create SSRS/Excel reports pointing to SQL/OLAP with slicing and dicing functionalities.
• Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Analysis & implementation of better performance strategies.
• Generating the release impact reports for major releases so that the business can be compared easily and can make out decisions for the better performance.
• Involved in logical and physical data modeling, database design, star schema, data analysis.
• Experience in SSIS ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Created new database objects like stored procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008/2012.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code.

Technologies: Analysis Services, Reporting Services, Integration Services, SQL, SSAS/MDX, SSIS, Excel 2010, C#.Net

Confidential

Software Engineer

Responsibilities:

• Designing the Architecture for ETL, Cube and Reports development based on Business requirement.
• Developed stored procedures, calculated members, perspectives based on the user’s requirements.
• Developed SSIS packages to pull the data from different sources and involved in the ETL processes.
• Implemented Actions, Dynamic Security while reporting data w.r.t Geography dimension.
• Developed Excel/SSRS based reports hitting OLAP/SQL with Slicing and Dicing functionalities.
• Performance tuning of both SQL and cube.
• Assess existing and available data warehousing technologies and methods to ensure our Data warehouse/BI architecture meets the needs of the business unit and enterprise and allows for business growth. Provide recommendations on evolution of the architecture.
• Research, define and deploy BI improvement opportunities and streamline the business intelligence processes
• Create detail design, work on development and perform code reviews.
• Analysis & implementation of better performance strategies.

Technologies: SQL, SSAS/MDX, SSIS,SSRS, Excel 2010, C#.Net

Confidential

Software Engineer

Responsibilities:

• Designed the Architecture (introducing new dimensions, measure groups, databases, partitions etc.) based on Business requirement.
• Designed and implemented ETL and Cube for Data Warehouse (Creating KPIs, Calculated Members, Dimensions, Dimension Relationships, Creating Partitions, Building MDX queries to test the data)
• Implemented business logic (Creating KPIs, Calculated Members) while developing stored procedures.
• Created Analytical Reports in Excel which are the key for business improvement by giving the ability to slice and dice the data for the field based professionals and other vendors.
• Developed different types of Tabular Reports, Matrix Reports (Cross Tab or Pivot) Reports, Chart and Graphs, Reports that aggregate data, Reports containing parameters and group, Reports containing Totals and Subtotals, Drill-down reports and ad-hoc reports using SQLServer2008 Reporting Services.
• Strong knowledge in performance tuning of both SQL and cube.
• Design and implementing Scorecards and Dashboards.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Writing VBA code in Excel for Macros.
• Unit testing business logic against other modules.
• Involved in Project Design Documentation.

Technologies: Sql Server 2008, SSAS, SSIS, SSRS, Silverlight with Telerik controls, Visual Studio 2010 and Sharepoint 2010