SUMMARY:

• BI Intelligence Consultant and DW Architect with over 13 years of experience in Information Technology
• Possesses transferable professional and technical skills to succeed in many technical environments and industries
• A dynamic team player with the ability to ensure that company objectives are met though individual and team efforts
• Extremely focused individual and willing to go the extra mile every time
• Key technical skills include: SQL Server 2014, SQL Server 2012, SQL Server 2008 R2, SQL Server 2008, SQL Server 2005, SQL Server 2000, SSIS 2012/2008/2005 , DTS, C#, Tabular, PowerPivot, SSAS 2012/2008/R2, MDS (2014/2012/2008 R2), Dimensional Modeling
• Eager to learn new technologies.

TECHNICAL SKILLS:

Database: SQL Server 2 /2008 R 2/2008/2005/2000/7.0 , Oracle 8i/9i/10G/11 G, Sybase, Teradata 13

Server/Operating Systems: Windows 7, Windows 2000 Professional, Windows 2000 Advanced Server, Windows XP, Server 2003, Server 2008, Server 2008 R2 Enterprise, Windows Server 2012/R2

Modeling Tools: Microsoft Office 2013/2010/2007/200 , Visual Studio 6.0, Visual Studio.Net (versions 1.0,1.1,2.0,3.5,4.0,SQL Navigator, Toad, MS BIDS,SQL Data Tools/ Red Gate SQL/Data Compare Embarcadero (ER/Studio Data Architect), Erwin, Visio

Versioning Tools: TFS, Visual Source Safe

Reporting Tools: PowerPivot, Power View, Excel Services, SSRS

WORK EXPERIENCE:

Confidential, Denver, Colorado

Senior BI Consultant/DW/ETL Architect

Responsibilities:

• Designed and implemented a BIML framework (data driven) to create ETL packages. All of the frameworks have Logging, Auditing, and notification.
• Transient Stage ( Confidential )
• Persistent Stage ( Confidential )
• EDW
• Data Analysis/Discovery and Data Mapping
• Setup and configured Confidential for SQL Server/Oracle
• Setup and configured Attunity Connectors V2.0 for Oracle
• Architected/Designed new Data Warehouse/Data Marts
• Source - to-target mappings
• Mentor and train client’s developers
• ETL architecture and team lead
• Designed/Developed PowerPivot/Tabular Models.
• Developed/Designed Informatica
• Mappings
• Re-usable Transformation
• WorkFlows and sessions
• Developed Execution Plans in DAC
• Designed SCD patters (SCDType1, SCDType2)
• Built Windows VM Labs for Informatica PowerCenter PowerCenter 9.5.1
• Installed the Server components, and configured the Admin Console
• Installed the Client tools (Designer,WorkFlow,Repository,Monitor)
• Installed and configured DAC - Data Warehouse Application Console
• Hadoop PowerBI/MS SQL Server 2016 CTP2 (PolyBase) POC
• Installed and configured HortonWorks 2.0.6 on a Windows server
• Configured Microsoft Hive ODBC
• Developed SSIS packages to import/export data in Hadoop Hive
• Designed PowerPivot report sourced from Hadoop Hive
• Implemented PowerQuery to extract data from Hadoop HDFS.
• Built Windows VM Labs for Microsoft BI Stack
• Installed/Configured MS SQL Server 2014/SharePoint
• Domain Controller
• Database Engine (2014)
• MDS (Excel 2013 Add-In)
• DQS
• Multidimensional/Tabular
• PowerPivot for SharePont2013
• Reporting Service for SharePoint2013
• Setup Power View/PowerPivot Galleries
• Office 365
• PowerQuery/PowerMaps

Confidential, Dallas Texas

Senior BI Architect

Responsibilities:

• Design models (logical|Physical) dimensional model.
• Data Analysis/Discovery and Data Mapping
• Code reviews and team mentoring
• Architected/Designed new Data Warehouse/Data Marts
• Setup/Configured SQL Server Environment (POC)
• SharePoint 2013/2010
• SQL Server 2012
• MDS (with excel add-in for MDS)
• DQS
• Oracle 32/64 BIT client
• Database Mail
• Attunity Connectors for Oracle for SSIS Source Adapters
• Setup and configured Confidential for SQL Server and Oracle
• Setup/Configured SQL Server/SharePoint2013/2010 (PowerPivot/Power View)
• Design/Develop PowerPivot /Tabular models
• Designed and implemented a custom ETL framework
• Logging/auditing Notification
• Reporting
• Incremental load process

Confidential, Austin TX

Senior BI Architect

Responsibilities:

• Mentor and trained internal BI team members
• Designed ETL template framework
• Optimize current ETL packages and including refactoring.
• Design models (logical|Physical) dimensional model.
• Designed/Architected MetaDataRepository
• Common repository for auditing /logging/configuration
• Developed reporting interface
• Architected a custom incremental load process
• Develop a Data Quality framework
• Designed Cube Partition utility (AMO/XLMA)
• Created Cube Backup utility (AMO/XMLA)
• Develop/Architect new features in MS SQL Server 2012 (Denali CTP3)
• MDS
• Power View (SharePoint)
• SSAS BISM (Tabular)
• SSIS
• PowerPivot (SharePoint)

Confidential

Senior BI Consultant/ ETL Architect

Responsibilities:

• Designed ETL template framework
• Mentor and trained client development staff
• Administered daily/weekly status meeting with the client
• Architected/Designed new Data Warehouse
• Data Analysis/Discovery/Data Mapping
• Design models (logical|Physical) dimensional model.
• Optimize current ETL packages and including refactoring.
• Designed/Developed/ ETL packages to load Relational DW and Data Marts
• Architected a custom incremental load process.
• Develop a Data Quality framework
• Develop Multidimensional SSAS Cubes
• Design/Develop Excel Reports (Excel Services,SharePoint2010)

Confidential, Bedford, TX

BI/ETL Architect

Responsibilities:

• Converted clients DTS packages to MS SQL Server 2008 SSIS
• Architected custom logging/auditing/configuration
• Developed ETL template great for rapid development
• Converted legacy MS SQL Server 2000 database to MS SQL Server 2008
• Assisted with production DBA support
• Converted all ETL inline SQL to use T-SQL stored procedures
• Optimized current ETL packages and including refactoring
• Developed C# CLR stored procedures
• Accessed Application conversion to MS SQL Server 2008
• Built SSIS packages to load source data into a Data Marts |Data warehouse
• Setup and configured Change Data Capture a new featured to MS SQL Server 2008
• Created process to load SSIS Data Profiler data into a Data warehouse Metadata repository
• History/Increment loads into the Confidential
• Set up and configured Confidential (Change Data Capture) for the ETL loads into the Data Warehouse.
• Designed both OLTP and OLAP models (Logical | Physical).

Confidential, FT. Worth, TX

Senior Database Engineer / ETL Developer

Responsibilities:

• Database design
• Re-wrote stored procedures, triggers, views
• Worked with team of C# (VS. 3.5) developers writing DAL layers using Entity Framework
• Converted DTS packages to SSIS heavy ActiveX conversion
• Architected the custom logging and configuration process for the ETL processes
• Developed Checkpoint functionality build into the SSIS packages
• Wrote C# executable to execute SSIS package
• Wrote C# class libraries for code re-usability
• Wrapped the executable in a stored procedure that could be created as a scheduled job
• Wrote custom exception handler and sent out exception reports within ETL processing
• Installed and configured the SQL Server 2005 instances in UAT/Production.
• Designed both OLTP and OLAP models (Logical | Physical).

Confidential, Winston-Salem, NC

Senior Database Engineer /ETL Architect

Responsibilities:

• Migrated 6 Oracle 10G schemas
• Re-wrote Oracle object(s) to T-SQL (Set-Based)
• Wrote Data migration in SSIS 2005
• Wrote some template database object(s) to be used by other developers
• Architected the custom logging and configuration process for the ETL processes
• Trained /Assisted team member
• Converted SQL Server 2000 databases to SQL Server 2005
• Converted DTS packages to SSIS 2005
• Loaded Data Mart using SSIS packages
• Wrote a custom parameterized XMLA script to be configurable
• Wrote best practices for database development
• Performed code review(s)
• Wrote C# console applications.
• Designed both OLTP and OLAP models (Logical | Physical).

Confidential, Duluth, GA

Senior Data Integration Engineer

Responsibilities:

• Developed SSIS ETL Packages/Reporting Services
• Integrated customer files to be prepped for Email and Print process
• Developed SSIS ETL packages to transform various sources and prepped for Production Content Teams
• Performed data scrubbing, data cleansing (CASS,CASE)
• Converted legacy DTS package to SSIS ETL packages
• Moved client off of Oracle 10 g database to SQL Server 2005
• Migrated 6 schemas
• Re-wrote Oracle object(s) to SSIS/T-SQL
• Wrote data migration in SSIS
• Wrote template database object(s) to be used by other developers
• Performed maintenance on legacy and the current websites
• VBScript/ADO/COM +/ASPX/C#
• Wrote C# console application for batch processes and SSIS/DTS execution(s)
• Participated in Agile 2 to 4 week sprints
• Migrated client off of an Oracle 10 g database to SQL Server 2005 using SSIS
• Architected the custom logging and configuration process for the ETL
• Installed and configured the SQL Server 2005 instances in UAT/
• Performed code review(s).

Confidential, Jacksonville, FL

Software Engineer /Database Developer

Responsibilities:

• Created T-SQL stored procedures, DDL scripts, Views, User Defined Functions, Query Optimization
• Used VB 6.0/ADO 2.6/ASP.Net (C#,VB.Net),ADO.Net (C#) for COM + object
• Provided production support rotation coverage (24/7)
• Performed enhancements/maintenance on the Confidential internal/external websites
• Converted Daily Batch Process
• Converted legacy batch processes written in (VB 6.0, C++) to C# 2.0 console applications
• Converted the logic in legacy DTS packages to C# console application(s)

Confidential, Jacksonville, FL

Software Engineer

Responsibilities:

• Created PL/SQL packages, stored procedures, sequences, DDL scripts, Views, Triggers, User Defined Functions
• Used VB 6.0/ADO 2.6 for COM + object
• Performed enhancements/maintenance on the JEA.com website
• Involved in the Software Development Life Cycle
• Administered the Web Trends server application
• Designed the DTS package to extract the Web Trends data from MySQL to MS SQL Server
• Ran monthly reports out of SQL Server to verify the accuracy of the Web Trends application.

Confidential, Jacksonville, FL

Database Engineer - Data Intelligence Group

Responsibilities:

• Server to Server base DTS package(s) (Oracle, Access, SQL Server 2000), xml, and flat file(s) integrations mappings
• Developed Nightly feeds using T-SQL (Stored Procedures) scripts and ColdFusion MX Web services
• Programmed all the stored procedures, User Defined Functions, and views for the front-end developers
• Managed the integration and conversion from clients database(s) into the schema
• Developed encryption and decryption Web services to be used on the integration processes
• Developed CFC component(s)
• Managed multiple Client/Customer accounts
• Scheduled daily database backup and recovery

Confidential, Jacksonville, FL

Web Developer / Database Developer

Responsibilities:

• Maintained and developed new functionality for wholesale website, which handles an average volume of $120 million in locked loans monthly, using ASP 3.0/ASP.Net/ADO 2.6/XHTML/CSS /T-SQL (stored procedures, views)/Photoshop 7.0
• The new site split into two different sites Administration Site and Broker Site
• Released the new Underwriting approval component, which allows clients to view up to date underwriting approvals from the website
• Strict security was enforced to only allow the retrieval of secure documents
• Streamed (Blob) underwriting approvals into the SQL Server 2000 database for security purposes
• Released the new broker pipeline status component, this allows the brokers to view all their up to date activities on the web for their loan activities
• Developed an emulation component that will enable an Global Admin to emulate a broker or master broker, this will give the Global Admin the emulated users security privileges to view and edit all loans processed on the website
• Designed a scheduled DTS package to upload all the aggregate details of the brokers loan activities into summary tables so that the Broker pipeline can have up to date data
• Generated customized emails on the website, using AspXMail server
• Added an upload rate sheet component that will display the current mortgage rate sheet for the business day
• Created an upload document component that will display all the site documentation from the database
• Developed CF 5.0 internal web application for customer service department
• Designed and implemented history tables for transactional tables using stored procedures
• Restructured website database
• Normalized the new database, and established a stronger referential integrity along with indexing (clustered and no clustered indexes)
• Developed COM + using VB/ADO
• Performed database cleanup, which comprised of a more strict data typing
• Designed DTS package in a step plan to clean the data and then map it into the new database schema
• Provided website support for an external user base of 2000 users
• Designed and scheduled DTS packages that transferred data from the Sybase mortgage database to the SQL Server reporting server, to administer financial reporting using Crystal 9.0
• Designed and built web-enabled management reports using Crystal Enterprise 9.0, with advanced parameter driven financial reports, using T-SQL stored procedures and views
• Scheduled daily, weekly, quarterly reports, under different department for the mortgage company
• Designed company Crystal templates using company graphics
• Administered four SQL Servers for Crystal reporting, website, and automated task purposes, using T-SQL (stored procedures, advanced views, and user defined functions )
• Designed an automated data submission to query the national database for potential fraudulent loan activities using T-SQL (stored procedures, user defined functions), and ActiveX
• Developed a Client-Side/Server-Side global web form validation system, using JavaScript 1.5 on the front-end, and VBScript Classes on the back-end (regular expressions)
• The regular expression patterns were stored in the database, and retrieved using stored procedures inside the VBScript Classes
• Performed calculations on the loan application pages using JavaScript functions
• Used stored procedures to validate the incoming parameter values to insure correct data insertion
• Designed and developed security architecture for the web administration of the wholesale website, using ASP 3.0/ADO 2.6/VBScript 5.0/Cookies
• Developed COM + using VB/ADO.