Neha Lingampally
Guelph,ON
Summary
Result driven Business Analyst with over 4 years of experience in SAP technology projects and a strong background in IT business processes, data modeling, and workflow visualization. Expertise in translating business requirements into technical specifications, collaborating with stakeholders, and driving IT process improvements. Experienced in CPG, Distribution, and Retail industries, with a focus on delivering efficient IT solutions.
Overview
6
6
years of professional experience
1
1
Certification
Work History
Data Analyst Intern
Clarke & Khan Consulting Inc
Guelph, ON
05.2024 - 08.2024
- Analyzed large datasets to uncover trends, patterns, and actionable insights, contributing to strategic decision-making.
- Designed and maintained dashboards and reports using tools like Tableau and Power BI to visualize key performance metrics.
- Conducted data cleaning, transformation, and validation processes using Excel, SQL, and Python to ensure data accuracy.
- Collaborated with cross-functional teams to understand business requirements and provide data-driven recommendations.
- Assisted in developing predictive models and performing statistical analysis to support forecasting and business planning.
- Automated data collection and reporting processes, reducing manual effort and improving efficiency.
- Documented data workflows and created user guides for internal stakeholders.
- Presented findings to stakeholders through clear and concise visualizations, ensuring actionable outcomes.
Process Developer
Genpact India Private Limited
Hyderabad, Telangana
11.2018 - 12.2022
Process: Hyatt Select & Full Hotels
Role: Financial Accountant
- Handled AP and AR for Hyatt Hotels under P2P and O2C processes, focusing on procurement, supplier accounts, and customer management.
- Reconcile assets, liability and capital accounts approximately 200 accounts using Excel sheets and submit those recons using Black-line (Reporting tool) every month.
- Prepare journal entries required after reconciling the accounts, during month ends using Oracle EBusiness Suite (ERP Software) and SAP FICO.
- R2R experience including bank reconciliations.
- Handled aging items from AP and AR and any issues by coordinating with clients via calls, chats, and emails.
Process: Johnson & Johnson
Role: Tableau Developer
- Designed, developed, and maintained interactive Tableau dashboards to visualize complex datasets, enabling data-driven decision-making across departments.
- Leveraged SQL to extract, transform, and load (ETL) data from various relational databases, ensuring high data integrity and performance optimization.
- Utilized Python for data cleaning, preprocessing, and advanced analytics, including predictive modeling and automation tasks.
- Collaborated with cross-functional teams to gather and translate business requirements into effective visual analytics solutions.
- Conducted comprehensive data analysis to identify trends, insights, and actionable recommendations, supporting strategic initiatives.
- Automated workflows using Python scripts, significantly reducing manual effort and improving reporting accuracy.
Education
Post Graduate Diploma - Information Technology Business Analysis
Conestoga College
Guelph04.2024
Bachelors of Commerce - Information Technology
St. Joseph's Degree And PG College
King Koti, Hyderabad, India05.2018
Skills
- SAP ERP module: FICO
- Programming Language: Python, C, C#
- Data Visualization Tools: Tableau, Power BI
- Microsoft Office Suite: Word, Excel (Power Query), PowerPoint, SharePoint, Visio
- Tools: JIRA, Oracle E-Business Suite
- Reporting Tool: Black-line
- Database: SQL
Certification
- Microsoft Excel: Data Visualization w/ Excel Charts & Graphs
- Statistics for Data Science and Business Analysis
Affiliations
VOLUNTEER — City of Guelph
Guelph, ON, April 2023 - June 2023
- Proactively introduced myself to children/youth participants at the beginning of each session to establish rapport and create a welcoming environment.
- Followed established routines and guidelines set by group facilitators to ensure smooth and consistent operation of the program.
- Demonstrated specific skills or actions, such as kicking a soccer ball, as requested by facilitators to help participants understand and engage in activities.
Project Title: IT Workflow Optimization for a Retail Chain
Objective: Streamlined IT workflows and enhanced system efficiency for a hypothetical retail chain by designing a process improvement plan based on stakeholder requirements.
Key Tasks and Deliverables:
- Collaborated with peers to gather business requirements through surveys and stakeholder interviews, focusing on IT processes related to inventory management.
- Developed process flow diagrams and IT workflow visualizations using tools like Microsoft Visio to highlight inefficiencies.
- Created detailed technical specifications and user stories, translating business needs into actionable IT solutions.
- Performed data analysis using SQL to identify patterns and bottlenecks in the existing workflow, presenting insights through dashboards.
- Modeled various process improvement scenarios to demonstrate potential benefits and shared findings with stakeholders in a formal presentation.
- Prepared comprehensive documentation, including business requirement documents (BRD) and training materials for the proposed system enhancements.
- Tested the new IT workflow using mock data and created test cases to ensure the solution met predefined business objectives.
Tools Used:
- Microsoft Visio for process mapping
- SQL for data analysis
- PowerPoint for presenting deliverables
- Excel for data modeling and reporting
Outcome:
The project highlighted the importance of aligning IT workflows with business objectives, reducing inventory processing time by 15% in the proposed scenario.
Timeline
Data Analyst Intern
Clarke & Khan Consulting Inc
05.2024 - 08.2024
Process Developer
Genpact India Private Limited
11.2018 - 12.2022
Post Graduate Diploma - Information Technology Business Analysis
Conestoga College
Bachelors of Commerce - Information Technology
St. Joseph's Degree And PG College
Similar Profiles
Melissa CorreiaMelissa Correia
Senior CSR/Senior Recruiter at SR Clarke Consulting ServicesSenior CSR/Senior Recruiter at SR Clarke Consulting Services
Faiz YarKhanFaiz YarKhan
Managing Principal – EPMO Consulting Practice at Yar Khan ConsultingManaging Principal – EPMO Consulting Practice at Yar Khan Consulting
JOSE REYESJOSE REYES
IT Support Specialist at Clarke Consulting IncIT Support Specialist at Clarke Consulting Inc