Resume

Sign in

Data Analyst

Location:
North Arlington, New Jersey, United States
Posted:
February 20, 2018

Contact this candidate

Rahul Patil Email: ac4ju4@r.postjobfree.com

*** ***** ******, ********, ** 07029 Ph: +1-862-***-**** LinkedIn: https://www.linkedin.com/in/rahulp22

PROFESSIONAL SUMMARY

3+ years of experience as a Data Scientist / Business Analyst with ability to deliver valuable insights via data analytics and advanced data-driven methods in demanding market segment while working for Fortune 500 industry clients.

Proficient in Data Analytics, ERP Systems, Business Intelligence, Applications & Reports Development. Passionate about expanding my skill set and knowledge in the field of Big Data, Data analytics.

PROFESSIONAL EXPERIENCE

9Edge Inc : United States Jul 2017 to Current

Worked as Business Data Analyst on developing Applications / Reports on Oracle ERP systems and Oracle Business Intelligence (OBIEE) for client Edward Life Sciences.

Incorporated Rational Unified Process (RUP) to create Business Requirement Document Specifications using MS Visio and MS Word.

Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio

Gathered client technical requirements for development. Created SQL test scripts for diverse group from the Application team, Testing team, Business partners which were used for application and reports verification.

During the Design and Testing phase, tasked with creating a sample production test data to be used for entire project. This was done by collaborating with various teams to gather testing requirements.

9Edge Inc : United States [ Spring Internship ] Jan 2017 to Apr 2017

Worked as Data Analyst Intern on developing of reports on Oracle Business Intelligence and MicroStrategy developer tool for pharmaceutical client Baxter.

Gathered client requirements and created Requirement specification documents (RSD) for development.

Used SQL queries for organizing and abstracting data from different data source for creation of reports.

Validating developed reports and testing with help of functional team on the client end.

Successfully completed the project of creating and upgrading of 300+ reports during internship.

KPIT Cummins Info systems, Mumbai, India Jan 2013 to Jul 2015

Worked as Technology Consultant on ERP Oracle JD Edwards Enterprise One (9.0/9.1) / Business Intelligence for Clients Weatherford International, B.E Aerospace, Chevron Corporation.

Worked throughout SDLC implementation cycle form gathering of client requirements to development and testing.

Accumulated system requirements from various departments like accounting, IS (Information Systems) through surveys and interviews.

Conducted JAD sessions with process owners and architects for analyzing and validating business requirements.

Designed process flows using Entity Relationship diagrams by collaborating with clients to analyze business processes.

Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio.

Captured Data flow diagrams and formatting of the data flowing through interfaces

Worked on development / upgrade of Applications, Reports, Table Conversion, Power Forms, and BI publisher on Finance, Sales & Distribution, Inventory Management, Manufacturing, AP / AR modules.

Facilitated user acceptance testing and test strategies with Information Systems Group.

Performed manual front-end testing to check all functionalities of different modules.

Suggested measures and recommendations to improve the current application performance.

Led the development of a training program to train users on a custom applications and Reports.

Managed Production environment support after GO Live and to resolve customer issues on Ticket system for 100+ countries.

SKILLS

Languages: Java, R, Python, JavaScript, HTML5, CSS,SQL, PLSQL, Unix Scripting, SSRS, SSAS

Certifications: Oracle SQL / PLSQL, Oracle Business Intelligence Enterprise Edition (OBIEE), Bloomberg Market Concepts

Database: MS SQL Server 2008, Oracle 10G, MySQL, SQLite

Big Data Ecosystem: Hadoop, MapReduce, HDFS, Spark, Pig, Hive, HBase

Tools: Oracle JD Edwards Enterprise One, Oracle BI Publisher, SAP (Classroom Knowledge), SharePoint, Microsoft SQL Server, Eclipse, Net Beans, MS Office, Axure, Rapid Miner, Tableau, SPSS, R-Studio, SVN, JIRA

EDUCATION

New Jersey Institute of Technology, Newark, NJ Year: May 2017

Masters in Information Systems CGPA: 3.4 /4.0

University of Mumbai, India Year: 2011

Bachelor of Engineering in Computer Engineering GPA: 3.50

Related Course Work:

Enterprise Database Management User Experience Design System Analysis & Design Information System Principles Data Analytics Business Process Innovation Information Retrieval Corporate Finance System Security and Auditing Data Structures & Algorithms Enterprise Architecture and Integration

ACADEMIC PROJECTS

Group Finder App: Aug 2015 to Dec 2015

A UX design application developed in Axure to help students find and make group with classmates for their course assignments and projects. It allows users to create user account and select courses and accordingly select group members on skillset and contact them through email to form project groups.

EPA’S Database: Sep 2015 to Dec 2015

To apply normalization techniques to remove data duplication and redundancy from over one million database records.

To restructure database tables and join them using primary and foreign keys and to ensure faster query processing for data retrieval.

Business Intelligence Model of Whole Foods Market: Feb 2016 to May 2016

Developed a data model for different retail processes of Whole Foods Market using Erwin.

Created a Data Warehouse and Business Intelligence system using dataset of Whole Foods aimed for better insights on how to increase the sales of their products.

Used Tableau and R to visualize data patterns and correlation to suggest future business scope

Web Crawler for Information Retrieval: Sep 2016 to Dec 2016

To implement web crawler in python to filter domain specific web pages.

To implement Dice coefficient and EMIM in Whoosh which is a python search engine library.



Contact this candidate