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 matter expert; provided for SAP Data Services (SAP BODS), SAP Business Objects Enterprise (SAP BOBJ), ETL architecture, SAP BI architecture, sizing, long term stability, end-to-end implementation, ETL disaster management, future initiatives, developments, enhancements supported by the business intelligence and data warehouse.Responsible for installations, upgrades, fixes and patching activities for SAP Data Services (SAP BODS), SAP Business Objects BI Platform 4x (SAP BOBJ), SAP Crystal Reports to ensure ongoing security, stability and data privacy (PHI) of the reporting system.Technologies:SAP Business Objects Data Services 3.2/4.2/4.3 (SAP BODS)SAP Business Objects Enterprise 3.1/4.1/4.2/4.3 (SAP BOBJ) (BI Launch pad, Universe design and Publications).SAP BOBJ and SAP BODS Administration, installations, Upgrades and working with SAP supportSAP Crystal Reports and Microsoft Power BI Oracle 19c,XML, Java Script, Linux and SOAP, HL7, FHIR (Fast Healthcare Interoperability Resources), EMPI/MDM. SQL, PL-SQL, FOP files for PDF printing; XML, user interface, HL7 FHIR protocol.EDR (Electronic Data Repository), FHIR (Fast Healthcare Interoperability Resources)

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 matter expert; provided for SAP Data Services (SAP BODS), SAP Business Objects Enterprise (SAP BOBJ), ETL architecture, SAP BI architecture, sizing, long term stability, end-to-end implementation, ETL disaster management, future initiatives, developments, enhancements supported by the business intelligence and data warehouse.Responsible for installations, upgrades, fixes and patching activities for SAP Data Services (SAP BODS), SAP Business Intelligence Platform 4x (SAP BOBJ), Crystal Reports to ensure ongoing security, stability and data privacy (PHI) of the reporting system.The ETL and reporting data have been extracted and loaded by applying Ontario healthcare industry’s standards for data security and privacy method.Technologies:SAP Business Objects Data Services 4.3 (SAP BODS)Azure Databricks, Azure Data Lake, Azure Data Factory, Azure data servicesSAP Business Objects Enterprise 4.3 (SAP BOBJ) (BI Launch pad, Universe design and Publications).Administration, installation and Upgrades.SAP Crystal Reports and Microsoft Power BIOracle 19c,XML, Java Script, Linux and SOAP, HL7, FHIR (Fast Healthcare Interoperability Resources), EMPI/MDM. SQL, PL-SQL, FOP files for PDF printing; XML, user interface, HL7 FHIR protocol.Health information custodians (HICs), EDR (Electronic Data Repository)Personal Health Information Protection Act (PHIPA)Personal Health Information (PHI), Electronic Medical Records (EMRs), Hospital Information Systems (HISs)Clinical Assessment tools, Ontario Healthcare Reporting Standards (OHRS), CDR (Central Data Repository)FHIR (Fast Healthcare Interoperability Resources)

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.• Leading the development of ETL reports and data extracting methods using healthcare industry’s best practices.• Performing regular data transfer process for standardized health assessments.• Providing after-hours support and implementations, as required.• Managing and maintaining all documentation related to the design, build, and maintenance of ETL environments.Technologies:• SAP Business Objects Data Services 3.2/4.1 (SAP BODS) • SAP Business Objects Enterprise 3.1,/4.1 (SAP BOBJ) (Infoview, Universe design and Publications)• 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.

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• Datastore and System Configurations• Central Repository Security• Data migration strategies

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 report on Strategy and Approach for migrating data.

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 between TSYS and other PCB systems and 3rd party vendors. This project provides increase protection against counterfeit and lost and stolen card fraud by validating the card and the cardholder. Responsibilities:• 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 third-party vendors.Different interface patterns: Transform file (file to file), Transform Datastore (file to database), Transform Database (database to file), Database to database. Source types: Database, Copybook, Teradata, IDOC, EBCEDIC, Flat files, fixed length files, variable block files (based on TSYS and 3rd party vendors format)Third parties & vendors: Master Card, TSYS, ACE, Scores SCI (Delinquency, BNI, Credit Bureau), MAGTEK, Balxfer, MC COLLECTION, Tel Pay payment, EDI Payments.Technologies: SAP BusinessObjects Data Services XI 3.1, Oracle 11g, Toad, Autosys, MIM, WIN CVS, ER Win, DB2, Microsoft Visio, Unix, AIX, Perl scripts, GPGFile sizes: 50KB to 100GB

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 data to efficiently manage Land and Financial processes. (e.g. Ownership, Billing, invoicing, dispute resolution, contracts, wells, partner interests, etc).• 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 10 member of team. Coordinating and managing different groups to achieve business goals and objectives. Managing resources and designing road map for all stages on project life cycle.Business Objects CMC,Business Objects XIR2 ImplementationBusiness Objects XIR2 Security implementationBusiness Objects XIR2 Info ViewBusiness Objects XIR2 Web IntelligenceBusiness Objects Dashboard Manager, Business Objects Performance Manager,Business Objects XIR2 – DesignerSAP BusinessObjects Data ServicesMigration to XI 3.0, Creating Business Objects environment for SAP and BW sources (Continue……..)

-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, generating queries for "proof of data validation for reports" to solve data quality issues.-Design and implement reporting and analytical solutions to business-Proven experience with Business Objects Universe design & development, reports development using WebI, DESKI and ad-hoc reporting.-Manage the ETL functionality of multiple Data Warehousing projects from conception to implementation-Oversee the development of logical and physical data models, ETL scripts, metadata definitions and models, queries and reports, schedules, work processes, and maintenance procedures

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, Business Objects, PL/SQL, T-SQL, Java, Javascript, Microsoft SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), HTML, Cascading Style sheets, FOP files for PDF printing; XML, XSLT, XSL-FO, Mainframe, SQL, Apache, IIS 4.0, Netscape Enterprise server, Solaris, Unix, Windows 2000, Windows NT and Win98/95. Involved in, design, development and implementation of Hospital Management Project.Environment: Visual Basic 5.0, Reports 1.1, Menus 5.0, PL/SQL, Oracle 6.0.

Mba, Mba

Misca