SUMMARY:

• ETL Application developer with 9 years of experience in developing, maintaining and migrating Enterprise level Data Warehouses based on technologies like Hive, HBase, Talend, DataStage, Oracle, Teradata, Linux, UNIX & other Big Data platforms for Confidential .
• 9 years of ETL Development and US Healthcare & Insurance experience.
• Extensive work done on Hive, HBase & HDFS data movement using hive SQL, sqoop export & talend into Oracle based Datawarehouse.
• I have built a private mapr based edge node for our Line of Business to be part of the enterprise datalake cluster.
• Over 8 years of development experience in ETL tools - Datastage & about 3 years in talend.
• Well versed in ETL processing i.e. Extraction, Transformation, Load and maintenance of Data Warehouses and Data Marts.
• Well versed in Agile & Waterfall Methodologies of Software Development
• Well versed in UNIX shell scripting PL/SQL and TWS Scheduling
• Proficient in talend for Big Data, primarily in the migration of ETL cycles for enterprise datawarehouses into talend from Datastage and other UNIX, SQL based services.
• Expert in the ETL tool DataStage. Lookup File Set, Change Capture, Filter, Funnel, Copy, Surrogate Key Generator, Sort, File set, Sequential File, Data set, Oracle Enterprise, Merge, Aggregator, Remove Duplicates Stages.
• Extensive hands on experience on upgrading an ETL Job Scheduling tool (Tivoli Workload Scheduler)
• Extensive experience in creating test plans, test files, implementation plans and Validation plans for data warehouse development, testing and checkout activities.
• Active DevOps practitioner for over a year.
• Extensive experience in creating supporting documentation, such as metadata, diagrams of entity relationships, business processes, and process flow in order to better Production Support function.
• Decommissioned 3 Datawarehouses and 1 DataMart.
• Worked at length on migration projects in conversion of transmission channels (FTP to SFTP, /ECG/CFT)
• Successfully improved various scripts and modified loading processes to increase efficiency.
• Over 18 months of Onshore experience in Development & Support of Datawarehouses
• Exceptional interpersonal and analytical skills.
• Excellent oral and written communication skills.
• Six Sigma White belt certified

TECHNICAL SKILLS:

ETL Tools: talend 6.2.1, 6.3.1, 6.4 & IBM DataStage 7.5, 8.0.1, 8.5, 11.3

Scheduling Tools: Tivoli Workload Scheduler 8.5, 9.1

Operating Systems: Linux, UNIX, Win XP, Win 7

Databases: Oracle 9i,10g & 12, HiveQL, Hbase, Teradata, DB2

Languages: UNIX Shell Scripting, PL/SQL, sqoop

PROFESSIONAL EXPERIENCE:

Confidential

Application Developer II

Technology: talend 6.2.1, 6.3.1 & 6.4 & IBM Datstage 8.7, 11.3, Linux, Perl, PL/SQL, Oracle, hiveQL & sqoop

Responsibilities:

• Setup, Maintenance of the mapr based Edge node for the Community & State Line of Business
• Develop Talend jobs and implement them in the Big Data environment to move data from Hive, HBase tables and mapr file system into Oracle based Datawarehouse.
• Deployed end-to-end ETL process to get Prior Authorization Pharmacy data for Community & State from the Datalake into Oracle.
• Developed a Helath Plan console for the Community & State Leadership that outlines all the metrics about the growth and factors that will impact the future of this line of business.
• Migrated a process that has 400 jobs from Datastage and SQL to talend and sqoop..
• Completed Proof of concept (PoC) for a Payment Engine Application to move to Talend from DataStage

Confidential

IT Data Analytics Analyst (Senior Software Engineer)

Technology: talend 6.2.1, IBM Datstage8.5, takend Citrix, Linux, Perl, PL/SQL, Teradata, DB2, hiveQL & sqoop

Responsibilities:

• Improved existing ETL processes (SQL Queries) to streamline and speed up the process.
• Extensively worked on documenting of Production Implementation documents.
• Extensively worked on projects to work on new implementations with the development team.
• Extensively worked on the automation of multiple process’s in order to avoid manual intervention.
• Provided 24x7 support involving quick fixes in case of ETL Process Failures.

Confidential

IT Database Analyst

Technology: IBM Datstage7.5, Citrix, UNIX, PL/SQL, Oracle, Toad, Tivoli Workload Scheduler

Responsibilities:

• Extensively worked on maintaining the most accurate and most updated data on a daily basis which included constant analysis and numerous code fixes in case of data discrepancies.
• Extensively worked on numerous automation projects in order to avoid annual intervention.
• Extensively worked on making the application more stable by reducing the number of incidents/failures and were successful in applying all proposed enhancements reducing the incidents count by 60%.
• Provided 24x7 On Call support involving quick fixes in case of ETL Process Failures.
• Extensively worked on implementation of SFTP, CFT jobs involving UNIX scripting and creating/modifying jobs in Tivoli Workload Scheduler to meet Confidential standards.
• Modified existing ETL processes to streamline and speed up the process.
• Extensively worked on Performance Tuning of DataStage Jobs and PL/SQL scripts.
• Extensively worked on the implementation of UNIX shell scripts to process the data Files.
• Worked on DataStage to design, validate, schedule and run the jobs.
• Extensively worked on the documentation of Production Implementation documents.

Confidential

ETL Developer

Technology: VACS VMS, Citrix, UNIX, PL/SQL, SQL server, Oracle, Toad

Responsibilities:

• Single handedly maintained the datawarehouse to make sure it was up to date on a daily basis
• This included constant analysis and numerous code fixes to correct data discrepancies.
• Provided 24x7 On Call support involving quick fixes in case of ETL Process Failures.
• Conducted a portfolio wide Knowledge session on the NICE Datawarehouse.
• Modified existing ETL processes (SQL scripts) to streamline and speed up the process.
• Was the application contact till it was decommission in September 2012.
• From a Datawarehouse perspective I had to archive all the data, source code as per the company guidelines before the application was shutdown.
• Extensively worked on the documentation of Production Implementation and Decommission documents.
• Maintained the Datawarehouse on my own and I was the sole technical contact for NICE Datawarehouse till it was decommissioned it in November 2012.

Confidential

ETL Developer

Technology: IBM Datstage7.5 PX, Citrix, UNIX, PL/SQL, SQL server, Oracle, Toad

Responsibilities:

• Implemented complete monthly load cycles for the DWH.
• Used IBM DataStage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into Data Warehouse database.
• Extensively worked on creating Unit and System test plans, thereby debugging and testing the jobs.
• Worked with DataStage Manager for importing metadata and write the Routines.
• Worked with the DataStage Director to validate, schedule and run the jobs.
• Extensively worked on the implementation of UNIX shell scripts to process the Flat Files.
• Extensively worked on the implementation of UNIX shell scripts to invoke the DataStage jobs.
• Extensively worked on the documentation of Production Implementation documents.
• Maintained the Datawarehouse till it was decommissioned in January 2012

Confidential

ETL Developer

Technology: Citrix, UNIX, PL/SQL, SQL server, Oracle, Toad

Responsibilities:

• Extensively worked on creating Unit and System test plans, thereby debugging and testing the jobs.
• Extensively worked on the implementation of UNIX shell scripts to process the Flat Files.
• Extensively worked on the implementation of UNIX shell scripts to invoke the DataStage jobs.
• Extensively worked on the documentation of Production Implementation documents.
• Maintained the Datawarehouse and I was the sole technical contact for RIMS Datamart till it was decommissioned in June 2012.