Ayushi Patel
Leesburg,VA
Summary
Experienced Software and Data engineer who has worked on companywide analysis projects using financial, product, and customer behavior datasets. Open mind to adapt to changing software release schedules and ability to multitask in a fast-paced environment. Having the ability to deliver valuable insights via analytics and advanced data-driven methods. Fast learner, problem solver, and detail-oriented seeking for a higher-level opportunity to build a career in the same field.
Overview
5
5
years of professional experience
Work History
Senior Software Engineer - Data Engineer
HCL America, Inc.
02.2022 - Current
- Client: Ocean Spray
- Data Engineering & Analytics: Compiled, cleaned, and analyzed complex datasets to deliver actionable business insights, improve processes, and enhance infrastructure scalability
- Technical Expertise: Proficient in SSIS, SQL Server Management Studio, Power BI, AWS, Snowflake, and SAP for data retrieval, manipulation, quality assurance, and reporting
- ETL & Data Architecture: Designed, implemented, and maintained ETL processes, aligning with data architecture and modeling requirements to optimize data pipelines and workflows
- Performance Optimization: Specialized in SQL performance tuning, data validation, and end-to-end process optimization for efficient and seamless data operations
- Big Data & Forecasting: Hands-on experience with Big Data technologies and forecasting concepts, supporting decision-making and strategic initiatives
- Stakeholder Collaboration: Effectively communicated complex insights to non-technical stakeholders, driving strategic decisions and operational performance improvements
- Key Achievements: Managed and supported data pipelines, ensuring smooth data flow And integrity across vendor applications such as o9, Blue Yonder, Vena, and Blacksmith. Automated manual workflows and redesigned infrastructure to improve scalability and performance
- Collaborated with cross-functional teams (engineering, program management, and finance) to identify and address data needs, ensuring timely project delivery
- Mentored junior developers, providing technical guidance, and ensuring adherence to best practices and quality standards
- Monitored business initiatives, evaluating them against performance indicators and presenting recommendations to management
- Enhanced processes for financial and forecasting applications, leveraging tools like Vena And Blue Yonder for robust decision-making support
- Tools & Technologies: Data Platforms: SQL Server, AWS, Snowflake, SAP; ETL & Analytics: SSIS, Power BI, Excel; Collaboration: SharePoint, PowerPoint; Core Skills: ETL, Data Warehousing Architecture, Forecasting, Workflow Management, and Financial/Mathematical Modeling
- By streamlining data processes and fostering collaboration, successfully contributed to enhanced business insights, operational efficiency, and scalable infrastructure
Data Analyst 1
Titan Technologies
11.2020 - 01.2022
- Client - BLS (Bureau of Labor Statistics)
- Data Processing & Analysis: Managed respondent files to collect, analyze, edit, and code monthly and quarterly employment and wage data while adhering to BLS-approved data quality procedures
- Automation Development: Designed and implemented automation strategies to streamline data processing workflows, enhancing efficiency and accuracy
- Data Management: Processed data files into BLS-approved software applications and databases, ensuring compliance with established standards
- Stakeholder Collaboration: Responded to data-related inquiries from state employment agencies by conducting research and drafting comprehensive correspondence
- Problem Resolution: Delivered complete and timely information on problem cases and solutions through customer 's web-based system, meeting BLS production timing requirements
- Tools & Technologies: SQL Server, R, SAS, Excel, BLS-approved software
- Successfully optimized data workflows ensured compliance with federal standards and supported accurate reporting of labor statistics for decision-making and policy formulation
Business Analyst
Kevadiya Inc.
01.2020 - 11.2020
- Reporting & Analysis: Created and analyzed ad hoc reports to support application performance reviews and provide actionable insights for stakeholders
- Quality Assurance & Testing: Worked closely with the QA team to validate test cases, write unit and integration tests, and execute automation testing to ensure application reliability and accuracy
- Agile Project Management: Partnered with Scrum Master to support technical design documentation and organized tasks in JIRA to streamline Agile development and QA workflows
- Requirement Analysis & Documentation: Collaborated with clients to gather and analyze requirements, translating them into deliverables such as user stories, functional specifications, workflow diagrams, and data flow models
- Designed API specifications and schemas for various projects, aligning with business and technical requirements
- Tools & Technologies: Workflow Diagrams, API Schema, JIRA, Automation Testing, Unit Testing, Integration Testing
- Played a key role in bridging gap between business needs and technical execution, ensuring project delivery aligned with client expectations while supporting Agile development processes
Education
Master's - Computer Science
Illinois Institute of Technology
Chicago, Illinois05.2019
B.Tech - Information Technology
Nirma University
05.2017
Skills
- Areas of Interest: Data/Business Analytics, Big Data, Software Engineering, QA, User stories, testing, Statistics, Visualization, ETL
- Technology: R, Python, HTML, CSS, ggplot2, Snowflake, Microsoft Excel, Tableau, Linux, R Studio, Jupyter Notebook, Jira
- Database: SQL/MySQL, RDBMS, Oracle, NoSQL
Coursesandvolunteering
Data Visualization with ggplot2, Introduction to Data and R, Python, Snowflake Data Cloud, Tableau, Power BI (Exam certification of Analyzing, Data with Microsoft Power BI), Information Retrieval Technology, Computational Advertising, Software System Architecture Software Project, Management. Volunteer at IEEE Student Branch, Technical Event Coordinator at The National Level NU-Tech’15, India
Timeline
Senior Software Engineer - Data Engineer
HCL America, Inc.
02.2022 - Current
Data Analyst 1
Titan Technologies
11.2020 - 01.2022
Business Analyst
Kevadiya Inc.
01.2020 - 11.2020
Master's - Computer Science
Illinois Institute of Technology
B.Tech - Information Technology
Nirma University
Similar Profiles
Navid MashhadiNavid Mashhadi
Sr.Technical Lead/Program Manager at HCL America, Inc.Sr.Technical Lead/Program Manager at HCL America, Inc.
Marcy GonzalesMarcy Gonzales
IT Help Desk Support at HCL America, Inc.IT Help Desk Support at HCL America, Inc.
Sudhanshu ShekharSudhanshu Shekhar
Director at HCL Technologies/HCL America Inc.Director at HCL Technologies/HCL America Inc.