SUMMARY

• Dedicated and experienced IT professional with exceptional applications support, production supportSQL Server Database Development and ETL development using Microsoft Business Intelligent Tools.
• Demonstrated experience utilizing ETL BI tools such as Informatica, SQL Server Integration Services (SSIS),SQL Server Analysis Service(SSAS) and Database systems such as Oracle, SQL Server 2000, 2005,2008R2,2012 and 2014, Teradata
• Experience with Microsoft BI Development Environment Tool ( SSDT)
• Excellent technical and analytical skills with clear understanding of system development lifecycle and designs goals
• Team player with excellent communications skills and problem solving abilities

TECHNICAL SKILLS

Programming Languages: Visual Basics 6, VBScript, VB.NET,C#.NET,T - SQL,ANSI SQL,PL/SQL

Operating Systems: Windows NT, 2000 Server, 2003 Server, Windows Vista, Windows 7, Windows 2008R2,Windows 10, Windows 2012

Software Application: Microsoft Access, Excel, PowerPoint

Database: Oracle 9i, MS Access, SQL Server 2000/2005/2008 R2/2012/2014,Teradata

ETL Tools: SSIS, Informatica

Reporting/Analysis Tools: SSAS, SSRS, Power BI

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

DW/BI Consultant

Responsibilities:

• My first task when I took over was to merge the data since it was coming from different DB sources but one source was being decommissioned.
• Modified all the extract Dimensions and Facts packages to remove the decommissioned source DB.
• Addressed the EDW performance issues by modifying the packages to run in parallel instead of serial, implemented indexing on the tables, replaced some cache lookups with T-SQL MERGE commands, removed unnecessary columns from the extract and processing packages, changed default settings in the packages and added update statistics to the packages as a last step when the load was completed. The changes improved the overall run time in the EDW from 50 minutes to 15 minutes per run.
• Addressed the Dimension table inaccuracies by analyzing the source data and realized some business keys records were not being used during the lookup hence the incorrect data in some of the Dimensions.
• Addressed the issue of Type 2 Dimensions adding a record even when no new updates existed in the source by analyzing the source data. I found that there were 2 system that were using the same ID, requested one to be removed from the source and the issue was fixed.
• Created new SSIS packages as requested by business users as part of the reporting requirements.
• Added Configuration files to the SSIS packages to simplify migration to the production environment
• Modified existing SSRS reports based on request from the executive managements.
• Monitored all SSIS and SSRS jobs scheduled in the production environment and fixed any reported failures.
• Created a data dictionary of all source and target tables, described table relationship using Primary and Foreign Keys. Also highlighted Business Keys in the source tables.
• Created an ETL Developer’s Guide Standards and Best Practices to be used at Utiliquest by all SSIS ETL Developers.
• Documented all EDW Dimensions and Facts SSIS extract and processing packages
• Documented all EDW SSRS and Transactions Reports, describing the purpose of the report, where it is located, who uses it and all the queries and parameters used in the report.
• Created reports and Visualization using Power BI as per the higher management request.
• Created Database objects such as Tables, Views, Stored Procedures, Functions, Triggers, etc.
• Used JIRA to track the progress of assigned EDW/BI projects from start to finish and updated the manager during the status meeting

Confidential, Atlanta, GA

DW/BI Architect

Responsibilities:

• Developed and Implemented executive Care Scorecard metrics by summarizing historical data for use by higher managers for analytical and trending purposes
• Involved in all phases of Development Life cycle, from requirement gathering, Design, Testing, Implementation and Support.
• Developed new SSIS packages using SSDT 2012 to extract data from different sources such as files, Oracle, SQL Server and Teradata. Transformed the data to meet our clients requirements and then loaded it to final destination mostly SQL Server 2012,Flat Files, Excel Files, Oracle and Teradata
• Used SQL Server Master Data Service (MDS) to load data to a Centralized Location for consumption by the organization.
• Build Models, Entities, Attributes, Members into the Master Data Service MDS.
• Designed Business rules in the MDS to validate and remove duplicates in the Entities
• Used Teradata utilities like BTEQ and TPT scripts using Teradata SQL Assistant for loading and querying data from different sources
• Developed Type 1 and Type 2 Slowly Changing Dimensions (SCD) when loading Dimension Tables to track historical records as per clients requirements and incorporating them to the Data Warehouse
• Developed T-SQL Store Procedures using Merge Command for Loading Data Warehouse Facts and Dimensions from the Sources
• Experience with SQL Developer for Oracle to write Oracle PL/SQL queries
• Developing SSIS Packages to load Detail Tables from Operational Data Store(ODS) Transaction Tables based on customer requirements and tracking type 2 historical data on the tables
• Used Team Foundation Server (TFS) for versioning SSIS Packages and T-SQL Code
• Scheduled SSIS packages and other Processes using SQL Agents jobs
• Monitored Schedules Production Job in SQL Server and Informatica and fixed all issues arising from failed jobs
• Implemented performance Tuning Technique in SSIS Packages and T-SQL Code to reduce execution time
• Participated in requirements gathering and data realities check from business owners for the development of Score Card Metrics, DW Facts, Dimensions and other ODS transactional processes.
• Modified the existing Data Warehouse by adding addition Dimensions to the Star Schema model based on Clients requirements.
• Created and maintained Database objects such as tables, views, stored procedures, triggers, indexes, and data constraints
• Used JIRA to track the progress of assigned projects from start to finish and updated the manager during the status meeting.

Confidential, Charlotte, NC

Senior SSIS ETL/SQL Server Developer

Responsibilities:

• Involved in all phases of Development Life cycle, from requirement gathering, Design, Testing, Implementation and Support. Acted as the SSIS ETL Developer and Analyst
• Developed new SSIS Packages for loading rating files to Target tables using Visual Studio 2012 and 2014 SSDT
• Modified SSIS Packages created by other users based on new business requirements
• Used JIRA to track the progress of projects from start to finish and updated the Project Manager during the status meeting
• Used Sprint Waterfall Methodology for project development
• Used Autosys for scheduling and running SSIS Package jobs
• Used Tortoise SVN for versioning SSIS Packages, T-SQL Scripts, stored procedures and C# Scripts.
• Created and maintained Database objects such as tables, views, stored procedures, triggers, indexes, and data constraints
• Deployed SSIS Packages and T-SQL scripts to QA for testing by the QA team.
• Fixed issues reported by QA team while testing deployed SSIS sprint projects
• Fixed issues related with Scheduled SSIS Packages running in production environment
• Implemented performance Tuning Technique in SSIS Packages and T-SQL Code to reduce execution time
• Kept history of changed records using SCD Type 2 as required by the business
• Reverse Engineered processes created by other users to better understand how they were created and how they operate so that we can use the same logic for development purposes
• Updated the management with our projects progress and any issues reported by QA every day during daily status meeting.

Confidential, Atlanta, Ga

ETL/SQL Server Developer

Responsibilities:

• Participated in the gathering of business requirements and data realities for the development of CMB Metrics Project
• Involved in all phases of Development Life cycle, from requirement gathering, Design, Testing, Implementation and Support. Acted as the SSIS ETL Developer and Analyst
• Created different Metrics for use by the executives to track the trend of different programs
• Created and maintained Database objects such as tables, views, stored procedures, triggers, indexes, and data constraints
• Used DML to retrieve, Modify, Delete, Insert and Update data in the database
• Used DDL to Create, Alter, Drop and Truncate database objects
• Created Primary Keys to enforce data uniqueness and Foreign Keys for referential integrity.
• Created Data Movement Engines (DME) to move data from the source to the destination for both Detail and Summary data using SSIS
• Created SSIS Packages from different sources such as Oracle, Flat Files, CSV Files, Teradata, SQL Server to populate Detail and Summary Tables
• Transformed and Cleaned the data from Sources using different Transforms such as Derived column, Fuzzy Lookup and conditional Split before Loading in the Destination Table
• Modified some of the SSIS Packages created by other users to meet customer requirements for the development of Financial Services Metrics
• Tested SSIS Packages before deploying them to Production Environment to make sure they executed as expected based on the customer requirements
• Fixed issues related with Scheduled SSIS Packages running in production environment
• Worked with business users to evaluate and resolve data related issues
• Deployed SSIS Packages from Development to UAT and Production Environments
• Created SSIS Jobs in DEV,UAT, PRD to automatically load Detail and Summary Tables using SQL Server Agent
• Created Stored Procedures to Load Detail and Summary Tables from staging environment to final destination using merge command
• Modified Stored Procedures created by other users to accommodate new requirements from the business
• Performed Database Performance Tuning by Creating Table Indexes, Updating Statistics, Maintaining and Monitoring Index Usage, Monitoring Log files, Separating Data and Log Files, Fixing poorly written queries

Confidential, Atlanta, Ga

Business Intelligent Consultant

Responsibilities:

• Participated in the gathering of business requirements and data realities for the development of the Revenue and Expense Data marts
• Involved in all phases of Data Warehouse Development Life cycle, from requirement gathering, Design, Testing, Implementation and Support. Acted as the SSIS ETL Developer and Analyst
• Involved in the modification of the Data Mart to accommodate Data Quality Service (DQS) for cleaning data based on the business requirements.
• Created and maintained SSIS Packages to populate Facts and Dimension tables using PeopleSoft ERP tables and Excel Files as the source using SSIS 2012
• Used DML to retrieve, Modify, Delete, Insert and Update data in the database
• Used DDL to Create, Alter, Drop and Truncate database objects
• Modified some of the SSIS Packages created by other users to meet customer requirements for the development of the Expense and Revenue Data Marts
• Tested SSIS Packages before deploying them to Production Environment to make sure they executed as expected
• Performed UAT testing to compare populated records in the existing old development environments with the new development environment
• Fixed issues related with Scheduled SSIS Packages running in production environment
• Worked with business users to evaluate and resolve data issues
• Created Stored Procedures to Load Dimensions and Fact tables in the staging environment
• Created Stored Procedures to Merge data to the Final Destination using the Merge command
• Maintained database objects such as tables, views, stored procedures, triggers, T-SQL, dynamic SQL, indexes, and data constraints
• Modified Stored Procedures to accommodate new changes from the business users
• Experience using Subversion (SVN) source control to version source codes
• Deployed SSIS Packages from Development, Test, UAT and Production Environments
• Created SSIS Jobs to automatically load Dimensions and Facts Tables using SQL Server Agent
• Experience using Visual Studio 2010 with SSTD
• Used Change Data Capture (CDC) to load Incremental records from PeopleSoft source tables
• Created Triggers to load changed/Updated records to the history Tables.
• Implemented deletes features in Facts and Dimensions to make sure records that have been deleted in the PeopleSoft source tables are marked as deleted in Facts and Dimensions in the Data Marts
• Created daily validation report to make sure source and destinations records match as expected
• Modified some old reports created by others users base on business users requirements
• Implemented performance Tuning Technique in SSIS Packages and T-SQL Code to reduce execution time

Confidential, Atlanta, Ga

SSIS ETL ENGINEER

Responsibilities:

• Developed and maintained SSIS Packages to convert all customer networks files running in legacy system using SSIS 2008R2
• Removed duplicate records during the SSIS package development as per business requirement
• Created validation rules to ensure that only valid provider records are loaded
• Performed data cleaning and scrubbing to remove unwanted characters
• Created and maintained database objects such as tables, views, stored procedures, triggers, T-SQL, dynamic SQL, indexes, and data constraints
• Used DML to retrieve, Modify, Delete, Insert and Update data in the database
• Used DDL to Create, Alter, Drop and Truncate database objects
• Used different kinds of data sources such as flat files, Excel, Access, fox pro files, SQL Server, Raw files
• Proficient using different kinds of data destinations such as flat files, SQL Server, Excel and Access, Raw files
• Experience using Visual Studio 2005 and 2008 for creating SSIS ETL packages
• Mapping Network customer files to destination DB
• Scheduled SSIS Packages to run automatically using SQL Server agent jobs
• Deployed SSIS packages to SQL Server MSDB and File System in Development and Production environments
• Testing SSIS Packages to make sure they extract, transform and load data as per the business requirements
• Created Error Handling features in all SSIS Packages to handle encountered errors
• Used package logging features to capture information such as errors, warnings and execution times
• Proficient using SSIS expressions and variables to make SSIS packages dynamic
• Created Stored Procedures and Functions to strip unwanted characters as per business requirements
• Wrote T-SQL ad hoc queries to extract data from various tables using inner join, outer join and union all commands
• Created databases, tables, views, indexes and other database objects
• Experience using Microsoft Share Point Server
• Experience using Tortoise Subversion Source Control
• Experience analyzing data to solve customer issues
• Implemented performance Tuning Technique in SSIS Packages and T-SQL Code to reduce execution time