Onsite Offshore Coordinator/system Analyst/ Senior Mainframe Developer Resume
SUMMARY:
- Over 6.5 years of experience as an IT Professional with Project Management, Business analysis, System Analysis, Design Architecture, Development/Coding, Testing, Maintenance (Enhancements and Change Requests) in the manufacturing and insurance Domain.
- Over 4.5 years of Project management experience, leading, Mentoring, coordinating with teams in an Onsite-Offshore model.
- Proven System Analyst Insurance Billing, Agency Commissions and Agency Performance (Bonus) application systems.
- Extensively worked on IBM Mainframe technologies using COBOL, JCL, DB2, VSAM, CICS.
- Extensively worked with various tools SPUFI, Insync, Smart Test, Endeavor, PDM, OPC and Dump Master.
- Extensively worked through the phases of Software Development Life Cycle (SDLC): analysis, design, development, testing, implementation, enhancement and Maintenance.
- Sound experience in writing Functional Requirements, Design documents, programming specifications, Unit Test Cases and System Test cases.
- Extensively involved in Production Support (24x7) and fixing the problems.
- Proficient in Leading, Mentoring and managing teams throughout the SDLC lifecycle.
- Proficient in stake holder expectation management, Scheduling, Prioritizing, Decision making, Problem solving, Time management, process improvement and Negotiation.
- Strong technical background and excellent interpersonal skills with an ability to interact with individuals at all levels.
- Highly accomplished at organizing and facilitating one-on-one discussions, workshops, and requirement elicitation sessions.
- Self-motivated with an ability to work independently to meet operational deadlines in a demanding fast-paced environment.
- Good intercommunication skills to work with all levels of management.
EDUCATIONAL QUALIFICATIONS:
- Masters Certificate in Project Management Confidential,University
- Bachelor Degree in Computer Engineering Confidential,University
CERTIFICATIONS:
- Project Management Professional (PMP)
- Sun Certified Java Programmer version 1.3
SOFTWARE SKILLS
Mainframe technologies:
Z/OS, OS/390, COBOL II, INSYNC, OPC, IDCAMS, TSO/ISPF, TSO/MVS, ASG-SMARTEST, Endeavor, RACF, SPUFI, JCL, CICS, JES2, SQL, DFSORT, SYNCSORT, IBM Utilities, ICETOOL, DUMP MASTER, PDM, HNET, SDSF.
Databases:
DB2, MS Access, VSAM
Operating Systems:
MVS/ESA, OS/390, Z/OS, Windows 2003/NT/XP/VISTA
Microsoft & other Technologies:
Java, C, C++, HTML, XML, UML, MS WORD /EXCEL/ ACCESS/ POWERPOINT/ VISIO/ PROJECT, VSS, FTP
PROFESSIONAL EXPERIENCE:
Confidential,Company [Jan 2008 - Till date]
Role: Onsite offshore Coordinator/System Analyst/ Senior Mainframe developer
Platform: IBM z/OS
Application: Corporate Billing System
Description: The Billing System calculates payment plans, develops the billing schedule, accepts certain policy and payment information, tracks equity and creates billing documents including invoices, withdrawal notices, refund checks, cancellation notices and confirmations. This system has external interfaces to the Bank for lockbox and EFT, Bill matrix for credit card processing, Collection Company and various internal interfaces to Policy administration systems, Finance, stat and claims systems.
Application: Agency Management Systems
Description: The system has following Sub-systems:
- Agency Master – This system stores and maintains Agency General and Processing Information.
- Commission System – This system maintains assigns commission rates for various agents that write Business in Harleysville.
- Bonus - This system calculates the bonus to be paid to the agency based on the business conducted by them during the year.
- Download – This system sends policy information from the Policy Management systems to agents in ACCORD AL3 format to download through their IVANS mailbox.
- Expiration – Stores and reports all the agencies written by the company.
Summary of Important projects:
Project # 1: Lockbox
Project was to switch check processing operations from in-house to an external bank. Collected requirements, designed, developed and implemented the switch in Phases to mitigate risks.
Project # 2: Direct Bill Online Administration
In this project a new sub system was created to allow real time processing of billing administrations functions.
Project # 3: Installment schedule generation on policy quotes
To create an interface to provide the insured/customer with a view of various payment options to choose installment plans from.
Project # 4: Tie in Dashboard
To consolidate a one page MS excel report of all payments and premiums. Collected requirements designed and implemented an automatic tie in process. This project was implemented in phases to first create a DB tie in report and then another phase to tie in DB with General Ledger for a complete end to end tie in solution.
Project # 5: Billing Commissions Upfront
Changes were made in Billing to pay upfront commissions to the agent, instead of paying commission when each installment is paid by the customer, the upfront information was obtained from the Agency Master and Commission upfront information was processed in the Finance and commission systems.
Project # 6: Credit card Processing
Changes to Billing to accept a Credit Card payments feed from the credit card processing vendor Bill matrix, involved creating new job streams to FTP, convert to billing system specific format to apply to bill accounts and create feeds for the general ledger as well as a real time interface to view the credit card payments entered.
Project # 7: Split Account Resolution
This year long billing sponsored project was divided into 3 phases. Unavoidable circumstances in the policy administration system lead to splitting of Bill accounts, causing multiple Bills to issue creating confusion and customer dissatisfaction. Designed solutions for merging split invoices, split account payment application, automatically switching refunds and handling suspense error correction for split accounts.
Project # 8: Acknowledge Memo and Actual Cash
This sub-system acknowledged New Business down payments to waive the installment fees on the first installment, New interfaces (Additional files were interrogated, services were called) to acknowledge Memo cash. Designed and implemented changes to the system to update Audit trail and Billing invoices for the acknowledge cash.
Project # 9: Commercial Lines EFT
Created interfaces to the Agent Portal from the billing system to give agents the capability to manage EFT information for its insured’s.
Project # 10: Chosen Due Day
To allow the customer to choose a policy account due day for; Changes were made to various aspects of the system right from setting the due day, adjusting the remaining installments to automatically setting the due day on new policies added to the system.
Project # 11: Insured Paid agent Hold
Created a new interface to the Agent Portal to prevent policies from going to nonpay by creating an interface between Agent Portal and Billing to allows the agency to enter payment information to put policies on Hold (from going to nonpay).
Project # 12: Commission Interface
This project was to expose a service from the commission system to the AQS Policy administration system to aid in commission expense reduction.
Project # 13: Kaplan Inquiry and Update
Designed new screens to display Kaplan information from the Kaplan SQL Data base in CICS via the use of inquiry and Update services and providing the system users with a way to view Kaplan agency and producer licensing information in CICS.
Project # 14: New Bonus Contract
Collected requirements designed and implemented changes to the Bonus system to create XML spreadsheets for a new Underwriting Profit bonus contract, also designed testing processes and templates for testing future changes to the various factors to reduce future testing time.
Project # 15: Agent entered Commissions
Provided Marketing with a way of increasing commissions by a few points based on whether commercial lines policies were entered by an agency. Designed new DB2 tables and screen flows, created Technical Specs and implemented various enhancements to the commissions system.
Project # 16: Commission Contract tiers
Made provisions in the commission system to assign an agency to different commission tiers of a state based of the agent appointment date, also added provision to allow the user to change the tier, this was used as a way to have more competitive commission rates, changes involved adding new tables and new screens to store and to display the commission tiers and reassigned tears.
Project # 17: Commission system
Increasing the number of unique commission rates the commission system can hold from 197 to 997 to make way for assigning commission rates for an Insurance product rollout.
Responsibilities:
- Lead small and midsize projects, managed a team of 7 associates.
- Responsible for managing the Development, maintenance and support (24X7) to achieved the highest level of customer (end user) acceptance and satisfaction within Service Level Agreements (SLA).
- Created project plans, schedules and Lead project detailed design phases, identifying, tracking and resolving technical issues -- Ensuring solution is in scope, on time and within budget.
- Designed and managed the development and implementation to automate payment error correction, reducing manual effort by 30%.
- Designed and implemented solutions to improve straight through payment processing in Billing.
- Designed and managed the development of strategic tightly scheduled marketing initiatives to enhance the Agency commissions and bonus applications to increase business.
- Lead a team to optimize production nightly mainframe batch cycles.
- Coordinated with various stake holders to document Business and functional requirement and created functional, design, and technical specifications.
- Used detailed knowledge of application features and functions to assess scope and impact of business needs.
- Managed changes to the project scope, project schedule, and project costs using change management procedures.
- Conducted business walkthroughs to generate consensus, maintain quality, and resolve issues among different stakeholders during different stages of the SDLC.
- Managed stakeholders through effectively communicating project plans, progress, expectations, assumptions and dependencies in a timely and clear fashion throughout the project.
- As an Onsite Coordinator provided direction, expertise, feedback, and coaching to buildthe capability of Off-shore project team and other onsite coordinators.
- Program development using COBOL, JCL, CICS, VSAM, SYNCSORT.
- Developed new CICS screens (MAPS) and used TSQ\'s in online process.
- Involved in Code review, Test results review and documentation.
- Involved in Unit testing, online system testing, functional, integration and regression testing.
- Prepared Program/Job hierarchy flow-charts in VISIO for documentation.
- Estimated time and efforts for the Enhancements.
- Involved in UAT and helped business users to test the solution before implementation.
- Involved in internal reviews like code walkthroughs, inspection and unit-review tests of converted programs, copybooks and JCL’s etc. and review of quality control documents.
Development Tools: CICS, COBOL, VSAM, DB2, JCL, INSYNC, DUMP MASTER, Endevor, PDM, ASG-Smart Test.
Confidential,Company [Sep 2006 – Dec 2007]
Application: Corporate Billing System
Role: Team Lead/ Senior Mainframe developer
Platform: IBM z/OS
The Billing System calculates payment plans, develops the billing schedule, accepts certain policy and payment information, tracks equity and creates billing documents including invoices, withdrawal notices, refund checks, cancellation notices and confirmations. This system has external interfaces to the Bank for lockbox and EFT, Bill matrix for credit card processing, Collection Company and various internal interfaces to Policy administration systems, Finance, stat and claims systems.
Project #1: Direct Bill Fees
Coded and tested fee increase and at the same time moved from a hardcoded to table driven approach for Installment, Nonpay and NSF fees to speed future fee increases development.
Responsibilities:
- Lead and Mentored a team of 3 associates.
- Created Knowledge Capture documents
- Analyzed and coded programs in COBOL II / CICS / VSAM/JCL
- Implemented resolutions to production problems and improved the reliability of the applications.
- Interacted with clients and assess needs, identify key challenges and define project scope and deliverables.
- Created Functional and Technical Specifications (FS and TS).
- Analysis, design, & developments of various enhancements based on client requirements
- Prepared the test data and performed unit testing, integration testing and system functional testing based on business requirements, technical specifications and/or product knowledge.
- Analyzed common defect trends as part of the Defect Prevention Group (DPG) and suggested corrective action, process improvements, and code review checklists to reduce defects.
- Assisted with user testing of systems, developed and maintained quality procedures and ensured that appropriate documentation was in place.
Development Tools: CICS, COBOL, VSAM, DB2, JCL, INSYNC, DUMP MASTER, Endeavor, PDM, ASG-Smart Test.
Client: Confidential[May 2006 – Aug 2006]
Application: Atlas 3/CDE
Role: QA Tester/ Software Developer
Description: ATLAS3/CDE is a web based system which is used for quoting and issuing policies in Auto & Homeowners insurance Lines of business. The application provides role based access to the Agents, Employees of the Insurance Company and External Users, wherein the agents and the employees have access to quote and issue policies and the external users only have access to quotes. The system also provides a Report Ordering Engine which enables acquiring credit report of customers.
Responsibilities:
- Developed the test plan, test conditions and test cases to be used in testing based on business requirements and technical specifications
- Created Requirement Clarification documents for team member
- Prepared Design Document for the impacted maintenance modules.
- Pear review of the modules and documents developed and tested by the team to confirm with standards
Development Tools: CICS, COBOL, VSAM, File AID, JCL, Endevor, Expeditor, CoolGen.
Client: Confidential[Oct 2005 – Mar 2006]
Application: PH-MSS
Role: Software Developer
Description: Maintenance of an application used to handle all the major activities of a production system like Order entry, Invoice generation, Shipping, Part maintenance, Inventory maintenance, Purchase order, Electronic data control etc. To provide support for maintaining the system, the project was divided into two major activities.
The first activity supports client’s production system which included daily activities like abend tracking along with abend resolution.
The second activity included enhancement requests for better system performance and resolution of current problems.
Responsibilities:
- Modified and extended functionality of existing systems using Cobol and Telon
- Provided solutions to production problems
- Created unit test cases and performed unit testing
- Performed peer review on modules and documents created by team member
Development Tools: CICS, COBOL, VSAM, File AID, JCL, Endevor, Expeditor, Telon.