Ankit Pandey Email and Phone Number

○ Extracted drilling data from client platforms using SQL queries and integrated into AWS Athena, ensuring data quality through data cleaning.○ Utilized AWS Quicksight for initial data exploration and preliminary data analysis.○ Analyzed drilling operations to identify cost optimization opportunities, using SQL queries to pinpoint inefficiencies in drilling time, equipment usage, and well completion rates.○ Developed and maintained dashboards and reports to visualize key performance metrics.○ Collaborated with clients to understand business needs, providing regular updates and insights ensuring alignment with analytical solutions. Creating business value by providing scalable and accurate data labeling solutions.○ I bring strong analytical and communication skills, attention to detail, and a commitment to excellence in data annotation.○ Conducting comprehensive analysis and assessment of Client, algorithm, broker, and venue performance, providing valuable insights for decision-making processes.

● Leveraged SQL queries to extract, manipulate, and analyze data from various databases.● Utilized Python scripting for data extraction, transformation and loading (ETL) reducing manual data process time.● Employed Power BI for data visualization and reporting, and presenting findings to management for informed decision making.● Conducted requirement gathering sessions with client/carrier/AIS and cross functional teams to understand data needsand translate them into actionable insights.

- Generated and maintained MIS reports, monthly and weekly reports using Excel Advance for key stakeholders, providing actionable insights and analysis to drive informed decision-making.- Utilized SQL queries to extract and manipulate data from relational databases, ensuring accuracy and completeness of reports.- Provided ongoing support to senior analyst by addressing queries, and sharing reports.

• Founded and managed a dropshipping business, building and operating e-commerce stores on eBay, Shopify, and AliExpress.• Leveraged Oberlo and Dropified to streamline product sourcing, automatically syncing product listings and inventory with suppliers, which reduced manual workload by 40%.• Utilized AI tools like Sell The Trend and Zik Analytics to analyze competitor listings and identify high-demand, profitable products, increasing sales conversions by 25%.• Implemented A/B testing with Shopify apps like Vitals and Optimonk to optimize product pages and improve the customer experience, boosting conversion rates by 15%.• Analyzed sales data across over 1,000 transactions using Google Analytics and Shopify’s built-in reporting tools, leading to a 20% improvement in product selection and demand forecasting.• Employed pricing automation tools like RepricerExpress to stay competitive in real-time, reducing pricing errors and increasing profit margins by 12%.• Improved monthly revenue by 10% through data-driven decisions on product bundling, pricing strategies, and targeted marketing based on customer behavior insights.