Shivani Rana Email & Phone Number

Bentonville, Ar, Us

Bentonville, Arkansas, Us

Espoo, Southern Finland, Fi

Espoo, Southern Finland, Fi

AS&C Portfolio, Practices & Solution Co-op• Assembling unstructured document data into a structured data lake• Developing a pipeline for uploading and accessing business documents using PowerApps and PowerAutomate• Provide consultation on following Data Management principles and Data Integrity• Provide logic for Metadata tagging on SharePoint document libraries• Automate document audit and provide statistics and inventory on documents using PowerBI

Chicago, Illinois, Us

Data Science Practicum, Research & Development Unit• Collaborate on lemmatization, tokenization and vectorization of Reuters data to perform multi-label classification across 20 diverse classes• Experiment on RNN with decay and class weights as well as Random forest, Logistic Regression, SVC, Ridge, KNeighbors, ExtraTress classifiers with a OneVsRestClassifier wrapper to generate multi-labeled predictions• Achieved 88% micro F1-Score using Stacking and maintained a 90% minimum precision score for each class in highly imbalanced dataset

Mumbai, Maharashtra, In

Developed and deployed quality SQL codes, stored procedures, views, functions, triggers and jobs• Designed and Populated specific tables, databases for collection, tracking and reporting of data• Developed SAP BW reports to reconcile data across 4 unique relational database systems to ensure integrity of sales data by performing advanced JOIN operations on tables differing in schema and data granularity• Performed advanced queries on views, and tables in SAP HANA database systems which was used in the Web Service reports to make real time and end of the day sales information available for 4000 Reliance Stores across diverse formats• Developed SQL based data analysis procedures for various reports to detect fraud, resource wastage, track logistics and inventory, curbing card-based frauds and goods loss by 30% over a span of 7 months• Optimized querying on Tax tables by developing advanced JOIN and aggregate queries to populate data in a Tax summary table• Worked on advanced SQL queries for Tableau reports and Email based Business Alerts to display current and historical data• Used advanced Microsoft Excel to create pivot tables and Pivot reporting, as well as used VLOOKUP function• Migrated and deployed Oracle based Tables, Views, SQL queries and procedures to SAP HANA Database systems• Worked closely with business heads to understand their needs and the data behind them, to enhance data reporting and analysis.• Deployed a group of reports were developed to report void, completed, refund, return etc. transactions and were delivered across each store as a web service. The reports also monitored cashier activities and events occurring at the time of billing a customer• The reports were developed on SAP HANA Database systems and catered to OLTP and OLAP business requirements by querying and updating data on a real time basis and providing analysis of weeks or months old data.

Master'S Degree, Data Science

Bachelor'S Degree, Computer Engineering