SNEHA KUMBHARE : 408-***-**** : ****.********@*****.***
EXPERIENCE SUMMARY
•18+ years of progressive experience in System & Data Analysis, Development and Enhancement, Testing, Quality process, Performance tuning, Implementation and Support for various applications with an extensive knowledge of systems both batch and online.
•Extensive hands-on experience on BMC CONTROL-M Scheduling, JCL, COBOL, CICS, VSAM, SAS, Data warehouse, SQL, DB2, FOCUS, WEBFOCUS.
•Hands-on experience on Legacy Systems (Mainframes) on OS/390 platform and Z/OS.
•Hands-on experience on testing & maintaining Data warehouse & User Reporting.
•Hands-on experience on DB2, GreenPlum, Sybase, SQL Server and Oracle 11g.
•Provided L2 level of support for various applications Production environment.
•Experience in domains like Asset Management, Investment Banking and Insurance.
•Diagnostic Ability - Ability to go to the core of the problem analysis and resolution.
•Excellent analytical and programming skills.
•A sharp skilled contributor to the solution, which is appreciated by customer.
•Has the capacity to work hard in order to meet the stipulated deadlines
•Strong in client interaction and inter-personal skills. Well versed with onsite-offshore delivery models.
•Has excellent work ethics and willing to learn and adapt to new challenges.
•Valuable Team Player with Mentor Skills, Ability to learn quickly and to correctly apply new tools and technology.
Technologies & Tools Used:
●JCL
●COBOL
●SAS
●WEBFOCUS
●CICS
●VSAM
●SDSF
●JES/JES2
●SELCOPY
●Control-M
●Endevor
●SCLM
●Changeman
●DB2
●Oracle
●GreenPlum
●Sybase
●SQL
●Microsoft SQL Server DB
●Rapid SQL
●SPUFI
●FileAid
●Advanced Query Tool (AQT)
●PG Admin III
●Embarcadero
●MQ
●Secure CRT
●WinSCP
●Putty
●Remedy
●ITSM (Service Now)
●Clear Quest
●JIRA
●SOAP UI
PROJECT SUMMARY
Charles Schwab Nov 2021- Till Date
Remote
Senior Mainframe Technical Analyst
Roles and Responsibilities –
●Support multiple QA environments and multiple applications, daily batches, job failures
●Work on BMC CONTROL-M extensively, perform scheduling, forecasting, provide operation support
●Day to day work involves JCL, COBOL, DB2, SQL, CONTROL-M scheduler, Changeman, file-aid, VSAM, Platinum, CICS, NDM, FTP
●Liaise with the application team to ensure communication and technical support for the project team as per requirement.
●Data Analysis and analyze end to end data flow
●Valuable Team Player with Mentor Skills, Ability to learn quickly and to correctly apply new tools and technology.
Technology Used: JCL, COBOL, VSAM, CICS, Service Now, JIRA, Changeman, BMC Control-M, PLATINUM, SharePoint, NDM, FTP, SFTP, SPUFI, FILE-AID, Microsoft SQL Server, Secure CRT, WinSCP, Rapid SQL, ClearQuest, DB2, Sybase, SQL, Oracle
JP Morgan & Chase June 2017 – Nov 2021
Jersey City, USA
Associate Vice President
Roles and Responsibilities –
●Support UAT environment and multiple applications, daily batches, job failures
●Work on BMC CONTROL-M extensively, perform scheduling, forecasting, provide operation support
●Day to day work involves JCL, COBOL, DB2, SQL, CONTROL-M scheduler, Changeman, file-aid, VSAM, Platinum, CICS, NDM, FTP
●Liaise with client & development team to ensure communication and technical support for project team as per requirement.
●Perform the requirements gathering, gap analysis, problem determination
●Data Analysis and analyze end to end data flow
●Valuable Team Player with Mentor Skills, Ability to learn quickly and to correctly apply new tools and technology.
Technology Used: JCL, COBOL, VSAM, CICS, Service Now, JIRA, Changeman, BMC Control-M, PLATINUM, SharePoint, NDM, FTP, SFTP, SPUFI, FILE-AID, Microsoft SQL Server, Secure CRT, WinSCP, Rapid SQL, ClearQuest, DB2, Sybase, SQL, Oracle
DTCC August 2015 – June 2017
Jersey City, USA
Sr. Mainframe Technical Analyst
The Depository Trust & Clearing Corporation (DTCC) is an American post-trade financial services company providing clearing and settlement services to the financial markets. It provides a way for buyers and sellers of securities to make their exchange in a safe and efficient way. It also provides central custody of securities.
Risk management is a big part of DTCC that deals with data analysis, calculation, reporting of risks and how to mitigate the risks. Data warehouse & UX Reporting are the pillars of this Risk Management.
Roles and Responsibilities –
•Liaise with client & development team to ensure communication and technical support for project team as per requirement.
•Perform the requirements gathering, gap analysis, problem determination
•Work with development team on Technical Specification & Data mapping for source vs target.
•Translate business requirement into developing software product using JCL, COBOL, DB2, and VSAM.
•Data Analysis and analyze end to end data flow
•Use client standard support/ docket i.e. ITDR, ALM, Clear Quest for tracking monitoring outage and issues/ defects.
•Weekly status reporting & provide detailed status report to the client.
•Analyzing, validating, comparing and reporting data from Sybase database to Data warehouse to UX Reporting
•Valuable Team Player with Mentor Skills, Ability to learn quickly and to correctly apply new tools and technology.
Technology Used: JCL, SPUFI, FILE-AID, Advanced Query Tool,
GreenPlum, Microsoft SQL Server, Secure CRT, WinSCP, BMC CA 7, PG Admin, Rapid SQL,
ClearQuest, Service Now, JIRA, Workflow Dashboards, SharePoint, DB2, Sybase, SQL, Oracle
The Northern Trust July 2012 – August 2015
Chicago, USA
Sr. Mainframe Analyst
Fund Accounting
Northern Trust is a leading provider of specialized financing and asset management services. We support and maintain their critical path applications used for back office financial accounting.
Fund Accounting (FA) deals with investment accounting, portfolio accounting or securities accounting. NAV – Net Asset Value & HPA – Hedge-fund Partnership Accounting are two important parts of Fund Accounting. Clients/Users are global for example London, US, Australia.
•NAV is a tool to audit, release and disseminate a fund’s NAV to interested parties. The NAV is the per-unit price of fund – the price at which a participant can buy into or sell-out of a fund. It can also calculate the NAV where the accounting system is unable to aggregate funds into a consolidated NAV calculation. HPA is a vended application from Fi-Tek LLC called HedgeTek. This application runs on a desktop and accesses an MS SQL Server 2005 database that runs on an MS Server Platform. HedgeTek perform different tasks such as entering trade information, setting up fund/investor, generating monthly statements. Most of programming is done in FOCUS and reports in WEBFOCUS.
Technology Used: FOCUS WEBFOCUS, COBOL, JCL, JAVA Basics, DB2, MQ, SDSF,
SCLM, JES, JES2 & JES3, CICS, CONTROL-M & Remedy, Sharepoint.
Roles and Responsibilities - Team Lead & Senior Developer
•Liaise with client to ensure communication and technical support for project team both at on site and offshore are as per requirement.
•Identify pain areas of client and convert it into new business opportunities. Perform requirement gathering, analysis and design for business requests.
•Produce various FOCUS reports for many clients on a legacy mainframe and establish a method of transmitting these reports to either a server for display, or e-mail directly from the mainframe to the user.
•Utilization of FOCUS & WEBFOCUS in the MRE (managed reporting environment) to manage and develop reports as required.
•Designed, developed and maintained WEBFOCUS reports and programs.
•Implemented improvements in WEBFOCUS reports as per business requirements.
•Translate business requirement into developing software product using FOCUS, WEBFOCUS, COBOL, DB2, and JCL.
•Use client standard support/ docket i.e. remedy, Incident (Service Now) for tracking monitoring outage and issues/ defects
•Weekly status reporting & provide detailed status report to the client.
The Northern Trust March 2008- July 2012
Chicago, USA
Sr. Mainframe Developer
FEE & Profitability
Northern Trust is a leading provider of specialized financing and asset management services. We support and maintain their critical path applications used for back office financial accounting.
Fee+ calculates, bills, and posts trust custody, management, and transaction fees for Personal Financial, Corporate & Institutional, and Northern Investment Services business units. Fees are based on point-in-time asset valuations, transaction volumes, one-time services, and flat rates.
Technology Used: COBOL, JCL, DB2, FOCUS, WEBFOCUS, SCLM, SAS, SDSF, JES, JES2,
JES3, CICS, SharePoint, Datastage ETL tool, CONTROL-M, Remedy.
Roles and Responsibilities - Team Member, Team Lead:
Team Lead:
•Liaise with client to ensure communication and technical support for project team both at on site and offshore are as per requirement.
•Identify pain areas of client and convert it into new business opportunities. Perform requirement gathering, analysis and design for business requests.
•Translate business requirement into developing software product using FOCUS, COBOL, DB2, SAS and JCL.
•Worked on data warehouse concepts, SQL- Joins, sub queries, etc, star & snowflake schemas.
•Solve production issues quick fixes Incidents, Prepare UTP and UTR as per project guidelines, Code review.
•Worked on FOCUS upgrades, Disaster recovery.
•Development & maintenance of financial reports in Managed Reporting using FOCUS & WEBFOCUS.
•Worked on migration of WEBFOCUS release from 7.1 to 7.7.03. Modified & Tested 1000+ reports.
•Use client standard support/ docket i.e. remedy, Incident (Service Now) for tracking monitoring outage and issues/ defects
•Independently worked on Apps other than Fee Plus such as Revport & Wealth Advisory Fee Management that involves UNIX basics & Rapid SQL.
Team Member
•Solving user queries.
•Working in 24*7 supports using onsite/offshore model.
•Unit test and User Acceptance Test for all the deliverables.
•Responsible for development, support and maintenance of COBOL, DB2 Modules, SAS programs.
Achievements: Throughout my tenure with Fee Plus, the work was greatly appreciated by business users & client managers. Some of the key projects handled during my onsite stay and were appreciated by customers to an extent where we bagged new business from the customer.
Royal & Sun Alliance Insurance Group Aug 2006 – March 2008
India
Mainframe Developer
Royal and Sun Alliance-Management Information System (RSA-MIS)
RSA in the UK with a premium income of £5091 million, some 23,000 employees and it’s business based in more than 20 key locations, is one of the UK's largest financial services companies, providing innovative, leading-edge products to customers in the UK. MIS is the one of the core systems in RSA that gets its feed from all other systems like SAUNA, CLAIMS etc., and maintains in DB2. MIS maintains all the management-related information and produces appropriate reports to management regarding each and every system. Responsible for any amend in the production runs of Morpheus, TSUNAMI and all enhancement and maintenance of the MIS system.
Technology Used: COBOL, JCL, SDSF, REXX, SELCOPY and ENDEVOR
Role: Programmer/Analyst
Responsibilities:
•Analysis & conversion of JCL & control cards.
•Qualitative Analysis of the converted programs, JCL & control cards.
•Unit testing of batch & online programs as per the unit test plans given by onsite team.
•Analysis & conversion of Batch & online programs in COBOL.
•Requirement understanding
•Writing test cases for requirements, Designing & execution test cases
•Give regular feedbacks to the project manager and team members to get them better day-by-day.