Summary
Overview
Work History
Education
Skills
Websites
Certification
Hobbies and Interests
Awards
Timeline
Generic
Ankita Singh

Ankita Singh

Singapore

Summary

Dedicated and results-oriented SME with over 7+ years of comprehensive experience in data analytics, fraud detection, credit risk management, and data trust framework within the financial and public sector. Proven track record of exceptionally achieving Customer service, Stakeholder Management and Quality goals. Skilled in leading, motivating, and training teams to deliver exceptional service and mitigate key risk effectively. Worked on migration project for Temasek to migrate the data from on premise systems (IPP Postgres and Oracle) to AWS cloud and store the data to Snowflake platform. Worked for building the end-to-end pipeline architecture for the ingestion project. Used performance optimization techniques on big data components. Efficiently used cloud technologies such as EMR, EC2, S3, Amazon Sagemaker, Snowflakes etc. Created Reconciliation script to validate source and target data using python programming. Interacting with Business directly to gather information and provide best suited solution for the project deliverables.

Overview

10
10
years of professional experience
1
1
Certification

Work History

Manager

PwC
09.2022 - Current
  • SME for Data Trust Framework
  • Worked for building the end-to-end pipeline architecture for the
    ingestion project.
  • Used performance optimization techniques on big data
    components
  • Implemented rigorous data validation protocols, minimizing
    errors and ensuring accurate results in all analyses performed.
  • Optimized data analysis processes by implementing advanced
    analytical tools and software.
  • Mentored junior analysts as they developed their skills in various
    aspects of data analytics management techniques.
  • Involved in strict project planning, timelines and delivery
    including stakeholder management.

Senior Data Analyst

Infosys Consulting
11.2021 - 08.2022
  • Worked for building the end-to-end pipeline architecture for the ingestion project
  • Used performance optimization techniques on big data components
  • Implemented rigorous data validation protocols, minimizing errors and ensuring accurate results in all analyses performed
  • Optimized data analysis processes by implementing advanced analytical tools and software
  • Mentored junior analysts as they developed their skills in various aspects of data analytics management techniques
  • Involved in strict project planning, timelines and delivery including stakeholder management

Senior Data Analyst

HSBC
04.2019 - 11.2020
  • Extensively worked on automating the SAS Scripts for more accurate test case validations against source to target, field level or data level validations
  • Developing SAS Scripts for Data Cleaning, Manipulating the Data as per business requirements
  • Developing SAS and SQL Queries to incorporate newly introduced Plans on the client by connecting to Teradata database
  • File Creation against different database and sending to client for verification with strict time constraints for each file delivery
  • Provided technical support to end users on SAS, SAS EG, SAS Viya
  • Automation and Scheduling Final validated Reports using SAS Macros
  • Created verification queries for verifying details and creating dashboards using Tableau

Senior Analyst

Equifax Analytics
09.2018 - 04.2019
  • Extensively worked on automating the SAS Scripts for more accurate test case validations against source to target, field level or data level validations
  • Developing SAS Scripts for Data Cleaning, Manipulating the Data as per business requirements
  • Extensively working on PROC REPORT, PROC TABULATE, PROC Summary to produce reports for the purpose of test script validation for client
  • Data Merging, Data Sub setting with use of PROC SQL MERGE and SET statements
  • Involved in writing code using Base SAS data step programming and Advanced SAS Macros to extract, clean and validate date from external source
  • Extensively used ETL methodology for supporting data extraction, transformation and loading processing, in corporate-wide-ETL solution using SAS DI Studio
  • Automation and Scheduling Final validated Reports using SAS Macros

Senior Data Analyst

Alight Solutions
05.2015 - 08.2018
  • Extensively working on PROC REPORT,PROC TABULATE, PROC
    Summary to produce reports for the purpose of test script
    validation for client. Data Merging, Data Sub setting with use of
    PROC SQL MERGE and SET statements.
  • Involved in writing code using Base SAS data step programming
    and Advanced SAS Macros to extract, clean and validate date
    from external source.
  • Extensively used ETL methodology for supporting data extraction,
    transformation and loading processing, in corporate-wide-ETL
    solution using SAS DI Studio.
  • Automation and Scheduling Final validated Reports using SAS
    Macros.

Education

Bachelor of Engineering - Electronics and Communication

RGPV University
01.2015

Skills

  • Management Skills
  • Data Analysis
  • SQL Programming
  • Python Programming
  • Tableau /Power BI
  • Microsoft Excel
  • Data Trust Framework SME
  • AWS Services
  • Strategy Decisioning
  • SAS Viya
  • SAS EG
  • Base/Advanced SAS

Certification

  • Python Programming: The Complete Python Bootcamp 2023, 06/01/23
  • Metaverse Masterclass- Learn everything about the Metaverse, 06/01/23
  • Learn Advanced Techniques on Power Curve Design Studio, 04/01/20
  • Base and Advanced SAS Champion, 04/01/16

Hobbies and Interests

  • Cricket
  • Formula 1
  • Painting
  • Cooking

Awards

  • Team Award, 03/01/20
  • Live Our Value Award, 12/01/16
  • Outstanding Employee of the Year, 03/01/18

Timeline

Manager

PwC
09.2022 - Current

Senior Data Analyst

Infosys Consulting
11.2021 - 08.2022

Senior Data Analyst

HSBC
04.2019 - 11.2020

Senior Analyst

Equifax Analytics
09.2018 - 04.2019

Senior Data Analyst

Alight Solutions
05.2015 - 08.2018

Bachelor of Engineering - Electronics and Communication

RGPV University

Similar Profiles

CREATE PROFILE
Ankita Singh