SUMMARY

• More than 21 years of IT experience in Project management, design, development of business intelligence, data warehousing, ETL, performance tuning and data modeling for OLAP and OLTP systems.
• Developed strategy and framework to address advocacy, sponsorship, and continued assessment of the enterprise Architecture, along with the development standards and guidelines to be used in the program.
• More than 12 years of leadership and hands-on experience managing, designing, developing master data management MDM , business intelligence BI , analytics, visualization, data warehouse, data integration, quality, mining, governance, metadata and big data.
• Managed and supervised 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 5 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 project. Worked closely with the Business Owners and requirements team in identifying the requirements and functional specifications to meet needs.
• 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 and master data management using Informatica, Oracle Data Integrator ODI , Oracle, Sybase and BI report development using SAP BO, Cognos 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.
• Responsible for business analysis processes. Communication with stakeholders, Business and Technical teams to prepared business requirement and technical documents as per standards.

Accomplishments

• Built strategic relationship with vendors and reduced customization and implementation cost by 50 .
• Communicated with CxOs to align business strategy and increased customer base.
• Architected data processes for fortune 500 company and reduced latency to close to real time. Processing time was reduced from 50 minutes to 10 seconds.
• Reduced complex dashboard report generation time from 4 minutes to 30 seconds.

EXPERIENCE

Confidential

TCS Program Manager/ Technical Lead

• Developed strategy and framework to address advocacy, sponsorship, and continued assessment of the enterprise Architecture, along with the development of all standards, guidelines and metrics.
• Lead multiple teams working on multiple verticals of organization to precisely define, easily integrate and effectively retrieve data for both internal applications and external communication by following standard. Built strategic relationship with vendors to reduced customization and implementation cost by 50 .
• Responsible for Data Governance, Data Warehousing/ BI, Data Integration, Metadata Management, Enterprise Content Management, Data Quality, Data Storage and Operations, Data Security and EIM Components.
• Built and maintained relationships with a wide variety of internal stakeholders in order to understand the current and future information and data needs as they relate to business goals and IT strategy. Developed vision and roadmaps of EIM functions.
• Partnered with upper management for delivery of Data Management functions. Managed participation in projects to ensure compliance relating to enterprise standards, policies and guidelines. Overseen audit of project level deliverables to ensure that practices and standards are met.
• System: Unix, Windows, Linux, Oracle 11g/10g, SQL Server, MySql, Netezza
• Tools: Agil, Waterfall, MS Office, TOAD 10.x, Informatica, Erwin, TOAD Data Modeler 3.x

Confidential

Adviser/Consultant

• Guided for Management, Training and Development. Discussed with CEO of YaraGo 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

Data Warehouse Architect/ETL Manager

• 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

Data Warehouse Manager

• 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.
• 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.
• 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

Data Warehouse Consultant

• Responsible for design, development and implementation of Customer and Billing System Data warehouse.
• Customized Complex 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

Defense Logistics Agency, Lead / Architect

• 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.
• Reported to Vice-President SAIC. 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

Senior Member / Lead

• 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. 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

Social Security Administration, Technical Manager

• Managed 20 million dollar SUMS Data Warehouse project to develop reports for field Managers and High Level Executives of 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.
• 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

Data Warehouse Consultant

• 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

Data Warehouse Consultant

• 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.
• 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, Oracle Financials, Sybase 12.x on NCR 5100
• Tools: Oracle 8i, PL/SQL, Sybase 12.x, Transact SQL, Decision-Base Transformer 1.9, Shell script

Confidential

Comsys Lead

• 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

Comsys Consultant

• As an Oracle Developer worked with PL/SQL tools to analyze, design, program, support and implement the above system.
• Product Rating System is used by MCI users to provide product, feature, Call-Plan and rate related information to Local MCI customers.
• RDBMS: Oracle 7.x on HP-9000
• Tools: PowerBuilder 5.x/4.x, PL/SQL, SQL Loader, Pro C, HP-Unix, Shell, PowerDesigner

Confidential

Consultant

• Executive Information System is for analysis of Financial and Human Resources information related to various departments.
• Developed reports, 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

SKILLS: Project Management - 8 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

TRAINING: Project Management training by Senior Management of Lockheed Martin

SAP R/3 Financials, Java, ASP, XML, Holos OLAP and Java Script reputed Institutes

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