14+ Years Reporting Development
6+ Years Microsoft Business Intelligence
Ability to convey technical material to a non-technical audience
Ability to work well within deadline-oriented development structure
16+ Years Technical/Software Support
Strong Analytical Ability and Problem Solving Skills
Strong technical abilities and desire to learn new things
Ability to work well both independently and within a team environment
Systems and Data Analysis/Design
Motivated, Reliable, Organized, Detail Oriented
SQL Server 2008/2012, SQL Server Management Studio, SQL Server Business Intelligence Development Studio/Data Tools, SSRS, SSIS, TFS, Cognos, Framework Manager, Actuate, IQ Report Writer/Report Builder
Active Directory, Exchange Management, Terminal Services, IIS, RDP
SAP R/3 and Business Warehouse, Sagitta, ABS Accounting/POSITRAKS
Microsoft Windows 95/98/ME/NT/2000/XP/Vista/7/8/Server 2008 R2/2012 R2,UNIX/XENIX/OS5/MS DOS, MAC OS, Azure
Microsoft Excel, Access, Word, Outlook, PowerPoint, Publisher, SharePoint, PowerPivot, PowerView
PC Anywhere, Termulator, Wintegrate, Rumba, FTP, VPN
09/2013 to 12/2014
BI DeveloperSaxony Partners － Dallas, TX
Corporate and customer facing role to develop and generate On-demand and Scheduled reports for Business Analysis or Management decisions using Microsoft Reporting Services platform (SSRS), MS Excel, PowerPivot, and PowerView.
Write Parameterized Queries in developing Custom Report and different types of Chart Reports, Tablix Reports, Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using Global variables, Expressions, and Functions, Sorting, Defining Data sources and Subtotals.
Perform analysis, design, development and implementation of new reporting requirements.
Collaborate with business partners to provide technical report assistance.
Creating and/or enhancing report objects, filters and prompts.
Validating report results against requirement deliverables for accuracy.
Troubleshooting and analyzing data issues within reports.
Following and enhancing BI standards and best practices across the team.
Write, maintain, and optimize SQL queries, stored procedures and functions in SQL Server 2008/2012/2014.
10/2006 to Current
Business Intelligence, Solution ArchitectCirculation Specialists － Shelton, CT
Develop, implement, enhance and manage reporting/web solutions for internal and external clients using SSRS, Microsoft Access, and ASP.Net.
Includes technical design, coding, testing, debugging, documentation and end user training.
Database development, analysis, design, and support.
Extract data from different source systems and files, transform, and load (ETL) data into database tables/data warehouse.
Design interactive VBA interface for report selection, criteria, and display.
Modify report content and deliver output in formats based on user input.
Create ad hoc query solutions targeted to client needs.
Develop web based reporting solution for maintaining client subscriber files both domestic and foreign, digital edition integration, and web stats.
Manage data conversions from fulfillment services.
Build, design, and maintain client facing web applications to maintain subscribers, query subscriber data, and import/export subscriber records.
12/2003 to 03/2008
Systems SpecialistMassMutual Life Insurance Company － Springfield, MA
Cognos/Actuate report developer for corporate controllers division.
Creation/maintenance of queries from SAP BW data warehouse environment.
Construction and maintenance of Actuate reports using SAP queries as the data source.
Using Actuate methods and code to link different subsets of data together to provide fluid reporting.
Conversion of Actuate reports to Cognos including the conversion of source data.
Maintenance of SAP master data, SAP Workbook creation and maintenance, and Actuate production.
Year end/quarter end financial report design and support.
Daily/monthly/quarterly production setup and support.
SAP query design for Cognos Framework Manager.
Documentation of manuals and training materials.
Design automation solutions for Life Financial Controls Accounting and Balancing team to increase productivity and reduce risk.
Analyze and Process Map current workflow issues to outline solution needs.
Develop efficient, accurate, straightforward results to the end user that are clearly documented.
Develop VBA code to create easy to follow spreadsheet and database interface.
Integrate mainframe reports/languages with desktop applications.
Provide internal technical support to team members for mainframe and desktop issues.
09/2002 to 11/2003
Accounting Support AnalystAMS Services, Inc － Windsor, CT
Provide accounting support and analysis to insurance agencies.
Troubleshoot accounting software issues and procedures including Accounts Receivable, Accounts Payable, and General Ledger.
Repair system problems using the applied programming language.
Supply problem-solving techniques to clients.
Write and maintain custom reports.
07/1996 to 08/2002
Software Support ManagerIntegra Systems, Inc － Suffield, CT
Provide support for software, operating system, and basic hardware inquiries.
Analyze financial and numerical data.
Advise clients in the general accounting practices including reconciling financials, month end/year end close, and daily posting of AR/AP/PR/BR entries.
Manipulated raw data to form useful reporting tools.
Devised a system for client implementation and data conversion.
Coordinated and presented classroom/seminar instruction.
Tested and documented program fixes and bugs.
Was solely responsible for creating and maintaining instructional manuals and internal documentation.