Data Warehousing Financial Services

Syed Ibrahim

+1-306-***-**** *********@*******.*** ON Canada

https://www.linkedin.com/in/syed-ibrahim-abdul-muthalif-mca-pmp-itil-24bba031/

Profile Summary:

Accomplished IT professional with over 18 years of experience in analysis, design, implementation, testing, and support across Data Warehousing, Oracle Developer Suite, OLAP applications, ETL tools, and Cloud technologies. Expertise in handling complex technical challenges and delivering scalable solutions for diverse business needs.

Core competencies include:

Data Warehousing & OFSAA: Significant experience implementing Oracle Financial Services Analytical Applications (OFSAA) FCCM suite of applications and AML solution (formerly Mantas), Oracle Enterprise Case Management (ECM), Know Your Customer (KYC), Compliance studio and other modules (FTP and Profitability).

ETL & Data Integration: Expertise in Informatica, IBM DataStage, Python scripting, and Unix/Linux, with strong skills in processing XML, JSON, and flat files. Solid experience in creating mappings and transformations to support ETL processes.

Oracle Cloud Financials and EPM: Extensive expertise in Oracle Cloud Financials, EPBCS (Enterprise Planning and Budgeting Cloud Service), PCMCS (Profitability and Cost Management Cloud Service)

Data Modeling: In-depth understanding of Fact/Dimension tables, Star schemas, dimensions, hierarchies, and attributes to support OFSAA FSDM – AML, FTP and PFT.

Cloud Technologies: Strong grasp of AWS infrastructure, including EC2, S3, and DynamoDB, with best practice implementations to optimize scalability and performance.

Leadership & Collaboration: Proven ability to collaborate with clients on Agile project deliveries, create mapping documents, and lead teams in resolving support tickets within SLA. Exceptional problem-solving and analytical skills, complemented by excellent interpersonal and communication abilities.

Recognized as a quick learner and highly motivated professional, with a results-driven approach and a passion for delivering high-quality solutions in fast-paced environments.

Educational Qualification

Master’s in computer applications (MCA), May 2002

Bachelor of Science (B.Sc.) in Computer Science, April 1998

Professional Certification/Training

Project Management Professional (PMP®) – PMP Number: 2876725

ITIL Foundation Certificate in IT Service Management

IBM CLP (Certified Lotus Professional) – Domino Designer & Server 5

Microsoft Certified Professional (MCP) – Visual Basic Application Design

Technical Expertise

Programming Languages: Java, J2EE, C, C++, XML, SQL, PL/SQL, VB, Unix Shell Script, JavaScript, Servlets, JSP.

OFSAAI Framework: OFSAA 8.0.8 – Oracle AML(Mantas), KYC, TM, CRR, ECM, FTP and PFT.

Data Warehousing Tools: Informatica PowerCenter 10.2, IBM DataStage, Business Objects, OBIEE, and Tableau.

Development Tools: ServiceNow, CI/CD tools (GitHub, uDeploy, Jenkins, Artifactory), CA7, AutoSys, PL/SQL Developer, Eclipse, WinSCP, Cloud JIRA, ETL, JAMS, Oracle Identity Management.

Application & Cloud Technologies: Oracle ERP/EPM Cloud, Oracle Financials, Oracle EPBCS/PCMCS, AWS, BEA WebLogic, IBM WebSphere, JBoss, Apache Tomcat.

Databases: Oracle 12c, MySQL, MS SQL Server and Sybase.

Professional Experience

Client: Scotia Bank, Toronto, ON. Consultancy: Tech Mahindra Jun 2022 – Present

Sr Oracle OFSAA Consultant

Project: OFSAA – FCCM (ECM/AML)

Responsibilities:

Handling implementation and optimization of Oracle OFSAA products, with a focus on Financial Crime and Compliance Management (FCCM), including AML, Sanctions, and KYC solutions.

Managed end-to-end implementations and upgrades of Oracle Financial Services Analytical Applications (OFSAA), driving seamless transitions from legacy to modern versions.

Hands-on experience working with AML Transaction Monitoring Systems using Oracle Mantas, ensuring compliance with regulatory standards.

Involved in the design of AML detection scenarios to produce effective alerts for applying various thresholds.

Developed and fine-tuned AML behavior detection scenarios by leveraging deep expertise in Mantas Risk calculations and post-processing logic to enhance alert accuracy, modifying batch processing jobs from KYC, TM, CRR including ECM case generation.

Extensive experience in PL/SQL and Oracle Stored Procedures, optimizing database performance and ensuring efficient query execution.

Strong understanding of the Oracle Mantas data model and schema, enabling effective troubleshooting and issue resolution for batch processing.

Led requirements analysis, system configuration, and end-to-end testing to validate compliance workflows and risk models and ensure smooth daily/monthly batch processing.

Conducted advanced data analysis, leveraging structured and unstructured data to drive predictive analytics and risk assessment to evaluate the customer’s rating.

Designed and implemented UNIX shell scripts for automated file validation and job scheduling, improving system efficiency using ICC server logs, batch maintenance, SMS and other OFSAA modules.

Optimized SQL queries using performance tuning techniques such as SQL trace, Explain Plan, TKPROF, indexing, and partitioning to enhance database efficiency.

Environment: OFSAA – AML (Mantas), FCCM suite of applications, ECM, CRR, TM, BDF, KYC, Oracle PL/SQL, JIRA, Confluence, ServiceNow, Unix Shell scripting.

Client: CPP Investment Board, Toronto, ON. Consultancy: Luxoft Jun 2021 – Jun 2022

Sr Oracle EPM Consultant

Project: Oracle ERP/EPM Consultant

Responsibilities:

Develop and customize EPM applications to meet business requirements.

Design and implement data integration processes, including mappings and transformations.

Create and maintain calculations, business rules, and workflows within EPM applications.

Build and maintain reports, dashboards, and analytics using EPM reporting tools.

Conduct unit testing and assist in system testing efforts.

Collaborate with functional teams to ensure data accuracy and integrity.

Manage JAMS scheduled jobs for GL transformation and Oracle ERP integration.

Integrate EPM General Ledger application with other systems, ensuring smooth data flow/mapping via APIs.

Worked on integration capturing activity time of booking, HR solution with OFSC.

Wrote Python scripts for financial data manipulation, including validation, cleansing and reporting within the EPM General Ledger.

Perform upgrade testing, FX rate data population, and integration testing with Oracle Financials, coordinating with vendors for seamless sign-off.

Extract financial data from EPBCS/PCMCS to Amazon S3 and automate the movement of data using AWS.

Use AWS Glue for ETL operations to prepare data for analytics.

Trigger AWS Lambda functions for additional data processing and calculations.

Load transformed data into Amazon Redshift for efficient storage and high-performance analytics.

Write UNIX shell scripts for file validation and scheduling daily/month-end jobs.

Query data directly in Amazon S3 using Amazon Athena for SQL-based analysis.

Enable AWS CloudTrail and AWS Config for monitoring and auditing integration activities, ensuring compliance and governance.

Environment: Oracle Financials 23B, Oracle EPM (EPBCS, PCMCS), Oracle PL/SQL, ETL – DataStage, CI/CD pipelines using Jenkins, GitHub, Python, AWS, JAMS scheduler, Cloud JIRA, Confluence, ServiceNow, Shell scripting.

Client: SGI - Saskatchewan Government Insurance, Regina, SK. Consultancy: ISG Jan 2021 – Jun 2021

Sr. Oracle/Java Developer

Project: Insurance Legacy Migration

Responsibilities:

Developed and customized the General Insurance System (GIS) encompassing Policy Center, Billing, and Claims modules using PowerBuilder, Java, and Sybase/Oracle databases.

Designed and implemented data integration processes using IBM DataStage for ETL tasks, ensuring seamless data flow between systems.

Worked with Guidewire tools to implement and enhance insurance processes in PolicyCenter, BillingCenter, and ClaimCenter.

Developed and maintained stored procedures, functions, and triggers for Sybase and Oracle databases to support GIS applications.

Integrated GIS systems with external systems, ensuring accurate data synchronization and communication between platforms.

Collaborated with business analysts and project teams to gather requirements, design solutions, and deliver high-quality, scalable applications.

Performed data migration tasks, ensuring accurate transfer of policy, billing, and claims data from legacy systems to new platforms.

Conducted unit and system testing, debugging, and troubleshooting to ensure application functionality and data integrity.

Optimized application performance and database queries to improve overall system efficiency.

Provided support for production environments, including monitoring, issue resolution, and system updates.

Environment: Java, Oracle Weblogic, log4j 1.4, Guidewire, Gosu Scripting, IBM InfoSphere DataStage 11.3, Unix, Oracle PL/SQL, Sybase, PowerBuilder 2019, Service Now, JIRA, uDeploy, GitHub

Client: Wells Fargo, Charlotte, NC. Consultancy: Cognizant Technology Dec 2019 – Jan 2021

Senior OFSAA Technical Consultant

Project: e-FTP Migration

Responsibilities:

Designed and created Oracle database objects, including tables, packages, procedures, functions, triggers, views, and materialized views.

Utilized Toad for executing SQL scripts and optimizing SQL performance.

Automated job scheduling using AutoSys to streamline and manage recurring tasks.

Implemented projects using Agile methodology, leveraging Scrum tools to manage development activities.

Developed and configured OFSAA batches, designed data transformations, and implemented FTP methodology for process automation.

Performed root cause analysis and resolved issues encountered by business users within the OFSAA environment.

Collaborated with business analysts and stakeholders to gather functional requirements and translate them into technical specifications.

Managed tasks and subtasks in JIRA and tracked bugs and issues following Agile best practices.

Created dynamic SQL queries to generate end-user database views based on metadata from upstream systems.

Used Informatica PowerCenter 10.2 for ETL processes, developing complex mappings to load data from multiple source systems into the data warehouse.

Analyzed SQL query performance, advising DBAs on indexing, schema optimization, partitioning, and using Explain Plan for improvements.

Developed Shell scripts to monitor OFSAA batch processes and job execution times, generating alerts for abnormal situations.

Wrote Python scripts to automate domain and adapter resource creation, integrating with CI/CD processes using Jenkins for continuous build and deployment.

Developed Python scripts to monitor Transfer Pricing (TP) logs from the OFSAA application, aiding in quick issue debugging.

Contributed to application migration and supported Business Continuity Planning (BCP) activities to ensure system resilience.

Environment: OFSAAI 8.0.7 0 Funds Transfer Pricing, Informatica 10.2, Erwin DM, Oracle WebLogic, Unix Shell scripting, TOAD, Oracle 19c, PL/SQL, OBIEE, AutoSys, JIRA and SQL Server.

PNC Financial Services Group Inc, Cleveland, OH May 2018 – Dec 2019

Senior Software Developer

Project: OFSAA FTP & Profitability Management

PNC utilizes OFSAA to calculate the internal line of business profitability. It uses two modules to assign cost or benefits of the funds and profitability management to perform cost and other allocations to businesses.

Responsibilities:

Contributed to the profitability solution by integrating new data sources for Non-Interest Income and Product to enable Revenue recognition.

Developed processes integrating data capture hierarchies, reconciliation, and data model changes for profitability management (PFT) and FTP in OFSAA.

Created batches, data transformations, and business rules for allocation engines and standard processes in the OFSAA module.

Strong knowledge of T2T, F2T, SCD, Hierarchy, Data Quality, Rules, and Batch components in OFSAAI.

Developed Shell scripts to monitor OFSAA batch processes and job execution times, triggering alerts for abnormalities.

Scheduled automation jobs in CA7 and Cron for server management, including ICC Server, Router, and WebSphere server patching.

Created Oracle database objects, including packages, procedures, functions, triggers, and materialized views.

Optimized SQL query performance using execution plans, SQL hints, and statistics collection.

Coordinated changes with the change management team and other developers.

Documented technical and system specifications for OFSAA applications and ETL processes, performing unit tests.

Environment: OFSAAI 8.0.4 - PFT, FTP, Informatica 10.2, IBM WebSphere, Apache Tomcat, Erwin, Linux, Shell Scripting, TOAD, Java 1.8, Python Scripting, Oracle Exadata/12c, Teradata, PL/SQL, OBIEE, CA7, uDeploy, Service Now.

Client: State Street Corporation, Boston, MA. Consultancy: UST Global Oct 2017 – May 2018

Senior DWH/ETL Consultant

Project: REF Load Automation and OFSAA/ODS Migration

Enterprise risk management, Portfolio management and Regulatory reporting solutions using Composite analytical tool as part of Treasury requirements.

Environment: Java, Oracle WebLogic, log4j 1.4, OBIEE 11.1.1.8, IBM Infosphere DataStage 11.3, (Designer, Administrator, Director), Erwin Data Modeling, Quality Stage, Unix Shell scripting, TOAD 10, Oracle 11g, Oracle PL/SQL

Client: Banque Saudi Fransi, Riyadh, SA. Consultancy: Addar Group Sep 2010 – Oct 2017

Senior Data Warehouse Analyst

Project: e-Funds Transfer System OFSAA GL Recon FCCM(Mantas) AML KYC SAS BO

Responsibilities:

Leading and managing offshore and onsite team, planning and ensuring on time delivery to meet the project deadlines.

Analysis of software requirements, analysis of source and target systems/Data mining for loading data in Data Warehouse. Specifically involved in design, development, and implementation of Data Warehouse projects.

Involved in Data Modeling for DWH (Star Schema and Snowflake Schema)

Hands-on experience in handling Back Office Payments operations which involve Swift Transfers, B2B, Inter Exchange transfers, MACUG and STELINK enhancements.

Developed SAS scripts integrating COBOL programs to apply scenario detection and alerts processing.

Worked on building T2T (Table to Table) transformations in OFSAA.

Understand complex SQL queries, analyze data related issues, and identify root causes of issues/defects.

Monitoring daily jobs and extracting the queries for performance tuning and debugging.

Involved in designing and development of FAH - OGL migration project and Reconciliation of various data between mainframe systems and the FAH data.

Actively involved in the development of PL/SQL code and tuning the DB queries, data extraction using BO tools.

Environment: OFSAAI 7.x, Java, Hibernate, JSF 3.0, Log4J, JBoss, IBM Data Stage 11.3, Oracle 12c/11g/Exadata, Tuxedo, BizTalk, Oracle PL/SQL, SAP Business Objects BI 4.2, STELINK, MACUG, SWIFT Standards, SQL Server, XML, Net Framework, AIX Unix, Linux.

Samba Financial Group (For. Citibank), Riyadh, SA Sep 2004 – Aug 2010

Senior Programmer Analyst

Project: Core Banking Unit

Implemented the Consumer Portal System, improving user access and satisfaction.

Led the migration of Business Objects XI R3, ensuring seamless reporting and dashboard integration.

Managed the SAS AML migration to version 9.2, enhancing fraud detection capabilities.

Handled SAMA status changes and regulatory compliance updates.

Re-engineered SMS alerts, improving accuracy and reducing false alarms.

Upgraded gateway applications, optimizing transaction speed and system performance.

Developed SMS key authorization for secure transactions, ensuring 99% uptime.

Created a channel limit service engine, reducing complaints by 20%, mobile banking application enhancement.

Integrated GCC-specific account opening and trading services, expanding market reach.

Environment: Java, J2EE, Tomcat, log4j, JavaScript, HTML, CSS, Ant, Oracle, Eclipse, Microfocus COBOL, C, C++, Linux, Bea WebLogic, Sybase EAS, Bea Tuxedo, LDAP.

HSBC - Saudi British Bank, Riyadh, SA Nov 2002 – Sep 2004

Lotus Notes Consultant

Project: CCMS, CA Arc Storage, Clustering & Replication and Administration of Notes Servers.

Environment: Lotus Domino, Lotus Notes, Oracle 8i, Unix, Windows NT, IBM AS/400, PowerBuilder 8.0, Sybase ASE.

Contact this candidate