SUMMARY

• Having a good experience of around 10 Years in IBM Mainframe applications, development, maintenance and Production support with great exposure to JCL, COBOL, PL1, DB2, and VSAM.
• Extensively worked on MVS Architecture, COBOL, JCL, DB2, VSAM, Z/OS and TSO/ISPF, OPC, SPUFI, Change man, RDZ, Remedy, ITMS, File - AID.
• Extensive Knowledge in requirement gathering, analysis, design, development, implementation, testing, integration deployment, documentation and maintenance of IBM Mainframe applications.
• Experience in technical co-ordination and onsite/offshore model project delivery. Expertise in preparing project plans, proposals, estimations, functional specs and Technical specs.
• 3 years of extensive experience in Information Technology with special emphasis on Design and Development of Data Warehousing using Informatica Power Center .
• Strong expertise in Relational data base systems like DB2, Oracle, SQL Server, MS Access.
• Designed and developed various mappings and mapplets in Mapping designer and sessions and workflows in Workflow manager to extract data and load to Oracle database.
• Well acquainted with Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups, Aggregators, and Re-usable transformations
• Strong Experience in developing Sessions/Tasks, Worklets, Workflows using Workflow Manager tools - Task Developer, Workflow & Worklet Designer.
• Excellent strengths are my interpersonal skills by working in well diverse business settings. Experience in handling projects in various roles as Team Member, Team Lead, Technical Specialist and Programmer.

TECHNICAL SKILLS

Database skills: DB2, DATACOM, FOCUS, Oracle 9i/10g

Programming Languages: COBOL, JCL, VSAM, RPGLE, PL1

Operating environments: Z/OS, OS/400, and Solaris 5.9.

Tools: and Utilities: ISPF/PDF, SPUFI, FILE-AID, Autosys,OPC/TIVOLI, ALCHEMIST, CHANGEMANExpeditor, N2O, RDZ, Remedy, ITMS.

ETL tools: Informatica Power Center 8.1.1

PROFESSIONAL EXPERIENCE

Confidential

Technical lead

Responsibilities:

• Participate in the Business requirement walk thru with Business users and Business Analysts.
• Create technical specification and conduct technical walk thru with Business area.
• Coordination with offshore technical team by interaction through conference calls, mails and Net Meeting
• Coordination with offshore to validate and clarify requirements for design/development work at offshore.
• Reviewing the changes done by offshore.
• Analyzing and fixing any critical bugs raised by users.
• Monitoring ITMS, work on critical and urgent ticket raised by helpdesk.
• Attending bug status meeting with client and SQA.
• 24/7 production support.

Environment: zOS, COBOL, PL1, JCL, DB2, Datacomm, OPC, Changeman, RDZ, ITMS, FILE-AID, VSAM

Confidential, Boston

Technical lead

Responsibilities:

• Worked as developer for the project which involves migration of CIW data from DB2 to Oracle database.
• My role includes requirement gathering, Analysis, Coding, Testing, Documentation, Implementation and Production support.
• Raising issues and problems proactively so that no impact will be caused on the effort and schedule of the project.
• Ensuring the quality of outputs to the client by following the client standards.
• Support during integration testing.

Environment: COBOL, JCL, DB2, OPC and Oracle

Confidential

Senior developer

Responsibilities:

• As an onsite coordinator, collecting the requirements from the customers and preparing design document, efforts required and planning for the completion date.
• Handling issues raised by business users and production control which are categorized as Incidents, Problems and Minor enhancement.
• Assigning tasks to the reportees and make sure they complete on time.
• Level 2 Oncall support for DWH application- during weekends.
• Coding, Unit Testing and preparation of the Technical document
• Involved in preparation of DWH Process document for handling Production job abends and this has been followed by all application teams across the account.
• Part of first oncall for all application Production support(DWH,CTS,PMS)
• Monitoring Batch jobs running in the live and fixing it with given SLA period.
• Coordinating with Client SME for any unresolved job abends and fixing it with proper documentation.
• Coordinating with Onsite team and SME for month end activities and extensively worked on month end supports.
• Weekly status meeting with client.
• Involved in Performance tuning in existing mapping and SQL.
• Involved in the analysis, design and development of all the interface's using Informatica Powermart tools in interface team and interfaced with all the other tracks for business related issues.
• Loading contracts on daily basis.
• Reporting to clients on daily basis.
• Sending Reports on monthly basis.
• Worked on complete SDLC from Extraction, Transformation and Loading of data using Informatica.
• Developed standard and re-usable mappings using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, update strategy and filter.
• Created, updated and maintained ETL technical and design documentation.
• Managed software releases after each stage of the testing and defect removal.

Environment: COBOL, JCL, DB2, FOCUS, Change man, N2O, TWS, Natural & ADABAS, Informatica Power Center 8.1.1, SQL Navigator, SQL developer, WINSQL, Oracle 9i/10g, DB2 8.01, SQL server, PL/SQL, Solaris 5.9, Windows XP, UNIX shell scripting.

Confidential 

Developer

Responsibilities:

• Taking ownership of issues assigned (Through ASSYST) by service line and completing it within given SLA limit.
• Performing rate uploads for all products of NUI(Motor & Non-Motor products)
• Preparing UTP for the minor changes and system test plans for Application development projects.
• Monitoring live jobs and fixing it as on when it fails and reporting to service line
• Providing overnight batch support when new components are implemented in LIVE system.
• Extensively worked on print issues, both ASF (Application Support Facility) and CSF.
• Handled the Underwriting AD, Policy and Quotes mart AD's.
• Responsible for the Underwriting Changes.
• Contributed reviews in the Policy and Quotes Marts.
• Provided support for system and acceptance testing

Environment: Mainframe - zOS, COBOL, JCL. Tools-alchemist, OPC, FILE-AID, AS/400- RPGLE, CL, DB2, Expeditor.