Rajesh Rao

( US Citizen )

PH: 919-***-**** ~ E-Mail: acqzs3@r.postjobfree.com

PROFILE SUMMARY

* ***** ** ********** ********** in Finance and Health insurance sector as a data architect / data analyst. Extensive IT project experience in Capital Markets & Investment Banking, Consumer Loans, Lending and Mortgage, Health Claims, Providers, Billing and EOBs.

Extensive experience in Data Management and Database Consulting industry, System Analysis including leading and directing team work and coordinating deliverables.

Adept in various data related aspects including Data Architecture, database design, data modelling, data cleansing, data migration, data quality, data profiling, data management, data governance, and data administration, data transformation, metadata and master data (reference data) management and business intelligence tools

Extensive knowledge in ER Modelling, Dimensional Modelling (Star Schema, Snowflake Schema) and Data warehousing, & OLAP tools.

Efficient in Dimensional Data Modelling for Data Mart design, identifying Facts and Dimensions, creation of cubes.

Having experience in Agile Methodologies, Scrum stories and sprints experience, along with data analytics, data wrangling and Excel data extracts in support of data warehouse and OLTP systems

Participated in workshops for definition of technical standards and guidelines that pertain to data and information use, security, access and governance (including defining accountabilities in support of data quality mandates)

Confirmed existing data/information assets are identified, stewarded and leveraged across the enterprise.

Strong experience in requirements definition, analysis, conducting stakeholder interviews, and developing test cases as per the user requirement

Good knowledge of financial accounting, investment banking, fixed income, payment systems & 835's, HL-7

Proficient in range of technologies- database, modelling, reporting, etc, including business process tools such as Microsoft Project, MS Access, MS Visio, technical assessment tools.

Highly motivated, independent, Values Driven, pro-active and result oriented individual

Professional Skills:

DB (7+ Years) Oracle 8.x through 11 G, DB2, (Back up/Recovery, Design/Architecture), PL/SQL, SQL Server, Designer (v6.x, v2.x), Enterprise Manager, STATSPACK, JIRA, Rational Requisite Pro

Data Architect/Analysis (7 Years) - Process Modelling, Informatica PowerCenter, IBM Data Stage, IBM Quality Stage, SOAP, WSDL, ER Studio, MS- Visio

Configuration Management – Clear Quest, VSS, Star Team

OS/Others UNIX, Solaris 2.x, IBM-SP-AIX, Windows

Project Management – Microsoft Project

Jun' 2012 – Present, VGLABS

Client: Wells Fargo

Data Architect May' 2015 - Present

Environment: SQL, Data Analysis, TFS, Jira, Data Mapping, Visio

Enterprise Credit Risk Information system (Retail) is a data mart that supports the information needs of the credit underwriting and credit management processes with a primary focus on the total consumer credit process

Interfaced directly with the client on all matters related to deliverables, ad-hoc request and audit requests, while helping to manage client relationships.

Responsible for data related issues at an enterprise level

Used Business Objects internally as an ad hoc query and reporting tool

Client: Bank Of America

Lead Data Analyst Nov' 2013 to Apr' 2015

Environment: Oracle, Java, Data Analysis, Data Stage, TFS, Jira, Data Mapping, Visio

The goal of the Client Portal solution is to provide an industry differentiating client portal service to Bank Of America's clients. The portal will provide a single, configurable access point for both BOA and its clients to access information and collaborate. This includes interaction directly with BOA, status updates, financial reconciliation, and customer service. The Client Portal tightens the integration with BOA's customers and provide advanced functionality leveraging data from existing technologies while at the same time redefining the way BOA's clients interact

Interfaced directly with the client on all matters related to deliverables, ad-hoc request and audit requests, while helping to manage client relationships.

Led data mapping exercise for legacy data conversion and created roadmap for Data migration.

Lay down the process of the data migration and data handover and data cleansing

Responsible for the data migration effort. This included creating the data model & design effort to store various control, data and systems information.

Formulating processes around data validation post cutover and testing process

Gathered and analyzed source systems Meta data in terms of source data volumes, growth, job details, data quality issues and complexity in data structures.

Participated in the creation of data requirements and gap analysis for the modernization initiative.

Began the process of formally creating a enterprise wide data governance group and plan

Reviewed Data profiling results and recommended change to existing business processes to eliminate known issues.

Proficiently managed the database performance and reduced time of batch jobs in some cases from 15 hrs to less than 1 hr

Keeping track of all the issues and getting resolution from the business SMEs

Work on recommending improvement to the overall data architecture

Review various documents submitted by both the legacy and target side vendor

Key Responsibilities:

Client: Freddie Mac

Data Analyst Jun'2012 - Oct '2013

Environment: Visio, UML, J2EE, Oracle, SQL Server, Web sphere, MS Project, Informatica

Freddie Mac Credit Risk Sharing Central (RSC) is a J2EE, JSF, JPA, SOAP web services, DB2 application. RSC integrates with loan source systems like Corporate Data Warehouse (CDW), selling and servicing applications like MIDAS using SOA components. RSC exposes loan risk information namely sunset dates and seller/service information in display and reporting capabilities

Key Responsibilities:

Identified the system of records and attributes to map to the target database

Helped in tuning and creating complex views for GUI application

Designed the architecture for getting 12 million loans pulled from the data warehouse to a staging database for reporting and search functionality.

Overall technical strategy ETL architecture and development

Design & Develop projects on Oracle / Informatica

Provided input to the developers to help them build the logic into the application based on the requirements in various sprints

Reviewed the logical model and provide feedback to the data modelling team.

Performed data profile activity for source systems, ODS, ADL and Mart level and generated profile reports

Created data design documents in order to set up the various data interfaces with different legacy systems.

Extensively using SQL to retrieve the detailed information about the database management system in order to generate different reports

Sep' 2010 – Jun' 2012, OHM Logics

Client: United Health Group

Data Analyst Sep' 2010 - Jun'2012

Environment: MS Project, MS Visio, UML, Requisite Pro, J2EE, Oracle, Web sphere, Jira, Data Stage

Project 1: Payment Engine is a project to consolidate systems & integrate data from multiple systems to be the key payment systems for United Health Group. The project achieved its goal through a Data Warehouse system which acted as a data repository to provide data for consolidated client reporting. The ODS received data from many upstream systems, and also fed many downstream systems.

Project 2: The Claim Enhancement Project re-architected the claims processing system to support and enable component-based, service driven architecture, shifted common functionality to the national claim processing system, and enabled the retirement of the existing legacy system.

Key Responsibilities:

Reviewed Data profiling results and recommended change to existing business processes to eliminate known issues.

Reviewed the Logical and Physical Data Model.

Developed interface specifications to regulate data interchange to comply with Enterprise Service Bus requirements.

Led the database model and design effort to store various control, data and systems information.

Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules

In Erwin DM creating Logical and Physical Model.

Designed and created Data Lineage diagrams (DLDs & DIDs).

Identified/documented the Data Quality Controls, reviewed the Business Rules Spreadsheet (BRS) and attended project release meetings.

Identified dependencies and performed gap analysis of current state to desired state and documented requirements for control gaps identified

Successfully created and managed a conversion testing effort which included a data quality review, system test cycles, and user acceptance testing.

Created, compiled and tested various PL/SQL packages, functions and procedures.

Improved query performance 20% and reduced database load / server requirements through code review, performance tuning and rewriting of views and queries using explain plan, tip-off, sultrier, Oracle parallel server options and optimizer hints

Jul' 2007 – Sep' 2010, VitalSpring Technologies

Manager Data Warehouse

Environment: MS Project, MS Visio, UML, Requisite Pro, J2EE, Oracle, Web sphere, Jira, Data Stage, WebLogic

VitalSpring Technologies has 3 core products - Agility which is an award winning enterprise based analytic cloud based solution that enables users to develop strategies for reducing healthcare cost and improving service quality. Integrity product analyses 100% of health care transactions and reduces costs by preventing overages. Affynyty product is a communications platform and returns information to stakeholders

Actively involved in implementing the data warehouse using standard data warehouse techniques (star schema, data cleansing, data staging, and dimension and hierarchy maintenance).

Spearheaded the team of DBAs, ETL developers and Quality Assurance teams for all the database & ETL Administration related activities.

Responsible for Data extraction, profiling, cleansing, data fixing and Transformations

Analysed content and quality of databases, recommend data management procedures, and developed extraction/ETL processes

For new product suite’s developed a roadmap for DW&BI solution for the client. The key deliverables were an As-Is assessment & Gap Analysis, a conceptual model of the business, Key Information and analytical areas to target, a recommended DW&BI solution architecture and a DW roadmap. Further developed and implemented the solution.

Providing security and technology briefing during pre-sales for new & prospective clients.

Proficiently managed the database and ETL redesign effort which improved performance and reduced time of batch jobs in some cases from 15 hrs to less than 1 hr. This redesign saved over 6 hrs in processing time / client.

TRAINING PROGRAMME ATTENDED

Management Trainings:

Dale Carnegie Effective Communication and Human Relation

Maximizing team commitment

Powerful conversations

Process Trainings:

ITIL V3 foundation Six Sigma PMP

Business Analysis

Oracle Training:

SQL PL / SQL SQL/SQR, PS/n Vision – OLAP

Query / Crystal Reporting Database Administration Data Modelling

PeopleSoft Training:

Business Process Design Data Management Tools PeopleTools

PeopleCode HR / Benefits Benefits Administration

Payroll Time and Labor

EDUCATION

MS in Engineering from University of Toledo, OH, USA

BE (Mechanical Engineering) from Sri Krishna Deva Raya University

AWARDS & ACCOLADES

Winner of numerous global awards for service excellence

Contact this candidate