SUMMARY:

• Enterprise Business Intelligence consultant with over 10+ years of experience in SDLC and 5 years in the Data Visualization Architect/Analytics space.
• Possess 7 year of experience in developing interactive data visualization dashboards in Tableau 9.3 - 10.3 for testing/acquisition of the B.I. Software
• Evaluated Tableau SalesForce data connectors & AWS Management Console (Redshift) architecture, to understand (MySQL) data flow process to feed dashboards in Tableau 9.3
• Experience in data mapping, data normalization, and reporting capabilities using Tableau 8 Business Intelligence tool to support Digital Display Benchmarking Analytics project for client
• Managed & Planned and developed Business Intelligence Analytics solutions for Data Integration utilizing SQL Server 2005/2008/2012 platform for Multi-Clients ( Wal-Mart - BMS - Krafts )
• Experience in developing ETL Architecture utilizing SSIS packages for system data integrations/transmission to SQL Server objects using Business Intelligence Development Studio ( BIDS ) and Visual Studio 2008
• Intensive Experience in Tableau Development and connected multi database sources, tables/views to Tableau 8.1 for data modeling/manipulation/visualization dashboards, created calculated fields, parameters, Web Analytics metrics, that provided business insights to internal team and clients for decision-making
• Developed and delivered training on SSRS and Tableau to Business Analysts and Power Users to create a self-service environment where business users could build out their own reporting for low complexity reports.
• Prior experience with SCRUM/Agile environments with enterprise-level application development projects, intensive use of JIRA
• Experience in developing SSRS/Report Builder 3.0 reports for Sharepoint, created charts, dashboards for Analytics
• Performed admin support activities across a multi-client environment Tableau 6.0/7.0 infrastructure including security administrations, API connection to download files from report central in DART/Google Analytics.
• Experience in performing data modeling, data mining within Teradata database schemas, stored procedure & data extractions for analysis
• Design and develop ETL workflows and datasets in Alteryx to be used by BI reporting tool (Tableau). ETL specific for creating datasets (to be used by Tableau Data Extract for BI)

TECHNICAL SKILLS:

Languages: C/C++, C#, Java, JavaScript-D3.js, VB 6.0, VB.NET, VBA, ASP.NET & SQL/T-SQL, PL/SQL, SQL*PLUS, Python

Tools: MS Office XP: Excel, Access, Word, FrontPage, Power Point, Crystal Reports, Visio, and Lotus Note, Tableau 10.3, Power-BI, Cognos 8 BI, Alteryx 10.1/10.5

Web/Internet: E-Commerce, Web Design, Dreamweaver MX, Flash MX, HTML, DHTML, JavaScript, CSS/ASP.NET.

Database: Oracle 8i/9i/10g, DB2, Teradata, MySQL, SAS, SQL Server 2005/08, SSIS/SSRS/SSAS.

Operating Systems: Windows 95/98/2000/XP/Vista/ 7, NT-Server/WorkStation 2000, LINUX/UNIX.

Big Data Tools: AWS, Hadoop, Clarudera, Impala, Apache Spark, Scala, MapReduce, HDFS, Hive

PROFESSIONAL EXPERIENCE:

Data Visualization Specialist

Confidential, New York, NY

Responsibilities:

• Collaborated with Business Analyst/Power users in meetings with Stakeholder’s and product management team to understand Business requirement, layout, and look and feel of the potential dashboards to be developed and created prototype/proof of concept.
• Established partnerships with key business leaders to provide strategic consulting services and solve data related challenges and needs.
• Support Analytics team to implement self-service analytics products to commercial banking in the US & Global. Embedded Analytics solution to existing wed base Applications.
• Supported Research Equity & FICC Sales LOB on the implementation plan for their data visualization initiatives Tableau 9.3
• Provided Tableau (Desktop) intensive training to Analysts to support aspects of operational risk reporting and analysis, and input on improving the reporting process; included streamlining (automating) reporting (Statistical Sampling Population) to make it a more robust, efficient and cost - effective process.
• Provided strategic analysis of structured (e.g. transactional data) and unstructured (e.g. text) electronic data, from initial data scoping and collection through transformation and validation, for purposes of deep data mining and analysis.
• Evaluated (MySQL) data connection to the Amazon Cloud (AWS Redshift) to understand the database architecture for Tableau 9.3 data connection.
• Evaluated Tableau SalesForce data connector to create data extract (tde files) from SalesForce API structure and setup data refresh within different time intervals in tableau server.
• Developed Analytical benchmark measurements to monitor sales online performance between different online Businesses across the world (UK, France, Mexico, Brazil, Argentina, etc.)
• Successfully managed and oversaw a team of analysts for a dual onshore and offshore group, acting as liaison between Sr Management and IT to ensure accurate and actionable Business Insights.
• Managed data governance, data architecture analysis and design, and integrated data management ETL processes (Alteryx) to extract data from multiple sources, generated data extract (tde), Data Architecture/Modeling, development, production, distribution , and support of key operational metrics (Daily, weekly, and monthly) at the global, regional, and LOB-specific levels.
• Defines and implements strategies / processes to ensure the accurate input, storage and reporting of customer marketing data
• Managed Customer Relationship Management (CRM) system and raise any feed or data issues to relevant parties.
• Designed new logic and database structure to improve data usability, customer experience and analytics.
• Gathered Business requirements & converted to data modeling (Conceptual/Logical & Physical Data Model), data mapping, data normalization, and reporting capabilities using Tableau 8 B. I. tool to support Digital Display Benchmarking Analytics project for client (GroupM/MindShare).

Manager Data & Analytics

Confidential, New York City, NY

• Managed & Planned and developed Business Intelligence Analytics solutions for massive Data Integration utilizing SQL Server 2005/2008 platform for Multi-Clients. Developed and manage performance, integrity and security database.
• Created and Designed logical database schema architecture for data warehouse ( Teradata ) environment to prepare for ETL process using Visual Studio SSIS packages (VB.NET 2008 & SQL Server 2005/2008 T-SQL, SSAS), performed data modeling, data mining within Teradata database schemas, stored procedure & data extractions for analysis.
• Interacted with stakeholders and business users to understand Business requirements to provide insights/recommendations per interactive data visualization dashboards views/metrics developed in Tableau .
• Conducted intensive Tableau training sessions to business analyst/users, provided support to analytics team, managed admin user accounts & provided self-service analytics/reporting solutions to business users and clients.
• Intensive development of views/Dashboards using Tableau 7 analytical tool, and published dashboards to Tableau Server for data visualization portals.
• Intensive data mining practice (SQL ), data mapping, data profiling for data manipulation/extraction in Teradata environment for data integration and statistical analysis (predictive analytics, regression analysis, etc.)
• Responsible & coordinating data collection for Marketing Mix Modeling Analysis (MMM) across multiple media channels
• Integrated multiple raw data sources (Ad data, double-click, Omniture, Google Analytics (API Python), Search, Purchasing & Planning data, Radio and Print, Impressions/Clicks) into centralized data repository Data Warehouse.
• Interacted with planning & Activation team to identify and resolve issues that arose throughout the duration of Marketing Campaign. Worked close with the media team to determine optimal metrics for developing insights into campaign effectiveness
• Analyzed and identified key insights in relation to overall objectives of maximizing Marketing ROI from (SEO/Keyword analysis, social media, paid media, earned media and global search) and created intuitive summary analytics dashboards, PowerPoint 2010 - Embedding an Interactive Excel PivotTable (Slicer)
• Wal-Mart Project: Plan vs. Actual Spend (Tableau 7.0)

Automation/Database Analyst

Confidential, New York City, NY

• Managed plan and development of Data Integration utilizing TOAD for Data Analysis tool to support Corporate Audit - Global Market-Branch Supervision Units. Interacted with line of Business and the IT group to define future state of data integration from multiple sources and data management to meet Business and IT objective
• Created and Designed logical database schema layout structure to prepare for ETL processes, data extraction, data mapping, data Analysis and Reporting System utilizing SSIS, SSRS, for data warehouse (SQL Server 2008)
• Performed intensive data mining developed complex SQL script, data mapping with DB2, Sybase, Oracle, and SQL Server platforms utilizing Teradata, TOAD for Data Analysis, Hyperion, and Systematic. Intensive used of Business Object & SharePoint environment to support GM. Developed SQL/T-SQL script for data extraction and developed prototypes for risk assessment models. Identified control trends in assigned business areas as well as impact to the business and to the Bank overall by applying deep and broad business acumen.

Database Developer Analyst

Confidential , New York City, NY

• Managed research to create system scope and objective, understanding business requirements in the Social, Environment, Governance and Financial industry within their sectors, and collect the necessary data (KPI’s) to create logical data model, as well as develop of reporting system for sustainability performance investments analysis.
• Development of views/Dashboards using QlikView/Tableau 6.0 analytical tool, Assessed Tableau desktop / QlikView softwares to ensure it will meet analytical expectations.
• Developed data integration systems for MS SQL Server data merger. Performed data extraction from different data sources and loaded into a centralized data warehouse environment. Developed SSIS packages (C#/VB.NET) and implemented SSIS structure using Visual Studio 2008.
• Designed and Developed MS Access database structure for Index-Base product ETFs, Mutual Funds & UITs, logical and physical database layout, data model, data integration from different sources such as MS Access, SQL Server 2008, Oracle 10g, and OLAP tools from Financial Industries. Intensive used of SharePoint to share files within the company as well as out sources
• Managed Intensive data manipulation for analysis utilizing SQL/VBA script, macros, created complex queries to manipulate data and export analyzed data to Excel spreadsheet for final reports, and exporting data from Excel to Access Database, migration to MS-SQL Server 2008 for development life cycle including Store Procedures, view, DataETL process utilizing SSIS, SSAS, & SSRS tools.
• Managed development projects to assess Oracle database platform to ensure that met company requirements. Evaluated oracle database schema by testing conceptual, logical and physical data model structure utilizing Oracle SQL Developer Data Modeler, and then populated data model structure to create database architecture. MS Access database layout was migrated into Oracle10g database structure for testing.

Associate Manager, Marketing Analyst

Confidential, New York City, NY

• Multi-Source Business Intelligence/data warehouse application environment
• Managed & execute weekly, monthly and seasonal credit card/loyalty reporting and analysis to provide actionable insight to maximize sales
• Provided strategies during campaign planning stages, and sampling statistical analysis on business request; Customer’s sales behavior, all incremental (lift) sales as results of all DM/EM marketing campaigns offers on monthly basis.
• Responsible for bringing the right Marketing campaigns analytics and reporting tools on members & non-members across multiple channels. Developed and implemented campaign data flow processes, campaign tracking procedures, and results reporting applications.
• Assisted in development & implementation of the seasonal strategy for credit card acquisition & retention, as well as assisting on ad hoc analysis request from Marketing, Finance & Store Operations.
• Collaborated with campaign management team in developing campaign requirement specs, as well as analyzing and marketing the most highly successful multi-channel loyalty program.
• Performed Intensive data mining using RapidSQL, TOAD, Microstrategy, from Oracle 10g/MS-SQL Server 2005 database schemas architecture by writing complex queries/store procedure/Functions in (PL/SQL) and import/export capabilities for data reconciliation. Connect Tables to MS Access database utilizing pass-through query with ODBC connection. Extensive used of query analyzer and Crystal Reports.
• Managed development of front-end application (U.I) and back-end database (MS Access), logical and physical database structure layout, developed data modeling, tables, forms, queries, macros and VBA Modules for Business Analysis Reporting in a multi-user environment. Export data from Oracle10g/SQL Server 2000/Access databases to Excel for final presentation. Such Apps & automation process saving as much as 85% of the initial estimating time of completion.
• Evaluated and analyzed metrics on customer’s database with in-depth knowledge of all data elements including web traffics/trends.
• Created Ad-Hoc reports to identify strategic trends and actionable online customer’s insights based on business requirements such as retention, acquisition, identify RFM Scores across dual channel shoppers, profitability, etc.