ETL Lead/Developer Resume

SUMMARY

IT professional with increasing role, responsibilities and proven records.
Self - motivated, result-oriented, adaptive and focus on customers’ satisfaction.
Dynamic leader who utilizes creativity, leadership and teamwork to design and build managed-services for large group of business applications.
Intimate knowledge on a wide range of databases, ETL technologies including DataStage, Informatica and SSIS. Built services and support processes on these technologies for large group of business applications.
Excellent system design, solution architect, problem-solving and development skills.
In-depth knowledge and tuning on Oracle databases, UNIX and Windows operating systems, IaaS, VM’s, networking and various ETL technologies.
Exceptional development skills in C/C++, PL/SQL, Unix Scripting, DataStage, Informatica and SSIS.

TECHNICAL SKILLS

DataStage architect, developer, administrator
Informatica developer, administrator
SSIS developer, administrator
PL/SQL developer
BusinessObjects, Crystal Report, Cognose
Data warehouse, dimension model, Star / Snowflake schema

PROFESSIONAL EXPERIENCE

Confidential

ETL Lead/Developer

Responsibilities:

Served as an ETL Architect and led an ETL team in the development of a Claims Data Warehouse using IBM InfoSphere DataStage and Oracle.
Provided consultation and reviewed code from contracted developers.
Developed PL/SQL code for complex member eligibility calculation.
Designed and built ETL services for internal data integration customers. ETL technologies included IBM DataStage 7x, 8x, 11x, Informatica PowerCenter 9x, 10x, Big Data Manager / Data Quality and Microsoft SSIS.
Implemented ETL services on GRID
On-boarded and provide day-to-day support of 100 DataStage applications, 150+ SSIS applications and 12 Informatica applications. Responsible for 24x7 support, troubleshooting an investigation of issues. Handled complex ETL performance issues against RDBMS especially Oracle databases.
Designed and developed self-services features using UNIX Korn Shell, Windows PowerShell and third-party tools so customers can carry-out common tasks themselves without relying on support staff. On average 10,000 self-services requests are performed on a monthly basis.
Developed staff and transitioned workload across onshore and offshore members to maximize support coverages and provide learning opportunities for all members.
Continuous refinement of service offerings to support DevOps and agile development methodologies. Over 80% of operational requests re fulfilled in less than 1 day.
Reviewed business requirements and architected ETL/BI solutions on traditional database platforms including Oracle, DB2, Sybase, SQL Server, MySQL and Hadoop.

Data Warehouse Architect

Confidential

Responsibilities:

Led a successful implementation of a Supply Chain data warehouse using SAP Business Warehouse. Managed a team of 10 including 6 SAP consultants and 4 employees for the entire duration of the design, develop and implementation. Data includes Sales orders, Material Management and flat-file data sources. User population: 200.
Led a team of 10 employees of various roles to two successful implementations of the Sales and Trade data warehouse servicing 2000+ users. Tools: Oracle database backend, BusinessObjects for the end-user interface and DataStage for the ETL process.
Worked with data from multiple sources including SAP R/3, various bolt-ons, Seibel, Manugistics and custom data sources.
Architected, deployed and supported a BusinessObjects infrastructure for 1500+ users across the enterprise. Managed the BusinessObject development team to develop and deploy over 10 BusinessObjects universes.
Developed utility scripts on Unix and NT servers to monitor system performance, automate data validations and communicate system availability via Web sites and e-mails.
Setup and supported Oracle databases.

Oracle DBA

Confidential

Responsibilities:

Led the development team to several successful implementations of Sales & Marketing applications, supporting a cross-divisional sales force of 200+ users and 250 in-house users. Applications include:
Provided coaching and direction to a team of five IT professionals to ensure on time project delivery and customer satisfaction.
Provided system and application support for all users in the CardioVascular Division.
Evaluated and recommended network infrastructure, hardware and application platform to support the CAD/CAM systems.
Administered Unix and PC networks

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship