Summary

• Senior Information Architect with 20 years of varied industry experience across different Industry verticals and cross functional areas such as Financial, Pharmaceutical, Insurance, Telecom and Retail industries.
• Adept at identifying and troubleshooting process issues through solid analytical and technical skills with a strategic and collaborative approach to successfully partner across business stakeholders and IT operations teams.
• Proven Execution skills in Leading and Managing Data governance, Data Architecture, Data quality, Data Modeling, Reference Data and MDM Master Data Management Initiatives.
• Designed Centralized Data Repository to ensure high availability of quality data across the enterprise.
• Expertise with Data Modeling and MDM.
• Comprehensive understanding of database design, ETL and BI design and different Industry Regulated systems.
• Led and Managed geographically dispersed multi person teams towards implementing concurrent multiple projects in record time.
• Worked with Senior Management and C level Officers within large matrixed organizations on aggressive time lines and budgetary constraints. Managing, Leading Projects and Liaising between Business and Technical teams and coordinating across different teams, including on-site and off-shore teams and providing POC to the PMO, Business and Senior Management.

TECHNICAL SKILLS

EXPERIENCE

Confidential

MDM Solution Architect

• Presented architecture solutions for a Single Party Domain MDM for both health care Providers and Subscribers.
• Led the Implementation of a Proof of Concept for a Party Domain MDM by getting data from six different sources and production volume data in six weeks including data Enhancement using third party data.
• Presented the results of the POC to Business and IT Sponsors.
• Presented the Architecture for the MDM Implementation Program including design of the ETL, Design of the Party MDM and the Real Time SIF Java Components.
• Presented the Data Governance Standards around Provider and Member Data and Provided Rules to standardize the existing data.
• Co-ordinated with various Business and IT groups to create standardized values for common data attributes.
• Provided status reporting to the Higher Management and partnered with Testing, Business Information and Configuration Management/Support teams to ensure quality implementations and the rollout of standardized and supportable code.
• Managed business and technical requirements.
• Co-ordinated requirements review meeting with business.
• Defined the MDM Development Methodology
• Defined the Match and Merge Rules after a detailed analysis of source data.
• Defined the Testing methodology for MDM.
• Converted a Normalized Enterprise Data Model to a de-normalized for MDM Use.
• Led a Group Known as the Confidential . The Lab was charged with the responsibility of coming up with different technical Ideas, developing a proof of concept for the use of the Implementation team. Major Achievements included
• Successful analysis and Redesign of the Prospect data flow and Integration with Sales CRM.
• Exposing Informatica IDQ Cleanse mapplets as real time services for Enterprise wide consumption.
• Importing IDQ Cleanse mapplets into MDM to avoid duplication of code.
• Implementing Proof of Concept for SIF API's using Eclipse, SOAP UI and EJB and converted the SIF output to a Canonical Data Model.
• Analysis and Integration of Third Party Provider Data from Enclarity.
• Ran a Proof of Concept comparison between address cleansing tools Melissa and Address Doctor.

Environment: Oracle 11g, Informatica MDM Formerly Siperian 9.01/9.1, Informatica Power Center/Analyst, Microsoft Project, ER/Studio.

CONFIDENTIAL

MDM Solution Architect

• CONFIDENTIAL a Wealth Management Firm was merged with CONFIDENTIAL which is Primarily a Consumer Banking Organization.
• The Challenges of such a merger were to understand the Business processes of the 2 organization identify the best way to integrate their day to day operations. One of the main process identified was to integrate the Client and Account data of the 2 organizations so that existing customers could get an integrated experience and also allow the merged entity to launch and market new products. The Combined customer database was one of the largest databases of its type in the world.
• Worked with the Business and Data Governance Teams to Document the Business Processes and the flow of Accounts Data Between Bank of America and Merrill Lynch Applications using Visio Data Flow and Flow Chart Diagrams..
• Designed two Siperian Customer Classes Master Profile and GWM Index. This Involved Designing the Siperian Tables, Look up Tables and working Tables.
• Led the Development team and was responsible for meeting deadlines and deliverables.
• Provided status reporting to the Higher Management and partnered with Testing, Business Information and Configuration Management/Support teams to ensure quality implementations and the rollout of standardized and supportable code.
• Participated in requirements review meeting with business.
• Implemented the Data models using Siperian Master Reference Management interface and created the Landing, Staging and Base Table.
• Participate in code review, architecture and planning meetings.
• Resolve technical issues encountered by brainstorming with developers to come up with the best technical solution/course of action.
• Mentoring, training and teaching developers on proper MDM techniques, standards and guidelines.
• Responsible for Liaison with the downstream consuming applications understanding their individual needs, the best method and time of consumption.

Environment: Oracle 10g/9.x, PL/SQL, Toad, Erwin 7.2, Informatica MDM Formerly Siperian XT , Data Stage, Microsoft Project.

CONFIDENTIAL

MDM Solution Architect

• CONFIDENTIAL is among the top pharmaceutical companies in the world. The project involved identification, standardization, use and cost effective sharing of information across Pfizer by way of creating Master Data Management MDM Classes.
• Documented the Business Processes and the Data flow involved in Pfizer Research, Development, Regulatory and Production and Human Resources Groups using Corporate Modeler.
• Designed the Logical and Physical Data Models for Identity, Customer and Compound to Product Business Areas.
• Analyzed the Business data and Defined the Match and Merge rules and Trust Scores for Siperian MDM Hub,
• Responsible for creating the project schedule using MS Project.
• Delivery Lead responsible for meeting deadlines and deliverables related to assigned projects.
• Created the Mapping and Transformation Documents from various sources into the Master Database for the ETL team.
• Redesigned and converted Informatica ETL to DataStage ETL
• Provided status reporting to the Higher Management.
• Partnered with support teams to ensure high quality and standardized roll out.
• Managed business and technical requirements.
• Designed logical and physical data model of Individual Application, Updated the Canonical Data Model and ensured that all applications followed the Canonical Model.
• Configured the Siperian MDM Hub.
• Provided inputs to infrastructure team on capacity planning.
• Participate in code review, architecture and planning meetings.
• Gatekeeper of project artifacts/system production accounts.

Environment: Oracle 10g/9.x, PL/SQL, Toad, Erwin 7.2, Siperian XT, Data Stage, Informatica, Trillium, Corporate Modeler, Microsoft Project.

CONFIDENTIAL

Data Architect

• CONFIDENTIAL had various applications which service Provider and Members allowing them to carry out various contract management, enrollment and self service activities. These applications resided on various platforms like Mainframes, Midrange, and distributed architecture applications. Aetna used a DB2 UDB Data Warehouse running into Terabyte Size. Aetna had well defined CMM process to which every development team had to adhere to.
• As Information Architect for Provider and Plan Domain, participated in the JAD sessions with the users, actively involved with requirement gathering and ensuring applications follow and meet Enterprise wide architecture goals.
• Participated in the Architectural reviews of Requirements, Design, Development Deliverables and Testing Strategies.
• As part of the project management team responsible for tracking Project Schedule and Project Cost.
• Designed the Logical and Physical design for the Mainframe DB2,,SQL Server Environment using COOL:Gen , Erwin and Jumar using well defined Meta Data Repository.
• Responsible for Ensuring that the Logical and Physical Models Confirm to the Enterprise/Canonical Data Models. Updated the Enterprise Data Model wherever required.
• Responsible for Database Access Path Analysis.
• The Meta Data Models followed the Zachman Framework and Data Ware House best practices.
• As part of the design created complex database structures for Provider and Plan Domains.
• Responsible for Designing the Behavioral Health and Utilization Management Data marts Databases. Erwin and COOL: Gen was used as the Data Modeling tool.

CONFIDENTIAL

Data Architect

• CONFIDENTIAL is part of theCONFIDENTIAL group. The company is involved in online advertising of products. The company tracks and analyses internet browsing habits and uses complex algorithms and real time ETL tools to display appropriate advertisement content to internet browsers. The company expects 500 million transactions per hour on its Website.
• As part of the database architecture team responsible for implementing the in memory database and designing the backup oracle database.
• Carried out performance analysis of various database using Mercury Load Runner.
• Responsible for Volumetric analysis of the database.
• Responsible for Creating Partitioning Strategy.
• Responsible for Creating the Logical Data Model.

CONFIDENTIAL

Data Architect

• The Main Objective of this project was to unify 5 different systems into one and ensure flexibility in the design to allow for future acquisitions with minimal changes in the design. The Design had to account for the various modes in which the corporate I.T. receives data from across the United States and the World CONFIDENTIAL
• Responsible for Interacting with Business Users and Analyst to Review Requirements and to Design and Present the Enterprise Canonical Models, Conceptual Models, Logical and Physical Data Models to the Requirement and Development Teams Using Rational Rose, Erwin and Visio for large DB2 and Teradata Databases for Online. The modules consisted of H.R., Payroll, Training, Accounts Payable, Inventory and Sales as well as separate Data Marts for Individual Yum Brands KFC, Pizza hut, Taco bell, LJS and A W .
• Used Saphir to Maintain the Metadata Repository.
• Used Rational Rose to Create Use Case and Class Diagrams and Converted Class diagrams to XSD.
• Responsible for Estimating table, Index and Table Space Sizes based on estimated use, future growth and performance.
• Responsible for partitioning strategy for large tables.
• Responsible for access path analysis.
• Responsible for creating new Database and for synchronizing the Erwin Models with the Database Schemas for existing Data Models.
• Designed a tool to Map XSD Path of Data Elements to Excel Document using Visual Basic.
• Responsible for designing and maintaining Logical and Physical Data Models for Data Ware House Systems Using Teradata and Erwin. Used Star Schema/Snow Flake Schema Architecture.

Additional Activities

• Developed Customized Reports to Extract Information from Rational Rose Models using Rational Rose API's and Visual Basic.
• Designed a tool to Re-organize Erwin Data Models Created by Reversing Engineering People Soft DB2 Database Using Saphir and Visual Basic and Erwin API.
• Developed Web Site Using ASP, JavaScript, VBScript and IIS to publish Rational Rose and Erwin Models, Search facility for locating the Correct Data Model.
• Developed Intranet Module for user's to Request assistance from DBA's/DA's. The Module allowed users to Upload attachments, track the Request and auto e-mailed status changes to all concerned users.

CONFIDENTIAL

Project Manager

• Implemented Enterprise Project Management Tool Niku Now CA Clarity .
• Carried out Quality Analysis Check On Work plans existing in Microsoft Project as mandated by the State office.
• Migrated MS-Project Plans To Niku.
• Guided Project Managers in Developing New Project Plans, Reschedule projects and level Resource Assignments and manage inter project dependencies.
• Created Specifications for Project Monitoring Reports.
• Monitor Progress of the Project Using Various Indices like CPI, TCPI, SPI, ACWP, BCWP, Efficiency and Utilization using e-PMO.
• Under went Mandatory HIPPA Training.

CONFIDENTIAL

Data Architect

Environment/Tools: Windows XP, AIX Unix, DB2,SQL Server, Erwin, Rational Rose, MS

• Project, e-pmo, Cognos Impromptu, Power Play and Web Reports, Toad, Power Builder, Java,
• J2EE, JavaScript, XML, HTML
• Participated in JAD Meetings with the Business user to Create Conceptual, Logical and Physical Data Models Using Rational Rose and Erwin.
• Designed and Maintain the Logical and Physical Data model for Member Enrollment, Claims Processing and Provider Enrollment Modules Using Erwin and Rational Rose. The System catered to Employees of more than 40 Fortune 100 companies and was designed to process very large volumes of data.
• Designed and Maintained Data Warehouse using Star Schema/Snow Flake Schema architecture and Creating Dimensions and Cubes as per Business Requirements Using Erwin.
• Responsible for Estimating table, Index and Table Space Sizes based on estimated use, future growth and performance.
• Was responsible for carrying out Impact Analysis, Generate Scripts and Estimate Table, Index, Table Space Sizes.
• Was responsible for analyzing queries and optimize system Performance.
• Designed and Developed ETL Scripts to load data from OLTP System to OLAP System.
• Developed the Configuration Management Plan.
• Was Responsible for Maintaining Promoting Changes across the different Environments.
• Was Responsible for SQL Server Administration.

CONFIDENTIAL

Business Process Engineer

Environment/Tools Windows, Java, Weblogic, Fuego BPM

• Underwent Training on the Architecture and use of Fuego BPM.
• Along with a team of 5 developed the FuegoBPM API for parsing and accepting EDI files.

CONFIDENTIAL

Onsite Project Manager

Environment/Tools Windows 95, SQl Server, ERWIN, Rational Rose.

• Responsible for Interacting with the Senior Management team to define the scope of the project.
• Developed Requirement Definition Documents and Activity Diagrams using Rational Rose for Online Mortgage System and Online House Insurance System.
• Responsible for Designing and Maintenance Logical and Physical Database Design using ERWIN for OLTP and OLAP system. Implemented Star, Snow Flake Schemas and Created Dimensions and Cubes as per Business Requirements.
• Responsible for planning the physical database in terms of Table Space, Table Size, Index Size with the objective of scalability and optimized performance.
• Responsible for rolling out the data model changes and keeping the Model and Physical Implementation in Sync.
• Developed the Configuration Management Plan.

CONFIDENTIAL

Project Manager

• Responsible for Creating Requirement Documents in association with Business Users using Rational Rose.
• Developed Use Case Diagrams, Activity Diagrams, Class Diagrams Using Rational Rose.
• Developed Logical and Physical OLTP Database Design Using ERWIN.
• Developed Software using Weblogic 5.1, Oracle 8i, Java, J2EE, Servlets, JSP, XML and Java Mail which allowed users to Create User Id, Log Requests for New Cards, View and Download Statements and Authorize transactions and Process New Requests for Purchase Cards.

Environment/Tools Windows 95,SQL Server, Rational Rose, Together Soft, ERWIN, JavaScript, Java Servlets, EJB, Web Logic Application Server, XML,HTML

CONFIDENTIAL

Solution Architect

• Environment/Tools Windows 95, AIX UNIX, DB2, Oracle, Erwin, Scopus CRM-Tool , TCL, Pro C.
• Responsible for Creating Requirement Documents in association with Business Users.
• Responsible for maintaining the existing database design of various system and Modeling and Implementing Database Designs for New Projects.
• Was overall responsible for Maintaining and Designing More than 2800 tables.
• Modified Oracle OLTP Database Design of Scopus CRM-Tool for AT T's Order Provisioning System.
• Lead a team of Modeler for Maintaining the Logical and Physical Models of the Database Using Erwin.
• Lead a Team of 7 including 3 DBA's for optimizing 1000 PLSQL, Pro C and TCL Procedures.
• Used UNIX AWK Scripts and C programs to extract Column and Table Usage matrix from existing Programs.
• Responsible for Administration of the Database.

CONFIDENTIAL

Product Manager/Project Lead

• Managed/Led various client engagements at Kale Consultants. The Clients included
• As the Product Manager for the Praxis Product Successfully Implemented the ISO 9001 Standards for Software Development and defended the process to the External Auditors.
• Co-ordinated a major Product release for more than 15 Airlines.
• Managed the Onsite Interaction with the Emirates Petroleum Company and completed the project successfully.
• Led the Development of the first GUI application for SIDBI.

CONFIDENTIAL

Senior Systems Engineer

• Responsible for Creating Requirement Documents in association with Business Users.
• Designed OLTP Database
• Developed Programs using Power Builder 3.0, Watcom/Sybase for a Commercial Banks Credit Division enabling to Process Loans and carry out the related accounting

CONFIDENTIAL

EDP Officer

• CONFIDENTIAL is the 5th largest commercial Bank inConfidential. As the EDP officer in charge of their Foreign Exchange division was assigned the responsibility of computerizing the existing manual systems into computerized system.
• Involved in the short listing of Vendors and carrying out gap analysis between their existing products and the banks requirements.
• Responsible for creating the overall requirements for the Banks Foreign Exchange Dealing Room, Import ,Export, Remittance, Forward Trading and Retail Trading Modules.
• Responsible for Design and Development of the Dealing Room and Remittance Systems.
• First person in the bank to Install Oracle under UNIX.
• Responsible for administration of Oracle Database and Unix Server.