TECHNICAL SKILLS

Architecture / Modeling / Analysis Data Warehouse Design: Master Data Management (MDM), Kimball methods, Inmon methods, metadata, ETL, Data Stage, Multivariate Data Set Analysis, Requirements Gathering, Use Cases, Jackson methods, Enterprise Architect, CA Erwin, Embarcadero ER Studio, EA Studio, IBM Rational System Architect, Visio, Quest Toad

Microsoft: SQL Server 2012, 2008, 2005, 2000, BIDS,SSIS and DTS packages, stored procedures, Change Data Capture, Encryption, Replication, Indexed views, SSAS, SSRS, PerformancePoint Server, ProClarity, Team Foundation Server

Oracle: 10g, 9i, 8i, Partitioning, Indexes, Storage configuration, Security Profiles, Roles, Materialized views, Stored procedures, Pipeline and table functions, Index organized tables, Collections, Dynamic SQL, Types, Ref cursors, Aggregate functions

SAP / Business Objects: Crystal Enterprise 8.0, 8.5, 9.0, 10, 11, Crystal Reports, Xcelcius, Universes, Multiple server configurations, Pass through authentication (Active Directory), Report scheduling, Viewer customization, Sub reports, Crosstabs, Custom charts, Conditional Formatting, Shared variables, SQL commands, Alerts Experience Highlights

PROFESSIONAL EXPERIENCE

Confidential

SQL / SAS Programmer/Analysts

Responsibilities:

• Convert SAS programs to SQL Server data mart for marketing campaign management dashboard
• Refactor data structures in SAS and SQL Server to efficiently query 100 million row tables
• Translate denormalized tables into third normal form and snowflake schema
• Create SQL Server partition based tables based on SQL profiling, current, projected usage
• Automate ETL processes, leveraging SSIS between SAS, Access systems and SQL Server
• Convert SAS proc sql to T - SQL stored procedures
• Refactor undocumented SAS/Access based sales lead distribution system to SQL Server
• Capture relationships between business process and technical implementation using activity diagrams
• Document existing application in sequence diagrams
• Leverage CRUD matrix to extract functional requirements from complex, tangled control structures
• Deconstruct VBA driven, dynamic SQL spaghetti/macaroni code into three tier architecture
• Identify reusable functions and translate into SQL stored procedures

Confidential, Grand Rapids, MI

Data Modeler / Analyst

Responsibilities:

• Design and oversee the delivery of functional and technical components for master data initiative
• Partner with technical stakeholders and business customers to define requirements and processes
• Identify needed components for Finance and other emerging master data domains/subject areas
• Create business artifacts to capture requirements including gap analysis, business process, data flow diagrams, impact analysis and data lineage reports
• Refactor master data repository data model for expansion into multiple master data subject areas
• Expand ER Studio data model to include hierarchies, data lineage and data profiling
• Build data movement flows for physical metadata extraction and data profiling
• Deconstruct existing OLTP applications to extract business and transformation rules
• Create and optimized SSIS packages with C# script task for extracting reference data from http, file system and relational data sources
• Create Dataflux flows for data profiling DB2 and Teradata source databases
• Design and develop web based .net application for master data governance and usage
• Coordinate development and implementation efforts between DBA’s, offshore development resources and infrastructure stakeholders
• Design wire frames/mockups for customer approved application functionality and user interface
• Create UML activity, component, and deployment diagrams to translate business requirements to technical specification
• Build SQL Server stored procedures for middle tier metadata processing and application management
• Design and build conceptual, logical, and physical data models for OLTP and analytical systems
• Collaborate with business stakeholders, programmer analysts and SME’s to conduct model reviews and negotiate solutions that translate business requirements into enterprise data models
• Work with DBA’s to translate logical models to physical models in SQL Server, Oracle and DB2
• Assist the modeling team in implementing ER Studio as the enterprise data modeling tool
• Define process to extract, import and validate data model transfers between System Architect and ER Studio repositories

Confidential, Indianapolis, IN

Data Architect / Developer

Responsibilities:

• Partner with external customers, business analysts, and project managers to identify data sources, define business requirements, and develop implementation plans
• Create template to standardize requirement gatherings
• Develop use cases for measuring functionality and performance
• Define timelines factoring technical resources, customer need, and simultaneous implementations
• Collaborate with application architects, DBA’s, and technical analysts to transform business requirements into technical specification for implementing custom data marts
• Perform data analysis to identify data challenges, natural key candidates, cardinality and transformations
• Create dimensional models leveraging Netezza distribution and organization structures
• Leverage SSIS packages to automate creating Netezza and SQL Server data structures as well as meta data required by the application
• Work with develop team as both lead and development resource to implement ETL processes
• Define work plans across multiple clients for developers in house, remotely, and off shore
• Implement coding standards for writing optimized SQL in Netezza and SQL Server
• Perform code review to adhere to customer standards and verify technical and business requirements are implemented correctly
• Write complex SQL queries for transforming large multi-source datasets (100 million + records) into facts and dimensions for daily data loads

Confidential, Muskegon, MI

Data Programmer/Analysts

Responsibilities:

• Design and build ETL processes in SSIS between FoxPro, Filemaker Pro, and Access systems to Oracle and SQL Server transactional and warehouse environments
• Create custom SSIS task and SQL Server schemas for gathering metadata, error handling, and logging
• Leverage SQL functions in SQL Server and Oracle for BLOB/ unstructured text data scrubbing
• Collaborate with all levels leadership levels in requirement definition, analysis, and specification
• Optimize existing Crystal Reports 2008, utilizing advanced PL/SQL, data profiling and query tuning

Confidential, Hastings, MI

Data Architect

Responsibilities:

• Collaborate with both customer and contractors in defining and refining system specification
• Facilitate requirement gathering sessions with solution architect for project stakeholders at all levels
• Create data flow and CRUD diagrams to assist .net developers in translating requirements
• Create conceptual, logical, and physical models in Erwin for transactional and reporting functions
• Translate flat files into third normal schema for data integrity and standards
• Provide source to target mappings documented with Erwin
• Integrate flat file, mainframe (DB2), and Access data sources into SQL Server 2008
• Build SSIS packages with error handling for daily imports, exports and initial load
• Collaborate with DBA to define and implement configuration files for production SSIS packages
• Expand reporting capabilities through collaboration with analyst and marketing end users
• Design and build SSAS cube for analysis across demographic and business specific dimensions
• Translate Access queries into SSRS reports with SQL Server 2008 backend

Confidential, Portsmouth, NH

ETL/Data Architect

Responsibilities:

• Work with lead technologist, business analysts and project manager to define architecture
• Build data flow diagrams for business process in Visio
• Design logical model, Entity/ Attribute diagrams
• Create source to target mapping template identifying both facts and slowly changing dimensions
• Design physical model including indices and data integrity at the domain, referential, and entity levels
• Build dynamic SSIS package to perform ETL including the following transformations
• Type II, III, VI slowly changing dimensions
• Dynamic pivot tables based on business defined entities and system schema tables
• Implement SQL Server Reporting Services front end
• Design and build Report Model for ad hoc reporting through Report Builder
• Create drill down drill through SSRS reports

Confidential, Westwood MA

Technical Specialist, Data Warehouse Architect

Responsibilities:

• Design and build Oracle 9i supply chain, telecommunications and work management data marts
• Create conceptual, logical, and physical diagrams in Erwin and ER Studio and EA Studio
• Performance data analysis and source to target mapping
• Build ETL solutions in IBM Data Stage, SSIS, and Oracle packages and procedures
• Consult with management on data warehouse and business intelligence solutions
• Define and present data mart implementation methodology to technical and non technical staff
• Create project plan templates defining roles, resources, and task for implementing data marts
• Identify and implement Embarcadero DBArtisan, Repository, ER Studio for enterprise metadata framework, data warehouse cost savings, and compliance initiatives
• Consult with technical and non technical staff on business intelligence solutions
• Conduct monthly Crystal Reports user forums for beginner to advanced users
• Conduct training sessions on utilizing data mart with conformed dimensions and facts through SQL, PL\SQL, MS Access, and Crystal Reports

Confidential, Wakefield, MA

Data Services Consultant

Responsibilities:

• Implement The Microsoft SQL Server 2005 BI stack
• Design and build SSIS packages for ETL purposes from source to staging to target data marts
• Design and implement data and reporting architectural frameworks for terabyte data mart implementation
• Build multiple server configurations to support primary and secondary database file structures for future growth, table partitioning, index and tempdb optimization

Confidential, Boston, MA

Data Manager

Responsibilities:

• Architect OLTP and data warehouse systems Define hardware and software configuration for upgrade from SQL Server
• Manage internal and offshore database and application developers on multiple development projects

Senior Report Developer III

Responsibilities:

• Transform transactional SQL Server database into dimensional Oracle data mart