Manager
Standard Chartered Global Business Services
Total years of experience :20 years, 8 Months
MBA-Systems graduate with 15 years of Experiences into Techno Functional Solutions with BIG DATA (HIVE & PIG) & HADOOP, SHELL Scripts, HQL Scripts, Teradata, Informatica, LINUX, R Programming, SQL Server & VBA developments (MS Excel & MS Access) in Data Services such as
•Data Analysis & Services (Data Accelerator Projects for Core Business, Data Extractions, Data Mapping and ETL) from DWH (EDM in PROD Environment);
•Change Management:-Business Process Improvements and Cost Allocation Analytics;
•Investment Banking Operations in Reference Data Management:-
Grade ‘A’ Certified and Experienced in Big Data and Hadoop (PIG, HIVE, HBase and Sqoop).
Enterprise Data Management Service Delivery (EDM)
Special Projects and Data Profiling & Extractions:
•Manage Data Driven research, Identify statistical relationships, Perform Data Profiling.
•Gather Business understanding and serve liaison between business and developers.
•Participating in developing final deliverable, reports and visualizations.
•Data Quality measure & analysis on the Sources & Tier 1 layers in EDM PROD.
•Fine tuning the SQL queries -Big Data - Hive & Teradata.
•Data Recon between sources & T1 such as ebbs, ACBS, SCI, MUREX, HOGAN and FM Sys.
•Data Extractions support from Big Data - Hive & Teradata using Complex SQL queries.
•SHELL Scripts developments with HQL scripts.
•Prepared Business Catalogue for EDM data warehousing.
•ETL process using Informatica from Teradata datasets.
•Technical support for T1 & T2 Layers in terms of Data Quality and Data Mapping.
•Golden Sources load Status analysis in Hadoop - Hive.
•R programming Functions for Data report development and managed for EDM.
•Managing Partitioning for Data loading into Hadoop & HIVE file & tables
Business Process Improvements: Change Management.
•Big Data: Data feasibility analysis with HIVE Query for POC.
•Big Data: Data mapping analysis with source systems.
•Big Data: SQL tuning support in Big Data - HIVE & SQL Server.
•Informatica: ETL load datasets analysis
•Informatica: Data mapping and analysis for agreed outcome.
•Cost Allocation Data Analytics & Mapping and DB Development.
•% allocations for costs based on Stakeholders requirements across regions.
•Perform the feasibility study, Identification of GAPS, To Be Process requirements.
•Database Connectivity, RDBMS design, SQL, MS Access Database Maintenance.
•Develop Queries/Tables/VBA Scripts and Tools & Dashboards in MS-Access & MS Excel.
•Enhance ADO/DAO connectivity to capture data ETL Process.
•Develop VBA scripts to export and import data among Excel, Access & SharePoint.
•Coordinate with users to produce comprehensive test plan, UAT and signoff
EPIX -Enterprise Data Management: Equities & Fixed Income
•Issuer linking connectivity analysis between Security and Issuer through SQL.
•EQ & FI Counterparty, Issuer and Security setup and Data Reconciliations and Cleansing.
•Data Mapping and Data Issues resolved by SQL for Issuer Link and Product Control.
•Enable the Issuer linking data in Database as per Regulatory requirements.
•Reconciling the system linked issuers Data by SQL for Corporate Action updates.
•Implemented, managed and customized new VBA scripts on MS-Excel & MS Access tools.
•Database & Metrics with MS Excel VBA & connected to the server through ADO/DAO.
•Requirement Gathering, Feasibility Study and Developing Scripts & Queries in MS Access
Fixed Income Security set up & updates in Mainframe as per Bloomberg.
Tolerance Issue solving by various Calc Method. (Act 360, Act/Act, Act/365, 30/360).
Issuer & Counterparty setup, mapping and linking.
Data Analysis and Data Mapping for Reference Data Management.
Developed & Maintained MS Access database to capture Trade Details.
Reference Data Management: Fixed Income
•Fixed Income Security set up & updates in Mainframe as per Bloomberg.
•Tolerance Issue solving by various Calc Method. (Act 360, Act/Act, Act/365, 30/360).
•Issuer & Counterparty setup, mapping and linking.
•Data Analysis and Data Mapping for Reference Data Management.
•Developed & Maintained MS Access database to capture Trade Details
Verifying the transactions comply with financial policies and procedures with SEC.
•Updating & Maintaining the Receivables & Payables by totaling unpaid invoices.
Projects & Achievements in Enterprise Data Management (EDM) & Process Improvements.
BIG Data (HIVE), Informatica, Teradata, R Programming & VBA
1. Client on Boarding Project Data Analysis and Extraction Support. Tableau support Query Development. 8. Project SAIL - Scripts & SQL developments
2. Data Remediation project SQL developments 9. Project NTB clients scripts & SQL development
3. Project Diaocha SQL & scripts developments 10. Intraday Balance project - SQL & Script development
4. Excess Balance Summary - HIVE SQL development & Analysis. 11. Adhoc Extraction Queries
5. Client Derived Status scripts developments 12. Data Quality Business Rules SQL Development
6. PBOC - Chinese Query development 13. MS-Access Developed & Implemented. Tool implemented in Tokyo, Japan.
7. BRRD - Data Extraction Query development 14. Applications Used: Kondor + 2.5, 2.6, WallStreet, Adaptive, Mainframe, SAFE, FISS and Bloomberg
Second Mar & Oct 1995 DCA VB, Oracle, MS-Office
System Executive: •Server Maintenance & Accounting Database development in FoxPro. •Data Reconciliation and Analysis with multiple sources and consolidated data.
Commerce