SHALINI KHANDUJA
Phoenix,Arizona
Summary
- Senior Data Analyst with over 6 years of experience in comprehensive data analysis, data modeling and data visualization. Skilled in SQL, DWH, and Power BI. Demonstrates exceptional analytical capabilities to drive informed decision-making processes. Expertise in transforming complex data sets into actionable insights that drive business decision making.
- Strong IT industry experience at Tata Consultancy Services,Hewlett Packard GlobalSoft Pvt. Ltd. and Infosys.
- Have a proven track record of managing complex projects to successful completion while ensuring stringent SLA adherence.
- Practiced Software Engineering Processes at CMM Level5.
- Also have Expertise in writing complex SQL queries for data validation.
- Have sound knowledge in Incident/Problem Management, Change Management, SLA Management, Deployments, and Configuration Management.
- Analytical skills including identifying, forecasting and resolving problem.
- Good hands on experience in Oracle, PL/SQL and UNIX. Command on database tools like SQL server, Toad for Oracle.
- Have in-depth understanding of SDLC. Worked for the projects that undergone all the phases of SDLC.
- Ability to be a team player with excellent interpersonal skills.
Overview
15
15
years of professional experience
Work History
Data Analyst
Tata Consultancy Services
04.2022 - 03.2023
- Developed a comprehensive dashboard to monitor and analyze sales performance across regions and products. Tools Used: Power BI, SQL, Excel.
- Created and Utilized SQL queries to extract relevant data from multiple sources for reporting and analysis purposes.
- Developed and maintained interactive Power BI dashboards to monitor key performance indicators (KPIs) across various departments.
- Utilized Microsoft Excel to generate reports and graphs based on complex datasets.
- Analyzed data trends and created visualizations for management review.
- Implemented visualizations and dashboards to help senior management make informed decisions.
- Reviewed large amounts of data across multiple platforms and sources to determine operational impacts and needed actions.
- • Designed and deployed Power BI dashboards that enhanced visibility into key business metrics, increasing operational efficiency by 20%.
- Provided technical support for existing reports, dashboards, and other tools.
- Generated standard and custom reports to summarize business, financial, and economic data.
- Trained team members on Power BI best practices and dashboard utilization.
Senior Developer/Engineer
Hewlett Packard GlobalSoft Pvt. Ltd.
07.2011 - 03.2013
- Worked as Senior developer for SDLCM application
- Attending daily meeting for requirement with domain teams
- Complete Analysis of the new enhancements/Release changes
- Prepare design documents and write the code changes for system design
- Responsible for complete end-to- end test cycle from Requirement gathering till defect fixing
- Write SQL queries, generate mappings for data loading and generate end user reports and publish the same
- Design SQL scripts to quickly set up data for load testing
- Extensively involved in test plan/test case preparation
- Performing complete Unit and System testing
- Completely involved in Defect life cycle
- Preparing Traceability Matrix at the end of the SIT cycle
Senior Database Dev
Ferminich
01.2011 - 07.2011
- Responsible for data migration,loading,validation and report generation
- Create design document and ETL mappings to load the data
- Handled vendor master object data conversion for FIRMENICH
- Dealing with third party to gain knowledge about complex logic to generate FSA Reports independently and thus removing dependency on third party
- Verification of generated reports with the reports sent by client
- Responsible for Production Support and maintenance activities
- Involved in Unit, System and Integration Testing
- Worked as a DPL(Defect Prevention)anchor to analyze the root cause of defects found in various project stages Documentation of various project artifacts and knowledge transfer to other team members
System Engineer
TELSTRA
01.2008 - 01.2011
- Handling the CONNECT applications revolving around Asset center
- Responsible for fixing and testing any Production issue/enhancement coming in these applications
- Requirement gathering, analysis, design, development, testing and deployment of new enhancements
- Extensively involved in test planning/test case preparation, unit, system, performance and load testing
- Design SQL scripts to quickly set up data for load testing
- SIT Testing for various applications Handling the responsibility of Configuration Controller
- Successful delivery of various daily, weekly and monthly reports Anchoring defect prevention activities, create DP plan in order to ensure quality adherence and to ensure that project is adhering to the configuration management plan
- Design and developed critical Archival and Data Retention work request for removing obsolete/orphan data
Education
B.Tech. - Information Technology
A.K.G.E.C.
India05.2007
High school - CBSE
K.V. IFFCO
Bareilly, U.P.03.2002
Intermediate - CBSE
K.V. IFFCO
Bareilly, U.P.03.2000
Skills
- Microsoft Power BI
- Tableau
- SQL ,Data analysis, Data Cleaning,Excel functions
- Data visualization and presentations
- Oracle 9i/10g, SQL Server 2016,SQL,PL/SQL,HQL
- Agile methodologies
- ETL Testing, Web based Testing, Postman
- Incident/Problem Management
- Quality Center,QTP,JIRA
- SLA Management and Change Management
- Toad90 for Oracle, Mercury Quality Center/ALM, QTP, Caliber, Informatica
- WINDOWS2008/2012, UNIX
- Project and portfolio management tools
Timeline
Data Analyst
Tata Consultancy Services
04.2022 - 03.2023
Senior Developer/Engineer
Hewlett Packard GlobalSoft Pvt. Ltd.
07.2011 - 03.2013
Senior Database Dev
Ferminich
01.2011 - 07.2011
System Engineer
TELSTRA
01.2008 - 01.2011
High school - CBSE
K.V. IFFCO
Intermediate - CBSE
K.V. IFFCO
B.Tech. - Information Technology
A.K.G.E.C.
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Elias MercadoElias Mercado
Lifeguard/SSI at City of Phoenix Aquatics DivisionLifeguard/SSI at City of Phoenix Aquatics Division