SIDDHARTHA PATNAIK
Bhubaneshwar,OD
Summary
Certified data Analyst with 3 years of experience. Using Intelligence tools like Tableau/PowerBI, MYSQL and PL/SQL. Having strong analytic skills, attention to detail, and hard work ethics to turn complex requirements into working systems Involved in creating Dashboards, reports as needed using Tableau Desktop and Tableau Server. Preparing Dashboards using calculations, parameters in Tableau. Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets , Groups, Parameters etc., in Tableau.
Overview
3
3
years of professional experience
6
6
years of post-secondary education
3
3
Certifications
Work History
DATA ENGINEER
TATA CONSULTANCY SERVICES
Bhubaneshwar, Odisha
08.2021 - Current
- Created Azure Storage Accounts (Datalake Gen2 )and Azure SQL Databases .
- Migrated On Premise Data to Cloud using Azure Synapse.
- Created SQL Pool, Authorized access.
- Loading Data into SQL Pool,using Bulk Insert
- Developed in sights by Adhoc Analysis on Synapse.
- Employed data cleansing methods significantly enhancing data quality, producing .
- Performed large-scale data conversions, transferring of data into standardized formats for integration
- Developed polished visualizations to share results of data analyses.
Data Analyst
Tata Consultancy
Bhubaneshwar, Odisha
08.2020 - 07.2021
- Examination of discrepancies between Depot to warehouse and from supplier to retailer
- Handled issues on order tracking, Deranging, Delisting using SQL queries for around 50-80k items daily Executed and tested required SQL queries and reports before publishing to production
- Cleaned Data and performed EDA on weekly basis.
- Good working knowledge of data modelling and warehousing concepts including dimensional data modelling using Star schema, snowflake schema, Fact and dimensional tables.
- Implemented data blending feature in tableau for internal team reporting and analysis
- Defined best practices for Tableau report development and shared the same with business Improved workarounds on Inventory Adjustments to avoid discrepancies and performance was increased by 2%
- Created and Build, publishing customized interactive reports and dashboards using Tableau.
- Documented Business requirement and plans for creating dashboards and generating insights Developed Calculative fields to meet business needs in Tableau Visualizations
- Modeled code changes using SQL functions and Procedures to meet business needs
- Steered SQL reporting skills with the ability to create SQL views and write SQL queries that reduced work by 1 hour
Data Analyst
Tata Consultancy
Kolkata, West Bengal
04.2019 - 06.2020
- Wrote complex SQL queries using complex joins, grouping, aggregation, nested subqueries
- Generated SQL reporting skills with the ability to create SQL views and wrote SQL queries
- Identified data issues and provided recommendations for resolution to ensure optimal performance.
- Developed a good understanding of workflow of SharePoint architecture and SharePoint Sites Administered applications like KCentral, Intra and serving the clients.
- Examined the root-cause of using with tools like ULS/HTTP Logs on daily basis along with event viewer.
- Debugged the root cause of the alert and providing with appropriate solutions.
- Formed various insights using MS-Excel to meet business requirements on weekly basis Managed Tickets with a top priority within the SLA, to ensure there is no escalation
Technical Recruiter
Artech LLC
Noida, Uttar Pradesh
06.2018 - 01.2019
- Gathering Job requirement is the main step of recruitment in RPO
- Scanned & sourced Potential candidates by using a job portal sites like Monster, Dice.
- After sourcing a candidate, a telephonic round of interview which included technical questions were asked.
- If the candidate is potential, then next step of recruitment was carried out.
- Composed proper documentation (including work Visa and payroll) is done before submitting the candidate for further recruitment process
Education
Post Graduate Diploma - Data Science
IIIT Bangalore
10.2020 - 12.2021
Bachelor’s - Mechanical Engineering
Institute of Technical Education And Research
07.2014 - 05.2018
P.C
DAV Public School
05.2011 - 04.2012
Skills
PL/SQL Python for Data Science (Numpy,Pandas,EDA) Inferential and Hypothesis Testing using P-value, Z-score and Critical Value Method MYSQL,SQL Server, POSTGRES SQL, PL/SQL Tableau ,PowerBI & Advanced Exce
Certification
Microsoft Certified : AZ 900
Timeline
Microsoft Certified : AZ 900
12-2021
Microsoft Certified : DP 900
12-2021
PG DIPLOMA IN DATA SCIENCE - UPGRAD- IIIT BANGLORE
12-2021
DATA ENGINEER
TATA CONSULTANCY SERVICES
08.2021 - Current
Post Graduate Diploma - Data Science
IIIT Bangalore
10.2020 - 12.2021
Data Analyst
Tata Consultancy
08.2020 - 07.2021
Data Analyst
Tata Consultancy
04.2019 - 06.2020
Technical Recruiter
Artech LLC
06.2018 - 01.2019
Bachelor’s - Mechanical Engineering
Institute of Technical Education And Research
07.2014 - 05.2018
P.C
DAV Public School
05.2011 - 04.2012