SQL
Ajitesh Choubey
Data Analyst
Sydney,NSW
Summary
More than 4 years of professional career development with experience in data and business analytics. Possessing a master's degree in Information Technology with a demonstrated history of working with multidisciplinary teams in high demand projects reaching both business success and customer experience quality. Skilled in data and insights analysis, automation projects, stakeholder management, pattern and trend identification, database design and management and reporting. A tech-savvy comfortable in fast paced environments.
Overview
4
4
years of professional experience
6
6
years of post-secondary education
2
2
Languages
Work History
Growth Data Analyst
Valiant Finance
1 2024 - Current
- Lead the development and implementation of data analytics strategies to support business objectives within digital space
- Diagnosed issues and identify opportunities for ongoing improvement to Valiant’s marketing channels and funnel data pipeline, and work with the team to execute on my recommendations
- Delivered regular reporting on funnel health and ROI (including campaigns and promotional initiatives), and execute optimisations to improve efficiency
- Supported teams to continuously run ongoing testing and optimisation that deliver improvements to acquisition, retention, and product marketing conversion rates
- Worked cross-functionally with Engineering, Marketing, Finance, and Data teams to implement analyses on customer segmentation, funnel / deal health, lead quality and conversion, product targeting, new / existing channel performance, to aid ongoing improvement.
Digital Data Analyst
Nib Group
01.2021 - 01.2024
- Extensive experience in utilizing SQL for comprehensive data analysis in marketing automation space
- Proven ability to design and execute complex SQL queries to extract, transform, and load (ETL) large datasets, ensuring accurate and timely reporting
- Proficient in database management and optimization, contributing to streamlined marketing workflows and improved campaign performance
- Conduct campaign analysis, encompassing the development of key performance indicators, real-time monitoring of campaign effectiveness, and post-campaign analysis
- Proficient in utilizing data-driven insights to assess marketing campaign performance, identify areas for optimization, and implement strategic adjustments for enhanced results
- Effective stakeholder management collaborating closely with cross-functional teams, including marketing, IT, and business development
- Demonstrated ability to translate technical insights into accessible information for non-technical stakeholders, fostering clear communication and understanding
- Support operations of data for automated campaigns to improve customer insights
- Use SQL to prepare audience lists to support sophisticated omnichannel marketing campaigns in Salesforce Marketing Cloud
- Create new data pipelines that optimize data flow from different data sources resulting in data integrity to business and help stakeholders for better decision making
- Identify and analyse issues within automations to find a quick and sound solution reducing any risk and business impact.
Data Analyst
Belgravia Leisure
01.2020 - 01.2021
- Statistical data analysis including cleansing, joining and analysing different data sets
- Develop and implement databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality
- Initiated for creating a Power App that enabled product owners to derive business insights and take actions from Power BI reports and dashboards for centre audits
- Able to use innovative approaches for data value extraction
- Experience working with end-users from technical and non-technical backgrounds.
Education
Master of Science - Information Technology
University of Technology Sydney
04.2017 - 04.2019
Bachelor of Science - Electronics And Telecommunication
GGCT
04.2012 - 04.2016
Skills
- Statistical Analysis
- Data Synthesizing
- Database Maintenance
- Database Management
- Data Mapping
- Trend Data Analysis
- Stakeholder management
References
- Bonnie Marshall, Group Manager, Marketing Automation, nib, bonnie.marshall@nib.com.au
- Gourav Gupta, Chief Financial Officer, Belgravia Leisure, gouravgupta08@gmail.com
Software
Snowflake
Power BI
Datorama
Salesforce
Salesforce Marketing Cloud
Active Batch
BuildKite
AmpScript
JavaScript
HTML & CSS
MySQL
Microsoft Excel
Timeline
Digital Data Analyst
Nib Group
01.2021 - 01.2024
Data Analyst
Belgravia Leisure
01.2020 - 01.2021
Master of Science - Information Technology
University of Technology Sydney
04.2017 - 04.2019
Bachelor of Science - Electronics And Telecommunication
GGCT
04.2012 - 04.2016
Growth Data Analyst
Valiant Finance
1 2024 - Current
Similar Profiles
Ratchaphak PrekpanarutRatchaphak Prekpanarut
Commercial & Development Finance Broker at Valiant FinanceCommercial & Development Finance Broker at Valiant Finance
Charley Howell-IvesCharley Howell-Ives
Commercial Finance Broker at Valiant FinanceCommercial Finance Broker at Valiant Finance
Anna GillenAnna Gillen
Broker at Valiant FinanceBroker at Valiant Finance
Cindy Annette Nicoline JennekeCindy Annette Nicoline Jenneke
Teacher at Seventh-Day Adventist Schools (Greater Sydney) LtdTeacher at Seventh-Day Adventist Schools (Greater Sydney) Ltd
Sreyneang NySreyneang Ny
Financial Services Officer at Ministry of Social DevelopmentFinancial Services Officer at Ministry of Social Development