CAREER SUMMARY:

• Overall 12+ years of experience in Mainframe and Data Warehousing and ETL in Insurance and banking domains.
• Over 8+ years of Experience in various Ab Initio Products.
• Designed/Developed Batch processing jobs, good at performance tuning and Exposure to Various Performance Testing Techniques in Ab Initio.
• Designed Error and Logging Framework (ELF) for error and log capturing
• Strong knowledge of Data Warehousing concepts and Dimensional modeling like Star Schema and Snowflake Schema.
• Extensive experience in ETL Design, Development, Data Analysis, Requirements Gathering, Gap Analysis, Production Support, Incident/Problem Management, Release Management, Configuration Management, and Testing.
• Worked on all phases of SDLC from requirement gathering to product support.
• Excellent business communication skills, both written and verbal.
• Critical thinking with good negotiating, influencing, and delegating skills.
• Excel at communicating with stakeholders to provide accurate reporting and information regarding the ongoing projects and initiatives
• Ensuring the delivery from the projects adhered to the appropriate levels of quality, on time and with limited resources, in accordance with the plan and governance models
• Effective Issues and Risks management with status tracking and compliance with quality tools and standards
• Team management includes conflict resolution and issue management
• Track Issue Register and Risk Register and publish the updates as and when necessary to the stake holders.
• Report Customers with exact and precise information during Daily and Monthly Review Meetings with the Executives.
• Extensive experience in various databases like Oracle DB, DB2.
• Reviewing ETL graphs and Unix Scripts.
• Worked extensively on application maintenance tasks such as requirement analysis, functional studies, estimation, design, coding, testing, implementation, 24/7 L3 support and quality reviews.
• Organized and detail - oriented, able to work well under deadlines in a changing environment and perform multiple tasks effectively and concurrently.
• Strong working experience in Scrum / Agile framework and Waterfall project methodologies.

TECHNICAL SKILLS:

Programming Languages: - Ab Initio, Unix, Python, COBOL

Databases: - Oracle, DB2

Scheduling Tools: - Control-m, Tivoli

Operating Systems: - Windows, Unix

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Manage test environment booking requests from project teams.
• Performance tuning and Exposure to Various Performance Testing Techniques in Ab Initio.
• Handling Jobs scheduling requests in control-M and consulting.
• Consulting application teams on the job abends in Cherwell Service managements and working on it to resolve them in control-m with application teams.
• Publish all necessary schedules, dashboards and reports in line with the agreed timelines
• Coordinate all refresh activities e.g. plan, GIS submissions
• Perform the pre & post refresh tasks as per schedule
• Provide Support for batch appilcations.
• Coordinate for execution scripts, tools for batch operations
• Review refresh, deployment plans
• Perform pre & post refresh tasks
• Install base line codes and configure message feeds in integration layer
• Test if the required batches work in the new environment
• Validate integration of systems via the integration layer

Confidential

Responsibilities:

• ETL Design, Development, Data Analysis, Requirements Gathering, Gap Analysis, Production Support, Incident/Problem Management, Release Management, Configuration Management, and Testing.
• Supporting ADW applications for Mon-Fri nightly cycle, weekly/monthly/yearly jobs for any aborts and long running jobs within the prescribed protocols.
• Creating analysis and approach (design) documents for defect solution.
• Providing lead activities for ODS L3 Support team which consists of DDE (Ab Initio/Unix/Oracle/DB2)
• Needed to coordinate 24/7 support provided by 12 offshore and 4 onsite team members.
• Responsible for meeting SLA for critical Severity 3 incidents (< 4 hours).
• Co-ordinated with numerous teams on a given day to resolve critical incidents within a stringent timeframe.
• Maintained a team strike rate of resolving more than 30 incidents in a day.
• Was required to do requirement analysis, estimation, design, coding, bug fixing, testing (Unit, regression and System), implementation, monitoring, doing 24/7 support activities and attending quality audits.
• Involved in the overview of test planning, adhering to standards and meeting deadlines.
• Responsible for reviewing the deliverables being sent from offshore and resolving issues if any, ensuring timely delivery and client satisfaction. Responsibilities include assuring quality deliverables and playing a key role in offshore delivery.
• Involved in implementation related activities such as preparing Change Orders, raising Quotes and Implementation Monitoring.
• Trainer on Ab-Initio basics and advanced sessions for new joiners
• Involved in implementation related activities such as preparing Change Orders, raising Quotes and Implementation Monitoring.
• Trainer on Ab-Initio basics and advanced sessions for new joiners

Confidential

Mainframe Developer

Responsibilities:

• Working as Analyst Programmer on multiple projects. Handling responsibilities starting from requirement analysis, designing, coding, testing and implementation.
• Impact analysis on different systems related to SOCROC due to this database expansion
• Performance analysis of the SOCROC due to DB expansion
• Actively involved in analysis & feasibility study of options.
• Involved coding & unit testing.
• Involved in changes for Performance improvement of the ROCSOC system.
• Involved in all the testing phase.
• Preformed Pre-implementation activities & participated in Post implementation support.
• Support for whole implementation with production team.