SUMMARY:

• Detail - oriented and Client-focused professional with more than ten years of experience in all expects of Data warehouse Design, Development, Testing and Maintenance; complemented with domain expertise in Banking and Financial Service, Confidential .
• Exhibit analytical problem-solving aptitudes in formulating cost-effective and technically feasible solutions to complex problems.
• Exemplify strong experience in Requirement analysis, Project tracking, Version control, Customer interaction, Release management, Defect Tracking, On time Delivery and Warranty Support.
• Possess articulate communication and interpersonal skills in building positive work relationships with internal and external customers.

SKILLS:

ETL Tools: IBM Datastage (8.5, 9.1), Pentaho

Script: Unix shell script

Database: Oracle PL/SQL, Teradata

Scheduling Tools: Zena, Autosys

Trained on: Talend 6.3, IBM Big Analytics, R, Python, Data Analytics Microsoft Cortana Intelligence Suite

WORK EXPERIENCE:

Senior ETL Developer

Confidential, Chicago, IL

Responsibilities:

• Brain stormed with Business Analyst and users during requirement gathering stage.
• Analyzed business requirements to convert it to technical specifications.
• Designed Teradata source queries, Datastage jobs to include complex code logic using Transformers, Joins and Lookups assuring good performance.
• Developed UNIX scripts to copy user uploaded files from Windows to UNIX server, SFTP the files to care providers.
• Collaborated extensively with connectivity team to understand and implement CFT protocol to transfer the files.
• Worked extensively on ZENA scheduler to develop and schedule processes which calls Datastage jobs, UNIX scripts.
• Provided warranty period support to resolve user queries applying troubleshooting skills related to application functionality and environment setup.
• Studied Zena and Datastage jobs and documented their working process.
• Worked extensively with System Analyst and DBA’s to performance tune the database maintenance jobs.
• Created Talend jobs to copy the files from one server to another and utilized Talend FTP components.
• Created Talend jobs for data integration from multiple sources, utilized lookup and joiner functions.

Senior ETL Developer

Confidential, Dallas, TX

Responsibilities:

• Worked on proof-of-concept automation of MS Access DB to ETL process in Pentaho under extreme deadline
• Analyzed business requirements to devise ETL mapping design
• Designed jobs to migrate history data from MS Access DB to Oracle tables
• Developed Pentaho jobs and transformations to perform data cleaning, validations and then load in staging tables
• Developed and managed project plans while providing status updates to management.
• Analyzed code incompatibility issues in Datastage/SQL Queries/Unix Shell Scripts and resolved it in collaboration with IBM/Oracle DBA’s respectively.
• Implemented on the fly selection of Configuration files which reduced performance bottlenecks by 30%
• Proactively automated clearing UVTEMP and Project (CORE Files) directories
• Awarded 'Awesome Associate' title for implementing password encryption/decryption in Data Stage 9.1
• Installed Pentaho, Message Queue and FCFM(File Mover) on Linux servers
• Developed UNIX scripts to copy vendor files from current production to new servers to mimic production data for testing
• Led automation for Data comparison and Validation
• Created and maintained a knowledge base on Data Stage migration by compiling a list of technical issues encountered in UNIX scripts and Datastage jobs along with corrective actions taken
• Executed and monitored standards for Disaster Recovery and High Availability

Confidential

Responsibilities:

• Conducted business requirement analysis and technical design sessions with business and technical team to develop requirements document and ETL mapping specifications
• Involved in performance tuning and optimization of Datastage mappings using features like Pipeline, Partition Parallelism
• Used Datastage best practices while designing to identify where Lookup/Join/Merge should be used and deciding where sparse/normal lookup to be used
• Efficiently handled data inserts/updates/deletes using change capture and shared containers for code reusability
• Developed complex SQL queries to in-built it in Oracle connector stage to remove performance overhead because of high data volume
• Defined data cleansing, validation, standardization and mapping rules for enhancements and new ETL processes
• Streamlined data from sources like sequential file, XML files, Oracle database
• Programmed complex calculation logic for business requirements in Transformers
• Performed impact analysis and devised test strategy for Unit, System and Regression test cases
• Systemized Monthly release process by implementing guidelines for version control and release notes
• Coordinated and monitored project progress with off-shore team for timely delivery

Confidential

Responsibilities:

• Led an offshore team of 4 members for ETL migration from Data Stage 7.5 to Data Stage 8.1.
• Automated data comparison/validation between 7.5, 8.1 data loads.
• Performed root cause analysis to resolve code issues and data mismatch.

Confidential

ETL Developer

Responsibilities:

• Reduced user manual efforts by reconciliation of processed data and sending notification to business users with discrepancy in data
• Automated routine tasks such as clear disk space, compress files, long running alerts and job abort alerts
• Automated Dataset management to delete datasets and filesets
• Enhanced ETL code to in-built audit functionality
• Automated weekend tasks using UNIX shell scripting and Autosys to stop and start ETL batch jobs before starting and after stopping weekend DB maintenance
• Resolved complex application issues applying in- depth knowledge of Datastage, Pl/SQL, Cognos, UNIX and broad range of troubleshooting skills related to application functionality and server setup, database management, data analysis
• Prioritized numerous issues of varying severity, and effectively managed the resolution of all issues within accepted service levels (SLA’s)
• Collaborated extensively with cross-functional Team Leads, Business Analysts, and Global Operations to resolve client issues
• Documented root cause analysis, solutions and maintenance procedures