Hi, I’m
Tarun Kumar Tiwari
A-101, Mira-Jai Arihant Tower CHS, Mira-Bhayander Road, Saibaba Nagar, Mira Road East, Thane
Summary
- Seasoned professional with 13 years of diversified experience, encompassing 7 years in the BFSI sector and 5 years in IT.
- Presently driving impactful insights as a proficient Data Analyst in the Banking domain for the last 3 years.
- Proficiently utilizing OBIEE, Tableau, Power Bi, SQL, and Python to extract, analyze, and visualize complex data, fostering informed decision-making and operational enhancements.
- Recent certifications in Data Science and Power Bi underpin a commitment to staying at the forefront of industry advancements, complementing a robust skill set.
- Proven ability to translate data into actionable strategies, contributing decisively to organizational objectives and facilitating data-driven transformations
Overview
14
years of professional experience
1
Certification
Work History
Tata Consultancy ServicesThane West (Olympus A)
Data Analyst
03.2021 - Current
Job overview
- As an OBIEE 12c Report Developer, my primary focus was automating Excel-based reports for the business management team.
- I collaborated with senior management to understand their requirements and assess the feasibility of automating these reports using resources available within OBIEE Answers.
- Utilizing OBIEE Answers, I successfully automated the reports and dashboards, ensuring their accuracy and reliability by validating them against the previously prepared Excel reports.
- Additionally, I configured automated email notifications using iBot within OBIEE, streamlining the dissemination of critical information to senior management.
- A significant project involved crafting the Global Monthly P&R report. Here, I meticulously investigated payment and receivable types, aligning them with client specifications to categorize and present the data effectively.
- This role allowed me to showcase my expertise in OBIEE development, report automation, validation, and meeting specific client-driven reporting requirements.
- Created predictive models to forecast customer behavior.
- Analyzed large datasets to identify trends, patterns and correlations for business insights.
- Leveraged SQL queries to extract, transform and load data into databases.
- Maintained documentation of all the processes related to Data Analysis.
- Worked with internal teams to understand business needs and changing strategies.
Tata Consultancy ServicesThane West (Yantra Park)
Project Management Officer (PMO)
05.2018 - 01.2020
Job overview
- In this role, I was responsible for managing SLA reports, ensuring timely delivery to relevant application teams, and tracking ticket closures within specified SLA periods.
- Additionally, I facilitated communication with application teams regarding IT support-related information, ensuring seamless operational continuity.
- Moreover, I liaised with third-party teams to address reported errors, ensuring efficient troubleshooting and resolution.
- Beyond this, I prepared various reports based on client requirements, demonstrating a commitment to delivering comprehensive and tailored information crucial for informed decision-making.
- This role demanded adept coordination, proactive follow-ups, and the ability to deliver accurate and timely reports to stakeholders.
- Developed project plans and tracked progress against milestones.
- Created presentations for senior management to provide updates on project performance.
- Ensured compliance with organizational policies and procedures related to projects.
- Provided guidance and support to team members in order to meet deadlines efficiently.
- Establishing project management standards, methodologies, and best practices to ensure consistency across all projects.
- Identifying and assessing risks associated with projects, developing mitigation strategies, and implementing measures to minimize potential disruptions.
- Providing support to project managers and teams, offering guidance on methodologies, tools, and best practices. Conducting training sessions to enhance project management skills across the organization.
- Evaluating project performance, identifying areas for improvement, and implementing changes to enhance future project outcomes
Tata Consultancy ServicesGoregaon East (Nesco Compound)
Team Leader (UK Insurance and Claims Process)
05.2017 - 05.2018
Job overview
- This role involved overseeing a team of 20 full-time employees, ensuring effective delegation of tasks to meet SLAs.
- Attending client meetings regularly, I discussed team performance and progress on a weekly and monthly basis.
- Additionally, I managed report production and monitoring, swiftly addressing exceptions. I maintained a focus on process adherence, ensuring that procedures and SLAs were consistently met.
- To foster continuous improvement, I organized monthly refresher trainings and feedback sessions for team members.
- Moreover, I conducted one-on-one performance discussions, providing personalized feedback and support to enhance individual and overall team performance.
- This role demanded a blend of leadership, proactive communication, and a commitment to continuous improvement within the team.
- Monitored daily workflow to ensure adherence to established policies and procedures.
- Analyzed data from various sources to identify areas of improvement in the department's operations.
- Maintained a positive work environment that promoted collaboration between team members.
- Resolved customer complaints in an effective manner while maintaining a high level of customer service.
Tata Consultancy ServicesGoregaon East ( Nesco Compound)
Subject Matter Expert (SME) (US Bankruptcy, Specialities & CCG)
05.2010 - 05.2017
Job overview
- In this role, I managed customer accounts and processed faxes from three major credit bureaus (Experian, Trans Union, and Equifax) in accordance with US bankruptcy procedures.
- I handled various customer requests, including settlements, cease and desist requests related to bankruptcy, fraud-related accounts, and disputes (balance, billing, CBD).
- Additionally, I conducted training sessions for the support team as part of Business Continuity (COB) measures and managed both MIS and daily team volumes.
- Attending client meetings and providing process-related updates were integral aspects of this role.
- I also facilitated payment programs for customers upon request, reviewed proposals submitted by customer representatives, and assessed account eligibility for payment programs by verifying balances.
- This multifaceted role demanded a keen understanding of bankruptcy procedures, customer account management, training, and active participation in client-related meetings and updates.
- Created detailed reports on project progress, metrics, and results for stakeholders' review.
- Provided subject matter expertise during meetings with senior leadership team members in order to discuss potential opportunities or challenges.
Education
Thakur College of Science And CommerceThakur Village Kandivali East
B. Com from Commerce
04.2010
Thakur College of Science And CommerceThakur Village, Kandivali East
H.S.C from Commerce
04.2007
Sardar Vallabhbhai Patel VidyalayaRamdev Park Mira Road East
S.S.C from High School
05.2005
Skills
- OBIEE
- Power Bi
- Tableau
- MS Office Applications
- SQL
- Python
- VBA
- Macros
Certification
- Data Science Certification, Boston Institute of Analytics, 11/2022 - 04/2023
- Power Bi Certification, Intellipaat Institute, 11/2022 - 04/2023
Accomplishments
- I received client appreciation for streamlining information access previously sourced from three teams.
- This recognition highlighted my efficiency and effectiveness in meeting client needs. My consistent performance and leadership skills led me to a promotion to the Team Leader position, showcasing my dedication and capability to lead effectively.
- Furthermore, my outstanding contributions were acknowledged with prestigious awards such as "Best Performer" and leading the "Best Performing Team" in TCS for two consecutive years (2016, 2017).
- These accolades underscored my exceptional performance and my team's collective achievements within the organization.
Projects
- Power Bi Project Summary: In this Power BI project focused on the Retail Industry's sales trends, I conducted a thorough analysis leveraging a complex dataset.
- My role involved data cleaning, modeling, and creating insightful visualizations to extract valuable business insights. Utilizing a student survey dataset, I specifically delved into analyzing student spending habits on video games.
- The process began with meticulous data analysis and cleaning, followed by the utilization of diverse visualization tools like Tabular, Matrix, Funnel, Pie, Scatter Plot, and Sand Dance plots. To ensure data security and relevance, I implemented a User Mapping table to restrict data access to specific users.
- The project's culmination saw the publication of the report on the Power BI cloud service. I constructed a comprehensive Master Dashboard incorporating Funnel and Scatter Plot visualizations.
- To maintain data accuracy and relevance, I implemented a scheduled data refresh occurring six times daily, every four hours, for the Dashboard.
- Furthermore, I integrated the Q&A feature to enable intuitive queries directly within the Dashboard, enhancing user interaction and facilitating seamless data-driven decision-making.
- This project highlighted my proficiency in data manipulation, visualization, security implementation, dashboard creation, and data refresh strategies within the Power BI ecosystem.
- Machine Learning Project Summary: In the machine learning project aimed at automating the loan eligibility process for customers, I employed various tools and techniques to build an efficient model.
- Leveraging NumPy for numerical computations and Pandas for data handling, I divided the dataset into training and test sets.
- For visual representation, I utilized Matplotlib and Seaborn libraries, enabling clear and insightful data visualization.
- Employing a range of machine learning algorithms such as Linear Regression, Decision Tree, Random Forest, and XGBoost, I developed models to predict customer eligibility for home loans.
- The iterative process involved training the models on the training dataset and validating their performance using the test set, ensuring accuracy and reliability.
- This project showcased my proficiency in data manipulation, visualization, and employing diverse machine learning algorithms to automate and enhance the loan eligibility assessment process for customers.
Languages
English
First Language
Hindi
Proficient (C2)
C2
Marathi
Upper Intermediate (B2)
B2
Knowledge
- In essence, I possess extensive expertise in KYC (Know Your Customer), AML (Anti-Money Laundering), and Investment Banking, demonstrating a profound understanding of these critical domains within the financial industry.
- My expertise spans Agile and Scrum methodologies, encompassing a strong understanding of their principles.
- In-depth knowledge of letters of credit (LC), documentary collections, and various trade financing options. Familiar with international trade regulations and compliance requirements.
LinkedIn Profile Link
- www.linkedin.com/in/tarun-tiwari-data-scientist-data-analyst
Timeline
Data Analyst
Tata Consultancy Services
03.2021 - Current
Project Management Officer (PMO)
Tata Consultancy Services
05.2018 - 01.2020
Team Leader (UK Insurance and Claims Process)
Tata Consultancy Services
05.2017 - 05.2018
Subject Matter Expert (SME) (US Bankruptcy, Specialities & CCG)
Tata Consultancy Services
05.2010 - 05.2017
Thakur College of Science And Commerce
B. Com from Commerce
Thakur College of Science And Commerce
H.S.C from Commerce
Sardar Vallabhbhai Patel Vidyalaya
S.S.C from High School
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
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Omkar YadavOmkar Yadav
Spatial Data Specialist at Here TechnologiesSpatial Data Specialist at Here Technologies