MS Access, Excel, vba, reports developer

R esume of Rona Rose

Microsoft Access Database/Excel/VBA/SQL/Power BI/Applications Developer

Summary of Qualifications

Microsoft Access Database/Applications Developer with an expertise in a wide variety of development techniques

involving extensive use of VBA, Macros, Structured Query Language (T-SQL), and custom data structures as well as a

business analysis. In addition, I have deep knowledge of migration of MS Access database to SQL and Oracle and a

proven track record of developing and customizing Microsoft Access applications from scratch. I have solid

experience in all phases of full life cycle development.

I utilized Power BI (Power Query) to create an application for my own Facebook. I get connected by means of Power

Query add-in to a Facebook feed and pull the data. Then I use that data saved in a spreadsheet as the feed to import in

to my Ms Access database, where I have written all sorts of queries to analyze my data, thus I can check all my posts

for a certain period of time, I can see all my friends and those, whom I added as new or the ones, who left me. I can

read all the posts I have ever posted at ease and not spend hours to find my information on the actual Facebook.

Technical Summary

Operating Systems:

SAP CRM, Windows (Windows NT, 2008, XP, VISTA, Windows 7 Professional, Win 365), OS/2, WIN 8.1

Application Development:

Microsoft Access 2003-2013 (including design, queries, forms, macros, reports, and data exchange/linking with SQL

Server and Oracle), scripting VBA within Microsoft tools such as Access, Excel and Word, ODBC to link ODBC

applications), Delphi3, VB6, VB.NET, VisualInterdev6, FrontPage2003.

Database Systems:

SQL Server2005-2008R2-2012, Oracle9i, Microsoft Access 97-200*-****-****, 2010, T-SQL, views, stored

procedures, triggers, integrity validation and business rules processing as well as extraction for reporting or migration.

Tools/Applications:

Windows Office Tools (10+ years) Microsoft Project, ODBC (Including SQL platforms, can extract/input data from

SQL Server/Oracle, and ODBC based Microsoft Access applications where the database platform could vary.) Oracle

Migration WorkBench, Crystal Reports XI, SSReporting Services, SAS 4.1

Other Skills:

Strong knowledge of and experience with MS Access 2007/ 2010, MS Excel 2007/2010, VBA, Strong knowledge of

and experience with SQL Server 2008 and above

Expertise in development using MS Access and SQL Server, Microsoft .Net 4.0, Subversion, SQL server management

studio, Visual Studio, Expertise surrounding software development life cycle methodology.

Professional Summary

Rockwell Automation (March 2012 – September 2014 – contract)

Database developer, Database Analyst, SAP Automation Reports development at Rockwell Automation

• Worked on creating business user tools in MS Access 2013 to fix errors in a backlog records, drawn from SAP.

Importing Excel files as Raw data and processing the records per business rules.

• Performed data analysis to clean up data, creating queries and automation routines.

• Creating reconciliation database and reports, from SAP CRM, heavy use of VBA (Excel-Access).

• Worked to create an end user database to analyze data pulled from Oracle and SAP CRM platforms. Presently

Worked on Error Analysis and Reconciliation modules. Extensive use of VBA to automate reports generation.

Worked on data architecture and business analytics. Created two new databases: Distributor and Customer

Dashboards and Reporting modules for US, Canada, Australia and new Zealand, to reconcile reports per months.

Reporting has a lot of business logic behind the data.

CitiGroup (September 2011 – March2012 – full time)

HF Intrm Sec Analyst

R esume of Rona Rose

• Worked on creating end user tools as well as user applications in MS Access and Excel to automate processes in

HF division, including re-design, data validation, business analysis.

• Created EUC/Project Tracking application, from architecture to design implementation, to track all life cycles and

milestones of Project timeline and development.

• Developed a number of reports, tracking and forecasting the dates and the % complete.

• Created embedded dashboards and analytical charts.

• Created activities tracking system, with version and issues control to keep track of design changes. Worked with

Geneva accounting system on creating different reports.

JPMorgan Chase (March 2010-September 2011 – contract)

Data Analyst

• Have worked as PM Test group reports designer, with MS Access databases linked to Oracle for data source

retrieval.

• Created pivot tables for data analysis.

• Created about 70 reports to be run on a daily basis from QC 9.2 and QC 10.0 for quality assurance. Linked MS

Access to Oracle Quality center, created pivot tables for the Excel reports.

• Worked with Quality center 9.2 and 10.0 to run reports. Run batch files and Scheduler to schedule time for

retrieving source data and processing data for the output reports.

*See Skills Profile for full employment details

Educational Summary

• BA in Patent Engineering, Central Institute for Management Personnel, Ukraine

• BA in Education, Kiev State Pedagogical Institute of Foreign Languages, Ukraine

Certification Summary

• CSC Institute, Southampton, PA, 2002 (VB6, VBscript, VisualInterdev, PL/SQL-Oracle).

• New Horizons (ASP.NET 3.5)

• Certified in SQL Server 2000-2005, MS Access2003-2010, Fundamentals, MS Access2003 Programming,

Excel2003-2010, Crystal Reports XI, VB.NET, VB6, MS Project, MS Project Management, MS PowerPoint 2013.

Skills Profile

Technology / Skill Experience Description

Experience developing database 15 years 1999-2000 –Ericsson(Czech republic) Telecom Roll-out Project database

objects (tables, forms, views, (Later on Split to SQL Server 2000)

queries, reports, etc.) within 2001 –RE agent database (for SouthJerseyHomes.com)

Microsoft Access. 2001-2005 Signs and Symbols (A Smartlearner.com)

2005-2006 Documentation Tracking Database (CCTS) (for LES –

Louisiana Energy Services)

2006-2007 RollOut telecom Project Database and Bon De Command

database – order tracking logistics (Lcc International)

2007-2010 Project Tracking database, Treasury metrics, Request

databases, Excel Automation (For Ace insurance company)

2010-2012 QualityCenterTesting Database (For JPMorgan Chase)

2012 – 9 months -CitiGroup

2012-2014 – ClientsAutomationReportingTools (Rockwell Automation)

Microsoft Access 2003 10+ years My most favorite version.

Microsoft Access 2010 4+ years Worked with it in JPMChase, as a Front-end, and Oracle as a back end

Experience developing 2-tier 7+ years I mostly worked with MS Access 2003 front end and SQL server

applications with a Microsoft Express 2005. I worked in both production and design environments.

Access graphical user interface The project was with Loisiana Energy services. It was ADP

R esume of Rona Rose

and a Microsoft SQL Server environment.

database

Developing applications with a 2+ years I mostly worked with MS Access 2003 front end and SQL server

Microsoft Access 2010 front end Express 2005 back end. In JPMChase I worked with MS Access 2010 as

connected to a Microsoft SQL a Front End and Oracle as a back-end.

Server 2012 database back-end

Experience successfully porting 7+ years I Had to do this with all my databases, the first version being 1995, now

(migrating) Microsoft Access I have all of my databases on 2013 version. I paid attention to what

databases, database objects and libraries in references have to be referenced.

applications from one version to

another Yes, not all the databases can be upgraded smoothly, it depends on

Migration experience must versions’ differences. I never had big issues.

include:

• I liked version when I was able to smoothly upgrade to ADP project and

Identifying and

this was my favorite configuration. But ADP project was deprecated by

troubleshooting conversion

Microsoft and now 2013 has no that kind of opportunity.

errors

• Evaluating options for

In some cases I had to redevelop the whole database…by creating a new

deprecated functions

database on the new version and importing the objects and checking how

• Converting forms and reports they function.

• Migrating Microsoft Access

databases

Experience migrating applications 4+ years Converted my databases from my portfolio show cases

from Microsoft Access 2010 to

Microsoft Access 2013

Experience successfully 5+ years Able to re-map datatypes, re-write SQL for the views when the syntax is

implementing changes required to different

Microsoft Access applications as

part of a Microsoft SQL Server

database upgrade

Experience creating, modifying 3+ years I use what drivers are already available and pre-installed on the

and using ODBC drivers with computers.

Microsoft Access 2010 (or later)

Experience implementing security 2+ years I usually use SQL (200*-****-****) server securities for adding new

groups using an Active Directory users assigning the objects the user can have access to. I have done the

solution for 2-tier applications conversion to ADP project, which was my best experience. If the front

with a Microsoft Access 2010 (or end is dot.net or vb6 - I had no experience in that. I also have experience

later) graphical user interface and in developing reports by SQL reports designer or Crystal Reports. But

a SQL Server 2012 (or later) my best tool is MS Access.

database

Experience creating and 5+ years I can back-up, restore, and create new databases in SQL server. I can

maintaining SQL Server database reboot the SQL server itself, in case it is down. I used to use the

objects, namely, T-SQL stored templates in SQL server for the stored procedures. I did not work with

procedures, functions, views, and triggers and complicated statements. I am a basic SQL developer,

triggers knowing how to establish schema, add remove tables and joints. I can

create views and work with SQL, but I am not strong with complicated

SQL statements.

IExperience with optimizing and 3+ years I did not work with complicated complex queries

tuning queries for SQL Server

2008 (or later)

Successfully 9 months Yes, My project CCTS for Louisiana Energy services.

rewritten/migrated/implemented Ms Access 2003-to-SQL Server Express 2005. The front end was adp –

at least one production the back end was SQL server 2005. I did not work with .Net.

application, taking it from a

Microsoft Access (front end)/SQL

Server (database) configuration to

a .NET/SQL Server web

R esume of Rona Rose

application platform.

Experience utilizing SQL Server 2+ years Yes, I was creating reports by reports designer. When I was working for

Reporting Services (SSRS). Ace insurance company. The SSRS were installed on SQL Server 2008.

Knowledge of PM methodologies 5 years (from My first PM database was created in 2006 when I was working for LCC

for system development projects project to International. Created even a database for that, adjusting developing

project) techniques to the specific project requirements. All my PM databases are

adjustable to specific features of the Project to Manage. My last PM

database was created to track effort (hours) spent by the team of the

developers, when the work of the developer is analyzed in terms of the

objects the developer created or changed + lines of code to be estimated.

Experience applying Change 5 years Was using Quality Center in JPMorgan chase for tracking changes…also

management processes to ensure created MS access 2010 database to track all the changes involved. Also

system changes are appropriately created a database for version control.

planned.

Contact this candidate