SUMMARY: 

• Experienced designing, developing and implementing full project lifecycle Data Warehouse/Data Marts/BI Solutions and developing Master Data Management strategies at an Enterprise scale using primarily Microsoft Data Warehouse Tools.
• Designed and implemented Enterprise scale data architecture which includes relational model, dimensional model (star schema) and Multi - dimensional cubes using Erwin, PowerDesigner and ER Studio data modeling tools.
• Large scale MDM and BI implementation experience from solution architect to solution implementation and final deployment involving millions of records using Master Data Service (MDS)
• Successfully delivered multiple Master Data Management solutions using MDS with different data domain such as Customer, Product, Location, Member, Provider, and Identity Management with integration solutions for big enterprise business with strong references.
• Implemented Enterprise Metadata Repository using Rochade and integrated it with the data modeling tool PowerDesigner. Also implemented bi-directional Business Glossary.
• Led the data quality, data cleansing, source system analysis, data dictionary creation, metadata management, data migration effort using Informatica and other related tools. 
• Created DW/BI Deployment plan in all environments and partnered with change management and support team to have proper knowledge transfer/documentation/training for post Go-Live.  
• Conducted Proof of Concept and tool evaluation to align the solution with the enterprise technology roadmap. Created PowerPoint slides and presented solutions, analysis, solution approaches to the architecture review board to get approval/sign-off, knowledge share etc.

TECHNICAL SKILLS:

Computer Skills: Riversand MDM Center, IBM InfoSphere Master Data Management 11.4, Informatica MDM.

Databases : Teradata, Teradata Retail Data Model, Oracle, SQL Server 2008 R2, DB2, VSAM, Sybase,

MySQL, IMS DB/DC:

Metadata Management : Rochade, PowerDesigner v12.5, Business Objects Data Integrator.

Database Modeling : PowerDesigner v12.5, Erwin, ERStidio.

OLAP : Visualization, Business Objects, Cognos, Tableau and Microstrategy.

Data Integration : Informatica, SOA, ESB BUS, WESB MQ,

Platforms: Microsoft, Linux, UNIX, IBM Mainframes.

Languages : XML, XAML, HTML, jQuery, JavaScript, T-SQL, VBScript, PERL, Shell Script,

Operating Systems : Windows XP, Windows 7, Windows 8, Windows Server 2003, Windows Server 2008 R2, Windows Server 2012, MVS, OS/390.

Software Applications: SSIS, SSRS and SSAS, Microsoft SQL Server 2012, Microsoft SQL Server 2008 R2, Microsoft SQL Server 2005, Microsoft SQL Server 2000, Microsoft Office 2003, Microsoft Office 2010, Microsoft Office 2013, Visual Studio 2008, Visual Studio 2010, Visual Studio 2012, NetBeans, Eclipse, Java, Apache 2.4, Tomcat, Open BD, Hadoop MapReduce, Pig, Hive, HBase, and support from Cloudera Inc, JAVA, J2EE, WSDL, Teradata Administrator, Teradata Parallel Transporter(TPT), BTEQ, QUERYMAN, MLOAD, FASTLOAD, FASTXPORT, Informatica, Informatica Power Exchange (PWX), Toad, Autosys, Cognos, QMF, SPUFI, COBOL, TSO/ISPF, JCL, IBM Utilities, CHANGEMAN Panvalet, Fileaid SAS, PL/SQL, Data Cleansing Trillium.

PROFESSIONAL EXPERIENCE:

Enterprise Data Architect 

• Reverse engineered AS-IS Data Models for both OLTP and Data Warehouse. Worked with the business to get the tables allocated into proper subject areas, created relationships, cardinality. This formed the baseline for the corporate enterprise data model.
• Created corporate data dictionary and shared with key business area’s
• Lead the Design and Development effort for the Master Data Management for Customer data domain.
• As part of the Data Governance process, designed and implemented Data Quality KPI’s and Dashboard to enable continuous monitoring and reporting.

I.T Technical Lead/Architect 

• Working on architecture, database design and enhancements for TrueValue data warehouse. 
• Responsible for all activities related to the design and development of enterprise wide data analysis and reporting solutions. 
• Translate high-level requirements from the customer into effective BI solutions Integrating complex data from disparate sources into a data warehouse and applying strong analytical skills to develop existing business reports with high level of complexity, thus reducing the time to generate these reports manually to complete automation. 
• Design and Architect of MDS solution for TrueValue Master Data management - Product,
• Design logical and physical data models for different MDS solutions.
• Design, development and integration of MDS Web service entities.
• Design and Architect of standard process for staging based MDS entity load process.
• Created KPI Objects in line with Requirement Docs. 
• Wrote MDX expressions to create name sets and calculated members. 
• Created ETL packages using SSIS to move data from various heterogeneous data sources. 
• Responsible for all ETL operations including client feeds, warehouse loads, and data extraction. 
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases. 
• Created daily snapshot SSRS report using MDX for the senior management.

Information Architect

• Developed and Enhanced Conceptual, Logical and Physical Data Model to support several releases
• Developed several scripts to automate enterprise data model implementation using PowerDesigner v16.1
• Implemented Packaging feature which enabled Jeppesen effectively develop and share their most valuable asset i.e. aviation enterprise data model
• Developed and Implemented several key features using Oracle Workspace Manager on Oracle v12c which enables Jeppesen to version enable tables, Manage Workspaces, enable Spatial and Graph Topology and Valid Time Support.

Enterprise Data Architect/Metadata Architect

• Architected, designed and developed a canonical model to aggregate data from four different legacy systems to provide a single view of "Member". Designed and implemented an ODS layer and Analytical reporting layer. This included some enhancements to existing data assets.
• Chaired technical review sessions. Proposed alternative design approach, modifications in data access and ETL designs to streamline existing processes and/or reduce overhead on the existing data warehouse.
• Participate in data rationalization including the implemented enterprise metadata solution. This resulted in substantial cost saving and enhanced overall MDM/Data Quality program.
• Designed and developed an MDM hub with providers, patients, Member and details about the relationships among them on Informatica MDM platform. Developed a Master Data Management (MDM) strategy.

Senior Staff Enterprise Data Architect 

• Conducted and Managed the requirements gathering, scope definition, analysis and translating business requirements to technical specifications.
• Partnered within and across all business units and teamed up with Directors, Managers, Architects and Stake Holders to create and formalize the eBay Enterprise Data Architecture. The data architecture deliverables included Conceptual Data Model, Logical Data Model and Physical Data Model for both OLTP and Dimensional Model, and Analytics.
• Developed SSIS packages using LOOKUP, SCD, DERIVED COLUMN, DATA CONVERSION Transformations.
• Built and deployed SSIS packages in .ispac format into all Environments.
• Participate in data design walk-throughs to communicate data warehouse and Data Mart table designs to ETL developers.
• Develop prototype views and reports of the data, and work with business users both internal and external to refine their requirements.
• Identify critical integration issues and developed corrective solution.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Created Report model for each report in Report Server for each report to help front end user to modify the report as per their requirement.
• Generated several weekly, monthly, quarterly, yearly, parametric, drilldown and chart reports using SQL Server Reporting Services (SSRS).
• Built ad-hoc reports using SQL Server Reporting Services (SSRS), Excel.
• Designed and developed bi-directional enterprise metadata management repository (MDR) using PowerDesigner and Rochade in support of data management strategy. Developed business glossary which contained key business definitions (from business domains), Terms and Acronyms. Immense savings were realized by implementing MDR.

Enterprise Data Architect / Data Warehouse Architect

• As a Solution Architect provided consultancy services to design and develop the Data Warehouse from scratch. My responsibilities and deliverables were as follows:
• Developed the Solution Architecture / Roadmap Blueprint, project plan, estimates, roles and responsibilities and Work Breakdown Structure (WBS), policies and procedures for Master Data Management and Data Governance/Data Stewardship, Data Quality, Metadata Management and Data Security and Project Charter
• Conducted JAD sessions with the SME and Cross functional team to gather and document requirements and reporting needs. Developed KPI’s for Data Quality, Data Warehouse, Metadata and Reporting.
• Published and implemented several standards such as data modeling, data warehouse, security, metadata
• Lead the ETL tool evaluation process, and decided on IBM WebSphere Data Integration Suite (Hawk beta version)