SUMMARY:

• Highly qualified MS BI consultant with over 5+ years of experience in implementing end - to-end solutions using the Microsoft BI Stack (TSQL, SSIS, SSRS) in multiple industries including Retail, Supply-chain and Health Insurance.
• Well versed in all aspects of Data Warehousing from Requirements Clarification to Data Modeling and Design, Data Profiling and Cleansing as well as setting up Data Migration and Integration.
• Extensively worked on both OLTP Relational Schema with Normalization and OLAP Dimensional Modeling using Star and Snowflake schema.
• Hands-on experience with Erwin for data modeling.
• Expertise in importing data from various sources including database, Excel and Flat file using BCP, Bulk Insert & SSIS package.
• Experience using various transformations such as Slowly Changing Dimensions, Derived columns, Aggregate, Lookup, Fuzzy Lookup, Conditional Split, Derived Column, and Multicast in Data Flow Tasks.
• Developed complex SSIS Packages using Data Flow Tasks, Execute Sql Task, Execute Package Tasks as well as For Each and Sequence Container with parameterized Connection Managers.
• Proficient in writing and maintaining SQL Stored Procedures, Views, Functions, Indexes, Triggers following best practice principles.
• Strong Skills in Optimizing T-SQL Scripts and Stored Procedures by analyzing Execution Plans as well as using Microsoft Tools such as SQL Profiler and Database Tuning Advisor.
• Highly skilled in building complex queries using Common Table Expressions (CTE), correlated sub-queries, queries with complex joins and aggregate functions as well as Dynamic SQL.
• Created partitions on tables, indexes and indexed views as well as querying and managing partitions from optimization point-of-view according to the business criteria.
• Experience creating Parameterized Reports, Drill Down, linked, sub cascading Reports and Reports using SQL Server Reporting Services (SSRS).
• Proficient in using Report Manager for setting up roles, security on the reports and creating Standard and Data Driven Subscriptions in Delivery of Reports.
• Well-versed in the Software Development Life Cycle (SDLC) using both Waterfall and Agile/Scrum methodologies.

TECHNICAL SKILLS:

Database Tools: Management Studio, ER-Win, MS Visio

RDBMS: MS SQL 2008 R2/2012, 2014

Business Intelligence: BIDS/SSDT, SSIS, SSAS, SSRS

Operating Systems: Windows Server 2008/R2, 7/8

PROFESSIONAL EXPERIENCE:

Confidential, Diamond Bar, CA

ETL/Reports Developer

Responsibilities:

• Worked closely with business stakeholders to clarify requirements for data transformations as well as strategies for cleansing data anomalies.
• Managed existing ETL strategy to extract, clean and deliver data to OLAP environment, ensuring accuracy, consistency and integrity of the data warehouse.
• Created and deployed SSIS packages using various Transformations such as Look up, Grouping, Aggregate and Derived Column Transformations.
• Created complex SSIS packages to pull data from OLTP database, Excel, flat files to Data Warehouse.
• Designed SSIS package templates as base code for package development incorporating package configurations, parameterized connection managers and custom error logging.
• Implemented the Master-Child Package Model for easier maintenance and better performance of the ETL process.
• Created and maintained database objects such as Stored Procedures, User Defined Functions, Triggers and Indexes using T-SQL.
• Modified database structures as requested by developers for Test and Develop environments and assisted junior developers with design, development, code review and performance tuning.
• Responsible for ensuring timely code deployment and sanity checks in test and production environments prior to QA hand-off.
• Analyzed queries for Optimization and Performance Tuning using SQL Profiler and Database Tuning Advisor.
• Followed the regular reporting life cycle analysis, design, development, testing and scheduling to develop Business facing Reports.
• Designed and deployed reports with Drill Down, Drill Through and Drop Down menu option as well as Parameterized and Linked reports.
• Delivered on-demand and scheduled reports for business analysis and management decisions using SQL Server Reporting Services.
• Scheduled Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including status.

Environment: MS SQL Server 2012/2014, SSIS, SSRS, Erwin, Excel, Windows Server, Flat Files, Team Foundation Server (TFS), Jira (Atlassian)

Confidential, California

El Segundo, CA BI/Reports Developer

Responsibilities:

• Created Stored Procedures, user-defined functions, views for handling business logic and functionality in reports.
• Generated sub-reports, drill-down reports, drill-through reports and parameterized reports to provide visible data for data analysts and business using SSRS
• Used Slowly Changing Dimension Transform in data flow tasks for maintaining historical data in data warehouse.
• Utilized temporary tables and indexed views enabling faster retrieval of the data when running SSRS Reports
• Involved in applying data conversion and transformations to cleanse the legacy database to support for annual decisions
• Created mapping between legacy tables and current tables in the database based on data dictionaries provided by SME.
• Developed new ETL processes for transforming and adding new attributes to the data warehouse from the OLTP system for use in SSRS Reports.
• Maintained SSIS packages for extracting data from different sources and scheduled daily loads to refresh data in the centralized data warehouse. Used environment variables to make the package configuration dynamic.

Environment: MS SQL Server 2012, SSIS, SSAS, SSRS, Excel, Windows server, Power Pivot, TFS.

Confidential, Fontana, CA

ETL Developer

Responsibilities:

• Responsible for analyzing various dimensions and facts that could be included in Data Warehouse design using best suited Star-Schema and created logical and physical model of the Warehouse in ER-Win.
• Played key role in identifying sources, creating staging database, and elements of data warehouse (Fact and Dimension Tables).
• Managed the entire ETL process for the migration into from transactional database into data marts involving the profiling, analysis, extraction, cleansing, transformation and load.
• Implemented both an initial Bulk Load and Incremental Loading strategy for the Data Warehouse.
• Created packages with several business rule validations ensuring that high quality data is sent to the destination.
• Created complex SSIS packages to pull data from Excel and flat files to SQL server
• Created staging database to perform various ETL data massaging operations such as data profiling, data cleansing and data verification.
• Developed complex mappings using SSIS to transform and load the data from various source systems like Excel, Flat files, Oracle into the SQL Server database.
• Designed and deployed SSIS packages using various Transformations such as Multicast, Merge Join, Lookup, Fuzzy Lookup, Fuzzy Grouping, Slowly Changing Dimensions, Aggregate, Conditional Split, and Derived Column Transformations.
• Implemented master child packages so only the Master package has to be scheduled which will in turn fire the other packages.
• Implemented various different SSIS features like logging, checkpoints breakpoints, deployment, and configuration based on designed end-to-end ETL strategy

Environment: MS SQL Server 2008 R2/2012, SSIS, Excel, Windows Server, Power Pivot, TFS.