SUMMARY:

• Confidential has a 12 - year experience in business intelligence and data engineering to improve performance of companies. 2 types of roles:
• Technology: BI Developer / Architect / Data Engineer, Confidential designs solutions to make companies data driven, such as data warehouses from scratch, reporting, data transfers:
• ETL Informatica (Power Center, Power Exchange, Cloud), SSIS, IBM Cast Iron, Ab Initio Data Modeling with Power Designer, Erwin, SQL Data Visualization / Dashboard / Reporting with SAP Business Objects (Webi, Designer, IDT, Xcelsius), Tableau, SSRS, PowerBI Scripting to automate processes, handle data from non DB sources (emails, external sources, web sites): batch, PowerShell, python Delivered a dashboard framework: to let management communicate objectives, leverage revenue/cost drivers, navigate interactively, answer business questions rather than displaying data, break silos between teams Architected and developed data integration to start a line of business with customers
• Analytics: Business Intelligence Engineer, Confidential worked in finance and business departments, on financials and analytics using his technical skillset (mix of Data Scientist, Statistician, Data Management, Reporting):
• Joined the Finance department of ING Direct (Bank) (2 years), finance control for insurance (1 year), retail (1 year). He took care of sensitive topics for management: profitability, forecast, revenue, marketing campaign efficiency and customer recruitment. Examples: profit warning, preparation of the sales forecast, gross margin and estimated profit per product He studied business processes, defined KPIs, designed dashboard to monitor them, escalated risks, suggested action plans to meet objectives. He achieved fact based analysis to identify opportunities for improvement (product profitability, multichannel sales, risk), customer segmentation, predictive analytics (machine learning in Confidential for customers recruitment, Python for origin and fraud detection)

PROFESSIONAL EXPERIENCE:

Confidential, Miami, Florida

SQL-SSIS-SSRS-Forecast

Responsibilities:

• Work in a business team, to provide operational and financial figures to handle their activity Design an end to end solution to forecast and report sales (volume, currency), profit. It includes the data flows, data profiling, data discovery, ETL, data modeling, reporting, to enhance the production of the forecast, the automation of reports for the division and the company’s customers. It includes algorithm for massaging data at different granularity levels, an integration with a
• GUI for data entry. Stakeholders: division president, financial controller, suppliers of the company Data sources and DB: flat files, SQL Server Skill: SSIS ETL (SQL Server Integration Services), SSRS for reporting (SQL Server Reporting Services), Tableau, Business Objects, T-SQL/SQL stored procedures

Confidential, Miami, Florida

ETL lead and reporting technical lead

Responsibilities:

• ETL Solution Specialist (3 months), ETL Lead and Reporting Technical lead for production support and enhancement (21 months, 4 resources), ETL Lead (4 months, 20 resources including offshore) Built solutions with subject matter experts, sales analysts, financial controllers, developers to make the company data driven: “what you can measure, you can change” Achieved projects to analyze financials, gross margin per products, planning revenue, monitor processes for home building. Includes defining metrics, scope of products, geographic area, data cleansing, loading, reporting Documented business processes, source data models and existing flows Structured the ETL team to get requirement, system analysis, design, code, reviews, testing, deployment plan Re-engineered legacy data loads: standardized sources, targets, mapping, sessions, workflows, Change Data Capture (MD5 and Power Exchange), system accesses. Outcome: reduced jobs duration, maintenance timeframe, stopped recurring failures during maintenances, pollution of production data, time out, deadlocks. Enhanced recovery, stabilized end-of-life environment, Designed IT processes. Ex: deployment. Outcome: during the first 2 months, up to 4 failures per deployment. After: only 2 failures in the last 2 years Split the
• ETL team into Development and production support, along with the new IT strategy Implemented new EDW (staging, 3rd normal form, datamarts) Administrated Informatica Cloud and PowerCenter, user rights policy, managed licenses Data sources: DB2400 iSeries JDE, Cloud (Oracle CRM On Demand, Salesforce), SQL Server, MySQL, Oracle, Excel, flat files, emails, social medias, leads, internet traffic Skill: Informatica PowerCenter Designer, Workflow Manager, Workflow Monitor, Repository Manager, Power Exchange, Informatica Cloud, reporting, data architecture, architecture, modeling, T-SQL/SQL stored procedures, SSRS, PowerBI, PowerPivot, Powershell - batch - python scripts

Confidential, Miami, FL

Big Data and machine learning

Responsibilities:

• Hadoop Cloudera distribution, big data, project to setup an environment, and a proof of concept including Hive, Impala, Sqoop for learning purpose. Machine learning experience with Scikit / SKLearn in Python. Pandas, Numpy, SK Learn. Examples: Predictive modeling for origin identification and fraud detection (example: water, whisky) based on its characteristics.

Confidential, Miami, Florida

Business Intelligence Data Architect

Responsibilities:

• Build data warehouse from scratch, define architecture, with source, data acquisition, ETL standards (Extract Transform Load) and best practices, set up and train the team on ETL IBM Cast Iron and data warehouse methodology Build and validate infrastructure with Technical architects in terms of server needs, development framework and VM Validating proof of concept with selected tools by former team, including performances, technical capabilities Data loading using a mix of IBM Netezza nzload, IBM Cast Iron 7, Data modelling with IBM Infosphere for Data Architect, reporting prototype using IBM Cognos 10.2.1, development Working with Business requirements in terms of scope, data requirements, prioritization of subject areas

Confidential, Miami, Florida

Business Intelligence Developer

Responsibilities:

• Participated to reports conversion from SSRS to Business Objects 4.1 Evangelization of Business Objects 4.1, created document for business users to use Webi Dashboard for cruiseline repairs over the world, with maps, drill down in Tableau. Interactive data visualization. Prototype in R for linear regression about repairs Creation and demonstration of BO Explorer Infospaces, Creation and modification of universes (UNX) with Information Design Tool, about travels, purchases, New report designs, modifications, provided new KPIs for the business Launched and developed BO Audit reports, to follow up users, report performance, to support proactively business users when errors happen. Technical skills: SAP Business Objects 4.1 (Web Intelligence, IDT, Designer), R, Tableau, SSRS, SSIS, SQL Server

Confidential, Miami, Florida

Sr. Business Intelligence Programmer Analyst and Team Lead

Responsibilities:

• Team lead on reporting and dashboarding (5 people) Participated or led projects with reports Business Objects, dashboards Xcelsius and ETL Informatica loading. Mentored and leveraged people with technical skills and methodology, standardization of methods Follow-up on move to production and releases, incidents. Provided dashboard methodology focused on business mission goals, objectives. Agile life-cycle methodology to follow performance, enhance reactivity, exceptions to trigger actions. Including interactions, drill, web services use. 10 releases delivered on-time with weekly follow-up to management, on project plan, workload, reviews, alerts Report performances methodology. Defined and leaded the project to improve performances for queries getting DB administrator, ETL, help desk, reporting team involved (query/database tuning, indexes, re-design, aggregate awareness, drill through). Revenue increase and cost reduction
• Analytical study on ancillary services to improve revenues, reduce cost by increase automation of packages Follow-up on new solutions involving e-reputation, semantic analytics, predictive analytics with KXEN, keep team updated with new products or versions (Qlikview, Tableau, SQL Server, Talend, Exadata). Technical skills: Informatica 9.1, SAP Business Objects XI R4.0 and XIR3.1, Web Intelligence, Dashboard Design (Xcelsius), Info Design Tool, QAAWS / BI Web service, SQL Server, Tableau, Oracle 11g, Teradata, Excel, SQL. Studied mobile implementation, access rights with CMC, CCM

Confidential, Miami, Florida

Sr. Business Intelligence Analyst

Responsibilities:

• Participated to analyze trends, sales and stock price for the company, manufacture quality issues Analyzed the processes of the company (wholesales, retail sales, EDI, product quality, factory audit, purchase, sales, pick slip, receipt, invoice/revenues), document, see the potential to provide a dashboard to business teams (Ex: operational dashboard to prevent sales on low margin orders, improve revenue on EDI sales) ** Key player in Executive requests, to provide a single version of truth for political topics and highest complexity topics ** Suggested and implemented new architecture of interactive dashboards (drill across, drilldown) to support company decisions Improved performances for queries (query/database tuning, re-design) and report conversion Proposed dashboard methodology including life cycle, constraints, pros and cons, and workload depending on the complexity Actively worked with the data scientist manager to provide commercial analytics (from people in store down to retail sales, with axis to analyze and massage).
• It includes the acquisition of the data and the analytical process, suggestion to improve the sales. Achieved data visualization reports to support Business Analysts, forecasters, Data Scientist Benchmark of reporting tools for new generation of dashboards He studied implementation of mobile BI with Explorer for iPad and iPhone, Webi, Dashboard Design (Xcelsius) Technical skills: Business Objects XI R4.0 and XI R3.1, Web Intelligence, Dashboard Design (Xcelsius), BO Explorer, Live Office, Info Designer Tool, QAAWS / BI Web service, SQL Server 2008, Oracle 11g, Netezza, Excel, SQL

Confidential, Hospital Miami, Florida

Data Architect

Responsibilities:

• Defined scoping methodology, proposed data strategy to get the core scope of the EDW Recruitment of business analysts and system analysts for the team Assessed workload and risk by source and area, macro-mapping, data model across facts/dimensions achieved (Kimball) Definition of the subject areas with consulting company, validation of the new requirement assessment, data model Selected ETL through benchmark (Business Objects data services, IBM Datastage, Informatica, SSIS) Team leader for data source analysis, with 1 collaborator, and IT vendors Technical skills: SQL Server 2008, SSIS, Oracle 11g, DB2, Sybase, Toad, Excel, SQL, Erwin

Confidential

Business Intelligence Analyst

Responsibilities:

• Managed business data requirements with IT team, rolled out information to the MIS and BI team, for his department including a mix of analysts, data scientists, financial analysts, Asset manager. Designed reporting with departments available to 400 users (activity monitoring and dashboards) for business and finance department to follow-up activity Identify the processes in the company (steps, point of measures, involved teams, levers, document through charts) for customer recruitment, risk, operations to help monitoring the improvement of performance. Defined the sales analysis, to monitor performance through several channels in competition (Internet, Inbound Call center, Outbound Call center, Marketing events, web site banners, internal or external emailing campaigns) Achieved, follow-up and reviewed over 15 marketing campaigns Participated to launch of new product, supported marketing team with key figures
• Performed statistical analysis on key issues: accounts, sales, sales representative incentives, churn, cards use, profitability, risk including non-performing loans, direct banking, clients profile and conversion, bias identification, original channel of the customer. Test of significance with P-values to confirm Hypothesis 0. He prepared the datasets for machine learning (with KXEN) to use algorithms (mainly multiple variable regressions, neuron network). He used it then for predictive analytics (anticipate growth of customers based on their prospect profiles, provide estimate of campaign returns) He worked on the acquisition of new data to improve customer recruitment and profitability Proposed a strategy to integrate ERP data into the EDW: Audited data management of financial analysts and systems (peoplesoft), studied issues on their reporting to assess and propose the project launch of cost assessment per department Technical skills: Business Objects XI R3 (Desktop Intelligence + Designer), Informatica 8.6, DB Oracle 10g, SQL Toad, advanced adhoc SQL queries, SAS Infomap Studio, campaigns on Epiphany Inbound and outbound, Excel. Queries and database optimization

Confidential

IT and Business Analyst

Responsibilities:

• European leader in consulting / technology, former Confidential & Confidential consulting branch. Branch specialized in industry and retail.

Confidential

Senior Business Analyst, Project Manager, Team Leader

Responsibilities:

• Defined the scope of business, proposed/designed the general solution, including workload, full planning, team proposal, following Confidential standard assessment and methodology Team leader: responsible to manage work and collaborator Defined the strategy for building the EDW with existing system and inherit work previously done. Assessed existing systems, and performed the gap analysis to get the highest industry standards (ODS, EDW, datamart, reporting, ETL, reporting, security issues) Designed and implemented a prototype with Datastage, including change data capture (CDC) and Business objects and including drill down functions. VBA for custom files conversions and extractions. Implemented the BO part, and managed 1 datastage consultant during presales to implement the mockup Technical skills: Business objects XI R2 (Infoview webi + Designer), DB IBM DB2, SQL, Excel VBA

Confidential

Business Analyst & Project Manager

Responsibilities:

• In strong competitive market and crisis context, business analysis for the management control, actuarial, sales services to enhance life insurance activity follow-up. Acted as Management controller. Define the requirement to Data warehouse team to launch revenue growth projects, analyze operational processes. Resumed ongoing projects, and launched new projects (requirements, planning & budget follow-up, testing and supervision) Audited current system and reporting practices to bring more efficient way to work for reporting teams Drove Steering committee to help taking directions and propose strategy to include consistently new data from new OLTP Designed reports (BO XI R2) on premiums, surrender, management fees, by distribution network, products Rolled out the projects and trained up to 20 users. Transferred skill Managed and transferred responsibilities to 2 people Technical skills: Business Objects XI R2, SQL queries, resolve performances issues

Confidential

Business Intelligence Consultant

Responsibilities:

Responsibilities:

• Gathered business requirements to build monitoring system and EDW for pharmaceutical labs. Scoped data warehouse, defined the first phase. Technical skills: SSIS (SQL Server Integration Services) SSRS (SQL Server Reporting Services).

Confidential

Business Intelligence Consultant

Responsibilities:

• In order to monitor the performance of its new EMEA sales model, BMS wants to follow-up KPIs (sales, market share, SF monitoring, visit frequency and coverage, P&L, BCG matrix) through a cross-country data warehouse. English environment (English, Spanish, German, Indian, Egyptian…). Includes offshore. Team lead in Confidential . Team coordinator with data provider teams, during integration, UAT tests to achieve 3 successful rollouts, covering 12 countries. Support Sales analysis on leads, sales-in, sales-out, financial results. Designed project, specified technical components, assigned project tasks to team and follow-up (3 members) for planning, workload, pending work assessment. Includes technical supervision, mentoring, technical and business . Gathered business requirements, defined and harmonized business rules across countries with heterogeneous data sources Designed the general solution, architecture, through a new
• Data Warehouse from Scratch, brought industry standards for ETL (error handling, recycling, audit trail, scheduling, data reconciliation, data integration) and Ralph Kimball methodology, data modeling and reporting solutions, datawarehouse star schema and ODS data model, implemented mappings, universes, reports. Defined strategy for integration/harmonization of 12 different countries with heterogeneous systems, and provide data to external vendors. Technical skills: ETL Informatica 7.1, Business Objects XIR3 deski/webi/designer, Oracle 10g, SQL, Stored procedures, indexes, Toad, KS script, Excel VBA

Confidential

BI Consultant - UAT Team Leader

Responsibilities:

• User Acceptance Tests team leader (responsible for 2 collaborators) and business requirement specification at EDF B2B market: defined campaign automation for small bills consumers and Data warehouse enrichment.

Confidential

Business Intelligence Consultant

Responsibilities:

• Consulting / technology European leader. Former Confidential & Confidential consulting. Branch specialized on very large databases.

Confidential

BI consultant on Video on Demand project

Responsibilities:

• Participated in designing the star schema for a prototype Implemented the mappings on ETL Ab initio and scripts

Confidential

BI consultant

Responsibilities:

• Project to consolidate financial data from all the subsidiaries Designed and implemented mapping using ETL Ab Initio to gather the data. Global group to gather heterogeneous data sources from 47 subsidies, 15 terabytes, team > 100 peopl