Durga Yerramilli

678-***-****

abmaki@r.postjobfree.com

**** ****** ****** **** #*** Glen Allen VA - 23059

Experience Summary:

Extensive experience in information technology with end to end project deliverables ranging from database design,

architecture, development and modeling, re-engineering, data transformations of relational and dimensional databases.

Extensive Knowledge in 3NF, Conceptual, Logical and Physical modeling of databases.

• Diversified technology experience with technology stack different source systems and databases such as SQL,

Oracle, DB2 and Teradata; ETL tools such as SSIS, DataStage, data junction, DT Studio; data modeling tools

such as Erwin, Cast Workbench; reporting tools such as SSRS, Crystal Reports and BI tools as SSAS. Also have

experience in Document Management Systems, PC Docs & InterWoven. Experience in program and project

management with MS Project and Agile.

• Extensive delivery experience and expertise on requirements management, DW architecture, ETL and database

design.

• End-to-end project planning and delivering. Set standards with SDLC.

• Setting standards in code review and documentation.

• Expertise and experience in security management, retention management, recovery management, estimates and

projection management of database systems.

• Experience in leading both onsite and offshore teams.

• Training\Certifications:

o Trained in SSRS development \Admin by MS

o Trained in document management systems by Interwoven Corp.

o Brown Belt in Six Sigma

o Gold Certification in Project Management\IT Unified Process by ATT University

• Winner of ATT Innovation Concept in 2011 & 2012

Education:

1994 MS in CS from Southern College of Technology Marietta, GA

1994 Ph. D in Anthropology from Andhra University India

Work Authorization:

US Citizen

Technologies Worked On:

Design Languages: Erwin, MS Visio, Cast Work Bench, DT Studio

Databases/Application Servers: SQL Server 6.5 - 2012, Oracle 9 - 11g, Teradata, Sybase, DB2

Programming Languages/GUI: TSQL, PL\SQL, SQL, ASP.Net, C#, XML\XSL, Scripting, MDX, Toad

Tools: SSIS, SSRS, Visual Studio, MS Project, Agile, DT Studio, Data Junction,

Change Management &Version Rational Clearcase, HP ALM, MS TFS & visual source safe, PVCs

Control Tools:

Industry Experience:

Health Care, Financial and Banking, Telecommunication, Insurance, Consulting and Business Processes

Work Experience:

Genworth Financial - Enterprise Data Warehouse

Aug 2014 – Current

Role: Role:Solutions Architect\Data Modeler

Responsibilities:

• Establish process improvements in bringing overall efficiencies of delivery.

• Improving Code Review and documentation standards.

• Working very closely with business stake holders, BAs and data analysts and working with BAs is designing Data

marts and Models.

• Working on POC and Road map of migrating the existing Models to new Appliances and Big Data Concepts.

• Reverse Engineering existing models and creating Data Dictionaries.

• Establishing Data Audit frame work and data governance standards.

SunTrust - Enterprise Data Warehouse\BI Risk Management

July 2013 – Aug. 2014

Role: Technical Lead\Data Modeler

Responsibilities:

• Establish process improvements in bringing overall efficiencies of delivery.

• Managing onsite and offshore teams; improving Code Review and documentation standards.

• Providing realistic estimates and working with other tech leads both on site and off shore.

• Working very closely with business stake holders, BAs and data analysts and working with BAs is designing BRD.

• Working with DAs with data analytics and hands on data modeling.

• Providing work order estimates to PMs and system estimates to operational teams.

• ALM change Management.

Cognizant Technology Solutions - Enterprise Data Warehouse Division

July 2012 – 2013

. Role: Technical Delivery Manager\Data Warehouse Architecture

Worked with healthcare client’s data warehousing needs for AMHP (Client) - EXP Maces, a healthcare

Claims\Service Forms Processing System

Responsibilities:

• Made process improvements in bringing the overall delivery efficiencies and managed onsite and offshore

teams.

• Re-engineered and re-architected BI solutions using MS technologies.

• Initiatives in building knowledge assets such as creating BRDs /FRDs & inventory documents of the reports.

• Introduced best practices, and recommended best practices in coding; did performance tuning.

• Introduced new method of transferring data instead of a report where a daily dump was needed and had

overall delivery responsibility.

• Utilized MS TFS for version control and change management.

• Took on defects prevention initiative; improved data quality issues and standardized ETL process.

AT&T (Bell South Inc.)

Jan 2006 – July 2012

Role: Lead\DBA\Database Architect

Responsibilities:

• Performed database architecture, reengineered legacy database systems.

• Initiated projects and completed full life cycle.

• Architecture of unified database driven ETL process with SSIS & Datastage for daily data dumps thus improving

data load performance by 25% and reducing load time by 2 hours. The ETL architecture allowed any new Source

or Data type integration to be seamless.

• Architected transaction replication topology on SQL Server as publisher, and SQL servers and Oracle Server as

subscribers for high availability systems and real-time availability of data.

• Designed data transformations from legacy systems to new systems with SSIS and SQL Loader.

• Integrated multiple legacy systems to unified database model.

• Designed and developed system maintenance modules and reporting with SSRS and led a team of developers both

onsite and offshore.

• Set up industry standards in design and coding; conducted code reviews and project reviews.

• Performed security, retention and recovery management of the systems.

• Quarterly capacity planning and estimates of the systems and budgeting.

• Saved approximately $100,000.00 by researching licensing options of software.

• Monitored SQL Server health with performance tuning and daily maintenance of database systems and

performing 24\7 on call for high availability of databases.

• Maintained team’s SharePoint site and ran audits on data dumps.

• Utilized Visual Source Safe and designed customer application for change Management

• Also worked with Clear Case.

Independent Consultant

2004 Jul – Jan 2006

Reed Data Construction

Role: Independent database Design Consultant

As an independent Consultant worked in various short term and long term projects.

• Primary responsibilities included architecting and designing operational database and data marts.

• Developed ETL process using DT Studio and SQL DTS. Also responsible for programming some C# in

Visual Studio Interface. DT Studio was ETL Tool.

• The primary responsibilities included generic DBA tasks and managing EDI project with a team of 6 DBAs;

developed conceptual model for data warehouse and Created design specs for implementing OLAP and

Report Services.

• Actively involved in implementing change control management and version control management.

• Assisted in-house development efforts and implemented database solutions.

• Administered and maintained document management systems.

• Synchronized data between old PC DOCS application ad current pilot implementation of Interwoven.

EXTREMELOGIC\HEWLETT PACKARD

Nov 1999 – July 2004

Role: Senior Technology Consultant\Database And Data Warehouse Architect

Responsibilities:

Worked on a business transactions projection project at Pfizer.

•

Primary responsibilities were development and architecture of database and analysis services models and business

•

Intelligence solutions for Financial Forecasting system.

Architected, designed & developed database for financial forecasting system (BI solutions).

•

Designed Relational database and star schema database for analysis services. Responsibilities included writing

•

stored procedures and user defined functions.

Designed and wrote cubes and MDX queries.

•

Maintained and administered daily changes and development of database for the applications. Wrote batch files to

•

update changes.

Scheduled jobs and job alerts. Downloaded data by various means such as DTS and Scripting.

•

Trained in Business Intelligence with Microsoft Enterprise technologies.

•

Worked on Microsoft SQL Reporting Services.

•

Engaged in pre-sales presentations and prototype development of Microsoft Report Server Applications for the

•

knowledge bank.

Developed Custom Forms for Outlook for Web Access for Exchange Server 2003.

•

Developer

Jan 1995 – Oct 1999

• Developed Web based Application in VB 5.0. Designed and developed Oracle 7.0 Database.

• Developed and Implemented Customer Service Application in VB 5.0

• The application allows the operators to take customer requisition for credit verification.

• The cases and data are then transferred to Mainframe.

• The application also has the capabilities of automatic reminder letter generation.

• Developed Custom COM and DCOM Objects with VB 6.0

• Development for OLTP in SQL SERVER 7.0.

• Used Data junction for Download and Upload Data from various Sources.

• Used Cast Workbench for Data modeling.

Contact this candidate