Objective

Seeking a full time position developing and implementing business solutions in Data Warehousing and Business Intelligence utilizing the Microsoft Business Intelligence product stack including one or more of the following: SQL Server 2012/2008, Integration Services SSIS, Reporting Services SSRS, Analysis Services SSAS and Office 2008/2010.

Technical Skill Set

• Possess strong experience in the Microsoft BI stack with SQL Server 2012/2008/2005. Have worked extensively with MS SQL Server 2005 and later versions since the first Community Technology Preview CTP release in 2004 developing a strong skill set in all of the following:
• SQL Server 2012 Database Engine and SQL Agent
• SQL Server 2012 Integration Services SSIS
• SQL Server 2012 Reporting Services and Report Builder SSRS both native mode and SharePoint integrated mode
• SQL Server 2012 Analysis Services SSAS
• Visual Studio ASP.NET, VB.NET, Web Services, XML, HTML, Visual Studio Tools For MS Office
• Business Intelligence Development Studio BIDS
• Microsoft Office SharePoint Server 2007 MOSS 2007
• Microsoft Office including InfoPath 2007 development
• Microsoft MapPoint Web Service and Virtual Earth
• Other Active Directory, IIS, Hyperion, Red Gate SQL Bundle, ER win, Ultra Edit, Confidential Compare, Citrix
• Oracle 9i, 10g, 11g database integration with SQL Server ODAC 11g, Oracle Developer Tools For Visual Studio, Toad, SQL Navigator

Recent Work Experience

Confidential Systems Analyst IV

• Architected Pinnacle Health's custom data warehouse using SQL Server 2008 and BIDS 2008. ETL development with SSIS, OLAP development with SSAS. Miscellaneous development projects with VB.Net, ASP.Net and MS Office.

Confidential BI Consultant

• SSIS Conversion from Cognos DecisionStream - Assist in architectural design, development and implementation in the conversion of all of JLG's Business Intelligence ETL processes from Cognos DecisionStream to SQL Server Integration Services 2008 SSIS .

Confidential - Consultant

• Serving as the Technical Lead within the SQL Server group of PJM's Business Intelligence department. Duties include SSIS, SSRS and SSAS Cube Development SQL Server 2008/2005, Dashboard Development, Architectural direction, planning and implementation. Primary data sources include Oracle 9i, 10g, 11g on AIX and Windows, SQL Server 2000/2005/2008 databases as well as PI Systems data.

Confidential - BI Portal Technical Architect

• Designed, developed and implemented to production environment Penn National's Business Intelligence Portal which hosts via SharePoint - over 100 individual data warehouse based reports available as real time and fiscal month end snapshot versions utilizing MOSS 2007, SSRS and SSIS
• Developed and maintain the company's Executive Financial Scorecard consisting of over 75 Key Performance Indicators KPI with SSAS cubes, MOSS 2007 and SSRS
• Developed and implemented Analysis Services 2005 cubes for ad-hoc analysis by Penn National power users utilizing Excel Services 2007 in SharePoint
• Developed and implemented several SSRS semantic data models for ad-hoc analysis by Penn National power users utilizing Report Builder in SharePoint
• Maintains an unofficial hot line to company executives for providing data studies, presentations and technology demonstrations as needed
• Mentored other Penn National IT developers in the Microsoft BI stack stressing the adherence to best practices
• As a side project developed the company's Agent Profit Sharing Application which has a high level of corporate visibility due to issues with the existing application and its inability to provide auditing feedback

Confidential Data Warehouse Technical Lead

• Obtained corporate sponsorship and budgetary support for the creation of a data warehouse initiative at Penn National for the purposes of providing company decision-makers with one version of the truth. Conducted interviews across all facets of Penn National's organizations determining reporting and ad-hoc data access needs for each business entity, e.g., Commercial and Personal Lines, Actuary, Marketing, Claims, Finance, etc.

Confidential Data Warehouse Technical Lead

• Familiarity with both the Kimball and Inman approach to EDW design, data modeling concepts, production implementation, star schema, relational schema, dimensional processing Type I, II, and III, large fact table processing, bridge tables, late-arriving facts, query optimization strategies, OLTP and OLAP environments
• Developed Penn National's current ETL architecture utilizing SSIS with data sources including VSAM flat files, all flavors of MS SQL Server, Excel spreadsheets, MS Access databases, and a variety of third-party proprietary data structures. Achieved an overall best practices approach to ETL design with SSIS stressing the need for very fast processing and optimization of available server resources. Experience with all data flow and control flow components of SSIS.
• Created Penn National's current production Claims Data Mart consisting of a Daily Transactional Fact, Monthly Feature Snapshot Fact and Monthly Claim / Line of Business Fact tables, the latter two of which implement a sliding window scenario approach utilizing SQL Server 2005 partitioning. These two fact tables contain over 100 million rows and provide rapid query response for current BI Portal users.
• Oversaw the creation and development of Penn National's Policy Data Mart architecture utilizing the SSIS and SQL Server architectures implemented previously. Including the staging environments, Penn National's SAN data storage now exceeds 7 TB terabytes of data. This was accomplished with a very small staff and limited data warehousing and ETL experience within the IT division.

Confidential Application Development Specialist

• Developed company's Premium forecasting application still in use today. Provides capability to forecast future premium and non-premium earnings and expenses utilizing year to date actual data applied to complex mathematical calculations. Results are used as part of company's budget forecasting for each ensuing year. This application, though since re-written was Penn National's very first in-house developed Client/Server application.
• Developed PEMA Property Exposure Mapping Application using MapPoint Web Service, MapPoint 2006 and VB. NET providing risk assessment analysis for company's underwriting staff. This application recently received a 2007 CELENT Excellency in Innovation award.
• Developed ACTS Automated Call Tracking System still in use by company's Customer Contact Center to track all calls received from external clients regarding billing questions, web-site accessibility, etc.
• Served as company's Citrix Server developer and administrator developed strong skills in thin client computing concepts utilizing Windows Terminal Services and Citrix enabling technology.