Prasad Vemulapalli

Prasad Vemulapalli Mobile: - ~ E-Mail:- Seeking freelance opportunities Career Overview A dynamic Website owner, blogger, marketer Software Professional with around 10+ years experience in developing/maintaining applications on mainframes, Project Leadership, Requirement Gathering, Delivery Management, Client & Management Interaction and Team Building / Mentoring. Insightful experience in project management activities including scoping, estimation, planning, risk management, finalisation of specifications, resource administration and quality management. A keen planner, strategist and implementer with demonstrated success in end-to-end project management and ensuring effective management of various resources to meet project specifications. Experienced in COBOL, MVS, CICS, DB2, JCL, VSAM, IMS, MQ Series, Endevor, Panvalet, Fileaid (VSAM, DB2), TSO / ISPF, IBM Utilities, Viasoft Smart Test, TELON, Platinum, Librarian, Expediter, SQL, SPUFI, QMF, REXX, ISPF / TSO, & RACF. Domain knowledge: Banking, Retail, Manufacturing, & Insurance. Skilled in Project Life Cycle Methodologies & Quality Methodologies (SEI-CMM5, ISO). Significant experience of working with Customers, Project Managers and Technical Teams for securing & executing concurrent projects. An effective leader with proven abilities in leading larger teams during the project phase and guiding team members and enabling knowledge sharing among the team. Employment Scan Apr’15 to Date Freelancing June’12 – Mar’15 with DSTWS, Hyderabad as S.S.E. Dec’08 – Nov’09 with Cognizant Technology Solutions Ltd., Netherlands as Senior Architect Aug’06-Nov’08 with Patni Computer Systems Ltd., Pune as Senior Software Specialist Aug’05-Jul’06 with Lion Bridge Technologies, Mumbai as Project Lead Dec’04-Jul’05 with Scandent Solutions Ltd., Bangalore as Team Lead Jul’03-Nov’04 with Waltech Inc., Marlboro, MA, U.S. as Consultant Oct’02-Jun’03 with Keane India Ltd., Hyderabad as Senior Software Engineer NOTABLE ATTAINMENTS At DSTWS got appreciation in recognition of excellent services from CIO of Brokerage Solutions At Cognizant Technology Solutions, Netherlands: Estimated, planned, streamlined and executed the Knowledge Acquisition of the mainframe systems successfully for client Rabobank at Utrecht Patni Computer Systems Ltd: Maintained business relationship with client ABNAmro bank and coordinated the development/maintenance activities from client location in Amsterdam Key Projects Handled: Refer to the annexure attached. Skill Set Business Process Management and Analysis Quality Management and Control Liaison / Coordination Resource Management Change Management SDLC / Framework Implementation Risk and Issues Management Team Management MANAGERIAL Mapping the requirements and providing customers the best solutions involving evaluation and definition of scope of project and finalisation of program / project requirements. Managing overall project activities including requirement gathering, preparing technical documents, resource & task scheduling, change management, manpower planning, etc. Providing end to end management of multiple projects from conceptualisation and visualisation to technology mapping and final execution of projects. Allocating resources among team members and guiding team members during the project till final delivery. Holding review meetings to monitor progress of the project as per schedule; ensuring timely completion & delivery of the project to the client. Providing high-end technical support on systems, managing incidents and ensuring high end-user satisfaction levels through prompt solution of their problems. TECHNICAL Operating Systems: MVS/ESA, MS-DOS, Windows 2000 / XP / NT Languages: VS Cobol-II, JCL, VS/Cobol, PL1, Java 2, PL/SQL, CSP Web Technologies: HTML, JavaScript, XML Database: DB2, Oracle 8i, IMS, VSAM Tools: Endevor, Panvalet, Librarian, REXX, Smart Test, Expediter, CA-Intertest, Platinum, Fileaid Utilities: JCL, QMF, SPUFI, ISPF/PDF, SQL, Expediter, CA-7, Coolgen, ZEKE, TELON Scholastics Bachelor of Technology in Mechanical Engineering from J.N.T.U. College of Engineering, Hyderabad in 1992 Certifications Agile Scrum Master L0: Banking & Financial Services Skillsoft certification in managing projects within organization ANNEXURE - PROJECTS HANDLED From March, 2015 Own and maintain Website, proficient blogger, motivated entrepreneur At Deloitte ISG Broker Production Support Type: Production Support Platform: Z O/S, Mainframes Software: COBOL, VSAM, DB2, CICS, IMS DB Client: Anthem, US Duration: Aug’16 to Oct’16 Role: Consultant Description: Anthem is second largest Health Insurance Provider whose mainframe systems were supported by earlier by UST which is being now transitioned to Deloitte. Anthem acquired many organizations whose systems are being integrated into one global system. There are three main functional areas, namely Enrolment, Billing and Commissions. ISG Broker is the system which calculates the commissions payable to the agents of Anthem. Responsibilities: Schedule Functional/Technical KT sessions with leaving vendor UST to acquire knowledge required for production support, document the daily/weekly/monthly jobs, monitor mock/production cycles, prepare the LO calendar and send daily hand off At DSTWS TRAC (Total Retirement Accountability Capabilities) Web Innovation Type: Support Platform: Z O/S, Mainframes Software: COBOL, VSAM, DB2, CICS Client: DST Corp, US Duration: Dec’13 to Mar’15 Role: Tech Lead Description: DSTWS provides 40% of backend support activities for Mutual Funds and Retirement Solutions, uses 6% of US postal Services. TRAC when started had only legacy applications in 3270, later developed Smart Desk which was developed in C/C++ and switched to pure Web Applications developed in Java. We are providing support for the TWI products. TWI has Sponsor/Participant Modules which were recently converted into web applications and not yet stable, so lot of issues arise due to inconsistence in the business logic employed in legacy applications and the web applications and thus require lot of maintenance. Responsibilities: Apart from resolving the issues on hand, reviewing team member’s code, ensuring quality by adhering to coding and quality practices, reporting the progress on daily basis, tracking the issues, preparing the Weekly Status Report, attending weekly status meetings with client. Subaccounting of Brokerage Solutions Type: Enhancements Platform: Z O/S, Mainframes Software: COBOL, VSAM, DB2, CICS Client: DST Corp, US Duration: From June’12 to Nov’13 Role: Tech Lead Description: DSTWS Brokerage Solutions provides sub accounting solutions also. The broker can buy mutual funds on behalf of few organizations or individuals together based on yesterday’s price, the price can go up or down creating either a negative or positive break, we introduced logic to avoid this nuisance break. As part of this an entirely new path was created in the cycle, which was built and implemented from scratch. Responsibilities: Apart from resolving the issues on hand, reviewing team member’s code, ensuring quality by adhering to coding and quality practices, attending Agile Daily Standup calls , tracking the issues, preparing the Weekly Status Report. At Cognizant Technology Solutions Ltd. IBM Cluster Type: KA/KT Platform: Z O/S, Mainframes Software: COBOL, VSAM, DB2, CICS, MQ Series Client: Rabobank, Utrecht, NL Duration: Since Dec’08 Role: Tech Lead /Assistant Manager Description: Rabobank has decided to outsource the maintenance of their mainframe applications to offshore. The knowledge about the existing system has to be acquired from the client and transferred to the offshore. There are about 22 systems in all developed in COBOL on mainframes. Once the KA/KT is complete Cognizant will be entirely responsible for the maintenance of these applications. Responsibilities: Estimating the effort required for the KA/KT activities for each application. Scheduling the technical knowledge sharing sessions with the respective SMEs. Reviewing the KA/KT documents. Coordinating with the bank resources to get the documents signed off. Estimating effort for the RFCs. Planning and executing changes. At Patni Computer Systems Ltd. SLB (Stop Licht Beheer) Type: Development Platform: Z O/S, Mainframes Software: COBOL, VSAM, DB2, IMS Client: ABN Amro, Amsterdam, NL Duration: Feb’08–Nov’08 Role: Onsite Coordinator Description: ABN Amro uses the SLB system to classify its clientele into three broad categories, green, orange and red based on their credit scoring. The green category as name indicates is the category of clients who have very good credit history and are eligible for all loans, those with orange are those with reasonable credit history and are eligible for selected but not all loans, of course those with red have very bad credit history and do not qualify for any loans. The business rules such as qualification of a client for review of credit history, setting the review date, demanding the collaterals, were being computed in the existing SLB system but now the computation of business rules is being moved to PROBE, a tool which will take the necessary inputs to compute the decisions. The scope of the present project comprises of the supply of the variables needed for the computation of business rules to PROBE & update SLB and CSD (Credit Scoring Database) databases using update variables supplied by PROBE. Responsibilities: Maintaining the QTS (Query Tracking Sheet) and resolve the offshore queries. Creating the document of understanding and present to the client. Converting the functional design into technical design and get sign off for the same, technical implementation plan, risk mitigation and contingency plan. Sales & Loans Type: Business Study and FMI Platform: Windows XP Software: Select Architect Component, MS Word, Microsoft Excel Client: ABN AMRO, Amsterdam, NL Duration: Apr’07–Jan’08 Role: Business Analyst Description: ABN AMRO uses an existing system for RF. This system is being redesigned under the EST program. The main project for Sales loans, EST Credits Vernieuwing Consumer Lending deals with changing several aspects of the system. ABN Amro uses an existing SEM (Strategic Execution Module) for new credit-Scoring demands within the program lending portfolios. This will be replaced by a Java based NBSM G3 (New Business Strategy Manager Generation 3). The channel Sales loans will connect to new Java based SEM for credit scoring. ABN AMRO proposes to develop a function layer to ensure that the new Front-end applications can interact with the re-designed Credit scoring. The function layer will receive the request for credit scoring from front-end systems, call the decision agent, store the credit score results in a database and return it to front-end application on need basis. Responsibilities: Participating in the Business Study phase of the sub-project as part of which will be responsible for creating the following deliverables during BS: PRL (Prioritized requirements List). SAD (System Architecture Definition). IT Implementation Check. Estimation for FMI-phase. Estimation for total project. Functional Description documents for all functions (U218's for all functions). Estimation DBI until Aftercare. Schedule DBI until Aftercare. Conducting Functional Model Iteration in coordination with the client’s Functional Experts and creating the following deliverables: Risk Log Implementation Plan Master Test Plan Updated Prioritised Requirements List Acceptance Criteria Risk Analysis Realisation Plan Case Control & CHD Type: Maintenance / Enhancement Platform: ZOS Software: PL1, NATURAL, ADABAS. Client: Thomson West, Eagan, MN Duration: Aug’06–Mar’07 Role: Project Leader Description: Thomson West Legal regulatory Services is the legal services division of Thomson West, the work requests are posted by the users through the 4HELP site from where they are fed in to the PVCS tracker database. The requests can vary by the type of request i.e. Enhancement, Maintenance, Development) or the severity like Show stoppers (which need to be resolved with in 8 hours after the they are posted.), Medium, Low. The documents could be either in printed in the form of digest, reporter, legal textbook or made available Online on Westlaw or could be made available on CD-ROM. Salient features of Case Control documents: There are over 14.6 million documents in CC database. There are over 31 million citations. 200,000 new documents get added and processed each year. 4.5 million new statuses and 130,000 new history links added each year. Over 10,000 reports run each year. Database is accessed over 180 million times a week (~10% of all CHD). It is a central repository built to store and organize head notes, along with their topic & key classification. Its main products are head note information for existing Digest products and other online services. Responsibilities: Creating metrics report (schedule variance, effort variance based on the desired, estimated and actual dates) for the use of client. Coordinating with the onsite team and got the necessary inputs and assign work to the team members. Helping the team in solving various technical issues. At Lion Bridge Technologies, Mumbai S2C (Service to Cash) Type: Development Platform: ZOS Software: COBOL II, VSAM, SAR, CICS, JCL, MAX, SPUFI, PANVALET, ZEKE, MQ Series Client: Beverly Corp, Fort Smith, AR Duration: Aug’05–Jul’06 Role: Project Leader Description: The Beverly Corp is an insurance major head quartered in Fort Smith, AR. Beverly has decided to change its front end to use .net technologies and UDB to be its database. Developed COBOL-DB2 applications which match and merge the resident profile information from db2 with that from the vsam files which contain the latest info. Apart from loading the master tables with initial data developed applications to update the facility, physician, resident, finance and spend down info. The project is necessitated as Beverly Corp is incurring huge losses on Medicaid patients whose eligibility can not be determined at the time of admission. The process involved in applying for Medicaid is tedious and takes 2 to 3 months, Beverly is trying to automate the admission process along with the Medicaid application process to avoid the delay in determining the eligibility and application for Medicaid. Responsibilities: Tracking issues and working towards their solution. Coordinating with the onsite team and obtaining the necessary inputs and keeping them updated with the project status. Helping the team in solving various technical issues. At Scandent Solutions Ltd., Bangalore CBS (Central Billing System) Type: Production Support Platform: MVS, OS/390 Software: COBOL II, VSAM, DB2, CICS, JCL, FILE AID, QMF, PSTT, MS Excel, Endevor, Panvalet, CA-7 Client: Liberty Mutual, Wausau, WI Duration: Dec’04-Jul’05 Role: Team Leader Description: Liberty Mutual Group is a diversified international group of insurance companies. Liberty Mutual has $64.4 billion in consolidated assets and $16.6 billion in consolidated revenue. The company ranks 116 on the Fortune 500 list of largest U.S. corporations, and it is the eighth-largest personal lines writer and the fifth-largest commercial lines writer in the U.S., based on 2003 direct written premium. Headquartered in Boston, Massachusetts, the Company employs 38,000 people in more than 900 offices throughout the U.S. The PLS( Personal Lines) processes Home, Auto, Watercraft and Umbrella policies coming from various inputs like manual entries, agency interfaces, web based PLIQ(Personal Lines Internet Quote). It also takes care of underwriting these policies and storing them in policy in force file. An offshore team comprising of 4 members provides 24x7 production support for the Personal Lines System module from Bangalore, India. Responsibilities: Analysing dump and determining the reason for the abend and fixing the abend. Coordinating with the onsite team through teleconference or webex, gathering the inputs and assigning work to the team members. Reporting the daily, weekly work status. Advising the team on technical issues. At Waltech Inc., Marlboro, MA, US Logistics Replenishment Type: Maintenance Platform: MVS, OS/390 Software: COBOL II, VSAM, DB2, CICS, JCL, FILE AID, QMF, PSTT, MQ Series, MS Excel, Endevor, PANVALET, CA-7 Client: CSC, Lowe’s, Wilkesboro, NC Duration: Jul’04-Nov’04 Role: Consultant Description: With sales of $26.5 billion, Lowe’s Company Inc., is the worlds is the second largest Home Improvement Retailer in U.S. Lowe’s is the twelfth largest retailer in U.S. Lowe’s has 1,30,000 employees and 9,000 stores spread over 45 States. At Lowe’s companies, Logistics can be defined as the method of procuring inventory, transporting inventory and replenishing inventory. Store employees and Customer Support Centre employees coordinate with manage inventory assets through replenishment systems. Responsibilities: Maintaining applications for replenishment department of Logistics Division. Analysing, designing, preparing specifications for new applications & all applications for current date disaster. Correcting the restart instructions for abending jobs. Changing jobs to confirm to Lowe’s standards. RAN Field Expansion Type: Enhancement Platform: MVS, OS/390 Software: OS/390, COBOL II, VSAM, DB2, CICS, JCL, FILE AID, QMF, IMS, MQ Series , MS-Excel, VIASOFT Smart Test, Endevor, MQ Series Client: IBM Smyrna, TN Duration: Jan’04-Jun’04 Role: Consultant Description: Nissan Logistics Centre, the IT Division of Nissan Motor Manufacturing Company at Smyrna has leased its IT development and maintenance to IBM for ten years starting from 1999. The present project basically involves expansion of the RAN (Release Authorization Number) from 7 bytes to 8 bytes. Involved in the RAN expansion project for NLC Spain, which is newly added as parts supplier. Responsibilities: Analysing the applications for RAN expansion. Preparing various documents viz. analysis and design document, program specifications, Function point document. Changing the applications to include Spain along with Japan, Brazil and Mexico as parts supplier. Preparing test data for Spain for which no previous data was available. Performing Unit Testing & System Integration Testing. CICSHA (CICS High Availability) Type: Enhancement Platform: MVS, OS/390 Software: COBOL II, VSAM, DB2, CICS, JCL, FILE AID, QMF, IMS, MS-Access, MS-Excel, FTP, Platinum, Expediter, Librarian. MQ Series Client: ISD, WALMART, Bentonville, AR Duration: Jun’03-Dec’03 Role: Consultant Description: Wal-Mart is the biggest retail company in the world. The ISD (Information Services Division) of Wal-Mart decided to make their CICS applications highly available for the users in all eventualities. This objective is basically achieved by making the applications independent of the terminal on which they are running, which involves changing TSQs, TDQs and removing APPLIDs, STARTs with terminal IDs and CWAs. Adopting following strategies in making the necessary changes. Placing the TSQs in a FOR (File owned region) or Coupling Facility, which typically involves changing the length of name of the queue from existing 8 byte naming convention to 16 byte one. Binding the transaction to the same terminal for its life. Replacing the TSQs by scrollable cursors. Responsibilities: Handling download tables into test region using platinum tools. Making necessary changes to make the applications HA compliant. Performing Unit Testing & UAT (User Acceptance Testing). At Keane India Ltd., Hyderabad NABISCO Type: Maintenance Platform: MVS, OS/390 Software: COBOL II, VSAM, DB2, CICS, JCL, FILE AID, QMF, MS-Access, MS-Excel, FTP Client: Farley’s and Sather’s, Round Lake, Minnesota Duration: Oct’02-Jun’03 Role: S.S.E. Description: Nabisco Inc. is a $8.27 Billion company, head quartered at New Jersey, is the client with name to reckon within U.S. having around 50,000 employees around the world. Farley’s and Sather’s is one of the leading manufacturers of biscuits, snacks and other premium food products and markets products in the U.S., Canada and eight other countries. Nabisco necessities this project as it took over Farley’s and Sather’s. The project is to enhance and maintain the Sather’s System applications. Responsibilities: Preparing Program Specifications. Coding online and batch programs (COBOL). Handling the maintenance of QA standards. Performing Unit Testing.