SUMMARY

• 15+ years of IT experience in Project management, Design, Development, Data warehousing, performance tuning, data modeling, logical and physical database design for OLAP and OLTP systems.
• Managed and supervised DW/BI design, development, analysis, training, and testing team for clients in the government, telecommunication, customer service, mortgage, publishing and defense industries.
• Lead Re-engineering, design, development effort of Data Warehouse project to enhance the performance. Strong experience in Design and Development of extraction, transformation and load (ETL) processes using Informatica and PL/SQL.
• Strong understanding of Data Warehouse concepts. Responsible for data model design using ERwin/Power Designer/Cast. Extensive experience in analysis, requirements gathering, design, and creation of technical documentation for OLTP and OLAP systems
• Strong skills in Analyzing and developing complex designs for Data Migration, Data Mart and Data Warehouse. Strong skills using Unix Shell scripts in importing and exporting data.
• Through knowledge in SQL and PL/SQL programming including effective use of Oracle packages, stored procedures, functions, database triggers using SQL*Plus and Toad. Extensive experience in SQL Performance tuning.

EXPERIENCE

Confidential, California, USA (Feb’10 – Till Date)
Consultant

• Responsibilities include design and development of a large Data Warehouse and ETL processes.

RDBMS: Oracle 10g/9i, Unix, Windows XP 
Tools: TOAD, PL/SQL, SQL Plus, ODI, ERwin

Confidential, Virginia, USA 
Defense Logistics Agency, Data Architect/ Consultant (Feb ’08 – Feb ‘10)
Asset Visibility System is used by the DLA to analyze their assets and movements. Lead the re-engineering design and development effort of Asset Visibility System to enhance data warehouse and Extract, Transformation & Load (ETL) performances.

• Provided technical leadership and guidance to team members. Diagnosed and resolved problem areas in the current system and improved the ETL performance considerably. Mentored the team for design and code development.
• Lead the team in the Design and development of data warehouse and ETL components (e.g. ETL process, staging, data quality). Responsible for gathering business requirements, requirement documentation, solution definition/development, data architecture design and dimensional modeling for associated data marts.
• Designed, Developed and tested mapping, maplets, sessions, worklets and work flows for ETL. Assisted analysts with data mapping and data profiling.
• Provided significant benefit to the customer in reduced data latency and reduced operating cost due to simplified and improvised design.
• Prepared project related design documents, Level of Effort and design documents to support ISO-9001 and CMMI standards.

RDBMS: Oracle 10g/9i, Windows XP 
Tools: TOAD, PL/SQL, SQL Plus, Informatica 8.x, ERwin

Confidential, Virginia, USA (May ’07 – Jan ‘08)
USAID, Senior Member
The Data Warehouse is designed and developed for USAID to combine financial, assistance and acquisition data to develop reports for high level executives and field managers of USAID.

• Designed, developed and tested ODS (Operational Data Store) System and Data Warehouse. Responsible for Extraction, Transformation and load (ETL) processes. Tasks included project plan, schedules and timelines, Weekly Status reports and design document reviews.
• Worked closely with the end-users, technical staff and team members to develop and design Data Marts/Dimensional Models and ETL mappings. Recommended data modeling and ETL changes to improve maintainability, data quality and performance. Designed, Developed and tested mapping, maplets, sessions, worklets and work flows for ETL.
• Worked with business groups to gather Business Intelligence requirements and lead the effort in translating them into an effective Data Warehouse design using Dimensional Modeling techniques to maintain data flow.

RDBMS: Oracle 10g/9i on HP server, Windows XP 
Tools: TOAD, PL/SQL, SQL Plus, Informatica 7.x, ERwin, Unix, Shell Script

Confidential, Maryland, USA (Aug ’04 – Mar ‘07)
Social Security Administration, Work Order Manager
Managed SUMS Data Warehouse project, to develop reports for field Managers and High Level Executives for the Social Security Administration in order to analyze field office performances.

• Provided supervision and guidance to team members. Responsible for hiring, mentoring, coaching, and professional development of the team. Provided technical support for troubleshooting and problem resolution for end users and team members.
• Developed procedures and functions to transfer data from staging tables to fact tables after applying business rules. Involved in design of logical and physical database Models and worked on test plans. Optimized query performance from 240 seconds to 20 seconds.
• Worked with customer to translate their business requirements into technical design document and worked closely with business analysts to document business needs. Established standards for development and maintenance of Data Warehouse.
• Responsible for status reports for the Work Order(s), Work Order Work Plans and Monthly Progress Reports. Met all Work Order Work Plan deadlines and maintained CMMI level 3 process standards across work orders.

RDBMS: Oracle 10g/9i on HP server, Windows XP 
Tools: TOAD, PL/SQL, SQL Plus, Brio, Hyperion, MKS, Visio, ERwin, Unix, Shell script

Confidential, Virginia, USA (Aug ’03 – Dec ‘03)

The project involved the transfer of data from Legacy Systems to the Oracle Production database.

• Compared data between legacy system and production test data before transferring data to production system. Created prototype of data models, and outlined Operational Data Store (ODS) needs and estimated impact on the project.

RDBMS: Oracle 9i on Solaris 8.x, MS Access on NT 4
Tools: Oracle 9i, PL/SQL, SQL Plus, MS Access, ClearCase

Confidential, Washington, DC, USA (May ’02 - Jun ‘03)

GATEWAY database is used as a staging database to extract data from STAR(System for Tracking and Administering Real-property) and other databases.

• Scheduled, Maintained and Executed Data Load. Developed Shell Scripts to bulk-copy data from the flat file to production and developed scripts to recreate the Table indexes, recompile and update the statistics of the Sybase objects.
• Maintained and updated Data Warehouse models. Generated and modified database schemas. Developed and enhanced procedures, reports and fixed production bugs. Lead the team of developers to solve production issues.
• Installed Oracle and new releases of GATEWAY, PSD (Procurement Summary Database) and other databases into production. Responsible for Import, Export, Patch Install, Version Upgrade, Extraction, Data Loading, SQL and PL/SQL Script. Performed Index rebuild to improve the query performance. Migrated data between Sybase and oracle database.
• Performed Disaster Recovery Process for STAR database and documented Disaster recovery process. Wrote Shell scripts to automate most of the Disaster Recovery Process.

RDBMS: Oracle 8i on NT 4/Sun Solaris 8.x/7.x, Sybase 12.x on NCR 5100
Tools: Oracle 8i, PL/SQL, Sybase 12.x, Transact SQL, DecisionBase Transformer 1.9, Shell script

Confidential, Washington, DC, USA (Mar ’98 - Apr ‘02)

Commission Registration / Practitioner Call Tracking System / FeeFiler / Collection Systems

• Supervised and managed a team of developers and testers. Communicated with end users in order to simplify business logic. Managed development and production related issues.
• Transformed business requirements into logical and physical data models. Created business rules, analyzed data sources and implemented test plans. Performed code optimization and performance tuning of financial Applications.
• Created Tables, Views, Stored Procedures, Triggers and fine tuned queries to enhance performance. Developed documentation deliverables including: data models, data flow diagrams, and entity-relationship diagrams.

RDBMS: Oracle 8i on Sun Solaris 5.7, Sybase SQL Server 12.x/11.x
Tools: PL/SQL, SQL*Plus, Cold Fusion, Unix, CAST, Crystal Reports, PowerBuilder 6.x, HTML, Java Script, XML, WDDX, PVCS Tracker, Transact SQL, Java, Actuate Reports, Shell script, ERwin

Confidential, Virginia, USA (May ’97 - Feb ‘98)
Consultant
Product Rating System is used by MCI users to provide product, feature, Call-Plan and rate related information to Local MCI customers.

• Created Packages, Procedures, Triggers, Export/Import, SQL*Loader Utility and Snapshots. Used DBMS_SQL, DBMS_JOB, UTL_FILE, and DBMS_PIPE packages for effective coding.
• Extensively used SQL Station Plan Analyzer and Explain Plan for performance tuning. Used Foundation Class Libraries, Tree Views, and Tabs for user interface. Developed Shell Script, Pro*C and Perl program to communicate with other systems.

RDBMS: Oracle 7.x on HP-9000
Tools: PowerBuilder 5.x/4.x, PL/SQL, SQL*Loader, Pro*C, HP-Unix, Shell, PowerDesigner

Confidential, New Jersey, USA (Aug ’96 - Apr ‘97)
Consultant
Executive Information System is for analysis of Financial and Human Resources information related to various departments.

• Used Inheritance, Classes, MDI, Crosstab, Tree View, Hot List and others for user interface. Created Custom user objects to minimize the usage of keyboard by the user. Developed several database procedures and triggers.

RDBMS: Oracle 7.2 on Sun Solaris 5.7
Tools: PowerBuilder 5.x, PL/SQL, Power-Designer, Power Point, Lotus Notes, Paint Shop

Confidential, New Jersey, USA (Feb ’93 - Jul ‘96)
Technical Analyst
Developed Engineering Information Systems using STAR database to analyze the inventory and suppliers performances. Implemented Total Quality Management (TQM) for all existing user interfaces.

Confidential (Oct ’90 - Nov ‘92)
Design Engineer
Developed project management system using SQL*Forms, Loader, Report Writer and PL/SQL

SAP R/3 Financials, Java, ASP, XML, Holos (OLAP) and Java Script. 
Completed 3 day Project Management training provided by Lockheed Martin 
Certificate Course on Project Management from George Washington University

EDUCATION

Master of Engineering

Bachelor of Engineering

Databases : Oracle 10g/9i/8i/8/7, Sybase 12.x, MS Access, SQL Server, Watcom, Star, 1032
GUI Tools : TOAD, Brio, Hyperion, PowerBuilder 6.x/5.x/4.x, Cold Fusion 4.x, SAP R/3 Financials, ClearCase, Pbdelta, Ab-Initio, Crystal Reports, Actuate Reports, Cognos, BusinessObjects, PVCS, MKS, Informatica 8.x/7.x
Design Tools : Cast, PowerDesigner, ERwin, Visio
Languages : PL/SQL, SQL, C, Pro*C, Fortran, Java, JavaScript, ASP, XML, HTML, Shell scripts
Systems : Unix HP/AIX/SCO, Windows NT/2000/98/95, Sun Solaris 8.x/7.x, VAX/VMS