SUMMARY:

• Highly skilled Business Intelligence Specialist with25+ years IT experience, producing solid results for clients ranging from Fortune 500 companies to privately owned businesses.
• I have extensive experience in creating complex software solutions, using many different technologies and platforms. I am a dedicated team player, willing to go above and beyond to meet deadlines and satisfy customer requirements.
• I am able to utilize my strong knowledge to train and lead less - senior developers, and foster an environment for innovation.

TECHNICAL SKILLS:

Microsoft Technologies: SQL Server 2005/2008 R2/2012, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SharePoint Server 2007/2010 & Excel Services, ASP.NET, VB.NET, Team Foundation Server (TFS), Access, Crystal Reports, Office Tools & Office 365

Databases Utilized: MS SQL Server (2000/2005/2008/2008 R2/2012/2014), MS Analysis Services Data Warehouse (SSAS Cubes), Oracle, MS Access, DB2

Development Tools Experience: SQL Server Business Intelligence Development Studio (BIDS/SSMS), Visual Studio 2005/2008/2012/2014, PerformancePoint Dashboard Designer, MS Office, Office 365

SQL & Transact: SQL (T-SQL), MDX, XML, REST (Web Services/APIs), SOAP, ASP.NET, JScript, Ajax, HTML, Visual Basic 6.0/.NET, SAS

System Platforms: Windows XP/2000/7/8/10, Windows Server 2003/2008/2012, Unix, WAN/LAN, IIS, Mainframe

PROFESSIONAL EXPERIENCE:

Confidential - Lehigh Valley, PA

Business Intelligence Solutions Specialist

Responsibilities:

• Develop database/data warehouse solutions for small businesses and home users, utilizing the following technologies:
• SQL Server Business Intelligence Development Studio (SSIS/SSAS/SSRS) 2005/2008 R2
• SQL Server Management Studio (SQL/T-SQL) 2005/2008
• Microsoft Access -and- Microsoft Office Products
• Build and Maintain custom websites for clients’ business requirements
• ASP.NET and API’s to such Web Services as Amazon and Google Apps
• Use SQL Server 2005/2008/2012/2014 (SSIS/SSAS/SSRS) to generate monthly reports for small businesses; including appointment scheduling, inventory control, customer data, invoicing and financials

Confidential - Bethlehem, PA

Team Lead - Reporting & Technology

Responsibilities:

• Manage a team of Business Reporting Analysts, supporting the Service Delivery Systems
• Technical liaison between our company and our external clients
• Develop Business Requirements and Development Plans for System Implementation & Upgrades
• Develop reporting solutions, from Oracle, to create customer-required SLA reports and billing data

Confidential - Center Valley, PA

Technical Specialist

Responsibilities:

• Provided technical support for the Enterprise Risk & Compliance Repository Delivery Processes
• Maintain and Monitor SQL Server ETL Processes and Agent Jobs to ensure SLA’s were met
• Responsible for the development of Web Portals, Web Services, UI Application and SQL Database processes. Also managed 3rd-Party integrated processes
• Created and executed the design and development for a Database Maintenance Consolidation Project, which combined data from the four separate database sources.
• Upgraded all of our 2005/2008 R2 SQL Server Databases, Procedures and Jobs to SQL Server 2012
• Converted SQL DTS 2000 packages to 2012 SSIS Packages, to increase performance & functionality
• Created Web Services as part of a 3-stage process for our Mini-Investigations solution
• Fully automated API and REST communications between three separate internal systems

Confidential - Jenkintown, PA

Database Admin/Developer

Responsibilities:

• Responsible for maintaining SQL Server Infrastructure and Developing Business Intelligence Solutions, using the Microsoft BI Stack (SQL Server/SSIS/SSAS/SSRS)
• Develop ETL Processes to enable transition of Data from multiple legacy systems into a new ERP system
• SQL Server 2008 R2 (SSIS/SSAS/SSRS/T-SQL)
• Set-up exercises to teach the current Developers how to use the MS Business Intelligence Stack, and mentored them with debugging SSIS Packages and ASP Web Pages

Confidential - Plymouth Meeting, PA

Sr. SQL/BI Solutions Consultant

Responsibilities:

• Develop ETL Processes to support the Health Assistant Contact Center, using the following:
• SQL Server 2005 Business Intelligence Development Studio 2005 & 2008 R2 (SSIS/SSRS)
• SQL Server Management Studio (T-SQL/Stored Procedures/Functions/SQL Agent)
• Development and Production support for Microsoft Dynamics and SharePoint Portal that utilizes data from a SQL Server Data Warehouse to provide accurate and secure Patient information to the Healthcare Assistants, which included:
• FTP File Processing (Encryption/Decryption and Secure Data Transmissions)
• Data Conversion/Lookup Matching/Conditional Splits/Script Tasks/Audit Logging/Error Processing - using SSIS Packages, T-SQL Stored Procedures and VB.NET
• Statistical Data Analysis of File Processing for Data Integrity, Completion and Turn-around Timing

Confidential - Pottsville, PA

Systems Analyst

Responsibilities:

• Provide production support and development of ETL processes for SQL Server databases/data warehouse, interfaces to/from external 3rd party systems, reporting services, intranet site/web pages, and other systems’ functionalities:
• SQL Server 2005 Business Intelligence Development Studio (SSIS/SSAS/SSRS/T-SQL)
• SQL Server Management Studio (SQL/T-SQL/Stored Procedures/Functions)
• ASP.NET Web Development (scripted using Visual Basic .NET)
• SharePoint 2007 (MOSS)
• XML / SOAP / Web Services

Confidential - Parsippany, NJ

Business Intelligence Master

Responsibilities:

• Existing data from multiple diverse data sources were consolidated into a uniform SQL Server 2005 database. Several stored procedures were written, using T-SQL, to do table definition and manipulation. SQL Server Integration Services (SSIS) was used for the ETL process to define imports of the data, build scheduling packages, define integration flow, log data error exceptions and orphaned data, define database maintenance plans and send email notifications.
• Created a number of Data Warehouse cubes, dimensions and business critical KPIs using SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance. Created several MDX queries to analyze data, according to business reporting requirements.
• Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements, using SQL Server Reporting Services (SSRS).
• Implemented business intelligence dashboards using Microsoft Office SharePoint Server (MOSS) 2007 Report Center and Excel Services producing different summary results of business critical KPIs, based on user view and role .

Confidential - Easton, PA

IT Consultant

Responsibilities:

• Worked in the Information Solutions department at Crayola, as a liaison between IT and the end-users to define business requirements and develop detailed specifications. This included all aspects of the system development life-cycle from concept and design through the programming/coding and testing/approval processes.
• Responsible for developing ETL interfaces from the mainframe-based SAPIENS (DB2) system into the Siebel 7.8 Consumer Goods system.

Confidential - Allentown, PA

IT Specialist

Responsibilities:

• Primary support analyst for legacy HR and Payroll systems, utilizing the following technologies in this position: PowerBuilder, SQL Server (7.0/2000), Transact-SQL, Stored Procedures, OLAP (Cognos) Cubes, Visual Basic 6, COBOL II, DB2, IDMS, FrontPage, HTML and ASP web design.
• Participated in a conversion project for a portion of our HR systems to SAP, and gained an introductory level of ABAP experience. Developed ETL processes to load SAP data.
• Provided Y2K programming services including modifying, testing, and documenting programs and JCL per company requirements. Worked with coding, compiling, testing, and debugging COBOL II and IDMS programs. Other programming tools used include FOCUS, EZ-Trieve, SyncSort, ADS/O dialogs, and DMLO.

Confidential - Allentown, PA

Senior Programmer Analyst

Responsibilities:

• Implemented a PC COBOL based system, which interfaced to a Visual Basic system.
• Designed and developed the IT Help Desk database and reporting system in MS ACCESS.

Confidential - Bethlehem, PA

Senior Customer Database Fulfillment Analyst

Responsibilities:

• Responsible for designing custom marketing databases. Worked closely with the sales force and external customers to create detailed database and report specifications based on the customers’ requests.
• Implemented customer specifications into a customized data infrastructure, which each customer then loaded on their own in-house computer system. Prepared data files for customer delivery.
• These would include both Mainframe and Desktop applications, as well as many different platforms & programming techniques. Including: COBOL II, EZ-Trieve, DB2, SAS, SQL Server, MVS and TSO

Confidential - Easton, PA

Programmer Analyst

Responsibilities:

• As the primary support for Order Processing, Customer Accounting, and Promotion systems; I developed solutions using COBOL and SAPIENS (object oriented language). Obtained a fluent knowledge of advanced COBOL programming language techniques and MVS JCL using the Roscoe editor.