Software Developer Data Analyst

ADITI MANGAL

************@*****.*** 586-***-**** linkedin.com/in/aditimangal/

**** ******* ***** **, ****, MI 48098

SUMMARY OF QUALIFICATION

• 2+ years of industrial experience as a Computer Science and Technology Engineer with professional experience in Software Testing, Oracle Database Management, Application Development (Frontend & Backend), Database Administration and Web Development (PHP, HTML CSS, BOOTSTRAP, JAVA SCRIPT).

• Currently working with DTE Energy as Software Tester, designed test cases for Maximo inspection forms as per field workers requirements and worked on resolving bugs/issues.

• Worked as Data Analyst and Software Developer to design over 50+ analytical dashboards using SQL into Power BI to provide visualizations. Also involved in Web Application Development to design and develop web applications.

• High competency in data analysis, technical writing, business requirement evaluation, risk identification and workflow analysis to assess requirements.

• Supported customer projects entailing configuration, maintenance and daily support of services. TECHNICAL SKILLS

Technologies: C/ C++, Java, JavaScript, PHP, HTML5, CSS3, Browser stack, Jenkins, XML, JSON, jQuery, Bootstrap, Python Database: SQL/MySQL and Oracle Database

Cloud and Data Analytics: AWS, Azure, Power BI, Click Soft/ EZ Max Mobile, ESRI and Maximo QA tools: Selenium and Tosca, Browser Stack, Rain Forest QA, CI/ CD pipeline, JIRA Applications: Eclipse, GitHub, Atom.io, VS Code, Jupyter Notebook, Minitab, SharePoint and Sublime Certification: Tricentis Certified Tosca Automation Testing Specialist, Amazon Certified AWS Cloud Practitioner PROFESSIONAL EXPERIENCE

SOFTWARE ANALYST/ TESTER, DTE ENERGY, Detroit, MI June 2019 – December 2020

• Designed over 50+ analytical dashboards using SQL into Power BI to provide visualizations and anticipate rate of continuous improvement of work orders and preventive maintenance of assets.

• Performed custom calculations using DAX leading to more intelligible data visuals.

• Retrieved data from Data Lake using Impala SQL query engine for analysis.

• Scripted functions in Python on retrieved data from Azure using Jupyter Notebook, and auto saved it into Excel spreadsheet for graphical representation.

• Preformed Beta testing on many upgraded versions of Click Software using VSCode, Selenium, Python, Browser Stack

• Tested phone reliability for various use cases and scenarios according to business requirements to evaluate performance of new updates on all operating systems, mobiles and tablets/ iPads.

• Ensured quality of different software (Click Soft, D3, D2) by performing an end-to-end Integration, Performance and Functional testing on the functionality of workorder dataflow.

• Verified the quality and flow of SMS and Emails sent to customers in accordance with work order. SOFTWARE DEVELOPER Intern, DTE ENERGY, Detroit, MI May 2018 – May 2019

• Designed, developed and maintained web applications using PHP, HTML, CSS, JavaScript, Bootstrap, and JSON. Used Oracle SQL database to retrieve, edit and store the data.

• Combined 15+ different circuit maps into a single web application to know discrepancy in each ancillary and to maintain accurate records in mapping data.

• Integrated work order with discrepancies of different assets to maintain data integrity.

• Recorded the monthly performance of all DTE Energy substations in a web page as per IEEE standards

• Converted paper-based Shutdown Initiation (SI) forms to web-based forms for improved tracking of everyday shutdown requests at different service centers by field employees.

• Improved security and reliability of data, by designing online/offline Maximo inspection forms related to its workorders and preventive maintenance on iOS and Windows devices.

• Linked preventive maintenance and work orders with assets and further added respective specifications of each asset to establish hierarchy between dependent assets.

• Congregated classifications of assets and asset location in Maximo and ESRI considering business requirement. EDUCATION

Master of Science (MS), Computer Science August 2017 - April 2019 Wayne State University, Detroit, MI

Bachelor of Technology in Computer Science and Engineering July 2012- May 2016 Punjab Technical University, Punjab, India

Contact this candidate