ANGELIN JOHNSON

Phone: 319-***-**** adjbqa@r.postjobfree.com

SUMMARY

Information Technology professional with 5 years of work experience in manufacturing, e-commerce, and technical support fields.

Experienced in Data Analysis using SAP Business Warehouse, SAP Business Objects, DB2 and PTC Windchill for John Deere.

Prepared dashboards and reports analyzing data to derive business intelligence using Tableau.

Worked as a transaction-risk analyst for Amazon.

Supported Internal applications for GMAC as a technical Analyst.

Worked on enterprise level environments at John Deere, Amazon, and IBM.

Knowledge in Database Concepts, Logical and Physical database designs, SQL and ITIL workflow, HTML, ASP, PHP, Cascading Style Sheet (CSS) and JavaScript.

Good interpersonal, communication, analytical skills, ability to work in a fast-paced environment and keen on learning new things.

Permanent Resident.

EDUCATION

Master’s in Business Administration Pursuing

University of Northern Iowa.

Master’s in Computer Information Systems 2016

California University of Management & Sciences.

Bachelor of Engineering (BS) in Information Technology 2008

Karunya University, Tamil Nadu, India.

TECHNICAL SKILLS

Areas of Expertise: Data Modeling, Data Extraction, Data Schema, ER diagrams, Tableau (preparing for specialist certification), SAP Lumira, Excel (ODBC Connections, Pivot Tables, lookup functions), SSRS.

Databases: MySQL, Oracle, DB2, Microsoft SQL Server.

Web Development: PHP, JavaScript, CSS, HTML, Active Directory.

Languages: Basics of Python & R in Analytics, Joomla, Drupal, and WordPress framework.

Tools: MS Office, Lotus Notes, Outlook.

AFFILIATIONS

Member Toastmasters International Inc. (July 2019 to Present)

PROFESSIONAL EXPERIENCE

Viva USA Inc.

Client: John Deere Power Systems 2017 –2018

Role: Product Program Manager

Responsibilities included managing and analysis of the Bill of Material and Engine design repository system.

Utilized SAP Lumira to analyze the data and adopted statistical techniques to interpret the results.

Used Tableau, SAP Lumira & Excel to slice and dice the data from the repository.

Performed gap analysis to identify issues and employed solutions to fix it.

Identified data integrity issues and reported it to the Cyber Security team.

Prepared new reports, modified, and migrated the existing reports in Excel & Tableau into Visual Reporting (SAP Lumira).

Developed and maintained various reports, merging data from multiple sources to derive business intelligence for ongoing projects.

Trained new employees to manage and distribute the reports periodically to various teams.

Amazon Development Centre, Bangalore, India 2013 - 2015

Client: Amazon.com

Role: E-commerce Transaction Risk Investigator.

Responsible for a wide range of duties related to investigation and elimination of online e-commerce fraud.

Investigated fraud transactions using Investigator Workbench (IWB) application built on JavaScript, Perl, and Oracle Business Intelligence Enterprise Edition (OBIEE).

Increased the productivity, quality and improved the delivery of tasks and projects on a timely basis.

Increased the revenue for the company by reducing complex and fraud transactions.

Trained junior and new employees in the functional and domain knowledge areas.

Worked independently with little guidance and with a high degree of accuracy.

Coordinated and worked with the network team to set up the Office Communicator to bridge the communication gap between critical teams. In turn, this reduced the time to resolve crucial issues.

IBM, Bangalore, India. 2010 – 2012

Client: GMAC, UK

Role: Senior Technical Support Analyst

As part of a 15-member team, provided technical support to GMAC employees located in EMEA (Europe, Middle East, and Northern America) region regarding their workstation, network access and internal systems access issues.

Analyzed the root cause of the problem(s)/open issues and provided solutions.

Ensured first and follow up call metric resolutions with high quality, accuracy, and efficiency.

Monitored, managed, and assigned ticket severity and priority.

Assisted onsite technicians regarding critical issues.

Managed and updated the Knowledge Management System (KMS) regularly.

Generated customer service reports for upper management using SQL queries.

Engaged, Coordinated and Supported IBM onsite technicians regarding hardware issues.

Trained and mentored new employees located onsite and at offshore sites.

Implemented Global Delivery Framework (GDF/ITIL) to improve customer interaction and satisfaction.

Based on my performance was promoted from Technical Support Analyst to Senior Technical Support Analyst from September 2011.

Academic Projects

California University of Management and Science. 2015 - 2016

Role: Graduate Student

Project 1: Designed a Network Infrastructure.

Used Gliffy, an online network tool to design the Infrastructure.

Developed a comprehensive network diagram plan for a fictitious organization.

Illustrated an Exchange, created DMZ, Printers, Copiers, Firewall, SAN, and VPN.

Added User IDs, Groups, Equipment information and Firewall to the network.

Defined policies and rules for firewall, Wi-Fi, Server, and directories.

Used Cisco networking stimulation software to configure Router and Switch stimulations.

Project 2: Developed Dashboards and Reports using Tableau

Led a team of five students in analyzing, developing dashboards & reports and demonstrated the same to the class.

Utilized data from data.gov to derive Business Analytics & Insights for Domestic and International markets.

Designed Dashboards using Filters, Parameters and Action Filters.

Analyzed and generated reports using Tableau Workbooks and Dashboards.

Karunya University 2004 - 2008

Role: Undergraduate Student

Project: QAGen: Generating Query-Aware Test Databases

QAGen is a new approach to generating inputs to database, used by testers to validate applications.

Used Java to create the user interface to initiate queries and display the output.

Employed MS Access as a symbolic query machine to store and retrieve data.

Utilized SQL interface to query the QAGen and connect to the query analyzer.

Contact this candidate