SUMMARY:

I am an experienced IT professional with experience from backend technologies to frontend reporting and website development. As Data Warehouse and Business Intelligence Architect, I have experience in all aspects of the full life cycle of a project. I have taken on roles from Data Modeler, Architect for ETL on the backend and Front End applications over a range of various industries. Highly skilled in enterprise data warehouses, data marts, database development, ETL process design and programming. Asset to any project team through leadership skills and team - mentality.In addition to my backend experience I also have various experience in designing and developing websites and incorporating backend technologies to customize sites to meet needs of both the company and the company’s clients.

TECHNOLOGY SUMMARY:

• Oracle 8i, 9i, 10g & 11g
• Netezza 6 & 7
• Microsoft SQL Server 6.5 - 2000
• DB2 v8, v9 & v10
• Teradata 13
• MySQL
• ERwin 3.5.2, 4.1.2, 7.1, 7.4
• ER/Studio 4.3, 8.5
• MicroStrategy 7.5, 8.0 & 9.x
• Hyperion Intelligence & Brio 8
• Microsoft Analysis (OLAP) Services
• Microsoft Web Components
• Crystal Reports v6 - 10
• Informatica PowerCenter 5.1 -9
• IBM WebSphere (Ascential) DataStage 7.5.1a, 8.1 (Server and Parallel)
• Ab Initio
• Microsoft DTS (SQL Server 7.0 & 2000)
• Microsoft SSIS
• PLSQL
• T-SQL
• SQL (DB2/Teradata/Netezza)
• MSDOS & Unix Scripting
• Visual Basic 5.0 & 6.0
• ASP
• VBScript
• JavaScript
• HTML
• PHP
• CSS
• Microsoft Windows 2007, 2008, 2010 (64bit)
• Microsoft Windows 2000 Professional/Server
• Unix HP-UX
• Red Hat Linux
• TOAD
• Aginity Workbench for Netezza
• Advanced Query Tool (AQT)
• SQL Navigator
• Microsoft Visio Pro
• Microsoft Project
• JIRA
• SQL Assistant
• IIS 4.0 & 5.0
• Visual Source Safe
• VI Editor
• Adobe Dreamweaver
• WordPress
• SVN

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Tech Lead

Technology/Skills: SQL (DB2), DB2, Ab Initio

Responsibilities:

• Worked with Business Analysist, Architects and Data Modeler to establish requirements and design for Enterprise Dimensions as well as Consumer Lending Conformed Dimensions.
• Worked with ETL Lead and off-shore development team to establish Ab Initio graphs used for loading data in to Dimension and Fact tables.

Confidential, Atlanta, GA

IT Specialist

Technology/Skills: PHP, MySQL, WordPress, HTML, JavaScript, CSS, SEO

Responsibilities:

• Designed and created website and backend technologies.
• Web site was created and designed in WordPress utilizing various plugins and customization to allow for a customer portal that gave customers an opportunity to login into their own portal to track progress of project, invoices, and make payments.
• This also gave the company the opportunity to have a place for their employees to login and view a calendar of their assigned projects and tasks, login time, and make any notes for project manager or customers.

Confidential, Atlanta, GA

ETL Architect/Developer, Data Modeler, Microstrategy Architect

Technology/Skills: Netezza 6 & 7, Oracle 10g/11g, Netezza SQL, Aginity Workbench, Microstrategy 9.x, ERStudio 8.5

Responsibilities:

• Project involved redesigning an Oracle/Oracle Discover data warehouse environment to a Netezza/Microstrategy environment.
• The redesign was done to eliminate size and processing time issues on the Oracle database and for reporting for the end users. Some of the processing was improved from many days to under two hours.
• Incorporated new requirements were to allow for business users to manage their reporting needs via Microstrategy instead of manual manipulation of data exported from Discover to excel.
• Designed the ETL to utilize a mix of Informatica mappings and Netezza Stored Procedures in order to maximize performance and getting data from disparate sources.
• Initiated and wrote Source to Target mappings and additional Architecture and ETL process documents and diagrams.

Confidential, Atlanta, GA

Data Modeler/ETL

Technology/Skills: Teradata 13, DataStage 8.1, SQL, SQL Assistant

Responsibilities:

• Project involved creating a data mart to bring together traffic and revenue records together from multiple source systems to provide end user the ability to query and report across and compare results from each system
• The data mart designed on as a Star Schema on Teradata for use by OBIEE front end reporting tool.
• The ETL was managed through Teradata Stored Procedures that were then called by DataStage jobs and sequences.

Confidential, Herndon, VA

Data Solutions Architect

Technology/Skills: TOGAF, ER/Studio 8.5, T-SQL (Oracle 10g)

Responsibilities:

• Project involved creating the guidelines for the Enterprise with regard for designing and implementing various Data Warehousing platforms, including an ODS, EDW, and Data Marts.
• TOGAF v9 was used as a high-level template for establishing and putting together various deliverables.

Confidential, Portland, ME

Senior Data Analyst

Technology/Skills: T-SQL (Oracle 10g), Visio 2007

Responsibilities:

• Project involved creating a Roadmap to provide options and recommendations for bank to meet Regulatory requirement regarding Customer Aggregate Exposure and Lending Limits
• Profiled data from multiple sources to develop possible methods for determining unique customer information across disparate lending servicing and originating systems.
• Finalized business and functional requirements based on government regulations and interviews with multiple key stakeholders

Confidential, Winston-Salem, NC

Technical Architect, Data Modeler/Data Architect, OLAP Architect

Technology/Skills: Informatica 8.1, DB2 v9, SQL (DB2), ERwin, AQT, Visio 2007, Microstrategy 8 & 9

Responsibilities:

• Project involved creating a Data Mart for Corporate Credit Risk Management.
• Initial phase included reverse engineering SAS code from 13 source systems including, Commercial Loans, Retail Loans, Mortgage Loans, Credit Cards, General Ledger etc. and conforming the data into a single Data Mart with monthly feeds
• Sequential phases have included bringing in Funds Transfer Pricing and Charge-Off and Recovery sources and expanding to daily transaction feeds.
• Designed enterprise Corporate Risk Data Mart along with additional dependant mart to support reporting in Microstrategy
• Established overall ETL Architecture and process for entire life-cycle of Data Mart load
• Oversaw team of on-site and off-shore developers to create ETL in Informatica mappings to populate the ECR Mart from DB2 and flat file sources.
• Developed prototype Dashboard in Microstrategy and managed off-site reporting development for Microstrategy reports

Confidential, Winston-Salem, NC

ETL Architect/Developer, Data Modeling

Technology/Skills: Informatica 8.1, DB2 v8 & 9, SQL (DB2), ERwin, AQT, Visio 2003

Responsibilities:

• Project involved making major enhancements to current IBM Banking Data Warehouse (BDW) from both a Data Modeling and ETL processing standpoint
• Established an ETL Architecture model with a conformed landing area (DB2 tables) called the Unified Source Model (USM) to provide a separation point for having source system specific business logic being applied when loading the USM tables and then allowing for general repeatable ETL mappings to be created for loading the BDW tables from the USM layer.
• Designed ETL process and Informatica templates for entire lifecycle of loading BDW
• Lead team of Informatica developers to populate BDW from DB2 sources as well as overseeing Informatica environment including Source and Target Definitions, Shared Transformation etc.
• Created mapping documents and ETL specifications for moving data from USM tables to BDW tables.
• Wrote ETL Standards Guide including Informatica, DB2, File Server, etc as well as providing Best Practices in each area.
• Wrote ETL Developer's Guides to provide instruction and guidance for using aforementioned Informatica templates and proper development of all Informatica objects including mappings, transformations, workflows, etc. to adhere to ETL Architecture

Confidential, Birmingham, AL

ETL Architect/Developer

Technology/Skills: Oracle 9i, PLSQL, ERwin, Visio 2003

Responsibilities:

• Added dimension and facts tables in addition to enhancements to previously designed system to dynamically generate stored procedures that loaded dimension and fact tables of multiple star/snowflake schemas
• Enhancements included added an additional layer providing end user ability to make updates to descriptive and hierarchical information to dimension tables these updates would then be updated into the actual data mart tables.
• Other enhancements were various restart functionality, easier maintenance of metadata information, ability to handle snow flaked and Type 2 dimensions, as well as improving performance on long running queries.
• Sourced data from various systems including AFS, Mortgage Ware, FIOD, RMS and additional loan accounting systems, stored in an Oracle9i database running under Windows 2000 Advanced Server.

Confidential, Atlanta, GA

ETL Architect/Developer

Technology/Skills: SQL (DB2), DB2, Unix Korn Shell Scripts

Responsibilities:

• Developed ETL processes to bring together Credit Risk data from varying sources into data marts with a Cognos reporting front end. All ETL was developed as DB2 scripts that were executed via an Ab Initio job.
• Both star and snowflake schemas were designed to handle fact and dimensions for four data marts that provided, Commercial Loans, Real Estate Loans, Loan Risk, and GL information.
• Data was sourced from other DB2 databases, and flat files.

Confidential, Atlanta, GA

ETL Architect/Data Modeling

Technology/Skills: IBM WebSphere (Ascential) DataStage 7.5.1a (Server and Parallel), Oracle 9i &10g, MS SQL Server 2000, Red Hat Linux

Responsibilities:

• Developed ETL processes to integrate Purchasing and Materials Management (PMM) data into current Enterprise Data Warehouse (EDW).
• Participated in the data modeling of dimensions, including conformed dimensions, and transactional fact tables.
• Architected ETL load process for loading Oracle 9i Operational Data Store (ODS) tables from SQL Server 2000 source system tables using DataStage parallel jobs.
• Developed series of DataStage jobs to load all the Type I and Type II dimensions, as well as fact data into a set of staging tables and finally into the EDW.
• Maintained a separate Oracle schema with views on then EDW tables, which managed any additional specific business rules for PMM data and acted as source for MicroStrategy 8 project.
• Created objects, including, attributes, metrics, prompts, and reports in MicroStrategy for end users.

Confidential, Atlanta, GA

ETL Consultant

Technology/Skills: Informatica PowerCenter 7.1.4, Informatica PowerExchange, MS SQL Server 2000, DB2

Responsibilities:

• Part of a team responsible for near real-time data replication and migration between two OLTP systems.
• As the Confidential was in process of rebuilding their Customer Management Applications, they continued to run the old system as modules new system were completed and brought online. Any data either modified or directly entered into the legacy Mainframe\DB2 system must be replicated over to the new Windows\SQL Server 2000 system. Monitoring of inserts, updates, and deletes on the legacy system was handled with Informatica PowerExchange. The altered records were then processed through Informatica 7.1.3 mappings and loaded into the new system. Replication system had to maintain data migration for both constant incremental changes as well as nightly bulk loads and was required to keep data synchronization within ten minutes of when changes occurred.

Confidential, Atlanta, GA

ETL Architect/Data Modeling

Technology/Skills: PLSQL, Oracle 9i, Informatica, Hyperion Intelligence

Responsibilities:

• Redesigned old ETL process sourcing PeopleSoft to load a Human Resources (HR) data mart due to poor performance issues.
• Decreased the processing time from over 8 hours down to 5 minutes.
• Designed the ETL to bring in additional Recruiting data in to the HR data mart.
• Assisted in development of Executive dashboard with Hyperion Intelligence which was used as the primary front to provide data to the end users.
• Involved in the model design of a Sales data mart. Both data marts were created as star schemas utilizing slowly changing, conformed, and subject area specific dimensions.
• Developed ETL process for the Sales data mart utilizing Informatica PowerCenter 7.1.3 which was designed to handle multiple data sources and irregular granularity of the numerous varying billing systems as resulted from numerous acquisitions.

Confidential, Norcross, GA

SAT Analyst, Designer

Technology/Skills: SQL (DB2), DB2, Unix Korn Shell Scripts, Ab Initio

Responsibilities:

• Part of team to analyze Basel II compliance Business Requirements and Design an automated System Application Test (SAT) application
• Unix Korn Shell Scripts developed to execute DB2 SQL Scripts and load SAT Metadata tables which maintained test case pass/fail history and provide reports to developers, business users, and ensure Basel II compliance.
• SAT application to provide a production incorporated audit test involving row count and aggregate checksum validations throughout EDW and mart loads.
• Functional level tests also developed to validate all logic points with specific test data records.

Confidential, Atlanta, GA

OLAP/MicroStrategy Architect

Technology/Skills: MicroStrategy 7.5.1, Oracle 9i, PLSQL, Informatica PowerCenter 6.2.1

Responsibilities:

• Architected and administered clustered reporting environment in MicroStrategy 7.5.1
• Created attributes, facts, metrics, transformations, prompts, filters, consolidations, custom groups and other MicroStrategy objects to be used to build standard and ad-hoc reports.
• Developed as part of a team, an enterprise solution data warehouse and reporting solution, providing data to business users, executives and ultimately clients with common definitions and calculations of KPIs throughout the entire company.
• Recommended data model design opportunities for report query performance improvements.

Confidential, Birmingham, AL

ETL/Technical Architect

Technology/Skills: Oracle 9i, PLSQL, Brio 8, Erwin, Visio 2002

Responsibilities:

• Designed and implemented the technical architecture to support a Credit Risk Executive Dashboard providing the analytics layer for the enterprise data warehouse supporting a $42B super-regional bank.
• Designed system to dynamically generate stored procedures that loaded dimension and fact tables of multiple star schemas
• Ensured the bank’s achievement of the preferred treatment under Basel II. Be ready to talk to this from the business perspective.
• Sourced data from the bank’s loan accounting, origination, and recovery management systems and stored in an Oracle9i database running under Windows 2000 Advanced Server.
• Improved bank’s competitive position by more closely managing risk, and favorably impacting their capital requirements. This too.