Data Sql Server

Summary: Consultant with over ** years of experience in SQL Development, Data Warehousing, Data Architecture, Metadata Management, Data Modeling, Database Design, Data Analysis, Data Profiling, Technical Writing and all facets of Data Governance. Comfortable in both Oracle and SQL Server environments.

Software: Oracle 10g – 12c, SQL Server Enterprise 2005 – 2016, SSIS, Teradata, DB2, Ataccama Data Profiler, Exeros Data Profiler, TOAD Data Profiler, Podium, Oracle Data Quality, SQL Server Data Quality, IBM Information Analyzer, QAS Unify Data Cleanser, Rochade, CA Erwin, Embarcadero ER/Studio, System Architect, SAP Business Objects Data Services, Knowledge of Datastage, Knowledge of ODI, Knowledge of Crystal Reports, Knowledge of XML, Meta-integration, Sharepoint, Excel, Word, Visio, Powerpoint, Access VBA, SQL, T-SQL, Knowledge of PL/SQL, TOAD, IBM Mainframe, JCL, JCL Utilities, IMS, CICS, DB2, VSAM, TSO, COBOL

Vendor Applications

Peoplesoft Campus Solutions

Ellucian Banner Student Management 8.0

Ellucian Banner Workflow 8.0

Ellucian ODS Banner Data Warehouse

EMS Resource Scheduling Application

Oracle Real Estate Application

Salesforce

Experience:

Citizens Bank Cranston, RI (Remote) 5/2017 – 8/2017

Contractor – Data Architect/Data Analyst

Created Logical and Physical Data Models using ER/Studio.

Mapped source/target data lineage from multiple data sources to Data Warehouse as part of data architecture.

Documented business rules.

Wrote SQL queries to support business rules.

Profiled data as part of data quality assurance program.

Updated metadata in Rochade Repository.

AT&T Atlanta, GA (Remote) 7/2016 – 11/2016

Contractor – Data Architect/Data Analyst

Mapped source/target data from multiple sources to support data architecture.

Created data profiles in support of data quality, data migration and data analysis using TOAD Data Profiler.

Created MS Excel pivot table reports for data profiles.

Created Oracle SQL and SQL Server queries for migrating data to a data warehouse.

Documented technical and business rules.

Created Data Dictionaries for legacy Oracle and MS SQL Server databases.

Created Physical Data Models using Erwin.

Massachusetts State Retirement Board Boston, MA 7/2015 – 4/2016

Contractor – Data Analyst

Created data profiles for legacy data as part of data quality initiative.

Documented legacy COBOL mainframe pension system.

Analyzed and documented legacy Oracle PL/SQL ETL scripts and procedures used for transforming mainframe pension data for migration to vendor application.

Created data models for legacy databases using ER/STUDIO.

Created Data Dictionaries for legacy databases using MS Access as a data dictionary repository.

Created data lineage metadata for mainframe to client/server data migration.

Created metadata reports using MS Excel.

Bridgewater State University Bridgewater, MA 1/2014 – 6/2015

Contractor – Data Architect

Created data stewardship program as part of a data governance initiative.

Created standards and procedures for data governance project.

Modeled relational and dimensional databases using ER/Studio.

Reverse engineered physical data models from Oracle and SQL Server using ER/Studio.

Supplemented reverse engineered physical data models with integrity constraints.

Created logical data models from physical models and supplemented with data definitions.

Created architecture and system support documentation for existing SSIS packages.

Created source/target lineage from existing SSIS packages to EDW and dimensional datamarts.

Mapped Banner student data, housing and EMS scheduling sources to dimensional datamarts.

Documented business and technical requirements for extending Banner forms to capture additional information requirements.

Analyzed Banner Oracle forms to document transformation rules.

Wrote queries to extract data from Banner Database.

Modified Banner forms for collection of additional data.

Designed and created reports using SQL as the programming language.

Profiled data in Oracle and SQL Server databases to determine data quality integration suitability with data warehouse.

TUFTS University Somerville, MA 2/2012 - 5/2013

Contractor – ETL Developer

Developed ETL to transform and move data from Peoplesoft Campus Solutions to Oracle data warehouse using Business Objects Data Services.

Developed relational and dimensional data models using ER/Studio.

Developed and supported Oracle and SQL Server data structures.

Designed and created metadata repository to document end-to-end ETL data lineage, processes and business data definitions.

Implemented Data Stewardship program as part of a Data Governance initiative.

Analyzed Peoplesoft Campus Solutions and DB2 database tables and mapped to data warehouse data structures.

Created source/target lineage mapping specifications, bus matrix and ETL design documents.

Iron Mountain Boston, MA 8/2008 – 8/2010

Contractor – Metadata Manager/Data Modeler

Created inventory of applications, databases and reports across the company for a rationalization project.

Created custom data repository application and database using MS Access and VBA.

Converted MS Access Database to SQL Server.

Created logical and physical data models using Erwin.

Reverse engineered physical data models from Oracle, SQL Server and Teradata databases using Erwin.

Forward engineered Oracle, SQL Server and Teradata databases to generate DDL using Erwin.

Provided data profiling and cleansing support using QAS and Exeros Data Profiler for large scale data quality and data governance initiatives.

Provided impact analysis support to determine potential downstream impacts resulting from data warehouse changes.

Documented legacy Business Object and Crystal reports for conversion effort.

Created SQL queries to extract report and source/target lineage metadata from Business Objects and Oracle Data Integrator databases.

Created MS Excel reports for metadata extracts using MS Excel pivot tables.

Mapped destination screen fields from Oracle Real Estate application to their Oracle database source and documented lineage and transformations.

Mapped inbound data extracts to enterprises data warehouse in support of a data integration project.

Mapped Salesforce data to data warehouse.

Analyzed reference, customer and product data to identify MDM candidates.

Documented Oracle Data Integrator ETL data lineage streams.

Developed and implemented an on-line enterprise contextual business term glossary containing over 3,500 terms and acronyms with definitions.

Authored business and functional design documents

Gathered report requirements and created reports using SQL as the programming language.

Harvard Pilgrim Healthcare Quincy, MA 5/2003 – 10/2007

Contractor – Data Modeler/Metadata Manager

Designed and developed Metadata repository to store business, process and technical metadata using MS Access and VBA.

Populated and maintained metadata repository in support of enterprise data warehouse initiative using MS Access.

Converted MS Access databases to Oracle.

Wrote MS Access VBA application to import MS Excel source/target lineage mapping documents.

Wrote business process and technical requirements guides.

Developed SQL Server views for generating metadata reports.

Developed and documented standards and procedures guide for metadata requirements and maintenance.

Developed ETL specifications for claims processing.

Worked with business to document data definitions for logical model entities and attributes.

Created normalized physical data models and forward engineered to generate Oracle, SQL Server and Teradata database DDL using Erwin.

Mapped salesforce data to data warehouse.

Mapped business requirements to enterprise data warehouse.

Performed gap analysis of business requirements and data warehouse.

Performed gap analysis between legacy application data structures and enterprise data warehouse.

Authored technical design and functional requirements documents.

Managed inbound and outbound Dun & Bradstreet data extracts.

Analyzed reference data to determine potential MDM candidate data.

Fleet Bank/Columbia Funds Boston, MA 12/2002 – 3/2003

Contractor – Data Analyst

Profiled and compared market data stored in data warehouse with Bloomberg market data to identify gaps and inconsistencies in bond related data.

Scholastic Publishing New York, NY 5/2000 – 10/2002

Contractor – Data Modeler

Created normalized physical data models using System Architect.

Created data naming standards guide.

Provided AS/400 COBOL development support.

TIAA-CREF New York, NY 3/1997 – 3/2000

Contractor – Metadata Manager/Developer

Created a maintained central metadata repository using MS Access and VBA to support corporate-wide Y2K remediation project.

Extracted metadata from IBM Mainframe COBOL/VSAM, Natural/ADABAS and PL/1 applications and loaded metadata repository.

Developed COBOL programs to extract JCL metadata.

Coded Y2K COBOL fixes.

AT&T E. Brunswick, NJ 2/1991 – 1/1997

Contractor – Metadata Manager/Data Architect

Created normalized physical IMS and DB2 customer and billing databases.

Generated DDL for IMS, Oracle and DB2 databases on IBM mainframe.

Mapped Oracle, IMS and DB2 database data structures to Enterprise logical data model.

Built and maintained corporate metadata repository to support integration of customer and billing data in IMS, DB2 and Oracle databases.

Created and documented logical and physical data naming standards.

Created standardized COBOL copybooks and retrofitted legacy COBOL applications.

Securities Industry Automation Corporation New York, NY 1/1987 – 12/1990

Contractor – Data Analyst/Metadata Manager

Documented NYSE and AMEX legacy COBOL applications and rationalized data structures for IBM Mainframe CICS/VSAM IMS applications.

Reverse engineered and documented legacy IMS databases.

Mapped database columns to securities data.

Created data model s for legacy brokerage applications.

Converted IMS databases to DB2.

Created naming standards for data and application components.

New York Telephone New York, NY 3/1982 – 11/1986

Contractor – Data Analyst/Metadata Manager

Built and maintained metadata repository to support divestiture and conversion of AT&T billing system.

Designed and coded Mainframe COBOL applications to extract metadata from COBOL applications and databases.

Lead a team of six developers charged with extracting metadata from COBOL applications, JCL and IMS databases in an IBM mainframe environment.

Reverse engineered and documented legacy IMS databases.

Education:

Columbia University New York, NY

Data Modeling and Relational Database Technology continuing education courses

State University of New York at Stony Brook Stony Brook, NY

B.A. Social Sciences

Contact this candidate