Detailed Professional Profile of

Raja Ghattamaneni

678-***-****

acfpb7@r.postjobfree.com

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