SUMMARY:

• Senior Data Analyst and BI Specialist with 25+ years of experience in business services, banking, and technology industries with heavy focus on SQL Databases, Data Warehouses, Integrations, Reporting, Dashboards and KPIs. Expert level in Tableau, Salesforce, SQL Server, SSIS, SSAS, SSRS, Excel, Python, XML, JSON, VBA, and UiPath. Looking for new challenges and technologies in Data and Automations.

TECHNICAL SKILLS:

• BI, Tableau, PowerBI, QlikView, Google Analytics *JSON, XML, CSV, XLSX SSIS, SSRS, SSAS, Scribe DTS, Crystal Reports, UiPath, SoapUI *C#, Python, Java, VBA, VB Script Deltek Maconomy, Workday, Salesforce, IQMS ERP *SQL Server, Oracle, MySQL, MS Access

PROFESSIONAL EXPERIENCE:

Programmer Analyst

Confidential

Responsibilities:

• Supported Deltek Maconomy ERP and middleware SQL Server via Java Extensions, MPL Print Layouts and Integrations.
• Responsible for modification of Salesforce (Sage HCM) schema, pay flow and workflows prior to switch to Workday.
• Built HR Checklist utilizing UiPath to distribute to 20+ HR professionals.
• Run Ad Hoc data analysis and reports of Engagements and Conflicts using PowerBI and complex SQL Queries.
• Convert JSON Files to Scribe Online Cloud ETL for Microsoft Dynamics and HubSpot Integrations.
• Migration of datasets encompassing Timekeeper Data from Sage HCM to Workday.

IT Manager

Confidential

Responsibilities:

• Development of Dashboards written in Tableau for Executive and Sales/Marketing Teams to benchmark Sales to Quotas, System Placements and other KPIs. Using IQMS ERP system and underlying Oracle database and Crystal Reports through automations such as scripting output files using VBScripts and Altair Monarch from PL/SQL queries and Crystal.
• Involved in the IQMS to NetSuite upgrade with consultants (mapping of Systems, Locations, Schema, Inventory, Users, etc.).
• Various Ad Hoc projects such as automating using Word Mail Merge templates for RMA outbound to clients.
• Created MyExcel.com, an online real time Excel class website.
• Design and built MySQL Database for SportBettorsHandbook.com.
• Developed SQL fact table for manufacturing client to in corporate more accurate data mappings in Microsoft Dynamics NAV/CRM and replace SSRS report data and methodologies using this new fact table.

Data Warehouse Analyst

Confidential

Responsibilities:

• Development, enhancement and maintenance of SQL Server Data Warehouses and integration from MISER operations database, vendor data, external files and templates, update logic and mappings, 80+ Integration Services (SSIS), Debugging SQL Queries and Views, Stored Procedures, Performance Tuning and Optimization.
• Transferred Accounting’s Hyperion Essbase application into SSAS, replicating hierarchies, dimensions, and measures, saving bank money from Oracle’s Hyperion fees.
• Reporting solutions such as company - wide dashboards in Reporting Services, QlikView and Excel and creating the report models, dimensions, cubes, etc. using SSAS, SSRS and SQL.
• Development and maintenance of SQL Server Data Warehouse and daily migration from MySQL operations database, Salesforce, Google Analytics, external files, and templates through use of Apex Data loader, Python, AWS (S3 and EC2), Visual Studio, Team Foundation Server, Integration Services, Stored Procedures, etc.
• Created management reports in SSRS and Excel to benchmark Sales, Cohort and Client Campaign profitability.

Senior Data Analyst

Confidential

Responsibilities:

• Created various databases in Access and SQL Server to consolidate and report data for clients in litigation and regulatory matters that were critical in making informed decisions.
• Gathered and analyzed data for Wage disputes and financial damage claims for clients.
• Created MS Access Databases to track and monitor Asset Management infrastructure changes.
• Created a MS Access Database to track and monitor corporate sponsored events held between issuers and investors.
• Built new and supported existing User Developed Tools written in Access for Securities Lending Team.
• Used Macros (VBA) to automate reporting in the Treasury Services Operations Team.

Budget Systems Analyst

Confidential

Responsibilities:

• Maintenance of Satori Procube OLAP Database, including designing and creating cubes, dimensions, members, etc.
• Budget analyst for various offices, practice groups, and departments.
• Proofed statements and reporting packages for senior partners and executive group meetings.

Systems Analyst/Developer

Confidential

Responsibilities:

• Maintain large scale SQL Server database that consolidated Investment Bank revenues from numerous data sources, aggregating dimensions of Time, Region, Sector, Product, etc.
• Received for migrating multiple Access databases into SQL server, converting 400+ Access queries into stored procedures.
• Creation of Access database solutions for Client Profitability & Corporate Data aggregation and reporting.
• Automate reporting of IB Finance to efficiently transfer financial information resulting in reduced overhead.
• Implemented new Oracle based daily reporting by creating solutions using functions i.e. SUMIF() to link Excel.
• Built ad-hoc Access databases to provide pro-forma information and new management requests.

Budget Analyst/Database Administration

Confidential

Responsibilities:

• Loading, consolidating and reconciling data from three legacy G/L databases into Cognos database.
• Maintain Cognos database with new cost center hierarchy roll-up, account structures, and users.