Mridul Ojha
Analyst
Gandhinagar,GJ
Summary
Dynamic Data Scientist with a proven track record at Tata Consultancy Services, leveraging Data Mining, Data Modelling and advanced statistical analysis to drive key business insights.
Excelled in data analytics & validation processes and achieving significant improvements in data accuracy.
Expert in SQL querying and adept at translating complex data sets into actionable strategies.
Overview
4
4
years of professional experience
Work History
Junior Data Scientist
Tata Consultancy Services
Gandhinagar
10.2023 - Current
- Worked with stakeholders to develop monthly reports based on impact, spending, and campaign performance, and delivered a presentation to highlight strengths and cost efficiency in certain marketing channels that boosted a 40% increase in CTR.
- Utilized advanced querying, visualization, and analytics tools to analyze and process complex data sets.
- Applied statistical and algebraic techniques to interpret and deliver KPIs to clients for data-driven decision making.
- Analyzed large datasets to identify trends and patterns in customer behaviors in the healthcare business.
- Improved data collection methods by suggesting 20+ surveys, polls, and other instruments, resulting in better analytics.
- Compiled, cleaned, and manipulated data for proper handling.
- Identified, measured, and recommended improvement strategies for KPIs across business areas.
- Helped the client identify and target active customers, thereby reducing several marketing tactic costs.
Data Analyst
Tata Consultancy Services
Gandhinagar
04.2022 - 11.2023
- Led a team of eight junior analysts to generate various Excel reports to assist with metrics and present information to stakeholders for concise explanations of user interactions and engagements.
- Used statistical methods to analyze data, prepare a data model, and generate useful business reports for 110+ KPIs.
- Developed and optimized scripts and queries to extract and analyze data from multiple sources, resulting in a 20% increase in efficiency.
- Identified patterns and trends in large data sets with over 10 million records, and provided actionable insights.
- Collaborated with clients and SMEs to identify business needs and data sources.
- Developed complex dashboard and reporting tools to track business performance metrics.
- Developed and maintained data warehouses to support ETL operations.
Data Validation Analyst
Tata Consultancy Services
Gandhinagar
03.2021 - 03.2022
- Worked on several concurrent tasks, and prioritized workload with minimal direction.
- Initiated, performed, documented, and approved data validations, and technology or test method transfers.
- Identified and applied customer-specific rules and processes.
- Monitored and reported on test results and performance data to identify areas of opportunity for improvement.
- Collaborated with cross-functional teams for the identification and resolution of validation issues.
- Build a Python-based automation application for validating data models for 120+ web domains.
Education
B.E. - Electronics And Telecommunications
Sinhgad College of Engineering (Pune University)
Pune07-2019
HSC - Science
Kendriya Vidyalaya No.1 AFS
Jamnagar05-2015
Skills
- Language: Python, SQL
- Libraries: Pandas, NumPy, Scikit-learn, Matplotlib
- ETL Tools: Dataiku, Informatica
- Analytics tools: Excel, Snowflake
- Database: Snowflake, Adobe, AWS
- Data Visualization: Tableau, Power BI
- Python automation
- Advanced mathematical skills
- Analysis: Statistical, Geospatial, Time series
- Data mining
- Data Dimensional Modeling
- Data storytelling
- Agile methodology
Accomplishments
- On the spot Award
- Multiple appreciations from client
- Engineering Excellence Exhibitions
Timeline
Junior Data Scientist
Tata Consultancy Services
10.2023 - Current
Data Analyst
Tata Consultancy Services
04.2022 - 11.2023
Data Validation Analyst
Tata Consultancy Services
03.2021 - 03.2022
B.E. - Electronics And Telecommunications
Sinhgad College of Engineering (Pune University)
HSC - Science
Kendriya Vidyalaya No.1 AFS
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