profile-pic
Vetted Talent

Suman Saurabh

Vetted Talent
Strategic mindset person that focuses on problem-solving tasks and maintaining priorities on strict deadlines. Currently working as data analyst at ServiceNow (Client). WORK EXPERIENCE
  • Role

    Senior Data Engineer I

  • Years of Experience

    5 years

Skillsets

  • Redshift
  • Microsoft Office suite
  • PostgreSQL
  • Power BI
  • Predictive Modeling
  • Presto
  • Python
  • Python Automation
  • PyTorch
  • Real-time Data Migration
  • LabVIEW
  • S3
  • Scikit-learn
  • Snowflake
  • Spark
  • SPSS
  • SQL
  • Tableau
  • VBA
  • Data Cleaning
  • AlloyDB
  • Anaplan
  • API
  • automation scripts
  • AWS
  • Azure
  • Azure maps
  • Big Query
  • Dashboarding
  • A/B testing
  • Data Testing
  • Data warehouse
  • ETL processes
  • Excel
  • Forecasting models
  • Google looker studio
  • Hyperion
  • KPI tracking

Vetted For

8Skills
  • Roles & Skills
  • Results
  • Details
  • icon-skill_image
    Oracle ERP Functional Analyst - Finance(Remote)AI Screening
  • 68%
    icon-arrow-down
  • Skills assessed :asian client, Business Analysis, Customization, Data Migration, Finance Module, Oracle ERP E-Business Suit 12.2, Problem Solving Attitude, SQL
  • Score: 34/50

Professional Summary

5Years
  • Mar, 2024 - Present1 yr 9 months

    Senior Data Engineer I

    Kreon Financial Services
  • Nov, 2022 - Feb, 20241 yr 3 months

    Data Engineer

    Apptad
  • Feb, 2021 - Oct, 20221 yr 8 months

    AI Development Engineer

    MEA Platform

Applications & Tools Known

  • icon-tool

    Power BI

  • icon-tool

    Microsoft Excel

  • icon-tool

    PowerPoint

  • icon-tool

    SQL

  • icon-tool

    Excel

  • icon-tool

    ServiceNow

  • icon-tool

    ArcGIS

  • icon-tool

    Azure

  • icon-tool

    MS Excel

  • icon-tool

    Python

  • icon-tool

    PowerBI

  • icon-tool

    Advanced Excel

  • icon-tool

    My SQL

  • icon-tool

    Data Analysis

Work History

5Years

Senior Data Engineer I

Kreon Financial Services
Mar, 2024 - Present1 yr 9 months
    Developed and optimized financial data pipelines using PySpark for distributed data processing and transformation, ensuring efficient handling of large-scale transactional data. Managed and monitored scheduled workflows with AutoSys, leveraging GCP services such as BigQuery for data storage and analysis to support financial reporting and analytics. Built predictive forecasting models using Scikit-Learn and SPSS, enabling accurate cash flow projections and improving strategic planning. Increased team efficiency by 30% by mentoring analysts on Git, ETL development, and dashboarding, while managing delivery cycles via Agile (Scrum).

Data Engineer

Apptad
Nov, 2022 - Feb, 20241 yr 3 months
    Analyzed structured and unstructured data from Azure, improving report accuracy by 35% through advanced Python scripts and SQL query optimization. Delivered 10+ interactive BI dashboards using Power BI, enabling cross-functional insights for product, marketing, and finance, and reducing insight lag time by 30%. Automated high-volume ETL workflows, cutting data processing time by 40%, and increasing team output through Python, SQL, and cloud-based data pipelines.

AI Development Engineer

MEA Platform
Feb, 2021 - Oct, 20221 yr 8 months
    Designed and implemented PySpark-based data pipelines processing over 10TB of financial data daily, improving processing speed by 30%. Utilized GCP BigQuery to optimize query performance, achieving a 40% reduction in data retrieval time.

Major Projects

2Projects

Kreon Financial Dasboard

Mar, 2024 - Jul, 20251 yr 4 months
    Built a high-precision geospatial analytics system using Azure Maps, Python, Snowflake and cloud-based ingestion pipelines to identify fraud-prone zones and drive campaign optimization based on live location insights.

Kreon UPI Dashboard

Oct, 2024 - Feb, 2025 4 months
    Engineered a real-time UPI mandate monitoring pipeline using Python, SQL, Snowflake and Azure, boosting success rates by 15% via anomaly detection and trend analysis.

Education

  • BCA (Computer Applications)

    JRN Rajasthan University (2017)

Certifications

  • Customer relationship management (hp life)

  • Business communication (hp life)

  • Data analysis with power bi & excel (june 2024)

  • The complete introduction to sql 2024

  • Master powerbi 2024

AI-interview Questions & Answers

So, uh, in my recent role at, uh, my app, Ted, I was working as a data analyst, but I was able to maintain, um, cost improve customer retention, uh, in 60% or lead a team to complete project, uh, ahead of schedule. Uh, this experience taught me lot about, uh, my skills, my valuable skills, my problem solving, and which I'm excited to bring to this position. Uh, outside of work, I'm passionate about, uh, mentioning, uh, my, uh, special, uh, skills. I like learning new techniques and monitoring others in my field. As I believe, I closely align, uh, with my career goals, and and and I have a hands on space on working with Oracle E Business suit, uh, R2L, primarily in the areas, uh, like, uh, financial analysis, uh, supply chain, HRMS, etcetera. Uh, over the course of my time working with Oracle EBS, I have gained strong skills in, uh, configuring modules, uh, man managing workflows, creating custom reports, or troubleshooting issues. So, uh, in my previous role at my company, uh, I was responsible for, uh, for various responsibilities, like implementing new modules, optimizing existing processes, uh, supporting, uh, end to end users rule. Uh, one of my key achievements was, uh, being unsuccessful as a rollout and process improvement or cost saving initiative that, uh, involve Oracle EBS, Artwell. Uh, this experience is strengthened my skills in in problems on this case, cross functional collaboration, or also in attention to detail. Initially, I'm familiar with the technical sites of Oracle EBS, uh, including, um, SQL, p SQL, uh, for reporting customization using Oracle, uh, forms or reports or integration with other systems. Uh, I understand the importance of ensuring data integrity and providing accurate reporting, uh, which prioritize my work with Oracle EBS.

So I have significant development experience in Oracle EBS r two, particularly, uh, with the AP, AR, and GN modules. My work has involved, uh, creating custom solutions to meet specific business needs and integrating EBS with other enterprise applications. For, uh, integration projects, I have developed and maintained, uh, APIs and interface to ensure smooth data flow between Oracle EBS and external system. Uh, often using, uh, Oracle API and XML, uh, gateway. Uh, I've also created custom stored procedures for data validation and transformation, which streamline processes and enhance data integrity. Uh, in terms of my personalizing, uh, I have tailored Oracle forms to improve user experience and and align them, uh, with business requirements, adjusting layouts, uh, default values, and adding validations to reduce errors. Uh, I'm proficient in PLSQL, uh, allowing me to build and optimize stored procedures for reporting and data manipulation across the AP, AR, and GL modules. Uh, these customizations have, uh, contributed to more efficient data processing and help teams gain real site insights real time insights.

If you lack experience in development, APARTL, integration projects, form personalization, stored procedures, d f f, custom reports, and configurations. APAR. My strategy for gaining expertise in those areas, uh, is both structured and proactive. Uh, first, I would start with self paced learning with build a foundation. I'd focus on in Oracle EBS, artwork training resources, uh, especially modules on APER and GL, and any available documentation or tutorials on development, form personalization, and integration techniques. Next, I would seek hands on experience as I believe press practical exposure is essential for technical skills. I will start my working on on the small inte internal projects or or environments practicing, uh, tasks like, uh, writing simple PLSQL scripts, um, building sample of forms, or configuration basic API requirements, integrations. This approach will help me gain confidence in a controlled environment. We are working on larger projects. I would also, uh, go out to colleagues and mentors with expertise in these areas to learn best practices, uh, to gain insights from their experiences. Uh, if possible, uh, I would shadow them or relevant, uh, projects to assist them in testing and troubleshooting to gain real site in exposures or insights. And finally, I would committed to continuous learning, uh, staying updated with Oracle's latest, uh, releases, participated participating in online forums, and enrolling in advanced courses. I'm confident that my focused, uh, effort out quickly acquire the necessary skills and and add value to the team.

All the techniques. Uh, for a major Oracle ERP system update, risk identification and mitigation are crucial to ensure smooth and successful rollout. Uh, so basic techniques would be a comprehensive risk assessment and impact analysis. Uh, by starting or by start by conducting a a thorough risk assessment to identify potential issues such as, um, data losses and integration failures or downtime. Uh, engaging stakeholders across departments, uh, help uncover hidden risks, uh, and assessments, uh, how to update it, and that that might impact each model AP, EIGL, analyzing dependencies, and performing, uh, impact analysis, uh, helps prioritize risk based on severity and, like, in likely, uh, likelihood. The second, uh, technique would be the environment of progression and backup strategy. By establishing a robust backup plan including full system of backups before the update and incremental backups throughout. Testing, uh, backups, uh, in source quick recovery in case of failure. Creating a separate testing environment to mirrors, uh, the products and set up, allowing for a safe testing, uh, without, uh, impacting daily operations. The third one, uh, include, uh, the, uh, user acceptance acceptance testing, and that is UAD and stakeholder involvement. Uh, like, uh, engaging, uh, users in UAD, uh, ensures that the update meets business requirements and minimizes user relevant, uh, issues. UOD also gives, uh, users a chance to familiarize themselves with the new features or changes, reducing resistance, and promoting a smoother transaction. And the last one includes the data validation. That's the most important thing I would, uh, rec I would, uh, I would suggest develop scripts or procedures to validate data integrity before, uh, both before and after the update. Reconcile key, uh, data points such as, uh, balance in the GL and the APA, uh, to ensure there's no data corruption or loss of data.