SUMMARY

• BI Architect Consultant and ETL Architect with over 11 years of experience in Information Technology
• Possesses transferable professional and technical skills t succeed in many technical environments and industries
• A dynamic team player with the ability t ensure that company objectives are met though individual and team efforts
• Extremely focused individual and willing t g the extra mile every time
• Key technical skills include: SQL Server 2012. SQL Server 2008 R2, SQL Server 2008, SQL Server 2005, SQL Server 2000, SSIS 2008/2005, SSRS 2008/2005, DTS, C , ASP, Visual Basic 6.0, COM , SSAS 2008/R2
• Eager t learn new technologies.

TECHNICAL SKILLS

• Versioning Tools: TFS, Visual Source Safe
• Reporting Tools: MS Reporting Services, PowerPivot, Power View, Excel Services

WORK EXPERIENCE

Confidential

Senior BI Consultant/DW Architect

Responsibilities include:

• Serve as Mentor and Trainer for the internal BI team
• Designed ETL template framework
• Optimize current ETL packages and including refactoring.
• Design models logical Physical for the various DW database layers
• Optimize current ETL packages and including refactoring.
• Build SSIS packages t load Integration data int a Data Mart Data Warehouse.
• Construct Deployment Release Packages/Documentation.
• Set up and configure CDC Change Data Capture for the ETL loads int the Data Warehouse.
• Architected a custom incremental load process.
• Model MetaDataRepository/DW/Data Mart using Embarcader ER/Studi Data Architect and Erwin
• Develop a Data Quality framework
• Installed/Configured/Develop Master Data Services

Models

• Entities for Meta Data tables and Conformed Dimensions
• Business Rules
• Hierarchy
• Subscription views
• Deployment Utilities/Documentation
• Entity-base staging
• Construct SSAS Cubes/Semantic Layers
• Develop/Architect new features in MS SQL Server 2012
• Master Data Service
• Power View
• SSAS BISM Tabular
• SSIS
• Develop reporting using MS SQL Server 2012 PowerPivot Power View in SharePoint2010/2013

Confidential

Lead ETL Architect

This project involved history conversion from MS SQL Server 2000 database t SQL Server 2008. There were around 200 DTS packages that needed t be converted t SSIS. Lastly, I built out some Data Marts used for reporting and analytics.

Responsibilities include:

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

Confidential

Senior Database Engineer / ETL Developer

This project involved history conversion from MS SQL Server 2000 database t SQL Server 2005 using SSIS 2005. There were over 150 DTS packages that I converted t SSIS 2005. I also, developed a DW that included Data Marts for a reporting solution.

Responsibilities include:

• 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 t SSIS heavy ActiveX conversion
• Architected the custom logging and configuration process for the ETL processes
• Developed Checkpoint functionality build int the SSIS packages
• Wrote C executable t 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

Senior Database Engineer / ETL Architect

This project involved history Conversion from Oracle 10 g database t SQL Server 2005, and created a DW, which included some subject area Data Mart used for reporting. I als converted around 50 DTS packages t SSIS 2005.

Responsibilities include:

• Migrated 6 Oracle 10G schemas
• Re-wrote Oracle object s t T-SQL Set-Based
• Wrote Data migration in SSIS 2005
• Wrote some template database object s t 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 t SQL Server 2005
• Converted DTS packages t SSIS 2005
• Loaded Data Mart using SSIS packages
• Wrote a custom parameterized XMLA script t 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

Senior Data Integration Engineer

This project involved data analysis and reporting for a direct marketing solution that included ETL, SSRS, and SSAS Cube.

Responsibilities include:

• Developed SSIS ETL Packages/Reporting Services
• Integrated customer files t be prepped for Email and Print process
• Developed SSIS ETL packages t transform various sources and prepped for Production Content Teams
• Performed data scrubbing, data cleansing CASS,CASE
• Converted legacy DTS package t SSIS ETL packages
• Moved client off of Oracle 10 g database t SQL Server 2005
• Migrated 6 schemas
• Re-wrote Oracle object s t SSIS/T-SQL
• Wrote data migration in SSIS
• Wrote template database object s t 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 t 4 week sprints
• Migrated client off of an Oracle 10 g database t 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

Software Engineer /Database Developer

Responsibilities include:

• Created T-SQL stored procedures, DDL scripts, Views, User Defined Functions, Query Optimization
• Used VB 6.0/AD 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 JMFamily internal/external websites
• Converted Daily Batch Process
• Converted legacy batch processes written in VB 6.0, C t C 2.0 applications
• Developed C console application s t execute legacy DTS packages
• Converted DTS package t SSIS ETL packages.

Confidential

Software Engineer

Responsibilities include:

• Created PL/SQL packages, stored procedures, sequences, DDL scripts, Views, Triggers, User Defined Functions
• Used VB 6.0/AD 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 t extract the Web Trends data from MySQL t MS SQL Server
• Ran monthly reports out of SQL Server t verify the accuracy of the Web Trends application.

Confidential

Database Engineer - Data Intelligence Group

Responsibilities include:

• Server t 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 int the schema
• Developed encryption and decryption Web services t be used on the integration processes
• Developed CFC component s
• Managed multiple Client/Customer accounts
• Scheduled daily database backup and recovery

Confidential

Web Developer / Database Developer

Responsibilities include:

• 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/AD 2.6/XHTML/CSS /T-SQL stored procedures, views /Photoshop 7.0
• The new site split int tw different sites Administration Site and Broker Site
• Released the new Underwriting approval component, which allows clients t view up t date underwriting approvals from the website
• Strict security was enforced t only allow the retrieval of secure documents
• Streamed Blob underwriting approvals int the SQL Server 2000 database for security purposes
• Released the new broker pipeline status component, this allows the brokers t view all their up t date activities on the web for their loan activities
• Developed an emulation component that will enable an Global Admin t emulate a broker or master broker, this will give the Global Admin the emulated users security privileges t view and edit all loans processed on the website
• Designed a scheduled DTS package t upload all the aggregate details of the brokers loan activities int summary tables s that the Broker pipeline can have up t 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 n 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 t clean the data and then map it int 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 t the SQL Server reporting server, t 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 t 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 t validate the incoming parameter values t insure correct data insertion
• Designed and developed security architecture for the web administration of the wholesale website, using ASP 3.0/AD 2.6/VBScript 5.0/Cookies
• Developed COM using VB/ADO.