OBJECTIVE:

• A VBA, reporting developer or business analyst position consistent with my qualifications and experience

SUMMARY:

• 10+ years of software development programming & Business Analyst experience
• Strong proficiency in Microsoft applications, specifically with MS Excel (with formulas, pivot tables, VBA etc), MS Word, MS Access, relational database technology.
• Expertise with query languages such as SQL, database management, manipulating large datasets, write report generation tools
• Strong programming skills in VBA, Excel, SQL and Visual Basic.
• Strong database and applications development skills using ORACLE, MS Access.
• Effective communication skills, effective working both independently and as part of a team
• Ability to manage multiple projects and tasks simultaneously. Ability to work independently and as part of a team in a collaborative manner.

TECHNICAL SKILLS:

Programming Applications: VBA, Visual Basic, SQL, SSIS, SSMS, SSRS, Reporting, Business Intelligent (BI)

Database: SQLServer, ORACLE, MS Access

PROFESSIONAL EXPERIENCE:

Confidential

Business System Analyst

Responsibilities:

• Provide advanced - level analysis and day to day support for all Business Services applications in the complex healthcare industry.
• Automated data processing solutions to increase the efficiency and effectiveness of work processes.
• Working on numerous system integration, database loading and extractions to meet business process and reporting needs. Work with complex data sets, repair inconsistencies with detailed data, and research appropriate resolutions.
• Currently working with SQL-Server, SSIS, SSMS, SSRS and Excel VBA.
• Knowledge of MS Access, SharePoint and Powershell.
• Working collaboratively with all levels of hospital employees in systematic problem solving and innovative thinking; generates detailed reports that are both deadline driven and require a high level of accuracy.

Confidential

Senior Business Analyst

Responsibilities:

• Worked in a planning and forecasting group.
• Developed a tool on Excel using VBA to automate the business processes.
• Designed and developed a user interface to extract data from over 30 strategic customers with various format weekly for loading to the corporate forecast planning system.
• Created quantitative forecasting, operational, and statistical models to guide business decisions.
• Gathered relevant data and built performance dashboards to conduct business analysis and provide recommendations on improved reporting infrastructure.
• Extract business insights to guide marketing campaigns, budget, and identify / prioritize product feature requests.
• Automated and maintained various reports and helped the other analysts in the team with their efforts.
• The team relied on my accurate data management and timely responses to their requests.
• Strived to provide a strong customer service attitude, and assist the team in meeting their objectives.

Confidential

Application Software Engineer

Responsibilities:

• Responsible for development of software tools, and methods for the System Engineering Group. The tools organize and manage data collected from laboratory experiments to generate spec, charts and reports using VBA and Excel. The other tools are using an Access database to manage internal testing data. Multiple input treads can insert, modify data simultaneously. The user interface was written in Visual Basic 6.0.

Confidential, Palo Alto, CA

Reporting Engineer

Responsibilities:

• I was responsible for analyzing end user data requirements; translating the requirements into functional specs and designing/developing reports to provide information to the business users. I worked with a dynamic team of individuals and collaborated with business units to contribute to the success of the company. I was also in charge of Oracle development, using PL/SQL and was the part time DBA. Other responsibilities included collecting data from various data sources, and integrating them into a data warehouse structure. Various reporting programs were developed using Oracle SQL*Plus, PL/SQL, SQLLoader, OCBC and VBA.

Confidential, Menlo Park, CA

Project Lead, Business Analysis

Responsibilities:

• Onsale was a 24 x 7 online shopping e-commerce company. I developed an Intranet data mining reporting system using ASP and VB Scripts running on Microsoft web server. A user interface was developed to allow for report generation by selecting a reporting category and report title from the menu screen, result populated HTML and Excel spreadsheets as an option. Other activities included; responsibility for ongoing, development of new reports, daily report generation and maintenance of existing reports, writing and tuning various reports in SQL*Plus and VBA for the company executive, accounting, marketing, merchandising, advertising, customer service, and, engineering. The reports were viewed as a tool for determining the company’s strategy.

Confidential, Belmont, CA

Worldwide Customer Support

Responsibilities:

• As a Sr. Software Engineer I was responsible for designing, developing and programming different levels of complex reports using SQL*Plus, HTML on Windows web servers for posting reports, Oracle Reports 2.5, Visual Basic for Application (Excel) in a client/server environment against one or more Oracle databases. These reports were used by all managers within Oracle Worldwide support division.