Professional Experience Summary

• Around 15 years of IT experience in design and development of ETL solutions using Ab Initio, Oracle, Teradata, MSSQL, DB2 for supporting data migration, data transformations & processing in data warehouse and integrating BI analytics and reporting environments through ETL solutions.
• 2.3 years experience in developing Big data solutions using Pyspark, Scala and Kafka
• 3 years of experience in leading ETL solutions delivery of FedEx Sales management applications and nearly 3 years in Florida Blue Healthcare.
• Hands on working experience in SDLC Life cycle and work experience in Agile-Scrum Methodology for 3 years.
• Experience in Gitlab for Source code version control and Jenkins for Code Migration
• Excellent knowledge of Data Warehousing and Business Intelligence concepts and working knowledge in Data Modeling Methodologies.
• Extensive hands-on experience in core Ab Initio concepts like Parallelism, MFS.
• Has experience working in Healthcare, Logistics, Telecom, Retail, Insurance and Finance domains.
• Good experience in leading teams to build ETL solutions for business capabilities and in training and mentoring team members
• Experience in using EME for version controls, impact analysis and dependency analysis.
• Has working experience in Conduct>It for creating Ab Initio Plans and has good experience in creating generic reusable graphs and has work experience in AB Initio Continuous Flows
• Developed generic Ab Initio graph for loading Teradata using Fast load or API based on data volume.
• Has working knowledge on BRE and has exposure to Ab Initio suite of products- ACE, Metadata hub, Control Center & Express>It.
• Experience working in Big data technologies to load the data to hive and Mongo databases
• Experience in ETL tools like Informatica and has working knowledge in Hadoop concepts of HDFS, Hive and has undergone a training using Talend.
• Hands on experience in Unix Shell Scripting and Scheduling tools.
• Excellent knowledge in ETL interfacing of heterogeneous source systems like various RDBMS (Oracle, Teradata, Sybase, MS SQL Server, DB2), flat files and legacy system.
• Expert in system analysis and troubleshooting, test plan strategy, release planning and has experience in all phases of SDLC starting from requirements collection till moving the code to Production.
• Flexible, enthusiastic and team player with excellent communication and analytical skills, ability to grasp new concepts and implement productively.
• Hands-on experience in improving performance and troubleshooting of Ab Initio graphs.
• Worked in client interfacing roles for clients across various domains.
• Experience in handling concurrent projects in an offshore-onsite development model.
• Experience in Code versioning tools like GIT, EME and Code Migration using Jenkins 1 and 2
• Experience in Agile, Waterfall model of ETL development
• Applied modern principles, methodologies and tools to support changing business capabilities.

Core technical and tool competencies

• Big Data tools : Pyspark, Scala
• ETL tools : Ab Initio 3.1.6, Conduct IT,Metadata Hub, Informatica, Talend
• Reporting tools : Business Objects, Brio
• Scripting Languages : Unix shell scripting
• Version Control tools : GIT, EME, RCS, CVS, Clearcase, Visual Source Safe
• Code Migration tools : Jenkins 1, Jenkins 2
• Databases : Hive, Teradata, Oracle, DB2, SQL Server
• Nosql Database : Mongo
• Defect Tracking Tool : HP Quality Center, ClearQuest
• Operating Systems : HP Unix, Solaris, Windows 7
• Schedulers : Control-M, Autosys, Dollar U, Maestro, Cron
• Others : PDSM, Visio, ITSM, Service Manager