SUMMARY:

• With a successful track record of s in multiple industries ( banking, health care, insurance, etc.), thought leadership, change management, business functional verticals, engaging executives, business and technology clients.
• Team Lead for those engaged in data, information, master and data architecture design, conceptual, logical and physical data model design, business requirements and use cases, data analyses, data integration, data quality.
• Hands - on experience in Enterprise Architecture, Master Data Management, Data Governance
• Design OLTP and OLAP data model, Business Process model and Enterprise Data Model
• Design and implement Business Intelligence and Data Warehousing solution architectures. Highly skilled in dimensional modeling using Kimball Methodology.
• Business Analysis, requirements gathering, elicitation, business rules validation, swim lane diagrams, use cases, enterprise analysis, requirements management and documentation.
• Data Analysis, data modeling, data profiling, data integration, ETL and EII metadata mappings documentation.
• Database and SQL performance tuning, experience in internal data base access path, index strategies, data access optimization analysis.
• Experience with Universal Patterns of data modeling and Canonical Data Design methodology
• Ability to analyze complex enterprise data and applications to derive optimal data strategy and process improvement.
• Experience with HP Project Management (PPM) and Asset Management (HPAM) software product
• Excellent leadership, written, communication, research, presentation, analytical and problem solving skills.

TECHNICAL SKILLS:

Project Lifecycle: PMBOK Business Analysis Lifecycle: BABOK

Enterprise Architecture Framework: TOGAF SDLC: Agile, Unified Process, Scrum, Waterfall

Languages: SQL, UML, XML Hardware: Windows, Linux, AIX, Solaris, DB2 Zos

Software: HP Project & Portfolio Management, Microsoft Project, Microsoft Office, Visio, Business Objects Enterprise, Informatica Siperian MDM, Informatica PowerCenter, Informatica Metadata Manager, Microsoft Analysis Services, Microsoft SSIS, Microsoft Reporting Services, Abinitio, Cognos, Tableau, Visual Studio, Websphere, Weblogic, Oracle, SQLServer 2012, Sybase, DB2 LUW, DB2 EII, DB2 Zos, Teradata, Teradata SQL Assistance, DBArtisan, Toad, Erwin Data Modeler 9.5, Erwin ModelMart, ER/Studio Data Architect, MS Visio Professional, Enterprise Architect

PROFESSIONAL EXPERIENCE:

Confidential, Newark, NJ

Solution Architect/Data Architect Team Lead (Consultant)

Responsibilities:

• Joined the multi-years extremely large and complex MDM repository project as Senior Data Architect to improve data modeling support for both pre and post production phases of the project.
• Later assumed responsibility as Data Modeling Team Lead to lead data modelers to improve data model design, standards and controls, accuracy, support to application team for physical database implementation. Streamlined and established better procedure to improve enterprise level data solution, data governance, data delivery and to establish better communication with other project teams.
• Led team efforts in building presentation/ class for new users to understand the integrated data store repository, Canonical Data Model design and XML application interface as well as data retrieval from data access layer.
• Designed and implemented many new data models and enhancements to existing data models, improved data visualization dashboard and refined data virtualization layer for report query efficiency.
• As Solution Architect, researched and recommended best solution to resolve many post-production data and project issues by performing data profiling, detail analysis on source data, database design and application processes. Worked closely with business analysts, end users, DBA and programming team to implement solution.

Software: Embarcadero ER/Studio Data Architect, Canonical Data Model Design, XSD/XML, MS Power Point, Informatica MDM, Teradata, Oracle 11G, MS SQL Server 2012 Management Studio, Visio Professional, Microsoft Office 2010, SharePoint, SQL Developer, Talon Data Profiling software, Tableau

Confidential, New York City, NY

Enterprise Data Architect/Data Governance Strategist (Consultant)

Responsibilities:

• As Enterprise Architect and Architecture Team Lead, coordinated, managed and supported all data architecture related activities for this major MDM project with the goal to improve accuracy, availability and completeness of infrastructure data within the organization globally. This includes Customer Information Data, Company Data, Operational and Configuration data across Server, Database, Web Service and Storage inventory applications.
• Provided guidance to management in designing the best approach and most effective Data Governance framework including setting up major groups responsible for Data Management, Process Improvement, Metric Governance, and Technology. Provided cross stream collaboration supports to all major groups in addition to architecture related tasks.
• Identified major data aggregates, defined complex architecture diagrams, business process models for existing upstream and downstream processes by working with more than 20 applications. Identified common data and determined golden sources among data used across many applications. Analyzed captured information for existing architecture and processes to recommend process changes and other areas of improvement to the management for installing new procedures to improve data accuracy and process efficiency.
• Co-managed the design and development efforts for the Web Service Inventory project and Database Asset Management project as part of the MDM strategy. Successfully implemented both projects to production by integrating company-wise web services and database asset inventory data into HP Asset Management software to be used as global inventory management repository.
• Designed an optimal web inventory logical/physical relational data model by working with business and SMEs. This has achieved more than 70 percent of improvement in functionalities and made available important data that were not present before.
• Captured data attributes for Database and Storage Inventory project and led automated data discovery efforts using ADDM server discovery software tool. Successful auto-discovery will avoid human data entry thus improve data accuracy tremendously.
• Defined many new business and technical requirement documents and created data dictionary Wiki library in company SharePoint to provide global sharing of up-to-date inventory data attribute information.

Software: Enterprise Architect, Erwin Data Modeler, MS Visio Professional, Oracle 11G, Sybase 12.5, Visio Professional, Microsoft Office 2010, SharePoint, DBArtisan, Toad for Oracle, HP Asset Management

Confidential, Jersey City, NJ

Senior Data Architect (Consultant)

Responsibilities:

• Led the initiative to re-architect extremely complex and large data warehouse data architecture for the Project and Portfolio Management application and to introduce star schema modeling, common dimension and fact tables and migrate from Sybase 12.5 to DB2 9.7 platform.
• Created the data and information architecture, vision, conceptual, logical and physical data models for a large scale, extremely complex project and resource management data warehouse hub for real time reporting.
• Responsible for designing the master and data repository logical and physical data models.
• Provided guidance and review for designing a people tracker data warehouse model as part of related subject area to the main data warehouse project.
• Facilitated and documented client requirements for reporting, business measures, data mappings, star-schema bus architecture, reverse and forward engineering of database to create ERD and DDL code.
• Performed important tasks such as reviewing existing documents and reports, examining old data model design for areas of improvement, interviewing business analysts for potential new functionalities and running data profiling queries for data quality analysis in order to complete the optimal logical and physical data model design.

Software: HP PPM 7.5, Informatica, PowerCenter 8.1.6, Business Objects, Crystal Reports 2008, Live Office, Oracle 10G, Sybase 12.5, DB2 9.7, DB2 Federation, DB2 QReplication, Erwin Data Modeler, Visio, Microsoft Office 2007, SharePoint, DBArtisan, HP Performance Center

Confidential, Franklin Lakes, NJ

Senior Data Architect

Responsibilities:

• Managed and implemented a complex dimensional data model for CHP Marketing application. Worked with users and Cognos/Tableau report team extensively to create management decision reports on important KPI metrics such as sale and customer conversion. Interface with ETL and Oracle DBA team to implement and populate Oracle target data base from Teradata source data.
• For a sophisticated Data Visualization project, designed and implemented a rule-based complex clinical opportunity dimensional data model in Oracle to support Tableau multifaceted reports for an off-shore client in Germany. Designed complex mapping rules and worked closely with ETL team for data population. Performed advanced SQL queries for data profiling to identify potential data issues and provide extensive support to QA team to ensure data integrity.
• As key contributor in a major team effort, designed and implemented an Enterprise Data Model for the company. This includes complex data architecture for Customer, Product, and Supplier which is used as foundation for developing a major MDM project with data governance and data stewardship.
• Completed design for a large and extremely complex logical data model to integrate data across many DB2 applications including Retail Provider Network, SPS and PPO systems. Have utilized universal patterns data modeling techniques extensively to enhance flexibility and scalability of the model.
• Designed a relational data model on Remedy tickets and SLA information for the PEGA application team. Used Erwin to create the data model by applying a flexible design approach to ensure data schema is scalable for future data changes.
• Designed and implemented a data warehousing project for BFG Account Management Reporting application. Worked closely with project manager and lead analysts to customize the dimension model to support both operational and reporting needs.
• Designed relational and dimensional data model for many other applications such as Cycle Billing, CMWS Reporting.

Software: Erwin Data Modeler/ModelMart 4.1, Abinitio, Teradata, Oracle 10G/11G, Db2, Cognos, Tableau Reporting Tool, SQL Assistant, SQL plus, Toad, PLSQL Developer, Pegasystems BI Architecture

Confidential, Liberty Corner, NJ

Senior Data Warehouse Data Architect

Responsibilities:

• As lead DW architect, is responsible for all corporate data model developments. This includes transactional relational data models and dimensional data models for data warehouse applications. Standard tasks include interfacing with business users and business analysts to designing new application requirements, designing the logical and physical data models, generating work flows and transformation rules for ETL process, and ensuring data accuracy.
• Completed design of logical and physical data models for many OLAP and OLTP applications. Had successfully implemented many projects in MS SQL Server data base platform. These include Submissions, DW Report Framework, Policy Management and Agency Management. Some of these applications also require interface with existing mainframe WINS insurance application.
• Used ERwin Data Modeler extensively to design new data models, generate forward engineering scripts and assist DBA in implementing physical data bases in MS SQL server 2005. In addition assumed key software support role that interfaced with CA regularly on all ERwin support related issues.
• Designed and implemented optimal indexes and Referential Integrity relationships for the physical data bases
• Assist programmers in data access and SQL performance tuning
• Developed data naming standards for all Data Warehouse new and existing data bases.

Software: SQL Server 2005, Erwin Data Modeler 7.4, DB2 Zos WINS, Microsoft SSAS, Microsoft SSIS

Confidential, Whippany, NJ

Assistant Director/Senior Lead Data Architect/Database Performance Specialist

Responsibilities:

• Designed and implemented many complex OLTP/OLAT relational and data warehousing data models in DB2/Zos for numerous investment related applications. Examples of accomplished projects include Money Manager Portfolio system, Money Manager Ownership Disclosure Form Automation system, Equity Transaction Position system, Global Clearance Position and Reconciliation system, and Business Product Reporting system.
• Transform logical data models into successful and efficient databases using in-depth knowledge of physical database properties such as indexing and performance tuning techniques. Responsible for both logical and physical design. Worked closely with application developers and production DBA.
• Developed Corporate Data Model Schema, Customer Information data model and many other application specific business data models to support business requirements for many projects. Capable to work independently to locate, capture and organize required data in complex corporate environment for any project. Designed and implemented many large scale relational databases that contain partitioned tables with immense amounts of data.
• Responsible reviewing and approving existing data model/database design changes for applications due to new business requirements or functional enhancements. Provide design assistance and ensure correctness for new data models. Ensured data integrity and in-house naming standards for tables, data elements and physical database objects.
• As application development DBA, defined many major large DB2 databases with optimal indexing strategy and resolved numerous performance issues using Explain access plan analysis and catalog statistics information collected by DB2 utilities. Researched and recommended solutions to improve efficiency of SQL coding and design related problems for many projects that typically improve performance tremendously. Also performed standard database administration support such as implementing new or altering existing database objects, running utilities to load, reorganize and back up application data.

Software: Erwin Data Modeler, DB2 Zos, Composite, Omegamon/DB2, Tmon/DB2, Platinum/DB2, JAVA,