Result oriented professional with 17+ years of IT experience in the analysis, design, implementation, testing and support with detailed understanding of the technical complexities associated with Data Warehousing, Oracle developer suite, OLAP applications using ETL tools and Cloud technologies.
Having 7+ years of industry experience in implementation of Data Warehousing projects which includes OFSAA - Profitability Management (PFT), Fund Transfer Pricing (FTP), Financial reporting, AML, FATCA, KYC using tools like OBIEE.
Excellent understanding of data modeling, analytical skills, and the ability to identify solutions to complex data problems, and to communicate appropriately with the team leadership.
Integrated and reconciled risk and performance measures to obtain immediate value from reports and dashboards covering customers, account, transactions, products and organization units.
In-depth understanding of dimensions, hierarchies and attributes as it applies to OFSAA Transfer Pricing to assign cost or benefit of the funds and Profitability management to derive cost and allocations.
Experience in Data Warehouse using Fact tables, Dimension tables, Star schema and Snowflake schema modeling.
Expertise in Data integration projects using Extraction Transformation and Load(ETL) methodologies like Informatica PowerCenter 10.2, IBM Info sphere DataStage 11.5(DataStage Designer, DataStage Director, DataStage Manager, DataStage Administrator), Quality Stage, Profile Stage, DB2, Teradata and Linux.
Interpret business and create technical requirements, including mapping documents to support the ETL development process, data transformation, data sourcing, mapping conversion and execution.
Extensive experience and well versed with UNIX commands, various source transformations including flat files, XML, modified Shell scripts and relational systems.
Proven ability to collaborate with clients in creating mapping documents for Agile projects delivery.
Worked with leading global banking and financial institutions - PNC Financial Services Group Inc.,
State Street Corporation, Banque Saudi Fransi (Credit Agricole – France), Samba Financial Group (Formerly Citibank), Saudi British Bank (ventured with HSBC).
Good problem solving and troubleshooting capabilities, quick learner, highly motivated, result oriented with excellent interpersonal, communication skills and enthusiastic team player.
Worked as L2 production support manager role, managing team with SLA timing of data loading and resolving various issues within SLA timeline.
Involved in Smoke testing, Functional testing, Regression testing, Integration testing, User Acceptance Testing(UAT) and Data validation testing for Revenue and Costing projects as part of OFS Profitability enhancements.
Experienced in development, testing, support and migration projects from Legacy and web technology products.
Master of Computer Applications, University of Madras, India
Bachelor of Computer Science, University of Madras, India
Java, C, C++, Cobol, Oracle Cloud, Shell Scripting, Power Builder
ServiceNow, CA7, AutoSys, Toad, PL SQL Developer, SVN, uDeploy, OIM etc.
Oracle 11g/12c/Exadata, MS SQL Server, Sybase Adaptive Server, My SQL
Data Warehouse tools
Informatica PowerCenter 10.2, IBM DataStage 11.5/9.2, Business Objects BI 4.2 (OBIEE), Tableau, Map Reduce, Hive, Pig, Flume, Oracle DWH Builder.
OFSAAI 8.0.4, Windows, HP Unix 9.x, Red Hat Linux, AIX.
IBM Web Sphere, Oracle Weblogic, JBoss, Apache Tomcat, IIS Server
CERTIFICATION & TRAINING:
ITIL – Foundation Certificate in IT Service Management.
IBM CLP – Certified Lotus Professional – Domino Designer & Server 5.
MCP – Microsoft Certified Professional – Designing apps using Visual Basic.
Problem Solving and Decision Making at Samba Financial Group Riyadh. (3 days training workshop).
Effective Leadership Skills at Samba (4 days training workshop).
PMP – Project Management Professional (5 days training workshop).
PNC Financial Services Group, Cleveland, OH Apr 2018 – Till Date
Application Tech Lead
Involved in the profitability solution to capture new data sources incorporating Non-Interest Income and Product to create Revenue recognition results.
Responsible to write process that includes integration with data capture hierarchies, reconciliation and analyze data model changes for its implication on profitability management and FTP in OFSAA.
Created batches and data transformation for the business rules, allocation engine, standard processes in OFSAA framework.
Perform root cause analysis and fix any issues that line of business encounters within OFSAA.
Analyze and interpret complex data on the target systems and provide resolution to data issues and coordinate with business analysts to validate all the requirements.
Good understanding of T2T, F2T, SCD, Hierarchy, Data Quality, Rules, Batch component of OFSAAI.
Perform tests and validate the data flows for source data consumption and prepare the ETL processes according to business needs.
Developed Shell scripts to monitor the OFS batch processes and jobs execution time to generate alert to handle the abnormalities.
Scheduled jobs in CA7 and Cron scheduler to handle automation of ICC Server, Server Socket failures, Router issues, Websphere server patching activities.
Design, develop and test the ETL components for the changes requested by business teams.
Responsible for creating database packages, procedures, functions, triggers, materialized views in Oracle.
Effectively used execution plans of the SQL to investigate the root cause of the slowness in query performance and fine tuned them by rewriting with the help of SQL hints and collecting Stats.
Coordinate changes with the change management team and other application developers in the team.
Design and implement publication activities such as dashboards and maintain required system documentation according to IT applications and SDLC procedures.
Document technical and system specifications documents for OFSAA application, ETL processes and perform unit tests.
Environment: OFSAAI 8.0.4 - PFT, FTP, Informatica 10.2, Erwin 4.1, Unix Shell scripting, TOAD, Oracle Exadata/12c, PL/SQL, OBIEE, CA7, Service Now, Teradata
Swift Tech LLC October 2017 – April 2018
Clients - State Street Corporation, Boston, MA
Loans and Genius, Boca Raton, FL
Senior Technical Consultant
Worked in a migration project where the requirement is to migrate data from legacy systems to new system
Involved in analysis, requirements gathering, function/technical specifications, development, deploying and testing.
Deliver interactive, online reporting with delivered email and offline reports using Oracle BI online reporting.
Developed Routines for Error handling and also developed before/after job subroutine.
Perform OFSAA fitment study based on the list of OFSAA out-of-the-box reports provided by external entities.
Extensively used Quality Stages like Investigate, Match and Survivorship.
Used Director for executing, analyzing logs and scheduling the jobs.
Used Quality Stage plug-in to call Quality Stage jobs from Data stage.
Written SQL scripts to create and drop the indexes those are passes as parameters in the pre & post sessions.
Involved in investigating & solving the data integrity issues.
Wrote UNIX shell Scripts for file validation and scheduling DataStage jobs.
Environment: OBIEE 220.127.116.11, IBM Info sphere DataStage 11.3, (Designer, Administrator, Director) Erwin 4.1, Windows, Quality Stage, Unix Shell scripting, TOAD 10, Oracle 11g, Oracle PL/SQL
Banque Saudi Fransi, Riyadh, Saudi Arabia September 2010 to September 2017
Decision Support Systems, EDA
Sr. Data Warehouse Analyst
Environment: OFSAA 7.x, IBM Data Stage 11.3, Oracle 12c/11g/Exadata, Tuxedo, BizTalk, Oracle PL/SQL, SAP Business Objects BI 4.2, STELINK, MACUG, SWIFT standards.
Roles & Responsibilities:
Leading and managing offshore and onsite teams.
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 Snow flake Schema)
Hands on experience in handling Back Office Payments operations which involves Swift Transfers, B2B, Inter Exchange transfers, Macug and STELINK enhancements.
Designing and maintain data models to transform for successful implementation of Data Warehouse.
Responsible for development of Administration, User security, Data Masking, Dashboards, Alerts and scorecards.
Worked on building T2T (Table to Table) transformations in OFSAA
Understand complex SQL queries, analyze data related issues and identify root cause of issues/defects.
Monitoring daily jobs and extracting the queries for performance tuning and debugging.
Troubleshoot technical issues by analyzing OFSAA log files and fixing the issues.
Analyze data related issues and identify root cause of issues / defects.
Worked on configuration and allocation rules in OFSAA for revenue allocation, profitability management and generation of Profit and Loss reports including Balance Sheet reconciliation.
Requirement collection, Documentation, Scheduling development, Integration, Testing, Delivery and enhancement of new and existing Web and batch processes to increase operational efficiency and customer experience.
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 development of PL/SQL code and tuning the DB queries.
Responsible for development, testing and implementation of various reconciliation jobs and automation.
Involved in designing and development of Data Stage server jobs and sequences.
Actively involved in development of PL/SQL code and tuning the DB queries.
Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into SQL server Database.
Involved in Unit Testing, created test cases, Integration Testing and Performance testing.
Assemble reports by extracting and Analyzing data using Business Objects tools.
Involved in SIT/UAT/Production support.
Coordinating with Database teams and system administration team.
Handling Data quality issues and assisting business to maintain Master Data.
Arranging and attending KT sessions with the different application teams.
Worked with defect management tools IBM Lotus/CM Synergy to keep track of defects and updates.
Fund Collection Systems - RESTful services that automate the existing manual process, receive company onboard, customer creation, payment collection services, virtual IBAN request from existing stream in XML format, parsing and creating object as well as insert into database to keep end to end track of each request submitted through various channels.
OFSAA Data Quality and Enterprise Reconciliation Systems.
IPP Archiving & Purging.
OFSAA Integrity Check tool.
Aramco Non-Oil Receipts automation.
Bank Trade enhancements.
Bank Trade online posting.
SAMA ID Inquiry tool.
SAMA Stop Dealing List .Net conversion.
Overdraft Reporting & Dashboard enhancement.
BASEL II, Pillar 3 reports design, FATCA enhancements.
Kondor, Funding Deals & Treasury products reconciliation.
Daily Accruals & Scale of Interest computation.
Samba Financial Group, Riyadh, Saudi Arabia November 2004 to August 2010
Senior Programmer Analyst
Project Description: The bank was established in Jeddah by Citibank in 1955, we have upheld a history of excellence. Citibank becomes Saudi American Bank following a Royal Decree. Citibank retains 40% ownership and manages the bank through a Technical Management Agreement. The remaining majority shareholding was owned by Saudi. Citibank sells its last shareholding to local investors. Samba has been leading the industry in innovation with a long list of industry firsts, playing a major role in the modern transformation of banking in Saudi Arabia. Indeed, our world class services, market-leading products and superior technology have made us one of the most successful financial services brands and the most internationally acclaimed bank in Saudi Arabia and even the Middle East.
System Supports Division, Core Banking Unit
Role: L2 – Support Project Manager
Environment: Java/J2EE, EJB, TOAD, UNIX, Oracle 9i, SQL Server 2008, Microfocus COBOL, Oracle Weblogic 8/10 Application Server, Eclipse, Sybase, Tuxedo Server, LDAP.
Roles & Responsibilities:
Analyzed requirements and created a high level and low-level technical design documents
Involved in detail design and development of jobs using DataStage Designer.
Transformations and finally loaded data in to Oracle and DB2 tables.
Customized different designs and prepared flow charts and entity relationship diagrams.
Design and development of Extract, Transform, and Load (ETL) processes for extracting data from a various legacy system and loading into target tables using SQL, DataStage Enterprise Edition.
Used parameters sets and variables to make jobs and sequencers are more flexible.
Worked as application support manager and JEE developer to resolve the day to day issues regarding online E-Banking applications.
Worked as Technology Analyst to perform the different assignments on Samba Online, Samba Mobile and E-Care applications and every year releasing around 10-15 projects to production.
Creating these documents for release process Requirement Description Document (RDD), High Level Design Document, project Initiation document, Code check in, release implementation document, code review documents, unit test, integration documents, user acceptance documents, user guide lines.
Support and maintenance of the online, combined-financials, SAS Anti-Money Laundering, SMS Alerts gateway applications.
System analysis, Software design and development of the IPO (Initial public offering) project at Samba.
Participation in meeting with business and vendors for the new requirements.
Presentation to CMMI auditor on CMMI audit at Samba.
Consumer Portal System.
Migration of Business Objects XI R3.
SAS AML Migration version 9.2.
SAMA Status changes and compliance.
SMS Alerts re-engineering & Gateway application upgrade.
SMS Key Authorization – Key factor authentication.
Channel limit service engine.
Mobile Banking, Trading through smart devices.
GCC Account opening and trading services.
Samba Speed cash enhancements.
Samba Online portal and SADAD Bill payment enhancements.
Samba Intranet application integration with Mubasher services.
Saudi British Bank (SABB - HSBC), Riyadh, Saudi Arabia November 2002 to October 2004
Lotus Notes Consultant
Enterprise Administration Division
Environment: Lotus Notes, Lotus Domino, Cobol, Java, Visual Basic 6.0, .Net, Oracle, AS/400, Power Builder 8.0, Sybase Adaptive Server Anywhere
Roles & Responsibilities:
Software Design and Development of a product and Implementation of CA Arc Storage solution.
As an administrator involved in Clustering of domino servers.
Installation and up gradation of existing Domino Notes servers and handling production support.
Software Design and Development of an enterprise application for leasing and finance.
Requirement specification, Development, Flowcharts, Detail Design, Sequence Diagrams and Database Design.
Install, configure, and administer Lotus Notes mail server in clustered and non-clustered environment.
Pentasoft Technologies, Chennai, India November 2000 to August 2002
Environment: Lotus Notes, Lotus Domino, Java Script, Java, Oracle 8i, Developer 2000, UNIX, EJB, Servlets.
Roles and Responsibilities:
Developed an online human resource management system as In-house development.
Involved in design, development, testing and implementation.
Worked on automation project of national defense academy and handled corporate training teaching the officers on latest technology.
Requirement gathering, requirement specification document preparation, functional specification document preparation, database design and the coding is done on the HRMS project.
Enhancement and improvement in the existing system and obtaining successful UAT/Production sign-off.
Handled corporate training for Forbes India Pvt. Limited, Reliance groups, National Defense Academy.