Data Analyst Senior Consultant

M

Singapore

About

Experienced Techno-functional

creation of intricate Monitor Authority

Data Technologies. Proficiently engaged

trends, interconnections, and results,

segmentation for diverse applications.

acquiring novel tools and expanding

Data Analysis on Banking, Insurance

Framework for Reconciliation of Critical

Credit Risk, Mechine Learning, and

Tools

Python, SQL, HDFS, Hive

Excel Macro, VB Scripting

Shell Scripting, C, Spark

Professional Experience

Quesscorp Singapore Pte ltd

Senior Consultant @ OCBC Bank

January 2022 – Present

Roles and Responsibilities:

Spearheaded the collection and aggregation of data from various bank operations, encompassing activities, transactions, and processes, while adhering to the Scrum roadmap for efficient deliveries.

Played a pivotal role in acquiring third

scoring, fraud detection, and market analysis, handling extensive datasets for robust business analysis.

Standardized data gathering techniques acros

PostgreSQL, MySQL, XML, and JSON, employing advanced data pipeline methods. Developed leadership skills to identify emerging leaders for forthcoming projects. Mapped the compiled data to both existin

insights into the bank's performance, customer behavior, risk management, compliance, and other critical domains.

Devised systematic processes for the detection and rectification of errors, inconsistenc inaccuracies in the data, ensuring its accuracy, completeness, and readiness for in to facilitate problem-

Designed data transformation and normalization techniques in alignment with established business rules and formula

effective teamwork.

Generated Heat Maps based on product, channel, demographics, and market segments utilizing Hadoop and Hive technologies.

Murali Natarajan

Singapore ****************@*****.*** +658*******

functional Data Analyst with over 17 years of expertise, specializing Authority reports for banking products through the utilization engaged in the exploration, elucidation, and prediction of data results, aimed at enhancing data optimization, classification, applications. Accomplished in generating segmented Heat-Maps expanding capabilities to contribute to well-informed decision-making Insurance and Retail

Critical data

and Claim reports

Solution Prototype

Project Estimation

FSLDM DWH Model

Teradata, Oracle, MS SQL

Informatica, Teradata GCFR

Tivoli, Control-M, Jira, Confluenc

Quesscorp Singapore Pte ltd, Singapore

OCBC Bank

Spearheaded the collection and aggregation of data from various bank operations, encompassing Played a pivotal role in acquiring third-party data sources for diverse purposes, including credit Standardized data gathering techniques across various sources, such as business routine files, Developed leadership skills to identify emerging leaders for forthcoming projects. Mapped the compiled data to both existing and novel predictive models, extracting valuable other critical domains.

Devised systematic processes for the detection and rectification of errors, inconsistenc

-solving.

Designed data transformation and normalization techniques in alignment with established business rules and formulas, fostering enhanced communication within the team to promote Generated Heat Maps based on product, channel, demographics, and market segments utilizing specializing in the proficient

utilization of advanced Big

data patterns,

clustering, and

while continuously

making processes.

SQL

GCFR

Confluence

party data sources for diverse purposes, including credit s various sources, such as business routine files, PostgreSQL, MySQL, XML, and JSON, employing advanced data pipeline methods. Developed leadership skills to identify emerging leaders for forthcoming projects. g and novel predictive models, extracting valuable Devised systematic processes for the detection and rectification of errors, inconsistencies, and inaccuracies in the data, ensuring its accuracy, completeness, and readiness for in-depth analysis s, fostering enhanced communication within the team to promote Standard Chartered GBS, Malaysia

Senior Data Analyst, May 2019 - April 2021

Tools: HDFC, Hive, Python, Teradata SQL, Shell Scripting, Control-M, Jira, Confluence, Bitbucket and Githup. Roles and Responsibilities:

Responsible for collecting and aggregating data from various bank operations, encompassing activities, transactions, and processes.

Acquired third-party data sources essential for credit scoring, fraud detection, market analysis, and other strategic purposes.

Standardized data gathering techniques from diverse sources, including Flat Files, RDBMS Databases, XML, and JSON, and loaded them into the data lake. Mapped the gathered and aggregated data to both existing and new IFRS models, ensuring alignment with the latest IFRS9 standards and corresponding risk and regulatory reports. Developed processes to identify and rectify errors, inconsistencies, and inaccuracies in the data, guaranteeing its accuracy, completeness, and readiness for analysis. Designed data transformation and normalization techniques based on established business rules and formulas.

Generated Heat Maps to visualize data by product, channel, demographics, and market segments.

Managed the L3 Support Team using Jira ticketing for addressing production incidents. Offered technical expertise and assistance to team members in resolving complex technical issues.

Identified and optimized the performance of long-running queries, including the collection of statistics, analysis of explains plans, and determination of necessary table statistics. The Optimum Solutions pte ltd, Singapore

Senior Data Warehousing Consultant @ Standard Chartered Bank December 2015 - April 2011

Roles and Responsibilities:

I played a key role in gathering and aggregating data from various bank operations related to activities, transactions, and processes using CI/CD pipelines. I successfully integrated multiple strategic and tactical data sources (such as eBBS, CCMS, RLS, Hogan, KEDW, eCAPS, C400, etc.) into the IFRS9 system through the V2 architecture (HDFS and HIVE). Additionally, I ensured that the data was loaded into the TD T2 environment. My responsibilities included standardizing data gathering techniques across various sources, including Flat Files, RDBMS Databases, XML, and JSON. I meticulously mapped the collected and aggregated data to both existing and new IFRS models to align with the updated standards introduced in IFRS9 and the corresponding risk and monitoring authority reports.

I established robust processes for identifying and rectifying errors, inconsistencies, and inaccuracies in the data, guaranteeing its accuracy, completeness, and readiness for analysis. I devised data transformation and normalization techniques based on existing business rules and formulas, ensuring data quality and consistency.

As part of my duties, I managed the L3 Support Team, utilizing Jira ticketing for handling production incidents effectively.

I proactively identified and addressed performance bottlenecks, including the optimization of long-running queries. This involved collecting statistics, analyzing explain plans, and determining the tables in need of updated statistics.

Apar Technologies pte ltd, Singapore

Senior Software Engineer @ DBS Bank

September 2014 - December 2015

Responsibilities and Role Overview:

Spearheaded the collection and aggregation of data pertaining to various banking operations, transactions, and processes.

Orchestrated the acquisition of third-party data sources essential for credit scoring, fraud detection, market analysis, and diverse applications. Standardized data collection techniques from disparate sources such as Flat Files, RDBMS Databases, XML, and JSON, facilitating seamless integration into the data lake. Aligned collected and aggregated data with both existing and emerging IFRS models, incorporating the latest IFRS9 standards and corresponding risk and regulatory reports. Devised meticulous processes for identifying, rectifying, and rectifying data errors, inconsistencies, and inaccuracies, ensuring data precision, comprehensiveness, and analysis- readiness.

Innovated data transformation and normalization methodologies in alignment with established business rules and formulas.

Generated insightful Heat Maps categorized by product, channel, demographic, and market segment.

Supervised and guided the L3 Support Team through the utilization of Jira ticketing for efficient management of production incidents.

Detected and optimized prolonged queries through comprehensive performance tuning efforts, encompassing statistics collection, explain plan analysis, and identification of tables necessitating statistics enhancement.

Tata Consultancy Services, Chennai-India

IT Analyst @ The Home Depot

November 2011 - September 2014

Responsibilities and Contributions:

Led efforts in project management and project auditing, resulting in enhanced delivery quality. Orchestrated the collection and consolidation of data from various retail operations, encompassing purchase orders, warehouse inventory, sales transactions, store demand, store restoration, advanced supply notifications, transport, and delivery. Spearheaded the standardization of data collection techniques from diverse sources such as Flat Files, RDBMS Databases, XML, and JSON.

Devised robust processes for identifying and rectifying data errors, inconsistencies, and inaccuracies, ensuring data accuracy, completeness, and analysis readiness. Played an active role in unit testing, system integration testing, user acceptance testing, and the formulation of comprehensive test cases.

Engineered data transformation and normalization methodologies aligned with established business rules and formulas.

Developed and implemented various scripts using BTEQ, FLoad, and Mload tailored to specific business functionalities.

Shared my technical acumen with team members to effectively troubleshoot technical challenges.

Unearthed performance bottlenecks by identifying lengthy queries and conducted performance tuning activities, including statistics collection, explain plan analysis, and identification of tables needing updated statistics.

Complied with change management procedures by contributing to comprehensive change management documentation in line with process requirements. Tech Mahindra Ltd, Bengaluru-India

Technical Associate @ Etisalat

March 2011 - November 2011

Roles and Responsibilities

Led project estimation and played a vital role in the Software Development Life Cycle (SDLC) process for successful project delivery.

Orchestrated the collection and consolidation of data from retail operations, encompassing inventory, sales transactions, store demand, store restoration, advanced supply notifications, as well as transportation and delivery data.

Standardized data collection techniques from diverse sources such as Flat Files and Relational Database Management Systems (RDBMS), ensuring consistency and efficiency. Designed robust processes to identify, rectify, and eliminate errors, inconsistencies, and inaccuracies within the data, ensuring its accuracy, completeness, and readiness for subsequent analysis.

Collaborated in unit testing, system integration testing, and user acceptance testing, actively shaping and executing comprehensive test cases.

Employed the RalKimball Data Modeling approach utilizing the Erwin Data Modeller Tool to create structured and effective data models.

Created and implemented a range of scripts including BTEQ, FLoad, and Mload, employing ETL techniques for data cleansing and redundancy reduction within extensive datasets, aligned with business requirements.

Shared technical insights and expertise with fellow team members, playing a pivotal role in resolving complex technical challenges.

Proactively identified and addressed performance bottlenecks, optimizing query performance through activities such as statistics collection, analyzing explain plans, and identifying tables in need of statistical enhancement.

Produced comprehensive change management documentation to align with the requisite change management processes.

Trianz Holding Pvt Ltd, Hyderabad-India

Software Engineer @ Liberty Mutual

March 2010 to March 2011

Roles and Responsibilities:

- Developed code and conducted unit/integration testing for new data marts related to insurance claims and quotes.

- Automated reconciliation processes across different environments including stage, ODS, and Data Marts.

- Generated comprehensive Data Lineage and Root Cause Analysis documents to track insurance data flow.

- Played a key role in optimizing resource-intensive queries to enhance overall system performance.

- Devised loading scripts utilizing Teradata Utilities while applying business rules that align with data characteristics such as Slowly Changing Dimensions (SCD).

- Conceptualized and implemented drill-down and drill-up data visualization views for various segments.

- Actively participated in stakeholder meetings to gain a deeper understanding of project requirements.

- Defined distinct segments within the insurance domain such as quotes, claims, demographics, and industries.

WiFi Networks Pvt Ltd, Bengaluru-India

Senior Software Engineer

December 2008 to March 2010

Roles and Responsibilities:

Proficiently create data flow diagrams and data models using Visio, while adhering to Ralph Kimball's dimensional modelling techniques such as fact-dimensions, star schema, and snowflake schema.

Skillfully gather business requirements and meticulously delve into the intricacies of design and technical specifications.

Expertly optimize underperforming ETL jobs, enhancing their efficiency and effectiveness. Display adept leadership by conducting team appraisals, fostering team cohesion, and facilitating developmental activities.

Maintain a track record of resolving problem tickets within the confines of the designated SLA. Skillfully author comprehensive project estimates and weekly performance matrices to provide valuable insights.

Actively engage in process enhancement initiatives, including the creation of diverse checklists to ensure procedural consistency.

Provide valuable assistance in UAT, UVT, and Regression testing, including the preparation of meticulous test plans.

Merrill Corporation, Chennai-India

Junior Systems Engineer

November 2007 to December 2008

Job Roles and Responsibilities:

Designed and conceptualized user interface using ASP.NET 2.0 Framework. Developed web services to deliver information regarding share market segments upon request. Created tools for extracting data from web pages utilizing Microsoft Excel Macros. Played a pivotal role in conducting performance and load testing for financial report pages. Conceived master entry forms and the presentation layer. Participated in the deployment of HTML web pages accessible to shareholders. Contributed to the development of an intranet web platform used for employee blogs and daily broadcasts by employers.

Authored optimized stored procedures to enhance data processing logic. Devised a Role-Based Access component within the admin interface using Role Management. Engaged in unit testing and rectification of defects. Education

Bharathidasan University, Tiruchirappalli

Master of Computer Applications (MCA) June, 2003 – April, 2006 Finance, Cost and Budget Accounting

Visual Basic Programming

Descret Mathematics

Artificial Intelligence

LAN Networking

Advanced Information Management

Java Programming

Contact this candidate