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

    Reporting Data Engineer I

  • Years of Experience

    6 years

Skillsets

  • S3
  • PostgreSQL
  • Power BI
  • Predictive Modeling
  • Presto
  • Python
  • Python Automation
  • PyTorch
  • Real-time Data Migration
  • Redshift
  • LabVIEW
  • Scikit-learn
  • Snowflake
  • Spark
  • SPSS
  • SQL
  • Tableau
  • VBA
  • Microsoft Office
  • 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

6Years
  • Mar, 2024 - Present2 yr 3 months

    Reporting Data Engineer I

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

    Senior Data Engineer

    Apptad
  • Feb, 2020 - Oct, 20222 yr 8 months

    AI Development Analyst

    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

6Years

Reporting Data Engineer I

Kreon Financial Services
Mar, 2024 - Present2 yr 3 months
    Developed and optimized financial data pipelines using PySpark for distributed data processing and transformation, ensuring efficient handling of large-scale transactional data. Designed and developed interactive dashboards and visualizations using Amazon QuickSight to provide actionable insights for business stakeholders. Built predictive forecasting models using Gen AI and SPSS, enabling accurate cash flow projections and improving strategic planning and Project Management. Automated data preparation and implemented advanced analytics features, improving reporting efficiency and decision-making processes.

Senior 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 Analyst

MEA Platform
Feb, 2020 - Oct, 20222 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 Dashboard

Mar, 2024 - Jul, 20251 yr 4 months
    Built a high-precision geospatial analytics system using Gen AI, 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

In my recent role at my app, Ted, I was working as a data analyst, but I was able to maintain cost improvements and increase customer retention by 60%. I led a team to complete a project ahead of schedule. This experience taught me a lot about my valuable skills, my problem-solving abilities, and which I'm excited to bring to this position. Outside of work, I'm passionate about mentioning my special skills. I like learning new techniques and monitoring others in my field. As I believe, I closely align with my career goals, and I have hands-on experience working with Oracle E Business Suite, R2L, primarily in the areas of financial analysis, supply chain, HRMS, etc. Over the course of my time working with Oracle EBS, I have gained strong skills in configuring modules, managing workflows, creating custom reports, and troubleshooting issues. In my previous role at my company, I was responsible for various responsibilities, including implementing new modules, optimizing existing processes, and supporting end-to-end users. One of my key achievements was being part of a rollout and process improvement or cost-saving initiative that involved Oracle EBS, Artwell. This experience strengthened my skills in cross-functional collaboration and attention to detail. Initially, I'm familiar with the technical aspects of Oracle EBS, including SQL, PL/SQL, and using Oracle forms or reports for customization and integration with other systems. I understand the importance of ensuring data integrity and providing accurate reporting, which is why I prioritize my work with Oracle EBS.

So I have significant development experience in Oracle EBS R2, particularly with the AP, AR, and GL modules. My work has involved creating custom solutions to meet specific business needs and integrating EBS with other enterprise applications. For integration projects, I have developed and maintained APIs and interfaces to ensure smooth data flow between Oracle EBS and external systems. Often using Oracle API and XML gateway. I've also created custom stored procedures for data validation and transformation, which streamline processes and enhance data integrity. In terms of personalization, I have tailored Oracle forms to improve user experience and align them with business requirements, adjusting layouts, default values, and adding validations to reduce errors. I'm proficient in PL/SQL, allowing me to build and optimize stored procedures for reporting and data manipulation across the AP, AR, and GL modules. These customizations have contributed to more efficient data processing and helped teams gain real-time insights.

If you lack experience in development, APARTL integration projects, form personalization, stored procedures, custom reports, and configurations, APAR. My strategy for gaining expertise in those areas is both structured and proactive. First, I would start with self-paced learning to build a foundation. I'd focus on Oracle EBS training resources, 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 practical exposure is essential for technical skills. I would start working on small internal projects or environments, practicing tasks like writing simple PL/SQL scripts, building sample forms, or configuring basic API requirements and integrations. This approach will help me gain confidence in a controlled environment before working on larger projects. I would also go out to colleagues and mentors with expertise in these areas to learn best practices and gain insights from their experiences. If possible, I would shadow them on relevant projects to assist them in testing and troubleshooting, gaining real-world insights and exposures. Finally, I would commit to continuous learning, staying updated with Oracle's latest releases, participating in online forums, and enrolling in advanced courses. I'm confident that my focused effort will quickly acquire the necessary skills and add value to the team.

All the techniques for a major Oracle ERP system update, risk identification and mitigation are crucial to ensure smooth and successful rollout. So, basic techniques would be a comprehensive risk assessment and impact analysis. By starting or by starting a thorough risk assessment to identify potential issues such as data losses and integration failures or downtime. Engaging stakeholders across departments helps uncover hidden risks, assess how to update it, and that might impact each model, analyzing dependencies, and performing impact analysis helps prioritize risk based on severity and likelihood. The second technique would be the environment of progression and backup strategy. By establishing a robust backup plan including full system backups before the update and incremental backups throughout. Testing backups in source quick recovery in case of failure. Creating a separate testing environment to mirror the product, set up allowing for a safe testing without impacting daily operations. The third one includes user acceptance testing and stakeholder involvement. Engaging users in UAT ensures that the update meets business requirements and minimizes user-related issues. UAT also gives users a chance to familiarize themselves with the new features or changes, reducing resistance and promoting a smoother transition. And the last one includes data validation. I would suggest developing scripts or procedures to validate data integrity before and after the update. Reconcile key data points such as balances in the GL and the AP to ensure there's no data corruption or loss of data.