SUMMARY

• Dynamic IT leader with 15+ years’ success driving all aspects of Software Development Life Cycle (SDLC) to deliver outstanding results in a timely manner for clients operating in diverse sectors including healthcare and banking.
• Results - focused Business Intelligence developer with forward-thinking approach to strategic planning and passion for full life cycle project management in Agile/Scrum environments.
• Proven ability to liaise with clients to gather requirements, manage vendor performance, and unite internal / external stakeholders around common goals.
• Capable of balancing multiple priorities, motivating team members and monitor progress, collaborating with IT Project Manager to develop plans and solutions, and ensuring customer satisfaction through comprehensive and attentive support.
• Able to develop metrics and reports, participate in cloud initiatives, and steer data integration and migration

• Cross-functional Team Leadership
• Business Intelligence & Analytics
• Technical Scope Development
• Training, Coaching, & Mentoring
• Enterprise Data Analysis & Reporting
• Application Development & Integration
• Strategic Planning
• Agile / Scrum Methodologies

TECHNICAL SKILLS

• C
• C#
• R
• Java
• HTML
• XML
• VB 6.0
• CSS
• JavaScript
• VB Script
• Oracle
• MS SQL Server
• SSIS
• SSAS
• SSRS
• DAX
• MDX
• SQL Developer
• R Studio
• Microsoft Azure
• NOSQL
• ASP.Net
• .Net
• MS-DOS
• Windows
• MS Team Foundation Server (TFS)
• SVN
• Rational
• HP Service Center
• HP Quality Center
• Hyperion Reports
• Brio Reports
• MS Visual Studio
• MS Visio
• Power BI
• Tableau
• Redgate
• CozyRoc
• Oracle OBIEE Reports
• Oracle Reports & Forms

PROFESSIONAL EXPERIENCE

Confidential, FL

LEAD MICROSOFT BUSINESS INTELLIGENCE (MSBI) Developer

Technical Scope: SQL Server & data tools, .Net, T-SQL, OBIEE Reports, IIS, Windows Server, Visio, TFS, Redgate, Tableau, Tableau Server, CA Erwin, MSBI Stack, WCF services, JSON web services, Crystal Reports, Power BI, Microsoft Azure, R, RStudio

Responsibilities:

• Facilitated BI reports and analytics to enable transition to OBIEE dashboards with supportive data marts. Developed ETL workflow for various projects, designed physical and logical data models, administrated data repository, extracted data from numerous sources and loaded it to SQL database. Designed and created complex SSIS packages for performing ETL operations from different source systems; managed checkpoints, package configurations, logging, and system and user-defined variables; and deployed SSIS packages to diverse environments. Created data marts for supply chain & analytics platform.
• Demonstrated knowledge of claims processing, HIPAA guidelines, EDI transactions (834, 835, 837) and X12 standards while helping to create data marts to support standard claims reports, SSRS reports, and Tableau dashboards. Established database objects; developed Tableau visualizations, dashboards, and workbooks from multiple data sources; and authored SSRS reports. Provided expertise during discussions regarding scaling of SSIS server for parallel processing and migration from SSIS 2012 to SSIS 2017.
• Proposed solutions supporting data-intensive SSRS subscriptions for standard claims and migrated subscription catalogs from SSRS 2012 to SSRS 2016. eBooks / eReportal System Migration: Replaced old Excel macros, Java APIs, and .Net Windows applications with service-oriented architecture (SOA) using WCF services to retrieve data from various sources including NOSQL and transform/load it into data warehouse sing MS ETL components. Programmed SSIS packages to convert JSON response to XML format and perform data warehouse load for eBooks process. Configured IIS 7.5, deployed WCF services, and migrated existing self-service/ad hoc reports to Power BI. Restored database from backup log files.

Confidential, Shelton, CT

MS SQL BI LEAD DEVELOPER

Technical Scope: SQL Server, .Net, T-SQL, SQL Server Reporting Services, SQL Server Integration Services, SQL Server Analysis Services SharePoint, Windows Server, Visio, CA Erwin, SVN, Panorama Viewer, TFS, SSIS, SSAS

Responsibilities:

• Migration of content, tasks, and supporting data from Engineering Standard Work (ESW) GEN1 to ESW GEN2 on SharePoint platform and integration with Engineering Technical University (ETU): Helped create ETU notification tool with Visio diagrams and data modeling. Developed C# application, CAML & LINQ queries to interact with SharePoint lists and libraries, and PowerShell Script to invoke nightly jobs.
• Automated Reverse Vending Machine solution recycling solution data warehouse: Programmed and deployed web-based applications, created various reports and parameterized stored procedures, and configured packages and environment variables. Extended OLAP cubes, dimensions, and data source views (DSV).

Confidential, Richmond, VA

BUSINESS SYSTEMS ANALYST / TEAM LEAD

Technical Scope: SQL Server, MVS, COBOL, DB2, CICS, JCL, VSAM, .Net, Requisite Pro, Harvest, HP Service Center, HP Quality Center, Visio, ASP, ASP.Net, SSIS, SSAS, SSRS

Responsibilities:

• Managed and motivated team of 10, creating and implementing KPIs adopted company-wide to improve supply chain performance.
• Participated in calls with 50 - 70 stakeholders to secure approvals and discuss strategies, partnering with diverse groups enterprise-wide to assess impact and drive critical issue resolution.