SUMMARY:

• 19+ years of IT experience in Project management, design, development, data warehousing, ETL, performance tuning, data modeling, logical and physical database design for OLAP and OLTP systems.
• Managed and supervised Oracle analytical applications, DW/BI design and development of Data Warehouse Projects (6+ Yrs). Responsible for Enterprise data warehouse architecture, design and deployment projects for various clients in Finance (4+ Yrs), Insurance (2+ Yrs), Telecommunications (5+ Yrs), Human Resources (2+), Services (7+ Yrs), and Supply Chain (2+ Yrs).
• Mentored the team of Application/data and Solution designers and developers off and on shore of 20 million dollars. Worked closely with the Business Owners and requirements team in identifying the requirements and functional specifications to meet needs.
• Responsible for Business Analysis Processes. Maintained smooth communication with stakeholders, Business and Technical team. Prepared Business, technical and requirement documents as per industry standards.
• Created and managed project budget vs. actual expenditures (capital and expense). Managed the team’s day to day activities to ensure on budget and on time delivery of all applications. Reported progress to the steering committee.
• Lead Re - engineering, design, development of Data Warehouse project to enhance the performance. Strong experience in Design and Development of Extraction, Transformation & Load (ETL) processes, Enterprise Architecture, Master Data Management and Master Data Management using Informatica, Oracle Data Integrator (ODI), Oracle, Sybase and BI report development using Cognos, BO and Hyperion.
• Strong understanding of Enterprise data warehouse architecture and Big Data. 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. Proficient in Unix Shell scripting.

SKILLS:

Project Management - 6 years; Lead/Management Experience - 10 years; Agile - 4 years; MS Project - 4 years; Business Intelligence - 10 years; Data Warehousing - 10 years; ETL - 10 years; Informatica - 8 years; OBIEE - 4 years; Oracle - 10 years; MDM - 4 years;

TECHNOLOGY:

Management: MS Project, MS Power Point, MS Office, PMI

CM Tools: Clear-Case, PVCS, MKS, CVS, Subversion

BI Tools: Brio, Hyperion, Cognos, Business Objects

GUI Tools: TOAD, PowerBuilder 6.x, SAP R/3 Financials, Crystal Reports, SharePoint

Databases: Oracle 11g-7x, Sybase 12.x, MS Access, SQL Server, Watcom, Star, 1032

Data Integration: Informatica 11.x-7.x, ODI 11.x/10.x, Ab-Initio, Decision-Base Transformer

Design Tools: Cast, PowerDesigner, ERwin, Visio

Languages: PL/SQL, SQL, C, Java, JavaScript, ASP, XML, HTML, Shell scripts, Perl

Systems: UNIX HP/AIX/SCO, Windows NT/7, Sun Solaris 9.x

EXPERIENCE:

Confidential

Adviser/Consultant

Responsibilities:

• Guided for Management, Training and Development. Discussed with CEO of Confidential for their Business requirement and accordingly mentoring technical team in Human Resources product development life cycle.
• Mentored technical members for company’s product development. Presented and trained them to broaden their technical and project management skills.
• Responsible for design, development and implementation of enterprise architecture. Customized related ETL / ELT processes and resolved related issues. Improved ETL / ELT architecture and SQL scripts for improved performance. Responsible for mentoring data warehouse and report developers.
• Managed multiple project deliverable activities. Guided and Implemented industry standards best practices for project development and testing. Responsible for planning project release date as per the requirement of the clients. Assigned the responsibilities of gathering business requirements to include in project planning. Handling the tasks of tracking and monitoring the staff by gathering project reports on a weekly basis.

RDBMS: Oracle 11g/10g, SQL Server, MySQL, UNIX, Windows

Tools: Informatica 10.x, Pentaho, ODI 11.x, TOAD 10.x, ODI 11.x, Agile, ERwin

Confidential, California

Data Warehouse Architect/ETL Manager

Responsibilities:

• Worked with the Technical Director and key Stake holders in creating the project plan, status documents and other communication artifacts. Prepared project plan and delivery schedules. Briefed steering committee on progress report of projects. Set development standards and best practice guidelines. Defined and prepared handover documents.
• Responsible for design, architecture and development of Databases and Extraction, Transformation and Load (ETL) processes. Incorporated master data management. Analyzing current production ETL processes to design future MASAGA ETL processes. Developed complex business logics.
• Prepared project related design documents, Level of Effort and design documents. Guided developers in development and design of ETL mappings for product databases.
• Lead the team of data and Solution designers and developers off and on shore of 20 million dollars. Managed the teams day to day activities ensure on budget and on time delivery of all applications. Reported progress to the steering committee.
• Lead and responsible in mentoring ETL and Database developers. Working on project planning and requirement gathering of ETL processes. Design of business Metadata.
• Responsible for Proof of Concept (POC) analysis for MASAGA project. Created POC Matrixes and charts for upper senior management Analysis.

RDBMS: Oracle 11g/10g, SQL Server, MySQL, Postgres, UNIX, Windows

Tools: Informatica 9.x, TOAD 10.x, SQL Developer, PL/SQL, SQL Plus, TOAD Data Modeler 3.x, Agile

Confidential, California

Data Warehouse Manager

Responsibilities:

• Responsible for leading the design, development and maintenance efforts of the company’s insurance related data warehouse of 5 million dollars. Responsible for Enterprise Architecture.
• Prepare project plans, milestones, and resource allocation. Execute projects with resources On-Site as well as Off-Shore. Interact with business users; gather requirements; develop ETL design; prepare mapping documents, develop high level and detail ETL designs.
• Defined areas of improvement to optimize data flows. Conducted root cause analysis and resolved production related problems and data issues. Implemented industries best practices for software development.
• Monitored performance of production Extract, Transformation and Load (ETL) processes and responded to errors and emergency problems.

RDBMS: Oracle 10g/9i, Windows XP

Tools: SQL Developer, PL/SQL, SQL Plus, ERwin, ODI 10.x Agile

Confidential, California

Data Warehouse Consultant

Responsibilities:

• Responsible for design, development and implementation of Customer and Billing System Data warehouse.
• Customized production related ELT processes and resolved related issues.
• Improved ELT architecture and SQL scripts for improved performance.
• Responsible for mentoring data warehouse and report developers.

RDBMS: Oracle 10g/9i, Unix, Windows XP

Tools: TOAD, PL/SQL, SQL Plus, ODI 10.x, Erwin, Agile, Cognos

Confidential, Virginia

Defense Logistics Agency, Lead / Architect

Responsibilities:

• Reported to Vice-President Confidential .
• Once a week Communicated, Discussed and Updated project management related status and issues to VP.
• Discussed Design, Architect and development related current and future plans with upper management for 20 million dollar project..
• Provided technical leadership and guidance to team members of size 30. Diagnosed and resolved problem areas in the current system and improved the ETL performance considerably. Mentored the team for design and code development.
• Responsible for gathering business requirements, BI Analysis and analytics, solution definition/development, enterprise architecture design and dimensional modeling for associated data marts. Incorporated master Data management.
• Created and managed project budget vs. actual expenditures (capital and expense). Managed the teams day to day activities ensure on budget and on time delivery of all applications. Reported progress to the steering committee.
• Designed, Developed and tested mapping, maplets, sessions, worklets and work flows for ETL. Assisted analysts with data mapping, data profiling and IDQ (data quality).
• 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, Business Objects, Agile

Confidential, Virginia

USAID, Senior Member / Lead

Responsibilities:

• Designed, developed and tested ODS (Operational Data Store) System and Data Warehouse. Tasks included project plan, schedules and timelines, Weekly Status reports and document reviews.
• Interviewed Business, collected functional requirements and converted those requirements to technical specs. Responsible in delivering Data Analysis, Data Profiling, IDQ (Data Quality), ETL Architecture, analytical and operational reporting and MDM
• Worked closely with the end-users, technical staff and team members to develop and design Data Marts/Dimensional Models and ETL mappings. Recommended ETL changes to improve maintainability, data quality and performance.
• 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, PeopleSoft 8.x, Windows XP

Tools: TOAD, PL/SQL, SQL Plus, Informatica 7.x, ERwin, Unix, Shell Script, Business Objects, Agile

Confidential, Maryland

Social Security Administration, Technical Manager

Responsibilities:

• 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.
• Prepare project plans, milestones, and resource allocation. Execute projects with resources On-Site as well as Off-Shore. Interact with business users; gather requirements; develop ETL design; prepare mapping documents, develop high level and detail ETL designs.
• 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, PeopleSoft 8.x, Windows XP

Tools: TOAD, PL/SQL, Ab-Initio, Brio, Hyperion, MKS, Visio, ERwin, Unix, Shell script, Cognos

Confidential, Virginia

Data Warehouse Consultant

Responsibilities:

• 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