SUMMARY

• 21 years of experience developing Access databases and applications for data transformation and Validation projects, understand the business process functionality and to translate them to Business Requirement Specification and System Requirement Specifications for Finance, Health industries, IT, Insurance and Publications.
• Solid background in table/query design, report design, data warehousing, data mining and automation utilizing VB modules.
• Strong track record collaborating with stakeholders to define functional requirements.
• Superior communication, interpersonal, and project management skills.
• In - depth understanding of Project Management Practices and Principles including Time Management, Budget Management, Resource Management, Master Data Management and Risk Management.

TECHNICAL SKILLS

Databases: Access, MSQL Server, Visual Foxpro, Tableau

Languages: VBA, SQL, Python

Business/Project Management Tools: Word, Excel, PowerPoint, OutLook, SharePoint, MS Project, Soarian, MS-Office, Excel, Power Point

PROFESSIONAL EXPERIENCE

Data Analyst/ Business Analyst

Confidential, New, York

Responsibilities:

• Gathering business and technical requirements and pay rules.
• Creating detailed business and IT specifications.
• Created full life cycle project plan.
• Automate Excel Reports using VBA.
• Write User Manual for reports.
• Use Tableau to extract data from Excel and SQL Server.
• Extract data from SQL Server connected by Python to create CSV.
• Generate over 10 statistical reports in Excel.
• Queried SQL Databases.
• Worked with IT to solve technical problems with SQL Server.
• Worked on requests from Editors.

Data Analyst/Access Developer/ Business Analyst

Confidential, New York, NY

Responsibilities:

• Gathered and analyzed business requirement and delivered business requirement documents, functional specification documents, test plans and requirement traceability matrices.
• Worked with business users, business SMEs and IT to further refine system effectiveness and communicated with business users on system productivity.
• Developed and maintained project schedules in Project.
• Produce Other than Personal Staffing (OTPS) Budget reports for 30 departments.
• Employ activity and data modeling, transaction/workflow analysis, internal control and risk Analysis and performance-measurement techniques.
• Have critical understanding of hospitals’ operation and systems.
• Developed a relational database in Access, using VBA, to schedule and track patients for therapist in rehabilitation.
• Maintain and support Excel worksheets for Finance. Developed with VBA.
• Responsible for all project life cycle from specifications and coding through deployment, testing, debugging, and documentation, and maintenance.
• Convert Excel and Access from Microsoft Office 2003 to Microsoft Office 2010

Project Coordinator/Business Analyst

Confidential, New York, NY

Responsibilities:

• Provide information and help resolve user problems regarding department systems.
• Act as liaison between department and IT personnel to support the business needs.
• Instruct user in all system enhancements and design activities.
• Provide to management to produce more effective means of accomplishing work.
• Reviewed user requests and conducted data-gathering interviews.
• Provide support to operating management by participating in operational analyses and studies.
• Provide management with analyst required for decision-making.
• Conducted Business Gap Analysis, feasibility study and impact analysis of the current functionality with respect to proposed enhancements and new requirements.
• Assist in evaluating new processes for use in operating areas.
• Monitored project lifecycles with Project.
• Administer PeopleSoft HCM.
• Created queries in MS SQL to extract data for reporting and analyst.
• Microsoft Access, Excel, VBA, and SQL for development, reporting, and analyst.

Data Analyst

Confidential, New York, NY

Responsibilities:

• Documented and tracked IT related issues until completion.
• Provided an overall atmosphere of continuity and transparency with respect to application releases and resolution of issues.
• Worked with supporting IT groups such as Development, and Help Desk to resolve issues.
• Participated in application testing during major releases and patches.
• Logged all issues encountered for the purposes of trend identification and consistent improvement of services.
• Developed schedule weekly basis using Project.
• Assisted manager with scheduling on Project.
• Third level point of contact for clients and liaison to the supporting IT teams.
• Identified, investigated, and resolved IT related issues as well as escalating to application specific support groups.

Manager

Confidential, NY

Responsibilities:

• Responsible for overseeing the conversion of data from 41,000 personnel cards into software system. System used to manage benefits for police officers.
• Managed day to day operations of 14 data entry and data analysis personnel. Position included hiring and firing of personnel.
• Set up training classes on the processing of cards and the use of the software system.
• Worked with end user to resolve any problems relating to the conversion process or any additions that would improve the system.
• Created data entry manual and user guide for software system.
• Prepare reports, studies and documentation. Delivered presentations.
• Created workflow chart for the conversion team.
• Scheduled work hours for each personnel. Provided time estimates for each phase of the project.
• Kept track of processing of each card in Access and Excel.

Database Developer

Confidential, Pompano Beach, FL

Responsibilities:

• Participated in the development of a client server application. Data uploaded and downloaded to Web Server used by law enforcement to track items sold and bought at pawnshops.
• Developed several statistical reports.
• Designed and implemented an on-line help for software.
• Developed stored procedures (combining SQL and Transact SQL language) and packages.
• Created system flow charts, manuals and user guide for software personnel and customers.
• SQL queries for Ad Hoc Reporting.
• In charge of resolving any problems that may arise from the customers use of software.
• Software developed in Visual Foxpro.

Access Developer

Confidential, Brooklyn, NY

Responsibilities:

• Processing State Tax Returns.
• Created user interface to produce statistical reports. Created in Access 2000.

Access Developer

Confidential, New York, NY

Responsibilities:

• Developed database system for pre-hire unit. System used to evaluate potential brokers credit and criminal histories, by using a point system. New system was authorized after providing charts and reports that it would improve processing (accuracy and time).Created several reports for system. Originally developed in Access 97. Upgraded to Access 2000. Documented and tracked pre-hire related issues until completion.
• Responsible for specifications, coding, deployment, testing, debugging, documentation, and maintenance.
• Developed using VBA.
• Databases and stored procedures created in MS SQL.
• Import data from MS SQL to Access. Modify data types as necessary for conversion to Access.
• Worked with supporting IT groups.

Database Developer

Confidential, FL

Responsibilities:

• Created survey reporting system utilizing Microsoft Access.
• Created user guides and system flow charts. Provided cost and time estimates for project.
• Upgraded an award system for personnel of Confidential using Visual Foxpro.
• Corrected many errors of previous system and made improvements that gave accurate data.

Manager

Confidential, Plantation, FL

Responsibilities:

• Developed inventory system with Visual Foxpro. System tracked purchase, pricing, consumption, transfer, and elimination of products.
• Developed reconciliation system with Visual Foxpro. Linked to inventory system. Over 200 stores used system.
• Inventory system and reconciliation system converted to Visual Basic5. As part of conversion had to make sure VB system worked same as Foxpro system by comparing data and reports.
• Created specifications, system flow charts, all user guides, and technical manuals for system using Microsoft Word.
• Tested debugged and trouble-shoot all systems.
• Ad Hoc Reporting.
• Trained all personnel on use of systems.
• Created data process system with SQL Server and Visual Basic. Developed stored procedures.
• Created job scheduler in Visual Basic.
• Provided support for LAN and all window operations.
• Supervised seven personnel, which included planning, developing, testing and installing software. Position included hiring and firing personnel.

Database Developer

Confidential, Plantation, FL

Responsibilities:

• Converted a collection system developed in Foxpro2.6 to Visual Foxpro.
• MS Word used to print letter from collection system.
• Upgraded customer credit card debt system to Visual Basic.
• Designed accounting reporting system in Visual Foxpro.
• Trained individuals on use of systems. Provided system flowcharts for all systems.

Foxpro Programmer

Confidential, Ft. Lauderdale, FL

Responsibilities:

• Converted customized accounting system in Foxpro2.6 to Visual Foxpro.
• Created stand-alone data conversion programs in Foxpro2.6.
• Enhanced and maintained various reservation modues in Foxpro2.6.
• Enhanced a procurement system in Foxpro2.5.
• Maintained ad hoc reporting system for procurement program in Foxpro2.5

Database Manager

Confidential, Washington DC

Responsibilities:

• Maintained data and manuals for FAA. Designed department inventory system in Foxpro.
• Exported data from Dbase III, Lotus, and Excel.