SUMMARY

• 11+ years of progressive experience in Microsoft BI full stack - SSIS/SSAS/SSRS/Power BI Development, optimization, implementation, maintenance and testing.
• Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and Leadership team
• Developed various Power BI Dashboards that depicts critical KPIs as Global Booking, Backlog and revenue Summary, Weekly Revenue, WTD and Cumulative QTD data CY Vs PY Booking by Geography, Sales and Gross Margin along with Slicers, Filters and Search Options
• Developed Opportunity tracker to identify top 10 won/lost opportunities by all region and customers for sales and operation department
• Extensive working knowledge in various phases of SDLC such as system analysis, design, development, testing and implementation of projects and capable of handling responsibilities independently as well as a proactive team.
• Knowledge in Kimball Data warehousing concepts and Experienced in data warehouse database design and package development.
• Expert in T-SQL, Indexes, Stored Procedures, Views and User Defined Functions with error handling try/catch blocks for SSIS packages and SSRS reports.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, For each loop container, Data profiling and FTP, SCD, Script task, Conditional Split, Lookup, Aggregator, Multicast and Derived Column, from multiple source systems (Oracle, DB2) with Full / delta load.
• Managed complete development of CUBE from requirement gathering, database design and modeling in STAR schema, ETL development for both staging and data warehouse.
• Developed complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs and worked in SSAS storage, partitions, Aggregations and calculation of queries with MDX,
• Extensively used SSRS to convert business requirements into various type of reports such as drill down reports, sub reports and linked reports. Managed SSR report subscription and security
• Performed Query optimization & Performance Tuning in complex SQL Queries, Stored Procedures, ETL and Reports.
• Performance Tuning: Hands-on experience on T-SQL script reviews, analyzing Query plans for stored procedure optimizations.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.
• Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.

TECHNICAL SKILLS

Relational Databases: SQL Server 2012/08/2005 , Oracle 9i

ETL Tools: SQL SSIS 2012/08/2005 , Power BI (Power Query, Power View, Power Pivot)

Reporting Tools: SQL Reporting services 2012

Analytic Tool: SSAS 2012/08

Schedulers: SQL Server Agent

Version Control / Defects Tool: Team Foundation Server (TFS)

Languages: T-SQL,PL/SQL

GUI Tools / IDE: SQL Server Management Studio, SQL Server Business Intelligence Development Studio, MS SQL Enterprise Manager, SQL Server Profiler, Visual Studio 2008/2012, Redgate SQL compare, SQL Data compare, SQL monitor, SQL Server Mobile Report Publisher

Project Mgt. Tools: Microsoft Project and Microsoft Office Suite (Office/OneNote)

Software/Utilities: ODBC, FTP, SFTP, MS Office 07/10/13

Operating Systems: Windows 2010/2008/2007 and UNIX

PROFESSIONAL EXPERIENCE

BI Reporting Analyst/Power BI

Confidential

Environment: SQL2012, SSIS/SSAS/SSRS 2012, SSRS 2016, Power BI, Power View, IFS (Oracle based ERP system)

Responsibilities:

• Worked with Leadership team in various Power BI reports such as On Time delivery reports by promised date /Wanted date, Market Expectation, Weekly/MTD/YOY Revenue,Booking and Backlog summary report, Customer service reports
• Developed Power BI dashboards as Booking YOY comparison by Region/Product/Customer Group, QTD Comparison for Finance Team
• Responsible for monthly currency rate upload, Month End Power pivot file refresh, creation of various power pivot tabs, data validation and distribution of file to Executive management team.
• Weekly and Daily Revenue Comparison charts (Line and Bar) charts created for Current Year VS Previous Year.
• Various chart options of Power BI charts like stacked bar chart, Pie chart, Multirow cards, Matrix and Maps, etc are used in Revenue, Margin and Booking dashboards
• Developed SSRS reports for New Product Development Vitality Metrix and CAPA (Corrective And Preventive Action) for Sales and Service Department
• Developed complex SQL Stored procedures and functions which are widely used in SSRS reports
• Involved in Data migration Projects and converted crystal reports into SSRS
• Developed SSIS packages for Staging and Data warehouse database and ran them for different regions
• Maintained customized BI data such as customer groups, product segments, regions, territory, target revenue data for 3P, Intercompany and Service
• Responsible for bringing data from Servicemax to BI using SSIS packages
• Created heat maps using Maptive for Annual Regional Sales and Bookings.
• Extensively used different type of Power BI charts as Line and stacked column chart, scattered chart, pie chart, card, multirow card, slicers and filters.
• Drill through dashboards created to drill down from yearly to quarterly and monthly.
• Developed customer measures as Last year vs Current year, MTD values, Gross margin, Margin %, using DAX queries

BI Reporting analyst

Confidential

Environment: SSIS/SSAS/SSRS 2016, SQL Server Mobile Report Publisher, Microsoft Visual Studio, TFS

Responsibilities:

• Created various ad-hoc SQL queries for customer reports, executive management reports and types of report types like tables, matrix, sub reports etc.
• Incident Management System (IMS) dashboard has been created using SQL Server Mobile Report Publisher Which includes case summary, case by month, Previous year Vs current year comparison, Case by category. All dashboards are linked to SSR report to see details.
• Employee certification Report - Drill down SSRS reports are created for managers who can see list of completed /pending certificates of their team people.
• Operation Performance Review - SSRS reports are created with combination of List and tables/charts. List is used to loop thro the set of tables and charts using header names for different measures like current year revenue, previous year revenue, Variance and Variance percentage. Customer formatting expression has been used for numeric, percentage and decimal values inside the loop

BI SQL Developer

Confidential

Environment: SSIS/SSAS/SSRS 2012, Red gate SQL compare, SQL data compare and SQL monitorMicrosoft Visual Studio, TFS

Responsibilities:

• Responsible for BULK INSERT of raw files (29 zip files, 300 raw files) data from MSP (Mortgage Service Provider) to company data warehouses (DW).
• Bulk loading of document images, loan comments and pay histories to PROD environment.
• Involved in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.
• Designed ETL packages dealing with different data sources (Oracle, SQL Server, and Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Responsible for coding SSIS processes to import data into the Data Warehouse from Flat Files and OLEDB Sources.
• Implemented SSAS Cubes, Facts and Dimension tables to perform analysis. Designed Cube partitioning and incremental synchronization for SSAS cubes.
• Creating Ad Hoc and parameterized various Reports using SQL server 2012 Reporting Services.
• Created various ad-hoc SQL queries for customer reports, executive management reports and types of report types like tables, matrix, sub reports etc.
• Worked on various tasks and transformations like Execute SQL Task, Execute Package Task and conditional split, Script Component, Merge and Lookup while loading the data into Destination.