Thotapalli Suma Deepthi
Aberdeen,UNITED KINGDOM
Summary
Having 4+ years of experience in IT industry and 4.2 years of Experience in Business Intelligence tools such as Tableau Desktop, Tableau Server, Power BI and Alteryx Designer and SQL, hands-on experience in Data Modelling, Data profiling, Python, data warehouse concepts.
Overview
6
6
years of professional experience
4
4
years of post-secondary education
1
1
Certification
Work History
Software Specialist
Capgemini Technology Services India Limited
Telangana, India
05.2023 - 07.2024
- Role : Software Specialist, Environment : Tableau, PostgreSQL, Domain : Banking
- Gathering the requirements from the clients then translate those requirements into POC.
- Creating data models using Alteryx and cleansing the data in Alteryx.
- Building different schemas like star schema and snowflake schema.
- Involved in Quality Management activities by creating project related documents.
- Creating new database objects like Procedures, Functions, Triggers, Indexes and Views using SQL.
- Ability to adapt to fast-paced Agile environment.
- Ensured that all the standard requirements have been met and is involved in performing the technical analysis.
- Designing the Reports as per client Requirement and created the reports using Excel file and SQL Server database.
- Created complex reports utilizing the features like hierarchy, new Calculated Columns, Drill functionality, Tables, graphs, line Charts and Bar Charts.
- Developed different types of Tableau Reports like Cross tab.
- Developed different types of visualizations reports like bar charts - Bullet graphs Box and whisker plots.
- Generated Tableau reports with Trend lines.
- Used filters, quick filters, sets, parameters and calculated fields on Tableau reports.
- Developed the complex reports using data blending.
- Developed the Reference lines in reports by using Parameters.
- Creating basic calculations including string manipulation, basic arithmetic calculations, custom aggregations and ratios.
- Created Hierarchies, sets, combined sets and groups in tableau.
- Involved in publishing the reports to Tableau server.
Consultant
EZ Solutions
Bangalore, India
11.2018 - 04.2023
- Client: Novo Nordisk., Denmark, Role: Consultant, Environment: Tableau, SQL Server, Domain : Pharmaceutical.
- Designing the Reports as per client Requirement and created the reports using Excel file and SQL Server database.
- Created complex reports utilizing the features like hierarchy, new Calculated Columns, Drill functionality, Tables, graphs, line Charts and Bar Charts.
- Developed different types of Tableau Reports like Cross tab.
- Developed different types of visualizations reports like bar charts - Bullet graphs Box and whisker plots.
- Generated Tableau reports with Trend lines.
- Used filters, quick filters, sets, parameters and calculated fields on Tableau reports.
- Developed the complex reports using data blending.
- Developed the Reference lines in reports by using Parameters.
- Creating basic calculations including string manipulation, basic arithmetic calculations, custom aggregations and ratios...
- Created Hierarchies, sets, combined sets and groups in tableau
- Involved in publishing the reports to Tableau server
Software Developer
EZ Solutions
Bangalore, India
11.2018 - 04.2023
- Client: Exelixis, Inc., USA, Domain: Health Care, Environment : Power BI Desktop, Power Query, SQL Server.
- Collaborate with stakeholders to understand business requirements related to sales and manufacturing analytics.
- Analyse data sources, including sales transactions, CRM systems, and manufacturing records.
- Design and implement a robust data model in Power BI, incorporating tables for sales, customers, products, and manufacturing.
- Establish relationships between tables to facilitate meaningful analysis.
- Use Power Query to clean, transform, and integrate data from various sources.
- Ensure data is accurate, up-to-date, and formatted for effective analysis.
- Develop visually appealing and interactive dashboards that meet the requirements of stakeholders.
- Create a dynamic elements like filters, slicers, and drill-down capabilities.
- Explore factors influencing sales fluctuations and identify key performance indicators (KPIs) for sales.
- Integrate manufacturing data to analyse production efficiency.
- Develop visualizations that identify correlations between manufacturing metrics and sales performance.
- In Power BI Desktop, created columns and measures.
- Apply row-level security to data and learn about Power BI security models. Rolled out security features in Power BI, including Role Based Security.
Education
Bachelor’s Degree - Computer Science Engineering
Anna University
Tamil Nadu / India 09.2008 - 04.2012
Skills
- Tableau Desktop
- Tableau Server
- Power BI Desktop
- SQL Server 2019
- PostgreSQL
- Redshift
- Alteryx Designer
- Alteryx Server
- Power Query Editor
- Informatica Power Center
- Jira
- Microsoft 365
Certification
Alteryx Designer
Languages
English
Custom
Yes
Personal Information
Nationality: Indian
Timeline
Software Specialist
Capgemini Technology Services India Limited
05.2023 - 07.2024
Consultant
EZ Solutions
11.2018 - 04.2023
Software Developer
EZ Solutions
11.2018 - 04.2023
Bachelor’s Degree - Computer Science Engineering
Anna University
09.2008 - 04.2012
Similar Profiles
Roopa NandakumarRoopa Nandakumar
Senior Consultant (Talent Acquisition) at Capgemini Technology Services India LimitedSenior Consultant (Talent Acquisition) at Capgemini Technology Services India Limited
Vasu Sagar AbishettiVasu Sagar Abishetti
Finance Controller at Capgemini Technology Services India LimitedFinance Controller at Capgemini Technology Services India Limited
Mrunmayee MehtaMrunmayee Mehta
Associate Consultant – Finance Controller at Capgemini Technology Services India LimitedAssociate Consultant – Finance Controller at Capgemini Technology Services India Limited
Anish DograAnish Dogra
Manager UK Bid Management at Capgemini Technology Services India LimitedManager UK Bid Management at Capgemini Technology Services India Limited
Gautam DuttGautam Dutt
Team member at InnoflateTeam member at Innoflate