Home

JAYANT SAXENA - DATA ANALYST/PROJECT MANAGER

[email protected]

Location: Jersey City, New Jersey, USA

Relocation: YES

Visa: HIB

Microsoft Certified Data Analyst Associate Data Analytics Data Visualization Project Management PROFESSIONAL SUMMARY Results-driven leader with a strong background in data-driven roles, offering expertise in data analysis, programming (SQL, Python, R), and data visualization tools (Tableau, Power BI). Proven ability to lead cross-functional projects, optimize data processes, and enhance operational efficiency. Certified Data Analyst Associate with a track record of delivering impactful insights, fostering collaboration, and driving informed decision-making. Experienced in aligning with strategic goals and leveraging statistical techniques to provide actionable recommendations. Adept at problem-solving and communication, poised to excel as an Analyst. CAREER HIGHLIGHTS Leadership & Collaboration: Successfully orchestrated seamless data integration for multiple clients, resulting in a substantial boost in operational efficiency. Led cross-functional initiatives, defining scopes and objectives, leading to a remarkable 25% increase in project success rates. Fostered efficient communication channels across teams, enhancing data-related discussions, and overall efficiency through collaborative efforts. Data Strategy & Insightful Decision-Making: Produced impactful visualizations critical for guiding product management strategy, directly influencing a 20% improvement in product development. Proficiently employed programming languages and data visualization tools to elevate data quality, resulting in improved accuracy and data-driven decision-making. Collaborated closely with stakeholders to identify data needs and empower them with insights into the impact of their work. Efficiency & Process Optimization: Innovatively automated intricate EDI data processes using cData Arc ETL workflows, leading to heightened accuracy and substantial time savings of 20-25 hours per week. Engineered the optimization of data pipelines, achieving a notable 10% reduction in data processing time. Leveraged ETL & MFT tools (Alteryx, cData Arc) for automated data integration and transformation, significantly enhancing operational efficiency, and streamlining processes. KEY SKILLS Data Strategy Cross-Functional Collaboration Data Visualization (Tableau, Power BI) Programming (SQL, Python, R) Operational Efficiency Enhancement Project Management Leadership & Stakeholder Engagement Database Management (Microsoft SQL Server) ETL & MFT Tools (Alteryx, cData Arc) PROFESSIONAL EXPERIENCE Cardinal Integrated Technologies, New York, New York Power BI/Data Analyst Feb 2021 Aug 2023 Led cross-functional initiatives, coordinating scopes and objectives, resulting in a remarkable 25% increase in project success rate. Engineered optimization of data pipelines, reducing data processing time by an impressive 10%. Innovatively designed Power BI visualizations, pivotal for product management decisions, contributing to a 50% improvement in data transparency. While working at Cardinal Integrated Technologies, I have worked on various projects as a Power BI/Data Analyst. Some of the notable projects include: Sales Performance Dashboard: I was responsible for creating a Power BI dashboard to track the sales performance of the company. This involved connecting to various data sources, cleaning and transforming the data, and designing interactive visualizations to identify trends and patterns in sales data. The dashboard provided key insights to the sales team and helped in improving their overall performance. Inventory Management System: I was part of the team that designed and developed an inventory management system for a client in the manufacturing industry. My role involved creating data models, designing dashboards, and implementing data refresh schedules to ensure real-time availability of inventory data. The system helped the client in optimizing their inventory and reducing costs. Customer Segmentation Analysis: I worked on a project to analyze customer data and segment them based on their buying behavior and preferences. This involved using data mining techniques and building predictive models to identify the customer segments. The insights from this project helped the marketing team in creating targeted campaigns and improving customer retention. Iterative Analysis: Agile encourages iterative data analysis, allowing data analysts to continually refine their work based on feedback and changing requirements. Human Resources Analytics: I was responsible for creating a Power BI dashboard to track various HR metrics such as employee turnover, performance, and satisfaction. The dashboard provided a holistic view of the HR data and helped in identifying areas for improvement. Financial Reporting System: I worked on a project to design a financial reporting system for a client in the finance industry. This involved connecting to financial data sources, creating data models, and designing interactive reports to provide insights on key financial metrics. The system streamlined the financial reporting process and provided real-time visibility into the company's financial health. Reduced Waste: Agile minimizes the risk of spending significant time on analysis that may not be needed, as it allows for ongoing evaluation of the project's direction. IHS Markit Denver, Colorado Senior Data Analyst II Feb 2020 Nov 2020 Crafted impactful visualizations pivotal for product management strategy, positively impacting 20% of product development. Conducted in-depth data analysis, ensuring alignment with KPIs, and identifying areas for improvement. Designed, revamped, and managed multiple dashboards, fostering a 25% increase in cross-team collaboration and insights sharing. Utilized dashboards to bridge communication gaps across teams, accelerating project timelines by 10%. While working at IHS Markit as a Senior Data Analyst II, I have worked on a variety of projects in different industries such as finance, automotive and energy. Some of the projects that I have worked on include: Financial Market Data Analysis: In this project, I was responsible for analyzing market data to identify trends and patterns for various financial products such as stocks, bonds, and commodities. This involved gathering data from multiple sources, conducting statistical analysis and creating reports for clients to guide their investment decisions. Automotive Industry Forecasting: I worked on a project to forecast the sales and production of various automotive models for a major car manufacturer. This involved analyzing historical data, identifying market trends and incorporating external factors such as economic conditions, consumer preferences and competition into the forecast. Regular Feedback: Agile methodologies include frequent review and feedback sessions, helping data analysts refine their work and ensure it aligns with business goals. Energy Market Intelligence: In this project, I was part of a team that provided market intelligence to clients in the energy sector. My role was to gather and analyze data on global oil and gas production, consumption, and prices to identify market trends and provide insights for clients to make strategic business decisions. Risk Management Analytics: I worked on a project to develop a risk management model for a multinational corporation. This involved analyzing a large volume of data on financial transactions, market trends and macroeconomic factors to identify potential risks to the company s operations and provide recommendations for mitigating them. Market Research for New Product Launch: In this project, I conducted market research and analysis to support the launch of a new financial product for a client. This involved gathering data on customer preferences, conducting competitor analysis and forecasting demand for the product in different markets. Overall, my experience at IHS Markit has provided me with the opportunity to work on diverse projects, utilizing my skills in data analysis and providing valuable insights to support critical business decisions. Data Analyst Intern Jun 2019 Dec 2019 Automated EDI processes via cData Arc ETL, reducing manual effort by 40%. Managed cross-functional projects, defining scopes and exceeding deadlines. Enhanced processing speed 25% by optimizing data pipelines. Developed strategic Power BI visualizations, improving product insights by 30%. As a Data Analyst Intern at IHS Markit, I have worked on various projects across different business sectors including financial services, energy, and automotive. Some of the key projects I worked on include: Market Research and Analysis: I conducted market research and competitive analysis to identify opportunities for growth in the automotive industry. This involved collecting and analyzing data from various sources such as industry reports, company websites, and market databases. Data Visualization and Dashboard Creation: I was responsible for creating interactive dashboards using Tableau to visualize key metrics and present insights to clients. This helped in identifying trends and patterns in the financial markets and providing data-driven recommendations for investment decisions. Data Management and Quality Assurance: I worked on data management and quality assurance tasks, which involved cleaning and organizing large datasets, performing data audits, and ensuring data accuracy and integrity. This helped in maintaining high-quality data for accurate analysis and reporting. Forecasting and Modeling: I assisted in developing forecasting and modeling techniques for energy market data. This involved using statistical methods and building models to make predictions about market trends, prices, and demand. Customer Segmentation Analysis: I conducted customer segmentation analysis for a financial services client to better understand their target audience and tailor their marketing strategies accordingly. This involved conducting statistical analysis and creating visualizations to identify patterns and segments within the customer base. Overall, my experience at IHS Markit as a Data Analyst Intern provided me with valuable hands-on experience in data analysis, visualization, and forecasting in a corporate setting. I was able to work with a diverse range of clients and apply my skills to solve real-world business problems. Covia Corp Houston, Texas Market Analyst Intern Jun 2018 Aug 2018 Established an efficient well selection workflow, reducing selection time by 30%. Analyzed predefined metrics, leading to 10% increase in customer satisfaction and 5% growth in sales. Identified market opportunities and competitor activity, contributing to 2% growth in market share. As a Market Analyst Intern at Covia Corp, I worked on a variety of projects related to market research and analysis. Some of the projects I was involved in include: Conducting Competitive Analysis: I conducted a thorough analysis of the company's top competitors in the market, including their products, pricing, market share, and marketing strategies. This helped the company better understand their position in the market and identify potential areas for improvement. Market Segmentation Study: I conducted in-depth research on the target market for one of the company's new products. This included analyzing market demographics, consumer behavior, and trends to identify potential target segments and develop recommendations for marketing strategies. Product Launch Strategy: I worked with the marketing team to develop a comprehensive strategy for the launch of a new product. This involved conducting market research, identifying target audience, creating marketing collateral, and developing a launch plan. Marketing Campaign Analysis: I assisted the marketing team in analyzing the effectiveness of previous marketing campaigns, including digital advertising, email marketing, and social media. This helped the company gain insights into their audience's preferences and optimize future campaigns. Sales Forecasting: Working closely with the sales team, I used market data and trends to develop sales forecasts for the upcoming quarter and year. This helped the company make informed decisions on production and resource allocation. Overall, my role as a Market Analyst Intern at Covia Corp gave me valuable hands-on experience in market research, data analysis, and strategic planning. It was a great opportunity to apply my skills and knowledge in a real-world setting and contribute to the company's overall success. PUBLICATIONS & CERTIFICATIONS Microsoft Certified Data Analyst Associate Product Management Certification (Brain Station) What Tier Sand Should You Use for Your Well Practical Use of Data Analytics to Determine Proppant Type and Quality. Society of Petroleum Engineers. https://doi.org/10.2118/195226 -MS Saxena, J., Sedillos, L., Roundtree, R., Convers, C., & Dean, E. (2019, April 8). Slickwater, Hybrid, Self-Suspending Proppant: Practical Use of Data Analytics to Determine Hydraulic Fracture Fluids. Society of Petroleum Engineers. https://doi.org/10.2118/195304 -MS Saxena, J., Sedillos, L., Roundtree, R., Convers, C., & Dean, E. (2019, April 22) PROJECTS/EXTERNSHIPS Colorado School of Mines Golden, Colorado Well data Analysis using Spotfire & SPSS for Gas wells of COVIA CORP EDUCATION Colorado School of Mines Golden, Colorado MS, Engineering Technology & Management Dec 2019 BS, Petroleum Engineering Aug 2019 Keywords: business intelligence rlang information technology microsoft