Sr. Business Analyst Resume Tampa, FloridaÂ - Hire IT People

SUMMARY:

To obtain an opportunity as a Data or Business Analyst which will utilize my previous experience and education.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential, Tampa, Florida

Sr. Business Analyst

Responsibilities:

Developed ad hoc reporting for agent development strategies and sales lead platform with Spotfire.
Gathered requirements for data extraction & data base queries utilizing Terradata, SQL and MS Access queries.
Developed strategies which enhanced the lead platform and improve lead results.
Created, communicated and managed project plans and business requirements
Troubleshoot platform issues and determine resolution options in concert with technical staff and business constituents

Confidential, Tampa, Florida

Sr. Business Analyst

Responsibilities:

Performs daily and monthly Financial MOR Reporting and linked them to SharePoint.
Performed process improvement using SQL and VBA Macros to improve upon timely deliverance of reporting.
Developed and implemented key operating procedures for Financial MOR Reporting.

Confidential, Jacksonville, Florida

Data Analyst/Business Analyst

Responsibilities:

Performed UA Testing and analysis on data warehouse servers, applications, and databases to ensure accuracy.
Performed ETL for data quality on all Disaster Recovery (DR) secured servers, applications, and databases.
Performed discovery on all SUs, PUs, and TUs from various BI data warehouse systems for analytical purposes including Active Directory, LDAP, and ArchSite.
Developed Qlikview reporting and drilldown diagrams for Cyber Security KPIs.
Worked with different business users and SME’s to develop Vision Document and Business Requirement Specification using SharePoint as an Audit source.
Developed BRDs and FRDs according to SME specifications and requirements and linked all requirements in SharePoint.
Created Use Case Diagrams using MS VISIO in order to show the interaction between the Actors and Use Cases as well as showing the relationship between the Use Cases.
Extracted, analyzed, and refined systems data for analytic purposes and KPI Reporting.
Created Oracle APEX reports for weekly cyber security reporting.
Performed Functional and GUI Testing to ensure that the user acceptance criteria are met.
Performed various Qlikview reporting and analytics on User Access to Critical Applications (CA), Onboarding, Secure Shell (SSH), and Databases.
Developed and implemented Oracle BI Object reports for Cyber Security KPIs and KCAs.

Confidential, Tampa, Florida

Business Analyst

Responsibilities:

Extracted and analyzed Audit and Financial data from various BI data warehouse systems for analytic purposes.
Designed and implemented UI Dashboards and Macros in Excel in VBA allowing business users to report on Risk and Controls processes in SharePoint.
Worked with different business users and SMEs to develop Vision Document and Business Requirement Specifications and gathered Business and Functional Requirements.
Wrote BRDs and FRDs according to SME’s business specifications and requirements.
Developed Qlikview charts, tables, and drilldown visualizations for Risk & Control reporting.
Performed ETL data and research analysis for data quality and Qlikview.
Performed UAT test analysis on data quality against previous reporting to ensure accuracy for regulatory reporting.
Developed Access databases using VBA for Risk & Control to improve efficiency and timely reporting.
Created Visio work flow diagrams for teams and management to show process of work.
Performed various SQL queries to extract data for reporting.
Knowledge and understanding of Use Cases, User stories and Scenarios within projects to effectively portray the needs of the customer.
Performed daily reconciliations in Treasury for various FRO entities for regulatory reporting.
Reconciled mark - to-market haircuts for bond derivatives.

Confidential, Tampa, Florida

Financial Analyst

Responsibilities:

Extracted, Transformed, and Loaded (ETL) data using Microsoft SQL Server to performed daily reconciliations on derivative trades to ensure accuracy.
Performed data analysis on all derivative trades using metric and pivots to ensure quality.
Partnered with various SME’s to develop process improvements and efficiencies.
Partnered with Risk & Control and Audit to ensure system controls were in place for financial accounting.
Performed various UA Testing and routine system updates to ensure systems accurately booked accounting.
Extracted and analyzed Audit and Financial data from various BI data warehouse systems for analytic purposes.
Extracted data from COGNOS, Hyperion, and PeopleSoft 9.1 for monthly and quarterly financial reporting.
Developed Qlikview reporting for various financial and accounting reporting.
Developed and implemented Excel UI Dashboards and Macros in VBA for accounting and regulatory reporting.
Developed Access databases using VBA to improve timeliness and accuracy for STAT and GAAP regulatory and Tax reporting.
Reduced daily operational functions by 6 hours allowing for increase work responsibility.
Analyze and prepare monthly and quarterly derivative tax and SEC reports.
Performed routine queries and reporting utilizing PeopleSoft 9.1.
Booked daily, monthly, quarterly GL entries utilizing PeopleSoft 9.1.
Performed audit testing on departmental Statutory Reporting database.

Confidential, Tampa, Florida

Operations Manager

Responsibilities:

Forecasted monthly and quarterly revenue and cash flow to determine year over yearly growth.
Increased capital by $10,000 per month by reducing A/R from 90 days to a maximum of 45 days.
Performed cost/benefit analysis and negotiated new contracts with vendors and service providers reducing cost by $15,000 yearly.
Managed accounting functions including payroll, G/L, A/R, A/P, bank reconciliations, purchasing, invoicing, and inventory control.