SUMMARY:

• Strong background in Data Modeling, Enterprise Data Integration, Database Development, Administration and ETL.
• Over 11 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.

CORE OF STRENTH:

• SSIS
• SQL
• T-SQL
• PL/SQL
• SQL Server 05
• Oracle 9i
• Oracle 10g
• Data Integration
• SSAS
• MDS (SQL Server Master Data Services)
• Master Data Management

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

PROFESSIONAL EXPERIENCE:

Confidential - Hartford, CT

Sr. Data Modeler

Hardware/Software: DB2, Erwin9.5, JIRA

• 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, Confidential 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 - Pittsburg, PA

Sr. Data Architect/Data Modeler

Hardware/Software: SQL Server, Erwin9.2

• 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

Hardware/Software: Oracle 10g, SQL Server, Erwin, Toad, Hyperion System 9 and Brio IR

• Data Modeler support Confidential ’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

Hardware/Software: Oracle, Toad, Power Designer15

• Lead Data Modeler for the Confidential (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.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. 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.

Confidential, Minn. MN

Data Analyst/ Modeler

Hardware/Software: Teradata UNIX MP-RAS, Oracle, Toad, Power Designer15

• Enterprise Data Modeler involved in Confidential ’s mortgage servicing data warehouse redesigns effort. The design supports the bank’s Mortgage Integrated Data Environment (MIDE) initiative to provide a single source of truth against which servicing data can be reported. Design conceptual, logical and physical data models (over 300 entities) in Power Designer using Teradata’s financial services reference data model template.
• Maintained the models in the Power Designer Repository. Map data requirements from the Fidelity Mortgage Servicing Platform on Oracle against the target data models.