We provide IT Staff Augmentation Services!

Network Engineer And Data Reporting Analyst  Resume

Portland, OregoN

EXPERIENCE

Information Analyst 

Confidential, Portland, Oregon

  • Contract work with Standard Insurance Corporate Financial Services in Portland, Oregon
  • Assisted with testing upgrade of Windows XP and Office 2007 to Windows 7 and Office 2013.
  • Converted complex financial and accounting spreadsheets from Excel 2007 and Oracle Essbase to Excel 2013 and Oracle SmartView.
  • Analyzed and modified Excel VBA and macros in spreadsheets for Excel 2013 and SmartView.
  • Created custom menus and add - ins for Excel 2013.
  • Assisted users in re-design of spreadsheets as part of upgrade to Excel 2013 and SmartView.
  • Developed new procedures for analyzing data with Excel and SmartView.
  • Developed and implemented new testing procedures for conversion of spreadsheets.
  • Created SharePoint Wiki Pages for technical documents.

Access Developer

Confidential, Portland, Oregon

  • Contract work with Karcher North America in Camas, Washington
  • Developed custom reports in MS Access
  • Created macros to export Access reports to Excel worksheets
  • Set up security for Access database

Programmer Analyst

Confidential , Portland, Oregon

  • Contract work at Omega-Morgan, a construction company in Hillsboro, Oregon
  • Modified intranet web pages to allow for tracking of jobs. Web pages developed on VB.NET and Visual Studio 2012 with Team Foundation Server.
  • Created new and modified existing reports using Crystal Reports in VB.NET and SAP Business One. Reports were for Job Analysis, Job Costing, Resource Tracking, and A/R Invoicing.
  • Created new Purchase Requisition form in Excel using VBA and Macros.
  • Used Adobe Acrobat to modify Excel Purchase Requisition form for use on Apple iPads.

Software Developer

Confidential , Portland, Oregon

  • Contract work at Nike, Inc. in Beaverton, Oregon
  • Duties included designing, coding and implementing Excel VBA solutions for tracking manufacturing methods to improve sustainability and reduce environmental impact
  • Developed software for Nike equipment, Hurley apparel and Converse footwear divisions
  • Software design including
    • User Interface Design
    • Data and Process Flow Design
    • Security and User Access Design
    • Report Design
    • Client/Server Data Transfer Design
  • Experienced in full cycle software development including analysis, design, development, testing and implementation
  • Developed custom reports using SQL Server Reporting Systems
  • Developed report layouts to be included in .NET web pages
  • Extracted data with Transact SQL using
  • Query optimization
  • View creation
  • Aggregation
  • Functions and Stored Procedures
  • Creating temporary tables
  • Unions and Joins
  • Assisted with release planning and management
  • Documented the solutions from both an end-user and technical perspective
  • Worked with system personnel to implement design and participate in development of project plan/timeline
  • Analyzed and resolved complex technical business issues and problems
  • Participated in and provided technical leadership
  • Ensured interpretability of integrated applications or components including considerations for performance, serviceability, usability and maintainability. Evaluated quality and reliability of performance data
  • Worked with Senior Business Analysts and Product Developers to collect data and define specifications for new applications
  • Used Agile Project Methodology for project management

Network Engineer and Data Reporting Analyst 

Confidential , Portland, Oregon

  • Used Oracle T-SQL commands, Microsoft Access, and Microsoft Excel to collect, analyze, and report data
  • Used HTML to modify web pages to create ad-hoc reports
  • Developed methodology for collecting data on network equipment
  • Helped develop best practices and benchmarks for network performance
  • Installed, upgraded, and maintained network management applications
  • Supported end-users of network management applications
  • Performed root cause analysis of network problems
 

SKILLS

  • MS Office
  • MS Access
  • MS Excel
  • MS Visio
  • MS Project
  • Oracle Essbase
  • Oracle SmartView
  • User Interfaces
  • Financial Analysis
  • Statistical Analysis
  • What-if Analysis
  • Pivot Tables
  • Macros
  • VBA
  • SQL Server Management Studio
  • T-SQL
  • Crystal Reports
  • SAP Business One
  • Adobe Acrobat
  • Agile Project Management
  • Team Foundation
  • Server
  • HP Application Lifecycle Management
  • Quality Control
  • SQL Server Reporting Service and BIDS
  • Creating and Modifying Stored Procedures
  • Creating sophisticated T-SQL queries for selecting, updating and deleting data using multiple joins.
  • Light DB architecture - tables, data types, primary keys, foreign keys, indexing and query performance tuning.

Hire Now