ETL Administrator and Onsite Delivery lead Resume Charlotte, NC - Hire IT People

SUMMARY:

Information Management Leader consummate problem solver having nine years of experience in Business Analytics / System Integration / Project Management / ETL Development and ETL Architecture. Has project experience inclusive of the analysis, design, construction and implementation of business case - driven process improvements. Uses of technology to support business / analytical process improvement have ranged from decision support enablers to integrated transaction processing applications across relevant computing platforms. Expertise in Business Intelligence and specializing on creating data marts, data warehouse solutions spans industry leading companies.

TECHNICAL SKILLS:

Industries: Healthcare, Banking and Insurance, Travel and Transportation

Project Domain: HealthCare Statistics, Business Analytics and Data Mart implementations; ETL process design and implementation; Technical Team Leadership; Business Process and Re-engineering; Application Development; Agile Methodology; Web Traffic Analysis; Supply Chain Systems Integration; Shipping Container Business; Market Analysis and Strategy; Data Governance; Enterprise Data Management; Banking and Insurance claims Integration

Hardware: IBM, HP, SUN

Operating Systems: UNIX, AIX, Linux, .NET, SUN Solaris, MVS, MS Windows

Prog. Languages: PL-SQL, C++, C; JCL, Java, SAP, Oracle Suite, SAS

RDBMS: Oracle, DB2 UDB, IMS, MYSQL, Teradata, Netezza, SQL Server, Informix

BI Tools: IBM DataStage (8.7/8.5/8.1 PX, 7.5 PX, IIS 9.1), Business Objects, Crystal Reports, SSIS, SSAS, SSRS, SAS, OBIEE, Informatica

Other Applications: Visual Source Safe, SVN, CVS, MS Office 2013, SharePoint, Service Center, Remedy and Service Now, Share Point, IPWC

Testing Tools: HP Quality Center, Confidential Rational Quality Manager

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

ETL Administrator and Onsite Delivery lead

Responsibilities:

Estimation preparation, Requirement Gathering and Analysis, Design Document preparation, Development, Mapping document creation, Unit Testing, Test Bed preparation, Test Plan preparation and execution, SIT co-ordination, preparing Implementation plan and Deployment of code
Co-ordination between Clients, Management and other teams
Performing Datastage Administrator activities like, setting up project properties, job scheduling, setting up environmental variables, Information Server stop and start, Weekly house-keeping activity on the Server, Database Client version upgradation in ETL Server

Confidential

ETL Design Lead

Responsibilities:

Creation of ETL solutions using stages like - TD Connector, TD Load, MQ Stage, Column Export, Import, Surrogate key generator, Aggregator, SCD, Join, XML Stages, Hash file, Transformer, most stages of Datastage sequencer, export/import of Datastage jobs and Table Metadata for Data Migration and DWH projects
Development of Teradata BTEQ Scripts and UNIX Scripts
Fine tuning of existing jobs
ETL monitoring and support of Production environments
Works closely with users and reporting team to identify and fix the Production issues

Confidential

Datastage Lead Developer

Responsibilities:

ETL code migration from Datastage 7.5 to Datastage 8.1
Task allocation to the team, Project estimation, Design document and Mapping document creation, Development of Datastage jobs and sequences
Enhancing ETL jobs and JCL creation, UNIX Scripts creation, SIT/UAT support
Conducting team meeting and weekly meetings between Clients and Team
Code review and testing, Unit test data preparation, test case and test results generation

Confidential

Datastage Developer

Responsibilities:

Creating ETL code to extract data from heterogeneous data sources, cleanse, transform and load data
ETL code creation as mentioned in the Design document. Fine tune of existing Datastage jobs,
SQL Scripts creation, Unit test data preparation and testing of ETL jobs and UNIX Scripts. Test case, Test Scenarios preparation
SIT support

Confidential

SAS Programmer

Responsibilities:

Interpreting and Converting MS excel formulas to SAS datasets using Base SAS
Writing generic Transformation Generators. SAS tables and graphs creation
Analyzing the data using existing statistical procedures. Design and implementation of SOX compliant processes

We provide IT Staff Augmentation Services!

Etl Administrator And Onsite Delivery Lead Resume

Charlotte, NC

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship