Greenville, South Carolina
firstname.lastname@example.org Phone: 713-***-****
4+ years of experience in the IT industry as a Data Analysts, Business Analysts and Data Specialist.
Responsible for producing reports from various sources to provide with actionable information using Excel.
Created dashboards and charts in Excel and Tableau.
Developing a clear understanding of existing business functions and processes.
Prepare routine and ad hoc status report.
Experience in Pivot tables generation, V- lookup formulation development and Pivot reporting.
Designed, recorded executed Macros to automate data entry report in Excel.
Reviews, analyzes, monitors, and interprets data; verifies and validates analytical results; develops innovative approaches and methods for assessing data quality and analyzing data.
Create pivot tables and modify spreadsheets to achieve analytical goals.
Proficient with SQL and its variation among popular databases.
Experience of data and databases. Relational design and query skills with SQL Server.
MS Excel (Pivot Tables, V-Lookup), MS Word, PowerPoint, MS Access, SharePoint, Tableau, SQL Server, Data Flow Diagram, RCV1, Tableau, Oracle, SQL Developer, Basic understanding of (Python, SAP, ERP, Data Modeling, Supply Chain, SSRS, C++, R, Java, SQL-Teradata, Hadoop, ETL)
Bachelor of Business Administration, Troy University - Troy, Alabama (2008)
Master in Computer Science, University of Houston - Victoria Texas– August (2019)
Operations Data Analyst, JPMorgan & Chase - Columbus OH Feb 2017 – July 2018
JPMorgan Chase & Co. is a leading global financial services firm with assets of $2.5 trillion and operation worldwide. The firm is a leader in investment banking, financial services for consumers and small businesses, commercial banking, financial transaction processing and asset management.
Responsible for developing, analyzing, data gathering and reporting functions that will ensure credit reporting inconsistencies are detected and corrected accordingly.
Perform data review and statistical analysis skills that are integral in their collection and presentation to leadership as to identified opportunities in support of business integrity, unit or function activities.
Participated in the development of new system functionality and the testing there of.
Ensured data is furnished in accordance with guidelines via execution of scripting set to detect illogical conditions.
Collection and analysis of credit reporting data for deficiencies and implementation of processes to ensure data quality/integrity
Responsible for producing reports from various sources to provide the department/division with actionable information using Excel and Tableau.
Skillful in creating dashboards and charts in Excel and Tableau.
Collaborated and worked with data analysts in various departments to ensure that data meets their reporting and analysis needs.
Interpreted business needs of stakeholders and develop analytical solutions.
Developed in-depth understanding of data environment and leverages knowledge to build robust scalable solutions.
Develop and deliver reports and analysis (using SQL, Excel & Tableau) for key strategic initiatives.
Created database objects such as Tables, Views, Functions, Stored Procedure and Triggers etc.
Perform data extraction from various sources and data analysis to deliver actionable insights in a timely manner, while ensuring data quality, consistency, and integrity.
Perform campaign analysis, various ad-hoc reporting, research and analysis duties to support day-to-day operational and strategic management decisions.
Modify report content and exporting reports in multiple formats based on the business requirement
Consultant Data Analyst, Virtusa – Houston, TX April 2013 – December 2016
The American Automobile Association (AAA) is a federation of motor clubs throughout North America. AAA is a non-profit member service organization with over 58 million members in the United States and Canada.
Responsible for full lifecycle analysis to include requirements, activities and design.
Interpreted data and analyzed results using advance Excel skills.
Run queries in SQL Server to gather, collect and extract information important for decision making by management.
Help generated monthly claim report for forecasting and trending purpose.
Provided management with analyzed reports with charts and tables to easily identify the current trend or any bottleneck.
Developed and implemented data analysis, data collection systems and other strategies that optimize efficiency and quality
Identified, analyzed and interpret trends or patterns in complex data sets.
Locate and define new process improvement opportunities.