SUMMARY

• Highly motivated and competent analyst with over 12 years of technical and business experience in the Financial Services, Automotive manufacturing, Banking and Telecommunications sectors. Intellectually aggressive business expert with proven ability to use and apply standard contemporary principles, theories and concepts to various business prospects and scenarios with the aim of uplifting the same.
• Collected, processed and analyzed data to track project performance and make valuable suggestions for enhancing overall profitability.
• Information research and data discrepancy analysis.
• Gathered business requirements from the end users and translated them to data flows and proposed conceptual models.
• Designed, developed, tested and implemented multiple projects using the Agile methodology as well as the Waterfall methodology.
• Experience working with databases - DB2, IMS DB, Teradata, VSAM.
• Experience with application development using IBM mainframe related technologies - COBOL, Pacbase, DB2, JCL, CICS, IMS DB/DC.
• Experience with middleware and web-based tools - MQSeries, Stored Procedures, SOAPUI, Eclipse.
• Experience with mainframe tools - SPUFI, Fileaid, XPEDITOR, Changeman, CA-7.
• Extensive experience with data modeling using ERWIN.
• Excellent communication skills with ability to work in big teams as well as across multi-functional teams.
• Excellent problem solving abilities and a fast learner.
• Ability to manage and lead multiple teams.

TECHNICAL SKILLS

Hardware: IBM OS/390, IBM ISeries.

Operating System: Windows XP/2000/98/95/NT, MVS/ESA, OS/390, Z/OS.

Languages: Pacbase, COBOL, JCL, REXX, MQSeries, Eclipse, Stored Procedures.

RDBMS: DB2, IMS DB, Teradata.

Groupware: Microsoft Office.

OLTP: CICS, IMS DC.

Access Methods: VSAM.

Tools: CA-File Master (CAFM), CA-7, SAVRS, Fileaid, ERWIN, XPEDITORCA-Endevor, SPUFI, QMF, Visual Source safe (VSS), Super CDCLGEN, Changeman, File Manager, File aid for DB2, SharepointVersion Control.

PROFESSIONAL EXPERIENCE

Confidential

Technical Leader and Business Systems Analyst

Responsibilities:

• Worked closely with the business team and Data analysts to categorize and sort the data requirements.
• Documented the requirements and shared it with the stakeholders and facilitated communication between the technical and product teams.
• Created functional detailed specifications from the requirements document to avoid/overcome such risks in future phases of the project.
• Prepared Business Requirement Document and converted into functional specifications.
• Created UML diagrams such as use case diagrams, activity diagrams, and sequence diagrams.
• Worked with the Erwin tool to create Data models for the new Teradata tables.
• Provided data mapping, data analysis and data profiling for all the mapped requirements.
• Provided design solutions based on the requirements and data mapping.
• Coordinated meetings/activities between the various cross-functional IT teams and the clients to maintain effective communication and working relationships.
• Worked closely with cross-divisional engineers for implementation, integration and testing.
• Developed and modified existing programs to help enhance their performance using COBOL, Stored Procedures, Easytrieve, JCL, VSAM, DB2 and Eclipse.
• Developed and modified programs to provide long term fixes for regularly failing jobs.
• Planned and provided support for Integration testing of certain long term fixes.
• Planned and implemented system changes.
• Provided post-Implementation support until system stabilization.

Confidential

Senior Software Developer

Responsibilities:

• Analyzed job failures as and when they occurred and helped in fixing them within the SLA set by business.
• Wrote technical specification documents and test documents.
• Created VISIO diagrams showing Current and To-Be systems.
• Developed and modified existing programs to help enhance their performance using COBOL, Stored Procedures, Easytrieve, JCL, VSAM, DB2 and Eclipse.
• Developed and modified programs to provide long term fixes for regularly failing jobs.
• Developed new Stored Procedures as specified by Business to perform eligibilities for certain cards.
• Developed new SOAPUI messages to run the Web Services to get the data off the PI databases.
• Performed unit testing for all the programs developed.
• Monitored jobs in SAVRS to check them for issues.
• Planned and provided support for Integration testing of certain long term fixes.
• Planned and implemented system changes.
• Provided post-Implementation support until system stabilization.

Confidential

Application Analyst

Responsibilities:

• Analyzed job failures as and when they occurred and helped in fixing them within the SLA set by business.
• Wrote technical specification documents and test documents.
• Created VISIO diagrams showing Current and To-Be systems.
• Developed and modified existing programs to help enhance their performance using COBOL, Easytrieve, JCL, VSAM, DB2 and Teradata.
• Developed and modified programs to provide long term fixes for regularly failing jobs.
• Created test scripts for QA team to validate the changes.
• Performed thorough system testing and regression testing as any issues could potentially cause financial losses for the client and its associates.
• Monitored jobs in ESP to check them for issues.
• Planned and provided support for Integration testing of certain long term fixes.
• Planned and implemented system changes.
• Provided post-Implementation support until system stabilization.

Confidential

Technical Lead

Responsibilities:

• Gathered and analyzed requirements from the users for the merging of the Renault and Confidential systems.
• Performed Impact Analysis and prepared the Impact Analysis reports based on the requirements.
• Developed Program specification documents.
• Designed and developed new IMS DC screens for new orders, documentation, broadcasting, breakdown, etc.
• Designed and developed modifications to existing screens to in corporate the Renault Truck standards into the Confidential systems.
• Designed and developed interfacing with the java-based screens for new orders, documentation, broadcasting, breakdown, etc.
• Assisted team members in debugging the existing complex codes using Xpeditor.
• Designed and developed batch systems (jobs) to determine quantities of orders, parts, etc. on a nightly basis.
• Designed and developed the performance testing and independent testing for all online and batch systems.
• Prepared the data dictionary documents to be submitted to the DBA to add new fields or to create new Tables.
• Tracked, reported and generated metrics through the different stages of the project.

Confidential

Programmer Analyst

Responsibilities:

• Gathered requirements from the users for the various products (mutual funds, brokerage, etc.) being administered to the clients.
• Designed and developed new CICS screens for new account setup, account detail maintenance, client detail maintenance, etc.
• Designed and developed modifications to existing screens to in corporate changes such as addition of email address, etc.
• Designed and developed client notifications such as statements, letters, etc.
• Designed and developed tax forms - 1099R, etc. for the clients Confidential the financial year end.
• Designed and developed new batch systems to generate lists of accounts/clients to whom notifications/tax statements needed to be mailed.
• Developed JCLs to execute batch programs and procedures.
• Designed and developed systems for IRAs, CESA, etc. to determine contributions/distributions made by the clients and accounts associated with thesame.
• Assisted team members in debugging the existing complex codes using Xpeditor.
• Involved in data extraction, data preparation, data validation, analysis and reporting.
• Designed and performed the performance testing and independent testing for all online and batch systems.
• Prepared project plans identifying risks and mitigation plans.
• Performed production support activities including resolving tickets and raising tickets for all projects implemented.
• Tracked, reported and generated metrics through the different stages of the project.