SUMMARY:

• A senior IT Lead with over twenty five years of experience developing technical solutions for a variety of business applications. Understanding the needs for corporate objectives and growth. Building and developing the IT organization processes and procedures to support business needs. Ability to establish partnership with management team to align company information technology with strategic direction.
• Known for abilities in the areas of project leadership, business system analysis and design, facilitation, on - line processing, data architecture/modeling and data warehousing.
• Remote work experience.
• A catalyst for positive change with a proven ability to develop constructive relationships and teams with a broad and diverse group of cross-functional business partners, influence key internal/external stakeholders and establish a cooperative climate across multiple departments/divisions.
• Superior interpersonal, analytical, critical-thinking and problem-solving skills; proficient in French.
• Bus. Sys. Analysis/Design
• Data Architect/ Modeling/UML
• SQL
• Database Analysis/Design
• OLTP / OLAP / ETL
• Query / Reports
• Data-warehousing
• Normalized Schema
• Web / Data Analytics
• Business Intelligence
• Data Analysis
• STAR Schema
• GE Centricity EMR
• Data Transformation / Validation
• Data Governance
• People Skills / Team Player
• Leadership ability
• Coaching / Leading by example
• Motivation
• Setting Goals / Objective
• Problems solving
• Multitasking
• Work under pressure
• Conflict resolution
• Open door style
• Empowering People
• Meeting deadlines
• Planning / Organizational skills
• Communication / Listening skills
• Rapport establishing

PROFESSIONAL EXPERIENCE:

Senior Analyst/Dev - DB/DW/BI/ETL/Analytics

Confidential

Responsibilities:

• Conducted workshops with the users that resulted in the definition and the finalization of the statement of requirements for an analytic system to load data from the cloud (Teradata, Netezza, SAP/R3 and DB2) using Hadoop into OBIEE 11g and Cognos 10 BI datamarts for future query and reports. Represented a detailed project plan from the facts gathered that helped running the project smoothly to implementation within time and budget. Developed the Hadoop Clusters.
• Designed the Datamarts using STAR schema concept that helped loading and retrieving the data properly. Designed the OBIEE 11g RPD and the Cognos Cubes. Produced design documents and UML diagrams.
• Developed Stored Procedures/Functions using PL/SQL. Tuned Database and SQL following parsing guidelines.
• Involved in the RFP process. Performed GAP Analysis thru the Project phases. Produced detailed Designs documents. Designed the OBIEE and Cognos Queries and Reports. Supported team members thru SDLC phases. Kept management updated on issues and performance. Developed test schedules. Reviewed test plans. Tracked and documented the test plans and regression test results. Followed up on user acceptance testing and production migration following the releasing process standards and guideline.
• This initiative increased the quality and speed of decision making.
• Facilitated users workshops resulting in the statement of requirements for a Property and Casuality Analytics application.
• Designed SAS Data Sets using STAR schema concept that helped loading and retrieving the data properly. Developed Data Steps to populate Data Sets from DB2 and Oracle. Developed Proc Steps to produce stats and analysis.
• Produced ad - hoc reports using R, Python and Ruby.
• Major Health Provider Engagement
• Facilitated users workshops resulting in the statement of requirements for a Health Analytics application to bring data from DB2 using Hadoop for further query and analysis.
• Involved in the RFP process. Produced design documents. Followed up on testing till implementation following the releasing process standards. Performed GAP analysis. Supported team members thru SDLC phases.
• The delivery of a variety of OBI modules using OBIEE 11g on HP Unix and Reports that provided queries and reports for Health Analytics.
• The development of a variety of ETL and data conversion modules using Informatica and C/C++ that helped exchanging data accurately between GE Centricity EMR and other applications.
• The involvement in the Data Governance Process to ensure the reliability and quality of data.
• Major Franchise Company Engagement
• The emplementation of an OMS and Billing System, Order to Cash using Oracle Financials and C/C++ on top of UNIX that simplified orders handling.
• The delivery of an operational reporting module using OBIEE 11g on HP Unix that enhanced performance.
• The development of a variety of ETL and data conversion modules using Informatica and C/C++ that helped exchanging data accurately between applications.
• Large Retailer Engagement
• The release of a Cobol DW application and a set of C/C++ ETL modules to feed a Cognos Analytic for query and reporting that aided backups, data analysis, BI, query, reporting, stats and forecasting.
• Major Bank Engagement
• The development of a variety of ETL and data conversion modules using Informatica and C/C++ that helped exchanging data accurately between applications.
• Major Mutual Funds Company Engagement
• The offloading of statements printing module from the mainframe to the UNIX box that increased processing performance.

Confidential

Senior Analyst

Responsibilities:

• Developed an upload module to load new accounts and customer credit info to an Informix V.7.2 server running on AIX - UNIX using "C" that enabled collecting data from the internet effectively.
• Maintained and enhanced a reservation client/server C/AIX-UNIX application that enabled the users to run their daily business smoothly.
• Modified programs to interact with a newly developed internet reservation system as part of a team that upgraded the client/server application. This initiative allowed rail customers to reserve and buy tickets on-line.

Senior Analyst

Confidential

Responsibilities:

• Involved in the database architecture, process design and the development of an order management and billing system using Informatica, C/C++ with Oracle 8 running on UNIX. This enabled a Web - Store to establish a new business channel that resulted in significant increases in revenue and profit.
• The development of a Query and Reporting SAS and Cognos modules that enhanced operation performance.

Senior Analyst

Confidential

Responsibilities:

• Developed a code parser using "C" that enabled team members to scan source code for Y2K problems.
• Scanned Oracle Forms V.3 & V.4 source code using Microfocus Revolve, resulting in identifying Y2K anomalies effectively.
• Verified scan results and investigated problems thoroughly enabling the production of high quality change reports for Year 2000 compliance that helped the user to deal with Y2K properly.
• Renovated three of their application, written in PowerBuilder V.5 with the Oracle V.7 running on HP - UX V.10.20B, by applying manual logic correction that made the applications ready for Y2K testing.
• Conducted workshops with the users that resulted in the definition and the finalizing of the statement of requirements for a system to load drug wastage data from stores into a datamart RedBrick engine for future query and statistics.
• Represented a detailed project plan from the facts gathered that helped running the project smoothly to implementation within time and budget.
• Designed the conceptual datamart model using the STAR schema concept that helped loading and retrieving the data properly.
• Designed and developed the load process using Informatica, C/C++ and the reports and queries using SAS and Cognos that helped forecasting and reducing costs.

Senior Analyst

Confidential

Responsibilities:

• Prepared a proposal to off load data from the corporate warehouse to a datamart by performing workshops with the user that helped future planning of the project effectively.
• The development of Pricing modules using SAS and Cognos to produce queries and reports that resulting in a positive impact on setting a more competitive pricing strategy.
• Completed an ETL project for the Pricing Department on time and within budget, using stored procedures with Sybase S.10.01 engine running on SCO UNIX 3.2 to populate the SAS and Cognos Pricing Analysis modules.
• . Participated in the design and the development of stored procedures as the middle tier of a logstics billing system using object oriented methodology on Oracle V.7 database running on Windows NT that resulted in a reusable object modules that helped moving data smoothly between the user interface and the Oracle database.
• . Participated in the design and the development of a C/C++ library on top of OCI running on a Pyramid UNIX computer that helped developing a conversion module to populate an Oracle V.7 database with corporate data from a legacy mainframe ADABAS database. Created a C library using Oracle Dynamic SQL Method 4 that resulted in reusable functions that was used successfully by another development team.