UMMARY:

• MSBI consultant with 7+ years of experience in design, development, analysis of database and business intelligence solution which includes SQL scripts, database objects upgrade, ETL frameworks, data conversion, and reporting. Proficient in MS SQL Server, BI Stack (SSIS, SSAS, SSRS, Power BI), and Tableau in large and complex environments within multiple industries.

TECHNICAL SKILLS:

Database: SQL Server 2016, 2014, 2012, 2008/R2

SDLC: Agile, Scrum, Waterfall, and Spiral

Data Modeling: ER - win, MS Visio

Database Programming: T-SQL, Dynamic SQL, MDX, DAX

Development Tools: BIDS, SSDT, SSMS

Integration Tool: SSIS

Analysis Services (SSAS, OLAP Cubes, Tabular Model)

Reporting Tools: SSRS, Tableau Desktop, Power BI, Excel Power BI

Source Control and Collaboration Tool: Team Foundation Server (TFS), SharePoint

Programming Language: Java and C#

Cloud Technologies: MS Azure (IaaS, PaaS, SaaS)

PROFESSIONAL EXPERIENCE

Confidential. Methuen, Massachusetts

Business Intelligence Engineer

Tools: and Environment: SQL Server 2008R2/2016, T-SQL, SSMS, SSDT, SSIS, SSRS, Tableau, Excel, GitHub, SQL Profiler, SharePoint

Responsibilities:

• Analyzed business and functional requirements, facilitated planning and implementation of the data warehouse during JAD and JRD meetings
• Created and maintained data mapping document and functional guide by analyzing various objects in OLTP/OLAP data sources.
• Developed and created tables, views, indexes, stored procedures, and functions per requirement specifications.
• Maintained data integrity utilizing multiple constraints such as primary key, foreign key and check constraints on Dimension tables part of Data Warehouse.
• Wrote complex stored procedures to migrate data from existing Data Warehouse to new Data Warehouse that supports SCD type 2 to store history.
• Analyzed and upgraded 75+ SSIS ETL packages from 2008R2 to 2016 manually in CPS system.
• Migrated SSIS packages from package deployment model into project deployment model with environments (within SSISDB catalog), and project parameters for new configuration settings.
• Automated execution of ETL process with SQL Server Job agent for SSIS packages and procedures in production environment.
• Examined and evaluated data structures of the existing database and performed data cleanups utilizing Transact SQL.
• Extracted, transformed and loaded data from various sources such as SQL Server, Flat files and Excel files to Data Warehouse after necessary cleansing.
• Managed errors within SSIS package utilizing event handlers, error outputs, and precedence constraints, adapted custom loggings with execute SQL task and script task.
• Analyzed and designed tables, views, stored procedures and indexes in support of various databases and ETL applications.
• Designed column-store indexes on multiple fact tables in central data warehouse to enhance SQL read operation.
• Analyzed dimensional model architecture identifying required modification on dimension and fact tables to improve PHI (Patient health information) report rendering performance.
• Designed reports and dashboards per requirement in SSRS/Tableau utilizing parameters and complex expressions.
• Developed Tableau dashboards with multiple visualizations including custom visualizations such as donut and funnel charts.
• Managed security of Tableau dashboards on Tableau server utilizing users and groups.
• Managed source code version control on GitHub for GLFHC BI team.

Confidential, Richmond, Virginia Area

ETL Engineer

Tools: and Environment: SQL Server 2012/2016, T-SQL, SSMS, SSDT, Erwin, SSIS, SSAS, Excel, TFS, SQL Profiler, MS Azure

Responsibilities:

• Participated in JAD meetings and outlined functional requirements to design the data migration process.
• Developed complex stored procedures to perform index maintenance, data profiling, metadata searches.
• Performed data profiling of OLTP database systems and defined data mappings.
• Evaluated and created different document to support database version upgrade process from SQL Server .
• Examined and evaluated data structures of the existing SQL Server 2012 database and performed data cleanups.
• Documented database structure and objects before and after data upgrade into both business and technical documents.
• Designed dynamic SSIS Packages to transfer data across multiple platforms; validated transferred data.
• Created SSIS packages utilizing different transformations such as aggregate, merge, and merge join.
• Modified package properties such as delay validation, transactions to meet the business needs of data in data mart.
• Utilized various SSIS control flow tasks in SSIS packages such as execute SQL task, file system task, execute package/process task and script task.
• Implemented master-child package architectures in SSIS with package tasks, improving modularity and maintenance.
• Utilized various package configurations for SSIS packages with the help of parameters.
• Converted legacy ETL package from SSIS 2012 version into SSIS 2016 version manually to ensure best accuracy.
• Migrated SSIS packages the in SSISDB catalog with environments; automated execution with SQL agent jobs.
• Designed and deployed SSAS multi-dimension cubes used in analytic research and report generation.
• Developed numbers of SSAS cube objects such as KPIs, calculated measures and named sets
• Configured partition for SSAS cubes to use different storage modes (MOLAP, HOLAP, ROLAP) to improve performance
• Configured resources on Microsoft Azure platform to developing IaaS, PaaS cloud platform for data processing.
• Migrated databases from local database engine onto Microsoft Azure SQL database for proof of concept.
• Collaborated with team utilizing TFS to synchronize data with differing sources.

Confidential, San Diego, CA

Data Integration Developer

Tools: and Environment: SQL Server 2012, T-SQL, SSMS, SSDT, Erwin, SSIS, TFS, SQL Profiler, DTA

Responsibilities:

• Collaborated with the project team and business analysts to outline project requirements in JRD meetings.
• Documented complete workflow to describe database, logic, implementation of application and integration.
• Maintained referential, domain, and column integrity utilizing various constraints such as primary key, foreign key and check constraints.
• Created complex stored procedures and functions to support efficient data storage and manipulation.
• Modified queries to improve database performance utilizing execution plans, indexes, batch processes, and hints
• Extracted, transformed and loaded data from various sources such as SQL, Flat files and Excel files
• Created complex SSIS packages utilizing data flow, bulk insert, script, FTP, and execute SQL tasks.
• Managed errors with event handlers, error outputs, and precedence constraints.
• Adapted SSIS and custom logging techniques to identify performance and error info of packages.
• Optimized SSIS packages with non-blocking/synchronous transformations and task/transformation properties
• Created package configurations utilizing parameters to deploy in different environments such as DEV, UAT, and production.
• Monitored and debugged SSIS packages using log details, checkpoints, breakpoints, and data viewers.
• Automated the execution on data migration packages utilizing SQL Server Agent jobs and proxy accounts.
• Implemented TFS for version control and change management of BI solution for cross-functional communications.

Confidential, Greenville, SC

SQL/ETL Developer

Tools: and Environment: SQL Server 2012, T-SQL, SSMS, Erwin, Visual studio 2010, SSIS, SSDT, TFS, DTA

Responsibilities:

• Collaborated with business users and project management to gather system specification requirements for the project via JRD sessions.
• Wrote stored procedures, functions and triggers per requirements.
• Analyzed requirements and fine-tuned stored procedures to improve performance.
• Optimized and restructured stored procedures for applications by partitioning large tables and managing indexing strategies.
• Created pre-staging and staging databases in the ETL process to perform data operations in the data mart.
• Modified mappings between sources to operational staging targets utilizing star schema.
• Developed SISS packages to migrate from data from OLTP server to the OLAP database.
• Created SSIS packages for data loading utilizing various task and transformations with in SSIS.
• Resolved SSIS package errors utilizing error logs using C#.Net, breakpoints, checkpoints, and data viewers.
• Enhanced the performance of SSIS packages by configuring several properties / features at control and data flow level.
• Created SSIS packages to remove bad data utilizing derived column, lookups, fuzzy lookups, and conditional split.
• Implemented Master/Child packages so only the master package needs to be scheduled which will in turn trigger the execution of other packages.
• Utilized Team Foundation Server (TFS) for the version control and project co-ordination.

Confidential. Stamford, CT

BI Data Engineer

Tools: and Environment: MS SQL Server 2008R2, SSMS, BIDS, T-SQL, Erwin, TFS, SSIS, SSAS, SQL Profiler, DTA, Tableau

Responsibilities:

• Analyzed business requirements, facilitating planning and implementation phases of the data mart via JRD meetings
• Developed and created tables, views, index, stored procedures, and functions per requirement specification.
• Created stored procedures, functions, and triggers for data retrieval/updates in the database.
• Wrote CTEs and ranking functions to remove duplicate records in OLTP tables.
• Implemented error handing techniques such as try catch and error functions to create robust T-SQL code.
• Prevented potential blocks and deadlocks with complex code and incorporating different isolation levels.
• Performed dimensional modeling (Star Schema) with ER-win for the ETL strategy
• Created data mapping document (DMD) by analyzing various OLTP data sources.
• Improved loading times of SSIS packages by implementing parallelism.
• Scheduled SSIS packages to execute during off-hours utilizing SQL Job Agent.
• Configured SSIS packages utilizing parameters and deployed to production server.
• Designed and tested OLAP cubes in SSAS as well as adding calculations using MDX.
• Developed SSRS reports using complex formulas and to query the database to generate ad-hoc reports.
• Designed and implemented multitude of data visualization reports in Tableau desktop as reporting tool and compare it approaches/pro-cons with existing SSRS as reporting tool.
• Designed reports, scorecards, stories, and dashboard for top level management utilizing parameters, sets, groups and calculations in tableau desktop.
• Scheduled the delivery of reports utilizing standard and data driven subscriptions in SSRS.

Confidential

SQL Developer

Tools: and Environment: SQL Server 2008, SSMS, T-SQL, SSIS, BIDS, DTA, SQL Profiler, TFS

Responsibilities:

• Collaborated with the development team in planning, defining, and designing functional requirements.
• Created ER diagrams and applied normalization to improve querying.
• Ensured data consistency; created primary/foreign keys and appropriate constraints.
• Created DDL and DML triggers to maintain database integrity.
• Performed data analyses and data profiling with TSQL and data profiling tasks.
• Implemented BCP utility and bulk inserts for transferring data between SQL server and flat files.
• Created new database objects with T-SQL such as procedures, functions, triggers, indexes, and views.
• Helped deploy SSIS Packages on various deployment servers using configuration files.