Manager Project
Resume:
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 : **************@*****.***
Office Email : ******.********@*******.***
Contact this candidate