SUMMARY:

• Analyst awith expertise in transforming complex data into business insight for stakeholders. Strong analytical, quantitative, and problem - solving skills. Prepares and presents information in a clear and comprehensible way.
• Extracting business data from data warehouses, databases, reporting portals, workbooks, text files, report decks
• Utilizing software tools to query, filter, group, define, summarize, and pivot data
• Connecting, combining, and manipulating data in Access and Excel
• Designing and building reporting in Excel for presentation, reading, further manipulation, or interaction
• Protecting and carefully handling Confidential and personally identifiable information
• Experience in many industries, working in various functional business areas and working with people of all levels of organizations and with diverse backgrounds. Customer service oriented.

TECHNICAL SKILLS:

Techology and Tools: Advanced Excel: complex formulas, vlookups, pivot tables, data filtering, graphs/charts, macros, hyperlinks, importing data, s to other sheets and workbooks, cell and sheet protection, workbooks with interactive interface for analysisMicrosoft Access, Business Objects, Hyperion, SQLEnd user of reporting websites including MicroStrategy, Cognos, JasperSoftUnderstands relational database concepts, data modeling, and report design.Decision support has enabled colleagues and management to: monitor sales and business activity, monitor customer behavior, track promotions, measure program performance, forecast future sales, identify business opportunities, decide on marketing strategies, expand sales.

PROFESSIONAL EXPERIENCE:

Confidential, Torrance, CA

Database Analyst (Data Analyst, Reporting Analyst, and Subject Matter Expert)

Responsibilities:

• Assisting Export Parts Operations to manipulate data more efficiently and obtain more needed information.
• Building Business Obects queries and Excel reports with particular attention to lead times and back orders.
• User acceptance testing of new data warehouse tables and reports built by IT division.
• Analyst (Data Analyst, Access Database Developer)
• Researched accessory marketing s current processes and reporting; investigated available data sources.
• Built an Access database and enhanced Excel workbooks to reduce the manual labor required for routine accessory parts sales reporting and analysis; expanded use of Business Objects for querying a data warehouse.
• Analyst (filled in for co - worker on medical leave)
• Provided reporting and analysis in support of collision parts programs, promotions, and initiatives. Provided ad hoc and scheduled periodic sales and analysis reports to marketing and management.

Confidential, Torrance, CA

Reporting and Business Information Analyst

Responsibilities:

• Provided metrics to Telematics decision makers and other stakeholders with multiple routine and ad hoc reports
• Developed, modified, and maintained 25 - sheet Excel workbook of business metrics and key performance indicators (KPIs): summaries, tables, graphs, charts, and supporting details.
• Developed and maintained Hyperion BQY (query) files which provided Oracle-sourced data for reporting.
• Utilized reporting portals to obtain business data. Platforms included Cognos, JasperSoft, MicroStrategy.
• Obtained data from other departments and vendors excel reports, text files, and reporting decks. Transmission was through email, ftp sites, Sharepoint, and Box.
• Interfaced with vendors (external service providers): identified and discussed required data elements.
• Reporting SME (expert) for change requests and for BRDs (requirements) for future telematics products
• Advised others of data sources; user acceptance testing and other project support

Confidential, Torrance, CA

Parts Sales Analyst (Decision Support/Reporting Analyst)

Responsibilities:

• Designed and prepared Excel reports and graphs for Parts Marketing and management by extracting and manipulating parts sales data from various sources. Utilized tools such as Business Objects, Excel, Access, and company - specific business application software used to obtain company sales, customer, and product data.
• Designed and created new reports; created required data warehouse queries and Access databases.
• Supported decision making by performing ad hoc analysis for Parts Marketing and senior management: required listening to manager and understanding issue of concern; conceiving method of collecting and preparing data and representing issue; ensuring accuracy and applicability of data; preparing and explaining reporting.
• Performed assorted clerical and administrative tasks; used Excel, SAP, Oracle, PeopleSoft, in-house systems.
• Primarily accounting departments; also: payroll, administrative, production, import/export, logistics, .
• High-tech and other manufacturing, software sales, hospitals, university plant operations, international air express carrier, international trade, vehicle services, automotive.

Confidential, Torrance, CA

Programmer/Analyst and Software Tester

Responsibilities:

• Developed, tested, and maintained application software used by Honda and Acura dealerships.
• Coded and debugged Visual Basic programs.
• Previous Employers (Career as Business Applications Programmer/Analyst)
• Utilized query languages for testing, problem assessment and resolution, and analysis.
• Used and maintained stored procedures; established coding standards.
• Participated in the analysis, design, and implementation of sales and inventory control system for consumer electronics retailer. Lead projects, trained and advised team members.
• Discussed problems and needs with users; defined functional requirements; designed reports, displays, data structures and programs; designed and developed interactive user interfaces; tested software; wrote documentation; trained users.
• Analyzed and maintained business applications including accounts receivable, accounts payable, sales order processing, and sales commissions for electrical components manufacturer.
• Wrote and maintained software that calculated personal income taxes for tax preparers.
• Provided phone support to customers.