L ATHA BHUVANAPALL I P MP

571-***-****

acezyf@r.postjobfree.com

w ww.linkedin.com/in/lathaBhuvanapalli

Seasoned ETL Developer

Enterpr ise I T Startup Database Modeler P roject Management

I N TENT :

Design, develop, launch, and manage ETL solutions for enterprise applications

PROF I LE :

• Result oriented E nterprise IT p rofessional in Data warehousing, Data modelling, Data

i ntegration, Data M igration, ETL process and Business In telligence

• Over 8 years of experience in diverse industries including M ortgage Banking

• Package Software: Expertise in SSIS ETL and reporting tools. Deep understanding of the Data

Warehousing S DLC and architecture of ETL, reporting and BI tools.

• Extensive experience in developing stored procedures, functions, Views and Triggers, Complex

queries using SQL Server, TSQL and O racle

• Development experience in P ERL, PL/SQL

• SQL expertise - excited to be challenged with complex query

VALUE ADD I T IONS :

• Customer Focus: Resolved Database application quality issues that have critical customer

i mpact to save on an average annual budget of $1.2M

• Leadership: S treamlined operational processes, by leading and motivating cross-functional

teams resulted in launching products under tight deadlines and gained the confidence of

customers.

• I nnovation : Designed innovative, robust, low maintenance, and customer specific technical

solutions to expedite product release cycles in saving resource budget over $2M

• Project Management: D irected cross-functional teams to manage Enterprise project delivery

u nder t ight deadlines, on budget.

I N D USTRY PROF I LE:

Mortgage Banking – F annie Mae Loan Sourcing, Servicing, HAMP

HealthCare – Federal Health Resource Services Administration (HRSA), Natural Language

p rocessing

PROFESSIONAL EXPER IENCE :

H RSA – Rockville M D ETL expert 2013 – Present

• Successfully migrated data between different heterogeneous sources such as f lat file, Excel

and SQL Server 2008 using SSIS, BCP and Bulk Insert.

• Design and create views for security purposes, implement rules, defaults, and user defined

data types.

• Create the automated processes for the activities such as database backup processes and

SSIS Packages run sequentially using SQL Server Agent job.

• Create SSIS packages to pull data from SQL Server and export to Excel Spreadsheets and

v ice versa.

• Deploy SSIS Package into Production and use Package configuration to export various

package properties to make package environment independent.

• Create various database objects (tables, indexes, views, stored procedures and t r iggers) and

i mplement referential integrity constraints for enforcing data integri ty and business rules

• Involve n project planning, scheduling for database module with project managers.

• Ut ilize SSIS (SQL Server Integration Services) to produce a Data Mart for reporting.

• Extract, Transform and Load (ETL) source data into respective target tables to build the

required data mar ts.

• Extensively use SSIS Import/Export Wizard, for performing the ETL operations.

• Develop ETL packages with different data sources (SQL Server, Flat Files, Excel source

f iles, XML files etc.) and load the data into target tables by performing different kinds of

t ransformations using SQL Server In tegration Services (SSIS).

• Design ETL as a part of Data warehousing and load data in to Fact tables using SSIS.

F annie Mae – He rndon VA Reports Developer/ Project Manager 2010-

2013

HA MP program encompasses several IT products, cross functional teams to meet Fannie Mae

deadlines. Tools team is key to deliver products in strict deadlines by developing projects TOPS,

H OPS, STRR, DBOT, TDR (Tech Data Repository) and DXU (Data extraction utili ty) etc.

• Experienced in MS SQL Server 2008 with Business In telligence in SQL Server In tegration

Services (SSIS), and SQL Server Reporting Services (SSRS).

• Created database objects including tables, stored procedures and Triggers.

• Developed SSRS Reports for Loan history of delinquent loans.

• Developed Parameterized Reports (SSRS 2008) like standard parameter reports, cascading

parameter reports which consist of report Criteria.

• Developed Chart Reports, Drill down Reports, Master Detail Reports and Mul tiple Reports.

• Created different kinds of reports like Cash Receipts, Aging Reports, monthly Adjustment

reports, Commission reports, Transaction Reports etc.

• Involved in creating Database Design (Physical and logical) as per the requirement given by

clients.

• Implemented security to restrict the access to users and to allow them to use only certain

reports.

• Worked on SSIS for t ransferring data from Heterogeneous, Database (Text format data) to SQL

Server.

• Bulk migration of Data from Flat file from MS SQL Server in SSIS.

• Experienced in developing and monitoring SSIS Packages.

• Created and executed SSIS packages to populate data from the various data sources.

• Created SSIS packages using SSIS Designer for export heterogeneous data from OLE DB

Source (Oracle), Excel spreadsheet to SQL Server 2005.

• Transferred data from various data sources/business systems including MS SQL, MS Access,

F lat Files etc to SQL Server using SSIS/DTS using various features like data conversion etc.

C reated derived columns from the present columns for the given requirements.

• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.

• Responsible for mapping, extraction, t ransformation and validation of data from the various

data sources.

• Facilitated technical gap analysis meetings, identify gaps and propose solutions for IR2

M aintenance readiness.

• Developed, maintained and communicated project plan of HAMP applications to management

and all stake holders on a weekly basis.

• Communicated project status reports to all stakeholders.

• Contributed monthly metrics of all teams to senior leadership.

Content Studios LLC – Reston VA Software Architect 2008-2009

WirkFlow: WirkFlow is Business process management for an Enterprise Workflow management

and business process customization software. The project is built startup to enable business to

manage the Work f low.

• Co-ordinate business requirements meetings, data models and technical specs.

• Responsible for requirements gathering from business and implement the back end integration

of the product and in designing the database for WirkFlow.

• Developed logical and physical data models using ER diagrams and Flowcharts that capture

current state/future state data elements and data f lows.

• Gathered LOEs for product development and align with Release schedule.

• Created Prototype of the Business Requirements for workflow.

• Facilitated and participated t roubleshooting and brainstorming sessions for T-SQL procedures,

packages and batch process.

• Developed Chart Reports, Drill through Reports, Master Detail Reports and Multiple reports.

• Generated multiple reports (SSRS) from SQL Server Database and included various reporting

features such as group by, drilldowns, mat rix, parameters and deployment.

• Co-ordinate code review meetings for SSRS reports, stored procedures, Functions, Packages,

SQL scripts to facilitate the functionality for ad hoc WirkFlow modules.

• Generated project reports on a periodic basis and communicate to all stakeholders.

CodeRyte I nc. – Bethesda M D Software Developer 2007-2008

CodeRyte is a Computer Assisted Coding and Revenue Cycle Workflow Management application

and service. I t enhances the ability of Hospitals, Physician groups, and billing companies to code

accurately, quickly, and maximize appropriate reimbursement. CodeRyte is a product in that it

consists of software to automatically code notes and allow coders to review, correct, and otherwise

manipulate these notes. At the core of the product is a Natural Language Processing (NLP) engine

w hich analyzes the content of a medical document (typically an electronic text document that a

physician has dictated) and identifies the CPT codes for the procedures performed and ICD-9-CM

( ICD) codes for the diagnoses described.

• Met with Clients on a weekly basis to go over the growing needs and identify and priori tize the

enhancement for the NLP database procedures.

• Involved in creating detailed task list for the SQL Server upgrade.

• Created Report Manager for different departments based on their Unique Requirement.

• M igrated DTS packages to SSIS packages by modifying those packages.

• Designed ETL packages dealing with different data source and loaded the data into target data

sources by performing different kinds of t ransformations using SSIS.

• Bulk data migration using SSIS from f lat files.

• Analyzed the business requirements and assess the technical limitations and product scope.

• Worked on all types of report types like tables, matrix, charts, sub reports etc.

• Extensively worked in SQL SERVER, T-SQL, SQL, Query performance tuning, Created DDL

scripts, Created database objects like Tables, Views Indexes, Synonyms and Sequences.

• Delivered T-SQL code by adhering to Agile/Scrum development process.

• Involved in Performance tuning of complex queries which involve NLP Engine.

• Supported production migration activities for deploying N LP database procedures and batch

jobs.

George Mason University, Bioinformatics 2000 – 2008

PhD Student

ATCC - Manassas VA 2007

Bioinformatics Developer: Developed proof of concept projects using Weka, Object Oriented

p rogramming in Python, PERL, ORACLE 10g and HP-UN IX

• Organized lab sessions.

• Taught RDBMS, SQL, PL/SQL and Networking concepts.

• Graded database projects and assignments.

• Assisted student’s projects in lab.

I TT-Tech I nstitute, Seattle Software Developer and T rainer

2002 – 2003

• Taught programming concepts in SQL, T-SQL, C++, Data Structures in C++ using VC++ 6.0,

H T M L/XML/XSLT.

• Designed course syllabus, subject materials, assignments and projects.

• Designed/code/test/debug programming projects and assignments.

• Trained/mentored students with database management systems and programming

concepts/coding.

• Organized seminars and conduct technical presentations.

Contact this candidate