We provide IT Staff Augmentation Services!

Enterprise Data Architect Resume

3.00 Rating

Minneapolis, MN

SUMMARY:

  • Over 17 years of strong Enterprise Data Architect, Data Modeling, Project Lead, Business Analysis, Data Warehouse and Business Intelligence experience.
  • Strong Data Architect with hands on capability to move project from requirements gathering and design through implementation.
  • Very strong Data Architecture and Team Leadership experience.
  • Database Design (Conceptual, Logical & Physical) using Sybase Power Designer and Erwin.
  • Very strong Relational and Dimensional data modeling experience.
  • ETL and Reporting Architecture, Design and Development.
  • Data Warehouse Design using Kimball methodology.
  • Strong experience with Oracle 7.x, 8.x, 9i, 10g, 11g and MS SQL Server, Teradata and UDB/DB2 databases.
  • Strong Vendor Management experience.
  • Excellent Communication, Team Management and Inter - personal skills.

TECHNICAL SKILLS:

Hardware: COMPAQ Servers (Proliant), Sun Ultra 7, Sun Sparc 5

Operating Systems: Windows NT 4.0, 2000, UNIX, Solaris 2.7, 2.6

Relational Databases: Oracle 7.x, 8.x, 9i, 10g, 11g, MS SQL Server 7/2000/2005, Teradata, DB2, MS Access

Web Technology: Java, C++, ASP, Perl, JDBC, Java Web Server, IIS, WebLogic

Languages/Tools: Power Designer 16.5, 15.x, Erwin 4.1.4, 3.5, Oracle Designer 6iDeveloper 2000 (Forms, Report Builder), OEM, PL/SQL, SQL*LOADER, XML, WebDB, TIBCO, TOAD 11.0, 10.5, 9.6, 8.5, SQL Navigator, PL/SQL Developer 7.1.4, PVCS, VSS, WinCvs 2.0.2.4, Visio 2000, 2003, Oracle Warehouse Builder 2.1, 3i, Informatica PowerCenter 5.1, 7.1, 8.1.1, Data Stage 8, SSIS, SSRS, Astera Centerprise Data Integrator 5.x, Logi Analytics 11.x, Business Objects, MS Analysis Services, Cognos 8i, MS Access, Jaros Analytics 3.0.3, Jaros AMDR 1.19.7

PROFESSIONAL EXPERIENCE:

Enterprise Data Architect

Confidential

Responsibilities:

  • Interviewed the SME’s and business users, for both Multi-peril Crop Insurance (MPCI) and HAIL lines of business within Crop Insurance to get the data requirements.
  • Worked with business users and stakeholders to identify FMH’s reporting and data needs
  • Created the data warehouse architecture and roadmaps and got buyin’s from the upper management and other team members.
  • Did various tool evaluations, POC’s and Vendor selection for both ETL/Data Integration tools and Reporting tools.
  • Defined and document the requirements using use cases.
  • Document Data Flows and Process Flows.
  • Analyzed the newly developed source system CloudNet and its data structures.
  • Created the BUS Metrics for the various business processes across FMH and identify the Dimensions and Facts to be used across these business processes.
  • Designed the Enterprise Data Warehouse including various dimensions and fact tables using Kimball methodology
  • EDW also housed some of the historical information from retired systems (TIP, AS400), P&C (Garvin Allen) and ReInsurance (SICS).
  • Created STAR schemas for Policy, Agency, Claims, Reserves, Financial data marts.
  • Established data modeling standards and best practices and created Conceptual, Logical and Physical data models using Sybase Power Designer.
  • Defined the ETL architecture for the movement of data across various systems.
  • Creating Templates to capture source details and source data elements.
  • Created source to target data mappings for ETL.
  • Worked with ETL developers to load data from source systems.
  • Working with DQ team for profiling data and resolving issues.
  • Working with source system experts and data stewards to resolve data issues.
  • Worked with the SME’s of source systems to satisfy the data and reporting requirements of the government body RMA (Risk Management Agency), NCIS and other third parties.
  • Conducted various POC’s and user focus groups for Agents and Adjusters for getting the dashboards and reporting needs using LogiXML (Logi Info and Logi Adhoc).
  • Identifies the reporting needs from the workflow and document management system ImageRight and its data integration needs with CloudNet.
  • Worked on reporting needs for Geospatial and GIS information in ESRI with CloudNet
  • Worked on variety of old systems to be retired (TIP, AS400) to move their data in EDW.
  • Working on the data security plan for confidential and restricted information and PII.
  • Implemented user level reporting security based on user types, roles and permissions for controlling access to users.
  • Helped with conversion effort from old policy admin system eCrop to CloudNet.
  • Created tables, partitions, materialized views, indexes and other database objects
  • Work closely with DBA’s to monitor and improve performance, etc.
  • Manage various work environments, Devlopment, Test, UAT, Hot Fix and Live.
  • Implemented database design, ETL and Reporting deliverables in an Agile environment.
  • Metadata creation, management and publishing
  • Helping in Project Planning.
  • Vendor evaluation and vendor management.

Environment: Sybase Power Designer 16.5, 16.1, Oracle 11gR2 (11.2.0.1), TOAD 11, 10.5, Astera Centerprise Data Integrator 5.1, Log Analytics (LogiXML) 11.x, Pervasive Data Integrator, ASP.NET, Perforce, MS Project 2007, Visio

Data Architect / Integration Team Lead

Confidential, Des Moines, IA

Responsibilities:

  • Working as Team Lead for ‘Sourcing Workstream’ managing team of 10 Data Analysts.
  • Worked with the SME’s of source systems including Loan Origination, Servicing, Correspondent and Wholesale, Institutional Lending, Sales systems, etc
  • Meet with SME’s of source systems including LIS, LPS, AS400, PCLS, SMS, CORE, C&W Standard, IL Online, MSP/Fidelity, Phoenix, Profiler, Arrow, ACAPS, SalesLogix, CTS, AOW, ECPR, MYBOB, Oracle GL, PeopleSoft, etc.
  • Meet with SME’s of various users to help identify what data should be sourced into MIDE.
  • Worked on variety of source system platforms including Mainframes, Oracle, SQL Server, Sybase, Extracted data files, User Maintained data, etc.
  • Setup meetings and work with the SME’s to identify and get the system of record (SOR) data sourced into MIDE from the respective source systems.
  • Interviewed the SME’s and business users of all the 40 source systems to get the data requirements
  • Defined and document the requirements using use cases.
  • Document Data Flows and Process Flows.
  • Creating Templates to capture source details and source data elements.
  • Creating Conceptual, Logical and Physical data models using Sybase Power Designer.
  • Help with Metadata creation, management and publishing.
  • Managing the process for loading of metadata into EMR (Enterprise Metadata Repository).
  • Help in creating source to target mappings.
  • Help in documenting source databases, business rules, transformations and data mappings from source to target data structures.
  • Worked with ETL developers to load data from various source systems.
  • Working with DQ team for profiling data and resolving issues.

    Working with source system experts and data stewards to resolve data issues.

  • Helping in Project Planning

Environment: Sybase Power Designer 15, Teradata, DataStage 8, MS Project 2007

Data Architect / Data Modeler

Confidential, Des Moines, IA

Responsibilities:

  • Meet with users to identify the requirement for the Predictive Modeling project.
  • Interviewed the business users and stake holders to get the requirements
  • Defined and document the requirements using use cases.
  • Document Data Flows and Process Flows.
  • Creating Logical and Physical data models using Erwin.
  • Metadata creation, management and publishing.
  • Followed the Agile methodology for the Predictive Modeling Project
  • Worked with ETL developers to load data from third party vendors.
  • Working on the PII (Personally Identified Information) project. Analyzing various applications and identifying as well as controlling access to users.
  • Working on various another projects and involved in tool evaluation.
  • Supported other application data models on DB2/UDB databases.

Environment: Erwin 7.1, Oracle 10g, DB2/UDB, Informatica PowerCenter 8.1.1, PL/SQL, TOAD 9.6, MS Project 2007, Visio

Data Warehouse Tech Lead

Confidential, Minneapolis, MN

Responsibilities:

  • Involved in maintaining the project plan, defining the tasks & identifying resource needs.
  • Interviewed the business users and stake holders
  • Worked on the Data warehouse Bus Architecture identifying various business processes.
  • Define and document requirements using use cases, Document data and process flows
  • Doing business analysis, identifying business data needs and reporting needs and obtaining sign-off from client on specifications
  • Conducting Joint Requirements Development (JRD) sessions.
  • Designed/Created various templates for conformed dimensions and facts.
  • Involved in work allocation to resources for ETL and Report Development.
  • Worked with the data modelers to design the ODS tables and star schemas for custom tables in Oracle Applications supporting Confidential specific business needs.
  • Create Logical and Physical data models.
  • Created various tables to support the data needs of the ancillary applications which the data warehouse was supposed to feed.
  • Designed structures around basic Customer Setup for various business units Credit Management and Recovery, Legal Fraud & Compliance, Agent Servicing and Operational Support, Settlement Servicing, Product Management & Marketing, Finance and Accounting, etc
  • Designed hierarchies for Agent and their relationships over time, Sales Rep, etc.
  • Help resolve the data issues by interacting with the SME’s and the business users.
  • Create data mapping documents and extract specification documents for enhancement to OOB Jaros data warehouse and custom OA tables.
  • Worked with Informatica ETL developers to get the required data loaded, both, ‘Near Real Time’ in ODS and ‘Nightly’ in the Data Mart.
  • Created and maintained the control tables and other details for sourcing the data from the Oracle Applications source table.
  • Technical Project Lead with Strong hands on capability to move project from requirements gathering and design through implementation
  • Provides project status updates and Report development status to the Project Manager.
  • Monitor the overall development process and made sure deliverables are on time.
  • Used Jaros Information Directory Services (IDS) to define relationships between various entities and publish the model in Cognos Framework Manager.
  • Used Jaros Metadata Manager (MDM) to define and maintain the metadata so it can be published by the Jaros Help System for the business users.
  • Applied Fixes for enhancement to the OOB Jaros data warehouse solution using the Jaros Fixes Tool
  • Identify sensitive data elements and implement the information security policies
  • Decryption of the encrypted data elements in the Cognos Reports and Auditing the information both at record level and the request criteria level for PCI compliance.

Environment: Sybase PowerDesigner 12.5, Oracle 10g, Oracle Applications v11i, Informatica PowerCenter 8.1.1, Cognos 8i, TOAD 8.5, 9.6, PL/SQL Developer 7.1.4, MS Project 2007, Visio, WinCvs 2.0.2.4, HP Project and Portfolio Management (PPM) v 7.1

Data Architect / Data Modeler

Confidential, Purchase, NY

Responsibilities:

  • Involved in creating and maintaining the project plan, defining the tasks and dead lines and identifying resource needs.
  • Defined and document the requirements using use cases.
  • Document Data Flows and Process Flows.
  • Interviewed the business users and stake holders
  • Conducting Joint Requirements Development (JRD) sessions.
  • Doing business analysis, obtaining sign-off from client on requirements & specifications.
  • Introduced a data warehousing methodology to be followed in the project for conformed dimensions and fact definition/computation
  • Designed/Created various templates for conformed dimensions and facts.
  • Worked on the Data warehouse Bus Architecture identifying various business processes.
  • Analyzed source system SABRE, GDS, CRM and historical information from Navitare and information from Traverse in the form of API’s.
  • Involved in work allocation to resources and work monitoring.
  • Designed star schemas for Guest, PNR and VCR.
  • Created Logical and Physical data models.
  • Help the resolve the data issues by interacting with the source system experts and the business users.
  • Create data mapping documents and extract specification documents.
  • Worked with C# Sharp and .Net developers and business users to identify the reports and cubes needed.
  • Technical Project Lead with Strong hands on capability to move project from requirements gathering and design through implementation
  • Provides project status updates to senior IT management
  • Monitor the overall development process and made sure deliverables are on time.
  • Metadata Management.

Environment: SQL Server 2005, Erwin 4.1.4, SSIS, SSRS, SSAS, MS Project 2003, Visio

Enterprise Data Architect

Confidential, Stamford, CT

Responsibilities:

  • Interacted with the source system experts and the business users.
  • Gained Business knowledge for Treasury, Fixed Income, Debts & Derivatives, Funding (Long Term, Short Term), Bonds, Commercial Paper, Swaps (Interest Rate, Commodity, Currency), Foreign Exchange, etc.
  • Analyzed the source systems Infinity, FXPress, ATOM, Trema, BAAS, COL, CDR, Principia, Match Funding, etc.
  • Interviewed the business users and stake holders.
  • Defined and document the requirements using use cases
  • Introduced a data warehousing methodology to be followed in the project.
  • Created the Data warehouse Bus Architecture identifying various business processes.
  • Designed/Created various templates for conformed dimensions and facts.
  • Identified the candidates for the conformed dimensions.
  • Involved in customer data integration (CDI) effort
  • Designed the data architecture for GE Treasury including the Treasury Data Hub (TDH), supporting EAI and Enterprise Data Warehouse (EDW).
  • Involved in CDI to get a single, complete and accurate record of their customers across the organization by designing CORE data models.
  • Identified the Core Data elements to be used within the business.
  • Designed Conceptual, Logical and Physical data model for Core Data and various subject areas in the business.
  • Created metadata for the business entities.
  • Did Feasibility study and came up with various options for automation of FAS133 accounting process.
  • Involved in Proof of Concept for various BI Reporting Tools.
  • Documentation.

Environment: Erwin 4.1.4, Oracle 9i, 10g, SQL Server 2000, Informatica PowerCenter 7.1, Business Objects, Cognos 8, MS Project 2003, Visio, Websphere Application Server 6

Enterprise Data Architect

Confidential, Stamford, CT

Responsibilities:

  • Technical Project Lead with Strong hands on capability to move project from requirements gathering and design through implementation
  • Involved in creating and maintaining the project plan, defining the tasks and deadlines and identifying resource needs.
  • Introduced a data warehousing methodology to be followed in the project for conformed dimensions and fact definition/computation
  • Designed/Created various templates for conformed dimensions and facts.
  • Worked on the Data warehouse Bus Architecture identifying various business processes.
  • Defined and document the requirements using use cases
  • Doing business analysis, identifying business needs and obtaining sign-off from client.
  • Interviewed the business users and stake holders
  • Conducting Joint Requirements Development (JRD) sessions.
  • Prototyping and GAP analysis.
  • Helped various business units agree to a common definition for the dimensions that were being conformed.
  • Analyzed all source systems Destiny, IRIS, RSG that feed data into RDW.
  • Involved in work allocation to resources and work monitoring.
  • Designed star schemas for policy/claims/reinsurance data marts.
  • Created Logical and Physical data models.
  • Help the resolve the data issues by interacting with the source system experts and the business users.
  • Create data mapping documents and extract specification documents for the ETL team.
  • Worked with MS Analysis developers and business users to identify the reports and cubes needed.
  • Work with the project manager and business leads to identify what will go in a release and make sure the development and QA work is done on time.
  • Provides project status updates to senior IT management
  • Monitor the overall development process and made sure deliverables are on time.
  • Metadata Management.

Environment: Erwin 4.1.4, SQL Server 2003, SSIS, SSRS, SSAS, MS Project 2000, Visio

Enterprise Data Architect

Confidential, Danbury, CT

Responsibilities:

  • Involved in creating and maintaining the project plan, defining the tasks and deadlines.
  • Technical Project Lead with Strong hands on capability to move project from requirements gathering and design through development and successful implementation
  • Develop project plans, time and resource estimates and set priorities.
  • Managed onshore and offshore team resources.
  • Strong leadership and team management.
  • Provides project status updates to senior IT management
  • Analyzed and defined the business requirements.
  • Interviewed the users.
  • Analyzed various source systems.
  • Interface with various different teams and other departments within GE
  • Created various templates for dimensions and facts.
  • Defined the naming standards and best practices for data warehouse development.
  • Helped the six businesses agree to a common definition for the dimensions that were being conformed.
  • Designed star schemas using Kimball methodology.
  • Assigned tasks to Data Architects and ETL developers and monitored the ETL process designed by them for individual dimensions and facts.
  • Worked with the offshore development team and helped them resolve issues.
  • Helped to resolve the data issues by interacting with the SME’s and the business users.
  • Metadata management.
  • Reported the overall status of each star schema to the Project Manager.
  • Created the Physical Design of the data warehouse
  • Forward and Reverse engineering of tables and entities
  • Designed Staging and Error handling tables
  • Monitored the overall database creation process.
  • Interacted with the DBA’s to identify the indexes and partitions.
  • Capacity Planning.
  • Monitored the Business Object Universe and helped in front end development for creating dashboards and various reports.
  • Involved in User and documentation.

Environment: Oracle 9i, Erwin 4.1, Informatica PowerCenter 5.1, Business Objects 5i, Microsoft Project, Autosys 4.0, Toad 6.3

Data Modeler/Data Architect

Confidential, Bakersfield, CA

Responsibilities:

  • Interviewed the business users
  • Analyzed various source systems.
  • Document Data Flows and Process Flows.
  • Defined Enterprise Architecture using Zachmann Framework.
  • Designed Conceptual data model for Document Management System.
  • Designed Conceptual data model for Data Management.
  • Forward and Reverse engineering.
  • Designed the staging process and staging tables.
  • Creating and publishing data dictionaries.
  • Managing the completion of project in the given deadline.
  • Documentation.

Environment: Oracle Designer 6i, Oracle 7.3, MS Access, MS Project 2000

Data Architect / Lead

Confidential, San Francisco, CA

Responsibilities:

  • System Analysis and understanding Business Requirements.
  • Participate in the Business Requirement Analysis
  • Interfacing with business, project managers and other business analysts
  • Analyzing Portfolio, Security, Options for Customer and Account centric approaches.
  • Document the Functional specifications of the system.
  • Defining tasks related to analysis in the Project Plan.
  • Reengineering Models for optimal flexibility and performance.
  • Design Relational model based on application system requirements.
  • Logical Data Modeling and Physical Data Modeling using ERwin.
  • Develop, Maintain and Document data model.
  • Support to developers, end-users.

Environment: Erwin 3.5.2, Oracle, SQL Server 2000, DB2, MS Project 2000, Visio

Data Architect/DBAMeet

Confidential, San Francisco, CA

Responsibilities:

  • Understanding business requirements.
  • Design relational model based on application system requirements.
  • Logical Data Modeling and Physical Data Modeling using ERwin.
  • Database Design, Sizing, and Capacity Planning
  • Develop, Maintain and Document data model.
  • Participate in the analysis effort required for all Global Data Mapping/Conversion.
  • Capacity Planning, deploying Backup and Recovery strategies using Veritas.
  • Reengineering schemas for optimal flexibility and performance.
  • Assist in tuning database performance. Optimizing query performance.
  • Involved in Database Design for different partner countries.
  • Design and enhance the global database architecture.
  • Assisting various countries to setup the defined strategies.

Environment: ERwin, Oracle 7.1.3, SQL Server 7, WinNT 4, Veritas, OEM, PL/SQL, SQL*Loader, XML, Web Logic, TOAD, TIBCO, WebDB, VSS

Data Modeler/Team Lead

Confidential

Responsibilities:

  • Analyzing the system and getting the requirements.
  • System analysis and system desing based on the requirements.
  • Creating Logical and Physical data models using Erwin.
  • Created backup and recovery scripts.
  • Resolving the performance tuning problems.
  • Setting up the storage, schemas and database objects for production instances.
  • Troubleshoot problems regarding the databases, applications and enforcing security.
  • Provide technical support to application development teams.

Environment: Windows NT Server 4.0, Oracle 7.x, SQL*LOADER, Erwin, VSS

Database Consultant / Oracle DBA

Confidential, Pittsfield, MA

Responsibilities:

  • Created PL/SQL scripts for database migration.
  • Created different objects in the development, test and production databases.
  • Migrating the database as per the new application.
  • Maintaining development, test and production databases
  • Applying patches to the Oracle database.

Environment: Oracle 7.3, Designer 2000, PL/SQL, Stored Procedures, UNIX, SQL*Loader

Data Modeler/DBA

Confidential

Responsibilities:

  • Designed the application using Designer 2000/Developer 2000using Forms 4.5, Report 2.5 and Oracle 7.x databases.
  • Created backend stored procedures and triggers in PL/SQL
  • Worked as an Oracle DBA for maintaining Client Databases.
  • Provided technical support to application development teams and end users.
  • Involved in work allocation, work monitoring and time sheet preparation.
  • Interacted with customers for Function point analysis and design.
  • Involved in design HLD and LLD. Also in Unit testing and Integration testing.
  • Preparing unit test plans and Integration test plans.
  • Set up and maintained Backup and Recovery strategies for the database.
  • Provided hardware recommendations for fail-over and load balancing.

Environment: Oracle 7.x, Designer 2000, SOLARIS 2.x, PL/SQL, Veritas Backup/Recovery

We'd love your feedback!