Data Engineer

*******.********@*******.*** 862-***-**** Harrison, NJ 07029 linkedin.com/in/alekhyavv-analyst/ GitHub/AlekhyaVV SUMMARY

Detail-Oriented Analytical Professional with 7+ years of experience in generating and analyzing data reports to help Business make informed decisions, gained vivid business knowledge by working closely with customers and BI Analysts. Areas of Expertise include:

● Data Warehousing ● Business Data Modelling ● Project Management

● Business Intelligence ● Reporting and ETL Tools ● Process Documentation

● Data Cleaning ● Microsoft Excel and SQL Server ● Pandas, NumPy, Matplotlib

● Data Analysis ● Database Management ● SQL

● Data Visualization ● Agile, Waterfall ● Python, R EDUCATION

Master of Science in Information Technology and Analytics (GPA: 3.93/4.0) Aug 2019-Present Rutgers Business School, New Jersey Expected Graduation: Dec 2020 Bachelor of Engineering in Electronics and Communications (GPA: 3.53/4.0) Jun 2008-May 2012 Andhra University College of Engineering

WORK EXPERIENCE

Oracle, Senior Business Intelligence Engineer Aug 2017-Aug 2019

• Analyzed Cloud-Order and Cloud-Subscriptions subject areas and redefined the business data models using ODI and OBIEE tools.

• Developed dashboards and scheduled delivery for 3 Cloud applications using Oracle DVCS and IBots and saved 200-hour manual effort.

• Investigated the Oracle Cloud Data Platform system and Presented Data Security rules and applications in the system to the management.

• Performed Unit Testing for developments on ODI packages/PLSQL scripts and delivered 0% error outcomes with optimized query. Accenture, Senior Software Engineering Analyst Dec 2015-Jul 2017

• Worked for Royal Sun Alliance, a multinational insurance company in UK as Senior BI Developer providing business insights to clients.

• Involved in regular customer interactions in learning business requirements and developed/scheduled 12 real time-apps using Qlik tools.

• Collaborated with database developers to communicate business requirements and helped design data models for 2 system applications.

• Managed a team of 13 members and mentored peers on deliverables. Received Accenture Team Award in December 2016 for teamwork. Accenture, Software Engineering Analyst Aug 2013-Nov 2015

• Summarized information over period of 10 years on a motor product adhering to agile methodologies and delivered 6 migration reports.

• Automated dynamic report generation through VB code in MS access and saved 120 hours of manual intervention with 0% defects.

• Designed BI Solutions by gathering requirements, analyzing data, debugging output irregularities for better business decision-making.

• Received Accenture Excellence award as Best Performer of the team in Sep 2013 and FS Certified in Insurance domain in Jan 2013. Accenture, Associate Software Engineer Jun 2012-Jul 2013

• Delivered a total of 83 regular operational reports in a month to customers and troubleshooted more than 30 report and cube issues.

• Improved business report performances by following best practices and saved report running time by a total of 700+ hours annually.

• Designed 22 technical documentations, includes common issues, impacts, problem-solving techniques, process improvement and scope. PROJECTS

Flight Delays Predictive Analysis Aug 2019-Dec 2019

• Data Extraction and Data cleaning in large datasets from bts.gov to analyze and predict flight delays. Used data imputation to clean the dataset, used relational database knowledge to combine multiple tables and develop a statistical model. Platform: Jupyter, Python IT Strategy on Dominos Aug 2019- Dec 2019

• Designed the IT strategies after high quality research for Dominos by maintaining business integrity of the company under guidance of Dr. Cherif Amirat (IEEE CIO). Analyzed business strategy and prepared a comprehensive IT strategy followed by presentation. Linear Regression Diagnostics on Social Networking Companies Aug 2019- Dec 2019

• Used R for scripting, visualization and Microsoft excel for simulation. Decided the best company to invest on via data visualization post data cleaning, data processing and streamlining data and checked for linear regression assumptions before putting the Regression model and defining related statistical attributes on it. Platform: R Programming TECHNICAL SKILLS

Languages: R, Python, SQL Libraries: Pandas, NumPy, Matplotlib Tools: Jupyter, Spyder, Oracle BI EE 11g, Oracle DVCS, ODI, Qlik Sense 3.1, Qlik NPrinting, Tableau, IBM Cognos, Business Objects, SSIS, Excel Reporting, Base SAS, Microsoft SQL Server, JIRA, HP Quality Center, Confluence

Contact this candidate