Post Job Free

Resume

Sign in

SQL, PL/SQL, Tableau, AWS, OCI, Python, R

Location:
Pasadena, CA
Posted:
May 18, 2020

Contact this candidate

Resume:

MONIKA MISHRA

+1-626-***-**** addans@r.postjobfree.com Linkedln

PROFILE OF QUALIFICATIONS

• Proactive, results-driven professional with about 9 years of professional and academic experience in Business Intelligence, Analytics and Oracle E-Business Suite (11i/ R12).

• AWS, Tableau and Oracle Certified.

• Provided functional assistance for Oracle Requisition to Pay/Procure to Pay operations and processes.

• Adept in Descriptive and Predictive analytics leveraged with database & Big Data management.

• Skilled in Machine Learning – Supervised (Regression, Classification, Neural Network) and Unsupervised (K-Means Clustering, Recommender System) .

• Proficient in PL/SQL programming, SQL, Unix Shell scripting and Big Data analysis using Hadoop, Hive and Pig.

• Excellent communication and interpersonal skills working closely with customers during deputation in Australia.

• Strong logical, assessment and interpretation skills. EDUCATION

• Master of Science, Information Systems GPA – 4.00 California State University, Los Angeles, California Spring 2020

• Bachelor of Technology, Electrical Engineering

Biju Patnaik University of Technology, Bhubaneswar, Orissa, India June 2009 IT SKILLS

• Programming Languages: SQL, PL/SQL, R, Python, PySpark, Hive, Pig, Unix Shell Scripting

• Database and platform: Oracle 10g, TOAD, PL/SQL Developer, Putty

• BI Tools: Tableau, MS PowerBI, MS Excel PowerView, SAP Lumira, SAP Predictive Analytics, SAS Visual Analytics, SAS Studio, Kibana (ELK Stack).

• Oracle Tools: Oracle Reports Builder, Oracle Workflow Builder, Oracle Discoverer

• Machine Learning Platform: Databricks Community Edition, Microsoft Azure Machine Learning Studio, Oracle BDCE, Apache Zeppelin, SAP Predictive Analytics, Elasticsearch and Kibana, IBM Watson Studio, Amazon Web Services (AWS) PROFESSIONAL EXPERIENCE

Consultant

Company: Tata Consultancy Services Location: Kolkata, India Period: October 2015 - October 2017

• Resolved Remedy Tickets.

• Advised solutions to the problem areas in Requisition to Pay cycle.

• Coached the technical team about issue resolution.

• Tested functionality of the new solution/bug fixes and prepared test cases.

• Explored areas of improvement in the Supply Chain Management process. Subject Matter Expert

Company: Tata Consultancy Services Location: Kolkata, India Period: August 2014 - October 2015

• Managed all the steps of Software Development Life Cycle (SDLC).

• Briefed about the progress of our work to the clients in the weekly meeting.

• Designed solutions and prepared estimates for the new components.

• Delegated duties to the other team members.

Technical Lead

Company: Tata Consultancy Services Location: Perth, Australia Period: January 2014 - August 2014

• Led the five-member team involved in fixing code for the upgrade project of Oracle EBS from Oracle 11i to Oracle R12.

• Tested the fix and prepared test cases.

• Redesigned solutions to meet customer requirements and reviewed all deliveries to ensure the quality.

• Achieved 100 % CSI (Customer Satisfaction Index). Developer

Company: Tata Consultancy Services Location: Kolkata, India Period: March 2010 - January 2014

• Analyzed business requirements, assessed the data and developed codes using Oracle tools and Unix Shell scripts.

• Prepared test cases, technical documents and functional documents.

• Collaborated with my team and developed a solution that automated the order response from the B2B suppliers.

• Optimized the inventory by developing a solution for the cost reduction by creating a custom workflow that tracked items.

• Prepared SQL reports and discoverer reports based on SQL queries. CERTIFICATIONS

• Oracle Cloud Infrastructure Foundations 2020 Certified Associate

• Oracle Autonomous Database Cloud 2019 Certified Specialist

• AWS Certified Cloud Practitioner

• Tableau Desktop Specialist

• Oracle E-Business Suite 12 Supply Chain Certified Implementation Specialist: Oracle Purchasing, Oracle Order Management, Oracle Inventory

• Oracle E-Business Suite 12 Financial Management Implementation Specialist: Oracle Payables.

• Oracle PL/SQL Developer Certified Associate, Oracle Database SQL Certified Expert. PROJECTS

• Analyzed revenue and attendance of Los Angeles Zoo using Tableau as a partner of Data Science Federation of Los Angeles City.

• Developed a system in AWS to detect objects in an image and send the output to subscribed email address.

• Analyzed product review data using Hadoop and Hive. Visualized the data using Tableau, PowerBI and excel power map.

• Predicted products’ ratings on Amazon website using Azure ML and Spark ML.

• Analyzed hospital readmission using SAS Visual Analytics and diabetic encounter analysis using SAS studio.

• Superstore data analysis using R. Analyzed LA Energy and Water Efficiency Statistics using Tableau.

• Drug review analysis using Elasticsearch and Kibana.

• Analyzed a B2C E-commerce site using SAP Predictive Analytics. Also used machine learning techniques to segment the customers and predict yearly amount spent.

PUBLICATIONS AND CONFERENCES

• “Rating Prediction using Deep Learning and Spark” at the 11th International Conference on Internet

(ICONI 2019) – Hanoi, Vietnam December 2019

• "Big Data Predictive Analysis of Amazon Product Review" at the 14th Asia Pacific International Conference on Information Science and Technology (APIC-IST 2019). - Beijing, China June 2019

• “Predictive Analysis of Amazon Product Review” at SWRC (South Western Regional Conference). Chapman University School of Pharmacy, Irvine April 2019 AWARDS AND ACKNOWLEDGEMENTS

• Recipient of Non-Resident Tuition Fee Waiver for maintaining a high GPA June 2019

• Honored with special recognition award for high scholastic achievement in graduate studies April 2019

• The 3rd place, “Predictive Analysis of Amazon Product Review” at SWRC

(South Western Regional Conference), Chapman University School of Pharmacy, Irvine April 2019

• ‘Your Example Shines’ award - Multiple times during my work period in TCS March 2010 – October 2017



Contact this candidate