Summary

• Seasoned Data Architect with around 19 years of extensive IT experience. Presently working Contractor at NJ State Sandy Transparency Project as a Data Warehouse Lead Architect and Manager. Worked at Home Land Security CBP as a Data Warehouse Architect.Worked as a Sr. Consultant with IBM Global Business Services. Extensive experience in Business Process, Data Governance, Data Stewardship, Data Warehousing, Data Modeling Erwin version 4.x to 9.1 , DBartison, Power Designer , Dimensional Modeling Oracle, Sybase, DB2, SQL Server , Meta Data Management, ETL SSIS Informatica 9.1 Design, PL/SQL, Transact-SQL, programming and the Data Dictionary Information System integration. Experience with ETL tool Informatica Power Center 9.1,8.6.1/7.2 Experienced in Informatica for developing UNIX Shell PMCMD for automation of ETL process.
• Experience extends in the realms of policies and procedures that guarantee pristine data qualityacross the enterprise in terms of accuracy, accessibility, consistency and completeness. Extensive experience with relational databases Sybase, Oracle, SQL Server, DB2 and moderate knowledge on WCC Web Sphere Customer Center . Reengineered and implemented Sales and Distribution processes as well as Inventory Management processes for several industries.

Experiences and Skills

Confidential

Sr. Data Warehouse Architect Lead Data Modeler

Project goal is to build ODS which will give them 360 degree customer view and then top of that build DW. To do this effort I am involving with information gathering which include source information, naming standard, member of a data Governance team, data profiling , integration ETL design , meta data , MDM, creating CDM Conceptual data model ,LDM Logical data model ,PDM physical data model and related documentation like data flow diagram, data dictionary, Standardize metadata, Naming standard, mapping document etc. . In this project I have to do relation use normalization rules as well as dimensional data model deformalize data model for Data Warehouse which include CDM conceptual data model, LDM logical data model and PDM physical data model . At present we are at information gathering phase. In future for BI we are going to use BO. Here my responsible to design ODS and provide 360 degree customer view and then design DW and BI solution. For that they are using SQL Server 2008 R2, Oracle 11g Erwin and SSIS. Operating system we are using here Unix and Windows.

Confidential

Sr.Data Warehouse Architect Lead Data Modeler

Project goal to build data warehouse for Sandy Transparency fund which NJ state received from Federal government to rebuild after Sandy hurricane 2012. This warehouse is continuously feeding data to Sandy Transparency website. My role is to design and implementing this data warehouse which includes information gathering, data stewardship, data modeling, ETL design, establish development standard, data standardization and reporting. I also responsible to provide different type documents like data flow diagram, data model CDM, LDM, and PDM , mapping, ETL design, deployment etc. I am using Oracle 11g as target database, Excel Spread sheet for source , Erwin for data model, Data stage ETL, BO for Reporting, Toad , AIX etc. Also maintain the full Data Confidentiality. Operating system used AIX and Windows.

Confidential

Data Warehouse Architect

Project goal to assess their existing data warehouse and provide road map to build data warehouse proper way. I also provide dimensional data model for their existing subject area and build prototype for one subject area for demo. We use SQL Server, Erwin, and Microstrategy.

Confidential

Data Warehouse Architect Manager Lead Data Modeler

Project goal to build data warehouse for Confidential from scratch and for that we are using Kimball methodology. My roles are gathering requirement to design dimensional data model ERWIN 9.1 which includes data flow diagram, CDM, LDM, PDM and maintain my data warehouse development team. I also responsible for MDM, Data Governance/DATA STANDARDS, and to create maintain project plan and provide status report every week to client team. In this project we are using SQL Server 2008 R2,Oracle11g, SSIS, Sparx Data Model Tools .

Confidential

Data Warehouse Architect ETL Lead Lead Data Modeler

Project goal to built EDW and Client is Confidential methodology. My role is identify sources, analyze required data on the basis of business need, Create data model including ERD and DM Using ERWIN 8.2, Data Governance/DATA STANDARDS, Profiling, data stewardship, design ETL from different source to staging and data mart , ETL Naming standard ect.. Here I am using Oracle10 and 11g, SQL Server 2008 R2 in data base side and OS using windows and very little AIX. For data model using Erwin and ETL using Informatica. Also we have to follow organizational Data Confidentiality rule for all sensitive data.

Confidential

Sr.DataWarehouse Architect Lead Data Modeler

Confidential functional spec., Data Governance/DATA STANDARDS, MDM, data stewardship, design dimensional Data Models ERWIN 7.3 , including Conceptual, logical and physical data model. Also design ETL OWB , data transfer from different OLTP system to DW and load related data to their OLAP system for EIS Enterprise Information System , for analytical reporting purpose. We have to follow very strict data confidentiality rule when we load data from different source to staging area. Manage project in sync with the client's PM. For this project, I work with Oracle, SQL Server SSIS and Mainframe as the source system. Because of different source systems, there is a lot of scope for data cleansing and formatting etc. I also coordinate test teams to create their functional test script on the basis of used case. I work very closely with DBA, SME and System admin. In near future, I have to workon Siebel analytics, on their OLAP application. This is a mid size project with almost over 400 end users directly or indirectly using this.

Confidential

goal is to build a mission critical Reporting Service for higher Management based on existing enterprise data. As a Lead SME Subject Matter Specialist in EIS Enterprise Information System , worked closely with stakeholders in determining requirements for the project. Work involved extensive research of policies and procedures in existing Data Governance/DATA STANDARDSand modeling of existing data warehouse and relational databases Oracle 9i to identify cross section of enterprise data sources mainly from OLTP that will flow into the reporting needs of the project. Involved in all phases of requirement gathering, setting policies and procedures of data standardization and security, design, architecture, implementation and testing of the physical database.

Confidential

Worked as a Lead Data Steward and Q A Data Architect in their P C functional area. Involved in interfacing with all stakeholders of the project Siebel SOA , including client representatives, business analysts, application development team, project management team, database team as a Data Modeler and QA team. Responsible for the planning and execution of the QA team. This included determining claim related policies and preventive care related data standards for maintaining high data quality and building the QA team from onshore and offshore resources and assigning tasks, integrating claim related data from twelve enterprise data sources all from OLTP and building the test database environment, overseeing the development of test cases and scripts and their executions, providing data to the development team for unit testing, etc. This was a SOA project and provided challenging hurdles in achieving the testing goals that were successfully accomplished using technologies like XML extenders to tap into the ESB. In this assignment we have to strictly follow HIPAA Health Insurance Portability and Accountability Act rules Health Care data Confidentiality rules .

Confidential

Installed, configured and maintained Oracle 9i/10g.Set up and maintained oracle disaster recovery site using Data Guard. Utilized RMAN for backup and recovery strategy. Completed export and import of different databases using Oracle Export ExpDp / Import ImpDp utilities in their P C functional area. Table fragmentation tuning, partitioning the large table by date. Installed, configured and maintained Oracle database 10g, and upgraded Oracle 9i to 10g. Created and maintained different database entities included table spaces, data files, redo log files, rollback segments and renaming/relocating of data files on servers. Trouble shooting and resolving any database and/or application issues or errors that occurred Performed database tuning by using various tools, like Oracle Enterprise Manager and STATSPACK.Monitored the various database activities by developing shell scripts and using various tools. Architecting database infrastructure, development and implementation.Exercising technical leadership in creation of database infrastructure including planning, procurement, installation, configuration, integration and implementation.

Confidential

My role was to develop Analytics reports. To create those reports I had to interact with OLTP, OLAP database Oracle SQL Server and BA team. Up to some extent, I worked with informatics for mapping and workflow.

Confidential

for Sprint DATA MART project.Also to help development team to develop the ETL Informatica and create shell script to automate ETL.Developed ETL processes to populate the Enterprise Product Orders data mart Dimensions and Fact using Informatica, Oracle SQL,UNIX shell scripts Developed complex mappings using transformations such as the Source qualifier, Aggregator, Expression, Lookups, Filter, Router, Sequence Generator, Update Strategy, andJoiner Optimized performance by tuning the Informatica ETL code as well as SQL. My role was in the Data Governance, data quality in terms of naming conventions, integrity, accuracy and completeness, design CDM Central Data Management , Logical, Physical data model and ETL design. This was not only confined to Sprint but also used withdifferent accounts like GM etc, as a base model. Worked as a senior team member for the integration team DB2 . Started right from the discover phase and gap analysis phase. Worked on conceptual design phase moving to actual design phase.Responsible for Entire development of the project.

Confidential

Also work

ed on an IBM internal project with IBM ebHS Business Transformation team. This is the extension of the IBM Fast Path project. My role herewas to help Data Architect team Global DB2 SQL Server to make data dictionary for their E2E data flow process, which includes different databases like CFT/S, PACT, GBP, eSEC, SIEBEL etc.

Confidential

Worked at ABBOT LAB Siebel e-medical module and my role was data integration lead. Main purpose of the project was to upgrade Siebel 99.5 to Siebel 7 with some addition functionality.

Confidential

Confidential at IBM FastPath project Global project for G7 Countries . This was a first of its kind implementation in IBM of Siebel CME. It includes configuration of the product model which was an extremely complex task. Worked on product model design, as well as the Complex configuration. Thereafter, joined eCOMMET Project which is an extended FastPath project. Responsibilities grew to include that of Siebel administration, and MQ series specialist. As an MQ series Architect, evaluated the MQ needs for CME. Basic tasks included, designing a deployment strategy, delivering and architecting recommendations. The process involved vision of working with queues on the mainframe as well as deployment of a distributed MQ environment to support distributed operations.

Confidential

Worked as a Data Architect for the Lexis-NexisProject.Responsibility involved Data modeling Erwin SQL Server Data mapping, and Data migration with preprocessing from different legacy database to Siebel base tables.

Confidential

Worked as a Data Architect at PCD-SBC Project IBM Internal B2B client . This project involved different applications and products like SAP, Web sphere, MQSERIES, Java and Lotus notes. Involved in developing the Data Flow diagram for total backend process for data flows in between applications and maintaining data integrity between different applications. This diagram also shows the execution time within each applications and total process time to help monitor and control of data flows. Also involved in creating positive and negative test cases and control points and modifying XML file for positive and negative test cases. This process reengineering now helps the IBM senior management in understanding the implications very easily and almost in real time.