SUMMARY

• 10.3 years of experience in IT Software Development including Design, Development, Implementation, Testing and Support on various IT projects.
• 10+ years of experience in Data warehousing applications (ETL) using Ab Initio GDE, Co - operating System, Conduct>It, Express>It, Continuous flows, Metadata Hub and Unix/Linux operating system.
• Design, development and support experience with the Ab Initio product suite using GDE, Co>Operating System, EME and control center.
• Well versed in Abinitio parallelism techniques and working experience on Abinitio plans, XML flows,MQ, Continuous flow, Micrograph, Meta programming, PDL and EME.
• Ab Initio specialists to provide hands-on workdesigning and implementing data integration solutions for data warehouse and business intelligence systems
• Extensive development experience in Extraction, Transformation and Loading of the data from multiple sources into Data warehouse. Well versed with various Ab Initio parallelism techniques including Data, Component and Pipeline parallelism.
• Extensively performed Testing, Debugging, Troubleshooting, Monitoring and Performance Tuning of Ab Initio graphs.
• Strong knowledge of Data Modeling methodologies such as Star Schema and Snowflake Schema.
• Good exposure to multiple relational databases including Oracle, DB2, Teradata
• Experience with Hadoop and Big Data technology POC . Hadoop ecosystem Big Data Platform. Installing the tool, configuring hadoop datalake server in Confidential

TECHNICAL SKILLS

ETL Tools: Ab initio (v3.1.1, v3.0.5, v2.15, v1.15), METADATAHUB, EXPRESS>IT, CONDUCT>IT, EME, CONTROL CENTER

Other Tools: Anthill Pro, SPLUNK, CA Workload control center, Infrared360, HP Performance manager, OVPI, Ever bridge (Hiplink), SharePoint Documentation (DMS), Confluence, PAC2000, NDM, DTS, PMT, CAMS, ART, JIRA, HPSC, ITSP, SPARC (Risk and Assessment), Power Designer, PM Universal workstation, SQL Assistance client, Toad, SQL Developer, PUTTY, mainframe gateway, RMS

Operating Systems: AIX and HP UNIX, Linux, Windows 95/98/NT/2000/XP, IBM Mainframe MVS zSeries.

Databases: DB2 8.2, Oracle 10.2, 11g and 12c, TERADATA

Programming Languages: SQL, JCL, JIL, UNIX shell script (BSH, KSH)

Data Modeling Tools: ERwin, MS Visio, TOAD

Scheduler Tools: CA 7, AUTOSYS, CRONTAB, CONTROL-M

Version Control Tools: Ab Initio EME, Subversion (SVN), Harvest

Model: Agile Methodology, SDLC, Software Engineering

PROFESSIONAL EXPERIENCE

Confidential

Technology Specialist

Responsibilities:

• Automated manual works through Unix KSH shell scripting
• File System cleanup/Unix and databse space usage automated Report scheduled in Linux.
• Automated reports for long running jobs in production and UAT.
• Linux ETL Servers CPU / virtual memory usuage of all environments and health check automated Reports .
• Unix Script was developed, if any SQL failed or running longer in database side to send the automated email to support team for taking further action to resolve the issue.
• Ab Initio graph design and development (Includes Web service, XML data parsing, PDL, Meta programming), the design includes the code driven using metadata to make it more generic and less rework/ change request once moved to production.
• Involved in code reviews, performance tuning strategies at Ab Initio and oracle/db2 database level.
• Creating of Ab Initio parallel jobs for faster execution of jobs.
• Worked on Ab Inito Graph components such as Join, Reformat, FBE, Rollup, Run, Redefine format, Fuse, Sort, dedup sorted, datasets and database components, compress and deprecating components.
• Worked on Ab Initio Plan components like Conditional Task, Program Task And Graph Task.
• Solving of Ab initio Dependency errors and data lineage and metadatahub issues in all environmenrs.
• Unix file system/database space usage, NDM, DTS, Golden Gate alerts monitoring setup and mentanance/enhancement for production and non prod environments.
• Designing real time interactions in the batch process by using Continuous graphs Queues Publish and Subscribe.
• Metadata hub issues were reported and resolved on timely manner.
• Resolved the existing data quality issues and DQE issues though EXPRESS>IT .
• Built Big Data POC's on Hadoop framework. Hands on exposure to HDFS and Ab Initio Datalake migration project for short term.
• PAC2K was used for problem tickets and JIRA for tracking all the tasks Dev requests for any perfective maintence in ABINITIO graphs.
• Performance tuning of ABINITIO jobs developed.
• Infrafred 360 was used for MQs channel related jobs where XML was used in ABINITIO code.

Environment: Mangers/Access Analyst/Sizing Lead

Confidential

Responsibilities:

• Designing and Implementing a continuous process to pick and process the inbound files as in whenthey arrive. The inbound data from the file is routed to corresponding country’s DB instance.
• Responsible for end-to- end design comprising the FSD, HLD, LLD and other process designs
• Job scheduling - Autosys, Creating /updating /deleting and Jilling the jobs.
• Developing generic graphs for daily processes in MFS layout. Leading the development team and mentoring them on development needs.
• Developed wrapper scripts and using Plan IT to schedule the processes.
• Performed DEV/IST/UAT/SPL/PFIX environments setups /Install Plan creations based on each enterprise and monthly releases to support Teams for on time delivery of projects in releases.
• Database Install Plan creation and execution in each releases.
• Prodfix environment setup and dry run execution before every enterprise release.
• SPARC, Confidential security and Risk assessment of each project before landing in to production.
• Created many ART requests for getting access to Databases / UNIX / BOK / DMS/ EME/ AB INITIO/SubVersion/Confluence/Anthill/ and other tools for new and existing team members .
• Involved in upcoming Projects cost estimations though T-shirt, Swag and detailed sizing ( Confidential Terms)for MODE platform in Confidential bank.
• Anthil /Jenkins / u-deploy and Subversion was used for deplying daily python code in SIT and UAT.
• CAMS requests was used to deploy ABINITIO code deployments in production and non production environments.
• SPARC (Risk and Assessment) system was used to access the risk in production for any upcoming projects in production on Confidential enterprise level.

Confidential

Solution Design Engineer/ SPL tester / Tableau Developer

Responsibilities:

• Generating the data through Ab Initio Graphs/Plans and psets for non -production environment.
• Performing data analysis using Toad and shell script on the source data to assist in doing impact analysis.
• Developing graphs and wrapper scripts based on the design related to change controls and using Plan IT to schedule the jobs.
• NDM/DTS setups were done for upcoming projects for file transfers within Confidential /outside Confidential bank.
• Stress performance testing for all production like schedule along with the upcoming new release jobs in integrated /stress and load performance test environment.
• Fixed defects / bugs reported by the functional/data quality testing teams.
• Proposed the solution/design for upcoming new MODE projects and involved in creation and maintenance of FSDs.
• Developed the dashboard in Tableau 8.3 and 9 versions for production support and other teams for file system/database usage/ capacity management for the platform.
• SPLUNK and Business Objects POC was done for MODE dashboard during this period.
• Mainframe Gateway was used to read and write the mainframe files in ABINITIO GDE for multiple applications.

Confidential

Infrastructure/Ab Initio Admin

Responsibilities:

• Worked as a ABINITIO admin activities for upcoming ab intio Projects.
• Used different EME air commands in project promotion like air tag create, air save, air lock, air project export etc.
• Data directories, sandbox creations, EME setups were performed as an admin
• EME was also used as a part of dependency analysis extensively .
• Involved in AI projects migration from development to QA and QA to UAT and then Production.
• Linux servers setups . co>op installation, version upgrades, environment setups .
• Docmentaiton was each tasks performed and resolution was captured in DMS/Confluence for furture reference for the team.

Environment: Ab Initio GDE V2+ and V3+ versions., Co>operating system, AUTOSYS, Oracle SQL Developer, Teradata SQL assistant, Windows XP, Linux, EME, Metadata Hub, Control Center, express>IT, conduct>IT

Confidential, Atlanta, GA

Ab Initio Developer

Responsibilities:

• Worked on the dependency analysis as a part of Technical analyst of this project.
• Gathering requirements from business users, SMEs and Production support teams.
• Seeking the opportunities for renovation, retire or consolidate the applications, if possible.
• Under the above categories will estimate the cost savings in terms of Infrastructure, maintenance and support cost savings to the Confidential Inc portfolio by portfolio.
• Reviewing the existing code, Impact analysis and ensuring the opportunities, if any redundant data is present under the scope of retire.
• Preparation of Business cases and on the basis of BC cost savings estimation and in next phase execution of these opportunities.

Environment: Ab Initio GDE 1.15.x,, 2.1x,3.1x Co>Operating System 2.15.x, Unix HP-UX, MVS Mainframe, Unix script, DB2, MS Visio, CA-7 Scheduler, Plan IT, Control-M, CRONTAB.

Confidential, Atlanta, GA

Technology Specialist

Responsibilities:

• Application production support comprising of incident, user request and problem tickets. This includes Emergency break fix and associated unit testing.
• Perfective maintenance to avert future foreseeable application issues, in order to improve performance, quality, reliability, efficiency, usability and maintainability of the application.
• Business continuity activities including, disaster recovery planning and support for exercises and events.
• Knowledge Transition planning and preparing system appreciation documents
• Business continuity activities including, disaster recovery planning and support for exercises and events.
• Business Impact analysis of system changes and implementing necessary changes in the application.
• Implement perfective maintenance to improve the system health and performance.
• Defect prevention and documenting learning’s.
• Resolve production incidents and document the steps involved in resolution.
• Coordination with Enterprise Testing Organization for maintenance and execution of regression test scripts.
• Capacity planning and co-ordination.
• Environment: Ab Initio GDE 1.15.x,, 2.1x,3.1x Co>Operating System 2.15.x, Unix -AIX, MVS Mainframe, Unix script, DB2, MS Visio, CA-7 Scheduler, Plan IT, Control-M

Confidential, Atlanta, GA

Senior Lead Ab Initio Developer

Responsibilities:

• Gathering requirements from business users and creating Logical Design and Physical Design documents.
• Performed analysis, design, development, and testing of Ab Initio graphs.
• Setting up Ab Initio and Unix environment in DEV, QA and PROD region for the project.
• Developing generic graphs for daily processes in MFS layout. Leading the development team and mentoring them on development needs.
• Developing wrapper scripts and using Plan IT to schedule the processes.
• Reviewing the code developed by offshore team and ensuring the code is developed in accordance with the Organizational standards.
• Conducting Integration testing in QA environment and performing smoke test with CA-7 scheduler.
• Performing data analysis using shell script based on the need of the business.
• Promoting the codes to QA & PROD, assuring the transition to Prod Support team is completed.

Environment: Ab Initio GDE 1.15.x, Co>Operating System 2.15.x, Unix HP-UX, MVS Mainframe, Unix script, DB2, MS Visio, CA-7 Scheduler, Plan IT, CONTROL-M

Confidential, Atlanta, GA

Lead Ab Initio Developer

Responsibilities:

• Gathering requirements from business users and creating Logical Design and Physical Design documents.
• Performed analysis, design, development, and testing of Ab Initio graphs.
• Setting up Ab Initio and Unix environment in DEV, QA and PROD region for the project.
• Developing generic graphs for daily processes in MFS layout. Leading the development team and mentoring them on development needs.
• Developing wrapper scripts and using Plan IT to schedule the processes.
• Reviewing the code developed by offshore team and ensuring the code is developed in accordance with the Organizational standards.
• Conducting Integration testing in QA environment and performing smoke test with CA-7 scheduler.
• Performing data analysis using shell script based on the need of the business.
• Promoting the codes to QA & PROD, assuring the transition to Prod Support team is completed.

Environment: Ab Initio GDE 1.15.x, Co>Operating System 2.15.x, Unix HP-UX, MVS Mainframe, Unix script, DB2, MS Visio, CA-7 Scheduler, Plan IT, Control-M

Confidential

Senior Ab Initio Developer

Responsibilities:

• Gathering requirements from business users on change controls and enhancements to the mart and maintaining Logical Design and Physical Design documents.
• Conducting impact analysis on the change controls and contributing to the project plan based on the analysis.
• Performing data analysis using Toad and shell script on the source data to assist in doing impact analysis.
• Developing graphs and wrapper scripts based on the design related to change controls and using Plan IT to schedule the jobs.
• Conducting Integration testing in QA environment and developing mainframe JCLs for scheduling in CA-7 scheduler.
• Conducting KT sessions with Prod Support team to deliver the project after Prod migration and creating application Playbook and Runbook as reference documentation to assist Prod Support team.

Environment: Ab Initio GDE 1.15.x, Co>Operating System 2.15.x, Unix HP-UX, Unix script, DB2, Toad, CA-7 Scheduler, Plan IT., Control-M and CRONTAB.

Confidential

Ab Initio Developer

Responsibilities:

• Developed complex ETL job processes for the system. Performed requirement gathering, analysis, design, development and testing of Ab Initio graphs.
• Learnt the business process and applied appropriate business rules to develop processes.
• Developed component architecture design, designed job process flow diagram, created high level design and business rules documents.
• Estimated and planned development work, tracked and reported task progress, delivered work on schedule.
• Prepared unit test cases, performed unit testing and created unit test results. Integrated master & child perl scripts with Ab Initio graphs and performed integration testing.
• Deployed Ab Initio graphs into Test and Production environment and Support in post-production deployment.
• Worked with offshore team to develop multiple shelll scripts and took direction from managers.

Environment: Ab Initio GDE 1.13.x, Co>Operating System 2.14.x, Unix, Shell script, Oracle 10.2, Toad, MS Visio.

Confidential

Ab Initio Developer

Responsibilities:

• Developed complex ETL job processes for the system. Performed requirement gathering, analysis, design, development and testing of Ab Initio graphs.
• Learnt the business process and applied appropriate business rules to develop processes.
• Developed component architecture design, designed job process flow diagram, created high level design and business rules documents.
• Estimated and planned development work, tracked and reported task progress, delivered work on schedule.
• Prepared unit test cases, performed unit testing and created unit test results. Integrated master & child perl scripts with Ab Initio graphs and performed integration testing.
• Deployed Ab Initio graphs into Test and Production environment and Support in post-production deployment.
• Worked with offshore team to develop multiple shelll scripts and took direction from managers.

Environment: Ab Initio GDE 1.13.x, Co>Operating System 2.14.x, Unix, Shell script, Oracle 10.2, Toad, MS Visio., Control-M