Attending SQL Career networking eventsResearching IT Industry LeadersTracking Industry TrendsParticipating in Industry Discussions

• Work with BI staff and Management to develop systems enhancements| Analyze Business Requirements and develop SSRS reports and Data Sources • Develop Analytic solutions using SSIS and Excel PowerPivot• Work on creation of a data model and data dictionary of CCA distributed Data Environment

Database Development and Administration | Reporting Services | Specializing in SQL BI | SSRS / SSIS / SSAS

• Develop enhanced SSRS Reporting systems through analysis of current environment; communicate with Business Units and update functionality of key systems to scale up to greater flexibility and improved performance; • Greatly improve reporting procedure performance by use of Table-Valued Parameters for Set-based data selection;• Perform Analysis and Create Documentation of Commissions Services systems, using this resource for redevelopment of Procedures and Reporting; this was key… Show more • Develop enhanced SSRS Reporting systems through analysis of current environment; communicate with Business Units and update functionality of key systems to scale up to greater flexibility and improved performance; • Greatly improve reporting procedure performance by use of Table-Valued Parameters for Set-based data selection;• Perform Analysis and Create Documentation of Commissions Services systems, using this resource for redevelopment of Procedures and Reporting; this was key business tool in departmental communications and business planning. Show less

• Build | Optimize | Manage SQL Server Reporting Services through analysis of current environment; communicate with Business Units and successfully manage full cycle of Reporting Services development and scheduling; • Perform Analysis and Create Documentation of Complete NREO Reporting Services system; this documentation exceeded requirements of external auditors and was key business tool in client communications and business planning;• Develop Data Structure, Business Model and… Show more • Build | Optimize | Manage SQL Server Reporting Services through analysis of current environment; communicate with Business Units and successfully manage full cycle of Reporting Services development and scheduling; • Perform Analysis and Create Documentation of Complete NREO Reporting Services system; this documentation exceeded requirements of external auditors and was key business tool in client communications and business planning;• Develop Data Structure, Business Model and Deployment Logic for Data Marts using SSAS; develop ETL processes for import of data using SSIS. Show less

• Development, Maintenance and Quality Control of Active Server Page sites for Fortune 100 clients• Component-based code editing and new development in JavaScript | VBScript | SQL Server | CSS | HTML • Create and Transform SQL Server solutions which deliver dynamic content for Site components; Analyze and tune query logic

• Develop Document Automation Database Application in MS Access with SQL Server back end and MS Word automation• Deliver Custom forms to import from Db2 Data Warehouse, and create new SQL records with Document Storage capability• Work directly with department contacts to analyze specifications, deliver application prototypes and implement project phases

• Analysis, Stored Procedure development and Normalization for SQL Server Data Warehouse/Migration project • Provide SSRS reporting and develop SSIS packages to import data sources to normalized data structure • Develop Web data import application - from PHP/MySQL to SQL Server - in Visual Studio with SSIS • Automation of HTML Email Marketing using Stored Procedures/Functions/Triggers, dbSendMail and SQL Job Scheduling

• As Project Manager, led Production Department and provided development | author of comprehensive Policy and Procedure Manual of all Production operations | led group meetings to present all operational procedures directly to all Internal business groups• Design, Develop and Maintain Active Server Pages (ASP) applications in JavaScript | VBScript | SQL Server | CSS | HTML • Transform all legacy MSOffice VBA Publishing systems through adoption of XML with XSL Schema standards