SUMMARY:

• Confidential is a data processing professional with over 10 years of experience in Client/Server application development, from business analysis and GUI programming to data warehouse design.
• He has worked extensively in Oracle, SQL Server environments using MS Excel and MS Access tools.
• He is outstanding both as a team worker and as an individual contributor.
• Confidential is highly organized, motivated and thorough.
• He is an asset to any development project.

SKILL:

Application Software: MS Access 2016, Visual Basic 6, VBA DAO, ADO.NET.

Database: Oracle 11g, 12c, SQL Server 2055, MS Office, Access 2016

Languages: MS Excel VBA, SQL, PL/SQL, Visual Basic 6

Software: MS Excel 2016, MS Word, Power Point, ERWin, Visio 2013, InfoPath 2016, SharePoint Services 3.0.

Hardware: Intel Based PC, Apple Macintosh Operating System: Windows NT, DOS, Novell and UNIX

EXPERIENCE:

Confidential, South San Francisco, CA

Business Systems Analyst

Responsibilities:

• Developer of Microsoft Office applications for Inventory and business process executives.
• I created ad hoc project management reports for MS Access for Inventory project management tracking.
• Performed as an analyst in migration project from Hyperion to MS Access and SAP reporting system.
• Guided the Inventory control team as to form SAP system migration strategy from Hyperion database.
• Created reports for project leads.
• Lead meetings and performed in project JAD sessions.
• Provided documentation for applications.
• Deep atomic level data analysis of manager historic data on SharePoint using SQL queries.
• Perform systems analysis to reverse engineer logical models for business expert presentations in Power Point.

Skill: Windows, SQL, Oracle Hyperion, PL/SQL, MS Power Point, SharePoint, UNIX (Linux), MS Access 2016, Excel Macros (VBA)

Confidential, Helena, MT

BSA/ Developer

Responsibilities:

• Performed business analysis for projects.
• Interviewed users and validated business rules.
• My database responsibilities included application and GUI development for front end MS Access application and Oracle connected databases.
• Managed project planning and development of local Client/Server applications.
• I created forecast budgeting and lease tracking system application in MS Access with date sensitive reports to ensure data integrity.
• Maintained functionality of the applications incorporating data from the Internet, the Oracle data warehouse and hierarchical database.
• Created test plans and created gap - fit documents to catch missing functionality.
• Designs schemes for system data flow charts and ERD documents.
• Aided organization in distribution of new application releases for the end users.
• Worked with employees application and users to train in new and existing applications.
• Performed modeling duties for Oracle 10g and SQL Server 2012 systems using ERWin CASE tools.
• Test and update System/Cutover Plan to Qracle.

Skill: MS Access 2013, Windows, Oracle 10g, SQL Server 2012, PL/SQL, Data Warehouse, Data modeler, Erwin

Confidential, St. San Francisco, CA

BSA, Developer

Responsibilities:

• Update technical documents to support system development.
• Maintain financial tracking systems web portal with MS Access issues tracking system.
• Created ad hoc and canned reports for the MIS department as per user request.
• Modifying applications on the Oracle 10g database, incorporating business rules for the Confidential web portal into the applications.
• Configure VBA and MS Excel Macros for applications according to business rules.
• Maintained back office applications.
• Designing logical data models of database for documentation.
• Developed artifacts tables based on criteria gathered from meeting with facilitators and business experts.
• Performed necessary systems analysis for web team and end users data support with integrity issues.
• Canned report and database maintenance.
• Automate transfer of data between Oracle tables and MS Access application via ODBC.
• Application documentation and user defined data definition manuals.
• Interviewed users for testing and application distribution.
• Used Visio to document projects and reverse engineered Oracle databases using CASE Tools.

Skill: MS Access 2013, VBA, Excel, Windows, SQL, SQL Server 2014 and Oracle 10g, PL/SQL, ODBC, Data modeler, ERwin CASE Tools

Confidential, Redwood City, California 9

Data Modeler

Responsibilities:

• Reverse Documentation Business systems analysis for data dictionary project for the data warehouse team. Interviewed users and validated business rules.
• Document existing code and created a repository of business rules.
• Working as a lead developer at Confidential data warehouse team I designed data models and created Oracle databases for data store.
• Working independently and with facilitators to create a comprehensive representation of business objects and entities for the business data dictionary.
• Worked to enhance data warehouse design by creating a fact table.
• Reversed engineered data models into business systems on the Oracle database.
• Used Oracle 10 databases to develop business fact table.
• Used Erwin CASE tool to create dimensional data models.
• Connected via OLE DB protocols to Oracle.
• Reverse engineered Oracle databases.
• Support End-user development and delivery to VBA front end GUI solution.
• Assisted the QA manager and application users to clarify definitions for business data.
• Developed ERDs, data process and data flow charts showing business schemas to give understanding of data key points during production development.
• Participated in JAD sessions to design logical models of an existing physical database.
• Interviewed facilitators, users and business experts to gather business requirements and created business user manuals.
• Documented code and gave presentations on schemas and databases functionality.
• Execute final system/ cutover plan for Go-Live events.

Skill: Data modeling, Windows 2000, ODBC, ERWin, Visio, Oracle 10g, CASE Tools

Confidential, Lyndhurst, NJ

Business Systems Analyst

Responsibilities:

• Worked as a member of the data warehouse team.
• Provide functional and technical analysis for front-end Excel development. data mining the oracle data warehouse and using Toad and SQL*Plus environment development tools.
• Extracting and transforming of business information for reporting for use by business experts and departments.
• Worked in SQL* Plus environment and with other oracle tools.
• Managed UNIX file system to track reports. Documented SDLC testing.
• Worked with DBAs to create functions in PL/SQL to modify data warehouse dimensions.
• Scheduled and run date sensitive reports.
• Maintained and upgraded MS Access applications as part of my daily database duties making use of VBA for functionality and using Excel with macros for reporting.

Skill: Data modeling, Windows 2000, ODBC, ERWin, Visio, Oracle 10g, CASE Tools