Candidates About

 

Sidharth Shankar

SUMMARY:

·         Associated with Tata Consultancy Services as a Lead Technical Analyst for almost 9 years in Mainframe Technology.

·         Having almost 4 years of direct interaction/work experience with Customers at Onsite (USA).

·         Having 9+ years of experience in leading and managing various Banking & Finance, Capital Market and Retail domain projects.

·         Got opportunity to work with Citi Bank, Banco Popular, Morgan Stanley, Fidelity Investment and HBC.

·         9+ years extensive experience in development and implementation of database design, program coding, enhancements, implementation, deployment, software support, quality testing and Production support.

·         Strong background in developing application software using COBOL, JCL, DB2, IOM, Dynamic SQLs, CICS, MQ, VSAM, NDM, MICROFOCUS, TSO, FILE-AID, QMF, SPUFI, CA7 and other Mainframe tools and utilities.

·         Having experience in application software development in Web-based environment, Distributed n-tier architecture and Client/Server architecture using various technologies, functional and integration testing.

·         Strong experience in Conversion project, involved migrating the data from db2 to Oracle (vice-versa).

·         Involved in analysis and modification of complex Batch/CICS Modules.

·         Experienced with Debugging tools like XPEDITOR, INTERTEST and Abend-Aid.

·         Modified the IOM which is used Channel and Container to pass the structured data via MQ to Web service.

·         Good experience with Version control tools like ENDEAVOR & CHANGE-MAN. Experience in Package creation, Migration & Installation of the impacted elements of change requests using version control.

·         A project-oriented team player with good communication, Presentation and Excellent Leadership Skills.

·         Performing in different roles as a Technical Lead, Senior developer proficient in obtaining project requirements from user and manager, formulating the requirements into design specs, preparing system specifications, assigning tasks to team members, and tracking the progress.

·         Provided work estimate document and MOM (Minutes of meeting) for walkthrough meetings.

·         Good understanding and practice of Quality Assurance Processes, Acquired knowledge through the Defect Prevention activities, Quality Control, Configuration Control, Coding Standards, Maintenance standards etc.

·         Projects involved feasibility studies, analysis of business problems, business requirements, cross functional analysis, data modeling, process modeling, development and implementation of software in the mainframe.

·         Expertise in the development of test plans, test cases, executing the test cases, test strategies variety of test levels, methodologies, test designs and testing techniques.

·         Proficient in implementation, project planning, execution, monitoring, risk assessment and resource balancing skills with ability to support multiple tasks and completing deliverables on time.

·         Involved in full life cycle of project implementations (SDLC) for various types of projects and Worked as SCRUM Team member which is part of agile methods & Supported and managed 4-5 people’s team.

·         Extremely well organized with proven ability to multi-task and prioritize workload. 

 

                                                              EDUCATIONAL QUALIFICATION

·         Master of Computer Application (M.C.A) in Information Technology from Ranchi University, India.

·         Bachelor of Science in Mathematic Honors from Ranchi University, India.

 

TECHNICAL EXPERTISE

Hardware:   Software, Languages & Tools:         Database:   Version Control:   Documentation:

IBM Mainframe – MVS/ESA, Z-OS, MS-DOS, Windows   COBOL, CICS, SQL, IOM, VSAM, MVS/JCL, SDF, IBM Utilities, TSO/ISPF, VM, IBM MQ, SQL, QMF, SPUFI, DFSORT, File-Aid, INTERTEST, PLATINUM, MICROFOCUS, ICAMS, TSO/ISPF, RUMBA, XPEDITER, FTP, PARM, ORACLE, JCLPLUS, STROBE, Connect Direct NDM, ICE TOOL, IBM WEBSPHERE, MQ and IBM MQ Series, Abend Aid, CA7, AIX, IMS, Sharepoint, Rational Developer for zOS, Channel and Container, MS-DOS, Lotus Notes, MS Office, EASYTRIEVE, HP Quality Centre, IBM utilities, PL/SQL, ETL and SQL.   DB2, ORACLE 11g   CHANGE-MAN, ENDEAVOR   Microsoft word, Excel, Power Point, Visio

 

 

 

PROFESSIONAL EXPERIENCE

 

 

·         Working in Tata Consultancy Services as Sr. Mainframe Developer from May 2008 to till date. 

 

 

 

 

 

PROJECTS

 

Hudson’s Bay Company: Sales Audit Finance                                                                                                  Feb 2017 – Till date

Mainframe Tech Lead

 

Client: Hudson’s Bay Company, USA

Skills: COBOL, JCL, IOM, VSAM, DB2, CICS, MQ, Channel & Container, FILE-AID, and other Mainframe tools and Utilities

Project Location: MS (USA)

 

Hudson’s Bay Company (TSX: HBC) is one of the fastest-growing department store retailers in the world, based on its successful formula of driving the performance of high quality stores and their all-channel offerings, unlocking the value of real estate holdings and growing through acquisitions. Founded in 1670, HBC is the oldest company in North America. HBC’s portfolio today includes ten banners, in formats ranging from luxury to better department stores to off price fashion shopping destinations, with more than 460 stores and 66,000 employees around the world.

In North America, HBC’s leading banners include Hudson’s Bay, Lord & Taylor, Saks Fifth Avenue, Gilt, and Saks OFF 5TH, along with Find @ Lord & Taylor and Home Outfitters. In Europe, its banners include GALERIA Kaufhof, the largest department store group in Germany, Belgium’s only department store group Galleria INNO, as well as Sport arena.

 

·         Involved in various project meetings and review the Functional requirement and Business requirement documents along with Business team.

·         Review Business Requirements document, provide the inputs to Business Analyst on Approach and attend Approach walkthroughs.

·         Responsibilities include designing, developing, debugging, coding, writing specifications and other assigned duties related to programming.

·         Deliver new and complex high quality solutions to clients in response to varying business requirements.

·         Support, enhancement or Maintenance of existing applications.

·         Handled a five member’s team at offshore.

·         Co-ordinated the development and testing tasks between onsite and offshore.

·         Managing teams with Coding, code reviews, Unit, System testing, Development and implementation of various critical projects.

·         Creates various COBOL/CICS/DB2/VSAM/MQ programs for online/batch processing.

·         Create JCL and Proc with various utilities like SYNCSORT, IDCAMS, IEBGNR and IEFBR14.

·         Setup QA and PRODUCTION JCL AND PROCS.

·         Created business document for project life cycle.

·         Complete analysis of the System to create the High Level and Low Level design documents.

·         Verified program logic by preparing test data for trial runs, test and debugs programs.

·         Involved in preparation of unit test plan, system test plan and test data and executed the test cycles.

·         Execution of test scripts in quality center and Defect tracking through Quality center.

·         Review unit tested the entire functionality & performed Regression testing.

·         Performing configuration management by using the ENDEVOR.

·         Used debugging tools like Expediter & Abend-Aid, db2 maintenance through SPUFI, QMF & DB2I.

·         Used job scheduling tools like CA7 for dependencies.

·         Involved in monitoring the jobs through SAR & SDSF.

·         Involved in coordination with interface teams in UAT and SIT phases of the project.

·         Provided complete support for the implementation and post implementation verification in production environment.

·         Presented various Mainframe process improvement opportunities, cost savings ideas and automation tools to Clients and successfully implemented.

 

 

FIDELITY INVESTMENT: Plan Record Keeping (PRK)                                                                                   June 2014 – Jan 2017

Mainframe Tech Lead/Analyst

 

Client: Fidelity Investment, USA

Skills: COBOL, JCL, IOM, VSAM, DB2, CICS, MQ, Channel & Container, FILE-AID, and other Mainframe tools and Utilities

Project Location: NC (USA)

 

Fidelity Investments is an American multinational financial services corporation. It is one of the largest mutual fund and financial services groups in the world. Fidelity personal, workplace and institutional services are the largest provider of 401(k) retirement plan services in one country. Workplace offers everything that need to help to run an efficient, successful retirement plan that attract and retains key talent and helps employers prepare for comfortable retirement.

Fidelity Defined contribution (DC) Plan Record Keeping (PRK) under this project Fidelity has number of DC applications used to maintain plan level data – AAROW, WPDT and PAM.

 

 

·         Involved in various project meetings and review the Functional requirement and Business requirement documents along with Business team.

·         Review Business Requirements document, provide the inputs to Business Analyst on Approach and attend Approach walkthroughs.

·         Responsibilities include designing, developing, debugging, coding, writing specifications and other assigned duties related to programming.

·         Deliver new and complex high quality solutions to clients in response to varying business requirements.

·         Support, enhancement or Maintenance of existing applications.

·         Handled a five member’s team at offshore.

·         Co-ordinated the development and testing tasks between onsite and offshore.

·         Managing teams with Coding, code reviews, Unit, System testing, Development and implementation of various critical projects.

·         Involved in analysis and modification of complex Batch/CICS Modules.

·         Created business document for project life cycle.

·         Complete analysis of the System to create the High Level and Low Level design documents.

·         Verified program logic by preparing test data for trial runs, test and debugs programs.

·         Involved in preparation of unit test plan, system test plan and test data and executed the test cycles.

·         Execution of test scripts in quality center and Defect tracking through Quality center.

·         Review unit tested the entire functionality & performed Regression testing.

·         Performing configuration management by using the ENDEVOR.

·         Used debugging tools like Expediter & Abend-Aid, db2 maintenance through SPUFI, QMF & DB2I.

·         Used job scheduling tools like CA7 for dependencies.

·         Involved in monitoring the jobs through SAR & SDSF.

·         Involved in coordination with interface teams in UAT and SIT phases of the project.

·         Provided complete support for the implementation and post implementation verification in production environment.

·         Assisted Client during any phase that is applicable to the project as per the project plan.

·         Presented various Mainframe process improvement opportunities, cost savings ideas and automation tools to Clients and successfully implemented.

·         Successfully delivered various key critical projects with high quality, zero incident report after Post implementation and got appreciation from Senior Management for 95% reduction of abends in SIT and UAT Batch cycles.

 

 

MORGAN STANLEY - CAPITAL MARKET – profit and loss (PNL)                                                     Aug 2012 – April 2014

Senior Mainframe Developer

 

Client: Morgan Stanley, USA

Skills: COBOL, JCL, VSAM, DB2, CICS, MQ Series and other Mainframe tools and Utilities

Project Location: NY (USA)

 

Morgan Stanley Wealth Management is unique in being the only wealth management Firm to have its own independent capital markets platform. It provides fully integrated sales, trading and content. Our scope extends across multiple asset classes, providing differentiated and commercial content. Capital market consist the several modules like Order manager, Activity browse manager, Manager Approval, Profit and loss, and Global currency.

 

Profit and Loss is the module where it generates the report for Profit and Loss of every trade on daily basis based on the business date. It creates the report for several types of the products (Equity, Muni, Taxable, ABS etc.). The created reports which are monitored every day by the system analyst to have error free details. On daily basis, it calculates the principal, interest, yield, coupon for every trade.

 

·         Communication on daily basis with clients and offshore team.

·         Coordinated the development and testing tasks between onsite and offshore.

·         Analysis of functional specification received from the client.

·         Analyze Business requirement documents to create High level and Low level detailed design document.

·         Prepare estimates on deliverables.

·         Design, development, testing, implementation and documentation of assigned modules.

·         Involved in analysis and modification of complex Batch/CICS modules.

·         Created JCL, PROCS and Control Cards in all non-prod and production environment.

·         Worked on Capital Market and created many profit and loss reports.

·         Wrote specifications for Offshore team.

·         Used XPIDITER to test/debug batch jobs and INTERTEST for CICS programs.

·         Used SPUFI, QMF to inquiry DB2 tables.

·         Create JCL and Proc with various utilities like SYNCSORT, IDCAMS, IEBGNR and IEFBR14.

·         Creating ADHOC reports using Micro Strategy tool.

·         Use CA7 scheduler to create predecessor/successor job flows.

·         Used IBM utilities to copy file (IDCAM, GENER, SORT).

·         Write pseudo-code to explain diagram for developer.

·         Interact with designers to understand software limitations.

·         Writing Test Plans, Test Cases, Test Strategy, Traceability Matrix and Test Environment.

·         Work with interfacing applications to complete Integration Testing.

·         Performed different levels of testing, Functional, Unit, Integration, System, Regression and UAT testing.

·         Developed and Executed Positive and Negative QA Test cases on HP quality center for conversions testing.

·         Assist Clients during any phase that is applicable to the project as per the project testing plan.

·         Interact with customers for understanding the system, test objectives, questionnaire, test scenarios, SLAs, production metrics and engagement time lines.

·         Attend daily, weekly and monthly stakeholder and customer meetings to discuss about the current and future performance test engagements.

·         Performing in depth Trouble shooting to find out the issue.

·         Creating in db2 objects (tables, views, alias, indexes, and partitions), runstats, optimizing queries and programs for better   performance and running efficiently. 

·         Involved finding the root cause of the production issue.

·         Successfully delivered various critical projects and Performance Tuning.

 

CITICARDS: CUSTOMER COMMUNICATIONS – PLASTICS (EMBOSSING)                                          July 2009 – June 2012

Mainframe Developer

 

Client: Citi Bank, USA

Skills: COBOL, JCL, VSAM, DB2, CICS, NDM and other Mainframe tools and Utilities

Project Location: FL (USA) and Chennai (India)

 

 

The Citi Card’s Embossing system is responsible for producing Embossing files and the associated card carriers for the credit card issuance. Different types of plastics include Photo cards (credit cards that carry the photograph of the card member), Non-Photo cards, Fastcards (credit cards that reach the card member within 1 days of the request being placed).

.

• Created various COBOL/CICS/DB2/VSAM programs for batch processing of IBM System.
• Worked closely with business users to gather requirements and coordinate testing efforts etc.
• Responsible for converting the business requirements into detailed design document.
• Involved writing the TSD and low level data flow.
• Used XPIDITER to test the batch job.
• Used INTERTEST to test CICS modules.
• Involved for creating the MAP and modification of existing MAP.
• Involved creating JCL, PROC and Control card for various batch jobs.
• Involved in daily status call with onsite coordinator to understand the requirements, query and review the changes.
• Involved to support the SIT and UAT batch jobs.
• Used SPUFI, QMF to inquiry DB2 tables.
• Involved in development activities in Work Request / Change Request. Preparation of Unit Test Plan.
• Writing, executing test scripts for various projects.
• Performing regression testing.
• Responsible for database design, analysis and fine tuning.

• Involved in testing and ensuring all the applications are working properly.
• Involved in System test and User acceptance test.
• Work with interfacing applications to complete Integration Testing.
• Developed production rollover and back-out plan documents.
• Involved creating the package by using the version control like CHANGE-MAN.
• Defect management in all stages including Development, UAT, Production support.
• Responsible for production rollover and production support.
• Investigate and correct identified defects.

 

 

Integrated Deposit Application Reengineering                                                                                         July 2008 – June 2009

Mainframe Developer

 

Client: Banco Popular, Puerto Rico, USA

Skills: COBOL, JCL, VSAM, DB2, SPUFI, QMF, TSO/ISPF and other Mainframe tools and Utilities

Project Location: FL (USA) and Chennai (India)

 

Integrated Deposit Application is the core banking system of Banco Popular, Puerto Rico, serving the retail and commercial banking customers of BPPR. The objectives of the project involve the re-designing of the Integrated Deposit Application of the bank IDA is the heart of Core Banking System of Popular, any changes to IDA processes is likely to have impact across Enterprise Systems, Key Business Processes like Authorization, Internet Banking, Branch Banking and Tele-banking pass through several application systems / platforms before being processed in IDA. The scope of the current assignment is to re-architect the IDA system, which