ANIKET JAIN
Jabalpur,Madhya Pradesh
Summary
Experienced Data Analyst with 3 years and 9 months at Teradata India Pvt. Ltd. Specialized in interpreting and analyzing complex data sets. Skilled in PL/SQL, Teradata, data visualization, statistical analysis, and predictive modeling. Proficiency in statistical software, data mining, and predictive modeling techniques contributes to robust decision-making processes. Demonstrated ability to streamline operations by identifying trends and improving data reporting efficiency.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Teradata India Pvt. Ltd.
Pune
02.2021 - Current
- Designed automated ETL processes for efficient data extraction, transformation and loading in order to improve accuracy and reliability of reporting systems.
- Create visual reports, KPI scorecards, and dashboards using Power BI Desktop.
- Conducted exploratory analysis of complex datasets using Python libraries such as NumPy and Pandas.
- Conducted knowledge transfer sessions and provided technical training to team members, ensuring continuous skill development and proficiency enhancement.
- Develop and implement data collection systems and other strategies that optimize statistical efficiency and data quality.
- Designing and developing data warehouses using dimensional modeling techniques.
- Convert raw data into a structured format suitable for analysis. This includes normalizing, aggregating, and optimizing database performance by adjusting system parameters, query tuning, and workload management.
- Created interactive dashboards and reports using Power BI, enhancing data accessibility for stakeholders.
- Proficiency in SQL and experience with BI tools, such as Tableau, or Power BI.
- Collaborating with marketing, sales, finance, and product teams to understand their data needs.
- Regularly communicating progress and insights to business leaders or stakeholders.
- Led a team of 12 members as a Subject Matter Expert, overseeing multiple applications utilized within the project.
- Prepared business-critical reports on a weekly and monthly basis, contributing to strategic decision-making processes.
Junior Technical Associate
Teradata India Pvt. Ltd.
Pune
10.2020 - 01.2021
- Extracted the data from a flat file and transformed it using Teradata utilities (TPT).
- Assisting in transforming data to fit into the data models used by the business.
- Loading the data from staging to the Teradata warehouse using the BTEQ utility and SQL.
- Monitored system performance metrics such as CPU utilization, disk I and O to ensure optimal performance of Teradata systems.
- Maintained performance of existing queries by analyzing query plans and optimizing code.
- Identifying and resolving basic performance issues, such as slow-running queries.
- Assisting in database optimization tasks, such as index creation, partitioning, and tuning.
- Performing routine maintenance tasks, such as vacuuming, reindexing, and table statistics gathering.
Education
Bachelor of Engineering - Information Technology
GYAN GANGA INSTITUTE OF TECHNOLOGY AND SCIENCES
Jabalpur, Madhya Pradesh07-2020
Skills
- Teradata SQL & Utilities
- SQL
- Azure Databricks, ADF
- ETL/ELT
- Data Visualization
- Power Bi
- Performance tuning
- Hadoop
Certification
- Microsoft Certified: Microsoft Azure Fundamentals (5,2021)
- Microsoft Certified: Microsoft Azure Data Fundamentals (5,2021)
- Teradata Vantage Associate Certified (4,2021)
- Teradata Vantage Associate Certified 2.3 (5,2022)
- Teradata Vatange data lake Certified (6,2022)
- Teradata Vatange Cloud lake Certified (6,2024)
Accomplishments
- Q1 quarterly individual Award (2023).
- Secured Third Position in Teradata Vantage Cloud-A-Thon on AWS (2023).
- GDC India SPOT Award (2022).
- Secured Runner Position in Teradata Vantage Cloud-A-Thon on AWS (2022).
Timeline
Teradata India Pvt. Ltd.
02.2021 - Current
Junior Technical Associate
Teradata India Pvt. Ltd.
10.2020 - 01.2021
Bachelor of Engineering - Information Technology
GYAN GANGA INSTITUTE OF TECHNOLOGY AND SCIENCES
Similar Profiles
Onkar RajopadhyeOnkar Rajopadhye
Senior Software Engineer at Teradata India Pvt LtdSenior Software Engineer at Teradata India Pvt Ltd
CHAITANYA NEELAMCHAITANYA NEELAM
Information Security Manager, Audit Readiness at Teradata India Pvt LtdInformation Security Manager, Audit Readiness at Teradata India Pvt Ltd
Sushant WaghmodeSushant Waghmode
Hadoop Administrator at TERADATA INDIA PVT LTDHadoop Administrator at TERADATA INDIA PVT LTD