Vikas Panwar Email & Phone Number

Gurugram, Haryana, India

• Developed algorithm to detect recurring transactions for enhanced analysis across verticals for the purpose of creating strategies from both the merchant & customer side. This strengthens product reach and marketability.• Aiming for process automation to minimize analyst involvement as well as minimizing the error, with highest quality work.• Creating dashboards to visualize process efficacy, aiding algorithm refinement or process enhancement.• Leading a team of 4, dissecting dashboard data for accuracy or delay insights.• Redesigning the existing algorithms or processes for precise results within optimal timeframes

Gurugram, Haryana, India

1. Spearheaded a 3-member team in enhancing client data operations for precise merchant identification.2. Amplified data quality by integrating 3rd-party bank data into the merchant repository, augmenting location details using spectrum engine, including latitude and longitude.3. Innovatively employed pyspark to establish a robust data audit foundation, ensuring merchant repository accuracy while efficiently geo-tagging merchants.4. Evaluated potential data sources for seamless integration, optimizing tracking of merchant transactions.5. Devised management dashboards, enabling swift identification and resolution of data quality issues within the repository

Gurugram, Haryana, India

1. Developed diverse dashboards for intuitive data visualization, enabling pattern recognition and comprehension.2. Pioneered process automation, diminishing manual involvement, and ensuring prompt outcomes for standard requests.3. Streamlined existing procedures, resulting in reduced time and resource expenditure.4. Orchestrated Model Development targeting Merchant Identification & Data Cleaning.5. Employed Multi-Class Linear Regression, deriving scores from selected features for precise identification.6. Demonstrated an impressive 84% accuracy with the model, using unbiased data randomly chosen by Management for rigorous testing.

Gurgaon, India

• Revamping fulfillment process through Hive & Tableau, facilitating data comprehension and visual representation.• Profiling client strengths, weaknesses, and improvement areas. Crafting and refining effective solutions, aligning requirements, processes, and recommendations for success.• Crafting detailed functional specifications and system designs for clients, primarily utilizing SAS, Hive, & Tableau.• Extracting insights from diverse sources to uncover trends, opportunities, and risks.• Collaborating with cross-functional teams to bridge information gaps and strategize data provision.• Engineered comprehensive dashboards showcasing fraud stats, transactional trends, and merchant performance relative to peers across Acquirer & Issuer Banks.• Employed k-Means cluster analysis for customer segmentation, optimizing marketing strategy by deepening customer profiles with insightful KPIs, enriching customer understanding

Hyderabad Area, India

Demonstrated prowess in analysis, problem-solving, organization, and interpersonal finesse. Adept at engaging seamlessly across all organizational tiers—board executives to cross-functional teams. Facilitated team growth by assisting in data analysis templates.Roles & Responsibilities:1. Crafted variance and summary reports in R, encompassing Profit Variances and Budget to Forecast Analysis.2. Compiled interactive Dashboards using Tableau, housing custom filters and graphed events, fostering effective monthly result and budget scrutiny.3. Utilized advanced Excel to meticulously track budgets across diverse Deloitte business units, overseeing expenses, billings, and transactions.4. Generated concise, model-ready reports via SAS, pivotal for model development and validation.5. Condensed datasets, spotlighting essential project elements and exhaustive result analysis, bolstering informed decision-making and predictions.

New Delhi Area, India

Operating in the AML division entails meticulous analysis via advanced Excel, extracting client data for Transaction Filtering & cross-referencing with the Global Client Screening Database. Prioritizing due diligence is crucial.Roles & Responsibilities:1. Skillfully deploy Excel & fundamental SQL queries to deconstruct data, yielding valuable insights for pivotal business inquiries.2. Harness advanced Excel proficiency to extract payment details from extensive datasets, rigorously inspecting for precise anomaly identification. Leverage backend tools like world check & transaction system, presenting outcomes in varied formats for both internal and external stakeholders.

Noida Area, India

Conducted in-depth analysis of equity market efficiency, encompassing Market Size, Liquidity, Volatility, and Efficiency. Explored the past 5 years (2007-2012) using specialized company software for capital market analysis. Devised a comprehensive investor questionnaire to examine investment trends and patterns in the capital market.

The project was done under the mentorship of Mr. Puneet Gupta in order to have a research on "Financial Inclusion- Mutual Funds"The Responsibilities given were as follows:Collecting data on the rules & regulations made by Indian Government over Financial Inclusion.Confirming whether people know about Financial Inclusion policies made for them.Helped team members in preparing questionnaire in knowing the perspective of people for whom policy is being made.Analyzed the data & helped in getting to a conclusion.Presented the results with other team members in front of the consultancy for whom the project was made.

Gurgaon, India

• Prepared reconciliation statements, executed vendor payments, and established databases.• Conducted a Comparative Study between Marketing Strategies of Bharti Airtel & Vodafone.• Analyzed business positions, gathered and compared marketing strategies, manufacturing processes, etc.• Assessed effectiveness in countering aggressive competitor marketing strategies for both telecom giants

Mba, Finance & It

Bachelor Of Business Administration - Bba, Business Administration And Management, General

12Th, Commerce