• Currently handling Business Intelligence Application and Analytics projects.
• Managed BI for the following group of companies - Emirates Post, EPG Courier, EDC (Card printing business) and Western Union Money transfer. (UAE Federal Authority)
• Publish monthly business performance to Emirates investment authority the parent company of EPG.
• People management (hiring, performance appraisals, team mood monitoring)
• Reporting to Emirates Post Group management (UAE Federal Authority)
• Continuous process improvements, manages project budget.
• Cooperation with the client to establish the best delivery practices and processes
• Risk management, Vendor and people management, Facilitates team and client meetings effectively.
• Project planning - analyse, estimate, plan, commit for the release
• Preparing project profitability, revenue, margins, bill rates and utilization.
• Assures project legal documents are completed and signed.
• Issues solving, impediments removal, Supporting all data requirement and analysis for audit requirements.
• Prepare the Business Intelligence Project Planning
• Analysing latest trends related to technology and market, and identifying their potential impact on the enterprise
• Coordinating with the database administrators and data warehouse owners and establishing and maintaining secured data integration patterns
• Develop policies and procedures for the collection and analysis of data
• Data Assessment - Collaborate with end-users to gather the overall business requirements
• Reviewed and validated customer data as it is collected
• Analyzed, and developed data model and structure the business requirements to address the data modelling
• Created new data procurement and processing programs
• Technical Assessment analysing and preparing the Technical Architecture Design
• Analyzed and prepare BI Application Specifications
• Developed and maintaining the Dashboards & reports for ‘C’ level management using Microsoft Power BI, Tableau, OBIEE and Microstrategy.
• Project Management and complete end-to-end BI project management (design, develop and deployment).
• Prepare monthly Net Income (P&L) by segment as report in the Management Report using Microsoft Power BI.
• Extract the data from database using SQL & analyse the source application data to convert into meaningful reports.
• Monthly performance analysis and operating reports for core business and profit centre and compare it against budget, Prior Year.
• Extract and organize data in simple and easy templates to discuss with Business Units.
• Prepare the monthly management reporting slides - Revenue and its variances; Key ratios and its variances
• Develop, maintain and distribute as-hoc reports and financial models as needed
• Supporting external audit during quarterly, interim and annual audit and automated reconciliation reports.
• Vendor and people management.
• Develop best practices, standards, and methodologies to assist in the implementation and execution of Data Governance
• Developed and implemented security for reports in OBIEE, developed best data model design for the better performance of the reports.
• Lead the Data Governance committee, recruit data stewards from the lines of business and departments, and work with them to ensure data standards across the organization
• Determine the rules and workflows that define and monitor the process of creating, modifying, storing and deleting data for the Master Data Solution and audit data to ensure it is in accordance with the Master Data Governance program
• Develop and deliver management dashboards that describe the state of master data health across the company

• Provide feedback and lessons learned on project execution and project team performance
• Create project plans and manage project costs, quality, and schedules to drive project execution activities through implementation and project closure
• Document, manage, and communicate project issues, risks, and action items
• Manage project scoping and estimation activities, document the project scope and approach, review plans with business and technology stakeholders and acquire sign-off from business and technology leadership
• Provide cost/benefit models in support of business and infrastructure initiatives
• Assist in evaluating priorities and advise on options, risks, and costs versus benefits of proposed solutions
• Partner with GTI, IT and business partners to identify , model, and execute on risk analysis and cost save opportunities around Shared storage/infrastructure, and application specific storage and infrastructure
• Implemented Datawarehouse and Business Intelligence Application and Analytics projects for CRM application.
• Created customer data mart by coordinating with IT and built predictive model for the better campaign to identify the potential customer to increase the conversion rate.
• Used SSIS, SSRS and SSAS for loading customer loan data mart.
• Successfully interpreted data to draw conclusions for managerial action and strategy
• Presented findings and data to team to improve strategies and operations
• Proposed solutions to improve system efficiencies and reduce total expenses
• Created MIS dashboards and reports in OBIEE/OBIA to monitor the performance of product, sales, portfolio, revenue.
• Complete source application data analyse and identify the data available for reports.
• Solution designer at enterprise level for data insight and classification of reports to various roles in the bank.
• Prepared the project plan, Coordinated internal resources and third parties/vendors for the flawless execution of projects
• Managed changes in project scope, schedule and costs, measured project performance, escalated to management as needed
• Manage the relationship with the client and all stakeholders, Performed risk management to minimize project risks
• Created and maintained project documentation
• Have set the team direction, Coordinating activities across different organizational functions, Motivating team members.
• Experience in Informatica MDM workflow including data profiling configuration specification and coding match rules tuning migration.
• Experience in statistical analysis and building predictive models.
• Developed Propensity Modelling and feed into OBIEE segment designer, which creates the target audience into Siebel campaign for the telesales, email and SMS marketing.
• Build out best practices regarding data staging data cleansing and data transformation routines within the Informatica MDM solution.
• OBIA configured with Siebel CRM and data model filled with data through Informatica.
• Completely engaged with business and suggesting for reports required.
• Implemented bank channel, digital channel and cross sell channel report for consumer banking with drill down of data insight into more detail level from the summary page.
• Reports mainly focusing on leads summary, ageing, pipeline, lead conversion ratio, application rate, products sold, channel vs product lead count – current YTD and Previous YTD, channel vs segment lead and booking summary and detail by drill down to detail data, segment vs source – complete summary on bank channel and digital channel leads, product vs source slice and dice reports.
• Whole sale banking reports covering, summary on Deals, RM Probability, Total income (Fee/Int) Deals won / loss, sales stages of deal summary, Funded and non-funded deals, Ageing on each deals, Product family report, account planning report.
• Drive the data-mining and analytics process to create a detailed understanding of the customer behaviour, trigger, buying habits, lifestyle preferences based on advance analytical methods.
• Through Big data platform received the data from social media and used for segment designer for the market campaign automation.

Accomplishments:

• Successfully managed a portfolio of AED 10 million in 2015.
• Efficiently delivered THE Following key projects which had a mandated timeline.
  • Bank-wide CRM data warehousing & analytics
  • Oracle OBIEE, MIS & business segments performance

Received excellence award from Head of CRM and business intelligence for the implementation of MDM and CRM analytical part of wave 1 delivery.

• Handled Business Intelligence and Analytics projects. Evaluation and implementation of Analytical tools, forming Data Governance strategy.
• Implemented Finance, HR and procurement analytics.
• Create presentations & assist in data gathering
• Create training documentation
• Assist in on-site production support during deployments
• Learn and understand the various processes and procedures performed within Client Information and Reporting
• Management and oversight of Data Quality team
• Manage Access recertification
• Manage future enhancement list and prioritization process
• Manage timelines based on volume and capacity, monitor progress and results.
• Key responsibilities for Prospect Prioritization
• Created Customer on boarding process to load data into landing tables of MDM Hub using external batch processing for initial data load in hub store and define automation process for staging loading match and merge
• Configured designed and delivered Informatica MDM hubs across multiple data domains Party Service/Product Prospect
• Used hierarchies tool for configuring entity base objects entity types relationship base objects relationship types profiles put and display packages and used the entity types as subject areas in IDD
• Successfully completed Customer and Product centric Master Data Management initiatives using Informatica Master data management product
• Developed Oracle Fusion Cash Management Reports in the following areas - Bank Statements, Cash Transit and Reconciling to the General Ledger.
• Developed Bank Statement Report displays balance and transaction information for specific bank statements.
• Built Bank Statement Analysis Report shows bank statements used to analyse balances and transaction details.
• Built Cash in Transit Report shows for a specific bank account, all transactions that have been remitted to the bank but have not been cleared. Excludes all voided transactions. It also excludes all reversed transactions which have a reversal date on or prior to the as-of Date.
• Built Cash to General Ledger Reconciliation Report - bank statement transactions and general ledger accounting entries that have not been reconciled and can cause discrepancies. Used to reconcile bank balances to general ledger cash balances. OBIA configured with Siebel CRM and data model filled with data through Oracle data integrator.
• Designing to implement OBIA segment designer for marketing segment to target the customer for each individual campaign contact, Siebel configured to fetch the targeted contacts from OBIA and to load into Siebel campaign contacts for the campaign launch purpose.
• Completely engaged with business and suggesting for reports required.
• Developed comprehensive models for managing and communicating the relationships between Base Objects and Performed the ETL process for loading the data into hub.
• Administered NQSCONFIG.INI and Instanceconfig.xml configuration files.
• Configured implicit fact columns. Enabled and administered Usage Tracking by using direct insert method.

Key member in the Big Data Exploration team

Accomplishments:

• Redesigned the whole data mart with proper data mart standard and to be flexible and accept the future changes.
• Automated in the operational activity.
• Set strong security in MIS.
• Key member for all technical issues and solution provider related to data warehouse and business intelligence / MIS.
• Trained Business users to generate the simple adhoc report themselves from the created data mart.
• Fortnightly educating higher management on the new concepts and achievements evolving in the Data warehouse and Business Intelligence world to get success in the Business with the help of utilization of powerful data.

• Implemented business intelligence application for the sales, marketing, finance and service module.
• Work with business users to define, plan and develop further BI / reporting capabilities.
• Implement Informatica MDM including data profiling configuration specification and coding match rules tuning migration.
• Used SSIS for ETL related to Finone Load data mart.
• Build out best practices regarding data staging data cleansing and data transformation routines
• Define and build best practices regarding creating business rules within the Informatica MDM solution
• Developed the mappings using various cleanse functions in the Hub and the address doctor to standardize the data
• Worked with Business users in understanding Match Merge setup and incorporated their requirements and ideas
• Collaborated with users in defining Match Rules and conducted workshops to discuss over and under matching
• Develop and maintain a long-term roadmap for solutions.
• Developed and Implemented data quality, ETL for Data Extraction, Data Mapping and Data Conversion complex using Informatica.
• Ensure documentation is available and up-to-date.
• Support BI solution Planning and implementation of enhancements.

• Designer for AML (Anti Money Laundering) projects and implemented the data leakage prevention.
• Strong Programmer used the following technologies – Informatica, SAP BO, UNIX (shell scripting), and Erwin – data modeller.
• Analyzed the key functionalities of the institute and performed Data Analysis and abstracted the transactional nature of data.
• Profiled the data using Informatica Analyst tool to analyse source data (Departments, party and address) coming from Legacy systems and performed Data Quality Audit.
• Provided support to other developers in accurately mapping source attributes into the Teradata Financial Services Logical Data Model (FSLDM) and in interpreting business requirements
• Experience as Data Architect in enhancing the FSLDM
• Development of scripts for loading the data into the base tables in EDW using Fast Load, MultiLoad and BTEQ utilities of Teradata.

• Prepared technical specification using FSD as source document.
• Implemented data warehouse on Teradata, since the volume of data is very high, achieved by massive parallel processing architecture using Teradata V2R5.
• Understood and interpreted complex business requirements and translated them into useful BI applications.
• Worked on developing various report using OBIEE, interactive reports, dashboards, KPI.
• Implemented complex conceptual database design and database architect.
• Implemented complex business requirement in backend using efficient stored procedures and flexible functions, and facilitated easy implementation to the front end application.
• Using Erwin and Visio 5.0 design different kind of Data Models for various kinds of databases as per the requirement.
• Designed schema using KPIs, Fact, Dimensions, Physical, Logical, Alias and Extension tables. Built Business Model and established relationships & Foreign Keys (Physical & Logical) between tables

Accomplishments:

• Created Standard template for ETL and Report code review and also best practices document, which has been validated and accepted by senior architect and other stakeholders for the reference by software programmers.

• Understanding the Functional Business processes and Requirements and creating the Technical specification.
• Involved in creating Mapping documents, test case, Performed analysis, coding, bug fixing and testing for the new enhancements.
• Generated scripts for data migration and data validation.
• All the jobs are integrated using complex Mappings, which includes Mapplet and Workflows using Informatica Power Centre Designer and Workflow Manager.
• Performance Tuning has been done to increase the throughput.
• Accomplishments:

Have conducted many internal training’s on the ETL and BI tool including Data warehouse basic concepts.

16+ years Analytics and Report expertise subjects

Financials - Cash Management (BRS) Reports, Payables Reports, Payments Reports, AP Balance, AR Transactions, Asset Balance, Asset Overview, GL Balance Sheet, GL Budget and Expenses, GL Cash Flow, Profitability – Customer, Product and Company

General Ledger - Balances Real Time, Journals Real Time, Transactional Balances Real Time

Human Resources, Workforce Deployment, Workforce Gains and Losses

Incentive Compensation - Credits Real Time, Disputes Real Time, Earnings Real Time, Pay Group Assignments Real Time, Inventory

Marketing CRM - Campaign Launch, B2B Customers, B2C Customers, Campaign Launch, Events, Leads, Lead to Order, Leads and Opportunities, CRM Planning

Marketing Segmentation Agreements, Segmentation Assets, Segmentation Campaigns, Segmentation Leads, Segmentation Opportunities, CRM Partner Programs

Procurement and Spend, Product Management, Receivables,

Sales - CRM Pipeline, Orders, Service - CRM Activities, Service - CRM Agreements, Service - CRM Assets, Service - CRM Orders / Workforce Management, Workforce Performance

Territory Management - CRM Forecast, CRM Leads, CRM Pipeline, CRM Quota, CRM Sales Accounts.

TECHNICAL SKILLS

Functional Knowledge : Finance, HR, Procurement, EAM, CRM and other applications Business Intelligence,

AML, Risk Management, Trade Finance, core banking, consumer and whole sale

Banking.

Technical Knowledge : Informatica MDM, Power centre, Data Quality, Data Governance, Data modelling,

Data warehousing and BI, Data Analytics, ETL, Reporting Databases Platforms: OLTP

& OLAP report.

Database : Oracle 11g, Teradata, Sybase and SQL Server

Business Intelligence Tools : OBIEE 11g, Siebel CRM OBIA (RPD), BI Publisher, Mobile BI, Informatica 9.x, ODI

MDM, IDQ, Informatica Power Exchange 9.5.1, Control-M, COGNOS, BO and Cast Iron,

SAS Analytics

Banking AML tool : Fortent, Mantas.

Risk Management Systems : AML - FCRM, Customer Screening, Moody's Risk Analyst.

Trade Finance : Eximbills

Source system Application : T24, Siebel CRM, Sigcap, Etrade, Finone, Finacle, calypso, and Prime.

Languages / Tools : Oracle SQL and PLSQL, Visual Basic, MS Visio, MS Project, MS Office.

Operating Systems : UNIX, Windows.