Ruchi Moondra

• Collected, clean and analyzed IOT data of heat exchangers to develop a predictive maintenance solution using AWS services (Sagemaker, S3, Lambda function, etc.) & Time Series Forecasting. • Developed predictive models using AWS in-built functions to predict the time of clean for heat exchangers instead of scheduled maintenance period. • Analyzed the customer buying behavior via studying the product sale patterns to partners and customers across different product categories using exploratory analysis to identify growth opportunities. • Co-ordinated with product management teams to understand the product lifecycle and customer segmentation. • Worked with product managers to show the impact of unit price change on revenue and product sales over the time. • Designed a Tableau report which helps the commercial team to track the digital progress for placing the online orders.

Courses: Business Data Management (SQL) Data Analysis & Visualization (R Studio, Tableau) Data Analysis & Decision Making (MS Excel) Introduction to Data Science (Python) Analytics of Business Intelligence (R Studio) Business Analytics Programming (Python) Business Forecasting (R Studio) Statistics & Machine Learning (Python) Multivariate Analysis (R Studio)

• Led team of 5 people for creating Oracle Secure Content Management Application incorporating all the latest Oracle Technologies and AWS Services, resulting in transition of all the physical paperwork to the Virtual Asset Management, this reduced the Client’s physical paperwork by 20% in initial phase. • The encryption of the data was done at database level using TDE. • Using Python analyzed the data growth across different verticals for Database Designing, this reduced the manual efforts. • Built and delivered Business Intelligence KPI reports and dashboards that provided insights and provided decision making analytics.

•Transitioned the e-commerce legacy system to Websphere Commerce DB2, giving customers a rich user experience while doing online shopping. •Improved the Billing cycle by 4hrs through performance tuning, resulting in decreased response time to customers after making purchases. •Formed a Dashboard for reporting/analysis purpose by selectively combining the data from various online sites using Golden Gate and Python for better warehouse and inventory management and sales, this resulted in 8% increase in product management. • Encrypted the Sensitive information at the Database level resulting into enhanced security while doing the payments for Online shopping.

• Consolidated the small databases and scaled up the application, resulting in 15% decrease in logistics costs of maintaining various small applications. • Automated various day-to-day ETL processes, thereby increasing the work productivity by 12hrs/week. • Created a new Data Center to migrate the applications and databases, providing better up-time to the Client for Risk Management and Business Continuity.

•Served as Oracle DBA for 10+ medium to large-scale database implementations, managing projects from business requirements analysis to the solution delivery and support. •Developed and tested disaster-recovery plan, backup plan for critical databases, delivering solution that guaranteed recovery performance and high availability. •Provided database high availability and performance solutions for critical Billing and CRM applications to reduce lag time and ensuring 99.9% up-time for the application. •Won ACE Award for delivering high quality work while creating/implementing a Data Retention/Auditing plan for Sensitive Personal Information in CRM.