Project Manager
Resume:
Detailed Professional Profile of
Raja Ghattamaneni
***********@*****.***
Experience Summary
. 16+ years of extensive experience in managing, designing, coding,
testing and maintenance of Information systems in full PMLC and SDLC
(both Waterfall and Iterative models).
ETL/Data warehousing:
. Created complex workflows/mappings to capture changed data from CIS to
CMA using Informatica PowerExchange and PowerCenter at AGLR
. Lead the effort of creating an enterprise data warehouse from the
ground up at Compass Bank using Informatica PowerCenter, Oracle and
SyncSort
. Created complex workflow/mappings using Informatica PowerCenter to
load data into enterprise data warehouse from FiServ at JM Family
. Architected and designed processes to load data from various source
systems (provider, enrollment and claims) into various data layers
(staging, canonical, operational data stores and data marts) at
CareFirst
. Lead the effort to load data from various heterogeneous sources into
enterprise data warehouse at CareFirst
. Lead the effort to create various data marts and reports sourcing data
from operational data store and enterprise data warehouse for various
divisions in CareFirst
. Lead the effort of sourcing claims data from various sources and
loading them into various data layers (staging, relational, enterprise
data warehouse and claims lifecycle data mart) at Horizon
. Leading the above efforts involved (but not limited to):
1. Create/review/approve requirement documents and getting approvals from
business users
2. Create POCs and design prototypes using Informatica PowerCenter
3. Review/approve test plans and test cases
4. Create/review/approve design documents
5. Review and provide feedback on end user test cases
6. Review/approve database design for star schemas and ER schemas
Program/Project Management:
I have always employed the very best industry standard program/project
management processes at every stage of the program/project. I have always
performed well under pressure and handled challenges like limited
resources, budget reduction, attrition, additional requirements with no
increase in budget etc. I have lead many projects with varying budgets
ranging from $50k to $10 million with team sizes between 2 to 50 (including
managers) across multiple geographical locations. I have good working
experience in the below aspects of program/project management:
. Project integration management (created project charters, project
plans etc.),
. Scope management (business/technical requirements, implementing change
control processes, creating WBS etc.),
. Time management (created program sequence diagrams, effort estimation,
and project schedule using Microsoft Project etc.)
. Cost management (created monthly forecasts, variances etc.)
. Quality management (requirements tractability matrix, created
checklists, ensured business sign off on UAT test cases and execution)
. Communications management ( Identified all stakeholders, provide
weekly status report to all stakeholders, weekly/daily team meetings
as required, created program radar reports for C level executives)
. HR management (resource procurement/loading, resource leveling,
performance appraisals etc.)
. Risk management (created risk register templates, identify risks and
corresponding mitigation etc.).
I can provide examples from my past experience for all the aforementioned
skills. I also ensured that I review all the project deliverables and
ensure they meet the quality standards.
Business Intelligence:
. Lead the effort of creating various reports for various divisions
using Microsoft SSRS at CareFirst
. Lead the effort of creating pending claims reports using SAS at
Horizon
. leading the above efforts involved (but not limited to):
1. Meet with various business users to gather reporting requirements
2. Review wireframes and get approvals from business users
Healthcare:
For the last 6 years I have worked at various healthcare payers (CareFirst,
Horizon and FEP) and have amassed a wealth of domain knowledge around
claims (claims adjudication lifecycle), enrollment (membership,
subscription, employer groups etc.) and provider (providers, practitioners,
networks, contracts etc.) and also the technical aspects of the
applications (FACETS, Portico, NASCO etc.) around these domains. I have a
good understanding of most of the EDI transactions (837, 835, 834, 270,
271, 276, 277 etc.)
Functional Management:
As a functional manager I have performed the below tasks:
. Yearly performance appraisals
. Approving timesheets and expense reports
. Interviewing and hiring resources
. Employee corrective actions for low performing resources
Others:
. Being a true leader I always stay calm in case of crisis and look to
first resolve the issue at hand and then ensure it doesn't reoccur by
identifying the who and how of the issue
. I have always been incredibly focused, analytical and logical. I also
have the ability to quickly learn any new aspect in an IT
program/project (technology, process etc.).
. I am also very good at articulation. This aspect of mine has helped me
immensely with managing the stakeholders, business users and in
general the entire project team.
. I also have an incredible sense of ownership, may that be the entire
program or a small piece of code.
. I have received appreciation from every client that I have worked with
(verbal and/or written)
. I have taken projects from an idea to post production
Skill Summary
Skill/Domain Years of
Experience
ETL 9
Data warehousing 7
Program Management 5
Project Management 11
Functional 6
Management
BI 2
Healthcare 6
Technology 5
Banking 1
Energy 2
Technical Skills
Microsoft Project, Visio, Excel, Visual Basic 6.0, VC++.
Technologies COM/DCOM, ASP, STL, ADO, MSXML, SQL Server, Visual
Studio.NET, SSRS
Internet ASP.NET, ASP, XML, XSL, HTML, JavaScript, VBScript,
Technologies COM/DCOM
Languages C#, C, C++, VB6, PL/SQL, Java, Lotus Script
RDBMS SQL Server 6.5/2000/2005, ORACLE 7.3/9i/10g, MS
Access
Source Control Visual Source Safe 6.0, PVCS
Operating Systems Windows 98/NT/2000/XP/2003/Vista, OS2 Warp, Sun
Solaris, HP AIX
Tools Informatica PowerCenter 7.1.4/8.1.1/8.6.1/9.1,
Informatica Power Exchange 5.2.2/8.1.1/8.6, Visual
InterDev 6.0, WinDBG
Application servers IIS 5.0/6.0, PWS, MTS, COM+
Others IBM Aptrix, IBM Edge, STL, JCL, Clarity, Shell
Scripting, SAS
1
2 Education
. BS, Computer Science, Osmania University, Hyderabad, AP, India.
. PMI certified Project Management Professional (PMP)
. Informatica Certified Consultant (Version 8)
. Informatica Certified Administrator (Version 8)
. Informatica Certified Designer (Version 8)
. Microsoft Certified Solution Developer (With VB and SQL Server as
optional)
3
4 References
Upon request
5 Professional Experience
Employer: ManpowerGroup
Client: SBPASC
Period: May' 13 - Till date
Title: Senior Project Manager
Description
The Service Benefit Plan Administration Services Corporation (SBPASC), an
affiliate of CareFirst, Inc., provides business processing and technology
infrastructure for the Blue Cross and Blue Shield Service Benefit Plan, a
health plan offering to Federal employees. SBPASC's PMO team was tasked to
manage the multi-year ICD-10 conversion program that started in 2009 and
scheduled to be implemented in Oct' 2014. This program involved in
identifying all the impacted areas and remediating them to handle ICD-10
code set. As a PMO program manager I was responsible of managing all the
development effort required for the remediation.
Responsibilities (PMO Program Manager)
. Facilitate JARs and JADs.
. Create WBS.
. Create detailed Project plans.
. Create project schedules using Microsoft Project.
. Identify and manage project risks and issues.
. Status reporting.
. Project financials tracking using Clarity and Microsoft Excel.
Environment
Microsoft Project, Microsoft Excel, Microsoft Word, Microsoft PowerPoint,
Microsoft Visio, Clarity.
Employer: Cognizant
Client: Horizon (BCBS NJ)
Period: Sep' 12 - May' 13
Title: Senior Manager
Description
Horizon Healthcare Services, Inc., doing business as Horizon Blue Cross
Blue Shield of New Jersey, is a not-for-profit, health Service Corporation.
It has around 3.6 million members and over 5000 employees. Horizon's Data
Strategy and Management (DS&M) team has undertaken a massive effort of
building Horizon Data Analytics Platform (HDAP) using cutting edge
tools/technologies and high industry standards. To better manage the ROI
and the entire program, DS&M management has divided the entire program into
3 sub-programs namely, Provider, Member and Claims. Horizon has chosen
Cognizant as their implementation partner and I as a senior manager have
been given the responsibility of delivering the HDAP-Claims program.
Responsibilities (Program Delivery Manager)
. Manage the HDAP-Claims program. This involved in:
> Creating SOWs and getting them reviewed and signed by both
parties
> Work estimation
> Project planning/execution
> Create project schedules using Microsoft Project
> Status reporting to executive management (both Horizon and
Cognizant)
> Managing the onsite/offshore development team
> Tracking project financials
. Design/architect the ETL processes that load data from various claims
source systems into multiple data layers (staging, canonical,
enterprise data warehouse and data marts).
. Oversee and review design/architecture of SAS reports.
. Performance evaluation for direct reports (that included managers).
. Development planning for direct reports.
. Hire resources for various projects.
Environment
Microsoft Project Plan, Microsoft Excel, Informatica PowerCenter 9.1,
Oracle 10g, Teradata 13.1, SAS 9.x, SQL, PL/SQL, AIX 5.3.
Employer: CareFirst, Cognizant, Keane
Client: CareFirst
Period: Apr' 08 - Feb' 13
Title: Manager
Description
CareFirst, Inc. is the not-for-profit, non-stock, parent company of
CareFirst of Maryland, Inc. and Group Hospitalization and Medical Services,
Inc., affiliates that do business as CareFirst BlueCross BlueShield. As
part of the Model Office initiation, CareFirst took on the effort to build
an Oracle based Operational Data Store systems utilizing their hierarchical
business rule structure that spans over multiple legacy systems and
redesign existing EDW.
These ODS systems will introduce the next generation information systems
for the client where they will be merging multiple aspects of their
business (e.g. membership, claims, billing, provider, etc) together into
one conformed aggregated dimension which will hold higher quality of data
(data will be filtered and cleansed thoroughly as per the business rules).
These ODS systems will also provide a conformed view of claims, membership,
revenue and providers from multiple sources (FACETS, NASCO, FEP and
Portico)
Responsibilities (Manager/Architect)
. Manage multiple projects. This involved in:
> Create/update the project plan
> Create project schedules using Microsoft Project
> Project execution
> Status reporting to executive management
> Managing the development team
> Tracking project financials
. Create and present C level presentations highlighting ODS data
capabilities.
. Design/architect the ETL processes that load data from various source
systems (provider, enrollment and claims) into multiple data layers
(staging, canonical, enterprise data warehouse and data marts).
. Performance evaluation for direct reports.
. Development planning for direct reports.
. Actively involved in the hiring process.
. Resource leveling across the division.
. Setting up process, design and coding guidelines.
Environment
Microsoft Project Plan, Microsoft Excel, Clarity, Informatica PowerCenter
8.1.1/8.6.0, Informatica PowerExchange 8.1.1/8.6.0, Oracle 10g, TOAD, SQL,
PL/SQL, AIX 5.3, SSRS.
Employer: Informatica Corp, USA
Client: Various Clients
Period: Jan '07 - Mar '08
Title: Senior Consultant
Description
As a Senior Consultant at Informatica I have worked at various different
clients on various projects at various capacities. Some of the key projects
included building enterprise data warehouses for Compass Bank and JM
Family, installing and setting up Informatica GRID with high availability
environment for Ace Insurance and creating the input feeds for the TM1
reporting system for the retail department of Compass Bank. Below are the
some key responsibilities while at Informatica. More details will be
provided around each project upon request.
Responsibilities (Manager/Architect)
. Architect and design the complete ETL processes for loading data from
various heterogeneous source systems into Enterprise Data warehouse
(EDW) following Informatica Velocity best practices.
. Establish error handling and error reprocessing/restart ability
processes.
. Managing/Leading the team involved in activities like Estimate,
planning, track progress, status reporting, build checklists and
reviews.
. Building prototypes/templates.
Environment
Sun Solaris, AIX5.3, Windows XP/2003 Informatica 8.5.1/8.1.1/7.1.4, Oracle
10g/9i, MS SQL Server, TOAD, SQL, PL/SQL, DMExpress 4.2, IDQ, AIX 5.3,
VSAM.
2
Employer: Sapient Corp, USA
Client: AGLR, USA
Period: Oct '05 - Jan '07
Title: Associate Technology
Description
CMA is a customer management application developed to replace the existing
a legacy system (CIS). This system is built in ASP.NET and MS SQL Server
2000 platform. One of the major parts of development was involved in
developing online replication system using Informatica. This online
replication system is used for data migration and replication from the
existing DB2 system (CIS) to MS SQL server.
Responsibilities (Lead)
. Worked in the Data replication track to map tables from CIS to CMA
that would enable data to be replicated from CIS to CMA using
Informatica power center and power exchange.
. Worked on resolving design issues with the Database.
. Design/Develop complex workflows/mappings using Informatica power
center and power exchange.
. Train newly on-boarded resources on Informatica power exchange.
. Worked as a lead for the Informatica infrastructure team where the
responsibilities included planning patches/releases, automate patch
release process, managing the team, resolving any major issues,
supporting the testing team for the data replication part.
Environment
Windows XP/2003, Visual Studio .NET 2003,Visual Studio 6.0, C#, XML,
SAX/DOM, ODBC, ADO, SQL Server 2000, ASP.NET, Informatica Power Center
7.1.4, Informatica Power Exchange 5.2.2.
Employer: HCL Technologies, India
Client: Various Clients
Period: Dec '00 - Mar '05
Title: Senior Software Engineer
Description
As a Senior Software Engineer at HCL Technologies I have worked at various
different clients on various projects at various capacities. Some of the
key projects included maintaining the core IDM layer for FileNet Corp,
building FOCUS system for Conexant Inc and creating the intranet site for
Co-operative Group. Below are the some key responsibilities while at HCL
Technologies. More details will be provided around each project upon
request.
Responsibilities (Lead)
. Created project plans for future releases of IDMWS and Report Manager
using Microsoft project plan, which also involves project estimation
using object count.
. Published the plans on the web server for tracking it online.
. Managing the development team.
. Prepared project status reports.
. Client communication in weekly teleconferences and monthly video
conferences.
. Designing for requirements coming from the marketing team.
. Reviewing the design, code and solving major issues in coding.
. Developed MS office macros using VBA for the Application integration
with MS Office.
. Worked on solving some critical issues involved with the multithreaded
modules.
Environment
Windows NT/2000/XP/2003, Visual Studio 6.0, VC++, COM, ATL, STL, VSS, PVCS,
XML, SAX/DOM, ODBC, ADO, SQL server, HTLP, ASP, Visual Basic, Win DBG,
Crash Dump analysis, Digite, Rational DTS system, IBM Aptrix, Lotus Notes
R6.
Employer: Sphinx Networks, India
Client: Various Clients
Period: Jun '98 - Nov '00
Title: Software Engineer
1
Description
As a Software Engineer at Sphinx Networks I have worked at various
different clients on various projects. Some of the key projects included
creating a website for ClassADs and building a web-based product for MCS
Software. Below are the some key responsibilities while at Sphinx Networks.
More details will be provided around each project upon request.
Responsibilities
. Designing and coding.
. Involved in review of designs of all other modules.
. Created the unit test cases and executed them.
. Worked on Change requests and bug fixing.
Environment
Windows2000/NT, C++, ASP, Oracle 7.3, COM/DCOM, MTS, VB, IIS.
Contact this candidate