Sr. Data Architect/sr. Data Modeler Resume
Saint, LouiS
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 teh 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 teh ability to interact wif management and stakeholders at all levels of an organization.
- Excellent interpersonal and communication skills, and possesses teh 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), Principal/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 teh 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 teh business rules and understand teh relationships between teh Operational data for teh Data Model design.
- Creation of New Logical/Physical models and enhancement of existing models as per technical requirements.
- Involved wif multiple scrum teams to maintain teh Logical/Physical models as per teh requirements.
- Reported to multiple project owners to help understand teh integrity of teh model and relationship between entities..
- Created standards and methods for teh development team during teh life cycle.
- Generation of DDL from teh physical model(s) and deliver to DBA(s) for implementation.
- Reviewed teh database implementation to make sure stated teh physical design.
- Maintenance of teh large data mart models in teh repository.
- Worked wif business and IT on improving data integrity and quality.
- Documented business & technical metadata/data dictionary dat has been captured during teh 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.
- Strong expertise in understanding data modeling involving logical, physical and reverse engineering data model(s).
- Adherence to enterprise data standards, policies and procedures governing teh 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 teh Entity Relationship Diagram (ERD) methodology in Scrum Agile environment.
- Translated teh functional requirements into technical design and data modeling.
- Worked wif MDM team to understand teh Business reference 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 teh relationship between teh 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 teh 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
Consultant - Sr. Data Architect/Sr. Data Modeler
Responsibilities:
- Facilitated requirements gathering sessions/workshops wif business owners to understand & document teh 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 teh 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 teh existing source system physical design as per teh data warehousing standards, procedures and best practices.
- Provided support for collecting metadata, data definition/dictionaries related to teh 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 teh 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 teh scope and feasibility.
- Interviewed business users to understand teh 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 teh new and upgrade to existing cross functional subject areas.
- Performed extensive data profiling and analysis to validate teh business rules and understand teh relationships between teh source data for teh DW design.
- Lead teh logical and physical model design and dimensional designs for teh DW as per teh database standards and made sure aligned wif teh 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 teh optimization of teh database implementations for business reporting and performance to teh technical team.
- Reviewed teh database implementation to make sure stated teh 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 teh 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 teh 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 training 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 teh RUP process.
Confidential, St. Louis MO
Data Architect/Business Analyst
Responsibilities:
- Responsible for requirements gathering sessions wif Business users and various departments to understand teh 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 teh life cycle.
- Performed thorough analysis of requirements, user sign offs and documentations to teh projects.
- In teh analysis and design phase, dealt wif data architectural team to assist in understanding teh functional requirements, technical requirements documentations and design of logical and physical data models.
- Member of Architecture Data management team tasked wif ensuring teh 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 teh requirements and planning and validation of dimensional modeling.
- Worked on project constraints and risk impacts to achieve teh milestones and deliverables.
- Dealt wif business owners on timely basis for project statuses, risk impacts and issue logs.
- Provided support and documentation throughout teh development, implementation, change control processes and lessons learned during teh 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.