OBJECTIVE

Technically sophisticated database software engineering professional with more than 18 years of experience in developing and implementing innovative database solutions. Proven success in planning and directing projects to successful completion utilizing excellent analytical and troubleshooting skills. Highly proficient in data warehouse/BI development using the Microsoft SQL Server BI Suite.

Areas of Expertise:

Confidential

Manager Reporting and Data Analytics

Leads a group of business intelligence developers. Provides daily direction and undertakes project management duties. Works with business leadership and business users to gather requirements for reports and data warehouse deliverables. Drives user acceptance testing, and coordinates the ticketing system. Designs and develops reporting and data warehouse deliverables.

Key Achievements:

• Completed a reporting automation project for one of the company's program offerings for the U.S. Department of Treasury. This project reclaimed 80 resource hours per month.
• Spearheaded development of a formal Reporting and Data Analytics strategy, identifying the necessary steps to deliver a top-tier business intelligence platform to the enterprise. Presented the strategy to Senior Executives.
• Led the operational reporting team to complete 60 operational reports for a new custom CRM application.

Confidential

Business Intelligence Project Lead

Worked as an on-site BI Project Lead/Developer for Sparkhound's client. Provided technical leadership and daily direction for the Business Intelligence project team. Created new database objects, SSIS packages, SSAS cubes, and SSRS reports. Conducted end-user meetings and worked with other Director-level managers to keep the BI project in line with other enterprise IT initiatives. Reported directly to the Vice President of IT.

Key Achievements:

• Collaborated with other team members to design the BI infrastructure for the client. This includes automated deployment, change control, and ETL and cube process monitoring.
• Re-factored existing and developed new SSIS packages for extracting call center data from the client's phone system. Created tables, views and stored procedures within SQL Server.
• Designed new SSAS Cubes and dimensions for the extracted phone data. Developed custom .Net assemblies for use in the SSAS project. Created calculated measures and Perspectives. Created SSAS connected Excel Pivot Reports for business users to perform analysis on the call center data.
• Developed numerous SSRS reports. One report utilized extract phone data to produce a billing report for one of the client's government sponsored programs, Making Homes Affordable. The second report was a daily compliance report for Fannie Mae.

Confidential

Business Intelligence Analyst

Performed design, develop, deploy, support, and maintain functions with the products engineered by the Information Delivery Team. Translated high level business requirements into detailed function specifications and managed requests for changes to the specifications. Participated in the creation of new offerings and feature enhancements of current offerings by developing ETL processes, SSAS cubes, custom reports, and other business intelligence solutions that empowered businesses and capabilities within INVISTA to make better educated business decisions. Supported overnight ETL processing of Business Object Data Integrator and SSIS.

Key Achievements:

• Designed and developed an internal markets billing data mart solution within SQL Server. Designed tables, stored procedures, SSIS packages, SSAS database cubes , and Excel templates to complete the solution.
• Designed new reports for the Procurement Excellence Project. Also collaborated on SSAS cube design. Maintenance of existing reports, and stored procedures within the data mart. Led a sub-project that dealt with modifying the existing cubes, reports, and SSIS packages to handle Unicode characters.
• Maintained and modified the internal IT product catalog system. Interacted with other team members to confirm issues and assist with testing of software modifications. Built necessary database objects for a new sales forecasting client tool. Designed and developed a cross border billing solution for IT management.

Confidential

Contract Data Warehouse Developer

Delivered technical onsite expertise to high profile client, Capital One Bank, in converting legacy WebFocus applications into T-SQL stored procedures. Served as primary point of contact in assessing MIS Services Department reporting and data warehouse needs. Developed and implemented project plans and schedules to meet short-term and long-term project goals.

Key Achievements:

• Developed T-SQL stored procedures and user-defined functions for the WebFocus conversion. Tested and validated the output against current production processes. Performance tuned stored procedures to exceed current processing requirements.
• Developed and tested complex and efficient SSIS packages for loading 5GB files into SQL Server. Packages required extensive control flows, transformation, and error handling.
• Collaborated with other team members in designing tables, views, indexes, auditing framework, testing plans, and design documents using recognized best practices.
• Designed and developed bank associate incentive processing system. This includes SSIS packages for data import, date intensive processing with stored procedures including error handling and auditing, and SSIS packages for data export.
• Provided expert direction and advice to Capital One Bank management in design and implementation of the bank data warehouse.

Confidential

Contract Applications Developer

Interfaced with diverse range of medium-sized clients to complete sophisticated database driven applications. Created and developed client specific turn-key solutions built around Access and MSSQL 2000/2005 databases. Regularly assigned to manage key development projects, reported senior management on project status and success.

Key Achievements:

• Spearheaded creation, programming, and deployment of 220 custom database oriented applications.
• Collaborated with client IT departments to incorporate training, security, SQL database design, and improved application functionality.
• Exceed expectations in developing and programming client user interfaces and reports to meet specific customer specifications.
• Report design and development using various 3rd party reporting tools, including SQL Server Reporting Services.
• Onsite implementation of software solutions using DTS/SSIS packages for initial and on-going loading of external data.
• Delivered complete data processing solutions for such clients as: Amtrak, Media General, Bayer, Wells Fargo, BellSouth, IBM, United Airlines, and Louisiana State University, Texas MHMR, PSI, American Scandia, and Orange County CA Vector Control District.