Senior IT Business Systems Analyst Resume Juno Beach, FL - Hire IT People

TECHNICAL SKILLS

B.I. Tools: MSBI Stack (SSAS, SSRS, SSIS, SSMS, Report Builder); Visual Studio; Cognos BI (Administration & Studios, Framework Manager, Power Play, Transformer); Power BI; Power Pivot

Development: SQL, PL/SQL, T - SQL, HTML 5, CSS, Powershell, Windows Script

Modeling & Simulation: MATLAB, Simulink

Productivity: Atlassian Suite (Jira, Confluence, Service Desk); Microsoft Office Suite; Toad for Oracle; Serena PVCS; Git; MS Visio; SharePoint

PROFESSIONAL EXPERIENCE

Senior IT Business Systems Analyst

Confidential - Juno Beach, FL

Responsibilities:

Performed sizing, installation, configuration of 3 Cognos 10.2 reporting environments. Migrated contents from Cognos 8.4
Led a team of on-premise and off-shore developers to migrate 300+ reports/cubes from Cognos to MSBI
Transferred knowledge to and trained off-shore team to support overnight batch processes in MSBI
Managed off-shore team’s assignments workload and provided guidance and direction on needed solutions/enhacements
Developed Oracle “VPD” functions for use with SSRS to dynamically filter data to keep in compliance with FERC regulations
Developed Power BI reporting datasets & dashboards to present a POC to an executive team on capabilities of tool
Automated overnight batch health check reports and set up email subscriptions via SharePoint
Administered Cognos & MSBI reporting environments. Handled access provisioning, patching, maintenance and troubleshooting
Designed and developed SSAS models to replace Cognos cubes. Developed SSIS packages in conjunction with Powershell & XMLA scripts to schedule SQL Agent jobs to handle the daily processing of the models.
Worked with AWS migration consultants to design MSBI reporting environment in the cloud
Involved in projects utilizing each of Kanban board and Agile methodology
Led the Design and Development of DMR models to replace very complex snowflake schema models
Supported IM existing reporting structure in addition to entire company's Cognos reporting needs
Created Event Studio agents to notify risk department of potential trade exceptions once triggered
Created interactive dashboards for users to monitor performance trends and compare actual data vs. forecasted
Developed & Modified Oracle & SQL Server reporting objects to serve needs for reporting solutions being developed
Designed and Maintained critical Framework Manager models to serve different business department needs

Database Programmer/Analyst

Confidential - Deerfield Beach, FL

Responsibilities:

Imported and modeled metadata into Framework Manager for use by Cognos report writers
Developed 26 complex reports and scheduled them to automatically burst to appropriate sales staff email
Documented designs of data models and reports created to provide a quick reference for maintenance/troubleshooting purposes
Worked with data modelers to design/develop a Cognos reporting framework for a complex service warranty pricing application
Used Report Studio to develop professional customized multi-query reports

Research/Teaching Assistant

Confidential - Baton Rouge, LA

Responsibilities:

Provided supplemental instruction and review sessions for Instrumentation and Mechanical Control Systems courses
Developed project outlines and graded homework, technical papers and exams. Supervised lab sessions
Researched attempts to control MEMS (microelectromechanical relays) and analyzed open-loop behavior
Designed & simulated a solution for dynamically controlling micro electromechanical relays.
New controller optimized the tracking response to the signal and effectively eliminated gap pull-in.

We provide IT Staff Augmentation Services!

Senior It Business Systems Analyst Resume

Juno Beach, FL

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship