SUMMARY:

• As a Business Analyst who insist on continuing to learn every day, who thrive in a highly collaborative work environment and who when presented with a challenge, don't quit until find a solution. Experience in design and develop custom Business Intelligence (BI) dynamic dashboards, metrics and reports.
• Develop revenue/sales dashboards to track performance for management across products, industry, client sector
• Experience with PowerPoint and proficiency with Excel, Access, MS Project, Visio, Word and SharePoint Admin
• Participate in the design and creation of SharePoint Pages, Sites and Admin functions
• Experience building dashboards using Tableau or similar BI tools using: Data wrangling, Data Warehousing, or Big Data
• Extensive experience in reporting and business intelligence applications on Alteryx and Tableau (Front/End development)
• Strong knowledge of data visualization techniques and dashboard design
• Adaptable and flexible to changing situations with a strong problem - solving mindset.
• Experience with investment products including fixed income, equity, private equity, hedge funds and structured notes

SKILL:

Microsoft Office 2010 (Word, Excel, PowerPoint, Outlook and Access), HP PPM, Visio, Agile, MS Project, SQL Server 2008r2 (SSAS, SSIS, SSRS), Visio, SharePoint (Internal/External), Adobe, Tableau, Micro Strategy, Tableau Server, Alteryx

EXPERIENCE:

Confidential, New York, NY

Sr. Tableau Developer (Business Intelligence Analyst)

Responsibilities:

• As a Sr Tableau Developer work with compliance team to develop new concept dashboards for Trade Surveillance Calibration reporting and monitoring progress
• Create visualization data analytics dashboards, stored procedures, SQL Scripts, process documentation, and standardization of The NICE Actimize, SMART platforms.
• Design innovative approaches to view and interact with data (data modeling, data loading, data migration, data analysis)
• Define report and dashboard models and templates, write complex SQL queries, Alteryx developer for an ETL Processes
• Build and deploy reports, dashboards and publish to server and configure schedules
• Adapt reports with the latest changes on a continuous basis
• Collaborate with various stakeholders within the global Compliance function
• As a member of a team focusing on Compliance Management Information and Regulatory Affairs reporting and a dynamic and high-performance environment

Confidential, New York, NY

Executive Administration, Business Analyst

Responsibilities:

• Create Tableau Dashboards to analyze demand data in order to make business decisions and proposals for capacity management, billing, purchasing decisions, and operations
• Participate in the design and creation of Tableau dashboards and reports for Executive and Sr. Leadership, working with Tableau BI, creating interactive dashboards, and customization to meet needs of end-user, connect to multiple data sources including MS Access, SQL Server, Excel and others.
• Design and develop ETL workflows and datasets in Alteryx to be used by the BI reporting tool. ETL specific for creating datasets (to be used by Tableau Data Extract for BI)
• Plan and execute high quality business analysis of large data sets, analyzing and interpreting collected data to meet business requirements in Alteryx ETL environment. Provide ad-hoc data analysis and support to business functions
• Performing administrative and support activities across a multi-environment Tableau Server infrastructure including security administration, release management, troubleshooting and general systems maintenance
• Reports are created for each audience in mind, ranging from dashboards sent to executives daily and weekly and drill-down dynamic dashboards used by operations to aide support sales
• Create database views and indexes to provide definition and structure, and to maintain data efficiently and reliably
• Ensure data quality in all tableau reports by examining data sets and reducing aggregation errors
• Develop visualizations using sets, parameter driven analysis, filtering, extracts, and background image maps
• Successfully manage capacity of a SharePoint Developer / System Administrator.
• Deliver projects and enhancements that impact the reporting suite, to ensure full continuity and stability in the data.
• As a SharePoint Developer demonstrate exceptional technical skills and teamwork and be capable of showing documented success in the operations and management of Microsoft Office SharePoint Server (MOSS) implementations of varying size and complexity.
• Involve in Front end developing. Designing and supporting a SharePoint site is to ensure that when the users open up the site they see the information in a format that is easy to read and relevant. Support a large variety of devices with varying screen sizes and resolutions to take into consideration these aspects when designing the site. Running tests to make sure that site comes up correctly in different browsers (cross-browser), different operating systems (cross-platform) and different devices (cross-device), which requires careful planning on the side of the developer

Confidential, New York, NY

Sr. Business Analyst

Responsibilities:

• Assisted in test strategy and data creation for testing the mapping document.
• Created and reviewed mapping documents based on data requirements.
• Provided database migration and management solution.
• Assist in design & development of reconciliation report for tracking the data during conversions.
• Coordinated data migration from old to new databases.
• Performed classification / trending analysis by understanding the source data.
• Advanced Excel programming (Vertical and Horizontal look ups, Index and Match functions.
• Design end-to-end ETL process to load the data from client extracts into data warehouse.
• Developed source to target mapping document for Item Master and Item Branch tables.
• Targeted mapping documents for multiple subject area using MS Excel.
• Established standards and guidelines to be used in the areas data access.
• Involved in building and developing reporting solutions on MicroStrategy BI.
• Advanced Excel programming, Usage of Vertical and Horizontal look ups, Index and Match functions.
• Design end-to-end ETL process to load the data from client extracts into data warehouse. Develop source to target mapping document for Item Master and Item Branch tables, source to target mapping documents for multiple subject area using MS Excel. Conversion of Excel Reports to SSRS. Development of all SSRS Reports.

Confidential, New York, NY

Sr Financial Business Analyst

Responsibilities:

• Supported the implementation of bank wide model risk policies including model governance, and monitoring
• Reviewed complex models, conduct large scale data.
• Created challenger models, prepare model documentation, and perform maintenance of model inventory.
• Model development and/or model validation with respect to multi-family and CRE lending. Performed independent validation of selected models to assess the soundness of model design, underlined statistical estimation technique, back-testing and ongoing model performance monitoring.
• Involved in independent model validations and report on the model soundness, accuracy, and ongoing model performance to the Model Risk Manager as well as both internal and external regulators and auditors.
• Reported regularly to the Model Risk Manager on the compliance of the model risk management program, including policies and procedures, with respect to its progress, working issues, and challenges.
• Balance sheet and related journal entries. Involved in Profit & Loss Drivers.
• Updated and enhanced data, model assumptions and methodologies used in stress testing, CCAR calculation; manage operational risk stress testing reporting as part of CCAR process.
• Managed requirements traceability and change request process. Imported and linked Data and Charts from Excel into PowerPoint. Developed of Macros for MS Excel and Access files using VBA, for future updates.
• Processed large data sets of portfolios, analyzed the portfolios' profitability, stability, projection and sensitivity using Excel (PivotTable, VLOOKUP, formulas, Index and Match) and Access (SQL Query) for Federal Reserve's 2012 Comprehensive Capital Analysis and Review (CCAR). Managed of regular stress test "runs," ensuring aggregated results meet or exceed defined standards

Confidential, New York, NY

Sr. Accounts Receivable Department - IT Liaison, Data Reporting

Responsibilities:

• Responsible for insuring that daily billing downloads are performed and billing is ready for processing
• Supported the Meditech BAR Patient Accounting functions and investigates and resolved any problems
• Performed upload s and downloads of patient accounts to various outsource companies into Hospital Server
• Analyzed specific payer activity and/or reports, makes recommendations for appropriate actions
• Completed system account transfers between the Hospital and varies outsource companies using ETL Tools
• Run electronic payment and adjustment files and reconciles
• Responsible for daily downloads of billing files and investigating and resolving errors

Confidential, New York, NY

Business Analyst

Responsibilities:

• Assisted in test strategy and data creation for testing the mapping document.
• Created and reviewed mapping documents based on data requirements.
• Provided database migration and management solution.
• Designed & developed of reconciliation report for tracking the data during conversions.
• Coordinate data migration from old to new.
• Performed classification / trending analysis by understanding the source data.
• Data Validation, Pivot Tables for Reports and Graphs (Advanced Excel programming)
• Designed end-to-end ETL process to load the data from client extracts into data warehouse.
• Created organization charts, Financial Tables, Various layouts in PowerPoint as per Client branding.
• Produced templates based on MS Word, Excel, Visio and PowerPoint with highest quality standards.

Confidential, New York

Data Analyst

Responsibilities:

• Reviewed and recommended database modifications
• Analyzed and rectified data in source systems and Financial Data Warehouse databases.
• Generated and reviewed reports to analyze data using different excel formats.
• Documented requirements for numerous adhoc reporting efforts.
• Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
• Documented all system functionality. Creation Pivot Tables for Reports and creation of Graphs.
• Advanced Excel programming, Usage of Vertical and Horizontal lookups.