Sneha Konduri
Toongabbie,NSW
Summary
To associate myself with an esteemed organization where there is an opportunity to share, contribute knowledge for the growth of the organization and to expand my potential to the maximum
Overview
10
10
years of professional experience
Work History
Technical Lead/ Data Engineer
HCL Australia Services Pty Limited
06.2022 - 07.2023
- Leading a team of data analysts in collecting and analysing large datasets from multiple sources using SQL and Python
- Developing complex SQL queries to retrieve, transform, and aggregate data, resulting in streamlined reporting processes and improved data accuracy
- Mentoring junior data analysts, providing guidance on data analysis techniques, SQL optimization, and Python programming
- Conducting in-depth data analysis on customer behaviour, market trends, and product performance using SQL and Python
- Developing and implementing data cleaning and pre processing techniques to ensure data accuracy and consistency
- Creating interactive dashboards and reports using Qlik Sense and Halo, presenting key insights and recommendations to the executive team
- Utilizing advanced Excel functions and pivot tables to analyse sales data and identify opportunities for revenue growth
- Assisting in data collection and validation processes, ensuring data quality and integrity
- Supporting data analytics team in creating SQL queries to extract and transform data for reporting purposes
- Developing and maintaining databases, data systems – reorganizing data in a readable format
- Removing corrupted data and fixing coding errors and related problems
- Working with programmers, engineers, and management heads to identify process improvement opportunities, propose system modifications, and devise data governance strategies
- Filter Data by reviewing reports and performance indicators to identify and correct code problems
- Preparing reports for management stating trends, patterns, and predictions using relevant data
- Preparing final analysis reports for stakeholders to understand data-analysis steps, enabling them to take important decisions based on various facts and trends
- Design, construct, install, and maintain large-scale processing systems
- Set up and maintain data architectures, including databases and large-scale processing systems
- Ensure systems meet business requirements and industry practices
- Design and implement database schemas, tables, procedures, and permissions
- Create and manage ETL processes that pull data from various sources
- Ensuring the ETL processes are efficient, reliable, and transparent
- Maintain data pipelines and ensure timely data flow from various sources to the warehouse
- Utilize various ETL tools and platforms to fetch data from different sources
- Implement measures to ensure data security and data quality.
Data Analyst
Cognizant India
03.2016 - 01.2019
- Supports production and enhancement tickets raised by users on Visual Basic Application (VBA) and SQL
- Generates reports (Excel and PPT's) in innovative and effective way by taking the data from SAP BW excel version tool
- Resolved queries within SLA (Service Level Agreement)
- Designing database schema, create tables to store data, and perform data manipulation
- Reporting regularly to the customer via daily, weekly, and monthly status reports
- I have automated many tasks by using VBA which saved time and money
- Creating Standard Operating procedure for reports
- Worked on SAP BW to extract data
- Identified and collected additional information critical to decision making as necessary and explains needs through contact with external constituents within established time frames where applicable, region specific
- Cleaning and transforming massive data into useful and insightful to specific teams
- Outbound phone calls from members regarding general/specific questions or status of new business submissions
- Developed and maintained multiple databases using VBA and MS Excel
- Perform numerical analysis and data manipulation by using Python programming
- Liaise with internal and external stakeholders.
- Designed and implemented tools to support strategic value chain optimization initiatives.
- Optimized company resources allocation with detailed forecasting models based on historical data analysis.
Data Analyst
Genpact India
06.2013 - 03.2016
- Delivered reports and dashboards using the analytical skills to track and forecast trends enhance revenues
- Used the analytical skills to track and forecast trends enhance revenues
- Analyzed and provide business solutions to help enterprise users make better business decisions
- Provided accurate benefit explanations to groups as requested
- Handled a variety of task and resolved with expediency
- Analyze and provide business solutions to help enterprise users make better business decisions
- Collaborating with Project Leads and IT team to resolve issues and ensuring solutions are viable and consistent
- To work Independently and team with users to define concepts and under direction of project managers
- Used Advanced Excel capabilities, including pivot tables, lookups, complex formulas and graphing to streamline business processes
- Developed 30 Excel macros using VBA to streamline and accelerate project completion
- Created comprehensive project reports using MS Excel, MS Power-point and VBA
- Responsible for developing VBA macros to automate repetitive tasks
- Created automated reporting systems to improve strategic planning and analysis.
Education
Master of Technology (Software Engineering) -
Federation University – IIBIT
Sydney, Australia06.2023
Bachelor of Technology (Electronics & Communications Engineering) -
Jawaharlal Nehru Technological University
Hyderabad, India04.2012
Board of Intermediate Education -
Sri Chaitanya Junior College
Hyderabad, India03.2008
Skills
- SQL
- ETL
- Qlik Sense
- Halo
- VBA
- Macros
- Microsoft Office (Word, Excel, PowerPoint, Access)
- HTML
- Python
- Java Script
Attributes
- Ability to work under pressure
- Decision making
- Time Management
- Self – motivation
- Conflict Resolution
Extra Academic Activities
- Worked as HR catalyst at Cognizant and Genpact (Celebrating Birthdays of all team members, events, Festivals)
- Anchored and conducted events in Cognizant, college, and school
- Received 2nd prize in Rangoli competition held in cognizant
- Presented paper presentation at SLC's Institute of Engineering & Technology in B-Tech 4th yr., CBIT (Chaitanya Bharathi Institute of Technology) & HITAM (Hyderabad Institute of Technology & Management) 2011 in B-Tech 3rd yr., CMR institute of technology 2010 in B-Tech 2nd year, Avanti Institute of Technology 2009 in B-Tech 1st year
References
References will be furnished upon request
Timeline
Technical Lead/ Data Engineer
HCL Australia Services Pty Limited
06.2022 - 07.2023
Data Analyst
Cognizant India
03.2016 - 01.2019
Data Analyst
Genpact India
06.2013 - 03.2016
Master of Technology (Software Engineering) -
Federation University – IIBIT
Bachelor of Technology (Electronics & Communications Engineering) -
Jawaharlal Nehru Technological University
Board of Intermediate Education -
Sri Chaitanya Junior College
Similar Profiles
Gerald Cyril Pereira LGerald Cyril Pereira L
SR. Manager at HCL AUSTRALIA SERVICES PTY LTDSR. Manager at HCL AUSTRALIA SERVICES PTY LTD
Anurag JaiswalAnurag Jaiswal
Technical Business Analyst at HCL Australia Services Pty LtdTechnical Business Analyst at HCL Australia Services Pty Ltd
Philip FarhartPhilip Farhart
Senior Account Manager at Sofico Services Australia Pty LimitedSenior Account Manager at Sofico Services Australia Pty Limited