PROFESSIONAL SUMMARY:

• Experience in development and maintenance projects with system study, analysis, design, development, testing and implementation responsibilities.
• Having strong domain knowledge on Banking and financial services and Health care
• Experience on data warehousing technologies such as Ab Initio - Creating and testing of Ab Initio graphs using GDE (Graphical Development Environment)
• Have experience on extensive dataflow analysis on web EME across different AbInitio graphs.
• Sound knowledge on most of the mainframe supportive tools Like - Changeman, Endevor, DBvisualizer, DB2 Admin, Star tool, Insync, File aid, Expediter, QMF and Spufi
• Completed technical and domain s experience
• Achieved countless s - STAR, ABOVE & BEYOND, Best Team player, Project of the year … etc
• Having good experience on production implementation activities
• Has been working as an onsite coordinator for long time having sound experience on working with client and different vendor teams .
• Experience in handling complex project installations and coordinating with different teams.
• Having sound experience in analyzing issues and giving fix quickly, many times single handedly resolved many production issues, installation and environmental issues.
• Ensure that metrics are correctly defined and reported, never compromise the quality of our deliverables and always deliver on time and on budget
• Good experience on organization internal tools (peoplesoft, Project tracker .. etc) and organizational internal activities
• Strong database skills and software development & testing knowledge.
• Clear understanding of business procedures and ability to work as an individual and as a part of team.
• Flexible with work environment and having good communication and Interpersonal skills.
• Good analytical abilities, self motivated and zeal in learning new tools.
• Like to help team members on resolving issues and sharing knowledge
• Nice supportive to work in friendly environment and celebrating team functions
• Most interested on new learning’s and sharing with team.

TECHNICAL SKILLS:

ETL Tools: Ab Initio(GDE, WebEME & Control M), DW Concepts

Operating Systems: MVS - OS390, UNIX - AIX, Windows 9x/2K

Hardware Platforms: IBM Mainframe, Pentium PC

Mainframe Technology: COBOL, DB2, JCL, REXX and VSAM

Mainframe Tools: Star tool, Insync, Endevor, Changeman, Xpediter, QMF, Spufi, File Manager,MVS utilities, ICETOOL, SORT, IBM Data Studio

Database: DB2, SQL

Domain: Banking & Finance and Healthcare

Other Utilities: TSO/ISPF, IBM Utilities

Methodologies: Dimensional modeling of STAR, SNOWFLAKE.

Knowledge: C, C++, JAVA, Informatica, Python, AWS, DevOps, Salesforce

PROFESSIONAL EXPERIENCE:

Confidential

Environment: ETL Tools - Ab Initio, EME, UNIX, DB2, SQL and Control M

Responsibilities:

• Applying advanced knowledge of Ab Initio Graphical Development Environment (GDE), AbInitio Data Profiler, Ab Initio EME, DB2, SQL and UNIX
• Developed UNIX shell scripts to automate the Data Load processes to the target Data Warehouse
• Deploying the Ab Initio Graphs and scripts between environments.
• Worked on complex data formats, which included Vector type of record format coming as a source from Mainframe as part of Acquisitions Transaction and Maps using AB INITIO Normalize and later on De-normalize component.
• Developing and working with ETL job status report, Cognos BI job status report, BHI job status report for monthly submission, external data transfer, and IN/OUT status report
• Worked various Programs, conditional components and transform functions, sub graphs, most components like datasets, filter, join, and sort, Partition etc and used lookups.
• Developing and applying performance improvements, updates, and production deployment guides for every release in CCTI
• Providing release notes for every release in CCTI
• Documenting updates to CCTI Architecture documentation
• Producing an adhoc report requests tracking report
• Involved in effective communication between the team and customer to ensure all the deliverables met on time without revert backs.

Confidential

Environment: IBM Mainframes - COBOL, DB2, JCL

ETL Tools - DMExpress, UNIX

Responsibilities:

• Responsible for leading the project team in delivering solution to our customer for complex Forms Conversion project.
• Deliver Analysis & Design of the project with Quality deliverables.
• Code reviews, test results reviews and handling Installation of Projects for new implementations and enhancements for our customer.
• Deliver new and complex high quality solutions to clients in response to varying business requirements.
• Self and independent testing of enhancements made in the system with respect to the new business requirements, Bug Fixing.
• Estimation & Tracking of the Maintenance requests.
• I have to ensure that Quality Centre will be updated for each defects found in the projects and follow up till it fixes
• Code review has to be done in each language.
• Involved in effective communication between the team and customer to ensure all the deliverables met on time without revert backs.

Confidential

Environment: ETL Tools - AbInitio - GDE, Contro M, UNIX

IBM Mainframes - COBOL, DB2, JCL

Responsibilities:

• Working as an Onsite Coordinator in understanding the requirements of the End Users/Business Analysts and developing applications for ETL Process using Ab Initio and Mainframe process using COBOL, JCL.
• Analysis and Design of the project with Quality deliverables.
• Performed Unit Testing of the mappings developed and ETL process to check if the transformations are executing as expected.
• Developed ETL code using Abinitio Tool to load data from cross platforms into DB2 Tables where the data will be extracted for reporting purpose.
• Validating UNIX scripts for parsing & modifying data and FTP.
• Actively coordinating with testing team in the testing phase and helped the team to understand the dependency chain of the whole application.
• Providing warranty support for implemented projects.
• Involved in writing complex sql queries to fix analyze/fix any production incidents as part of Level 3 support team.
• Extensively working on different utilities to load/fetch data from Multiple Virtual Storage (MVS) systems built on a Mainframe platform.

Confidential

Environment: IBM Mainframes - COBOL, DB2, JCL, Stored procedures, REXX ETL Tools - AbInitio(GDE, Control M and Web EME), UNIX

Responsibilities:

• Responsible for leading the project team in delivering solution to our customer for complex Forms Conversion project.
• Deliver Analysis & Design of the project with Quality deliverables.
• Code reviews, test results reviews and handling Installation of Projects for new implementations and enhancements for our customer.
• Deliver new and complex high quality solutions to clients in response to varying business requirements.
• Self and independent testing of enhancements made in the system with respect to the new business requirements, Bug Fixing.
• Estimation & Tracking of the Maintenance requests.
• I have to ensure that Quality Centre will be updated for each defects found in the projects and follow up till it fixes
• Code review has to be done in each language.
• Involved in effective communication between the team and customer to ensure all the deliverables met on time without revert backs.

Confidential

Environment: IBM Mainframes - COBOL, DB2, JCL, VSAM, REXX

Responsibilities:

• Requirement Analysis.
• Estimation
• Design
• Coding
• Unit Testing
• Application maintenance
• Status reporting and tracking
• Mentoring junior members in the team
• Attending process audits and quality assurance

Confidential

Environment: IBM Mainframes - COBOL, DB2, JCL, VSAM

Responsibilities:

• Involved in Design, Analysis, coding and testing.
• Involved in Cobol DB2 Program constructions.
• Involved in writing the Unit Test Conditions.
• Involved in Execution of Unit and system Test Conditions.
• Acted as Team Member and ensured that deliverables are of high quality.

Confidential

Environment: IBM Mainframes - COBOL, DB2, JCL, REXX

ETL Tools - AbInitio, UNIX

Responsibilities:

• Played an active role as an Application Developer to develop modules.
• Played an active role in Unit Test Case preparation and execution.
• Performed System Testing of the Application.
• Developed a tool using REXX to automate the submission of batch jobs.