We provide IT Staff Augmentation Services!

Database Engineer Resume Profile

SUMMARY

  • BI Architect Consultant and ETL Architect with over 11 years of experience in Information Technology
  • Possesses transferable professional and technical skills tsucceed in many technical environments and industries
  • A dynamic team player with the ability tensure that company objectives are met though individual and team efforts
  • Extremely focused individual and willing tgthe 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 tlearn new technologies.

TECHNICAL SKILLS

Database:

SQL Server 2012 /2008 R2/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

Applications Tools:

Modeling Tools:

Microsoft Office 2013/2010/2007/200, Visual Studi6.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

EmbarcaderER/StudiData Architect , Erwin, Visio

  • 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 tload Integration data inta Data Mart Data Warehouse.
  • Construct Deployment Release Packages/Documentation.
  • Set up and configure CDC Change Data Capture for the ETL loads intthe Data Warehouse.
  • Architected a custom incremental load process.
  • Model MetaDataRepository/DW/Data Mart using EmbarcaderER/StudiData 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 tSQL Server 2008. There were around 200 DTS packages that needed tbe converted tSSIS. Lastly, I built out some Data Marts used for reporting and analytics.

Responsibilities include:

  • Converted clients DTS packages tMS SQL Server 2008 SSIS
  • Architected custom logging/auditing/configuration
  • Developed ETL template great for rapid development
  • Converted legacy MS SQL Server 2000 database tMS SQL Server 2008
  • Assisted with production DBA support
  • Converted all ETL inline SQL tuse T-SQL stored procedures
  • Optimized current ETL packages and including refactoring
  • Developed C CLR stored procedures
  • Accessed Application conversion tMS SQL Server 2008
  • Built SSIS packages tload source data inta Data Marts Data warehouse
  • Setup and configured Change Data Capture a new featured tMS SQL Server 2008
  • Created process tload SSIS Data Profiler data inta Data warehouse Metadata repository
  • History/Increment loads intthe ODS
  • Set up and configured CDC Change Data Capture for the ETL loads intthe 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 tSQL Server 2005 using SSIS 2005. There were over 150 DTS packages that I converted tSSIS 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 tSSIS heavy ActiveX conversion
  • Architected the custom logging and configuration process for the ETL processes
  • Developed Checkpoint functionality build intthe SSIS packages
  • Wrote C executable texecute 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 tSQL Server 2005, and created a DW, which included some subject area Data Mart used for reporting. I alsconverted around 50 DTS packages tSSIS 2005.

Responsibilities include:

  • Migrated 6 Oracle 10G schemas
  • Re-wrote Oracle object s tT-SQL Set-Based
  • Wrote Data migration in SSIS 2005
  • Wrote some template database object s tbe used by other developers
  • Architected the custom logging and configuration process for the ETL processes
  • Trained /Assisted team member
  • Converted SQL Server 2000 databases tSQL Server 2005
  • Converted DTS packages tSSIS 2005
  • Loaded Data Mart using SSIS packages
  • Wrote a custom parameterized XMLA script tbe 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 tbe prepped for Email and Print process
  • Developed SSIS ETL packages ttransform various sources and prepped for Production Content Teams
  • Performed data scrubbing, data cleansing CASS,CASE
  • Converted legacy DTS package tSSIS ETL packages
  • Moved client off of Oracle 10 g database tSQL Server 2005
  • Migrated 6 schemas
  • Re-wrote Oracle object s tSSIS/T-SQL
  • Wrote data migration in SSIS
  • Wrote template database object s tbe 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 t4 week sprints
  • Migrated client off of an Oracle 10 g database tSQL 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/AD2.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 tC 2.0 applications
  • Developed C console application s texecute legacy DTS packages
  • Converted DTS package tSSIS 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/AD2.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 textract the Web Trends data from MySQL tMS SQL Server
  • Ran monthly reports out of SQL Server tverify the accuracy of the Web Trends application.

Confidential

Database Engineer - Data Intelligence Group

Responsibilities include:

  • Server tServer 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 intthe schema
  • Developed encryption and decryption Web services tbe 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/AD2.6/XHTML/CSS /T-SQL stored procedures, views /Photoshop 7.0
  • The new site split inttwdifferent sites Administration Site and Broker Site
  • Released the new Underwriting approval component, which allows clients tview up tdate underwriting approvals from the website
  • Strict security was enforced tonly allow the retrieval of secure documents
  • Streamed Blob underwriting approvals intthe SQL Server 2000 database for security purposes
  • Released the new broker pipeline status component, this allows the brokers tview all their up tdate activities on the web for their loan activities
  • Developed an emulation component that will enable an Global Admin temulate a broker or master broker, this will give the Global Admin the emulated users security privileges tview and edit all loans processed on the website
  • Designed a scheduled DTS package tupload all the aggregate details of the brokers loan activities intsummary tables sthat the Broker pipeline can have up tdate 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 nclustered indexes
  • Developed COM using VB/ADO
  • Performed database cleanup, which comprised of a more strict data typing
  • Designed DTS package in a step plan tclean the data and then map it intthe 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 tthe SQL Server reporting server, tadminister 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 tquery 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 tvalidate the incoming parameter values tinsure correct data insertion
  • Designed and developed security architecture for the web administration of the wholesale website, using ASP 3.0/AD2.6/VBScript 5.0/Cookies
  • Developed COM using VB/ADO.

Hire Now