Assistant Data Entry
Resume:
Romy Kapoor
Hicksville, NY *****
Cell: 917-***-**** Home: 516-***-**** Email:adscs1@r.postjobfree.com
Experienced Database Manager/Report specialist
Offering 12+ years’ experience in Database Creation, Administration, Management, & Maintenance with solid Oracle and SQL Server background; expertise in database and reporting technologies
Career Highlights
Proven history in database creation, administration, analysis, modeling, reporting, QA, and management.
Successfully managed large-scale, comprehensive databases with over 70,000 records.
Utilized superior technical skills to optimize database/reporting performance and overall efficiency.
Troubleshot and resolved critical technical and database related problems and issues.
Liaise with programmers to achieve systems goals and optimize overall IT infrastructure.
Outstanding analytical and technical skills. Adept at troubleshooting and problem resolution.
Team player who is able to relate to people at any level, including technical and non-technical users.
Supervised, managed, and trained employees/end users. Able to adapt to new technologies/environments.
Technical Proficiencies
Languages/Databases: Oracle 9i, SQL plus, PL/SQL, Oracle Discoverer 9i, Oracle, Microsoft Access, SQL Server 2008
Applications: Microsoft Office (Word, Excel, Access, PowerPoint, Outlook), Adobe Acrobat, and Crystal10
Operating Systems: UNIX, Windows 95/98/NT/2000/XP/Windows7
Reporting Tools: Crystal Reports, Microsoft Data Reports
Related: SCT Banner System, Advance Database System, Task Tracker System, Agency Manager and Reporting Manager
Education/Professional Development
Associates Degree in Computer Information Systems, 1993 (NOT COMPLETED)
Oracle 9i and PL/SQL, Oracle Corporation, New York, NY
Oracle and SQL plus, School of Continuing Education, Columbia University, New York, NY
Professional Experience
Data Analyst, reporting
American Marketing Group (travelsavers), Oyster Bay, NY 11771 1/2010 – 11/2016
This position is responsible for ongoing analysis of company’s several travel business operations using data obtained
from a variety of sources, including travel agency information, supplier data and many sources of internally generated statistics. It involves development of methodologies, maintenance of databases, perform complex data analysis data quality and integrity checks, design data models, participation in new product development and analytical tools. It requires proficiency with analytical tools (SQL, Excel, Crystal), knowledge of data analysis methodology.
Data Analyst, Billing Department 9/2009 – 12/2009
Betances Health Center, New York, NY
Handled enquiries, recovered benefit overpayments, Maintained database in Excel Examined causes, including fraud and Local Authority errors.
PepsiCo, Marketing and Advertising, Purchase, NY(CONSULTING) 6/2009 – 08/2009
Extract data from various data sources(ACCESS, EXCEL, CRV etc,)
Build constructive reports using Excel Macros
report specialist Microsoft/MSN (consulting) 3/2008 – 11/2008
Developed reporting solutions using Microsoft SQL Server
Research and Data Analsys
Used Excel to analyze data and generate ad-hoc reports and queries.
Office Manager/Sales Manager
Paramount, New York, NY 10016 7/ 2005 – 02/2008
Establish, maintain, and update files, databases, records, and other documents; develop and maintain data, accounts and perform routine analyses and calculations in the processing of data for recurring internal reports.
Database Management & Administration/Assistant Director, Reporting
Columbia College, Columbia University, New York, NY 7/ 2003 – 4/2005
Maintained records, accountable for identification, cultivation, and stewardship of donors. Liaised with
Cross-functional departments to ensure accurate and timely awarding of donor scholarships and to ensure efficient database management.
Leveraged database skills to identify lost alumni, increasing funds generated by approx.
$2 million.
Responsible for data management/reporting; assessed and built prospects using Oracle 9i platform.
Created and maintained daily reports from a large integrated transactional database.
Fulfilled reporting needs through ongoing development of various alumni information system reporting applications. Provided online reports using Crystal.
Developed and modified ad-hoc PL/SQL reports; supported alumni relations user community.
Effectively monitored data entry of demographic information into university database.
Developed systems; analyzed data to determine trends.
Evaluated, analyzed, and prepared reports using data from alumni database (CUADS/Advance).
Liaised with two departments to ensure seamless communication and effective workflow.
Assistant Data Manager
Teachers College, Columbia University, New York, NY 6/1995 – 4/2003
Challenged with responsibility for managing programs and databases. Created detailed correspondence; provided support for alumni relations.
Supervised development information assistants; orchestrated workflow; entered data related to demographic information, address correction, gift and pledge processing, receipting, reporting, and acknowledgments.
Trained staff for use of computer system (SCT Banner); maintained validation tables, system documentation, inter-departmental feeds.
Oversaw design and implementation of quality control procedures for data management and maintenance; coordinated information selection and retrieval with computer center programmers.
Directly responded to senior management requests for mail services and alumni listings.
Consulted with directors and departmental managers for planning, organizing, and staffing assignments related to implementation and maintenance of departmental activities.
Coordinated systems development, programming, and output needs; served as liaison with other administrative areas using Banner.
Volunteer Help
Shri Shirdi Sai Baba Temple, Flushing NY 03/1995 - Present
GNK Hicksville, NY 05/2021 - Present
Nassau County NY – Medical Reserve Corps 07/2021 - Present
References are available upon request.
Contact this candidate