We provide IT Staff Augmentation Services!

Senior Data Warehouse Resume

Fairfax, VA

SUMMARY

Senior Database Developer, DBA, and Data Warehouseconsultantwith 13 years of experience with leading companies like Nationwide Insurance, AOL, PNC Bank, and Sprint.Well versed in database modeling usingErwin, Oracle, Teradata, DB2,SQL Server, andINFORMATICA. Strong database design (both physical and logical) experience. Excellent database development skills withPL/SQLand SQL. Excellent understanding of Data Warehouse concepts and techniques. Ability to lead a team or work independently.

EDUCATION
Technical Training of SAP BASIS & BW
Master of Computer Applications
Certified Oracle DBA

SKILLS

OPERATING SYSTEMS
AIX 4.1 /4.3, UNIX (SUN SOLARIS 2.6, HP 10.2), MS-DOS, WINDOWS 95/98, WINDOWS/NT

LANGUAGES
PL/SQL, UNIX KORN SHELL, BASIC, COBOL, SQL 2000, MS-SQL

DATABASES
TERADATA, ORACLE8i/9i/10g,FOXPRO 2.5, SYBASE IQ, MS SQL SERVER 6.5, DB2

DATA WAREHOUSE TOOLS
ORACLE WAREHOUSE BUILDER11g/10g,INFORMATICA ,POWER EXCHANGE, DATASTAGE, BUSINESS OBJECTS, SAP BW

SOFTWARE
DEVELOPER/2000 (FORMS 4.5, REPORTS 2.5), TOAD, INFORMATICA, ERWIN
DESIGNER 2000, SQL LAB, REPLICATION RMAN (RECOVERY MANAGER) SERVER MANAGER, ENTERPRISE MANAGER (OEM), SQL*DBA, SQL*PLUS, NET 8, SQL*LOADER, PERFORMANCE, MANAGER, MAESTRO

EXPERIENCE

Confidential Fairfax VA March2011 – Present
Senior Data Warehouse Lead Analyst

  • Involved in business analysis, ETL requirements gathering, physical and logical modeling and Created Fact and Dimensional tables using Erwin for Exceptions Datamart for Hamp Programme started by US Treasury.
  • Designed testing requirements and code modules according to specifications and client standards. Prepared test plans and modules. Developed program and system documentation.
  • Worked with DBA to move all the ETL process code into QA and Production environment.
  • Wrote Shell script wrappers for Pre and Post session jobs.
  • Responsible for data modeling and data warehouse configuration services for Hamp Programme.
Environment:HP-UX, Oracle 11g/10g,Oracle,INFORMATICA9.0, PL/SQL, UNIX Shell Scripting ,IDQ, BOXI

Confidential Fairfax VA Jan2010- March2011
Senior Data Warehouse Lead
As aData Warehouse Lead and Informatica/ETLconsultant,architected anddeveloped ETL software modifications for a data warehouse and associated data marts inInformatica

  • Designed the data-model. Implemented indirect ETL data-loading using dynamic list files that were generated by shell scripts.
  • Designed and developed Informatica Mappings to load data from Source systems to Data Warehouse and then to Data Mart.
  • Extensively used Power Center/Mart to design multiple mappings with embedded business logic.
  • Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica Designer.
  • . Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner
  • Parameter files were generated dynamically using UNIX scripts to provide values for the ETL sessions
  • Created mappings, sessions and scheduled workflows. Implemented SCD-1 for change capture in the data.
  • Generated Adhocs reports from Buisness Objects Universe on demand requirement from customers.
  • Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.
  • Improved Data quality of incoming source data from various federal agencies using IDQ (Informatica Data Quality)plans.
  • Involved in Administrative tasks including deployments to different environments and administration of admin console tasks.
  • Handled unit-testing, integration testing and User-Acceptance test cycles
    Code migrated from DEV to QA and QA to PROD
    Handled post Go-Live Production Support
Environment Sun Solaris8.0, Oracle10g, PL/SQL, DB2, UNIX, Erwin4.1, INFORMATICA (POWER CENTRE8.1.6),IDQ, TOAD , Buisness Objects.

Confidential Jan2009 –Dec2009
Sr. ETL Lead

  • Worked as Developer in all phases of project life cycle responsible for System Analysis, Design and Creation of Database objects like Tables, Indexes, Constraints, Stored Procedures, Functions and Triggers
  • Responsible for Business meeting, conversion of business rules into technical specifications.
  • Worked with various active transformations in Informatica PowerCenter like Filter Transformation, Aggregator Transformation, Joiner Transformation, Rank Transformation, Router Transformation, Sorter Transformation, Source Qualifier, and Update Strategy Transformation.
  • Participated in business analysis, ETL requirements gathering, physical and logical modeling and Created Fact and Dimensional tables using Erwin.
  • Worked with DBA to move all the ETL process code into QA and Production environment.
  • Designed and implemented performance improvement changes to nightly ETL processes using Informatica and SQL Server2005 and Oracle databases.
  • Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.
  • Involved in Administrative tasks including deployments to different environments and also worked on upgradation of Power center from 7.1.1 to 8.1.1.
  • Wrote Shell script wrappers for Pre and Post session jobs.
  • Devleoped PL/SQL database procedures and functions for ETL transformations.
  • Developed and tested a number of ETL scripts and mappings using Informatica8.16 to accept student data into a Staging and Data Warehouse databases.
  • Wrote ETL packages using SSIS integration service for Core project.
Environment HP-UX,, Oracle10g,Informatic8.1.6 , UNIX, SQL SERVER2005, Autosys,TOAD

Confidential Jan2008 – Dec2008
Data Warehouse Lead

  • Worked as Data Warehouse Architect in all phases of project life cycle and Responsible for.Mentor other team memberstocomplete deliverables on time.
  • Developed and tested a number of Oracle Warehouse Builder ETL mappings and process flows using OWB to accept Items , Costs and Pricing data from different ERP sources Including Oracle EBS , Cullinet and JD Edwards into a Staging and Global Data Warehouse database.
  • Maintained and supported data transfer programs which included PL/SQL, UNIX shell scripts, and SQL Scripts.
  • Directed new development by providing analysis, design, programming and database expertise. Organized task lists and delegated work to subordinates.
  • Created stored procedures, functions, Triggers, and packages according to database specs.
  • Designed the various subject areas for Existing Model Mart using Ralph Kimball Methodology
  • Responsible for integrating master data requirements across multiple projects and building an external master data models in Erwin.
  • Allocated system storage and planned for future storage requirements for the databases. Modified and altered the database storage parameters as needed.
  • Involved in Data Extraction in homogenous or heterogeneous environment.
  • Worked within a team to populate Type I and Type II slowly changing dimension Item, Cost tables from Oracle EBS tables.
Environment:HP-UX, Oracle 11g/10g,Oracle Warehouse Builder 11g, PL/SQL, UNIX Shell Scripting, and Maestro, OEM (Oracle Enterprise Manager),OBIEE

Confidential April 2007 - Dec2007
Data Warehouse Lead

  • As anData Warehouse Leadstreamlined and tuned accounting related ETL to be more efficient using Teradata, Oracle and SQL Server databases. Processing time for the accounting close period was reduced from 80 hours to 48 hours. Assist others in maximizing the use of Informatica in ETL processes.
  • Extensively worked in Oracle SQL, PL/SQL, Query performance tuning, Created DDL scripts, Created database objects like Tables, Indexes, Synonyms, and Sequences etc., Wrote Shell script wrappers for Pre and Post session jobs.
  • Developed and tested a number of ETL scripts and mappings using Informatica to accept Product ,Customer and Sales Activity , Product Activity data into a Staging and Data Warehouse databases.
  • Designed testing requirements and code modules according to specifications and client standards. Prepared test plans and modules. Developed program and system documentation. Worked within a team to contribute to the successful delivery of an Operational Data Store.
  • Involved in the design, development and implementation of the Enterprise Data Warehousing (EDW) process and Data Mart.
  • Successfully sourced Sales and Product Oracle,SQL SERVER data into Oracle8i Data Warehouse using PL/SQL procedures, function using Oracle10g features.
  • Primarily responsible for design and coding of fallout process to back fill missing data elements.
  • Worked within a team to populate Type I and Type II slowly changing dimension customer tables from several flat files..
Environment Sun Solaris5.8 , Oracle10g, Teradata, Buisness Objects.,UNIX,TOAD, INFORMATICA8.11/7.1.5, Autosys, ,POWER EXCHANGE

Confidential Jul2005 – April 2007
Data Warehouse Lead

As anInformatica/ETLconsultant,designed, modeled,developed ETL software for a data mart inInformatica.Data was sourced from Oracle databases. Data was utilized by Hyperion reports

  • Participated in business analysis, ETL requirements gathering, physical and logical modeling and Created Fact and Dimensional tables using Erwin.
  • Responsible for the daily transfers of data from various external systems into theDatamartdatabase. Maintained and supported data transfer programs, which included T/SQL, PL/SQL, SQL Loader scripts, UNIX shell scripts, and SQL Scripts.
  • Designed Technical specifications of Informatica ETL extract process for junior developers.
  • Involved in deployments and setting up new repository including folders connections and other informatica objects naming conventions.
  • Worked with DBA to move all the ETL process code into QA and Production environment.
  • Wrote Shell script wrappers for Pre and Post session jobs.
  • Devleoped PL/SQL database procedures and functions for ETL transformations.
  • Developed and tested a number of ETL scripts and mappings using Oracle Warehouse Builder to accept Investment data into a Staging and Data Warehouse databases.
Environment Sun Solaris5.8, Oracle10g ,UNIX, SQL SERVER2005, INFORMATICA7.1.4, MAESTRO,TOAD ,HYPERION

ConfidentialMay 2004 – Jun 2005
Senior DBA/Developer

  • Worked as Developer in all phases of project life cycle responsible for System Analysis, Design and Creation of Database objects like Tables, Indexes, Constraints, Stored Procedures, Functions and Triggers
  • Created (or edited existing) Informatica mappings and sessions to accomplish data migrations. Sources were Oracle and DB2 databases and flat files and targets were flat files. Created database procedures to accomplish data migrations from flat files to flat files. Assisted colleagues in developing requirements. Used Informatica, SQL*Plus, and SQL Advantage.
  • Created mappings and workflows for OEDS database to move all the teachers’ data into person, phone, address and location related tables.
  • Migrated all the Core Projects Mappings from Power Mart 5.1 to Power Centre 7.1.1.
  • Designed and Developed ETL application to link SAFE Application users with Polaris Application after the analysis of Business requirements.
  • Designed Staging and suspension tables for Core projects.
  • Designed Logical Model for Reading First Ohio Project for web services application.
  • Converted ETL process written in PL/SQL Oracle10g into INFORMATICA7.1.1 to Load Assessor data.
  • Created ETL for Loading Alternative Program Subject Area related tables from flat files.
  • Worked with DBA to move all the ETL process code into QA environment.
Environment HP 11i, Oracle9i, PL/SQL, DB2, UNIX, Erwin4.1, INFORMATICA (POWER CENTRE7.1), TOAD ,

ConfidentialJuly 2003 - April 2004
ETL Lead Developer

  • Responsible for the daily transfers of data from various external systems into the TeradataDatamartdatabase. Maintained and supported data transfer programs, which included,PL/SQL, SQL Loader scripts, UNIX shell scripts, and SQL Scripts. \\
  • Directed new development by providing analysis, design, and programming and database expertise. Organized task lists and delegated work to subordinates.
  • Worked on the migration of the database and its data to a new UNIX system. This involved using both shell scripting and PL/SQL programming to ensure the correct recreation of the new database exactly as it existed on the old system
  • Developed and tested a number of ETL scripts and mappings using datastage to accept policy data into a Teradata database. utilized by a Data warehouse application. The ETL application (written in Datastage and PL/SQL 8I) takes advantage of the Bulk Copy utility to load data, and Oracle stored procedures to manipulate the policy data to the needs of the Data warehouse application.
  • Worked on CLS logs maintenance using PL/SQL scripts by modifying the existing jobs.
Environment Sun Solaris 5.8, Oracle9i, PL/SQL, INFORMATICA7.1, UNIX, Erwin4.0, TOAD, Buisness Objects.

ConfidentialSeptember 2002 – June 2003
Senior Data warehouse Developer

Lead Database ModelerandETL developerresponsible for database modeling, physical and logical database design, designing database storage structures, creating database objects, and data mapping.

  • Responsible for data modeling and data warehouse configuration services for the Calling Card and toll free product Data.
  • Provided expertise for the development of Use Cases and the development of logical and first-cut physical data Models usingErwin, Translation of normalized model to starschema
  • Lead the model validation sessions, development of warehouse metadata, and identification and mapping of Data sources
  • Worked on the migration of the database to Teradata and its data to a new Unix system. This involved using both shell scripting andPL/SQLand various Teradata Data conversion utilities.
  • Worked on Unix Korn Shell script to automate the process to run in QA environment.
Environment HP11.0, Oracle8i, PL/SQL, SAP PP, BW,UNIX, INFORMATICA (POWER MART5.1), TOAD, ,Peoplesoft EPM

ConfidentialNov 2001 to Sep 2002
SeniorData WarehouseDeveloper

  • Worked as Developer in all phases of project life cycle and Responsible for.Mentor other team memberstocomplete deliverables on time.
  • Responsibilities included design of thestar schemas, interfacing with subject matter experts in the development of warehouse reporting requirements, detailed mapping of reportdata to warehousetables and columns, maintenance of thedata model within Erwin, and design and development of warehouse reports using Crystal Reports
  • Provided physical database performance tuning, which included resolving fragmentation and disk contention issues. Also provided database tuning through SQL Tuning.
  • Defined back ups and recovery strategy and maintained back ups. Automated the processes by writing Corn Shell Scripts.
  • Created and performed troubleshooting of database Triggers and Stored Procedures usingPL/SQL and TSQL.
Environment HP11.0, SQL SERVER7.0, Oracle8i, DB2, UNIX, Pl/SQL, INFORMATICA (POWER MART5.0), SQL LOADER, Erwin, TOAD

ConfidentialJan 2000-Oct 2001
Senior DBA/Data Modeler

  • Responsible for the daily transfers of data from various vendors into the Oracle databases. Maintained and supported data transfer programs which included PL/SQL, SQL Loader scripts, UNIX shell scripts, and SQL Scripts. Directed new development by providing analysis, design, programming and database expertise. Organized task lists and delegated work to subordinates.
  • Defined back ups and recovery strategy and maintained back ups. Automated the processes by writing Corn Shell Scripts.
  • Working with the business owners and consumers of data across the company and the appropriate IT manager(s) documenting business needs and develop solutions consistent with industry best practices for data warehousing.
  • Provided physical and logical design of star-schemas and slowly changing dimensions, including demonstrative detail in the construction of table partitioning, materialized views, query rewrite, and star transformation
  • Extensive experience with Oracle Warehouse Builder creating Star schemas,Partitioned Materialized Views & Logs utilizing Query Rewrite, Star Transformation and Quer Equivalence.
  • Creation of complex stored procedures, triggers, functions, packages and views, external file manipulation , Heterogeneous Database links using Oracle gateways. Database Monitoring, Performance Tuning. PL/SQL Development, development DB.
  • Involved in Data Extraction in homogenous or heterogeneous environment.
  • Data Conversion from DB2 to Oracle 8.1.5

EnvironmentHP11.0,Win NT ,Oracle8I , DB2, PL/SQL,ER-Win,DB2, Business Objects, Oracle Warehouse Builder

ConfidentialAug 1999- Dec 1999
Senior DBA/Data Modeler

  • Designed, developed, and tested the system using Oracle SQL*Forms 4.5, as well as SQL*Plus, PL/SQL
  • Used Oracle PL/SQL programs to load data to a competitive analysis reporting system designed in Access. Data originated from mainframe tapes and was manipulated on a DEC/VMS system before final exportation to a PC platform. Also wrote formal test plan and tested the system.
  • Responsible for project plan, short term and long term Caching Strategy, intermediate and final Caching Solution, Data Modeling, Pl/SQL code and upgrade
  • Loading data from flat files to database by using SQL*Loader by using Export and Import utilities to maintain a schema objects under different databases.
  • Designed a reporting module for Finance Department usingDimensional Modeling
  • Implemented the database monitoring system using shell Scripts

EnvironmentSun Solaris 2.6, Oracle 8.0.5, Oracle Application Manufacturing 11.0, Crystal Reports, PL/SQL, Developer 2000 (Forms 4.5, Reports 2.5), Designer 2000, Platinum Tools, ER-Win

ConfidentialJuly 1998 - July 1999
Oracle Developer

  • Worked as Developer in all phases of project life cycle Responsible for complete deliverable. System Analysis Part Designing and Creation of Database objects like Tables, Indexes, Constraints, Stored Procedures, Functions and Triggers Development and Testing Preparing checklists for steps included in the daily project.
  • Provided physical database performance tuning, which included resolving fragmentation and disk contention issues. Also provided database tuning through SQL Tuning.
  • Defined back ups and recovery strategy and maintained back ups. Automated the processes by writing Corn Shell Scripts.
  • Created and performed troubleshooting of database Triggers and Stored Procedures usingPL/SQL.
  • Wrote shell scripts for automation of various database-monitoring activities.
  • Developed and maintained application and database security standards.
  • Trained end users in the effective usage of the database

EnvironmentHP9000/x, Window NT 4.0, Windows 95,Oracle PL/SQL,SQL SERVER, ErWin3.0,SQL LOADER

Confidential July 1996 – Aug 1998

Worked asProgrammer AnalystandQA Analystfor two years in Data Processing and Information Systems. Applications experience is centered on databases and Information retrieval in Data Warehousing applications and Financial Systems of Large Thermal Power Plant.

  • Responsibilities included Analysis, Design, Coding, Testing and Implementation as a team member. Well versed with GUI Development and Client Server applications in Oracle environment using Developer 2000 as Front end tool.
  • Member of team which designed conversion of COBOL/400 based system to Client Server environment using Oracle. All programs which were not useful when we used oracle were to be removed and their links to be converted without much transition because old staff was to be retained.
  • Converted lots of screens in Forms 4.5 and converted several reports in Reports 2.5.
  • Created database triggers, forms triggers to reduce the complexity which was involved in file based old system.
  • Involved in system testing and test plan preparation

EnvironmentHP 9000, Oracle 7.0, HP-UX 10.2, Windows NT, SQL*FORMS (4.5, 3.0), SQL*Reports 2.5, PL/SQL, DBASE IV, COBOL/400, CL/400, AS400 Query/400 and OS/400

Hire Now