Data Entry

SUMMARY:

Around * Years of strong experience in design, analysis, development and implementation of various Projects using SQL, MS-Office suite.

Writing Oracle SQL queries according to the user requirements.

Advanced proficiency in all aspects of Excel.

Experienced in preparing detailed documents and reports while managing complex internal and external data analysis responsibilities.

Skilled in VLOOKUP formula development, Pivot Table generation, and Pivot reporting

Created Excel charts and pivot tables that provided management with critical manufacturing line status information

Good knowledge on Oracle database/sql

Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines

Created Tables, Views, Constraints, Index

Hands on experience on Implementation, Testing and Production Support of Oacle Application projects.

Involved in various stages of implementation, Customization, Training and post implementation activities in multiple projects across geographies

Excellent analytical, logical and programming skills and a fast learner.

Rich experience in handling client queries and troubleshooting.

COMPUTERS WORKED ON:

Below is a list of important hardware, software products, tools and methods that I have worked on

Hardware

Software Products

Tools

Operating Systems/Methods

HP UX 9000, PENTIUM

ORACLE APPLICATIONS Release 12 with ORACLE 11g, 10g ORACLE APPLICATIONS 11.5.10.2 with ORACLE 10g.

MICROSOFT ACCESS DATABASE

SQL, PL/SQL,VBA

Microsoft office

(word,excel,powepoint,

outlook),Excel-pivottables DataType Conversions, IF/AND/OR, INDEX/MATCH,Macros, Error Handling

MS-DOS, MS-WINDOWS98/2000, MS-WINDOWS-NT, UNIX

PROFESSIONAL EXPERIENCE:

Excel Expert /Billing analyst Jun 2017 to Sep 2017

Konica Minolta Windsor, CT

Developed custom spreadsheets for billing analysis

update, and validate data underlying spreadsheet

Experience creating weekly and monthly reports for corporations

Develop and implemented standard operating procedures to bridge data gaps and resolve related issues.

Create pivot tables and modify spreadsheets to achieve analytical goals

Designed, recorded, and executed macros to automate data entry inputs.

Formatted spreadsheets and workbooks for print, document reproduction, and presentations

Created scripts to create new tables, views, queries for new enhancement in the application using TOAD

Created indexes on the tables for faster retrieval of the data to enhance database performance.

Crabtree&Evelyn Apr 2017 to Jun 2017

Data Analyst and Excel expert Woodstock, CT

Create and preserve existing and new client accounts kept all files updated and in order Processed vendor's purchase orders, invoices, payments and bi weekly payroll

Create pivot tables and modify spreadsheets to achieve analytical goals

Created the Macros to capture the repeated information.

Used the lookups to search the data in the multiple files

Created the Bar chart & Pie chart reports

Extracted, compiled and tracked data, and analyzed data to generate reports.

Performed daily data queries and prepared reports on daily, weekly, monthly, and quarterly basis.

Manage spreadsheets and maintain data currency to ensure accurate data availability for managers and decision-makers.

Compile and generate spreadsheets capturing key data related to company’s active contracts.

Compile statistical reports on payments, orders, and outstanding invoices

Develop and implemented standard operating procedures to bridge data gaps and resolve related issues

Accent Info, India Nov 2014 to Oct 2016

Junior Developer

Imported and exported data from text files, saved queries, or databases; used automatic outlining, inserted subtotals, created advanced filters, and used database functions.

Strong skills in implementing improved CM practices

Conducted database and tools quality assurance testing on a regular basis and as needed.

Writing Oracle SQL queries according to the user requirements.

Writing PL/SQL reports and designing aesthetically pleasing end user reports using Argos Report Writer; incorporated PL/SQL packages, procedures, functions, triggers, views, etc and compiled/installed into Banner job submission using SQL Developer

Created pivot tables and charts using worksheet data and external resources, modified pivot tables, sorted items and group data, and refreshed and formatted pivot tables.

Designed, recorded, and executed macros to automate data entry inputs.

Formatted spreadsheets and workbooks for print, document reproduction, and presentations

Input hand-written customer orders and cash, credit, and check payments into system.

Gathered statistical information about clients and purchases, and created reports for owner.

Confidentially handled business tax information, legal documents, and customer information.

Updated records for customers and employees on a daily basis.

Supported additional functions in administrative, payroll, and reception areas as needed.

Logged payments and refunds into system.

Worked with owner to improve data system and convert to computer-based ordering and payment format.

Prepared source data for computer entry, compiled, sorted, and prioritized data

Accent Info - Bangalore, India Aug 2011 to Nov 2014

Excel Expert

Manage complete data entry and customer support functions for Accent InfoTech.

Compile and generate spreadsheets capturing key data related to company’s active contracts.

Research, update, and validate data underlying spreadsheet production; strategically fill gaps.

Create pivot tables and modify spreadsheets to achieve analytical goals.

Manage spreadsheets and maintain data currency to ensure accurate data availability for managers and decision-makers.

Develop and implemented standard operating procedures to bridge data gaps and resolve related issues.

Enter customer orders, vendor receipts, and invoices into offline system.

Compile statistical reports on payments, orders, and outstanding invoices.

Transcribe phone messages for owner and manage email communications.

Create monthly reports for records, closed terminated records, and completed chart audits.

Update departmental standard operating procedures and database to accurately reflect the current practice

Qualifications:

Degree and Date

Institute

Major and Specialization

B.Tech

JNTU University

ECE

Contact this candidate