Vijay Kumar Email & Phone Number

Toronto, On, Ca

Canada

• Serve as a Business Intelligence Consultant for Morgan Stanley through LanceSoft, working remotely to develop finance reporting solutions.• Utilize SQL, Snowflake, and Power BI to create and optimize financial reports, enhancing the quality and accessibility of financial data.• Implement complex DAX calculations to improve data visualization and in-depth analysis for financial performance and decision-making processes.• Collaborate with cross-functional teams to ensure the accuracy and efficiency of financial reporting solutions.• Contribute to the improvement of financial insights, enabling more strategic and data-driven decision-making across the organization.

Noida, Uttar Pradesh, India

• As a Business Insights and Analytics Manager, I provide strategic leadership in data analysis and insights generation. I utilize Power Bi, Looker, Python data visualization, SQL, Excel, and G-sheet API to drive data-driven decisions across various domains.• My role involves end-to-end ETL data pipeline management, ensuring seamless data extraction, transformation, and loading using Python. Proficient in SQL and Excel, I deliver actionable insights crucial for business growth. I also streamline data management and reporting by automating updates in Google Sheets with the G-sheet API and pull data from various APIs, enriching our datasets.• In addition, I leverage AWS services, such as AWS S3 for data storage and AWS EC2 for remote data access, enhancing our analytical capabilities and scalability. I have applied simple ML techniques for data-driven forecasting and basic pattern recognition. I collaborate with cross-functional teams to align data initiatives with organizational goals, contributing to informed decision-making and business success.

Gurugram, Haryana, India

• I excel in creating and managing Power BI reports, harnessing Advanced DAX, optimizing data models, and deploying visualization techniques that have yielded remarkable results. My initiatives have significantly slashed reporting times across diverse departments, enhancing operational efficiency and data accessibility.• I've played a pivotal role in steering business insights, informing strategic planning, and fostering data-driven decision-making. My expertise spans critical domains, including budgeting, execution, CRM, business planning, reviews, user behavior analysis, churn, and user retention. Actively contributing to the strategic planning process, I align data initiatives with overarching organizational objectives.• My prowess extends to designing and implementing robust data warehousing solutions, incorporating best practices and employing dimensional modeling techniques such as star and snowflake schemas. These endeavors have revolutionized data storage, retrieval, and reporting, enhancing data accessibility and analytical capabilities. I have developed and maintained end-to-end ETL data pipelines using Python, ensuring seamless data extraction, transformation, and loading processes. These pipelines efficiently integrate data from diverse sources, including databases, APIs, spreadsheets, and flat files, into the data warehouse, enhancing data quality and consistency for analysis. I have also utilized Python to build pipelines for Power BI datasets, streamlining data flows and enhancing efficiency.

• I specialize in crafting compelling data visualizations that offer insights at a glance. Proficient in DAX (Data Analysis Expressions), I've harnessed the power of data modeling to transform complex datasets into actionable insights. Leveraging VBA and Power Query, I've automated manual tasks, enhancing efficiency and reducing manual efforts in data-related processes.• I've designed and implemented efficient data pipelines, optimizing data flow and bolstering reporting capabilities. My expertise includes implementing Task Schedulers to execute Python scripts at predefined intervals, streamlining critical data processes. Additionally, I've developed Batch Scripts to capture warnings, errors, and bugs, ensuring robust error resolution.• I efficiently collected, organized, and inputted information into databases, ensuring data integrity and efficient retrieval. I've played a crucial role in collaborating with the metrics team to strengthen global reporting, maintaining consistency and accuracy in reporting across regions. My meticulous approach included rigorous testing, reconciliations, and ad-hoc issue resolution, ensuring the flawless creation, design, and deployment of reports. I've developed Python scripts to automate the assignment of daily, weekly, and monthly tasks, optimizing workflow management.

Chandigarh, India

Chandigarh, India

Chandigarh, India

Master Of Science - Ms, Computer Science

Post Graduate Diploma, Computer Application