SUMMARY

• Microsoft Certified Solution Associate with around 7+ years of extensive experience in complete Software Development Life Cycle (SDLC) including System Requirements Collection, Architecture, Analysis, Design, Development, Testing, Maintenance and Enhancement in variety of technological platforms with special emphasis on ETL/Data Warehouse and Business Intelligence applications. Strong Consulting experience in Implementing Full Life Cycle Data Warehousing and Reporting Projects.
• Around 5 years of experience in Microsoft Business Intelligence (BI) stack including SQL Server 2012/2014/2016 , Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS).
• Around 2 years of ETL development experience in IBM Datstage and Oracle Data Integrator (ODI).
• Hands - on experience of around 3 years with data visualizing tools like Power BI and Tableau. Published reports using Power BI service and Tableau desktop. Sent automatic email notifications and attachments to business users with daily and weekly schedules. Created tabular model by importing data and created maps, graphs, charts and matrices.
• Good knowledge of Cloud Data Warehouse, Big Data and Data Science tools including R, Python, Hadoop, Hive, SQL Azure Data Warehouse/Data Lake/Blob Storage and AWS Redshift.
• Strong Data Modeling experience using ER diagram, Dimensional data modeling, Star Schema modeling, Snow-flake modeling using tools like ERwin, ER/Studio.
• In-depth knowledge and work experience of over 5 years in ETL, OLTP, OLAP Cubes, BI Reports and Dashboards.
• Highly proficient in SQL, PL/SQL and T-SQL Query writing skillsets (Query optimization, ETL Scripts, Performance tuning, Procedures and Packages etc.).
• Successfully implemented complex ETL systems and Data Warehouses from scrap (using SSIS, SSAS tabular) within tight three-month timeline.
• Earned a praise from management by increasing cost savings of up to 10%.
• Deeper understanding of business world including management sciences, leadership skills, marketing and financial analysis i.e. Balance sheet, Income statement, cash flows, working capital etc.

TECHNICAL SKILLS

• SQL Server 2012/2014/2016
• SSIS
• SSAS
• SSRS
• Oracle 10g/11g
• OBIEE
• IBM Datastage
• Oracle Data Integrator (ODI)
• Toad
• PL/SQL Developer
• Teradata Express
• Change Data Capture
• Master Data Management (MDM)
• Operational Data Store (ODS).
• Power BI (Desktop & Service) - 3 years
• Tableau (Desktop & Server) - 2 years
• Power Pivot
• Power View & Power Query & Crystal Reports.
• SQL Azure DWH
• Azure Data Lake
• Azure Blob Storage using SSIS Feature Pack for Azure (2016)
• AWS Redshift.
• PL/SQL Package writing
• Stored Procedures
• Query Optimization
• Normalization
• D- Normalization
• Materialized/indexed Views
• Performance Tuning
• Analytical Functions. Strong understanding of Bill Inmon vs Ralph Kimball methodologies data warehousing concepts slowly changing dimensions
• OLTP
• OLAP
• Star and Snow Flake data models. .Net C#
• Python 3.4
• SQL
• T-SQL
• DAX & MDX
• Unix/Linux.
• Agile/Scrum
• TFS
• JIRA
• Basecamp
• MS Project Server 2016.
• ERwin
• ER/Studio
• MS Visio.

PROFESSIONAL EXPERIENCE

Confidential, Houston, Texas

ETL/DWH & BI Developer

Responsibilities:

• Lead the implementation of existing Microsoft SQL Server Reporting Services Reports and Dashboards. Achieved this by creating the data warehouse (data marts).
• Performed Data Analysis of existing databases (100+ tables) through T-SQL/SQL.
• Data architecture - designed relational data marts for both of their transactional databases.
• Designed and implemented a single data integration architecture for data marts using SSIS and SQL Server 2012.
• Designed and implemented overall architecture, database objects, surrogated keys, lookups & transformation; incremental extract, incremental process and load.
• Worked on system and user acceptance testing. Created unit test plans and executed them in development environment.
• Deployed SSRS Reports and SSIS packages into development environment. Completed the testing with the business users.
• Created production deployment script and worked with DBA for the deployment of SSRS Reports and SSIS packages into production.
• Provide end-user support for assigned applications (includes some on-call support during non-business hours).
• Also created dashboards and reports using MS Power BI.
• Created different user roles for sharing of dashboards and implemented row-level security for reports.
• Created documentation for the technical design of the data warehouse.

Technical Summary: SQL Server 2012/2016, Power BI, SSRS, SSIS, TFS, T-SQL, MS Visio, DAX & MDX.

Confidential, Milwaukee, Wisconsin

Senior BI Consultant Manufacturing and Sales

Responsibilities:

• Worked with Business Team (End Users) and gathered all the BI Reports requirements for three different domains: Sales, Services and Warranty.
• Design and developed Data Warehouse for Sales, Services and Warranty Reports.
• Created dimensional model for the reporting system by identifying required dimensions and facts using ERwin r7.1.
• Created Tables, Views and Stored Procedures which were used in SSIS package to load data into data warehouse.
• Automated data load process and cube processing by creating SQL Job and run it on daily schedule.
• Design and developed Sales and Services Multidimensional Cube using SSAS.
• Design and developed complex BI Reports for business needs of Sales, Services and Warranty.
• Used Power BI, Power Pivot and JET Reports (Excel Reporting) Tools for creating these BI Reports.
• Performed installation, configuration and integration of Power BI and Office 365 environment.
• Worked with development team in integrating Power BI visuals in in-house application using Power BI embedded.
• Maintained the release management, maintenance, troubleshooting and performance tuning of Power BI.
• Wrote complex SQL Scripts, DAX and MDX queries to fulfill these reporting needs.
• Created Calculated Measures and Calculated fields in the SSAS Cubes and Power BI/Pivot Reports.
• Used JET Reports Excel Functions to create several BI Excel Reports for Service Domain.
• Scheduled several Power BI Reports using Power BI service. This includes automatic emails notifications and attachments to business users with daily and weekly schedules.
• Design and developed SSIS packages for Service and Warranty DWH Dimensional and Facts Tables ETL.

Technical Summary: ERwin, OBIEE, Oracle 11g, SQL Server 2016, Power BI, Power Pivot Reports, SSAS, SSIS, TFS, T-SQL, DAX & MDX.

Confidential, Chicago, IL

BI & DWH Developer

Responsibilities:

• Involved in database model design development for RFRS (Retail Financial Reporting System)
• Developed and defined RFRS database objects (Table, Keys, Datatypes, indexes) in SQL server for RFRS.
• Developed data integrity rules for source data to process data properly with error handling architecture
• Developed normalized Logical and Physical database models for insurance data using ER/Studio.
• Developed business accounting rules according to requirements using stored procedures.
• Developed SSIS package for Automation and ETL process.
• Extracted data from XML and HTML files using Python code and imported it into SQL Server tables.
• Developed Major source files for real data experience to test RFRS data integrity and accounting rules execution and verification.
• Involved with business in reports requirements verification and design for multiple SSRS reports.
• Designed and developed RFRS financial reports in SSRS and deployed on SSRS server.
• Designed and developed a Power Pivot model for RFRS and then imported BI semantic model into SSAS Tabular cube.
• Created Ad-hoc reports as per user requirements using SSAS Tabular cube as a data source.
• Used Tableau for reporting and dashboard.
• Involved in Load and Performance tuning process while implementation of multiple performance tuning techniques for complete RFRS end to end processing.

Technical Summary: ER/Studio, Oracle 11g, SQL Server 2014, T-SQL, Python, JIRA, Power Pivot, SSAS, SSRS, Tableau, DAX & MDX.

Confidential, Houston, Texas

BI & DWH Developer

Responsibilities:

• Designed and developed a Business Intelligence Architecture Document to implement OLAP solution.
• Created Dimensional Model (Star/Snowflake Schema) according to the requirements specifications.
• Created a data warehouse based on the Dimensional Model.
• Created ETL scripts using T-SQL queries, Views, Stored procedures and functions.
• Created Dimensional Tables and views on SQL Server 2014 for data warehouse.
• Developed SSIS packages to Extract, Transform and Load data from staging database to data warehouse.
• Implemented change tracking on database tables to keep track of incremental data changes and moved incremental data to data warehouse periodically.
• Used Lookup Transformation in SSIS packages to implement Slowly Changing Dimensions (SCD) to move incremental data in dimension tables.
• Developed SSAS multidimensional cubes using the data warehouse.
• Designed Measures to Count, Sum and Roll up average on Parameter, Asset and Notification values.
• Used attribute relationships to define hierarchies in dimensions.
• Created complex data sets using MDX and T-SQL queries to load data into report regions and parameters
• Created SQL Agent Jobs to process cubes periodically with XMLA scripts.
• Designed and developed parameterized and non-parameterized reports in SSRS. The reports consist of tables, charts and KPIs.
• Created SSAS Tabular models for Ad-hoc reports.
• Implemented DAX expressions in the Tabular Models for complex members, KPIs and calculations.
• Created Ad hoc reports for equipment and notification reports using Power BI. Used SSAS tabular models at backend for data models and power view/power map for visualization (tables, score cards, charts)
• Generated reports using SSRS for output in Excel, PDF and CSV formats.

Technical Summary: Oracle 10g, ERwin, Power Pivot, SQL Server 2014, SSIS, SSAS, Power BI, DAX, MDX & T-SQL.

Confidential, Gardena, CA

BI/DWH Developer E-Commerce

Responsibilities:

• As part of the team, I was involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects. Capable of handling responsibilities independently as well as a proactive team member.
• Designed ETL data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS.
• Developed complex store procedures, efficient triggers, required functions, creating indexes and indexed views for better performance.
• Worked on monitoring SQL Server Performance tuning in SQL Server 2000/2005 /2008 using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor.
• Worked on Database Backup, Recovery and Disaster Recovery procedures.
• Designed and developed interactive dashboards in SSRS.
• Developed SSRS reports with multiple filters as well as parameters and deployed SSRS reports.
• Diagnose and fix issues reported in Development and Production environment.

Technical Summary: SQL Server 2012, TFS, T-SQL, SSIS, SSAS, SSRS.

Confidential

SQL Reporting and ETL Analyst

Responsibilities:

• Understanding business needs, gathering and defining detailed requirements that serve the business requirements with attention to details and translating them to technical specifications.
• Responsible for running complete release cycle for the development of reports
• Assisted CFT in creating reports to generate them through Email for the administrative using MDX queries.
• Promoted the use of Microsoft Power BI, JET Reporting for better analysis of customer data
• Designed and developed an ELT strategy to load data from source files to staging database and then populated the data warehouse.
• SSIS packages are designed, developed and deployed according to ELT flow (Extract, Load and then Transform).
• Specifically involved in preparation of staging database preparation according to requirements as well as ELT flow designing, development and deployment through SSIS packages and TSQL stored procedures.
• Worked closely with business analyst and business users to understand requirements and datasets mapping for ELT flow.
• Assist in the analysis of business requirements and processes to identify workflow changes necessary to ensure data integrity for reporting and analytics purposes
• Contribute to coordination of data mapping, testing and validation
• Designed and developed views, stored procedures and SSIS packages to load data into data warehouse.

Technical Summary: SQL Server 2012, TSQL, Power Pivot, C#.

Confidential

MTO - BI/Data Warehouse Reporting

Responsibilities:

• Worked on Data Extraction, Transformation and Loading (ETL) between homogenous and heterogeneous systems using DTS and SSIS of MS SQL Server 2005.
• Developed MS SQL Server Analysis Services 2005 (SSAS) cubes, data mining models, deploying and processing SSAS objects, and writing MDX queries.
• Worked on the performance and maintenance of DWH/BI daily batch operations of Confidential .
• Designed and developed an end to end data warehousing and OLAP solution using SSIS, SSAS, SSRS, and SQL Server.
• Used multiple data visualization tools including Jet Reporting, Power Pivot and Power View as well as SSRS reports.
• Worked closely with business users to understand requirements for designing data warehouse.
• Designed and developed Dimensions and Facts tables as per the requirements.
• Designed and developed views, stored procedures and SSIS packages to load data into data warehouse.
• Implemented table partitioning and indexing strategy on fact tables.
• Diagnose and fix issues reported in Development and Production environment.
• Developed complex reports in SSRS with multiple regions and multiple data sets.
• Designed dashboards, score cards by collecting data through SSIS and worked on creating cubes & Reports.
• Also, responsible for ad-hoc reports development and customer behavioral analysis of data consumption through 3G and 4G.
• Requirements Gathering & Reporting: Implementation of Business Reports on Reporting Server Using SSRS, Analysis of databases using SQL Profiler and Query Execution Plan.
• Business Engagement: Promoted the use of Microsoft Business Intelligence (BI) tools and concepts across the organization. Worked with user community to understand business process challenges. Also, provided ad-hoc data reporting support to end users on following:
• MNP Analysis
• Customer Data Consumption and Behavioral Analysis
• Site Profitability Analysis
• Location Based Revenue
• Usage and Customer Analysis
• VAS Analysis
• Customer Churn Analysis
• Subscriber Activity and Dormancy Analysis

Technical Summary: OBIEE, Oracle 10g, PL/SQL Developer, TOAD, SQL Server 2012, SSIS, SSRS, T-SQL, Power Pivot, Power View.