Sql Server Data
Resume:
L ATHA BHUVANAPALL I P MP
*********@*****.***
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