SUMMARY

• Over 7+ years of Extensive IT/Database experience in SQL Server, Data Warehouse, Dimensional Modeling, SSIS/Informatica ETL Development, SSAS/Cube Development and SSRS/Tableau Report Development.
• Architecture, design, development of DW/BI solution for Enterprise Data Warehouse for education and health care industry
• Participated in all phases of SDLC, i.e., analysis, design, development, production, maintenance, and performance tuning
• Extensive knowledge of RDBMS concept, Dimensional Modeling using Kimball approach for Data mart and OLAP.
• Strong experience with T - SQL and PL/SQL in constructing tables, stored procedure, views, indexes, and complex SQL queries.
• Developed numerous complex ETL Packages using SSIS from various source systems and transformations.
• Experienced in SQL and SSIS optimization for peak performance.
• Strong experience in creating ad hoc and parameterized reports utilizing SQL SSRS 2005/2008.
• Created MOLAP Warehouse on SQL 2005 Server Analysis Services and produced multiple cubes from star schema utilizing dimension and fact tables.
• Optimized MOLAP cubes by partitioning, designing aggregations, implementing hierarchies and calculated members.
• Understanding of Scrum/Agile methodology, TFS 2013 and SDLC process.
• Performed different tasks of testing including manual testing, smoke testing, run for record, etc.
• Team player with excellent communication and problem solving skills.

TECHNICAL SKILLS

Languages: SQL, T-SQL, PL/SQL, VB.NET, HTML, PERL, PHP, JavaScript

Database: MS SQL Server 2005/2008R2/2014/2016, Oracle 10g, MySQL, MS Access-2003

Database Tools: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Informatica 9.0, ER-Win, Tableau, MS Test Manager 2010

Software: Visual Source Safe, MS Visio, MS Windows, Excel, PowerPoint and Outlook, TFS 2010/2012/2013 , Perforce

Operating Systems: Windows 7, Windows NT/2000/XP, UNIX

PROFESSIONAL EXPERIENCE

Confidential, San Diego, CA

Data Architect

Responsibilities:

• Serves as a senior technical member of the Data Analytics Team, guiding development and reporting discussion and decision.
• Responsible for the development of target data architecture, design principles, quality control and data standards for the organization.
• Ensures the integrity of the data warehouse, ensuring data flows and stores are controlled and correct, and the representation of data is accurate and consistent.
• Analysis health care data, business, relationship and fix the existing data warehouse for the matching encounters
• Prepare and present the entire Data Warehouse project’s high level architect and planning
• Worked with DBA/System engineer, provide drive specifications and implement the Data Warehouse servers
• Migrate SQL server 2014 data warehouse into SQL server 2016 which included data base objects and ETL packages
• Collect the technical business requirements and translate into Kimball dimensional modeling
• Architect/Design and implements logical and physical model design for the encounter data dimensional modeling using Visio
• Creates and manages Extract, Transform and Load (ETL) processes for data using various tools including Bulk insert and SSIS
• Creates ETL framework for the staging area as well for the final Data Warehouse area
• Creates complex ETL complex packages to load data for the dimensions and fact and to integrate data into multiples source system.

Confidential, San Diego, CA

Sr. BI Consultant / ETL Engineer

Responsibilities:

• Translated business requirement into technical specifications
• Developed stored procedure using MERGE to load/update data into Dimension, adding new columns, constraints, indexing into existing OLTP and data warehouse.
• Identified technical tasks, ETL data flow, unit test and creating all child tasks in the TFS for the given parent user story.
• Created complex ETL SSIS packages to extract data from SQL server OLTP to SQL Server DW.
• Successful run the build process using command window for every change made in SQL and ETL such as restore OLTP data base, run SQL data base/ETL build and then run the ETL, Report, Schema unit test.
• Performed data and schema comparison between different data base version and SQL OLTP /SQL DW schema and table relationship.
• Prepared ETL standards and wrote ETL flow for complex fact tables in DW and managed on the SharePoint site.
• Performed Unit Testing and tuned for better performance.
• Worked with SQE team to performed different tasks of testing including manual testing, smoke testing, run for record, etc.

Confidential, San Diego, CA

Sr. BI Engineer/ Data Architect

Responsibilities:

• Managed and created data mart and ETL processes for the Enterprise data warehouse.
• Gathered and analyzed business requirements, identified business processes, grains, dimensions, facts and further designed utilizing Kimball dimensional model star schema for various data marts.
• Create/design dimensional model using Visio diagram
• Created complex SSIS/ETL packages for staging, cleansing, integration and data warehouse load for the data mart from various sources like SQL Server, MySQL, Oracle, Flat files using transformations such as Kimball Slowly Changing Dimensions (SCD), lookups, and Task Factory upserts.
• Created package configurations to migrate packages from Dev to Prod and stored into Environment Variable for indirect configurations.
• Modified and created complex SQL queries, stored procedures and views using T-SQL in addition to table and index creations for optimal performance.
• Responsible for intraday lead activity load which collects current data every hour to fulfill reporting needs.
• Lead CRM integration project and worked successfully with Jr. ETL developers and provided ETL mapping/ data mart design and guidance to build efficient ETL processes and data marts.
• Helping migrating SQL Server 2008 to SQL Server 2014 and provide expertise as needed.
• Administered /Create Tableau report extracts and dash board for end-users.

Confidential, San Diego, CA

SQL SSRS Developer

Responsibilities:

• Responsible for rewriting external and internal reports and stored procedures to support a significant schema change in the source data.
• Analyzed/identified schema change within SQL queries and stored procedure for the reports.
• Converted SQL queries for the new schema change and modified stored procedures by passing multiple parameters using SQL Server 2008/2012.
• Created parameterized, drill down reports with multiple datasets in MS SQL environment using SSRS 2008.
• Optimized SQL queries by running SQL execution plan and applying appropriate indexing.
• Created SQL script and batch files that migrated sets of stored procedures from one database to another.

Confidential, San Diego, CA

Data Engineer

Responsibilities:

• Worked on business intelligence solution to support internal Navy infrastructure used for historical reporting.
• Created database objects such as stored procedures, views, and materialized views in Oracle 10g using PL/SQL.
• Designed staging database and data mart for data warehouse using Star Schema Dimensional Modeling Methodology.
• Created ETL wrapper using SSIS that calls various Oracle stored procedures and refreshes staging databases, updates dimensions and populates facts within the data warehouse.
• Created ETL error log which stored errors so if packages fail, it sends email notifications with error attachments.
• Developed Informatica packages that populate data into dimensions and facts using data conversions, lookups and Slowly Changing Dimensions (SCD) transformations.
• Scheduled/monitored ETL jobs and responsible for troubleshooting failures.
• Created Reports using Business Objects

Confidential, San Diego, CA

SQL/BI Developer

Responsibilities:

• Analyzed data warehouse architecture and created ETL mapping from source to destination target.
• Designed complex ETL strategies to extract data from various sources such as SQL server 2000/2005, SAP flat files, along with Excel then subsequently transformed and loaded data into dimension and fact tables.
• Developed SSIS packages using for each loop in control flow to process all SAP files, used file system tasks to move files into archived folders and inserted transaction log data into SQL tables.
• Developed ETL for SAP transaction logs which stored history for each populated table collecting data such as location of source file, source file type, number of row inserts and updates, creation date and creator name.
• Developed UDF functions which populated date dimensions.
• Defined data source, data source views, created cubes and MOLAP/ROLAP data warehouse using SSAS 2005.
• Developed complex SQL queries and stored procedure to create reports using SSRS 2005/2008 from relational database, data warehouse, data mart and cubes.

Confidential, La Jolla, CA

SQL SSRS Report Developer

Responsibilities:

• Satisfied clients reporting needs using SSRS by creating and presenting drilldown and parameterized reports.
• Developed queries to generate reports based on business requirements.
• Administered and scheduled mail subscriptions on SSRS Reporting Server.
• Developed complex SQL queries/ stored procedure using clauses such as inner and left joins.
• Created tabular and matrix reports using aggregate functions and expressions.