PROFESSIONAL SUMMARY:

• 7+ years of IT experience in BI - ETL & Reporting with a passion for leveraging data and a proven history of building large-scale data processing systems and serving as an expert in data warehousing solutions while working with a variety of database technologies.
• Microsoft Certified Technology Specialist involved in BI & ETL implementation for OLTP & Data Warehousing environments.
• Designed ETL strategy and architecture of the project with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Comprehensive understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Facilitated data requirement meetings with business and technical stakeholders and resolved conflicts to drive decisions in various stages of SDLC and approaches like Waterfall, Agile models.
• Involved in developing Stored Procedures, Functions, Views, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL, complex dashboard reports, KPI's, Business views charts.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement.
• Possess extensive knowledge and Expertise in ETL, Report & Database Design, Data Modeling, Development, Analytical Reports and Automated Dashboards helping users to identify critical KPIs and facilitate strategic planning in the organization.
• Expertise in designing complex reports using cascading parameters, drill-through reports, parameterized reports, sub reports & ad-hoc reports using SQL Server Reporting Services.
• Worked on process improvement, data cleansing, data profiling and maintained data governance.
• Experienced in optimizing performance in relational and dimensional database environments by making proper use of Indexes and Partitioning techniques.
• Excellent verbal and written skills and ability to document based on target audience.

TECHNICAL SKILLS:

Data Modeling Tools: ER Studio, Rational Software Architect, Erwin

Database Tools: Microsoft SQL Server, Oracle

ETL Tools: Microsoft SSIS, Informatica

Reporting: Tableau, Microsoft SSRS, PerformancePoint Services, Power BI

Business Intelligence: SQL Server Analysis Services

Business Applications: Microsoft Office Suite, Visio

Operating Systems: Microsoft Windows and UNIX

WORK HISTORY:

Data Analytics Lead

Confidential, Redwood City, CA

Tools: /Environment: SSIS, SQL Server, ER Studio, Erwin, Tableau, Power BI, Microsoft Azure

Responsibilities:

• Responsible for BI Enterprise data warehousing ETL architecture, design and development
• Studied in-house requirements for the Data warehouse to be developed
• Conducted one-on-one sessions with business users to gather data warehouse requirements Analyzed database requirements in detail with the project stakeholders by conducting Joint Requirements Development sessions
• Create/ implement operational data store(ODS) and Enterprise data warehouse (EDW) in Microsoft SQL server, design and ETL Strategy to Build, Develop and Load Data from Salesforce, NetSuite, and other various OLTP Source Systems.
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy DB2 and SQL Server database systems Extracted data from the databases using SSIS to load it into a single data warehouse repository.
• Design and develop various application specific Tableau/SSRS/Power BI reports for multiple Business Units like Finance, Executive, Commercial operations, Lab Operations etc.
• Created POC s to migrate data into Microsoft Azure cloud, build Tableau /Power BI reports on top of it.
• Integrated the work tasks with relevant teams for smooth transition from testing to implementation.

Technology Lead - Senior DW/BI Data Modeler

Confidential

Tools: SSIS, SQL Server, ER Studio, ER-Win, Oracle, Tableau, Power BI

Responsibilities:

• Played the role of a Program Technical Lead/ETL Architect and was responsible for Data Integration from source systems into Operational Data Store-ODS to Data warehouse.
• Facilitated JAD sessions for requirements gathering, creating data mapping documents, writing functional specifications and acted as a liaison between the business and development teams.
• Analyze Different Data Sources like SQL Server, Oracle and Flat files and involved in the data profiling activities for the column assessment and natural key study.
• Developed Conceptual/Logical/ Physical Data Models, Data Dictionary using EMBARCADERO ER Studio tool for integration of business rules into database tables, normalization and de-normalization for optimization and established referential integrity of the system.
• Worked in Agile Scrum methodology and optimized performance in relational and dimensional database environments by making proper use of indexes and partitioning techniques.
• Involved in ETL code to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures.
• Worked on POC for developing Tableau Dashboards for performance and KPI's of location.
• Tuning complex queries for better performance/efficiency and to meet business requirements.

Technology Analyst - DW/BI Data Modeler

Confidential

Tools: /Environment: T-SQL, PL/SQL, SQL Profiler, Report Builder, SSIS, SSRS, Rational Software Architect, ER Studio

Responsibilities:

• Gathered Business requirements by organizing and managing meetings with business stake holders, development teams and analysts on a scheduled basis.
• Designed the data flow from source systems to SQL server tables, technical specification documents for ETL processing into the data warehouse using Rational Software Architect.
• Normalized the incoming files to 3NF before loading into facts and dimension tables.
• Conducted design reviews with BA/content developers to create POC for reports.
• Created database objects - configuration tables, indexes, views, stored procedures and user defined functions in SQL Server Management Studio to support SSIS process workflow.
• Involved in maintaining and improving ETL processing efficiency for improved data quality, impact analysis and data validation.
• Configured with checkpoints, audits, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.
• Worked closely with the application developers to explain the database design and the complex Data Transformation logic.

Senior Systems Engineer - Senior BI/ETL Engineer/Analyst

Confidential

Tools: /Environment: SSIS, SSAS, SSRS 2008R2, Informatica, PPS 2010, Cognos

Responsibilities:

• Gathered and analyzed business requirements through continuous discussions with the business analysts, data analysts, and performed GAP analysis of the business rules, user administration and requirements in agile scrum project methodology.
• Designed the ETL framework from scratch with multiple data sources (Flat File, Excel, Oracle and SQL) and designed reporting solutions.
• Designed and developed complex packages, mappings to move data from multiple sources into target area such as Data Marts and Data Warehouse in SSIS & Informatica.
• Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models Involved in complete Software development life cycle SDLC of the project including Analysis, design, develop, deployment, test, implement and production.
• Wrote SQL Queries, SQL Stored Procedures, Views, Functions as needed.
• Experienced in writing Parameterized Queries for generating Tabular reports, Sub reports using Global Variables, Expressions, Functions and subtotals for the reports using SSRS.
• Involved in designing, building of OLAP cubes with SSAS 2008(R2) Identified and defined Fact relationships in SSAS
• Coordinated cross-functional strategic business teams focused on improving product quality.

Systems Engineer - Data Warehouse Engineer

Confidential

Tools: Informatica, SQL Server, UNIX platform, IBM TWS, MS-BI (SSIS & SSRS)

Responsibilities:

• Member of the warehouse design team assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Performed Data analysis, data migration by transferring them using SSIS packages.
• Developed mappings in Informatica and Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Update strategy, Sequence generator and SP.
• Performance & Tuning of Existing Mappings and Workflows in Informatica.
• Performed efficient tuning of SQL source queries for data load and used stored procedures.
• Created Parameterized, Drill down and Drill through reports, cross tab reports, Sub Reports, Summary Reports and charts using variables and expressions.
• Resolved data issues, answered user queries data issues and assisted the QA team in designing the test plan and test cases.
• Performed User Acceptance Testing.