Resume

Name : Ranjit Bhingare

Profile :

. Has almost 11 years of experience in IT with advance technical knowledge

in Mainframe with exposure to SDLC, Production Support and Project

Management along with Informatica and entry level knowledge of MYSQL with

shell script.

. Certified Scrum Master.

. Strong experience in Scrum practices

. Experience in Cognos 8,10 BI Suite (framework Manager, Cognos connection,

Report Studio, Analysis Studio,Metric Studio,Event Studio and Query

Studio)

. Strong experience in the Analysis, design, development, testing and

Implementation of Business Intelligence solutions using Data

Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.

. Have worked with cognos to develop and maintain Cognos coding and

designs., Create, modify and maintain Framework Manager models and

packages based on user needs., Produce reports and dashboards using

Report Studio, modify and maintain Transformer models and cubes etc.

. Have worked on creation or reporting structure for an account.

. Demonstrated skills in Mainframe Development with CICS & DB2 as key

areas, Good experiene in datawarehousing projects with Informatica

development, Status reporting, Trend analysis, Estimation for new

activities, Proposing improvements etc.

. Quick learner with the ability to work in a fast-paced environment.

. Working as a Lead on new Chase 3.0 program for JPMC client to analyze the

existing system and document business rules and derive business

requirements.

. Worked as a Technical Project lead in multiple projects for the State of

DE, State of NV MMIS, Onsite Coordinator (Designation: Project Manager)

in New Development, Maintenance project with wide exposure to complete

SDLC, Project management, change management, client co-ordination etc.

Hardware and Software Environment:

Operating Systems : ZOS/OS/390,WINDOWS95/98/NT/XP,UNIX

Languages : COBOL, CICS, JCL, SQL

Databases : DB2

ETL/BI : Informatica, COGNOS, WINSQL, Shell script

CRM Tools : Endevor, Changeman

Products Tools : File Aid, Expediter, SPUFI, QMF, IBM

utilities, PS Optim, BMC Unload

Applications : GMTKS, Enrollment & Billing system, ZEUS,

Backend reporting, MMIS

Application Servers : Mainframe

Software : CICS, TSO (Mainframe related)

Project Management Tools : MSPS, Control Charts, Pareto Diagrams,

Fishbone charts, Control Impact Matrix etc.

Certifications:

. Certified Scrum Master

. Six Sigma Green Belt

PROFESSIONAL EXPERIENCE

Project Experience Highlights:

Project Name : Chase 3.0 Program

Client : J P Morgan Chase

Duration : From 05/01/2014 to till date

Technology : N/A

Role : Project Lead ( Servicing & Communications Workstream

Lead)

Description :

Create the next generation digital platform focused on high

availability, scalability across devices and provide a personalized

responsive browser experience with next generation visual design language.

Responsibilities :

1. Analyzing the system and writing business rules for system.

2. Writing business requirements from business rules.

3. Working with product owners to create complete BRD.

4. Co-ordianting with client product for different work areas.

5. Status reporting to client delivery manager on a weekly basis

6. Time Tracking and reporting

7. Resource management.

8. Coordiante with different project teams and vendors.

9. Conducting reviews and ensure good quality

10. SPOC for Servicing & Communications Business Area

11. Scrum Master for the Servicing & Communications team.

12. Co-ordianting with client product for different work areas.

13. Keeping a track of team's wall board

14. Facilitating Daily sprints, reviews and retrospective

15. Helping resources to resolve the issues or road blocks.

16. Sharing Burndown charts with Product Owner.

17. Coordiante with different project teams and vendors.

18. Conducting reviews and ensure good quality

19. Onshore and offshore co-ordination

20. Leading team with different sub groups within Servicing &

Communication Business Area to derive business rules and documenting

them by analysing exisitng system.

21. Provide oversignt for creating Business requirement document to

client.

22. Work with group manager to provide PM support.

23. Analyzing the system and writing business rules for system.

24. Writing business requirements from business rules.

25. Working with product owners to create complete BRD.

Project Name : USGS Delaware Medicaid Management Information System

(MMIS)

Duration : From 10/29/2013 to 04/30/2014

Technology : UNIX, COBOL, C, JAVA, WEBSERVICE, Informatica, IBM

Cognos

Role : Project Delivery Lead

Description :

The purpose of this project is to provide medical assistance to

eligible low-income families and to eligible aged, blind and/or disabled

people of Delaware (DE) whose income is insufficient to meet the cost of

necessary medical services. The nature of work involves interacting with

the DE Department of Health & Social Services (DHSS) officials and

identifying and analyzing their requirements. Performing Enhancement and

Maintenance activities for the various subsystems of MMIS namely the EVS

(Electronic Verification System (EVS) and Claims subsystem.

Responsibilities :

1. Technical Analysis

2. System Business Analysis

3. Create Business design

4. Create techncial design

5. Work on enhancement and projects.

6. System testing and reviews.

7. Develop Cognos coding and designs..

8. Develop Framework Manager models and packages based on user needs..

9. Produce reports and dashboards using Report Studio

10. Used Informatica 8.x (Source Analyzer and Warehouse Designer) to

import the source and target database schemas and the mapping designer

to map the sources to the targets.

11. Developed various Mappings and Workflows in Informatica as required by

the Design specifications.

12. Provide oversight for the project managers.

13. Technical support as a lead for the team members.

14. Active participation in technical review committee.

15. Prepare and present monthly reports for the client.

16. Monitor and manage enhancement & maintenance activities for the

account.

17. Help with customer queries.

18. Provide managerial support for new DSS project.

19. Ensuring quality and Configuration management.

20. Time Tracking and Reporting.

21. Solutioning and performance management

Project Name : NV Data Warehouse

Duration : From 10/15/2012 to 10/18/2013

Technology : Mainframe and Vendors with Oracle, Informatica

Role : Project Technical Lead

Description :

The mission of Nevada Division of Health Care Financing and

Policy is to purchace and provide quality healthcare services to low-income

nevadans in the most efficient manner; promote equal access to healthcare

at an affordable cost to tax payers of Nevada; restrain the growth of

healthcare costs ; and review medicaid and other state healthcare programs

to maximise potential federal revenue.

NV DW : This project is to setup a new Datawarehouse for the State of NV

and its vendors.

Responsibilities :

1. Technical Project Lead of the project

2. Requirement Gathering & Analysis

3. Preparing System Design, Technical Design, Test Plan & Test Cases

4. System Architecture

5. Coding,Testing & Reviews

6. Develop Cognos coding and designs..

7. Develop Framework Manager models and packages based on user needs..

8. Produce reports and dashboards using Report Studio

9. Responsible for Business Analysis and Requirements Collection.

10. Worked on Informatica Power Center tools- Designer, Repository

Manager, Workflow Manager, and Workflow Monitor.

11. Parsed high-level design specification to simple ETL coding and

mapping standards.

12. Designed and customized data models for Data warehouse supporting data

from multiple sources on real time

13. Involved in building the ETL architecture and Source to Target mapping

to load data into Data warehouse.

14. Created mapping documents to outline data flow from sources to

targets.

15. Created mapplets to use them in different mappings.

16. Used existing ETL standards to develop these mappings.

17. Worked on different tasks in Workflows like sessions, events raise,

event wait, decision, e-mail, command, worklets, Assignment, Timer and

scheduling of the workflow.

18. Created sessions, configured workflows to extract data from various

sources, transformed data, and loading into data warehouse.

19. Co-ordinate with different vendors involved in the project

20. System Integration

21. To facilitate the technical meetings with all vendors & teams

22. Involved in preparation of Project Schedule, Risk Plan, Communications

Plan, System Design, Test Plan

23. To own technical design

24. Ensuring quality and Configuration management.

25. Time Tracking and Reporting.

26. Solutioning and performance management

Project Name : NV MMIS

Duration : From 06/17/2011 to 10/14/2012

Technology : Mainframe

Role : Onsite co-ordinator

Description :

The mission of Nevada Division of Health Care Financing and

Policy is to purchace and provide quality healthcare services to low-income

nevadans in the most efficient manner; promote equal access to healthcare

at an affordable cost to tax payers of Nevada; restrain the growth of

healthcare costs ; and review medicaid and other state healthcare programs

to maximise potential federal revenue.

NV MMIS majorly has 3 area

a. Core Application

b. Provider Web Portal (EVS)

c. New business

Responsibilities :

1. System Analysis

2. Requirement Gathering

3. Conducting feasibility studies and reasearch.

4. Preparing development & enhancement estimates

5. Preperation of System Design, HLD & Detail Technical Design

6. Design, Code, Test & Review

7. Develop Cognos coding and designs..

8. Develop Framework Manager models and packages based on user needs..

9. Produce reports and dashboards using Report Studio

10. Responsible for Business Analysis and Requirements Collection.

11. Worked on Informatica Power Center tools- Designer, Repository

Manager, Workflow Manager, and Workflow Monitor.

12. Parsed high-level design specification to simple ETL coding and

mapping standards.

13. Designed and customized data models for Data warehouse supporting data

from multiple sources on real time

14. Involved in building the ETL architecture and Source to Target mapping

to load data into Data warehouse.

15. Created mapping documents to outline data flow from sources to

targets.

16. Created mapplets to use them in different mappings.

17. Used existing ETL standards to develop these mappings.

18. Worked on different tasks in Workflows like sessions, events raise,

event wait, decision, e-mail, command, worklets, Assignment, Timer and

scheduling of the workflow.

19. Created sessions, configured workflows to extract data from various

sources, transformed data, and loading into data warehouse.

20. Ensuring quality and Configuration management.

21. Defects and trend analysis.

22. SME for mainframe webservice part of web portal system.

23. Datawarehouse SME

24. Status Reporting.

25. Onshore and offshore co-ordiantion

26. Support activities such as cycle monitoring, bug fixes, abend fix.

27. Suggesting system improvements and innovation.

Project Name : EDS Healthcare - BSC

Duration : From 14/11/2008 to 06/15/2011

Technology : Mainframe, Informatica, UNIX, Oracle DB

Role : Technical Lead

Description :

BSC stands for Blue shield of California. As everybody knows

about the BCBS (Blue Cross Blue shield) which is known for the hospital and

Professional services for whole lot of insurance companies but this has

nothing to do with BSC. BSC is an independent Payer and a competitor to

BCBS. So BSC should never be referred to be linked with BCBS as they are

competitor to each other. Blue shield of California provides both hospital

(insititutional) and Clinic (Professional) services in its plan and not

just professional as people may think. This type of payer with this name is

only in California.

History of Schedule L

Began in mid 1980's

1) For Back end needs like Underwriting, Paid vs billed, month end

reporting and many other.

2) Upgraded in 1980's to have BCBS Arizona data also together

3) But then when the upgrade was planned BCBS moved out with a copy of the

whole system in 1990.

4) 1991 TPS upgrade was done which brought in File manager for Schedule L.

5) There were other projects done but the major one came again in 1996

known as Information Access (IA) which gave better access data like

querying. As prior to IA the whole data was on tapes and there were no

capabilities for users to access the data. This gave them a better access.

6) Now Rosetta is the future for IA which will have more data elements

giving more access to the users.

Schedule L majorly deal with Back-end systems. Back-end system gathers data

from interface application throughout BSC and its vendors and provides the

data in form of reports and extracts which are loaded to databse. This

information is used by BSC users for their day to day functions.

The data which comes from different sources are classified in 3 types

1) Claims processing data -

2) Enrollment processing data

3) Capitation processing data

Responsibilities :

1. System Analysis

2. Requirement Gathering

3. Conducting feasibility studies and reasearch.

4. Preparing development & enhancement estimates

5. Preperation of System Design, HLD & Detail Technical Design

6. Design, Code, Test & Review

7. Develop Cognos coding and designs..

8. Develop Framework Manager models and packages based on user needs..

9. Produce reports and dashboards using Report Studio

10. Responsible for Business Analysis and Requirements Collection.

11. Worked on Informatica Power Center tools- Designer, Repository

Manager, Workflow Manager, and Workflow Monitor.

12. Parsed high-level design specification to simple ETL coding and

mapping standards.

13. Designed and customized data models for Data warehouse supporting data

from multiple sources on real time

14. Involved in building the ETL architecture and Source to Target mapping

to load data into Data warehouse.

15. Created mapping documents to outline data flow from sources to

targets.

16. Created mapplets to use them in different mappings.

17. Used existing ETL standards to develop these mappings.

18. Worked on different tasks in Workflows like sessions, events raise,

event wait, decision, e-mail, command, worklets, Assignment, Timer and

scheduling of the workflow.

19. Created sessions, configured workflows to extract data from various

sources, transformed data, and loading into data warehouse.

20. Ensuring quality and Configuration management.

21. Defects and trend analysis.

22. SME for mainframe webservice part of web portal system.

23. Datawarehouse SME

24. Status Reporting.

25. Onshore and offshore co-ordiantion

26. Support activities such as cycle monitoring, bug fixes, abend fix.

27. Suggesting system improvements and innovation.

Project Name : GLIC - ZEUS

Duration : From 01/02/2007 to 11/11/2008

Technology : Mainframe

Role : Module Lead

Description :

ZEUS is a software package from ERISCO 6.03, originally known as

GroupFacts system. This has been customized for maintenance of Plan and

Member details, rating and premium calculation, billing and accounting and

applying payments, calculating agent commissions, sales rep compensations

and reporting, for the Guardian Group Insurance Business.

Group Facts and the other systems that interface with Group Facts such

as Phoenix, Claimfacts, FAS, CDS etc., share data thru VSAM Files and DB2

tables.

ZEUS application performs the following main business functions:

1. Policyholder Setup : Sets up Group, Division and Class for

the policy

2. Member maintenance : Maintains Member related details

3. Rating and Premium calculation : Calculates Premium amounts based

on Medical, Non-medical and Family rates.

4. Billing : Generates the Bills thru batch billing

and Flexible billing processes.

5. Accounting : Sets up various ZEUS internal accounts.

6. Remittance : Applies the premium payments.

7. Commissions : Calculates commissions for Agents and

provides details for Commission checks generation.

8. Compensations : Calculates Compensations / Bonus for

the agents and Sales Reps.

9. Production credits : Calculates New business growth details

for bonus offerings by Guardian corporate office.

10. Reports generation : Generates various ZEUS reports.

Responsibilities:

1. Requirement gathering and analysis.

2. Preparation of High Level design and Unit test plan for the

requirements.

3. Handling development and enhancement requests.

4. Preparation of Test Plan and Test cases

5. Coding & Unit testing.

6. Conducting Reviews

7. Ensuring quality and Configuration management.

8. Leading enhancement projects.

9. Training new resources on project specific knowledge.

10. Been to onsite for requirement gathering, client co-ordination and

learn more about business.

Project Name : Horizon - BCBS New Jersey

Duration : From 03/03/2006 to 21/01/2007

Technology : Mainframe

Role : Senior Software Engineer

Description :

NMS (New Membership system) is an 15 years old application used at

Horizon Blue Cross Blue Shield of New Jersey (HBCBSNJ); a Health insurance

company.

The main functions of the NMS are as follows.

. Perform Enrollment both Online, Web (Internet) and Batch.

. Issue ID cards

. Write correspondence including welcome and other letters

. Create bills and different reports

On-Line functions are

. Inquiry

. Update

. Add

Responsibilities :

1. Requirement gathering and analysis.

2. .Preparing estimate documents for the requests.

3. Preparation of High Level design and Unit test plan for the

requirements.

4. Handling enhancement and modification requests.

5. Unit testing .

6. Ensuring quality and Configuration management.

7. Mentoring new recruits.

8. Application owner for 3 major modules (Enrollment, ID Cards & Letters)

Project Name : General Motors - Mainframe

Duration : From 13/04/2003 to 31/10/2005

Technology : Mainframe

Role : Team Lead

Description :

This system handles the distribution centers of GM. GM has got

more than 100 distribution centers all over the world. This system raises

the invoices for different GM DID is the primary repository of GM Dealers

and is part of the larger group of VSSM (Vehicle Sales Services and

Marketing). It consists of 2 areas - GM DID (Dealer Information Database)

which focuses on financial and organizational data and DNPS (Dealer Network

Planning System), which focus on the placement, tracking and improvement of

Dealers.

Responsibilities :

1. Requirement gathering and analysis.

2. Maintenance (Providing fixes for reported program errors)

3. Enhancements (Application Modifications as per requirements involvinf

Coding, Testing)

4. Wrote unit test plans and programs.

5. Created necessary JCL's, PROC's, to test the programs concerned with

the project.

6. Prepared Test data using File-Aid.

7. Coordinating between different technical and other user teams.

8. Providing leadership support for the project.

9. Ensuring quality and Configuration management.

Personal Details

Name : RANJIT BHINGARE

Name as Roll in passport : BHINGARE RANJIT KISHOR

Date of Birth : 14/10/1974

Date of Joining : 17/11/2008

Education Qualification : B.Com with Mainframe

Work Experience : Total Exp: 7 Yrs 10 mnth. Previous Exp:5 yrs 4

mnth Mphasis Exp: 2 yrs 6 mnth

Primary Skills : COBOL, JCL, VSAM, DB2, CICS Development, COGNOS,

Informatica, Management and Leadership Skills

Secondary Skills : PROD Support

Current project : USGS Delaware Medicaid Management Information

System (MMIS)

Passport Details:

Passport Number : J7119897

Passport Issue date : 05/18/2011

Passport End Date : 05/17/2021

Place of issue : PUNE

Visa details :

Visa Type : H1B

Expiration Date : 21 MAY 2015

Contact Details :

Cell Phone # : 916-***-****

Personal Email : acexjg@r.postjobfree.com

Office Email : acexjg@r.postjobfree.com

Contact this candidate