Senior ETL Developer Resume Greenville, SC - Hire IT People

SUMMARY:

Extensive experience in Data Warehousing and Business Intelligence project development in the IT industry.
Full life cycle experience with Microsoft SQL Server Business Intelligence stack (SSIS, SSRS and SSAS) to deliver industry standard BI solutions.
An effective hands - on leader and team player with the aptitude to work with business owners to architect, model, develop, test and implement BI solutions to fit a given business need.

TECHNICAL SKILLS:

BI / OLAP: SSIS, SSAS, SSRS,SSDT, Informatica, Tableau 10.0/ 10.2, Business Objects

Databases: SQL Server 2000 / 2005 / 2008/ 2012/2016, Oracle 9i, Oracle 10g,11g MS Access

Applications & Environment: Microsoft Visual Studio 2010/2013/2015, BIDS, SSDT, TFS, SSMS,TOAD for SQL Server, TOAD for Oracle, Toad Data Modeler, Visio, Erwin r7 and r9, TFS, SVN, Office 2017

Languages: Microsoft Visual C# 2010, Microsoft Visual Basic 2010, T-SQL, PL/SQL, TSQL

PROFESSIONAL EXPERIENCE:

Confidential, Greenville, SC

Senior ETL Developer

Responsibilities:

Responsible for designing and developing the ETL for the data warehouse and datamart on the Project Cost & Estimating project using the Microsoft BI stack ETL tools (SSIS)
Creating complex stored procedures and T-SQL to manipulate and move data across environments
Worked closely with the lead data architect to ensure the table designs were best optimized for re-usability and flexibility
Responsible for working closely with the application leaders and lead architect to put together mapping documents for the ETL and QA teams

Confidential, Atlanta, GA

Senior BI Architect & ETL Developer

Responsibilities:

Migrated and created over 20 reports and dashboards from old reporting systems such as Business Objects and Logi Analytics into Tableau 10.2
Developed over 100 back end Oracle packages and procedures that pulled data from the data mart and in some cases created the process to pull data from the source into the data warehouse for over 50% of the company’s dashboards and reports.
Designed and built out the data warehouse and data mart for ticketing data during the integration of the company’s Remedy application systems during the OneComm and Delta Comm acquisition.
Built out the company’s Consumer Data mart using Toad Data Modeler (TDM) and Kimball’s data warehousing methodologies for the Customer Support Team.
Extracted the data from several raw sources into the data warehouse (ODS) and then into the data mart using the Microsoft BI stack ETL tools (SSIS)
Successfully migrated the consumer reporting data from an unsupported Microsoft platform to SQL server 2005 and then eventually to 2016.
Provided the Consumer side of the business with over 50 reports via SSRS and the SSAS multi-dimensional structure for use with Excel pivot tables.

Confidential

Manager, Consumer Support Team

Responsibilities:

Responsible for managing all Consumer Support reporting or data requests that come to the Data warehouse team.
Managed a team of 4 offshore resources whose task is to ensure that all jobs run successfully and automated reports are distributed successfully.
Reviewed and approved the design and development of the ETL needed to populate the reporting data mart used for high profile reports.
Developed a prototype for the SAP CRM effort for the Customer support team using the SAP objects such as BEx Analyzer, infoObjects, Open Hub destinations and Process Chains.

Confidential, Atlanta, GA

Senior Consultant - SQL Server Developer Lead

Responsibilities:

Developed the Solution Design / Architectural Document which outlined the migration procedures, pre-conversion activities and data cleansing/massaging rules to share with the business owners
Led the team to a successful data migration from Granite to a SQL Server database despite the tight timelines
Set up a new development environment for the client. This environment was used for testing any updates made to the existing code as needed

Confidential

Senior Consultant - Data warehouse Support Provisioning Lead

Responsibilities:

Responsible for developing and executing UAT test cases in the Provisioning subject area for compliance upon migration to new data warehouse architecture. I was also responsible for
Oriented and trained new team members on business rules and processes in the provisioning subject area and reviewed test cases of my team members for the Maintenance and Repair and Billing subject areas.
Facilitated meetings and brown bag sessions with the client to share and broaden their knowledge around the current status of issues or risks on the project.

We provide IT Staff Augmentation Services!

Senior Etl Developer Resume

Greenville, SC

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship