SUMMARY:

• Results driven, hands - on technical leader with over 16 years of experience in the IT industry engaged in all Systems Development Life Cycle (SDLC) phases .
• 16 years of experience in designing, implementing Database and developing Applications (using SQL, T-SQL, Microsoft SQL Server, PL/SQL, Oracle tools, C#.NET, and VB.NET).
• Experienced in Extracting, transforming and Loading (ETL) Data using SSIS Packages.
• Experienced working with the Microsoft BI Stack (SQL Server Analysis Services, SSIS, SSRS...) to develop Business Intelligence applications.
• Over 5 Years of experience in Business System Analysis field at identifying, Analyzing and documenting Business System Requirements to suit the business needs of corporations.
• Design and Developing Reports using Crystal Reports and SQL Server Reporting Services (SSRS).
• Experienced in Developing Applications in SCRUM Methodology Environment.
• Experienced in Business Modeling using UML.
• Proficiency in using Microsoft Visio to develop Multi-dimensional and Relational Databases Models.
• Working knowledge of CA ERwin Data Modeler to design Data Marts and Relational Databases.
• Experienced in Designing, Developing and providing support for the effective implementation of Enterprise Applications software.
• Excellent skills in Designing and Developing applications using SQL, PL/SQL, Forms & Reports, Developer 2000, C/C++, C#. NET, HTML.
• Proficiency in understanding clients’ needs and generate, modify reports existing in Oracle Applications according to the requirements and specifications.
• Strong analytical and problem solving skills, excellent communication and presentation skills, and good team player.

TECHNICAL SKILLS:

Languages: Python, C, C#. NET, VBA, VB.NET, SQL, PL/SQL, T-SQL, UML

Database: Oracle 10g/ 9i/8.x/7.x, SQL Server 2005/2008/2012, MS ACCESS

BI Tools: Microsoft Business Intelligence Development Studio (SSAS, SSIS, SSRS ), Microsoft SharePoint 2007, IBM COGNOS Business Intelligence 10.1, Power BI.

GUI: Borland JBuilder 8 Enterprise, Forms 6i/9i/10g, Reports 6i/9i/10g, Crystal Reports XI, SQR V3-4

Modeling Tools: Rational Rose, TogetherSoft, CA Erwin Data Modeler, Microsoft Visio

Web Technologies: HTML, XML

Software: TOAD for Oracle, SQL developer, PeopleSoft V 8. * People Tools (Application Designer, Peoplecode, Application engine, Work Flow, etc), SQR, Crystal Reports, nvision

Operating Systems: Linux, Windows 95/98/XP, NT/2000/2003 Server & Professional

PROFESSIONAL EXPERIENCE:

Confidential

Data Warehouse Manager

Responsibilities:

• Designing, implementing and maintaining Enterprise Data Warehouse development environments and Data warehouse architecture/Data Mart systems.
• Lead and Manage Data Warehouse projects being implemented by outside Consultants.
• Lead and Manage the AZURE Data Warehouse Cloud Migration Project.
• Responsible for migrating Ratings Modules (T-SQL codes, DB Objects and Data) to AZURE SQL Data Warehouse Cloud Environment.
• Accountable for gathering Initial/Raw Nielsen and Rentrak (presently ComScore) Survey Data, Transforming/processing them into Program Average and Half Hour Summary TV Ratings Data and integrating those summary TV Ratings Data into the Enterprise Data Warehouse.
• Accountable for scaling the Enterprise Data Warehouse by continuously searching for new Data Sources/operational information from across the organization (and outside Vendors) in order to integrate them into the Enterprise Data Warehouse.

Confidential

Senior Consultant-Business Intelligence Architect/Developer

Environment: T-SQL, Microsoft SQL Server 2008 R2, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Excel Services, Microsoft SharePoint 2007, Visio 2007, CA ERwin Data Modeler and following Data Analysis and Visualization tools (Excel Power Pivot, Power Query and Power View) .

Responsibilities:

• Designing and Documenting the Multi-Dimensional Models for several FSIS-OCIO Discipline Metrics, such as Customer Satisfaction Metrics, Budget Metrics, Change Management Metrics, Telecommunication Metrics…
• Designing and implementing several Data Marts, with each related to a specific FSIS-OCIO Discipline Metric.
• Using SSAS (SQL Server Analysis Services) to design and implement Analysis Service Databases (OLAP Cubes) based on the developed Data Marts.
• Using SSIS to develop and automate the Strategies of Extracting, transforming and loading Data into the Data Marts.
• Deploying the developed SSIS Packages to SQL Server Environment (MSDB Database) and scheduling them in SQL Server Agent Jobs to run automatically on a weekly basis.
• Using Excel Power Pivot, Power Query and Power View to build Power Pivot Table Data Model, Power View Report for analysis and visualization of the OLAP Cubes Data.
• Configuring the SharePoint Portal by setting up Trusted Data connection for the connection files and Trusted File location for the Excel Workbooks to enable Data Rendering to SharePoint Excel Services.
• Updating the OCIO Dashboard Metrics by implementing/updating the included Excel Web Access Web Parts on SharePoint Portal to point to the Excel Workbooks located on the Trusted File Location folder.

Confidential

Senior Consultant - Sr. Data Warehouse Architect/Business Intelligence Developer

Environment: T-SQL, Microsoft SQL Server 2012, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Excel Power Pivot, Power Query, Power View, Excel Services, Visio 2010.

Responsibilities:

• Designing and Documenting the Multi-Dimensional Models for the Customer Calls Analysis, Outlets Data Mart solutions… based on the Gathered Business Requirements Document.
• Designing and Implementing set of Data Marts/ Data Warehouses.
• Working with SSAS (SQL Server Analysis Services) to design and implement Business Intelligence Solutions (OLAP Cubes) based on the developed Data Warehouses.
• Using SSIS to develop and automate the Strategies of Extracting, transforming and loading Data into the Data Warehouses.
• Using Excel Services, Excel Power Pivot, Power Query and Power View to build Power Pivot Table Data Model, Power View Report, SSRS to render the OLAP cubes Data.

Confidential

Senior Consultant - Sr. Business Intelligence Developer/Database Analyst

Working as a Senior Consultant on several IT development Projects at the clients Sites ( Confidential, Confidential ) and in-house.

Environment: T-SQL, Microsoft SQL Server 2008, SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SHAREPOINT, Excel Services, Excel Power Pivot, Power Query and Power View.

Responsibilities:

• Designing and Implementing Data Warehouses using SQL Server 2008.
• Working with SSAS (SQL Server Analysis Services) to design and implement Business Intelligence Solutions (OLAP Cubes migrated from COGNOS) based on the developed Data Warehouses.
• Using SSIS to standardize the Data that will be loaded into the Data Warehouses by extracting, transforming and loading the Data into Data Warehouses.
• Using Excel Services, Excel Power Pivot, Power Query and Power View to build Power Pivot Table Data Model, Power View Report, SSRS to render the OLAP cubes Data.
• Using SHAREPOINT to Publish the EXCEL cube Reports and/or SSRS cube Reports that have been developed.

Confidential

Software Development Engineer

Responsibilities:

• Design, Code, test and Debug custom queries using Microsoft T-SQL per defined technical specifications.
• Design, code, test and Debug business logic for Software applications using Microsoft T-SQL per defined technical specifications.
• Manage the extraction, transformation, and population of data files and Databases (MS SQL Server, Excel, Access) using SSIS;
• Working with SSAS (SQL Server Analysis Services) to develop BI Applications.
• Develop solutions to complex software design issues during the product development cycle, keeping in mind scope limitations and the impact of other integrated products.
• Act as technical lead of assigned projects with responsibility for both developing Data-driven solution in support of the project and ensuring that other team members associated with the project are developing products according to specifications.
• Design and Developing Reports using Crystal Reports.

Confidential

Consultant - Database Architect/Developer

Responsibilities:

• Created stored procedures to generate and insert Report ID in the Report table, aggregate data and upload them to URS database tables and testing of URS database implementation.
• Modeling the Relational Database of the Unified Reporting system.
• Key leader to develop the Entity-Relationship Diagram (ERD) with cardinality notation using Visio 2007.
• Converting the ERD into tables using “Standard notation format”.
• For each of the entities identified, designing tables and identifying the possible candidate keys, the primary key and probable foreign key.
• Based on the Database design, developing the URS Database Application using SQL Server 2005.
• Developed Triggers on the tables to track changes of the users on the Database.
• Created stored procedure to generate and insert Report ID in the Report table.
• Extracted, Transformed and loaded (ETL) Data from the legacy Access Database into the URS SQL server Database Application using SSIS Package.
• Worked with SSAS to translate the Data employed by NRI solution into Business Information.
• Key leader to develop various SSRS Reports used to make their Research products available to state policy makers and managers, who then use the research findings to implement more effective mental health programs and policies in their states.
• Developed Stored Procedures to aggregate Data and upload them to tables.

Environment: Microsoft SQL Server, Microsoft Business Intelligence studio, Microsoft Visio, C#, Microsoft SQL Server Reporting Services, Microsoft Access, VB.NET….

Confidential

Consultant - PeopleSoft Technical Developer

Responsibilities:

• Designing and developing/writing Specifications for various inbound /outbound interfaces with Peoplesoft.
• Creating the fields definitions
• Define the records
• From the records, building the tables definitions using Oracle RDBMS Database
• Using SQL for Programming purpose into Peoplecode
• Creating menus, pages and the components regrouping the pages
• Register the components into the portal.
• Performing PeopleSoft Enterprise Portals setup and providing Security.
• Using People Code, Application Engine programs, Component interface, Enterprise Portals for the Purpose of validating and implementing new Business requirements.
• Testing the application from PeopleSoft Enterprise Portal.
• Developing the test cases and documenting the test results after the Unit Level test. Running in trace, debugging the code and fixing errors.
• Creating the PS Queries, Crystal and SQR reports.
• Extensively involved in Go-Live move and Post-production support.

Environment: Windows XP, Windows NT, Oracle8i/ 9i, People Tools 8.4, Peoplesoft AP, AR, GL, HRMS, SQR, Crystal Reports, Nvision, XML, HTML, MS-Office, etc.

Confidential

Database Teaching Assistant

Main Subjects: ORACLE (SQL, PL/SQL, TOAD for Oracle, Developer 2000, Forms 6i/9i/10g, Reports 6i/9i/10g), MS ACCESS

Responsibilities:

• Using Oracle SQL, PL/SQL, Oracle Forms and Oracle Reports to practice, with the students, RDBMS (Database) theory they learned.
• Modeling relational database.
• Teaching how to create a Database using Oracle SQL PLUS, Oracle RDBMS.
• Teaching how to create triggers, cursors, stored procedures…
• Using Oracle Forms/Oracle reports to help them build Applications (Front end) supported by the Oracle Database created and the other objects (Triggers, Cursors, procedures…).

Confidential

Programmer Analyst - Oracle Developer

Responsibilities:

• Wrote the specifications and requirements document of the system.
• Using UML to develop the Business Model.
• Implemented the Database of the system using SQL PLUS.
• Developed and optimized different SQL queries to insure faster response time.
• Designed and developed various forms using Oracle Forms 6/6i and Designer/2000/6i
• Designed, developed reports using Reports 6i.
• Participated to the design and development of the packages, procedures, functions and triggers using PL/SQL.
• Wrote the user’ guide of the system.

Environment: Oracle Database 7.x/8i/10g, Forms6/6i, Report6/i, Designer/2000, PL/SQL, SQL, UML