SUMMARY:

• Strong background in Data Modeling, Enterprise Data Integration, Database Development, Administration and ETL. Over 15 years of IT experience. Designed and Implemented several large data warehouse projects utilizing a variety of methodologies, and technology design approaches providing a full range of enterprise services and solutions for both relational and multi - dimensional platforms. Expert in both OLAP and OLTP systems data modeling. In-depth knowledge and expertise for Information Management in areas of Enterprise Architecture Planning, Data Governance, Master Data Management, and Data Warehousing. Designed several large terabyte projects for various industries: Financial Services, Manufacturing, Energy, and State Government. Develops strong relationships with the business; excellent documentation and requirement gathering skills; enjoyable to work with while still being effective and efficient.

TECHNICAL SKILLS:

Data Warehousing: EDW normalized/dimensional modeling, star schema/cube design, Data Vault, BI and ETL design

DBMS: Oracle, Teradata, DB2/UDB, Sybase, SQL Server, MS Access

Life Cycle Expertise: Requirements analysis, database design, coding, testing, database tuning and DB Admin

Methodologies: Inmon, Kimball, MDM, IDEF, IE, Zachman and Six-Sigma

Languages: SQL*, VB, COBOL,C++

Other Products/Tools: Erwin, Power Designer, ER/Studio, Informatica, Data Stage, MS Project, Business Objects, Pentaho

EXPERIENCE:

Confidential

Sr. Data Architect

Responsibilities:

• Lead Data Architect role Created and reviewed data flow diagrams for the PDE data masking project. Lead the team in identifying and mapping the protected health information PHI data elements. Under the HIPAA Privacy Rule, protected health information (PHI) refers to individually identifiable health information. Created the architectural guide maps to mask the data at “Source”. Reviewed the current enterprise application landscape. Conducted sessions with business track leads to go over data lineage. Reviewed data profiling for PHI sensitive data across various business applications. Consolidated and delivered the Run Books to the Data masking team to perform masking.

Confidential

Sr. Data Modeler/Architect

Responsibilities:

• Lead Data Modeler role, work with First Data government professional services. Worked on departments Enterprise Regulatory Data Modeling Practices for federal reporting. Established a granular reporting procedure in which department reported aggregated summary of the dollar amounts details to the authorities. Overcame the flaws of redundant and parallel processing steps for the same reporting data. Removed inconsistencies in the reporting.
• Created and reviewed Conceptual, Logical and Physical Data Models for ImpaCT OLTP database, an integrated eligibility management system consisting of over 1000 entities across 17 data subject areas. Helped Department of Social Services, State of CT to create the best quality data models that meet all business requirements, database change requests, industry standard and also comply with MITA standards. Suggested revisions to add industry standards to the models.
• Conducted sessions with business track leads to revise LDM based on gap analysis. Ensure synchronization among business requirements, data models and the database. Created and reviewed data mappings for right implementation of departments interfaces with other state and federal agencies.

Confidential

Sr. Data Architect/Data Modeler

Responsibilities:

• Lead Data Architect for Chevrons Upstream Appalachian Michigan Business Unit (AMBU). Champion an enterprise architecture planning effort to outline the client’s future state business model for data, applications and technology in both the OLTP and OLAP systems. The plan included a 3-5 year enterprise road map.
• Defined an MDM solution for well master data. Designed the Data Warehouse and MDM hub conceptual, logical and physical data models in support of the AMBU Data Foundation Strategy. The MDM hub supports the client’s goal to improve Well exploration, development, production and field management and comply with regulatory environment, health and safety policies. Coached a team of project managers, data architects and business analysis using data architecture leading practices.

Confidential - New York, NY

Data Architect/Data Modeler

Responsibilities:

• Hardware/SoftwareOracle 10g, SQL Server, Erwin, Toad, Hyperion System 9 and Brio IR
• Data Modeler support AIG’s Enterprise Risk Management project for Chartis Insurance. Provided Chartis UK team with the files for different risk areas of Chartis which would be loaded into Tower Watson’s Igloo Database. Created conceptual, logical and physical models across multiple OLTP subject areas.
• Translated analytic business requirements into dimensional designs. Developed data standards, data mappings, load strategies and history tracking solution. Developed functional data models to enhance the reconcilability of financial and risk data by means of an integrated data model and to increase data consistency in regulatory reporting.

Confidential - Charlotte, NC

Data Modeler

Responsibilities:

• Lead Data Modeler for the Bank of America (BoA) Global Corporate, Commercial, and Investment Banking Technology (“GCCIBT”) organization. Worked on departments Enterprise Regulatory Data Modeling Practices for federal reporting. Established a granular reporting procedure in which bank reported every single loan by providing 95 credit, credit risk and financial data details to the authorities. Overcame the flaws of redundant and parallel processing steps for the same reporting data. Removed inconsistencies in the reporting, complexity at the banks and high costs. Worked the various levels of reports granularity to make them comparable and combinable within the supervisory authorities. Harmonized data management between the bank and supervisory authorities and to request granular data.
• Involved in an effort to decommission 2 data marts and expand the data model of an existing Oracle data warehouse used as their DMM (Data Mining and Metrics) repository. Implemented a top-down/bottom-up analysis approach to assess the as-is data warehouse environment (7 legacy source systems and over 600 reports) and extend the to-be data models. Designed conceptual and logical target OLAP data models using Power Designer15.