SUMMARY:

• Sr. Data Modeler & Data Architect has 12+ years’ experience; is highly motivated and a self - directed professional. Proven to excel in IT roles requiring deep Data Analysis, Data Modeling, Business Analysis, Data Architecture, Business Intelligence and project leadership for teams in the implementation of model-based, client/server solutions.
• Skilled in implementation of leading edge technology solutions, conducting business needs analysis, developing infrastructure to support information engineering analysis and development projects, as well as implementing standards & methodologies to support project teams.
• Successful in gaining insight on business needs and performing requirements gathering for enterprise initiatives, working wif sponsors and business owners in understanding scope & feasibility. Possesses effective written and verbal communication skills and the ability to interact wif management and stakeholders at all levels of an organization.
• Excellent interpersonal and communication skills, and possesses the ability to work wif internal and external clients to identify business needs and develop a plan to address those needs.

TECHNICAL SKILLS:

Methodologies: Agile Scrum, iDeliver, Oracle AIM, Kimball & INMON, Project Management PMI, RUP

Tools: Erwin 7.x (7 years), Power Designer 16.x (7 years), Profiling: Teradata SQL Assistant (7 years)

Database: Teradata (8 years), Oracle 11g (8 years), DB2 (6 years), SQL Server (6 years)

O/S: Windows 8.1, Windows 7, Windows XP

Roles: Project/Program Management (4 years), Business Analyst (5 years), TEMPPrincipal/Business Consultant, Sr. Enterprise/Project Architect (2 years), Data Architect (12+ Years)

PROFESSIONAL EXPERIENCE:

Confidential, Saint Louis

Sr. Data Architect/Sr. Data Modeler

Responsibilities:

• Analyzed business requirements, translate them to data requirements, and understand data relationships wifin a single domain and across domains.
• Significant collaboration wif functional/product owners to understand the business requirements.
• Defined technical requirements and facilitated reviews wif peers and lead architects.
• Provided high level design expertise in support of development team efforts to provide flexible reusable components to increase cost effectiveness, analyzes, designs and reviews design to ensure customer specifications are satisfied.
• .Involved in production of detailed Logical/Physical model designs and design documentations.
• Leveraging enterprise data modeling constructs, methodologies and practices to ensure flexible, scalable, maintainable, and high performing physical databases.
• Performed extensive data profiling and analysis to validate the business rules and understand the relationships between the Operational data for the Data Model design.
• Creation of New Logical/Physical models and enhancement of existing models as per technical requirements.
• Mapping of Logical design to Physical design to align business requirements and source to target mapping (DW) wif transformations.
• Involved wif multiple scrum teams to maintain the Logical/Physical models as per the requirements.
• Reported to multiple project owners to halp understand the integrity of the model and relationship between entities..
• Created standards and methods for the development team during the life cycle.
• Generation of DDL from the physical model(s) and deliver to DBA(s) for implementation.
• Reviewed the database implementation to make sure stated the physical design.
• Maintenance of the large data mart models in the repository.
• Worked wif business and IT on improving data integrity and quality.
• Documented business & technical metadata/data dictionary dat has been captured during the data modeling and business analysis processes..
• Maintained enterprise metadata so dat it can be reported and leveraged for re-use.
• Technical understanding of data model(s) across a variety of applications and BI systems.
• Involved in data migration from legacy systems to new architecture designed system.
• Strong expertise in understanding data modeling involving logical, physical and reverse engineering data model(s).
• Adherence to enterprise data standards, policies and procedures governing the management of company data.

Confidential, Chicago IL

Sr. Data Architect/Sr. Data Modeler

Responsibilities:

• Responsible for Deep Dimensional/Relational logical and physical data modeling using the Entity Relationship Diagram (ERD) methodology in Scrum Agile environment.
• Translated the functional requirements into technical design and data modeling.
• Worked wif MDM team to understand the Business Entities (MRT) and analysis per business requirements.
• Performed extensive data analysis & profiling of source systems (diversified products such as SQL server, Teradata, Oracle) to understand the relationship between the data and data structures, using SQL.
• Identified & analyzed existing source system data structures and creation of AS-IS data flow diagrams and logical models.
• Made recommendations for data quality, data migration and gap analysis between integrated & distributed database environments and platforms (diverse technology).
• Responsible for creating logical/physical models for new project initiatives and maintaining existing models wif enhancements.
• Applied experience and expertise in data architecture concepts (e.g. model management, meta-data management, data governance).
• Experience delivering concurrent, large information management projects at all phases-from project definition through design and delivery.
• Worked on business requirements gathering and analysis processes and methodologies and converted them into technical requirements.
• Developed a data strategy and worked wifin influencing the associated policies.
• Expertise in Database design wif relational or dimensional star schemas for data warehousing.
• Provided guidance in technical design for end products and solutions.
• Worked on model configuration reviews, approval and changes.
• Financial Services industry specific knowledge includes working knowledge of industry data standards and architectures.

Confidential, St. Louis MO

Sr. Data Architect/Sr. Data Modeler

Responsibilities:

• Facilitated requirements gathering sessions/workshops wif business owners to understand & document the high level functional & technical/data requirements.
• Responsible for analysis & profiling source systems (diverse technologies & products) data for integration wif data warehouse dat includes data flow diagrams, source to target mappings & transformations (state transitions). Tool used is SQL.
• Provided proactive guidance on modeling efforts for enhancements/upgrades and migration of the source data to data warehouse dat does include duration, timelines for logical and physical design.
• Documented & proposed high-level normalized and de-normalized modeling design & entity resolutions for the existing source system physical design as per the data warehousing standards, procedures and best practices.
• Provided support for collecting metadata, data definition/dictionaries related to the modeling efforts.
• Classification & identification of new modeling enhancements into proper subject areas & business domains to acquire consensus & buy in from business owners.
• Provided guidance on security models and methods to protect information in the DW solution.

Confidential, St. Louis MO

Sr. Data Architect/Sr. Data Modeler

Responsibilities:

• Responsible for business needs and requirements gathering sessions for small to large size enterprise initiatives wif sponsors and business stakeholders to understand the scope and feasibility.
• Interviewed business users to understand the functional, technical requirements and data needs to make sure aligned wif project requirements.
• Gained thorough understanding of business terminology, metadata definitions and documenting for business and technical teams.
• Worked on solutions planning and designing conceptual models for the new and upgrade to existing cross functional subject areas.
• Performed extensive data profiling and analysis to validate the business rules and understand the relationships between the source data for the DW design.
• Lead the logical and physical model design and dimensional designs for the DW as per the database standards and made sure aligned wif the requirements for new and upgrade projects.
• Reviewed logical and physical models (database design) wif stakeholders and peers to generate consensus and final approvals.
• Responsible for communication and review of first cut physical model wif technical team ensuring DW standards and guidance before hand out.
• Facilitated the optimization of the database implementations for business reporting and performance to the technical team.
• Reviewed the database implementation to make sure stated the physical design.
• Created mapping documents between source and newly/upgraded target DW systems including transformations and logics for ETL design team (Also used for system upgrades and initiatives).
• Facilitated and review of mapping documents wif ETL design team and transfer of knowledge.
• Provided guidance and communications to data architecture team on standards and maintenance.
• Created and published data dictionary for business stakeholders and technical teams.
• Worked on integrating cross functional subject areas into Enterprise Logical Data Model (ELDM).
• Provided guidance and documentation all across data architecture decision support.
• Established ETC hours wif senior managers to provide duration of tasks and deliverables during analysis and design phase.
• Ensured effective communications to senior managers of task dependencies, risks/impacts and schedules on timely basis.

Confidential, St. Louis MO

Business Analyst/Sr. Data Architect

Responsibilities:

• Responsible for requirements gathering for DW from PMO Team; decomposed requirements into detail functional and technical requirements as a part of SDLC requirements.
• Utilized expertise in SCDs and OLAP dimensional data modeling making sure business requirements are met.
• Created conceptual, Logical and Physical data models based on business requirements.
• Facilitated JAD sessions wif business users to understand requirements and deliverables.
• Identified conflicts between the application teams, business stakeholders and development team.
• Gained solid understanding of infrastructure, guidelines, standards and components to understand requirements.
• Participated in Business unit meetings for data warehouse to understand metadata, ODS, data mart and business requirements.
• Interviewed business users to understand the scope of software applications and ownership of data.
• Created business flow diagrams, business use cases as a part of RUP methodology.
• Prioritized project efforts and communicating to senior management on timely basis.
• Developed documentation and wire diagrams for business users to understand new/and modified aspect of applications and databases.
• Worked on source to target mapping, data analysis, transformation and documentation to it.
• Worked on peer reviews of data architecture team and data models as a part of the RUP process.

Confidential, St. Louis MO

Data Architect/Business Analyst

Responsibilities:

• Responsible for requirements gathering sessions wif Business users and various departments to understand the feasibility and business needs.
• Worked wif team on development of business use cases/system use cases using RUP Methodology and processes for Logical Data Model and Physical data Model.
• Created process flow diagrams, wire diagrams, system use cases, documentations for business users and technical teams as a part of requirements, analysis and design phases.
• Created standards and methods for development team during the life cycle.
• Performed thorough analysis of requirements, user sign offs and documentations to the projects.
• In the analysis and design phase, dealt wif data architectural team to assist in understanding the functional requirements, technical requirements documentations and design of logical and physical data models.
• Member of Architecture Data management team tasked wif ensuring the process is done correctly wif other business analysts, data architecture team, and technical teams.
• Worked wif several departments in communications wif process flow, traceability of the requirements and planning and validation of dimensional modeling.
• Worked on project constraints and risk impacts to achieve the milestones and deliverables.
• Dealt wif business owners on timely basis for project statuses, risk impacts and issue logs.
• Provided support and documentation throughout the development, implementation, change control processes and lessons learned during the closures as a part of configuration management.
• Assist DBAs in understanding of Physical data model and all aspects of Dimensional modeling.
• Extensive use of Erwin Suite and model manager.

Confidential, St. Louis MO

Sr. Architect

Responsibilities:

• Understanding of business practices and flow diagrams. Worked on the Microstrategy Business Intelligence and on BI Upgrade project during the first phase.
• Provided Analysis and design of use cases for web portal application wif understanding of 3 tier architecture and flow. Facilitated regression testing and reporting to management.

Confidential, St. Louis, Missouri

Senior Data Architect and Business Consultant

Responsibilities:

• Worked on business requirements gathering and analysis and documenting the finalized requirements.
• Gained understanding of the data requirements and data piping through various sources and enhancements to data flow diagrams.
• Worked on the conversion of OLTP ER diagrams into OLAP dimensional modeling. Created the data mart from existing Operational Data Store and other sources.
• Responsible for creation of data dictionary for the data mart and communications to stakeholders.
• Worked on volumetric analysis for the data-mart as a part of capacity planning.
• Converted ER diagrams into dimensional modeling including logical and physical modeling. Created materialized views from the data mart for easy drill down of the data. Extracted data from various sources using ETL processes and data mapping.
• Created executive dashboard using crystal reports for the enterprise reporting as a part of Business Intelligence requirements; including understanding the BI requirements and prototyping custom crystal reports.
• Served and facilitated as DBA for the team and customers.

Confidential, Kansas City, Mis souri

Senior Business Architect

Responsibilities:

• Responsible for business process modeling, workflow analysis and use case modeling and facilitation to build data warehouse for the organization. Led a team of 10-12 in analysis/design requirements and interaction wif technical/non-technical group.
• Worked capacity planning & data warehouse architecture (data consistency architecture, reporting, staging data store architecture, data modeling architecture, tools and security architecture).
• Worked on software change control process development and approvals & Order Management Module of Oracle Financials dat includes AR, AP, GL. Provide user support to write instant queries and procedures using SQL and PL/SQL to provide decision Support in PO, GL, AR, AP and Order Management.
• Developed custom reports and procedures to meet user requirements as part of the requirements management.

Confidential

Data Architect and Business Intelligence Agent

Responsibilities:

• Worked wif Oracle Consulting and Hallmark to strategize the project's direction and documentation.
• Led 5 Data architects & 10 Legacy system members in the implementation of Data-Warehouse.
• Facilitated/designed logical model for the Operational Data warehouse. Developed Operational Data Structure Data-warehouse using ERWIN to in corporate the conversion from Legacy mainframe to Oracle three tier structure.
• Provided technical leadership in designing the logical data model and physical data model on the enterprise level.
• Responsible for full life-cycle system delivery methodology such as AIMS and RUP, including primary responsibility for data - related deliverables.
• Responsible for source system analysis, data mapping documents, and defining common data definitions and integration/documentation on data cleansing and validation of existing data from the conversions.
• Conducted facilitated data model review sessions. Gained understanding of Teradata database and workflow.
• Strategized to feed the Operational Data Structure wif oracle applications & fit gap analysis and integration of operational Data Structure into corporate data model for use wif various departments and strategizing the point of vision for the corporation.

Confidential

Project Consultant

Responsibilities:

• Worked on conceptual design of life-cycle of Data-Warehouse & requirements management, gathering information, analysis, design and implementation, including understanding business practices & designing them in logical order. Created Scope and planned the activities related to transformation from logical model to Physical model.
• Lead for the architecture team of 8 members, ensured the data architecture met objectives & performance goals as defined in the requirements. Worked wif HR and technical teams to extract data from HRMS/Payroll Portal. Extensive documentation and understanding of Portal Advanced Benefits and Employee Hiring process.
• Created custom query and administration using business objects to the data-warehouse.
• Installation of DataStage ETL and emphasis on extraction from various oracle databases into the data-warehouse.
• Translated logical data models into meaningful business concepts and assemble documentations.
• Responsible for data analysis and mapping, me.e.: analyzing source system data to understand the meaning; determine and document the business rules required to move it through the stages of the Data Warehouse (Staging, Operational Data Store, Data Warehouse, Data Mart, Model Mart).
• Developed the logical and physical model plus the generation and modification of DDL using SQL and PL/SQL.