Aman Pawar
New Delhi
Summary
Experienced Principal Analyst with expertise in requirement analysis, data management, and analytics. Proficient in data analysis, visualization, and strategic decision support. Collaborative team player, skilled in process improvement, data quality, and compliance. Accomplished in designing data models, implementing CRMs, and leveraging emerging technologies for enhanced reporting and insights. Dedicated to maximizing data's value as a strategic asset.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Principal Analyst
Aurionpro
New Delhi
04.2023 - Current
- Managed and analyzed large volumes of data to extract actionable insights for informed decision-making. This involved processing and interpreting complex datasets using advanced analytical techniques.
- Utilized statistical tools to identify patterns and trends in complex data sets, enabling diagnosis and prediction of future outcomes. By applying statistical methodologies, I uncovered valuable insights to guide strategic decision-making processes.
- Resolved data quality issues to ensure the accuracy and consistency of data across systems. This involved implementing data cleansing and validation processes to maintain data integrity.
- Conducted data profiling and mapping activities to classify and organize data effectively for storage and retrieval. By analyzing data structures and relationships, I optimized data storage and retrieval processes.
- Leveraged data visualization techniques to communicate key insights to stakeholders effectively. By creating visually engaging dashboards and reports, I facilitated understanding and decision-making based on data-driven insights.
- Enabled secure user authentication and role-based access control to safeguard sensitive data. By implementing robust security measures, I ensured data privacy and confidentiality.
- Conducted user acceptance testing to validate portal functionality and usability. By soliciting feedback from end-users, I identified areas for improvement and ensured a seamless user experience.
- Undertook mid to high-level tasks, overseeing complex data analysis and strategic planning. This involved synthesizing and analyzing data to support strategic initiatives and business objectives.
- Played a pivotal role in ensuring data security, compliance, and strategic decision support. By adhering to regulatory requirements and implementing data governance frameworks, I facilitated compliance and informed decision-making processes.
- Contributed to continuous improvement through process enhancements and innovative solutions. By identifying opportunities for optimization and implementing innovative approaches, I drove operational efficiency and effectiveness.
Business & Data Analyst
Aurionpro
New Delhi
07.2022 - 03.2023
- Conducted comprehensive analysis of business and system requirements to develop effective solutions. This involved identifying key objectives and gathering requirements from stakeholders to ensure alignment with organizational goals.
- Collaborated closely with clients to gain a deep understanding of their data management needs. By leveraging strong communication skills and domain expertise, I delivered customized insights tailored to their specific requirements.
- Prepared detailed dashboards, reports, and Management Information Systems (MIS) to facilitate strategic decision-making. These resources provided stakeholders with actionable insights derived from data analysis, enabling informed and effective decision-making.
- Partnered with stakeholders to identify process improvement areas and enhance operational efficiency. By conducting thorough assessments and implementing targeted improvements, I contributed to streamlining workflows and optimizing resource utilization.
- Developed and implemented data management strategies to ensure quality, security, and compliance. This involved designing robust data governance frameworks and implementing security protocols to safeguard sensitive information.
- Maintained comprehensive documentation related to data processes, procedures, and policies. This ensured transparency and consistency in data management practices, facilitating compliance with regulatory requirements.
- Collaborated with cross-functional teams to design data models and warehouses. By leveraging interdisciplinary expertise, I contributed to the development of scalable and efficient data infrastructure to support organizational objectives.
- Successfully managed CMMI Level 5 documentation for industry standards compliance. This involved meticulous documentation and adherence to best practices to meet stringent quality standards.
- Actively participated in post-implementation reviews to gather feedback and identify areas for enhancements. By soliciting input from stakeholders and evaluating project outcomes, I contributed to continuous improvement initiatives.
- Ensured compliance with industry standards and monitored emerging technologies for innovative solutions. By staying abreast of evolving regulatory requirements and technological advancements, I proactively addressed compliance issues and identified opportunities for innovation.
Senior Business Analyst
FactoryPlus
Noida
02.2022 - 06.2022
- Identified key performance indicators (KPIs) and created customized dashboards using Data Studio and Redash to track customer journey and measure the effectiveness of company initiatives.
- Prepared user engagement, retention cohort, and app module performance reports to identify areas of high and low engagement, informing product development decisions and driving improvements in user experience.
- Framed and implemented a customer relationship management (CRM) system using Freshsales for the sales team to track and monitor their ticketing, interactions, and performance, increasing efficiency and accountability.
- Streamlined processes and reporting across departments, leveraging data-driven insights to improve collaboration and decision-making.
- Collaborated closely with cross-functional teams to understand business requirements, and to develop and implement data-driven solutions that address organizational challenges.
- Stayed up-to-date with emerging data management technologies and industry best practices, continuously improving data analysis and reporting capabilities.
- Developed and implemented a highly efficient data transfer pipeline, connecting Redash and Mixpanel analytics platforms to BigQuery. Utilized the pipeline to extract, transform, and load data into BigQuery, enabling seamless integration and analysis of large-scale datasets. Leveraged advanced querying techniques within BigQuery to extract meaningful customer insights, empowering data-driven decision-making and enhancing overall business strategies.
Data Analyst
Wipro
Noida
09.2021 - 02.2022
- No project assigned
Senior Operations Executive
CaaStle
New Delhi
06.2019 - 09.2021
- Streamlined and automated multiple reports and processes, increasing efficiency and accuracy while reducing manual effort and errors.
- Established periodic reports and conducted root cause analysis for customer service, marketing, and operations, providing key insights and recommendations to drive process improvements and enhance customer experience.
- Successfully managed the migration of operational processes to new systems, ensuring a smooth transition while minimizing the impact on business operations.
Operations Executive
CaaStle
New Delhi
06.2017 - 06.2019
- Established and maintained dashboards and reports to track key performance indicators (KPIs), identifying trends and monitoring company initiatives. These insights have enabled data-driven decision-making and helped drive improved business outcomes.
- Created and handled process-level documentation, ensuring consistency and accuracy in reporting while also simplifying the process for team members. This has led to greater efficiency and effectiveness in managing data and generating reports.
- Identified and organized a ticket category tree, providing structure and organization to customer inquiries and issues. This has facilitated faster and more effective resolution of customer concerns, leading to greater satisfaction and loyalty.
MIS Executive
Fortune Marketing Private Limited
New Delhi
12.2016 - 06.2017
- Handled sales activities within assigned region, utilizing data-driven insights to drive conversions and meet or exceed sales targets. This involved closely monitoring market trends and customer needs, and developing effective strategies to promote products or services.
- Managed 3-4 sales resources remotely, providing guidance, coaching, and support to help them achieve their individual and team goals. This required strong communication skills, as well as the ability to motivate and engage team members.
- Prepared performance, visits, payments, conveyance, and sales reports for assigned regions, providing insights and recommendations to improve sales performance and drive business growth. These reports were essential for identifying areas of strength and weakness, and for making data-driven decisions.
- Managed data, promotional events, and sales queries through to closers, ensuring a seamless customer experience and promoting strong relationships with clients. This involved managing a high volume of customer inquiries and concerns, and leveraging data to inform and improve customer interactions.
Operations Executive
Eversafe rent a car
New Delhi
02.2016 - 11.2016
- Worked closely with the proprietor to manage all business-related activities, including sales, marketing, operations, and finance. This involved developing and executing strategies to drive business growth and profitability, as well as collaborating with other team members to ensure smooth and efficient operations.
- Prepared and handled commission, salaries, invoices, and payments, ensuring timely and accurate payment to employees, vendors, and other stakeholders. This involved maintaining meticulous records and leveraging accounting software to streamline financial processes.
- Documented and assigned duties to available resources, ensuring that team members are aligned with business objectives and effectively contributing to the success of the organization. This required strong organizational and leadership skills, as well as the ability to prioritize and delegate tasks effectively.
- Communicated with companies for pending payments and upcoming tours, managing a high volume of customer inquiries and concerns to ensure a positive customer experience. This involved utilizing strong communication and relationship-building skills to promote strong customer relationships and drive repeat business.
Executive
Trustline Securities Limited
New Delhi
08.2015 - 12.2015
- Solely handled reporting tasks for the insurance vertical, providing critical business insights to senior leadership to support strategic decision-making. This involved collecting and analyzing data from various sources and developing/maintaining dashboards and reports to track KPIs and other key metrics.
- Prepared revenue, sales, commission, and payment data for branches located PAN India, ensuring timely and accurate reporting of financial performance to stakeholders. This required a strong attention to detail and the ability to work independently in a fast-paced and deadline-driven environment.
- Communicated with insurance companies regarding pending payments and new product launches, fostering strong relationships with key partners and promoting the organization as a preferred partner. This involved utilizing strong communication and negotiation skills, as well as the ability to effectively manage competing priorities and timelines.
Education
MBA -
Guru Gobind Singh Indraprastha University
Dwarka, New Delhi12-2024
B.Com -
Shaheed Bhagat Singh College
Seikh Sarai, New Delhi12-2015
High School -
Saraswati Bal Mandir
Nehru Nagar, New Delhi07-2012
Skills
- Functional Requirements Specification (FRS)
- Microsoft SQL Server
- Project Management
- Mixpanel
- Requirements Gathering
- Data Analysis
- Google Analytics
- Reporting & Analysis
- Business Analytics
- Team Management
- Tableau, Data Studio and Power BI
- Marketing Analytics
- Criticality Analysis
- Alteryx
- JIRA, Confluence
- Google Bigquery
Certification
- Google Analytics
- Advanced Databases and SQL Querying
- Tableau
- Mixpanel
- Prompting in AI Tools
- Microsoft Azure - Data Engineering, AI Fundamentals,Administrator,Data Fundamentals
- Machine Learning
Languages
Hindi
First Language
English
Advanced (C1)
C1
Timeline
Principal Analyst
Aurionpro
04.2023 - Current
Business & Data Analyst
Aurionpro
07.2022 - 03.2023
Senior Business Analyst
FactoryPlus
02.2022 - 06.2022
Data Analyst
Wipro
09.2021 - 02.2022
Senior Operations Executive
CaaStle
06.2019 - 09.2021
Operations Executive
CaaStle
06.2017 - 06.2019
MIS Executive
Fortune Marketing Private Limited
12.2016 - 06.2017
Operations Executive
Eversafe rent a car
02.2016 - 11.2016
Executive
Trustline Securities Limited
08.2015 - 12.2015
MBA -
Guru Gobind Singh Indraprastha University
B.Com -
Shaheed Bhagat Singh College
High School -
Saraswati Bal Mandir
Similar Profiles
Aashish VermaAashish Verma
Software Developer at AurionproSoftware Developer at Aurionpro
Rohit PatwaRohit Patwa
Assistant Manager at AurionproAssistant Manager at Aurionpro
Aashish VermaAashish Verma
Software Developer at AurionPro SolutionsSoftware Developer at AurionPro Solutions