Programming Language

- Core Java, VS-COBOL II 3.2, JCL, CICS, CLIST, TSO/ISPF, SQL, REXX, File-Aid, IBM VAGen 4.5, C and C , VB 6.0

RDBMS

- DB2 UDB, VSAM, Oracle 8i, mySQL, Teradata, SQL, PL/SQL

Big Data Technology

- Cloudera, MapR, HortonWorks versions of Hadoop, HDFS, Map-Reduce, Hive, Pig, Knowledge on HBase NoSQL , Zoo Keeper, Sqoop, Flume, Oozie workflow etc.,

Operating System

- Unix basic level , Ubuntu Linux basic level , Windows, z/OS, MVS, MS DOS

Development Tools

- Eclipse, PuTTY, FileZilla, WinSCP, Toad for DB2, Toad for Oracle, SAR, QMF, SPUFI, CA-7, ESP Encore, Connect Direct NDM / FTP , BMC Utilities, File-Aid Utility, PEGASYS

Web Services

- XML

Configuration Management Tools

- ELIPS Librarian , Module Coordination System MCS , Panvalet, Changeman, Endevor

Incident Management Tools

- Infoman, HP Open view, CA Unicenter, HPSM, Heat

Defect Management Tools

- HP Quality Center, BMC Remedy

Confidential

Role: Hadoop Developer

Summary: Online Policy Changes project will enable the customers of The Hartford Insurance to maintain their policies online and invoke changes real time. There is no online capability at this time available to maintain a policy and this puts the organization in the back foot with the competitors. This project is targeted for all the channels AARP, Agency and Consumer Direct and will be implemented in phases.

Technology: Java, HTML, JQuery, Enterprise Architect, ERWIN, , Pig, Sqoop, Flume, Zoo Keeper, Oozie workflow, Oracle, DB2, HBase

Key Responsibilities:

• Loaded the customer profiles data, customer claims information, billing information etc onto HDFS using Sqoop and Flume.
• Built data pipeline using Pig and Java Map reduce to store data onto HDFS.
• Used Oozie to automate workflow and map reduce jobs.
• Used Pig to do transformations, event joins, and some pre-aggregations before storing the data onto HDFS.
• Used Hive to analyze the partitioned data and compute various metrics for reporting on the dashboard.

Confidential

Confidential

Role: Hadoop Consultant

Summary: The goal of this pilot project is to send out personal communications targeting to members prescribers based on member claims fill history. The project aims at sending messages to members physicians in different channels like Letter, IVR, Fax and Text, thereby making the member adhere to a prescribed medication. This project analyses the trend for members who are targeted Vs those members that are not targeted and comes up with market opportunities and areas of improvement to the upper management.

Technology: Java JDK1.6 , Linux, Cloudera Hadoop, HDFS, Map-Reduce, Hive, Pig, Sqoop, Flume, Zoo Keeper, Oozie workflow, DB2, HBase

Key Responsibilities:

• Loaded member claims data to HDFS file system using Sqoop Flume.
• Created Pig, Hive scripts for data analysis.
• Developed Java Map-Reduce programs to do trend analysis of targeted Vs non-targeted members.
• Worked on HBase NoSQL database.
• Used Hive to analyze the partitioned and bucketed data and compute various metrics for reporting on the dashboard.
• Loaded the aggregated data onto DB2 for dashboard reporting to upper management.

Confidential

Confidential

Role: Technical Consultant / PM

• Summary: CVS Caremark Corporation is one of the leading Pharmacy Benefit Management PBM and healthcare companies that operate into Healthcare services and Online Pharmacy and Medicare.
• CNP is a mainframe and java based system used by Caremark's clinical division to send out communications to beneficiaries based on drug program defined by Caremark Pharmacy Benefits Managers PBMs . CNP receives adjudicated claims from Enterprise Data Warehouse EDW and Finance on a daily basis.
• As a Technical Project Manager, my responsibilities deal with Client interaction, Requirement feasibility analysis, managing the team, attending meetings, risk analysis/mitigation etc.,

Technology: IBM MF z/OS, COBOL, JCL, CICS, DB2, File-AID, Xpeditor, Change Man, HP Service Manager, Heat, Clarity, HP Quality Center, TWS.

Key Responsibilities:

• Assisting the Customer with designer inputs during idea development.
• Managing delivery of new enhancements by tracking deliverables financials, identifying and tracking current and new issues/risks/dependencies and actions.
• Tracking schedule /cost /project plan for new break-fix/enhancements
• Tracking and management of day to day incidents/issues within maintenance portfolio production support to ensure smooth flow of business in production environment.
• Management of work allocation, claims, training needs, identification of skills gaps, providing candid feedback and installing confidence in the team.
• Maintain healthy group dynamics proactively identify pain areas and resolve them, foster awareness of technology market, product roadmaps and assist team in their career growth.
• Assisting the resources with hands-on technical and business understanding in complex situations.
• Representing the applications in quality audits and process reviews.
• Assigning/tracking of break-fix/problem tickets, BSR and incident tickets on production problems to the team.
• RFS/RFC/SOW Management Lifecycle
• Initiate Work with the Customer on idea development and Pre-feasibility analysis
• Create Respond to new RFS/SOW request with details on scope/deliverables, schedule financial costing of in scope items.
• Manage Manage and deliver the in scope work/deliverables within deadlines, preparing customer reports, attending customer meetings and resolving any issues/risks by discussing with respective stakeholders.
• Close Close the SOW post implementation.

Confidential

Confidential

Role: Project Lead/Project Manager

• Summary: The Hartford is one of the largest insurance companies in the US providing insurance in automobile, home and P C insurance channels. Universal Auto UA is an automobile insurance product for the US market and provides a rationalized pricing structure across all the existing marketing / distribution channels. It brings together the features of all the existing rate plans into a single PLIC Next Gen PNG rate plan. Universal Auto 3.0 updates the current UA product structure with enhancements and has been implemented in twenty three states in addition to retrofitting the 20 UA 1.0 and UA 2.0 release states. It also added additional features to the UA product that includes PUP Personal Umbrella Policy discount, new vehicle discount, referral discount, years with prior carrier factor, enhanced household composition rating, risk-based rules that invoke increased down payment percentages, depopulation of the old rate plans and utilization of new symbol architecture separate symbol assignment for each of the seven coverage types - BI, PD, MP, PIP, UM, Comp and Coll and federally mandated changes to the VIN structure.
• As a Project manager my responsibilities lied in Client interaction, Team management, Customer/Upper management reporting, Forecasting of resources, Risk assessment/mitigation, advisory work on product technical issues etc.,

Technology: IBM MF z/OS, COBOL, JCL, CICS, DB2, IMS, Oracle, File-AID, Panvalet, MCS, MFE, Revolve, Exceed Client, CAFE Customer Assistance Front End , SFE Sales Front End , Info Facility Overview , BMC Remedy and HP Project Portfolio Management, HP Quality Center.

Key Responsibilities:

• Created and maintained Project Plan, Communication Plan, Work Plan, Task Log, Risk Log, and Issues Log.
• Managed a team of 8 members both of technical career front including their appraisal cycle.
• Reporting project status to upper management client Wipro on deliverables participate in WSR, QSR, SDR meetings etc., Chaired those meetings many times.
• Project estimation Forecasting of resources.
• Participating in Risk assessment mitigation meeting with Delivery manager.
• Solution Advisory on product technical issues assigning incident/problem tickets.
• Assisted team members on complex issues with hands-on on technical business related issues.
• Responsible for creating/implementing quality process and maintaining proper documentation.
• During initial phase of the project helped team members with deliverables code, tech spec walkthrough meetings with the client team.
• Review code changes prior to the implementation as a part of configuration control as a lead.

Confidential

Confidential

Role: Technical Lead/Module Lead

• Summary: Speed to Market was a development project for the Auto Insurance wing of the Hartford insurance company. As per the DOI department of insurance notice to have one rate plan Universal rather than to have multiple plans based on the different channels of issuing a policy is the key to this project along with the following extra things that were implemented as part of this project
• Introduction of rational pricing structure across all segments of market which will reduce complexity, enabling improved speed to market of future competitive initiatives.
• Marketing Cost Modifier apply to Employees, Affinity Groups/large producers, Marketing Groups
• Various kinds of discounts like Hybrid Vehicle, Employee, Referral, On Star, Spousal Discounts etc.,
• Pricing Factors for bill plan / payment type i.e. credit card, check, EFT
• Rate Cap Logic with decreases added and ability to re-set rate cap indicator at each renewal
• AARP Member Tenure Pricing and Robust Member Verification
• Distribution of an AARP endorsed auto program through selected independent agents.
• As a Tech lead my responsibilities include requirements gathering, application design, development, testing, implementation, and post implementation support.

Technology: IBM MF z/OS, COBOL, JCL, CICS, DB2, IMS, Oracle, File-AID, Panvalet, MCS, MFE, Revolve, Exceed Client, CAFE Customer Assistance Front End , SFE Sales Front End , Info Facility Overview , BMC Remedy and HP Project Portfolio Management, HP Quality Center.

Key Responsibilities:

• Analyze on Functional High Level Design Document.
• As per FSD, create Technical Design and Document.
• Helping the team with technical issues and guiding them with solution on day today issues.
• Meet with client team to understand the business and delegate the work accordingly to offshore team members.
• To participate in design and code reviews.
• Work allocation, tracking, status reporting, motivating, guiding, monitoring and doing appraisal for individuals of the team are a percent of what goes into the day today routine.
• Status meetings with Customer Project Management for activity and schedule discussions to meet deadlines.
• Performed thorough Design and Test Results reviews and coding walkthroughs and got them signed-off by the respective Tech Leads at Hartford.
• Tests performed manually in different stages and environments Development, Test , prior to moving to Production followed by thorough reviews to meet the Hartford standards.
• Coordinating with Off-shore team on a daily basis for knowledge base and status, helping them in understanding design, coding and testing and mentoring them to deliverables in a timely manner.

Confidential

Confidential

Role: Senior Developer

Summary: The Hartford Insurance provides automobile, homeowners and home based business coverage to AARP through direct marketing operation. PLA System has a set of online and batch programs which process the transactions which are initiated from different front ends or through nightly batch. Task performed at the backend are validation, edits, ratings, pre-renewal, OSP Output preparation, risk updation and underwriting.

Technology: IBM MF z/OS, COBOL, JCL, CICS, DB2, IMS, Oracle, File-AID, Panvalet, MCS, MFE, Revolve, Exceed Client, CAFE Customer Assistance Front End , SFE Sales Front End , Info Facility Overview , BMC Remedy and HP Project Portfolio Management.

Key Responsibilities:

• Helping the team with technical issues and guiding them with any solution issues.
• Involved in the analysis, design and enhancement to existing system using business spec / technical spec documents.
• Coding of application changes as required / specified by technical specification document.
• Support involves creating missing datasets and GDGs, providing overrides, Scheduler corrections and changes for preventive and corrective measures for better performance of the PLA system. Experience with COBOL, JCL, DB2, IBM Utilities, VSAM and Stored Procedures in Mainframe environment.
• To prepare test plans and conduct unit testing / system testing.
• To participate in design and code reviews.
• Production bugs come as Remedy tickets and they are assigned for problem studies. They will be worked based on the priority by the team.
• Setting up of new Jobs, scheduling using Control M and reviewing the status maintaining and updating the system documentation.

Confidential

Confidential

Role: Technical Lead/Manager

Summary: Embarq Corporation was the largest independent local exchange carrier in the United States, serving customers in 18 states and providing local, long-distance, high-speed data and wireless services to residential and business customers. HRIS is Human Resource Information System and the project deals with maintaining the complete inventory of data for each and every employee of the organization for one of the biggest telecom industry in the US. The maintenance includes the calculation of PTO Hours balance, Wage data maintenance on bi-weekly basis, benefits maintenance etc.,

Technology: IBM MF, OS/390, TSO/ISPF, VS COBOL II, JCL, DB2/SQL, VSAM, File-AID, IBM VAGen, CA Unicenter Service Desk and NDM.

Key Responsibilities:

• Leading a team of Mainframes maintenance and support developers.
• Assigning team members to project tickets service requests from the clients.
• Participating in the onshore team meeting on a daily basis and understanding / gathering the requirements from the client team.
• Analysis on the BRs and estimating feasibility of technical implementation and creating the technical requirements for the offshore team.
• Project tracking and maintenance of time Vs resource.
• Participating in internal quality audits QA and software configuration management SCM .
• Doing code review, code walk through of work product from offshore.
• Coordinating with Off-shore team on daily basis for knowledge base and status, helping them in design, coding and testing, mentoring them to deliverables in timely manner.
• Helping the clients in making business decisions on projects.
• Helping out the clients in solving day today technical issues.
• Solving analysis / design / coding / testing / implementation the service requirements on the HRMS online system with the help of IBM VAGen tool.
• Take part in weekly client meetings and IT status meetings and offshore meetings.
• Supporting the interface teams and providing solutions to solve issues with the interface applications.
• Created necessary status reports and Monthly performance status tracking matrices.
• Helping the offshore team members with coding issues and guiding them on the right path in coding the solution with respect to the business requirements.
• Providing On-Call Production support and helping / guiding the offshore team in taking decisions as and when required during the US night time.

Confidential

Confidential

Role: Lead Developer

• Summary: Sprint is the Leading Telecom service provider in Local and Long wire line and personal communication services to the Business, Consumer and Residential customers.
• WebTime is a web-based application used by the employees and contractors. WebTime provides user with forms for entering the time. User will be asked to feed in details like SR and Labor Code, along with hours worked for each time entry. The key features / capabilities of this system are: 1 Users can enter time daily or weekly. 2 Users can correct time within the calendar year. 3 User can approve the time, if he/she is a manager of a resource with sufficient authority or a power user. The architecture uses Java Servlet having HTML tags embedded in them. The business rules are all contained within the WebTime Domain Java Classes CTG Communication Beans is used to provide the connectivity/interface to CICS / COBOL / DB2 programs resident on the IBM Mainframes.

Technology: IBM MF, OS/390, VS COBOL II, JCL, DB2, CICS, VSAM, CTG-Beans.

Key Responsibilities:

• Maintain support for the existing application.
• Enhancements to the existing Application, as per the clients request.
• Design of technical solution to meet the requirements of functional requirement documents.
• Coding of application changes as required / specified by technical design documents.
• Involved in technical reviews and fine tuning of the system.
• Providing support in break-fix and severity-calls.

Confidential

Confidential

Role: Senior Developer

Summary: Payroll system is used in the calculation of payment to the employees of the organization. It involves pay check creation and updation of history details. Payment may be done by direct deposit or by manual check creation. There may be problems due to employee vacation or leave of absence which are to be handled by one time programs and jobs. Also Labor data will be provided to the Labor system for data collection.

Technology: IBM MF, OS/390, TSO/ISPF, VS COBOL II, JCL, DB2/SQL, VSAM, File-AID, INFOMAN and NDM.

Key Responsibilities:

• Participating in the SRM FRM sessions with the clients for upcoming new tickets and providing high level analysis on those requirements.
• Analysis of the tickets based on the specification document received from the clients, preparing design documents and providing estimation effort LOE - Level of Effort .
• Involved in business requirements gathering and converting them into technical requirements.
• Performed DB2 LOADS, UNLOADS, Image copies, RUNSTATS, BINDS and other DB2 core utilities from production to development, test and then to staging environments.
• Coding and unit testing of the tickets received from the clients documentation of the unit test results.
• Doing code review, code walk through of peer tickets.
• Creating migration plan for different types of programs based on functionality and preparing migration headers for the Payroll application.
• Acted as a configuration control member coordinated the activities during project releases.
• Developed, implemented and managed a standalone CICS and batch COBOL system with DB2 and VSAM files and Assembler called routines
• Provided 24x7 on-call production supports for the group of Payroll Labor Jobs.

Confidential

Confidential

Role: Software Engineer/Developer

Summary: Employees of the company can buy their company shares at a discounted price. Participants can elect a percent of their annual compensation towards the purchase. The shares will be purchased once in a year on June 30th. The amount will be deducted from every paycheck. Active participants can withdraw from ESPP before June 1st every year, they can choose the option to receive cash refund or purchase stock.

Technology: IBM MF, OS/390, VS COBOL II, JCL, DB2, VSAM, XPEDITOR, File-AID.

Key Responsibilities:

• To maintain support for the existing application.
• Involved in the analysis, design and enhancement to existing system using detailed design documents / client requests.
• Coded COBOL/DB2/VSAM programs as per technical design and quality standards
• To participate in design and code reviews.
• Prepared unit test plans, test cases, test data. Documented the test results
• Handled multiple tasks and implementations. Member in On-Call support team for previous implementations.

Confidential

Confidential

Role: Programmer/Analyst

Summary: ITE is an application which tracks the time entered by the Resources / Contractors and validates them against the Online / Batch feeds which it gets from other subsystems like OnTrack, WebTime and sPro. The various activities of this application involve Time Tracking, Project Charge Hours, Labor Charge Back, Cost Center Assignment, Resource Master, Correction Suspended Transaction and Reporting.

Technology: IBM MF, OS/390, COBOL 370, VSAM, DB2, CList, JCL, TSO Dialog Manager.

Key Responsibilities:

• Involved in gathering the requirement, designing and developing.
• Designed and Developed modules to handle change requests from the clients to make the system more stabilized one.
• Coding testing of COBOL/VSAM programs as per the requirements.
• Implemented several change requests in customizing the functionality of the ITE system with Sprint software engineering standards.
• Testing the code or modified modules against the requested and existing functionality.
• Involved in Re-Engineering activities, analysis and break fixes.
• Involved in creating new tool for customizing the creation of files based on customer's Business rules to track the Local and GMG records separately.

Confidential

Confidential

Role: Programmer

Summary: This project serves the need of a university/college in maintaining a student database. The application has administrator user roles/access. There are various modules like Student entry, Attendance tracking, Leave request/approval, Fees details/alerts, Lab reports, Hostel Accounts etc.,

Technology: Windows 2000 / NT, Visual Basic 6.0, Data Reports 6.0, Oracle 8.0

Key Responsibilities:

• Involved in End-To-End Implementation of the software for maintaining the student's records of the whole college
• Involved in Requirement gathering, Analysis, Designing, Coding, Implementation, Testing and Performance Tuning of the software
• Customized the software with creative new ideas and incorporated modules like time sheet, schedule hours, remote login, access check, User / Administrator login etc.,
• Involved in complete design and development of the Application using VB 6.0, SQL Oracle 8i
• Prepared high level design document for the system
• Designed forms reports using Visual Basic
• Extensively used controls like FlexGrids and DataLists with data binding.
• Designed, Developed and tested stored procedures in Oracle 8.0