SUMMARY:

• Over 13 years of experience in Data Integration, Data Modeling, Data Architecture, Database Design, Business Analysis, Data Warehouse Systems and Business Intelligence Applications
• Abe has extensive experience in leading data migration project. Worked with teams to migrate EMR Electronic Medical Record, Insurance - Claim and Policy data, Transportation and BMV / Vehicle Registration databases.
• Expert in Budgeting & Planning, Architecture, Design, Development, Data Migration - Strategy and Implementation for OLTP & Data warehouse projects.
• Defined governance policies supporting information architecture components and led projects related to data architecture, performance, server migrations and high available application development
• Partnered with stakeholders to identify business problems and develop state-of-the-art solutions aligned with business objectives. Provided data warehouse & BI technology vision, roadmaps and blue prints and project plans.
• Established data architecture and BI best practices & standards; recommended database, ETL & reporting performance-tuning techniques. Mobilized and directed BI professionals and offshore development team of 70+ members at different locations.
• Expert in Implementing multiple database models, data flow diagrams, database schemas, DB scripts, structures and data standards to support a robust data management infrastructure.
• Expert experience translating business requirements into conceptual, logical, and physical data models for both OLTP (3NF) & Dimensional (Star schema) modeling using ERWIN.
• Strong knowledge of ETL (within Data Warehouse environment) processes including a complete functional understanding with hands on experience using Microsoft SSIS packages for the migration of data between OLTP, staging and OLAP environments
• Extensive k no w l ed ge of dat abas e s y s tem s and has a strong Data Migration and Data architecture background. Knowledgeable in all aspects of designing and constructing business processes, functions and organizational structures including workflows, flowcharts, use cases, and organizational design
• Experience developing, supporting Hub and Spoke database architecture in a data warehouse Dev el o p a nd m ai nta in data bas e s tan dar ds, nam i ng c on v ent i o ns and data dictionary creation
• Problem Solving, Requirements Elicitation Expertise in gathering, analyzing and documenting Data requirements and developing Requirement Documents and Functional Requirement Specifications
• Complete understanding of database normalization and can fluently speak about the various normal forms
• W o r ked w i th d atab as e a na l y s t s to de v e l op m ethodol og i es, r epor t v i e w s, q ueri es, and t ab l e r e pl i c ati ons
• Proficient in Oracle version 7, 8, 9i, 11 and 12 .NET, SQL Plus, SQL Server, MS Visio, PLSQL, TSQL, SSIS, SSRS, Aqua Data Studio - Data analysis/data extracts/interface views, CSV, HL7 EDI

TECHNICAL EXPERTISE:

• Visual Studio Framework 8 Years’ experience, Object Oriented Design 11 years, VB.NET 8 years, ASP.NET 8 years, Business Analysis BA 11 years, Business Intelligence 8 years, Capability Maturity Model 9 years
• (CMM), COGNOS 3 Years, Database Management System 15 years, Data Warehousing 8 years, decision-making 11 years, Application Designing 11 years,, disaster recovery 8 years, IBM DB2 3 years, COGNOS Impromptu 3 years, JavaScript 8, leadership skills 15 years, MS Access 8 years, Microsoft Project 10 years, Microsoft SQL Server 12 years, Data migration 11 years, Oracle 12 years, Oracle PL/SQL 12 years, SQL TSQL 12 years, Organizational skills 12 years, Business Policy Implementation 5 Years, problem solving 15 years, process improvement 12 years, program development 8 years, SQL Server BI SSIS (SQL Server Integration Services) 10 years’ experience. Data Migration in Warehouse environment 10 Years’ experience. Aqua Data Studio - Data analysis/data extracts/interface views - CSV, HL7 EDI

WORK EXPERIENCE:

Confidential

Data Architect/ Integration

Responsibilities:

• Create detailed mapping between legacy and new system data elements,
• Contact customers to verify business rules and/or clarify data analysis,
• Identify problems and make recommendations on how to overcome
• Performed data verification.
• Expert in Implementing multiple database models, data flow diagrams, database schemas, DB scripts, structures and data standards to support a robust data management infrastructure.
• Expert experience translating business requirements into conceptual, logical, and physical data models for both OLTP (3NF) & Dimensional (Star schema) modeling using ERWIN.
• Led all facets of database architecture, strategy, capacity planning, data model design (logical & physical), development, performance tuning & maintenance.
• Worked with the business team to build requirements for Incentive management application & DataMart.
• Ensured that data is migrated accurately,
• Develop and run conversion programs and scripts,
• Develop and modify SQL complex Queries and Stored Procedures,
• Provide post conversion support to answer questions and address problems
• Develop standardized procedures for common conversion routines to increase efficiencies,
• Develop/maintain utility programs/scripts to automate common pre/post conversion development tasks.

Data Architect Lead

Confidential, COLUMBUS, OH

Responsibilities:

• Develops database structural requirements by analyzing client operations, applications, and programming; reviewing objectives with clients; evaluating current systems;
• Lead, Architect and Design Conceptual, Logical and Physical Data Models using dimensional model for Data warehouse
• Develops database solutions by designing proposed system; defining database physical structure and functional capabilities, security, back-up, and recovery specifications.
• Design database systems by developing flowcharts; applying optimum access techniques; coordinating installation actions; documents actions.
• Maintains database performance by identifying and resolving production and application development problems; calculating optimum values for parameters; evaluating, integrating, and installing new releases; completing maintenance; answering user questions.
• Provides database support by coding utilities, responding to user questions, and resolving problems.
• Identify reliable data sources during customer onboarding and guide the implementation of automated interfaces
• Work with existing customers and partners to identify and validate new data sources
• Work to ensure data consistency and adherence to defined file specifications
• Communicate interface requirements to Engineering and help resolve ambiguities and inconsistencies
• Ensure the successful completion of integration projects in a timely manner

Database Architect

Confidential, Columbus, OH

Responsibilities:

• Experience with data mapping between several applications and data models Tasked in rewriting Ohio Drivers
• Licenses & Vehicle Registration (DL/VR) databases to increase efficiency, improved functionality, improve performance and comply with department standards.
• Designed new structures for the data in Third Normal Form, Assist in the creation of stored procedures for transactions, Created ETL SSIS solution for moving the data to the new structure and ETL procedure to manipulate data that is currently in a form that cannot be easily maneuvered into the new structures.
• Experience developing, supporting Hub and Spoke database architecture in a data warehouse Dev el o p a nd m ai nta in data bas e s tan dar ds, nam i ng c on v ent i o ns and data dictionary creation
• Have excellent organizational skills, proven analytical, planning, problem solving, and decision-making skills.

Database Architect

Confidential, Columbus, OH

Responsibilities:

• Working with business users to refined business requirement into database design specification Responsible for gathering technical requirement, Design, Development, Testing and Deployment Analyze the current data in the enterprise; determine any similarities, links or if the data is the same. Looking for redundancies in data.
• Writing SQL statements and scripts, schemas, data diagrams.
• Experience writing requirements, entity relationship diagrams, data normalization Strong ETL experience migrating diverse data source into Oracle database Use Microsoft SSIS to migrate data from diverse sources into Oracle 11g database.
• Assisted in Data extraction from other locations primarily through database links to other Oracle Databases or through Oracle Database gateways for non-Oracle data sources.
• Involved in maintenance, enhancement, designing of data dictionaries, physical and logical database models, and performance tuning.
• Database Skills and knowledge of the utilities and production tools used for data storage management to support the Application Team

Database Architect

Confidential, Columbus, OH

Responsibilities:

• Manage developed of extract files from legacy system data that needs to be migrated to RDBMS - SQL SERVER 2008 R2
• Facilitated usage of SSIS Conduct analysis of data migration/conversion specifications and develop code to produce data file extracts based on Staging database Interpret data selection criteria articulated in data migration strategy and apply to data file extracts Unit testing of code Actively involved in quality assurance processes Built ETL processes utilizing SSIS /DTS, including FTP data from remote location, transform it, mart it to data warehouse and provided proper error handling and alerting.
• Developed reports using SQL Server Reporting Services and utilized complex SQL queries and stored procedures.
• Wrote ad-hoc query batches and stored procedures to assist in analyzing, cleaning, checking and processing data to ensure the maximum possible integrity and quality.

Information Technology Consultant /Database Architect

Confidential, Columbus, OH

Responsibilities:

• Architect and Design Conceptual, Logical and Physical Data Models using dimensional model for Data warehouse
• Reviewed & evaluated user requirements for systems development, business analysis, requirements/alternatives analysis and detailed design of small and large complex computer application systems which meet user needs and specifications Analysis of user needs and existing functions to determine feasibility and requirements for computerization maintenance support, software interface As a Technical Liaison, I provided business and systems consultation and support to users, peers, and other department personnel; participated in user walk through meetings.
• Created and managed multiple complex data models (including 900+ tables, 100+ stored procedures) for both incentive management application & incentive data mart solutions.
• Provided logical and physical data modeling and database design support to GM Business Rules, Warranty, Marketing & Sales and Vehicle Operation Systems.
• Defined overall program strategy for migrating data from multiple regions and from multiple legacy systems.
• Worked with the DBA’s to implement data warehouse models on Oracle databases. Assisted the Data Warehousing ETL team in defining the data source-to-target mapping and transformation rules.
• Procured user feedback on technical specifications determined from functional requirements;
• Developed transition plan from current state to future state architecture Established data governance and data quality principles, standards and policies Managed Corporate Data Architecture, Master Data Reference Model, Data Administration, Data Governance, Data Warehouse and Business Intelligence programs to meet strategic business requirements.
• Supported all Internal and External audits of data integrity. Increased audit compliance.
• Evolved the SDLC process and procedures to increase quality assurance and personnel productivity.

Database Administrator/Information Technology Consultant

Confidential, Columbus, OH

Responsibilities:

• Designed and implemented DB security, auditing, replication, and data management Responsible for SQL and
• PL/SQL: scripts, triggers, procedures, packages, automation projects provided 24/7 availability, (clusters, replication, standby database, RMAN) Designed/modeled DB structures to support a variety of software applications Supported developers in tuning DB and applications for optimal performance Monitored DB growth and provided DB capacity planning for application expansion Designed and implemented backup methods and disaster recovery strategies.
• Established data governance organization Developed future state logical and physical data architecture
• Understanding the dimensional modeling of all the data marts involved.
• Involved in creating mappings from basement to second floor (Dimension Model) having transformations like Expression, Filter, Router, Joiners, Update Strategy, Sequence Generator, XML Source Qualifier, Lookups, Stored Procedures etc.
• Developed transition plan from current state to future state architecture Established data governance and data quality principles, standards and policies Managed Corporate Data Architecture, Master Data Reference Model, Data Administration, Data Governance, Data Warehouse and Business Intelligence programs to meet strategic business requirements.
• Developed and managed all databases, which include over 80 application databases on Oracle, SQL Server and Erwin Developed, implemented and managed data security controls
• Evolved the SDLC process and procedures to increase quality assurance and personnel productivity.