Data Analyst Software Development

MEGHA PATEL

**** ******* **, ********** ** *****

CELL # 201-***-**** *************@*****.***

Professional Summary:

I have knowledge in PC hardware support, networking, windows desktop operating system, Microsoft Office, software development. Also do have experience with Oracle, Tableau, Power BI, SAP, JDE, P6 Primavera, Access Database, SEER, URB tool. I have gained knowledge to work with Inventory, planning, operation, PMO, SharePoint, sales, manufacturing and purchasing department. My enthusiasm and creativity in solving interesting problems had made it possible for me to grow in upward dimension.

Professional Experience:

The Carian Group (PSEG Client)

Lead Data Analyst, South Plainfield NJ 05-2020 to Present

• Moving from Large projects (RTEP) group to COE (Center of Excellence) group with all analyst people

• Working with Access Database, Large data sheet in Excel, SAP, SEER FM and P6

• Perform all projects request from manager to run Monthly recurring reports to handling ES2, RTEP Portfolio

• Run reports in SAP, P6, Database systems

• Close Working with Cost Engineers and Schedulers, also with PCE/PCS Leads to get accurate projects information besides systems

• Work with Manager to improve reporting platform and accuracy with source data

• Helping with different group to get request for create new reports/Analysis

• Performing and delivering project life cycle reports/Analysis to see where we are stand by project performance and if we need to improve on that project and delivers to managers and directors

• Working with COE team to get life cycle information and timely run reports with accuracy and finish deadlines

• Working with GM team to collect forecast data for reporting cycle and communicate with them for accuracy reporting submission

• Working with accounting team for tracker file to reconcile with ES2 RateCase

• Perform Monthly, Quarterly and Yearly reports in advance excel with using different resource tools The Carian Group (PSEG Client)

Lead Data Analyst, South Plainfield NJ 08-2018 to 05-2020

• Performing Weekly, Monthly, Bio-Weekly, yearly reports and Analysis

• Working with Large capital projects in DP & C

• Perform all projects request from manager to create in Excel, Power Point, Charts and Analysis, etc.

• Run reports in SAP, P6, URB and SEER systems

• Close Working with Cost Engineers and Schedulers, also with PCE/PCS Leads

• Work with Manager to improve PCE/PCS process for our business

• Helping with different group for Project Cost/Activities analysis

• Performing and delivering project life cycle reports/Analysis to see where we are stand by project performance and if we need to improve on that project

• Checking workload by PCE and PCS to manage our team work

• Running the large portfolio for TPIS and managing those projects (Transmission project in Service) Sound United (D+M Group)

Data Analyst, Corporate – Operation Department 01-2017 to 08-2018

• Performing daily Mitel System and Bright Pattern Reports (Call System)

• Updating refurbish, warranty repairs records (Advance Excel, Pivot table, VLOOKUP, charts)

• Perform all projects request from manager to create in Excel, Power Point, Charts

• Run reports in ADMS, JDE and export in Excel for analysis

• Run reports in Oracle for Customer service analysis

• Create daily/weekly/monthly/yearly Power point, Excel Repots

• Work with supply chain to improve parts inventory order process

• Managing MIS (month in service) charts reports (sales and returns base) RAB LIGHTING

Data Analyst - Manufacturing Department 07-2016 to 01-2017

• Performing ADS and Excel/Power Point Reports (LDM Charts)

• Perform all task/report request from managers and supervisors

• Create daily/monthly/yearly PowerPoint/Excel reports

• Create safety reports for HR dept.

• Check inventory and make the schedule for work order CRESTRON ELECTRONICS, INC.

Service Data Analyst - Service Department 11-2014 to 07-2016

• Performing SAP and BW Reports

• Solve problems related in CRM and SAP software

• Perform all task/report request from managers and supervisors • Gathering data for analysis to pinpoint trends and/or relevant analytics

• Keep track of stock information for parts and update as required.

• Liaison with purchasing and Inventory department to determine business demands

• Create monthly/yearly PowerPoint reports

Service Administrator - Service Department 05-2013 to 11-2014

• Run service reports in SAP (exporting and manipulating in excel) promptly and correctly for the upper management

• Assist supervisor and Business Analyst in running and sorting product and personnel reports

• Solve problems related to data entry with SAP and CRM software Data Entry - Service Department 08-2009 to 05-2013

• Finalize service orders quickly and precisely so that customer and vendor requests are processed correctly in a timely manner

• Accurately process and close discontinued and uneconomical units as well as obsolete products

• Run service reports in SAP (exporting and manipulating in excel) promptly and correctly for the upper management

• Utilize the SAP and CRM system to accurately access the history, status and cost of the units

• Input data into vendor’s spreadsheet

• Help Contract Manufacturing (CM) purchasing department run daily, weekly and monthly inventory reports

• Receive and process Customer and RTS, also close out factory seal units MEET MOTORS, INC. 09-2007 to 09-2008 IT Support/Web designer

• Provide Hardware support such as installing and setting up equipment, upgrading existing systems, fixing computer equipment, figuring out exact nature of fault and fixing it.

• Help develop and maintain company website.

• Create new tools for the company website and support marketing team in web-based marketing. MICRO-MAN, INC. 01-2007 to 06-2007 Internship

• Develop software program to meet specific transportation needs.

• Help develop networking support system.

• Provide PC support which includes fixing hardware problems, installing and upgrading systems, fix computer equipment.

PARTH DIAMONDS, INC. 01-2006 to 12-2006 Bookkeeper

• Enter Debits and Credits.

• Prepare monthly account balance sheet and reconcile monthly bank statements

• Install new software and computer equipment.

EDUCATION:

PARUL INSTITUTE OF TECHNOLOGY 06-2003 to 06-2007

Bachelor of Computer Engineering

ADDITIONAL LANGUAGE SKILLS:

• Fluent in Hindi/Gujarati/English

References available upon request

Contact this candidate