DEEPANSHU MEHRA
United Kingdom
Summary
A detail-oriented and competent professional with a proven track record in bookkeeping and accounting. Skilled in recording day-to-day financial transactions and ensuring accurate posting processes. Proficient in managing various ledgers, including suppliers, customers, and general ledger, and bringing books to the trial balance stage. Capable of handling tax forms and preparing financial statements and reports. Experienced in processing accounts receivable/payable and executing payroll efficiently. Demonstrated expertise in generating P&L statements for individual trades and meeting Companies House submission deadlines. Meticulous in checking and preparing contracts, letters of credit, and shipping documents, while maintaining meticulous records for audit purposes.
Overview
2
2
years of professional experience
Work history
Digital Marketing Analyst
Adlift Marketing Pvt Ltd
Gurugram, India
11.2021 - 08.2022
- Conducted in-depth market trend analysis across various business segments to identify key customer insights and preferences, contributing to the development of highly effective and targeted marketing strategies.
- Utilized various data analysis tools and techniques to gather, interpret, and present data-driven reports, providing valuable insights to senior management for informed decision-making.
- Collaborated with cross-functional teams to ensure precise execution of client briefs, aligning campaign messaging and imagery with brand specifications, resulting in consistent and impactful brand communication.
- Analyzed digital campaign performance metrics, including click-through rates, conversion rates, and engagement levels, to measure campaign effectiveness and identify areas for optimization.
- Implemented A/B testing methodologies to evaluate the performance of different marketing campaigns, optimizing ad copy, graphics, and targeting parameters for improved results.
- Assisted in developing and executing customer segmentation strategies to tailor marketing efforts to specific target audiences, enhancing customer acquisition and retention rates.
- Monitored industry trends and competitor activities, gathering competitive intelligence to inform marketing strategies and stay ahead of market developments.
- Collaborated with content creators and graphic designers to ensure content relevance and visual appeal, aligning with campaign objectives and brand guidelines.
- Managed and cultivated strong relationships with clients based in the UK, US, and India, understanding their unique requirements and providing personalized marketing solutions to achieve mutual success.
- Contributed to the enhancement of digital marketing automation processes, streamlining campaign workflows and improving overall efficiency.
- Maintained a strong understanding of digital marketing best practices, staying up-to-date with the latest industry trends, and implementing innovative approaches to maximize campaign success.
Business Development Associate
Planet Spark
Gurugram, India
09.2021 - 11.2021
- Conducted extensive and in-depth marketing research, analyzing market trends and identifying key business opportunities to drive revenue growth and expansion.
- Collaborated actively with the team to create result-oriented business strategies aimed at enhancing client relationships and uncovering new prospects.
- Maintained highly detailed and organized reports on critical areas of development, utilizing customer feedback and experiences to support data-driven decision-making and inform future business strategies.
- Played a pivotal role in contributing to the overall organizational growth by providing valuable insights and assistance in budgetary and financial management decisions.
- Worked closely with the cultural secretary to ensure alignment with organizational goals and objectives while effectively managing available resources.
- Actively participated in brainstorming sessions and strategy meetings, offering innovative ideas and solutions to address business challenges and capitalize on market opportunities.
- Utilized strong communication and interpersonal skills to build and maintain strong client relationships, ensuring high levels of client satisfaction and retention.
- Assisted in creating compelling business proposals and presentations, showcasing the company's value proposition and expertise to potential clients.
- Conducted regular market analysis and competitor research to stay informed about industry trends and developments, facilitating proactive adjustments to business strategies.
Data Management and Reporting Intern
HCL Technologies
Noida, India
06.2019 - 07.2019
- Recorded day-to-day financial transactions with utmost accuracy and efficiently completed the posting process.
- Verified and ensured the correctness of transactions recorded in various ledgers, including day book, suppliers ledger, customer ledger, and general ledger.
- Actively contributed to bringing the financial books to the trial balance stage and conducted thorough checks of the posting process.
- Assisted in the timely completion of tax forms and played a significant role in the preparation of comprehensive financial reports and statements.
- Proficiently processed accounts receivable/payable and demonstrated adeptness in handling payroll efficiently.
- Prepared precise and detailed P&L statements for individual trades, ensuring accuracy and reliability in financial data.
- Ensured timely and compliant submission of Companies House documentation to meet regulatory requirements.
- Checked and meticulously prepared contracts, letters of credit, and shipping documents, maintaining organized records for seamless audit purposes.
Financial Operations and Administration Intern
Sonai Fine Solutions
Noida, India
05.2019 - 06.2019
- Supported the team in meticulously recording day-to-day financial transactions and effectively completing the posting process.
- Assisted in verifying the accuracy and correctness of transactions across various ledgers, including day book, suppliers ledger, customer ledger, and general ledger.
- Collaborated in the process of reconciling accounts and efficiently bringing the financial books to the trial balance stage.
- Actively participated in the preparation of tax forms and contributed to financial reporting processes.
- Demonstrated proficiency in handling accounts receivable/payable and actively managed payroll responsibilities.
- Assisted in preparing detailed profit and loss statements for individual trades.
- Collaborated in the timely and accurate submission of Companies House documentation, ensuring compliance with regulations.
- Checked and diligently prepared contracts, letters of credit, and shipping documents, maintaining meticulous records to facilitate smooth audit procedures.
Education
Master of Science - Finance
University of Liverpool
Liverpool,UK 09/2022 -
B.A(Hons) - Economics
Delhi Technological University
India 08/2018 - 05/2021
Skills
- Proficient in bookkeeping and accounting principles with proven experience in accurately recording day-to-day financial transactions and completing the posting process
- Skilled in verifying and ensuring the accuracy of transactions recorded in the day book, suppliers ledger, customer ledger, and general ledger
- Experienced in handling data entry and maintaining meticulous records, creating reports, and financial statements with a keen eye for accuracy and attention to detail
- Proficient in using Microsoft Excel, including VBA, to efficiently manage and manipulate financial data for analysis and reporting
- Familiarity with spreadsheets and proprietary software, enabling effective data management and organization
- Advanced proficiency in Python programming for data analysis, enabling insightful financial insights and calculations
- Utilizing R for statistical analysis and data visualization to derive valuable financial insights and trends
- Demonstrating a strong command of SQL for efficient data querying and database management
- Skilled in creating interactive dashboards and reports using visualization tools such as Tableau or Power BI, presenting financial information in a clear and comprehensible manner
Languages
English
Fluent
Hindi
Fluent
Certification
- Programming with Python for Data Science, National Institute of Information Technology.
- Bloomberg Market Concepts, Bloomberg.
- Microsoft Excel Course, Earn n Excel.
- Environmental, Social & Governance, Bloomberg.
- Process Mapping Course, Reed UK.
- Xero Accounting & Bookkeeping Diploma.
- Advanced SQL Programming Certification.
- SAP FICO(Finance and Controlling) Certification.
- Sage 50 Payroll Management (Bookkeeper Training).
- Asset Management Programme, J.P Morgan.
Extra Curricular Activities
Cultural Treasurer at Cultural council, Delhi Technological University, Delhi
May 2020- May 2021
● Improved council cash flow by sponsorships and making recommendations to co-workers on cost cuts and money- saving opportunities.
● Partnered with cultural secretary on budgetary and financial management decisions.
Treasurer at Human Resource club, Delhi Technological University, Delhi
May 2019- May 2020
● Implemented mechanism to assess return on expenditures to ensure efficient use of funds and reduce resource wastage.
● Collaborated with team members to achieve target results.
Core Member at Finance club, Delhi Technological University, Delhi
September 2018- May 2019
● I was in charge of planning a variety of financial activities, including workshops, guest lectures, competitions, and networking gatherings.
● To guarantee that the club's mission and vision are in line with those of the college and its students, these should also be developed and promoted.
Timeline
Digital Marketing Analyst
Adlift Marketing Pvt Ltd
11.2021 - 08.2022
Business Development Associate
Planet Spark
09.2021 - 11.2021
Data Management and Reporting Intern
HCL Technologies
06.2019 - 07.2019
Financial Operations and Administration Intern
Sonai Fine Solutions
05.2019 - 06.2019
Master of Science - Finance
University of Liverpool
09/2022 -
B.A(Hons) - Economics
Delhi Technological University
08/2018 - 05/2021
Similar Profiles
Rajeev MunjalRajeev Munjal
Group Head - SEO at AdLift Marketing Pvt Ltd.Group Head - SEO at AdLift Marketing Pvt Ltd.
Kanika ChadhaKanika Chadha
Creative Director- Copy & Head- Social at Adlift Marketing Pvt. Ltd.Creative Director- Copy & Head- Social at Adlift Marketing Pvt. Ltd.
Vaibhav SinghVaibhav Singh
Sr. SEO Exectuive at Adlift Marketing Pvt LtdSr. SEO Exectuive at Adlift Marketing Pvt Ltd
Janice GuyJanice Guy
Principal Teacher ASN at South Lanarkshire CouncilPrincipal Teacher ASN at South Lanarkshire Council
Ambalavanan ChockalingamAmbalavanan Chockalingam
Senior TPM/Release Train Engineer at Marks and SpencerSenior TPM/Release Train Engineer at Marks and Spencer