SUMMARY:

• Exceptionally motivated, results - driven and accomplished Senior Information Technology Leader with over 20 years of experience in management and execution of IT Data Architect strategic initiatives in the Banking, Healthcare, Federal Government, State Government, Retail, Utility Service and Telecommunication industries.
• By envisioning the company's mission, taking leadership of systems implementation, and planning for risk management and growth; I lead, direct, develop, administer, and coordinate all phases of the company's data base infrastructure including, but not limited to, data Governance, data base design, ETL, programming, installation, security, maintenance and operation.
• I attain desired results through exceptional service orientation, efficient decision making, effective vendor, and by managing capital and operational budgets.
• Well known for superior analytical, evaluative and problem-solving abilities and expertise in creating highly effective organizational teams, structured training, and process oriented methodology.
• Effectively communicate complex technologies to technical and non-technical audiences.

TECHNICAL EXPERIENCE AND SKILL:

Lead Data Architect with around 20+ years of extensive IT experience with excellent hands on understanding of EIM framework, Data Governance, Profiling, integration, MDM, Meta data management, Reference data, Erwin data modeler (version 4.x to 9.x), Power Designer, ETL ( informatica until 9.1, SSIS(2012)), PL/SQL, Confidential -SQL also data base like Oracle, SQL Server, Sybase, DB2 UDB, SAP Hana. As a Lead data architect I also have excellent knowledge about relational, Dimensional data model design (Kimball, Inmon methodology). I also have knowledge of SOA architecture. I also have previous working experience with SAP and I have three Siebel certificates.

PROFESSIONAL EXPERIENCE:

Confidential

Informatics and Data Warehouse Lead

Responsibilities:

• Designed Data Warehouses and modified some existing design.
• Designed Informatica mapping and workflow existing and new.
• Efforts focused on Oracle data base supporting logistics and international trading.

Confidential

Lead Data Warehouse Architect

Responsibilities:

• Managed a team of 17 staff which includes AVP, DBA, ETL developer, SME and tester.
• Planning and proposing the outline of the experiment/s to be performed
• Planning and Estimation of cost and the resources.
• Conducted a feasibility study of the projects and further enhancements
• Prepared periodic reports for the senior management and other related departments
• Monitored the progress of each initiative and suggesting them necessary modifications for further development
• Training the subordinates
• Project was to create Customer 360 degree view data base and the create data warehouse .
• To accomplish this goal we use Erwin data model tools, Oracle 11g, SQL Server 2012, and ETL SSIS.

Confidential

Lead Data Warehouse Architect

Responsibilities:

• Preparing standard data sheets, reports, forms as guided by the Data Manager
• Searching for the research related data over the web
• Contacting various department to convey their roles and responsibilities in the ongoing projects
• Maintaining detailed daily records of the ongoing projects.
• Assisting the data managers in the preparation of the standard reports
• Managed a team of 10 staff which included data architect, DBA, ETL developer, SME and tester.
• Communicated to different state organization heads regarding data processing and strategy related issue.
• Oracle 11g, Erwin, Data Stage, Toad.

Confidential, PA

Lead Data Warehouse Architect

Responsibilities:

• Project goal was to provide road map to build Data Warehouse
• Analyzed existing data warehouse structure and design and developed new data warehouse strategies to business stakeholders.

Confidential

Manager and Lead Data Warehouse Architect

Responsibilities:

• Managed a team of 22 stuff including full time and consultant.
• Planning and proposing the outline of the experiment/s to be performed
• Created project plans and building the Data Governance team.
• Planning and Estimation of cost and the resources.
• Conducted a feasibility study of the projects and further enhancements
• Prepared periodic reports for the senior management and other related departments
• Monitoring the progress of each experiment and suggesting necessary modifications for further development
• Training of team subordinates and interviewing new resources
• Work with various business stakeholders, DBA, Developer (data base, ETL), also communicate with Confidential & Confidential management team regarding Data Strategy, Access Control, Hardware Requirement, Data Standardization, Reference Data.
• Used Erwin for data modeling, Spark data model, SSIS and Informatica for ETL, Oracle11g, MDM, Meta data management.

Confidential

Lead Data Warehouse Architect & ETL Lead

Responsibilities:

• Managed a team of 30 stuff (Total development team was in INDIA) including development (ETL, Data Base), DBA, business stake holders.
• Designed data warehouse and provided project strategy to business stake holders. (indirectly worked with Ralph Kimball, one of the original architects of data warehousing and is an author on the subject of data warehousing and business intelligence .
• Introduced Data standardization & security strategy, Meta data management strategy and implementation.
• Established Data Governance team.

Confidential

Lead Data Warehouse Architect

Responsibilities:

• Managed a team of 21 stuff including regular and consultants.
• Reported to Assistant Commissioner and Head Of The Branch CBP.
• Planning and proposing the outline of the experiment/s to be performed
• Planning and Estimation of cost and the resources as budget was critical.
• Conducted a feasibility study of the projects and further enhancements
• Prepared the periodic progress reports for the senior management and other related departments
• Monitored the progress of each experiment and suggesting modifications for further development
• Training the subordinates
• Primary was delivery analytical reports generated from CBP data warehouse every month to US Congressman (CBP)
• Built a data warehouse and communicated through different protocols new data standards, data strategy, data security to various federal departmental heads specific to their needs.
• Significant data volumes required extensive communications to ensure the data designs were adhered to.

Confidential

Sr. Consultant (Data Architect)

Responsibilities:

• As Sr. Data Architect led data teams comprised on Confidential and client resources.,
• Developed stakeholder communications, Hardware requirement,
• Communicated with Clients and data base team on DBA requirements development.
• Provided data warehouse and data base strategy road map,
• Designed CDM,LDM,PDM and ETL design strategy.
• Data base design includes OLTP as well as OLAP.
• Participate in sales pursuits interviews and SOW and Proposal development.
• Led two Confidential Global projects
• Siebel CME implementation project ( G7 Countries included Germany, England, Netherland, Australia, Canada, France) and
• Confidential IGA project (Country includes Germany, England, Netherland, Australia, Canada, Peru).