Sql Server Project

Rona Rose

Developer/reports designer in MS Access and Excel 2003-2010

LinkedIN profile

BrainBench certification: transcript No: 6687545 (for the year 2007)

BrainBench certification: transcript No: 506403 (for the year 2010)

In order to see the transcript, go to www.Brainbench.com and enter my transcript number.

3312 Whitfield drive

Reynoldsburg, Oh, 43068

Phone: 856-***-****, E-mail: ********@*******.***

SUMMARY

Experience

Over 10 years experience in Information Technology industry with full lifecycle development. Microsoft Access database developer with a wide variety of development techniques, all projects, which involve extensive use of VBA, Macros, Structured Query Language (T-SQL), and custom data structures.

Very proficient at creating reports both in MS Access and MS Excel, including complex reports with charts.

Can connect to different datasources, including Excel and Oracle in order to create reports from the different datasources.

Can automate reports import or export to and from MS Access.

Adapt with VBA, use it for automation processes.

At JPMorganChase:

PM test team Reports Developer

March 2010 – Present (18 months)

- As PM Test Team Reports Designer created Excel reports for Retail IT Test Team to monitor Quality Center test execution performance and other metrics.

- Performed data mining analysis by means of extensive use of PIVOT Tables.

- Imported the data sources from Oracle databases through ODBC connections.

- Automated the reports processes by means of extensive use of Macros and VBA procedures. Automated processes by means of .bat /.com scripts.

- Populated 70-100 reports for about 10-15 projects on a daily basis as per request and emailed/upload To the SharePoint intranet site to monitor KPI.

- Created BOW (book of Work) database template in MS Access 2007 format.

- Worked in Quality Center 10.1 ( 9.2) to monitor reports data. Created queries for tests metrics.

At Ace:

Have designed and developed “Request database application”, which provides for the Static Data Input, required for Quantum (Treasury data application, in VB6 as a front end, and Sequel Server 2005 as a back end), namely for Bank Accounts and Instruments as a standalone database application, which performs data validation and executes automatic email notification of the application users upon the successful input. I have created a reporting module with 15 different reports to control the entire input and validation process. I linked by means of dsn to Sequel server 2005 tables and wrote complex queries for the reports. It is MS Access 2003 application. The reports may be exported to Excel in xls or cvs formats or saved in pdf format.

Created Terminator, an Access database, with the help of which I was able to check on users active access to Quantum application as per the SOX requirements.

Also created eRequest (Dot Net version of Request database application), the front end is VS 2008 and the back end is SQL Server 2008. It is a database web application, which has the same functionalities as Request database application. The reports were written with the help of the in-built Crystal Reports Designer. Reports were also created in Crystal Reports XI and then used in an application.

Also created SOX Disbursement Application, which allows through ODBC connection to link to Quantum back end tables and to process data.

Also created Online Banking Database Application, to process reports from different online banking applications (User-Entitlements reports only). The reports produced by the online applications were imported to MS Access database in the xls or csv formats, reformatted for a better data type’s conversion, and later on used to create the reports in MS Access 2003. Then they were exported back to spreadsheets and distributed among the managers. The main role of this application was to monitor/edit access of treasury users to different online bank accounts and different entitlements and to change this access with regard to the approved access.

I was the primary contact for BRMedge application (installation and issues).

I was the primary contact for CPMA application, and later on for Maximo (to create and follow up CPMAs as per requirements).

At LES:

Project Management and Document Control functions, creating all sorts of document control systems, recently created database is Adp/SQL 2005 Configuration Change Tracking System, with the extensive use of DDL and DML, creating triggers, store procedures, functions, allowing creating ad hoc dynamic reports

CCTS database was mainly aim at creating KPI reports for the management team and therefore it contains more than 100 reports in it.

Multiple years of experience with Microsoft Access including design of tables, queries, forms, reports, and data exchange/linking with SQL Server and Oracle, ADO 2.6. , ADO.NET 3.5.

Responsibilities have included architecture, design, design review, coding, test plans, creation/execution, management and data manipulation.

Provided maximum project flexibility with a variety of import and export routines by creating custom file parsers and Excel spreadsheet outputs. SQL Server 2005.

Have years of experience with Microsoft Office products and am adept with multiple Operating Systems.

Involved

• Provided users with vast knowledge base of support engineering and analysis skills for exploiting computers to provide greater security, productivity, and usability.

• Solving business problems and improving productivity of my applications, both qualitatively and quantitatively, by providing business/technical support and analyzing, developing and implementing systems, tools, and procedures. (Visio flow-charting of the business rules).

• Provided the management with detailed analysis for better decision-making in terms of processes and software solutions.

• Leading requirements gathering sessions with business management and leadership regarding tools and systems to be used by various business units.

• Used PowerPoint and Visio presentations in these sessions.

• Performing requirements gathering, risk assessment, test plan, testing cases and scripts, and test summarization of data management tool using standardized systems quality methods.

• Creating testing scripts using step-by-step screen shots of actual installation, configuration, and utilization screens with MS Word, Photoshop CS, FrontPage.

• Writing and running data extract programs from internal/external file sources in support of analysis and preparation of reports (MS Access automation routines)

• Assisted in project management supporting the needs of department/functional unit.

Documenting/help

Preparing technical documentation for users, IT staff, and functional units. Developing help files in FrontPage, HTML Editors, and RoboHelp.

Identifying training opportunities to facilitate professional development and enhance quality of service.

Performing the review, analysis, design, testing, and implementation of special projects as assigned.

Assisted with development of web-based knowledge base used by helpdesk analysts.

Providing big-picture direction as to user-interface and design to ensure this tool would be beneficial to both helpdesk analysts as well as non-technical users in the corporation.

Experience in Reporting Services (Access, Crystal ReportsXI, SQL Reporting Services SQL 2005)

TECHNICAL SKILLS

Operating Systems: Windows (Windows, 95, 98, NT, 2000, XP, VISTA, 7), OS/2.

Application Development: Microsoft Access (10+ years)(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 applications),Delphi3, VB6, VB.NET, VisualInterdev6, FrontPage2003, VS 2008, DOT NET, ASP.NET3.5

Database Systems: SQL Server2005, Oracle11i, Microsoft Access 97-2000-2007, 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 (SQL 2005) and API based applications to extract/input data from SQL Server/Oracle, and ODBC based Microsoft Access applications where the database platform could vary.) Oracle Migration WorkBench, Crystal Reports, SQL Server 2005 Reporting Services. Hands on SAS 4.1. ASP DOT NET 3.5

Other Skills: SQL Server 2000-2005, MS Access (95-2007), Crystal reports XI, Excel2003-2007, PowerPoint2003-2007, MS Visio, Oracle9i, T-SQL, SQL Server 2005 (admin/design), VBA, RoboHelp, WinHelp, Visual InterDev 6.0, ASP3, VB6, VB.NET, Delphi3, Web design: Visual Web Developer 2005, (FrontPage2003, Web Expressions). Adobe Photoshop CS.

Best skills:

Knowledge of migration of MS Access database to SQL or Oracle (not only connection/import but also nifty-thrifty stuff of the final tune-up of the data transformation)

Custom Microsoft Access applications from scratch.

EDUCATION

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

• MA in Education, Kiev State Pedagogical Institute of Foreign Languages, Ukraine 1972-1977. Honored Graduate.

CERTIFICATION

o ASP.NET intensive course at New Horizons (VS 2008, SQL Server 2008)

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

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

o Certified in SQL Server 2000-2005, MS Access2003Fundamentals, MS Access2003 Programming, Excel2003, Crystal Reports XI, VB.NET, VB6, MS Project 2002, Project Management, MS PowerPoint, Systems Analysis

o BrainBench certifications: transcript 6687545

o BrainBench certifications: transcript 506403

PROFESSIONAL EXPERIENCE:

Present contract position:

Collabera: from March 2010 till now.

Work for Chase Home Lending as Database reports developer/designer.

Responsibilities: Create reports in MS Access from Oracle as a source of data as per the requirements. Import/Export data in/from Excel, heavy use of VBA and pivot tables, developing and running macroses. Automating reports. Create/develop Ms Access databases as per request (BOW).

Ace Insurance Company June 2008 – January 2010

Roles: Systems Analyst, Business Analyst, Database Designer, Applications developer

Environment: Citrix, MS Windows XP, Windows 2000 server, Windows 2003 server, SQL 2000 server, SQL 2005 server

Responsibilities:

The responsibilities include development, test and implementation of new mid-range applications for Global Treasury, development and implementation of reports as per business requirements. Support the production and development environments for Global Treasury and Corptax.

1. Application maintenance, upgrades and implementation support for Treasury and Tax workstations. This would include the following functions:

• Assist with vendor application upgrades for Tracker, Quantum and BRMEdge.

• Work with 3rd party vendor to develop, customize and maintain interfaces.

• Test applications when changes are applied due to the environment - software, operating systems, or hardware upgrades.

• Develop, customize and maintain existing applications using MS Access.

2. New development

• Assist in the business process redesign and documentation as needed for new technology.

• Design, develop and implement data consolidation, aggregation, reconciliation and reporting solutions for Global Treasury Department using .NET, SQL Server, MS Access.

• Develop, test and implement Reports using MS Access or Excel.

3. Other Application support:

• Administration of Bank proprietary systems: BADirect, Wells Fargo CEO, Wachovia, CitiDirect, JPMorganChase, iTelecash, HSBC, BNYMellon.

Basic knowledge of SunGard Quantum (Import of BAI files, Export of EFT files, Message Inquiry Reports), Tracker Escheatment system (administration), BRMEdge and APECS.

Have developed a number of applications: Request database (Ms access 2003- input data for Quantum interface), eRequest (Dot Net Application), SOX Disbursement, IT Dep KnowledgeBase, GL Extract upgrade, Online banking recertification database, Terminator (Quantum users as per Sox requirements), Multiple Projects Management System, etc.

Louisiana Energy Services August 2007 –April 2008

Role: SQL 2000-2005 Database designer/admin

Project: NEF

Environment : Microsoft ADP/SQL Server 2005

Responsibilities:

Make design changes to the existing CCTS adp/sql database (Configuration Change Tracking System), document control over design changes in the project.

Create new databases as per request, ensuring control over different documents and procedures.

Data maintenance and data manipulation, running ad-hoc views, stored procedures, triggers, functions.

Designing required reports as per request, improving the performance and design.

Documenting the whole database, including all the objects in a specially created for this purpose database.

Writing help manuals.

LCC International, Inc March 2006 – February 2007

Role: MS Access database designer/admin

Environment:

Project: GSM Telecom Rollout Project

Responsibilities:

• Designed MS Access 2003 database for the Rollout Project “LCC Rollout GSM database” according to the client’s requirements.

• Used Microsoft Access and VBA script to write tools to automate customer support reports.

• Information for reports came from a variety of Excel files and SQL Server tables.

• Application linked data from SQL Server 2000, imported flat file values, evaluated domain responsibility for the errors, and generated errors to SQL Server 2000.

• Designed Microsoft Access database, which comprised many forms, queries and reports and included an auto population mechanism, which took data from multiple sources.

• Designed from the scratch. Imported data from the Excel spreadsheets into MS Access database.

• Created a number of reports essential for the project operation, provided the reports both in Access and Excel formats, developed Operational, Logistic, Finance, Production and Management modules.

• Worked on tables, forms, queries, reports, macros.

• Worked with VBA coding for a better application interactivity and a more ergonomic interface.

• Worked with workgroup administration file, assigning access and roles. Resolved security issues with MDW file.

• Created Purchase Order database, which is a billing application.

• Created more than 45 reports.

• Created Human Resources database for the project team, triggers and procedures.

• Created Tracking database for maintenance of the design changes in the databases.

WorldNet Realty, NJ April 2002 – March 2006

Role: MS Access database designer

Responsibilities:

• Designed the database for Real Estate Agents in MS Access 2000, (mdb. file,).

• Its 15.5 MB in size, pass-protected; it contains 46 tables, 69 forms, 62 queries, 8 macros, 38 reports.

• It facilitated the activities of the Real Estate Buyer’s Agent, where the great attention is paid to follow up the dates.

• Adjusted workgroup file to ensure group and personal access and rights to tables, forms.

• Checked the validity of table records and performed the repair of the data, in case of corruption.

• Made links to the external sources (databases) to store or to get the information.

• Also created 31 reports to follow up the real estate activities.

• Took care of the deployment of the database to other computers.

• Saved data on a daily basis, ensured the integrity of the whole database.

Private Scientific Industrial Company “Rona”, Kharkov, Ukraine September 2000 – April 2002

Role: Executive Director

Environment:

Project:

Responsibilities:

• Designed the educational multimedia project in Delphi 3 - “English for kids and parents”, based on the new teaching technology. Demo CD is available.

• This project was approved by the Ministry of Education of the Ukraine and Russia to be widely used in secondary public schools as the alternative teaching method based on multimedia.

• Published 800000 copies of books, certificate from the Book Chamber.

Ericsson, Czech Republic November 1999 – September 2000

Role: MS Access Database Designer/Administrator

Project: Rollout GSM project.

Responsibilities:

• Worked for Ericsson in the Project Planning & Co-ordination Department as a database Administrator/Programmer.

• Primarily responsible for the provision and maintenance of a Project Management Database.

• Responsible to support the users in their daily work, acting as a user help desk as well as identifying the needs for the design of new database functionalities.

• Worked on tables and fields as well as on the development of reports and data interrogation forms.

• Designed the new modules, administered in SQL environment, designed and ran all kinds of the reports, took care of maintenance and bug fixing.

• Used reports created in MS Access for VIP at the meetings on the spot, upon their request.

• Created help instructions and documenting the database.

• Used RoboHelp.

Tebodin Consultants and Engineers 1998 – 1999

Role: Head of Information Department.

Responsibilities:

• Collected and processed market information, developed different kinds of databases in MS Access and Excel as well as ran different reports and to performed general Project Management Control with respect to the client’s scheduled milestones.

References:

JPMorgan Chase, 3415 Vision Drive, Columbus, OH, 43219

1. Mark Boggs (VP test Delivery Servicing and Default Project – 614-***-****, email:

****.*.*****@********.***

Louisiana Energy Services, Cherry Hill, NJ

1. Kate Scanlan (Information Supervisor - cell phone 419-***-****)

LCC International

1. Fabio D’Emilio (Senior VP Operations - email: ********@***.***)

Ace Insurance Company, 510 Walnut st, Philadelphia, PA, 19106

2. Denise Carson: 215-***-****

- Reference letters are available upon the request

Contact this candidate