Derick D'souza
Data Wrangler/Team Lead
Mumbai
Summary
Versatile Project Coordinator with background successfully executing diverse project tasks to meet deadlines. Highly skilled at communicating with colleagues, monitoring status and achieving key milestones. Enthusiastic problem solver and talented team player with superior planning and decision-making skills. Experienced in Quality Management, Quality Improvement, Team Management, Project Management, Solving complex problems, Scrutinizing Data and to increase efficiency, accuracy, and utility of the process.
Overview
6
6
years of post-secondary education
2
2
Certificates
1
1
Language
Work History
Data Wrangler/Team Lead
Oliver
9 2022 - Current
- Perform and document data profiling, quality assessment, source consolidation, aggregation and other data manipulation efforts, to understand data formats, source systems, file sizes, etc
- Create, update, and maintain documentation and procedures for sourcing, analyzing, and preparing data templates for video preparation & automation.
- Ensuring the highest quality and integrity of data sources
- Strong experience in data management, keying and linking, data handling and data wrangling.
- Developed and implemented automated processes for data entry, analysis, and reporting, resulting in a 40% reduction in manual labor and a 25% increase in data accuracy
- Troubleshot and debugged errors in formulas and functions, resulting in a 20% reduction in errors and a 10% increase in efficiency
- Accurately track and record time in the company's daily reporting system.
- Assist the project manager in the development of project management documents such as project schedules, scope statements and project plans.
- Supervise the project procurement process, meetings with project clients to assess their needs and define project requirements, acceptance criteria and project timelines.
- Coordinate the allocation of project resources to ensure the project team has what’s needed at the right time.
- Assign tasks to team members and help them understand what’s expected from them in terms of project milestones and deliverables.
- Be the liaison between the project team and project clients throughout the project life cycle.
- Help project managers monitor project progress and team members’ performance and provide updates to project stakeholders.
- Foster cross-team collaboration to help project team members complete project tasks and produce deliverables.
- Report project risks and outcomes to appropriate management channels, and escalate issues according to project work plan.
- Monitored campaign performance closely, analyzing data to derive actionable insights and optimize performance.
- Collaborated cross-functionally with creative, content, and analytics teams to ensure cohesive campaign execution.
- Generated regular reports on campaign performance, providing recommendations for continuous improvement.
Subject Matter Expert
Merit Software Services
5 2018 - 5 2022
- Using of Trillium cloud, Cygnus software & JSON to process data, Interpreting & Analyzing using Excel, Retrieving data from the database using MySQL queries & Representing this data to the client using Microsoft PowerPoint
- Working as a Six Sigma-Certified professional in planning, designing, and accomplishing project goals in order to meet Client SLA
- Applying DMAIC, PDCA & Lean methodologies to meet quality goals and was successful in bringing down the monthly error count from 60 to less than 10
- Generating reports that explain insights of monthly performance related to KPIs and process improvements plan
- Identifying areas for quality improvement to resolve quality problems, Developing Quality Control Metrics, Analyzing Root Causes, and recommended measures to prevent recurrences
- Delivering a high quality of work and ability to meet deadlines while working under pressure in a multi-system environment
- Communicating with offshore teams, business stakeholders, and production teams to identify business needs and discussing business improvement solutions
- Conducting feedback & brainstorming sessions, training newly recruited agents and generating monthly performance report for the agent
- Derive insights from data analytics and provide actionable recommendations to improve and streamline business processes
- Trained and mentored 20+ employees on Excel features and functions, resulting in a 30% increase in productivity and a 20% reduction in errors
- Created custom reports and dashboards to present data, enabling senior management to make data-driven decisions and resulting in a 15% increase in revenue
- Developed and maintained data integrity and accuracy, resulting in a 15% reduction in errors and a 10% increase in customer satisfaction
- Created pivot tables and charts to visualize data, enabling senior management to identify trends and make data-driven decisions, resulting in a 20% increase in revenue
- Regulating quarterly reviews of team members to ensure efficiency
- Collaborating with internal teams to meet client needs
- Promptly and effectively addressing client issues by coordinating with internal teams, especially with key account managers
- Overlooking and ensuring a smooth workflow
- Motivating the team and solving problems
- Guiding the team to complete their tasks
- Managing the schedule and delegating tasks to team members
- Organizing training and boot camps to maximize the potential of team members.
Education
Master of Commerce - Marketing Management And Research
St. Andrews College
Mumbai 06.2015 - 11.2017
Bachelor of Commerce -
St. Andrews College
Mumbai 06.2013 - 04.2015
Higher Secondary Certificate (HSC) -
St. Andrews College
Mumbai 06.2011 - 04.2012
Secondary School Certificate (SSC) -
St. John The Evangelist High School
Mumbai 06.2009 - 04.2010
Skills
Proficient in Microsoft Excel and Google Sheets
Effective communication and excellent interpersonal skills
Attention to detail
Data Cleaning
Data Quality Assurance
Data Visualization, Transformation & Mapping
Large dataset management
Adaptability and Flexibility
Time management & Problem-solving abilities
Project Management
Work flow planning
Productivity Improvement
Project Planning & tracking
Continuous Improvement & Automation process
Timeline
Project Management Fundamentals
08-2024
Lead with Empathy, not Ego
08-2024
Master of Commerce - Marketing Management And Research
St. Andrews College
06.2015 - 11.2017
Bachelor of Commerce -
St. Andrews College
06.2013 - 04.2015
Higher Secondary Certificate (HSC) -
St. Andrews College
06.2011 - 04.2012
Secondary School Certificate (SSC) -
St. John The Evangelist High School
06.2009 - 04.2010
Data Wrangler/Team Lead
Oliver
9 2022 - Current
Subject Matter Expert
Merit Software Services
5 2018 - 5 2022
Certification
Project Management Fundamentals
Personal Information
- Date of Birth: 08/31/94
- Nationality: Indian
Projects
A Comparative study on Amazon and Flipkart. Rural Entrepreneurship in Rural areas. A study on Gym goers in Mumbai. Reward system in an organization.
Projects
- A Comparative study on Amazon and Flipkart.
- Rural Entrepreneurship in Rural areas.
- A study on Gym goers in Mumbai.
- Reward system in an organization.