Vijay Santhosh Kumar Krishnan Email & Phone Number

Bengaluru, Ka, In

Bengaluru, Ka, In

Greater Bengaluru Area

Data Integration and Transformation Solution for Strategic Planning:• Automated data extraction, transformation, and integration from Hyperion Essbase using Dataiku, employing SQL, Python, and Spark for complex data transformations. Enhanced data accessibility and operational efficiency, optimized storage in Exasol, and enabled real-time insights in Tableau, resulting in a 60% reduction in processing time and improved operational efficiency.Automated Data Cleansing and Transformation:• Developed an efficient Alteryx workflow automating data cleansing, transformation, and validation, reducing manual processing time by 70% and seamlessly integrating data from SQL databases, Excel files, and cloud-based APIs to improve accuracy and integration capabilities.Custom Macro Development for Workflow Optimization:• Engineered and implemented batch and iterative macros in Alteryx for automating dynamic data input handling, complex transformations, robust error handling, logging mechanisms, and cross-functional team collaboration to elevate data processing efficienciesEnterprise-wide Database Transformation with SAP Analytics Cloud and SAP DataSphere: • Played a key role in implementing SAP Analytics Cloud and SAP DataSphere, replacing legacy Oracle and Hyperion databases. Managed migration and integration for improved data accessibility and enhanced Tableau dashboard functionalities, facilitating strategic decision-making across all business units.

Greater Bengaluru Area

• Spearheaded the comprehensive end-to-end process for the Operations Dashboard, encompassing data extraction from MRC, loading into the Hive database, and dashboard publication and management, serving over 500 users.• Designed and deployed a highly acclaimed Tableau dashboard for the OMT team, receiving exceptional feedback from the CFO of Operations, recognizing it as one of the finest dashboards ever created.• Automating all daily and monthly activities using advanced macros, with plans to further enhance automation through Dataiku upon license acquisition.• Developing a strategic dashboard for Corporate Planning, enabling stakeholders to access and review their budgets significantly ahead of the traditional timeline.

Bangalore

Sales Analytics:• Manage a team of Analysts, Part of discussions on new projects/ reports/dashboards using Knime and Tableau. • Predict the propensity to win an opportunity based on the SalesForce.com (SFDC) data using logistic regression model• Drive adoption of analytical solutions across all the regions/markets through active consulting• Intensively use SFDC for creating customized visualization and suggest improvements in it to scale up effectiveness in Sales Process and predictive models• Win loss analysis: Identified win/lost opportunities in the sales pipeline, track the win-loss rate and provide insights to the sales team by analyzing past dealsFraud Analytics:• Detection of Fraudulent transactions for Customers as well as for Merchants using Mahalanobis Distance for Clustering and aggregating using R the transactions that are above and below the threshold values and providing visualization an output using ggplot.Market Basket Analysis:• Experience in developing Market Basket Analysis/Recommendation Engine, R Programming to study the customer buying pattern and help build a recommendation model using Market Basket Analysis; Social Network analysis to find influencers in social media and brand sentiment/complaint analysis. Penetration Tracker:• Built a complex Alteryx workflow for automation of mapping local team’s data to global scale. Thereby reducing the effort from 20 Days to 20 Minutes.• This involves using text search and match algorithms to mine the data for Monthly, Quarterly refresh. Data Quality checks, data reconciliation are other integral part of the model.• Developed a Scoring Algorithm using Fuzzy Logic in R (integrated within Alteryx) method to help automate Brand Level metric mapping to SKU Levels. Effort Saved by this activity is 75% • Pattern Recognition and identify similar SKU’s based on categories\regions for cross segmentation.

Bangalore

• Using 11 different Univariate Analysis (like RWF,Forecast,MEANF,etc.) built forecasting model using R Studio which helped the Finance Team to allocate their budget accordingly and delivered final output as an App using Alteryx.• Converted all the Predictive Models into an App using Alteryx, which helped the client and the company to reduce the dependency rate of resources to do any forecasting.• Used Multi Linear Regression to find the correlation between the variables for company’s different cost heads and using ARIMA, ARIMAX and predicted the relevant Cost heads Cost.• Identified, developed and implemented statistical techniques, algorithms and data mining analysis to create new solutions that addressed business challenge of allocating budget for Finance Team across the organization.• Created interactive tools using cutting-edge visualization techniques using Tableau.• Working closely with various teams across the company to identify and solve business challenges utilizing large structured, semi-structured, and unstructured data in a distributed processing environment.

Bangalore

• Developed Disambiguation Algorithm model using R Studio for a KYC Product.• Text Mining: Designed and implemented a Suppliers’ classification (more than 150 categories) engine using R and RapidMiner, for a procurement client in the US, using different statistical techniques like “Maximum Entropy”, “Support Vector Machine” and Naïve Bayes Classification.• Spend Analysis: Analyzed commonalities, Variances and built modules on Spend Data Analysis, Suppliers’ selection and set up a benchmark for one of the biggest real estate management client using R and Tableau.• Customer’s profiling & segmentation for a retail customer helped to come up with couple of segments which was used for targeted promotions• Developed Claims Reserve Prediction Model (Simple Linear Regression Model), lead comparison and Benchmarking of Claims using R, for one of the largest insurance organization in the world.• Developed R functions (Fuzzy Search, Lookup etc.) to clean the unstructured data into usable information using Text Mining techniques.

Bengaluru Area, India

• Analyzing and understanding various Futures instruments based on technical and fundamental parameters.• Applying statistical techniques to take positional calls in the instruments.• Preparing reports on individual International commodities and indices for proprietary desk.• Making strategies to build logic for quant trading.• Making strategies for arbitrage and spread trading opportunities.• Derivatives and derived trading strategies.• Interpreting economic data or economic events for the markets and instruments individually.• Determining market sentiment via research, valuation and data analysis

Mba, Finance

Diploma In Hotel Management & Catering Technology, Food Production