SUMMARY

• Manufacturing
• Consumer Products
• Logistics
• Internet
• Sales and Customer Service
• Engineering and Product lifecycle
• Purchasing and inventory management
• Accounting and Finance
• Supply chain and Logistics
• Planning and execution
• Business systems analyst
• Application Architect /Developer
• Database Architect / Developer
• Report platform architect
• System integration developer
• Report developer
• Office automation developer
• Requirements solicitation and consolidation
• Use case scenario development meeting and workshop coordination and facilitation
• Analysis and mapping of business processes and workflows i.e. "as is" and "to be"
• Documentation of functional and technical requirements as well as change management
• User interface and application flow system integration
• Relational and others database formats; small and large scale
• Data warehouse, mart and cubes
• Reporting platform architecture reverse engineering of Database designs, SQL and application code

TECHNICAL SKILLS

Operating systems: Microsoft Windows through version 8.0

Office Products: Microsoft Outlook, Excel, Project, Visio, Word, Messenger, Net Meeting, PowerPoint

Programming: Visual Basic, VBA, C, Powerbuilder, ABAP

Internet: HTML, ASP, ODBC, JSP, Javascript, CSS, MS IIS, PHP

Databases/Business Intel.: Oracle, Sybase, SQL Server, MYSQL, Access, SAP BI, Cognos, Hyperion, BI Publisher, Business Objects, Web Intelligence, Crystal reports, SSRS, SSMS, Visual studio

ERP: SAP 3.1h, 4.6D, ECC 5.0, Oracle Apps w/ Noetix, Microsoft Dynamics GP

Computer assisted drafting (CAD): Autocad R9 through R14

Computer assisted machining (CAM): GIBBS, Bobcad and G - code programming

Small business: QuickBooks

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Supporting implementation of the Enterprise Business Intelligence Platform and analytic requirements related to Human Resources, Finance, Supply Chain, Capital Projects and Asset management
• Contributing to Process development related to planning, requirements, design, agile delivery, testing, functional and technical artifacts and change management
• Helping in aligning agile delivery support systems wif agile processes and business strategies
• Contributing to strategies around agile delivery and continuous improvement

Confidential

Financial Systems Analyst

Responsibilities:

• Worked closely wif the company's financial controller to turn concepts into tested enhancements of the project budget planning system that allowed internal departments and external contracting partners to maintain planned project energy savings estimations against project cost budgets. The system had multiple source integration points such as cost center master data and historical, aggregated actuals from the FI system and project transactional information and master data from operational systems. Outputs were fed into the data warehouse.
• Gatheird requirements and wrote BI reports that showed trends in energy project savings against different sectors and providers such as electric, natural gas and renewable energies wif dimensions by geography and time, and measures such as planned and actual avg. kilowatt, Megawatt and Therms consumed.
• Performed analysis, documented, created and/or modified various accounting reports related to vendor accounts payable and 1099 reporting.
• Enhanced existing and created new auditing reports that validated energy project legitimacy and accuracy based on the companies compliance manager's requirements. I also wrote ad-hoc audit queries providing site energy usages wifin jurisdictions of providers such as PGE, Clark County PUD, NW Natural and CNG.
• Reverse engineered, fixed defects and enhanced the in-house document retention and destruction database and reporting front end, integrating wif operational and internal databases, network directories, user spreadsheets and SharePoint lists
• Fixed defects and enhanced the company's payroll timesheet entry and payroll allocation systems.
• Prototyped from concept, to model, to operational wireframe for a company time entry workflow system using office and SharePoint automation and integration

Confidential, Beaverton, Oregon

Business Systems Analyst

Responsibilities:

• Modeled a prototype planning application and database schema, based on the sourcing director's concept, that allowed multi-scenario planning across multiple planning horizons, sourcing historical data from the global footwear planning data mart, and calculating forecasted footwear production quantities and material sourcing requirements based on complex formulas and user inputs
• Performed optimization and tuning analysis of data warehouse reports and dashboards, troubleshooting from the report level down to the VM and OS against Oracle database servers and working wif external technical teams and vendors. Reported statuses to manager and team
• Supported Business Intelligence applications.

Confidential - Portland, OR

Lead Report Developer and Analyst

Responsibilities:

• Implemented data ware house and operational reporting solutions utilizing Agile methodologies such as user story creation, project sizing, backlog grooming and ranking, demos to business, testing, sprint planning and execution, post evaluation and providing technical insight to assist product owners and scrum masters in balancing business priorities wif technical dependencies.
• Worked wif the business's financial stakeholders, analysts, and technical teams to gather reporting requirements, prioritize delivery and manage implementation of financial and accounting reports such as profit and loss, general ledger, Budget vs. Actuals and vendor accounts payables.
• Performed reporting platform integration and architectural duties working wif technical resources and accounting analysts to design and deliver an invoice processing metric dashboard solution integrating financial and reporting platforms that summarized KPI's such as avg. processing time per invoice and invoice count per associate per day
• Participated in development and led other developers in creation of over 20 real-time operational reports supporting international testing and go live schedules
• Wrote technical interface documentation instructing transactional application UI developer teams on web service and HTTP request integration procedures to access and retrieve reports from Oracle and Cognos reporting systems. I also assisted in testing the solutions Designed and documented reporting optimization and standardization solutions such as database views that integrated data from multiple source systems such as the global shipping transactional system and Master data databases
• Created and updated reporting requirements, created technical design documentation for database models, ETL logic and reporting specifications.

Confidential - Beaverton, Oregon

Business Systems Analyst

Responsibilities:

• Performed project management duties implementing sophisticated calculation enhancements to Confidential 's Global Footwear Planning (GFP) data mart. Such duties included coordination of external vendor DBA and developer tasks, communication of project statuses and timelines, managing stakeholder expectations and testing.
• Executed BSA duties such as business process documentation, system design documentation and analysis. Created Technical flow charts to assist wif communication to business and technical associates
• Responsible for operations support tasks such as troubleshooting data issues, modifying reports and tracking issue resolution
• Completed system integration testing of data feed accuracy into the GFP data mart during source system implementations and upgrades

Confidential, Hillsboro, OR

Business Intelligence Analyst and developer

Responsibilities:

• Responsible for the creation and automation of executive level reporting dashboards that showed KPI's such as customer service performance trends, customer satisfaction levels, cost per incident averages
• Provided product marketing stakeholders wif multiple graphing concepts, visualizing trends in customer engagement and product adoption across different consumer demographics based on historical data sourced from data warehouse and operational systems
• Created design documentation and user training manuals for ongoing system maintenance

Confidential - Islandia, NY

Business Intelligence Analyst/Contractor

Responsibilities:

• Analyzed companies BI solutions related to customer asset management and software solution deployments, updated requirements, provided proposal presentations to management and suggested ways of expanding reporting capabilities including data warehouse architectural design changes
• Worked closely wif stakeholders to implement management project dashboards using SAP BI and intranet portals that displayed metrics reflecting project statuses, actual and planned savings and revenue trends. Charts and graphs had drill down and drill through capabilities down to the individual project detail as well as row level security restricting access in both geographical and organizations cross sections
• Identified opportunities and implemented measures to increase performance of critical reports.
• Wrote functional and technical specification for the BI senior architects and developers.
• Led and mentored junior developers

Confidential - Kalama, WA

Business Systems Analyst

Responsibilities:

• Performed configuration, troubleshooting, user support and training of production planning related functionality in the companies SAP ERP and Shop floor execution systems.
• Designed, documented and implemented backend data tables and extractors for SAP Business Warehouse content and presentation mediums.
• Won management support to design and build web based dashboard exception reports to assist users in removing issues before each month and year end financial closing periods.
• Assisted finance and accounting stakeholders in tracking accounting anomalies, reversing and redeploying transactions on a mass scale using scripting tools.

Confidential - Gresham, OR

Owner and Operator

Responsibilities:

• Performed duties related to quotations, sales, purchasing, payroll, taxes, and accounts receivable and payable.
• Managed employees related to sales, office and manufacturing departments.
• Supported business systems for the office and manufacturing facility.
• Programmed automated machining centers using drafting and machining software.

Confidential, Piscataway, NJ

Business Systems Analyst

Responsibilities:

• As co team lead of production planning (PP) and product costing (PC) teams, I performed analysis, requirements gathering, specification writing, data scrubbing imports from legacy systems, configuration, application testing and end user training through implementation and upgrades cycles of SAP ERP. I was responsible for system configuration, reporting statuses to stakeholders and managing implementation schedules in Microsoft project.
• Utilized Lean manufacturing experience to enforce conformity of system design to company's lean mfg. standards.
• Built and managed an implementation portal to track and share SAP implementation documentation and issue management correspondences. Trained entire SAP team on web publishing.
• Integrated SAP PP modules wif external production planning applications
• Converted Legacy client server sales quotation applications to flexible web distributed apps
• Worked wif mfg. facilities to design and implement custom integration solutions between SAP and manufacturing execution systems synchronizing production quantities and inventory back flushing.
• Acted as technical project manager for the company's business to business distributer's website. In this role I met wif distributer's in the field, and brought back technical requirements to make the site more accessible and useable. I also managed gathering and loading material content.
• Successfully oversaw the Implemented of a custom, Intranet distributed, project management software solution utilized by company locations in 40 countries. As project manager, I managed stake holder expectations, Hired technical resources and worked wif IT to overcome technical challenges. Stakeholders held management positions such as CFO and CMO.