Mary Smith

E-mail: adwe0d@r.postjobfree.com

Phone: 619-***-****

SUMMARY OF SKILLS

Twenty years of experience administrating MS Access, MS SQL Server Databases as well developing and coding SQL, VBA, VB 6.0 and .Net Applications

The proven ability to conceptualize complex business problems and interpret customer needs to produce flexible solutions supported by educational background and experience

Plan, Conduct, Direct and Resolve various business problems by creating automated computerized systems

Proficiency in business application planning and development

Ten years of management experience: Strong interdepartmental coordination and communication skills

Excellent problem solving and decision making skills

Strong leadership and interpersonal skills

Ability to work under deadlines, meet project commitments and quickly adapt to changing priorities

Knowledge and experience in SQL Server 2000, MS Access, VBA, XML, GUI Development, VB.Net, ASP.Net, ADO.Net, ASP, JavaScript, VB Script, HTML, CSS, GIS, Adobe, PhotoShop, MS Office 2000, Adobe Acrobat, Fireworks, Java, C, DOS, IIS.

WORK HISTORY

10/2022 – 4/2023 Qualcomm – Wireless Technology & Innovation

Data Analyst - Supply Chain

Working with New Product Development Team to create an application will coordinate all the activities, around New Product Introduction. The application save time for planners, allows them to make realistic forecasting, and what if analysis. It also provides information to upper management to evaluate activities and make informed decisions regarding NPI. The application creates a dashboard to homogenize all the different type of files to help smooth information flow and coordination about all activities around the New Product Introduction activities.

01/2011 - ISPS, Integrated Sales Process Solutions, ISPS Jamul, CA

10/ 2022 Independent Consultant

Analyze needs, project requirements, data architecture

Conceptualized and Developed Website Applications using MS SQL Server, ASP.Net, VB.Net and SQL, VBA

Website Development and Affiliation Interface using ASP.Net and Various Reporting Apps including data mining, sales metrics, shipping reports, inventory logging and reporting using VBA

01/2010 - Amylin Pharmaceuticals, La Jolla, CA

11/2011 Business/IT Consultant

Created Quarterly Business Reports and Key Performance Indicator Reports Applications that produce ad hoc reports and graphics with very flexible parameters for Contract Performance Analytics utilizing MS Access, MS Excel, SQL, PL SQL, ODBC with Oracle CARS and Excel data sources utilizing Visual Basic for Applications – Microsoft

03/2007 - Hewlett-Packard, San Diego, CA

10/2008 Business/IT Consultant

Created and Managed several VBA applications that produce ad hoc reports and graphics with very flexible parameters on business processes such as sales, setup, replenishment, repair processing utilizing MS Access, MS Excel, SQL, PL SQL, ODBC with SQL Server, Oracle back end data.

Input and output excel data manipulating and producing reports using scripted Macros, Pivot tables, and Adhoc Graphics.

Computerized a Finance Forecast Model that requires creating a new database and developing GUI that gets input from multi-users, consolidates and processes the data, generates financial statements such as yearly, quarterly income statements as Excel reporting.

03/2002 - Technology User Database Latin America, El Cajon, CA

01/2007 System Analyst / Software Developer

Developed and coded applications utilizing VBA, VB 6.0, Microsoft Access, Excel Macros, as well as other tools, to import, compare, modify, analyze, and export reports

Customized Excel Macros to create output that supports client’s applications such as CRM, ERP or other in-house applications

Created complex, multi-table queries, reports, data entry forms, GUI, as well as creating and modifying table structures

Initiated and implemented the transition from MS Access database to MS SQL Server 2000 by using DTS

Imported data from a variety of sources to expand the existing database

Established business needs and customer requirements for new databases and their direct relation to custom applications, created database specifications and designs, and implemented database creation, and provided documentation

Created many applications that supports efficiency, productivity such as evaluating employee performance, creating standardized pricing system

Recommended enhancements and modifications to systems and procedures to improve the services provided by the Information Technology department

Gathered, organized and coordinated complex requirements from various clients, users and various levels of management and end-users.

Designed and customized various types of reports and applications that corresponds the clients needs, and requests

Consulted to clients such as IBM, Dell, Hewlett-Packard, Cisco, and Oracle for the purpose of delivering customized databases

Evaluated existing database, making revisions as necessary, to ensure databases as well as related applications and processes meet current business needs and customer requirements

Communicated effectively within all areas of IT and troubleshot issues

Efficiently managed time for completing urgent requests

Provided guidance, training, and assistance to the team members where needed

Administered creation, enhancement, support, maintenance, troubleshooting, monitoring, backup, restoration and optimization of MS SQL Server DB

Installed, troubleshot, and created maintenance, backup and restoration of SQL server 2000 Database on Windows-based servers

Developed, deployed and maintained navigation, flow, look, and feel of Company’s website www.tudla.com by using HTML, ASP, JavaScript, VB Script

02/2006 Business/Systems Analyst

Traveled to Asia on short-notice and met with the Primetrica Team regarding an IT issues.

Gathered the information and the issues about the requirements from the team and the client.

Trouble-shoot with the team and suggested the actions necessary.

Created small applications that resolve the issues related to the existing invoicing database system.

Re-designed and repaired the system for one of Primetrica’s major client Hewlett-Packard.

Delivered a working system that supported the client’s needs—the job was completed to the

satisfaction of both Primetrica and their client.

Continued to assess and determine problems after returning to the states; fine-tuned the system.

09/2001- American Systems Corporation, San Diego, CA

02/2002 Database Analyst

Analyzed the business processes and requirements of Special phone systems

Converted the requirements and the rules into specifications and flow charts of a database and interface

Created an MS Access 2000 database to keep track of activities by using these specifications related the procurement, maintenance, and issues of each phone system such as tracking the stocks by using a scanner, following the history of maintenance activities and location changes of the each phone system

Created a database-driven web application for U.S. Navy clients by using VB Interface

09/2000 - Grossmont College Student Education Technology Lab. El Cajon, CA

09/2001 Programming and Computer Tutor

Tutored Programming in Education Technology Lab

1998-1999 GILLETTE Co. Santa Monica, CA

System Analyst--Pen Division

Analyzed various production processes and workflow

Identified problems related to production/workflow processes

Formulated and conduct tests on manufacturing presses

Gathered, examined, and analyzed data from test results and observations

Created alternative solutions to reduce costs

Resolved problems and managed complaints

Made recommendations to improve manufacturing process and recording systems

1990-1997 VAKIFBANK Ankara, Turkey

Credit Analyst in the Marketing/Intelligence Department

Investigated credit worthiness of commercial clients

Analyzed in-depth of business financial statements

Reconciled correspondents’ bank accounts

Managed cash flow from 350 branch offices

Worked in deposit and loan services for customers

EDUCATION

2008 – 2009 Interactive Media Certificate Program

Continuing Ed San Diego Community College District

2000 - 2002 GROSSMONT COLLEGE, El Cajon, CA

Specialized Training-Computer Programming - GPA 4.0

Various Accounting Classes (UCLA, COS)

Database Administration and Visual Studio.Net programming classes (UCSD)

Interactive Multi Media Certificate Program (Continuing Education, North City)

1994 - 1996 UNIVERSITY OF ANKARA, Ankara, Turkey

Coursework toward the M.B.A. (Banking emphasis)

1982 - 1988 UNIVERSITY OF ANKARA, Ankara, Turkey

B.A. in Business Administration

Contact this candidate