Data Management

Chaitanya S Katterapalli

**** ****** *****, ***** ** 75013, Ph: 469-***-****, Email:

******@*****.***

Summary:

Accomplished IT management professional with 15 years of experience in

driving results and information strategy across the enterprise. A motivated

technology leader with extensive background in Information and Data

Management including Business Intelligence, System Development,

Architecture, Databases,, Analytics and Health Care IT. Experienced manager

in leading and building high performing teams. Excellent problem solver who

is versatile and adept in solution development by incorporating holistic

and proactive approaches.

Areas of Expertise:

IT Management * Strategic Planning * Business Intelligence * Health care IT

* Data Warehousing * Data Management and Integration * Analytical and

Operational Databases * Health care Analytics/Reporting * Master Data

Management * System & Application Development * Database Administration *

Data Governance *Quality Improvement * Business Process Reengineering *

Communication * Leadership * Project and Portfolio Management * Continuous

Process Improvement * Budget and Cost Center Management * Effective Team

Management * Problem Resolution

Professional Experience:

IT Manager, Business Intelligence (Aug 2013- Present), Capital One, Plano,

TX

Manage Home Loans Business Intelligence to aid in data management,

security, analysis, reporting, integration, governance and new solution

development. Responsible for business intelligence data warehouses,

operational data stores and reporting.

- Manage Business System Analysts and nine agile multi shore and cross

functional pods in matrix environment for Origination, Servicing and

Analytical data efforts by carrying the intent to development and

delivery.

- Engage with business customers in understanding needs and priorities,

conduct JAD sessions and scope the development in alignment with overall

initiatives.

- Involved in data management, metadata development, data guardianship,

data governance, data access, audits, data quality and standardization.

- Review and provide guidance on physical and logical data models,

dashboard development, analytics and reporting, load design and strategy,

code reviews, performance tuning and reject records processing.

- Manage BI Portfolio budget and participate in annual budget forecasting.

- Responsible for team management, performance evaluations and succession

plans.

- Involved with data and service level agreements across departments and

agencies with both internal and external vendor and in development of

metrics and KPIs.

- Coordinate projects with product owners, business customers, software

development teams, data stewardship team, data analysts and external

vendors.

- Design and implement process improvement projects, automations, best

practices and consistent software development and release processes

across the teams to get into well-managed state

- Investigate and provide input/feasibility analysis on introduction of new

technologies, product development and reporting solutions

Accomplishments (Capital One):

- Played a key role in successful delivery of a complex servicing data

upgrade and integration program to include home equities by strategizing

on effective data analysis and coordination across multiple stakeholders

that resulted in 40% improvement in timelines with zero defects and

smooth one platform integration.

- Led the development of BI quarterly and yearly roadmap to set strategy,

team and budget management while balancing the demand and prioritization.

Developed Tetris view that was incorporated across other lines of

business.

- Designed interaction model for Business Intelligence team across the

organization to improve coordination and visibility on application, data

and system requirements thereby improving business knowledge that

resulted in rapid application deployment.

- Effectively problem solved the contention of network resources by finding

the root cause by proposing the prioritization model that improved

visibility and increased the average availability to 2-3 weeks from 7

weeks which helped in commitment reliability.

- Developed a new model for the team structure and roles that accounted in

30% of cost savings.

Socialized RACI matrix with the team and stakeholders and got consensus.

Sr. Project Program Director IT/Application Systems Lead (Jan 2004 - Aug

2013), University of Arkansas for Medical Sciences, Dept. of Arkansas

Center for Health Improvement, Little Rock, AR

Responsible for providing and managing information technology solutions to

the health care promotion and the health policy development projects at

UAMS in the department of ACHI. Projects and databases involved with are

The Obesity Initiative, The Health Data Initiative, Vital records, Hospital

Discharge Data, Medicare, Medicaid, Delta Dental, Employee Benefit Claims,

Pharmacy and Eligibility Data, Health Risk Assessments, Cancer Registry,

Behavioral Risk Factor Surveillance Study and Immunization Exemptions.

- Managed Health Data Initiative data warehouse and operational data

stores.

- Provided strategic direction and technical consultation on database, data

warehouse, application development and analysis, data governance and data

quality that aid to the organization's goals.

- Led projects related to insurance utilization, dual eligible population,

quality improvement, cost and reimbursements, payer mixes, provider and

workforce density, access to care, readmissions and episode grouping

- Involved in the Health Data Initiative data warehouse design,

development, data linkage and analytics by integrating data from

different data sources and developing key metrics and relationships for

analysis.

- Provided guidance on new applications, architecture and design, user

interface, web connections, ETL processes, logical and physical design,

load strategy, dashboard development, data analytics, code reviews and

creation of complex solutions.

- Developed data warehouse ETL processes and provided data analysis

expertise using SSIS, SSRS, SSAS, BIDS, SQL and SAS.

- Provided agency specific utilization and cost review for state wide

Employee Health Benefits Division Network.

- Involved with database administration activities like security, roles,

maintenance plans for backups, disk space management, database refreshes

and restores, log monitoring and disaster recovery plans.

- Worked with cross functional teams in matrix environment and lead project

completion.

- Coordinated with different providers for data requirements, data

procurement and entry.

- Coordinated database, software, product and analytical report releases

and make go-live decisions.

- Developed data sets and performed analysis on Medicare eligible

population, Part A, Part B and Part D claims, diagnoses, utilization and

discharges.

- Developed and release statewide analytical reports on health data.

- Researched different software solutions, contact vendors and provide a

plan for new application development and integration.

- Developed project plans, deliverables and deadlines for the Obesity

Initiative, All Payer Claims Database development (APCD) and IT projects.

- Mentored team members, trained them on databases and ETL processes.

- Involved in resource management, hiring and talent management.

- Portrayed data and analysis though reports and maps using GIS

(Geographical Information Systems).

- Performed qualitative and quantitative statistical analysis within and

across data sets using different models.

- Envision the scope and chose the appropriate IT project methodologies

like agile, scrum, waterfall or rapid delivery.

- Developed technical specifications, process flow diagrams and process

improvement models.

- Communicated on project updates, challenges and results.

- Evaluated and developed test plans, use cases and co-ordinate stress/load

testing and followed up on user acceptance testing.

- Trained external and internal users and developed training manuals and

solutions to frequently asked questions.

- Oversaw statewide customer support, resolved issues and performed root

cause analysis.

- Involved in the budgeting, vendor contracts, data user agreements and

equipment procurement.

- Initiated and developed change control process and requirement

traceability matrices.

- Worked with server and network administrators in developing server

specifications and designing intranet for servers.

- Followed legislation related to population health, insurance and PPACA

(Patient Protection and Affordable Care Act), discussed with stage and

local agencies, understand the impact and perform analysis.

- Led the design, development and deployment of departmental web site and

intranet sites.

- Experienced in dealing with individual protected health information and

adherence to HIPAA and FERPA guidelines.

Accomplishments (UAMS):

- Designed agency wide DBMS architecture consisting of different databases,

data warehouses, linked servers and established database standards.

- Led the statewide web based application systems and analytics for student

health data information collection, health management and generation of

individual and aggregate reports by school, school district and statewide

from requirement gathering to design, development, analysis, testing,

conversion, deployment, maintenance and customer support. In addition,

developed mobile application for recording student health data and

synchronizing with the server.

- Played a key role in developing algorithms for identity management, data

de-duplicating, linking, longitudinal data analysis and developed master

data management strategy across databases. Designed healthcare models for

comprehensive and role based views and relations, data governance,

metadata development and standardization.

- Designed a methodology to quickly process Medicaid eligibility, provider

information, medical and pharmacy claims and adjudications into

analytical data sets. This resulted in the department becoming the

analytical data processing entity for ADH Medicaid Claims.

- Led and set the stage for All Payer Claims Database development project

for the state of Arkansas as part of Health Care Reform by coordinating

with different payer agencies, NAHDO, ADH and designed architecture in

the warehouses.

- Performed SQL tuning and reduced the time taken to run health care claims

queries to 75% and trained the team.

- Created the first and the only longitudinal children's obesity database

with data ranging over nine years.

- Proven track record of delivering high quality projects that meet

timelines and adhere to scope, requirements and ensure customer

satisfaction.

Software Engineer III/I - Data (Nov 1999 - Oct 2003), Applied Materials,

Santa Clara, CA

Responsible for application development (complete system life cycle

experience), analysis and maintenance of the projects within Product

Management Team of IT department. Led the data modelers across different

business groups worldwide.

- Designed and implemented data and product modeling for the new products

using modeling tools and Erwin.

- Translated the requirements of product business groups to software

solutions by generating functional specifications, project plans and

mutual delivery/service level agreements.

- Developed logical and physical data models and provide guidance on

changes

- Certified and trained data modelers worldwide in all the product business

groups.

- Assisted forecasting and marketing team in planning for future orders by

providing data analysis regarding customers, most demanded products and

the change in system bookings.

- Involved in Product Specification product Tool (PST) web application with

coding, debugging and support. Developed and maintained user interfaces,

packages, procedures and functions to enhance/support application

functionality.

- Participated in analysis, design, coding and testing of Account

Automation tool and web enabled reports.

- Worked on development of data extraction tool from Lotus Notes using

Access and also on a Test Tool application in Visual Basic for validating

configurations.

- Created and enhanced scripts and jobs to ensure data transfer within

different databases.

- Worked on database backups, database refreshes, migrations, maintaining

pipeline, open link lite/ODBC set up and disaster recovery.

- Administered and configured Citrix, web servers and troubleshot technical

user problems.

- Performed application testing, evaluated new software, generated test

scripts and trained personnel onsite and offshore with the modeling

skills needed.

- Provided global production and customer support, coordinated software

releases and user communication.

Accomplishments (Applied Materials):

- Played a key role in successful application migration by resolving

software issues with new set of hardware for Dual Data Center project

well within the deadlines that ensured smooth acceptance testing.

- Restored a corrupted database when deemed impossible by resolving complex

data integrity issues that resulted in saving two months of work by the

data modelers.

- Came up with Best Known Methods and FAQs to solve recurring issues and

trained personnel on root cause identification.

-

Computer Consultant (Jul 1999 - Oct 1999), Optimum Data Systems, Farmington

Hills, MI

Involved in client server application development, support, maintenance and

troubleshooting for Lear Corporation, Dearborn through Optimum Data

Services

- Modified and programmed Engineering Time Tracking application and

generated new forms and reports

- Enhanced and coded Design Failure Mode and Effect Analysis.

- Customized and debugged Gagetrak application for quality control and

modeled Parts Prototype Tracking System.

- Developed specifications, designed and modeled Technical Engineering

Document distribution.

Teaching and Research assistant (Dec 1998 - May 1999), Louisiana Tech

University, Ruston, LA

- Taught laboratory procedures and maintained students test records in

database.

- Performed data collection and analysis.

Education:

- MS Computer Engineering, Santa Clara University, Santa Clara, CA (June

2003).

- MS Engineering, Louisiana Tech University, Ruston, LA (May 1999).

- B.Tech, Chem.Engg (Jawaharlal Nehru Technological University, Anantapur,

India (June 1998).

Technical Skills:

Operating Systems: Windows 7, Windows Server 2008, 2008R2, NT/XP, UNIX

Databases: SQL Server (2005, 2008, 2008R2, 2012), Oracle 8i, Teradata, Big

Data Concepts, MS Access, OLAP, OLTP

Business Intelligence, Statistical, Modeling & ETL Tools: SSIS, SSRS, SSAS,

SAS, SPSS, Tableau, Business Objects, Cognos, ProClarity, Ab Initio,

Designer 2000, ERwin, UML

Languages: SQL, PL/SQL, T-SQL, Java, C, C++

GUI: Visual Basic, VB.Net, C#, ASP.Net, HTML, CSS, Developer 2000 (Forms

4.5, Reports 2.5)

Packages: Arc GIS

Other: Citrix, IIS web server, ODBC, SharePoint, VMware, MS Office (Excel,

Power Point, Word, Project, Visio), Version One

Software development: Iterative, Waterfall, Agile methodologies, Scrum,

Dynamic system development

Published Articles:

- Lessons Learned While Implementing a Legislated School Policy Body Mass

Index Assessments Among Arkansas's Public School Students By: Justus MB,

Ryan KW, Rockenbach J, Katterapalli C and Card-Higginson P In: Journal of

School Health, 77(10), pp.706-713 Published: December 2007.

Honors and Activities:

- Gamma Beta Phi

- Conducted mathematics and science workshops

- Member of PMI

Contact this candidate