Candidates About

PROFESSIONAL EXPERIENCE

Citigroup, Inc., Tampa, Florida                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  08/2017 – 11/2017

Sr. BI Consultant – Contractor with ICG FMU

·         Gathered requirements for data extraction, transformation, and load into Qlik Sense.

·         Performed SQL queries in Oracle to determine specific data types needed for requirements.

·         Developed Mock Qlik Sense reporting and drilldown diagrams for FMU Reporting.

·         Performed testing in Qlik Sense QMC to validate QS Extensions worked correctly.

·         Developed QVDs for Data Modeling used for Qlik Sense which were used in the development of the FMU Portal.

·         Reverse engineered the current QlikView portal to obtain formulas used in Mock trials.

·         Pushed current Qlik Sense development into the live Streams for end users access.

New York Life, Tampa, Florida                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   09/2016 – 12/2016

Sr. Bi Consultant/Sr. Business Analyst – Indirect Marketing and Strategy

·         Developed ad hoc reporting for agent development strategies and sales lead platform with Spotfire maps.

·         Gathered requirements for data extraction & data base queries utilizing Teradata, SQL and MS Access queries.

·         Developed SQL Scripts for creation of various Database Objects (Stored Procedures, Indexes, Triggers, and User Defined Functions).

·         Developed complex queries using joins and sub-queries.

·         Created multiple views and queries for extraction of data.

·         Involved in Extract, Transform and Load (ETL) process framework.

·         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.

Citigroup, Inc., Tampa, Florida                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    02/2016 – 4/2016

Sr. Business Analyst/ Sr. BI Consultant – CTO Strategy and Development

·         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.

·         Strong understanding of Dimensional Modeling technique, Multi-dimensional database Schemas like Star Schema, Snow flake Schema, Fact and Dimensional tables, Section Access, Set Analysis in QlikView and DW concepts

·         Writing SQL Scripts to load the relevant Data in QlikView Applications.

·         Developed Macros, SET ANALYSIS to provide custom functionality in QlikView Applications.

·         Involved in Extract, Transform and Load (ETL) process framework.

·         Developed SQL Scripts for creation of various Database Objects (Stored Procedures, Indexes, Triggers, and User Defined Functions).

·         Developed complex queries using joins and sub-queries.

·         Developed FRDs according to SME specifications and linking the requirements in SharePoint.

Deutsche Bank, Jacksonville, Florida                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        07/2015 – 09/2015

Data Analyst/Sr. BI Consultant – Contractor CISO

·         Developed QlikView reporting and drilldown diagrams for Cyber Security KPIs.

·         Experience with QlikView objects including multiple charts types, Trends, KPI’s, Bookmarks, Pivoting, custom requests for Excel Export, Fast Change and objects for Management Dashboard reporting and other KPI’s.

·         Created QVD’s & updated on timely basis as database updates.

·         Created different charts like pie charts, bar charts, radar charts, bubble charts, water fall charts, pivot tables, straight tables and Gauge charts.

·         Used different loads in the script like Load Inline, Binary load, Partial Reload, Resident Load.

·         Used Alternate States and Set analysis features in the designing part.

·         Monitoring of the QVS, QMC, QVW's and user accounts for the usage of the applications.

·         Pulled data from different data sources and connected using ODBC, OLEDB to QlikView applications and performed ETL as necessary.

·         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.

·         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.

Citigroup, Inc., Tampa, Florida                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  10/2014 – 03/2015

Sr. BI Consultant/Business Analyst – Contractor with FRO Risk & Control and FRO Treasury

·         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.

·         Wrote BRDs and FRDs according to SME’s business specifications and requirements.

·         Gathering data sources like QVD files, Excel, Oracle, binary QVW, Inline and .txt files in developing the QlikView Data Models.

·         Developed QlikView charts, tables, and drilldown visualizations for Risk & Control reporting.

·         Knowledge of many QlikView Functions (Date and Time, Keep, Join, Mapping, String & input Fields etc...) used in projects to create Data Models.

·         Used Alternate States and Set analysis features in the designing part.

·         Created various Flags and KPI based on users requirements.

·         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 and process mapping 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.

MetLife, Inc., Tampa, Florida                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       10/2010 – 7/2014

BI Data/Financial Analyst – (Derivatives Data Integrity & Analytics)

·         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.

·         Worked with QlikView Hierarchies, QlikView Architecture, ETL, Data-warehousing and Dimensional modeling.

·         Involved in Requirement gathering & designing QlikView applications.

·         Gathering data sources like QVD files, Excel, Oracle, binary QVW, Inline and .txt files in developing the QlikView Data Models.

·         Extensive knowledge of all phases of software development life cycle. (Requirement Analysis, Design, Development, Testing and Documentation).

·         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 various UAT testing for audit on departmental Statutory Reporting database.

FULL-TIME STUDENT                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   08/2007 – 08/2009

HERR VALUATION ADVISORS, INC., Tampa, Florida                                                                                                                                                                                                                                                                                              10/2005 – 04/2007

Operations Manager

·         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.