Parth Gandhi Email & Phone Number

Analyzed structured and unstructured data, conducted data preprocessing, cleaning and feature engineering, and implemented models and algorithms.Designed and developed models such as recommendation systems, predictive analytics, and time series forecasting.

Chennai, Tamil Nadu, India

• Designing Project including requirement gathering, Data Modeling, Front end development and reporting using QlikSense.• Extracting, transforming and loading data from multiple sources into QlikSenseapplications. • Created Dashboard using different objects of QlikSense like filter panes, Text objects, slider, and buttons, charts (Combo, Straight/Pivot table) etc..• Worked on Incremental Loading to reduce the reload time of application.• Designed data model in Qliksense. Created multiple layer QVDs to get the desired data mode.• Performing testing, validation and sanity checks on the deliverables.• Maintenance and Modification of pre-existing application.• Participated in full development of the report, security and deploying to end users.• Implemented AutoNumber Hash function to eliminate Synthetic key.• Strong knowledge on Bar chart, Pie chart, Gauge, Line chart, Pivot tables, Filter Paneand Funnel Chart for different business scenarios.

Chennai, Tamil Nadu, India

Designed and optimized SQL queries to extract and analyze data from various databases, achieving a 30% reduction in report generation time.Developed interactive dashboards in PowerBI to visualize key performance indicators, enhancing stakeholder decision-making.Performed ad-hoc analyses to assist different departments, leading to data-driven strategies that improved operational efficiency by 15%.Collaborated with IT and business teams to define data requirements and maintain data integrity across all systems.Contributed to the development of SQL queries for extracting and manipulating large datasets for routine reporting.Processed and transformed raw data to ensure accuracy and reliability, resulting in a 20% enhancement in data quality.Assisted in producing monthly reports that monitored sales and marketing performance, offering insights that guided campaign strategies.Engaged in team meetings to share findings and recommend improvements based on data analysis.

Chennai Area, India

During this tenure with Tech Mahindra, I worked on multiple projects.PROJECT 1 :Design and implemented ETL pipeline to extract the data from various data sources.• Develop Power BI dashboard to analyze the KPIs for Telecom Industry.• Increased the conversion rate via A/B testing from 2% to 4%.PROJECT 2 :Served as Oracle DBA executing daily DBA activities• Developed python scripts to automate DBA activities• IT performance analysis using Python, evaluating metrics like nos of issue resolved, pending tickets, SLA breached, Avg TAT.

Pune Area, India

• Worked on DW modeling and designed integrated ETL features for different applications within 3-Ireland.• Established and enforced technical standards on BI data deliverable for different reports.• Documented and maintained corporate metadata repositories and EDW artifacts such as data dictionaries, source-to-target data mappings, data models, and data flow diagrams.• Worked on tools like Teradata Data warehouse, SQL Analytics, Data Stage, Shell scripting, Teradata Utilities

India

Developed 2 Power BI Reports on Project Portfolio by extracting data from 4 data sources – Power BI Datasets, SQL, CSV, and Excel

Have done training on various Visualization tools such as Tableau, PowerBiCreated an interactive dashboard as a part of internship to get the meaningful insights from the data.

Performed Data Wrangling, Data Exploration , Data Analysis. Created interactive Dashboard using PowerBI

Post Graduate, Data Science & Business Analytics

Post Graduate Data Science & Business Analytics

Bachelor Of Engineering - Be, Electrical, Electronics And Communications Engineering