SUMMARY

• 8+ years of Information Technology experience in Analysis, Development and maintenance in Mainframe technologies .
• 7+ years of experience in COBOL, JCL, DB2, VSAM, CICS, Easytrieve, SQL queries, DB2 and Native SQL stored procedures.
• Expertise in Database tools like LOAD, UNLOAD, IMAGE COPY, REORG, RUNSTATS etc.
• Effective involvement in Data profiling, Data mapping, analysis of Data Transformation services, field to field data migration, test data creation and reconciliation activities.
• Understanding of Data modeling concepts, various schemas and their applications.
• Sound understanding of relational, object and dimensional databases
• Excellent domain knowledge in Financial Banking sector in the Wealth Management domains.
• Knowledge and working experience on Software Development Life Cycle (SDLC) & Agile Software Development Life Cycle.
• Working knowledge, experience in application migration activities. Performing due diligence in projects decommissioning that needs immense caution.
• Extensively involved in activities like Requirement Analysis, High level and Low level design, Coding, Unit Testing, QA Support, Implementation and Production Support.
• Extensively involved in giving ideas for optimizing the existing projects in terms of Technology Infrastructure cost and CPU processing time.
• Onsite and offshore team management, task assignment to subordinates and their progress monitoring. Experienced in working with Onsite - Offshore model and led a team of 5 members in few projects.
• Good debugging and diagnostic skills in batch/Online processing.
• Hands on experience in Disaster Recovery, effective coordination with upstream and downstream applications during technical outages to ensure functioning of BAU activities.
• Have experience in gathering and understanding the requirements from the client.
• Involved extensively in training, knowledge transfer sessions to new employees and subordinates to cater to technical and functional requirements of the application.
• Have immense ability to build productive relationships with peers, management, and clients applying strong Communication skills.
• Excellent written and verbal communication skills with ability to interact with individuals at all levels.
• Quick Learner, highly motivated team player with excellent organizational and analytical skills.

TECHNICAL SKILLS

Programming Languages : COBOL, JCL, CICS, Easytrieve, Native SQL

DBMS: DB2, VSAM, SQL, DB2 Stored Procedures, MS SQL, Teradata SQL assistant

Technologies: Mainframes

Programming Tools: ISPF, SPUFI, QMF, MQ, File-AID, DFSORT, NDM, Micro s o f t O ff ice 2007, Microsoft Visio

Performance Analysis: Application Performance Analyser (APA)

Debugging Tools: Intertest, Smarttest, Fault Analyzer

Version Management Tool: ChangeMan

Operating Systems: Z/OS, Windows 7/XP/2000/98, Linux

Certifications: Lean Six Sigma Green Belt

PROFESSIONAL EXPERIENCE

Confidential, NY

Mainframe Lead Developer

Responsibilities:

• Have been part of Party ID generation, assigning correct user id with party ID and maintaining accurate Confidential Online details.
• Strategically architect, design, develop, and implement efficient information systems and/or operations systems in support of core enterprise functions
• Understand business requirements, study existing application landscape, and identify redundant/ineffective systems
• Conceptualize technical solutions to complex problems and maximize benefit of IT systems investments. Work closely with clients to gain organizational commitment for all systems and software plans, as well as evaluate and guide the selection of technologies required to complete those plans
• Coordinate with offshore development team(s) to identify priorities and update scope and delivery schedule
• Create data migration/system integration strategies

Environment: COBOL, JCL, DB2, VSAM, CICS, Changeman, QMF, Eztreive, File-Aid, effective SORT cards.

Confidential

Mainframe Lead Developer and Tech Lead

Responsibilities:

• Involvement in different phases of SDLC i.e. analysis, design, testing and creation of respective documents during an enhancement project.
• Creation of High level and Low level design documents as per the business requirements.
• Coding many Cobol and DB2 programs as per the low level design documents.
• Involved in Unit level and Integration level testing.
• Involvement in rollout activities i.e. deployment of the packages.
• Creating effective Procedures for generating the ability to reuse the existing code effectively.
• Several Mock tests and prod parallel testing were carried out to ensure all applications complete regression tests successfully.
• Implemented the DB2 checkpoint routines wherever required to enhance the processing capability of millions of customer’s account information stored in the databases.

Environment: COBOL, JCL, DB2,Native SQL, VSAM, Changeman, QMF, Eztreive, File-Aid, TWS, Service Now

Confidential

Team Member & Tech Lead

Responsibilities:

• Participating in user requirement sessions to gather business requirements.
• Involved in Development, Integration and Testing of application modules.
• Developed DB2 Query optimization techniques for faster processing and retrieval of data.
• Developed stored procedures and triggers with DB2 and optimized the database updates.
• Implemented consistent summarization of data using a file based approach with the aid of powerful sort cards.
• Involved in active communication with the business for the decommissioning of unwanted, temporary and old datasets.
• Reduced the Technology infrastructure costs by moving the archaic data from disks to tapes using IEBGEBER utility.
• Handled the upstream file’s data cautiously through effective GDG creations using IDCAMS utility.
• Optimized the DB2 table designs by dropping the partitions in the least frequently accessed tables using file based approach.
• As part of Confidential Smith Barney joint venture, we had to undertake the below activities so as to support data migration of 5 applications
• Analyse the application databases in scope for migration on both Confidential & Smith Barney
• Prepare data mapping charts with field to field mapping from source to target.
• Indulge in meetings with business and all stake holders to conclude on data conversion algorithms for data elements that need conversion.
• Design individual data extract & data conversion processes for each database to unload data from source, run all conversion processes using various cross reference tables and arrive at final load ready file for the destination databases
• Load the final file into target database and send data conversion statistics upon conclusion.
• Run reconciliation processes to validate the data conversion results and look for data anomalies

Environment: Cobol, JCL, DB2, VSAM, Changeman, QMF, Eztreive, File-Aid, Jobtrac, effective SORT cards.