DEEPA VENU

San Jose, CA ***** • 408-***-**** • adj1je@r.postjobfree.com • www.linkedin.com/in/deepavenu

Education

Master of Science in Engineering Management Aug 2019 - 2021

San Jose State University, CA, GPA - 3.8/4, Phi Kappa Phi Honors.

Master of Science in Information Technology Management (Transferred) Aug 2018 – May 2019

Campbellsville University, KY, GPA - 4/4.

Bachelor’s in Computer Science and Engineering Aug 2010 – May 2014

Anna University, Chennai, India, GPA – 3.8/4; Certified University Rank Holder of 48 out of 8069.

Professional Skills

Lean Six Sigma, FMEA, DMAIC, Lean Manufacturing Techniques, Value Stream Mapping, Kano Model, 5s, Ishiwaka, TQM.

Software Skills

Programming: PL/SQL, TSQL, MSBI, Jile, Jira Python, R, Java, JavaScript, C & C++, SQL, XML, HTML, CSS, Angular JS, Visual Studio.

Frameworks/Components/APIs – Junit, Servlets, JDBC, Basics of WCS.

Test Automation Tools – Selenium Web-Driver.

Web Objects locating strategies – XPath, CSS.

Test Methodologies – Waterfall, Agile.

OS Types – Mac OS, Windows, iOS, Android, Linux.

Tools - HP service manager, Eclipse, SQL Developer, WCS-Management Centre, Admin Console, SVN, ALM, JIRA, Notepad++, SiteScope, APAR, MS-Project, Tableau.

Certifications

SAFe® Certified

R Basics - R Programming Language Introduction.

Introduction in programming using SQL

Regression Analysis/ Data Analytics in Regression.

Certification in Web Component Development using JAVA Technologies.

Object Oriented Programming Using C++.

Programming in C# Certification.

Professional Experience

Data Analyst Intern, Stone Universe. Inc, San Lorenzo, CA Feb 2020 – Sep 2020

Planned, designed, and implemented application database code objects, such as stored procedures and views. Experienced in database design, development, and data modeling.

Worked closely with the development team to provide support for database objects (stored procedures/triggers/views) and performing code review.

Developed PL/SQL scripts, indexes, and complex queries for data analysis and extraction.

Strong ability in Microsoft SQL to create or alter existing tables, views, aggregate functions, sequences, and hierarchical queries.

Provided database coding to support business applications using T-SQL.

Performed quality assurance and testing of SQL server environment.

Analyzed root causes in case of solution failures.

Developed new processes to facilitate import and normalization, including data file for counterparties.

Worked with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.

Ensured best practices are applied and integrity of data is maintained through security, documentation.

Developed and maintained database feeds and ETL processes using SSIS. Through SSIS deployed and debugged projects.

Designed and developed complete ETL/SSIS processes.

Efficiently moved and transformed data for Operational Data Store (ODS), Staging, and Data Warehousing

Worked independently as well as within a distributed global development team.

Broadened skillsets and learned a secondary technology when required.

Assistant Systems Engineer, Tata Consultancy Services, Chennai, India

Role – Developer and Tester Sep 2015 to Feb 2016

Client – General Reinsurance Corporation

Managed and involved the development of the application of a Re-insurance client. Have experience in handling and developing the application from the database to the front-end interface.

Used functionalities of AngularJS (extensive usage of $scope, ng-controller, ng-grid, ng- model)

Created the user Interactive web pages by HTML/ HTML5, XHTML, and CSS3.

Adapted Angular.JS MVC Framework during the development of the web application.

As a tester prepared Test Plan, Test Cases, Test Automation scripts and Test Metrics.

Implemented continuous integration using Jenkins.

Developed and executed SQL queries to verify proper requirements of data storage in MS SQL Server.

Done intensive QA testing on different devices – iOS, Android (Mobile, Desktop, and Tablets).

Reported Defects and worked with the development team to debug the issues and documented the reports for team members for future references.

Role – Product Support Engineer

Client – Hewlett Packard Enterprise Jun 2014 to Sep 2015

Managed the technical operations and Enhancement team for the large-scale distributed system.

Used IBM WebSphere Commerce Suite (WCS) tool to develop their site.

Administered Data loading and propagation (DLP) on a daily routine.

Worked on WAS Application, IHS, Solar servers, to perform Secured Shell (SSH) key sharing, configuration changes, start or stop of JVMs, Nodes, DMGR, and Error analyzing in runtime logs.

Monitoring server's health 24x7 by setting up SiteScope Monitor, where the monitors are configured to alert us whenever the threshold of various components (CPU starvation and Fluctuations, Timeout Exception, Approaching MaxClients, Ping, Diskspace, and Proc) is met.

Installation of APAR, SSL Certificate of the Web servers and WAS server upgrade were performed.

Employed Jenkins tool to migrate the upgraded applications to production live.

Worked as part of the Incident Management team to ensure that the performance of the team achieves within SLA and KPIs.

Academic Projects:

1. Operation Planning & Control in Vikings Division: Aug 2019 – Dec 2019

Each product’s historical data was analyzed and forecasted sales for the next five consecutive weeks.

Use of five different forecasting techniques to minimize the MAD.

Developed production plan, level, chase, and mixed policies.

MRP for all the four sub-products was calculated using the given ordering policy, safety stock and lead time.

Developed MPS record which included the planned order release of each sub-product from the MRP.

Capacity planning was developed for each of the sub-products and the combination of it all produced the aggregate capacity bill.

Performed cost analysis to minimize the cost-efficiency.

2. Process Improvement Project at Stone Universe Inc: Aug 2019 – Dec 2019

Identified the process lags that are contributing to the decreasing customers and applied Six Sigma DMAIC, Ishikawa diagram, 5Whys, X charts, Probability plots and Hypothesis test and improved the efficiency by reducing wait time to 36%.

Employed agile project management tools such as JIRA, Jile and Active Collab.

Designed an online application for customers to reduce wait time.

3. Project Management: Analysis of Software Publishing Industries using Financial Ratios Jan 2020 – May 2020

Analyzed software publishing organization with the same NAICS Code (511210) based on financial ratios.

4. Business Analytics - Statistical analysis (logistic ordinal regression) of smart phone pricing by R Jan - Mar 2020. Project was built through three below phases.

Selection of Database and cleanup: Found a perfect dataset about mobile price classification from Kaggle. Cleaned the data for analysis using R, interpreted unknown variables, classified outliers.

Data Analysis: Analyzed the data using columns (variables) smartphone features like RAM, battery usage, internal memory, height, and pixel width across various mobile phone price ranges. Performed a logistic ordinal regression and correlation analysis to determine the features that affect the pricing strategy of mobile phones. Worked on the data and predicted the pricing using regression and classification Model.

Data Visualization: Created visualizations using the data to interpret\communicate results. Created plots and dashboards using ggplot2 and gganimate.

5. Supply Chain Analysis and Expansion of Walmart: Aug 2020 – Nov 2020

Explored Walmart's business decisions, including its mission and vision to serve the customers, competitive strategy, supply chain strategy, and how they are achieving a strategic fit and delivering values. As a team, we provided recommendations and solutions from the supply chain perspective to overcome challenges while achieving a strategic fit. Utilized decision tree analysis and Gravity location model for finding optimal distribution center in India, and as a result, we obtained "Madhya Pradesh" as a new location. Also, analyzed the biggest challenges in designing the network model in this location.

6. Grocery/Convenience Store Capacity Tracker Aug 2020 – Nov 2020

Designed an application for the customers that track the number of people at a given time in grocery/convenience stores using an AI device and provide current status about the capacity of utilizing an application as an interface. The system would make it easier for people to shop in an organized environment and have a safe shopping experience while adhering to the social distancing norms.

7. Cryptography in Systems and Network Security Aug 2018 - Dec 2018

A comparative study between various encryption algorithms like AES, DES, RSA, 3DES, and MD5 has been provided and their real-time applications were analyzed.

Contact this candidate