Data Analyst - Reporting & Visualization Specialist

Soy john

***** ******** ***** **, ********, CA **880

Phone: 909-***-**** ********@*****.***

Career Objective:

Pursuing for a Data Reporting and Analysis opportunity to apply my superior analytical and data mining skills to be a problem solver and to bring an innate ability to encourage teamwork.

Professional Qualification

Post-Graduation : Master of Social Work (Social Science), Bharathiar University Coimbatore, TN, India

Graduation : Bachelor of Commerce (Accounting & Finance), M.G University Kottayam, KL, India

Certification : Data Analytics -Rutgers the State University of New Jersey

: ETL with SQL Server Integration Services - Microsoft

Technical Skills

Applications : SAP (FICO, SD), Salesforce, EPIC, Service Max

Languages : SQL, MS Access

Reporting Tools : Power BI, SSRS, Excel and MS Visio, Power Point

Data Governance : Ataccama Data Governance Application

Business Skills:

Analyze business requirements and create reports and dashboards for the purpose of improving the operational efficacy and efficiency in general.

oWork with stakeholders to identify the end goal of their request and help them to redefine their request into the wider spectrum of business if required.

oIdentify the resources to meet the requirements like peer assistance, data sources, data access, data availability, Data mining and Visualization, Time Management assessments etc.

o Analyze the current reporting process to understand the merit and drawbacks of the one in active use and why a new one is required.

oReview the analysis and findings with Project Team

oVisualize and create data story by connecting the visualization tool into databases and other file sources

Technical Data Stewardship -Ataccama Data Governance Application

oProvide technical support for the business users across the organization

oSet up user profiling, data mapping and data profiling

oSet up the data quality rules for assuring data quality

oMonitor the projects and step up into action to fix the issues

Career Summary

Employer: Citizens Business Bank 701 N Haven Avenue, Ontario, CA-91764, US

Designation: Data Warehouse Analyst (June 2021- Sep 2025)

Responsibilities:

Work with ETL team to identify and configure the new data sources.

Build SQL queries to extract data from database tables

Create Dashboard and Reports in PBI and published it into the workspaces

Help the users to configure their access into report platform

Support business by providing on demand reports

Data steward for the Data Governance system (Ataccama). Including data profiling, data mapping and data quality assurance by setting up data quality rules for monitoring the data quality

Employer: Iconma LLC 850 Stephenson Hwy’, Suite 612, Troy, MI 48083, US

Client: Abbott Vascular 42301 Zevo Drive, Temecula, CA 92590 (Nov 2018- Apr 2020)

Designation: Business System Analyst

Responsibilities:

Maintain and ensure compliance and quality for the data used in governs procedure and internal reporting metrics.

Analyze the requirements and create reports and dashboards for the business using BI tools like Excel/Power BI

Gather requirements and build templates and specifications for reporting.

Work with Supply Chain and Customer Service to identify the areas where the improvement is required/possible.

Create a model and provide business reports where analytical support required.

Employer: Artech Info System LLC., 360 Mt. Kemble Ave., Suite 2000, Morristown, NJ 07960

Client: Alcon Laboratories, Inc. 2051 Lake Forest Drive, Lake Forest, CA 92630 (Oct 2016 – Nov 2017)

Designation: Business System Analyst

Job Responsibilities

Create and maintain project requirements and analysis documents.

Analyze business requirements and create reports and dashboards for the business users.

Provide on demand data support for the business users.

Employer: Rose Intl., 17701 Cowan Suite 230, Irvine, CA 92614

Client: Kaiser Permanente, 75 North Fair Oak Ave, Pasadena, CA 91103 June 2016 – August 2016)

Designation: Data Consultant-Revenue Cycle

Job Responsibilities

Analyze business requirement and identify the data points.

Extract data and create report for business users for Management reporting.

Employer: Beyond Soft (TPG Consulting LLC), 1411 West 190TH Street Suite 3, Gardena, CA 90248

Client: Toyota Motor Sales, 19001 Western Avenue, Torrance, CA 90501 (April 2014 – Nov 2015)

Designation: Business Analyst

Job Responsibilities:

Perform Requirement gathering and identify the areas where the improvement is required.

Perform the QA testing for applications on development

Develop and maintain training documents and provide in person training for the end user.

Work with business users to gather more information if developers required.

Employer: Kelly Services, 33 Technology Dr., Irvine, CA 92618 / P.O Box 331179, Detroit MI 48232-7179

Advance Sterilization Products, 33 Technology Dr., Irvine, CA 92618 (July 2012- April 2014)

Designation: MRB Coordinator (Warehouse Operation)

Job Responsibilities:

Prepare and maintain country wise reports and analysis of return and refurbished itemized products.

Prepare Board Reports monthly for return and refurbished products.

Pacific Coast Spring Company, 2105 Lee Ave, South El Monte, CA-91733 (June 2008- October 2010)

Designation: Accountant /Business Analyst

Job Responsibilities:

Manage the accounting activities.

oBank Reconciliation, Vendor Management, Accounts Payable and Credit Management and more.

Maintain Financial Statements

oAP/AR statements, Trial Balance and Financial & Profitability Reports etc.

Implement, troubleshoot, test and configure a Quality Management System for the organization’s ISO 9001 certification.

oDevelop/configure Operational Procedure in accordance with Quality Management Process

oImplement and test the configuration of Internal Audit Procedure

Contact this candidate