SUMMARY:

I am a deeply experienced business intelligence development and management professional with proven ability to build and direct teams of local and off - shore knowledge workers and streamline processes with measurable results. I have strong abilities to design effective strategies, execute business plans, and improve profit outcomes. My recruiting, team development, and motivational skills are excellent.

TECHNICAL SKILLS:

• Microsoft SQL Server) 2008/2012 Analysis Services (SSAS)
• Microsoft SQL Server 2008/2012 Integration Services (SSIS/SSDT)
• Microsoft SQL Server 2008/2012 Reporting Services (SSRS)
• Microsoft SQL Server 2008/2012 Management Studio
• Microsoft Azure Machine Learning (Microsoft ML)/Predictive Analytics
• .NET Framework 3.0/3.5/4.0/4.5
• ASP.NET and MVC 4/5
• Microsoft Visual Studio .NET 2010/2012/2015
• Microsoft and Telerik Ajax Controls
• XML/XSL/XAML, SOAP, REST, JQuery, JavaScript

PROFESSIONAL EXPERIENCE:

Confidential

Team Lead/SQL DBA

Responsibilities:

• Supported Corporate Data Warehouse initiative team with tasks related to administration of SQL Server system across the enterprise.
• Developed detailed crosswalk and entity relationship diagrams and assisted ETL team with defining projects using Microsoft and industry best practice standards for data maintenance.
• Created SQL Server stored tables, stored procedures, views and user-defined functions as necessary and consulted with other team members on how best to optimize database system infrastructure.

Confidential

Responsibilities:

• Support Corporate Data Warehouse initiative team with tasks related to administration of SQL Server system across the enterprise.
• Develop detailed crosswalk and entity relationship diagrams and assist ETL team with defining projects using Microsoft and industry best practice standards for data maintenance.
• Create SQL Server stored tables, stored procedures, views and user-defined functions as necessary and consult with other team members on how best to optimize database system infrastructure.

Confidential

Sr. Business Intelligence Consultant

Responsibilities:

• Designed, developed and customized analytic models used to analyze aspects of business decisions within Operations.
• Collaborated cross-functionally to build quantified business cases, business problems, and desired outcomes.
• Mined data, conducted analysis and interpreted the results related to specific projects and over-all KPIs.
• Created influential dashboards and presentations that use information to influence senior leadership on business trends and strategies.
• Monitored KPI’s and engaged leadership on performance issues.
• Reviewed and analyzed trends in business KPI’s, providing relevant information, opinions and recommendations to leadership regarding trends.

Confidential

Senior Programmer/Analyst

Responsibilities:

• Assisted team with BI scripting and software maintenance tasks as needed.
• Monitored daily operations of several software systems, including Automate 10, Automate BPA Server 10 and FormWorks.
• Assisted with SQL Server and ORACLE Server scripting and helped with documentation of claims management workflow and hardware topologies.
• This was a short-term contract position.

Confidential

Business Intelligence Team Lead/Database Administrator

Responsibilities:

• Lead and mentor team in designing, developing, testing and deploying Business Intelligence applications of all kinds using Microsoft SQL Server suite of BI products: Microsoft Azure Machine Learning, Analysis Services (SSAS), Integration Services (SSIS), Reporting Services (SSRS) and Management Studio (SSMS).
• Duties include project management, daily customer interaction, and cube and multidimensional structure design and development.
• Work with Microsoft Team Foundation Server to present results on dashboards and reports.
• Deep knowledge of data structures and statistical methods and techniques are required.

Confidential

Business Intelligence Developer

Responsibilities:

• Design, develop, test and deploy Business Intelligence applications of all kinds using Microsoft SQL Server suite of BI products: Microsoft Azure Machine Learning, Analysis Services (SSAS), Integration Services (SSIS), Reporting Services (SSRS) and Management Studio (SSMS).
• Duties include project management, daily customer interaction, and cube and multidimensional structure design and development.
• Work with Microsoft Team Foundation Server and SharePoint 2013 to present results on dashboards and reports.
• Deep knowledge of data structures and statistical methods and techniques are required.

Confidential

IT Manager

Responsibilities:

• Oversee all aspects of IT Department, reporting directly to the CEO. Duties include user support and coordination of all IT-related projects, as well as interfacing with third-party network/hardware, Microsoft Dynamics GP, and third-party developers.
• Business analysis and management are required. Develop data mart and warehouse architecture to facilitate quick and accurate business analysis and utilize SSIS, SSAS, and SSRS with .NET/C# to support business processes and goals.

Confidential

Sr. SQL Server/SSIS Data Analyst

Responsibilities:

• Analyzed and imported large, class-action lawsuit datasets using SQL Server 2008 Integration Services (SSIS) for use by legal and reporting teams.
• Designed and developed utility programs (i.e., Stored Procedures) to complement ETL efforts and support other data analysts.
• Maintained erratic work schedule based upon customer needs and offered team leadership support to team leads and manager.

Confidential

Sr. Analyst/Developer

Responsibilities:

• Designed, specified, and programmed internal and external web-based applications using Microsoft MVC3, ASP.NET, C#, VB.NET and SQL Server 2008.
• The applications consisted of the customer-facing Sunstone.com website, as well as a custom CRM/CM system, a fully-functional ecommerce system, and several production-level applications and databases that utilize SQL Server Integration Services and SQL Server Analysis Services.

Confidential

Sr. SQL Server 2008 Analyst/Developer

Responsibilities:

• Analyzed existing environmental analysis application to port to new VB.NET codebase.
• Changes included cosmetic and code improvements utilizing a dynamic methodology.
• The application allows users to monitor and analyze environmental data collected using sensors distributed throughout a structure.
• The data are presented in a web-based format, including the use of Telerik presentation products.
• ASP.NET 3.5, VB.NET and SQL Server 2008 were the primary product systems used.

Confidential

Sr. SQL Server 2005 Analyst/Developer

Responsibilities:

• Worked with Confidential management team to develop change and configuration management reports in support of the program.
• Required daily interaction with Confidential team members, as well as in-depth knowledge of SQL Server 2005, SQL Server 2005 Integration Services, and SQL Server 2005 Reporting Services.
• Converted Microsoft Access and Excel reports and spreadsheets to SQL Server 2005 Reporting Services reports.
• Developed custom Visual C# programs to automate all report processing.
• Technologies used: Views, stored procedures, user-defined functions (table- and scalar-valued), SSIS.

Confidential

BI Development Manager

Responsibilities:

• Responsible for planning and design, development, quality assurance, and implementation teams across the organization and around the world, including off-shore developers working in Eastern Europe, Southeast Asia and India.
• The principal product focus was upon using Microsoft applications and tools such as SQL Server 2005, SQL Server 2005 Integration, Analysis, and Reporting Services, SharePoint 2007, and others to provide codeless programming access to SAP systems.
• Supported customers over the United States and in many countries across the world.
• All applications developed using .NET Framework.