Data Analyst Business

OBJECTIVE

A detailed and analytical IT and business professional seeking to apply Information Science, Mathematics, and newly learned programming language skills to a relevant role where I can continue to grow. Available to start as soon as possible.

EDUCATION

Udemy, Inc, March 2020-Present

Continual Online Learning

University of Pittsburgh, Pittsburgh, PA April 2018

Bachelor of Science in Information Sciences

Community College of Allegheny County, Pittsburgh, PA May 2015

Certificate in Accounting

Robert Morris University, Moon Twp. PA May 2013

Bachelor of Science in Applied Mathematics

Yeshivat Derech Etz Chiam, Har Noaf, Jerusalem Aug 2007-June 2008

Study Abroad

PROFESSIONAL SKILLS

Operating Systems: Apple, Windows, and Linux

Software: Microsoft Suite, Tableau, Google, Safari, Chrome, Jira, LAAQA, and Meledms

Programing Languages: Java, Python, Visual Basic, SQL, and Maple

Databases: Excel and Access

Scripting and Web Authoring: HTML, Hyperlinks, and Audio/Visio

RELEVANT PROFESSIONAL EXPERIENCE

Bank Of New York Mellon, Pittsburgh, PA

Business Analyst (Contracted through Robert half) (Contract) April 2022-Decemeber 2022

Processed Excel data by extracting Legal Entity Identifiers renewal dates for clients into a search system and updating the spreadsheet for clients that needed to have renewal dates updated

Submitted regulatory disclosure requests to Euroclear where account numbers needed to be entered from an Excel spreadsheet in a Find and Replace box in which the number was spotted and the client name was extracted from another Excel Spreadsheet and copied and pasted in the original spreadsheet and other similar functions were carried out as well

Performed a Mail Merge where letters that needed to be sent out to multiple clients where sent to all clients in one cycle regarding the Mail Merge in which entering information of clients from the Excel spreadsheet onto the documents and then sending the letters for each client was done in one step

Worked with mail sent from clients to set up accounts to have clients invest involving plotting info into an Excel spreadsheet, processing PDFs, and other information in order for others to maneuver the client’s needs to invest

Compared the master data spreadsheet involving the data received from clients to the client spreadsheet which was sent out to clients and if there was a mismatch between the two when comparing the data the master spreadsheet was updated in order to secure accurate data

Assignments inculcated complex and lengthy IT work, high attention to detail, Macros relating to processing documents for clients, and Filtering and Find and Replace Excel formulas

Idlewild Park, Ligonier, PA (Contract) May 2021-June 2021 Seasonal Finance and Information Systems Associate (Contracted through Robert Half)

Worked a daily Sales Report on rotation, summing up categories on a spreadsheet that needed to be constructed and entered the category totals onto another spreadsheet for further reference

Entered numbers and tickets from the spreadsheet into the system in where the entry total needed to balance out

Performed a daily Flash Report on rotation spotting numbers, dates, and categories upon then plotting these aspects onto multiple spreadsheets regarding other dates and categories

Completed Labor Reports daily where employee wages and paid hours regarding categories and dates got documented into a spreadsheet for other employees to see and paid hours were recorded onto a template for witnessing

Continued on further reporting to Corporate Finance for other analysis

FedEx Ground, Coraopolis, PA (Contract) November 2019-December 2019

Safety Support Administrator (Contracted through Oxford Solutions)

Analyzed data to identify drivers that may not be qualified to drive the vehicle driven composed of V-Lookups, Conditional Formatting, Filtering, Hiding columns, etc.

Monitored drivers to make sure they had capabilities to do the job requirements

Daily monitored drivers to identify any problems and to trouble shoot any problems in order to have them fall off reports

Warner Telecom, Pittsburgh, PA June 2019-August 2019

Data Analyst

Searched multiple excel spreadsheets in which ID numbers were retrieved and placed into a Find and Replace box on another excel spreadsheet looking for a corresponding match

Filtered different client names on an excel spreadsheet and copied and placed the filtered records onto another spreadsheet that was saved on the Server under each client name in order to work with the data pasted onto the client file

Extracted information from Invoices and plotted the information onto Open Audit and Mapping records in order to process these records with the needed information

CMMI Institute, Pittsburgh, PA (Contract) December 2018 –February 2019

Quality Analyst (Contracted through OpenArc)

Reported information regarding Appraisal ID’s through Excel, LAAQA, and JIRA, in order to label individuals based on qualification dates and educational requirements

Determined certifications of individuals and analyzed relevant dates from spreadsheets in which were plotted onto templates in Excel involving LAAQA and JIRA

Projects involved analytical applications of Excel such as filtering, creating tables, and V-Lookups in which the goals were to determine how to process student records more efficiently

Highmark, Pittsburgh, PA (Contract) May 2014 – Sept 2014

Associate Systems Analyst (Contracted through Bender Consulting Services)

Reported and analyzed data by creating Spreadsheets and Pivot Tables as well as other functions in Excel (V-Lookups, IF Functions, Filtering, Concatenations, etc.) using data

Completed Microsoft PowerPoint assignments involving putting together a document of employees photographs and profiles

Developed a Microsoft Visio flow-chart with employees’ titles and rank

DANIEL H. LEVINE

6209 Monitor St, Pittsburgh PA, 15217

cell (412)- 496-7044, adx28n@r.postjobfree.com

Contact this candidate