Data Analyst Project Management

RUCHI SINGH

857-***-**** Washington, DC *****.*********@*****.***

https://www.linkedin.com/in/ruchi-singh-30452280/

PROFESSIONAL SUMMARY

Experienced Data Analyst with 8+ years of expertise in migrating SQL databases to Azure cloud solutions, optimizing data management processes, and driving insights. Proficient in SDLC methodologies, adept at ETL tools, and skilled in Agile and Waterfall environments. Strong team player with extensive experience in RESTful web service testing and data mining. Possessing a diverse skill set encompassing project management, programming languages, and a passion for adventure sports and community engagement.

TECHINCAL SKILLS

Proficient in: Python,Java,C++,HTML,CSS,Javascript, SQL,mysql,mongoDB,Oracle, Tableau, R, PHP,Project management tools, MS Visio, MS Office(Word,Excel,Powerpoint)

Certifications: Stanford Advanced Project Management, Stanford; Business English, Cambridge

EXPERIENCE

CHOBANI New York, NY

Senior Data Analyst April 2023 – Present

Conducted comprehensive analysis of both functional and non-functional data elements, utilizing advanced SQL techniques across diverse systems including Postgres, MongoDB, Oracle, and Teradata, resulting in effective data profiling and mapping from source to target environments.

Leveraged data investigation and mapping tools to meticulously scan and process data records from various sources, ensuring accuracy and completeness in data management processes.

Spearheaded development and implementation of Extract, Transform, Load (ETL) pipelines, employing Azure Data Factory, T-SQL, Spark SQL, and U-SQL, facilitating seamless data migration to Azure Data Storage services and enhancing overall data accessibility and integrity.

Designed and executed modern data solutions on Azure PaaS, facilitating data visualization and analysis, meticulously assessing the impact of new implementations on existing business processes, ensuring optimal functionality and efficiency.

Demonstrated proficiency in API development and integration, including design and implementation of SOAP and REST APIs using Azure API apps, streamlining data retrieval processes, enhancing overall system interoperability.

Played a key role in development and optimization of Spark applications for data extraction, transformation, and aggregation, while actively managing Spark Databricks clusters, ensuring optimal performance and scalability.

MORPHIS TECHNOLOGIES Washington, DC

Senior Data Analyst September 2019 – June 2022

Conducted thorough data investigations utilizing advanced data discovery and mapping tools, meticulously scanning data record from diverse sources, ensuring comprehensive data coverage

Expertly analyzed functional and non-functional data elements, employing sophisticated techniques to profile and map data from source to target environments. Developed comprehensive documentation to support findings and facilitate task assignment, ensuring clarity and alignment across project teams

Utilized complex SQL queries to perform in-depth data analysis and profiling across a multitude of systems, including Postgres, MongoDB, Oracle, and Teradata, enabling actionable insights and informed decision-making.

Led the Extract, Transform, and Load (ETL) processes, leveraging a blend of Azure Data Factory, T-SQL, Spark SQL, and U-SQL to seamlessly transfer data from source systems to Azure Data Storage services. This optimized data accessibility and reliability, enhancing overall data management efficiency.

Spearheaded the design and implementation of modern data solutions on Azure PaaS, facilitating data visualization and analysis. Evaluated the current production state of applications to assess the impact of

MPOWER SOLUTIONS India

Data Analyst July 2013 – September 2019

Facilitated collaborative technical requirements gathering and project coordination through team meetings and Joint Application Development (JAD) sessions with Business Analysts and DBAs, ensuring alignment and clarity throughout project lifecycle.

Orchestrated architecture and implementation of scalable BI solutions on Azure, leveraging Azure Data Platform services to empower data-driven decision-making and streamline business operations.

Led design discussions to define optimal Data Mart structures, meticulously considering granularity and dimensionality to maximize data insights and usability.

Spearheaded migration strategies for legacy systems onto Azure, employing a range of techniques including Lift and Shift and Azure Migrate, while optimizing cost-efficiency and performance.

Developed and advocated architectures that balanced cost considerations with data infrastructure requirements on Azure, delivering tailored recommendations to optimize resource allocation.

Engineered complex distributed systems for efficient data handling and analytics, orchestrating end-to-end data pipelines and ensuring robustness in data processing and analysis.

EDUCATION

THE GEORGE WASHINGTON UNIVERSITY, School of Business Washington, DC

Master of Science, Information Systems Technology May 2024

DEVI AHILYA UNIVERSITY, Institute of Management Studies Indore, India

Master of Business Administration December 2002

DEVI AHILYA UNIVERSITY, MKHS Gujrati Girls College Indore, India

Bachelor of Science, Commerce December 1999

ADDITIONAL INFORMATION

Global View: Languages: English (Fluent), Hindi (Fluent), Visited 50+ countries

Volunteer: Mentor Indian Institute of Management Indore India, Volunteer with the International Monetary Fund

Interests: Skydiving; Kayaking; Helmet Diving; Parasailing; Connecting with People

Contact this candidate