Farooq Mohammad Email & Phone Number

London, ON, CA

Toronto, Ontario, Canada

Responsible to deliver a single enterprise-class technical solution for data integration, data quality, data profiling, preparing and data processing that allows Ontario Health, MOH and Long-Term Care (MOHLTC) to integrate, transform, improve, and deliver trusted data to critical business processes.Act as the overall SAP BI and data application’s subject.

Toronto, Canada Area

Responsible to deliver a single enterprise-class technical solution for data integration, data quality, data profiling, preparing and data processing that allows Ontario Health, MOH and Long-Term Care (MOHLTC) to integrate, transform, improve, and deliver trusted data to critical business processes.Act as the overall SAP BI and data application’s subject.

Performance and optimization for SAP BODS server architecture, sizing and ETL performance tuning.Tuning source databases, target databases, SAP BODS repositories, BODS Job server and ETL jobs to improve performance. After performance and optimization, the ETL jobs execution time reduced from 50 hours to 1 hour.

Toronto, Canada Area

• Responsibilities and Accomplishments:
• Integrating, designing, and building ETSs, data extracts, and assessment reports for the IAR.
• Ensuring stability, optimization, and performance improvements for ETSs and data extracts.
• Performing regular updates to the ETLs and data extracts that align to the Ontario’s healthcare assessment standards implemented in the IAR.
• Developing a reporting delivery mechanism that is scalable for distribution at the provincial HSP level.
• Assisting Health Information Network Providers (HINPs) in troubleshooting and resolving production-related issues.

Toronto, Canada Area

• Technologies:
• SAP Business Objects Data Services 3.2/4.1 (SAP BODS)
• SAP Business Objects Enterprise 3.1,/4.1 (SAP BOBJ)
• SAP BOBJ and SAP BODS Administration, installations, Upgrades and working with SAP support
• Data Services Management Console
• Central Configuration Manager, Central Management Console, BODS Management Console.

Canada

• Setup, configuration and best practices for:
• BusinessObjects Data Services (BODS) and ETL Architecture
• Multi-User Environment Setup
• Multi-User Development
• Development standards and governance methodology
• Application data ownership, Test strategy, Build book and security management

Data Migration legacy system to support transform business process for SAP programData migration, data cleansing and ETL (SAP BusinessObjects Data Services XI 3.2) from legacy systems into high-quality, business-ready ERP dataUtilizing SAP Data Services XI 3.2, SAP Best Practice for Data Migration - AIO Methodology, LSMW and Tools to analyze, profile and.

• Project Objectives: Project Hercules is a migration of the PCF MasterCard credit card platform from FDR to Total Systems (TSYS Credit Card Processing System). This migration involves the development of new interfaces.
• Leading team for requirement gathering, source definitions, target definitions, mappings, transformations and business rules for fifty interfaces (50 Interfaces).
• Responsible for technical lead, ETL Design, development, data migration, data mapping, data cleansing, data conversion, data archiving, testing, performance and query optimization.
• Transformation and Loading the data from different sources using SAP BusinessObjects Data Services XI 3.1. Created ETL jobs, Workflows, Datastores, Dataflows and different Transforms.
• Provided 24/7 support during deployment phase and post deployment phase.
• Training, walk through and knowledge transfer for Interfaces technical design, support process, deployment process and maintenance. Data Integration: Between PCB and TSYS (master card processing company), PCB and.

• Project Objectives: Create a standardized data repository that becomes the source data for Canadian Land reporting and querying. This along with the financial data in SAP will provide the business with the necessary.
• Move essential Land reports off i-Reporter to enable the termination of that product by year end (transform those reports that were adversely impacted by the SAP implementation to make them meaningful again)
• Make Land information meaningful, accessible and easy to use for the general user (well views, property ID views, etc.)
• Enable a link to our land mapping environment (ArcGIS) to allow them to launch Business Object reports for land and finance data
• Enable a link to the Financial SAP BW Reporting to launch existing reportsResponsibilities:Design development and deployment of Business Intelligence platform across BP environment for 500 users. Managing and directing.

-Architecture, design and maintaining large data warehouse environment-Architecture design and maintaining ETL jobs, scheduling ETL jobs, updating and managing ETL jobs-Design and maintaining BO Universe, WEBI and DESKI reports (right now I am managing 800 reports and 2,000 users in Aflac world wide head quarter)-Work extensively on data profiling.

Environment: Business Objects 6.2/6.5/ XI,, Business Objects Data Integrator XI 6.5(BODI), Web Intelligence 2.7.5, Broadcast Agent 2.7.5, and Publisher 5.6.2, Oracle 9i, SQL Server 2000/7.0, DB2, ERwin 4.1, Toad, Microsoft Visio 2003, Argent Scheduler, T-SQL, PL/SQL, SQL, Server 2000, UNIX

Environment: Business Objects XIR2, 6.5.1,Oracle 9i, SQL Server 2000/7.0, Data Transformation Services (DTS), ERwin 4.1, Toad Microsoft Visio 2003, Informatica 6.1/ 6.2, T-SQL, PL/SQL, SQL, ASP/ASP.NET, C#, Windows 2000, UNIX

• Duties and Responsibilities:
• Responsible for ETL process and Business Objects Reports. Responsible for design, development and maintain of existing data models using ErWin and Oracle Designer.
• Wrote ETL procedures and created mappings between Source and Target with Informatica Power Center and DTS (Data Transformation Services). Involved in full life cycle of Business Objects reporting Application.
• Environment: SQL Server 2000/7/6.5,DB2, Informatica, DTS (Data Transformation Services) Oracle 9i, Oracle Designer 2000, Business Objects 4.1/5.1.6, Web Intelligence 2.7, Supervisor, SQL Server 2000/7.0, ERwin.

Mba, Mba

Misca