Data Analyst

Aruna Chuppala

**** ******* ******, ***#**, San Diego, CA 92122

Cell : 858-***-****

Email: adiqi6@r.postjobfree.com

LinkedIn: http://www.linkedin.com/in/aruna-chuppala Summary

• A self-motivated data analyst graduated from Osmania University, who has above 8 years’ experience in excellent organizational skills, is highly efficient and has a good eye for detail.

• Has extensive experience of assisting in the development and upgrading of database systems and analytical techniques. Able to play a key role in analyzing problems and come up with creative solutions as well as producing methodologies and files for effective data management.

• Experience with automation of processes by writing VBA code to speed processes and maximize accuracy.

• A quick learner who can absorb new ideas.

• Result oriented, self-driven, highly motivated and eager to learn new technologies, methodologies, strategies and processes.

• Objective – Become a key role player in providing quality solutions for the data analysis and research. Area of Expertise

• Data Validation

• Data Analysis

• Data cleaning

• MS Office

• VBA for Access, Excel and SAP

• Tableau

• Visio

• MS SQL Server

• Exposure to SAP

Key Skills and Competencies

• Quickly learning new concepts and methodologies as needed and then applying them to new scenarios.

• Extensive experience with MS-OFFICE 2007/2010-Word, Excel (V-Lookup, H-Lookup, Concatenating formulas, Conditional Formatting, and Pivot Tables), Power Point, Access (Tables, Queries, Forms, Reports, Macros), Outlook, Visio, VBA

• Automation by VBA (Sub Routines, Functions, Modules)

• Knowledge about Dashboards in Excel & BI reporting tool-Tableau.

• Capable of handling multiple tasks, taking initiatives, working in groups or as an individual.

• Excellent logical thinking and problem solving abilities.

• Strong analytical skills that helps evaluate a given situation, consider alternatives and find feasible solutions.

• Attention to detail & ability to work in a pressurized time sensitive environment.

• Maintaining the security of data.

Education

• BSc (Microbiology, Botany Chemistry) from St. Francis College 2003-2006

• MSc (Organic Chemistry) from Osmania University 2006-2008 Professional Experience

Becton Dickinson, San Diego, CA 08/2016 – 08/2020

Analyst, Business Metrics/Analytics, Data Operations Management Responsibilities

• Assisted with automation of department’s manual processes by writing VBA code and using macros and formulas to speed processes and maximize accuracy.

• Creating Tables, Queries, Forms, Macros and Reports in MS Access.

• Automation of processes using SAP, MS Access and excel applications by VBA.

• Maintaining Data in SAP.

• Expertly convert old material SKUs to new serialized material SKU using MS Access, Excel applications and update them in SAP. Create VBA programs to update SAP with material SKUs.

• Created process flows in MS Visio and shared with team members.

• Develop and maintain metrics using Excel.

• Create VBA programs to Import data from SAP into MS Access and create mass reports for 5000 clients.

• Assists in analyzing, designing, creating, and implementing database and spreadsheet applications in all environments.

• Helps in investigating and resolving database and spreadsheet application problems.

• Collaborate with teams on ensuring material set up meets the data standards. GVK Bio, Hyderabad, India 11/2009 – 09/2015

Data Management Analyst

Responsibilities

• Provided support in data life cycle development, including Data Acquisition, Data cleaning and Data Visualization

(Pivot Tables, Charts).

• Maintain MS SQL databases. Queried relational databases using SQL day to day to resolve issues and assist business and IT in a better understanding of business requirements.

• Write simple SQL Queries, Stored Procedure, Triggers, Views using DML, DDL commands and user defined functions to implement the business logic.

• Responsible for design, development and testing of tools used by Application Support team

• Responsible for maintenance and enhancements to back office applications

• Data entry, data auditing & monitoring all data for accuracy.

• Analyzing raw data, drawing conclusions & developing recommendations.

• Plan efficient data procurement procedures and prepare databases suiting client's specifications

• Performing daily system checks.

• Monitoring the automated loading processes.

• Coordinate work between clients, researchers, quality assurance teams and database administrators to ensure efficiency and timely completion of work.

• Optimized data collection procedures and generated reports on a weekly, monthly, and quarterly basis.

• Prepare routine reports and ad hoc reports.

• Prepare Charts, dashboards using Tableau.

Contact this candidate