Data Analyst Processing

NIKKI RASTOGI

***********@*****.*** +1-347-***-**** New York, NY GitHub

PROFESSIONAL SUMMARY

Data Analyst with 4+ years of experience specializing in database management, data processing, and reporting for enterprise environments. Core expertise in PL/SQL development, Oracle Exadata and Oracle 10g, with a strong background in designing and optimizing complex queries and stored procedures to support large-scale data initiatives. Proficient in modern data stack tools including Snowflake, PySpark, Apache Airflow, and dbt for ETL and workflow orchestration. Highly skilled in data validation, integration testing, and scenario design, ensuring seamless system integration and reliable delivery of business requirements. Adept at utilizing Microsoft Office Suite for comprehensive reporting and analysis, and experienced in Agile Scrum teams managing work prioritization, sprint planning, and story estimation. Recognized for precise analytical thinking, clear communication across both technical and business audiences, and the ability to manage multiple projects efficiently in fast-paced environments.

TECHNICAL SKILLS

Databases: Oracle Exadata, Oracle 10g, Snowflake

Agile & Testing Tools: Agile Scrum, Test Scenario Design, User Story Mapping, Backlog Prioritization, Sprint Planning, Proof of Concept Development, Validation Testing, Integration Testing, Story Estimation

Data Processing & ETL: PL/SQL, PySpark, Apache Airflow, dbt

Data Analysis & Reporting: Microsoft Excel, Pivot Tables, PowerPoint

Programming & Query Languages: SQL

Productivity & Documentation Tools: Microsoft Word, Microsoft Office Suite

WORK EXPERIENCE

TensorStax, Data Analyst Jan 2024 - Present

●Developed and tuned complex PL/SQL queries and stored procedures to support data extraction, transformation, and analysis across large-scale data sets in Oracle Exadata environments.

●Built and optimized PySpark jobs for both batch and incremental data processing pipelines, ensuring efficient movement and transformation of structured data required for analytics and reporting tasks.

●Created and maintained detailed documentation of pipeline logic, data lineage, and metadata using Microsoft Office tools, supporting clear communication with technical and business stakeholders.

●Analyzed data quality and pipeline performance by designing validation tests and monitoring workflows, addressing issues proactively to maintain reliable end-to-end data delivery.

●Designed dbt workflows with custom macros and tests to transform and validate data models, supporting accurate insights for business users and downstream applications.

●Developed and scheduled Apache Airflow DAGs to manage dependencies between hundreds of ETL tasks, improving visibility and control over data processing workflows.

●Utilized advanced SQL and PL/SQL skills to identify data discrepancies, troubleshoot pipeline failures, and ensure integrity across multiple environments including Snowflake and Oracle databases.

●Participated in Agile scrum ceremonies, contributing to story refinement, estimating work, and prioritizing backlog items to meet evolving business requirements.

●Used Microsoft Excel and PowerPoint to present analytical findings and pipeline health summaries to both technical and non-technical audiences, supporting data-driven decision making.

●Supported team members by answering questions, sharing best practices, and assisting with complex query writing, helping to maintain a collaborative and productive work environment.

CIBC, Data Engineer Jul 2020 - Mar 2023

●Developed and maintained PL/SQL queries and stored procedures in Oracle 10g and Exadata to support analysis and data retrieval for wholesale credit and KYC onboarding processes.

●Designed test scenarios and validated integration of new data solutions within enterprise financial applications, ensuring seamless and well-documented interfaces across multiple business systems.

●Created and updated business requirement documents, user stories, and functional specifications using Microsoft Word, Excel, and PowerPoint for wholesale banking initiatives.

●Analyzed end-to-end data flows across client onboarding and credit risk applications, connecting multiple internal and third-party systems to provide a comprehensive business view.

●Participated in Agile scrum ceremonies, guiding the team through story estimation, backlog prioritization, and sprint planning for compliance-related technology projects.

●Developed solutions to automate validation and reconciliation of client onboarding data, improving accuracy and reducing manual intervention in regulatory KYC processes.

●Used advanced Excel functions and pivot tables for financial and operational analysis, preparing detailed executive summaries and visual presentations for both technical and non-technical stakeholders.

●Built proof-of-concept data models to assess feasibility and risk of new compliance requirements, incorporating innovative approaches to address evolving regulatory demands.

●Identified project priorities and managed multiple deliverables simultaneously, balancing urgent business needs with long-term strategic goals in a fast-paced banking environment.

●Provided guidance and support to team members on PL/SQL best practices, query optimization, and troubleshooting complex data issues within Oracle banking systems.

EDUCATION

Master’s in Data Analytics and Visualization

Yeshiva University 3.8

Bachelor of Technology in Computer science Engineering

Ajay Kumar Garg Engineering College 3.4

CERTIFICATIONS

AWS Certified Data Engineer – Associate

AWS Certified Solutions Architect – Associate

AWS Certified AI Practitioner

dbt Fundamentals Certified

Contact this candidate