TECHNICAL SKILLS

Platforms: UNIX (Solaris, HP - UX), Windows 2010/XP, IBM 370/OS2, Oracle11g

Languages: VB/ASP .NET, C#, VISUAL STUDIO, LINQ, 2013, SQR, SQL-Server 2008 - 201 9./, Oracle, MF-Cobol, Access, Excel/SSRS VBA

Tools: Visual Studio, Excel, Tableau ( 12 yrs.), SSRS (15 yrs.), Power Bi Desktop and Mobile Apps ( 3 yrs.), Qliksense Desktop Reports

Query Languages: T-SQL, MDX, PL/SQL

PROFESSIONAL EXPERIENCE

Confidential - Middlebury, CT

Business Data Analyst /DW/BI/.Net/SQL/SSRS/ BI Desktop-Mobile App / Tableau Developer

Responsibilities:

• Assignment was to maintain and develop custom SSRS, Tableau, Qliksense/Qlikview and BI Desktop - Mobile Dashboard/reports for the CRM Nexus Academic Application platform based on the SQL Server 2017 database platform.
• Developed a series of Academic reports and dashboards for the Mobile Bi app that contained a wide variety of chart types such as Funnel, Bar and GPS Maps with demographic information.
• A major project was to meet with the Dean of S chool of Liberal Arts in developing and rewriting SSRS reports that the academic intake staff used to determine student grade and financial eligibility.
• Developed the reports in SSRS and later incorporated transposed the same reports and expanded them to dashboards for Power BI Mobile custom apps and Power Bi Modeling with role level Security implemented using DAX filters.
• Developed the first Confidential mobile app was for the student body and upper management called Student Search that would perform wild card searches based on a regular basis with major stakeholders .

Confidential - Lockheed and Martin

Senior Business Materials Analyst /DW/BI/.Net/SQL/SSRS/Tableau Developer /Admin

Responsibilities:

• Maintain and develop a Data Warehouse backend on SQL Server 2017
• Develop and maintain DW Business Intelligence reports for Aftermarket Aircraft Inventory (SAP) system (over 800 reports) on a share point web platform.
• Lead Business/Materials Project Leader for Lockheed’s cutting edge Analytical and Forecasting team. This is a special unit designed specifically to react and plan the inventory for Confidential S-76 and S-92 helicopters in FSL (Forward Storage Locations) around the globe.
• Saved nearly 80 million dollars for management using our BI report tools to know where excess /surplus helicopter part inventory movements are tracked to individual customers.
• Internal, new, and other Corporate Analytic professional tour and train at are U.S. ITAR secure facility daily with a full time Tour guide.
• Live data dashboards showing and comparing how each plant’s production line was performing up-to and including year-to-date are shown daily including an Inventory-Density report showing which ITAR countries are located using color shading
• Developed Tableau 10.5 Bump/BAR charts, Trend and Demo forecasting lines with KPIs, actual and forecast data.
• Installed, administered and developed all the material and programming aspects using Tableau 10.5 Desktop, Data Prep and Server.
• Created reports for the Lockheed Analytics Forecasting team using Qliksense Desktop in a Product comparison of Power BI, Tableau and Qliksense/Qlikview
• Develop SSIS packages using the new SQL Server 2017 toolset (DDST) in Visual Studio 2017 to load the processing stats for manufacturing products from each Site.
• Led meeting to gather requirements for projects for the AOG and Forecasting Staffs.
• Trained 2 other report analysts assigned to me at any given time on SQL, SSRS, SSIS, and Tableau Workbooks and designing Management level dashboards.
• Developed and tested SSRS reports in Visual Studio using cascade groups, grouping by details and pivoting grid/text/object built -in SSRS techniques.
• Drill-through (sub reports with links/parameters and Drilldown dynamic details)
• Performed all the DBA database and data architect functions for the Team.
• Built Data Warehouse BID SSAS cubes (dimensions and measures) for Service Operation using Visual Studio 2017 BIDS.
• Recognized with a Special citation for Repairs induction queue Dashboard for the forecasting team that helped the FSL sites maintain and manage available inventory spare parts for restocking subject based on future stock minus available amounts in recognizing inventory stock reorder points
• Led the project with the Aftermarket Director, Joshua Goodman, to develop a series of AOG (Aircraft on the Ground) SSRS/Tableau dashboards that would show any or all of the FSL’s Part Pull/Push/Repair order and part associated cost details as measurements displayed in various object formats (Grids, Legends, Drill Down / Drill Thru) including location, Date & Time and part number for selection straight or dynamic param eters.

Confidential

Senior Business Data Analyst /DW/BI/.Net/SQL/SSRS/Tableau Developer

Responsibilities:

• Build a Data Warehouse backend on SQL Server 2017 and then report the companies U.S. remote plants thru Tableau 10.4 workbooks and dash boards.
• The first project phase was to analyze the current Access 2014 Applications (Haver-Line Production) form components in order to emulate the same reporting information being currently display in Access queries and reports.
• Developed Tableau and Online Admin Data warehouse workbook reports and dashboards showing and comparing how each plant’s production line was performing year-to-date. Built BID SSAS cubes for Service Operation using Visual Studio 2017 BIDS.
• Installed, administered and developed all the material and programming aspects using Tableau 10.4 Deskto p and Server.
• Develop SSIS packages using the new SQL Server 2017 tool set (DDST) in Visual Studio 2017 to load the processing stats for manufacturing products from each Site.
• Received numerous jobs well done mentions following the presentation.
• Developed Tableau version 10+ Bump charts, Trend and Demo forecasting lines with KPIs, actual and forecast data
• Created a demonstration VB.Net form application for running SSRS reports.
• Performed all the DBA database and data architect functions for this project.

Confidential, Mashantucket, CT

BI/SQL Stack Business/Data Analyst/Developer

Responsibilities:

• Analyze and develop a variety of Power BI /SSRS Pharmacy reporting projects.
• The SSIS projects that I developed contained various Health Plan carriers’ claims and eligibility data for Foxwoods employees in both transferring data files and maintaining data warehouse tables.
• Developed procedures that used queries with advanced joins/unions created in SQL Server 2014.
• Created a VB.net form that would display the various carrier insurance coverage enrollee status codes and other data.
• Used Visual Studio Community 2013 to develop the VB.net form which was set up to accept the group and plan search criteria (text/search button types) to be displayed in a grid using a binding source/navigator
• Developed Power BI desktop reports with role level security(DAX ) - Mobile App Data warehouse reports and dashboards with charts, graphics and parameters showing various member deductibles, out of pocket expenses by insurance carrier, elevator operations with parameters.

Confidential

Senior SQL Data Analyst

Responsibilities:

• My successful assignment was to restart the development on an advanced SQL agent submitted sq. procedure that would perform the SQL Server 2012 database table reduction and archiving of the service center’s DATA MART financial data.
• The business goal was to help the current DataMart report processing performance by only storing data for a seven-year current period and to deliver a separate new data mart for an 8-year historical reporting period purposes.
• The procedure involved advanced technical SQL methods such as dynamic sql with command shell scripting, conditional looping with parameter driven cursors, DML sql commands and try-catch errors with transaction commit and rollback capability (.Net - Visual Studio).
• Produced Data Warehousing SSIS project packages using slowly changing dimensions in conjunction with the new merge statement for DW/ BI data maintenance.
• Developed Power BI Data warehouse reports and dashboards, showing elevator operations with parameters.
• Developed User Acceptance test plan with the internal Business analyst.