Management Data
Resume:
Durga Yerramilli
**********@*****.***
**** ****** ****** **** #*** 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