Senior Functional Analyst Resume
Bellevue, WA
SUMMARY:
- Strong SQL developer (T - SQL, triggers, views, tables, modeling)
- SDLC (all project phases, strong requirements, strong agile dev)
- Multi-tasker (project management, project reporting, project priorities)
- Passionate Developer (instructor of software dev, graduate degree Information Systems, volunteer web dev)
- Advanced Project Management
- Managing Management Time
- Counselor Selling
- Strategic Selling
- Bosworth Solution Selling
PROFESSIONAL EXPERIENCE:
Senior Functional Analyst
Confidential, Bellevue WA
Responsibilities:
- Analyze Business Requirements including process and data process
- Analyze Data Sources for Enterprise Retail and Supply Chain Operations
- Prepare data models for reporting solution
- Prepare sample (mock) reporting layouts
Manager
Confidential
Responsibilities:
- Technical Program Manager for financial data transactions for data quality and data assurance
- The project featured Technical Data analysis for Outbound Royalties paid to gaming partners / publishers
- Analyze business transactions for contract compliance using PowerBI, SQL Server
- Prepare business reports for correcting data quality issues. Reports on SharePoint 2013.
- Analyze business process and data process for online gaming and royalty payments
- Prepare Auditor reports for contract compliance
Program Manager
Confidential, Redmond WA
Responsibilities:
- Office 365 Enterprise Exchange Server is responsible for hosting Cloud managed services for premier clients. Change and Configuration Management services are contractual agreements. Program Manager for Standard configuration services are defined as Service Level Agreements.
- The project featured building a database for tracking SLA performance/ metrics.
- Services were provided using SharePoint 2013, SQL Server, Excel and Access
- The project was completed on time and on budget, resulted in management SLA metric report.
Senior Functional Analyst
Confidential, Bellevue WA
Responsibilities:
- Analyze Business Requirements for commission system enhancements Visio UML
- Author Functional System Design and Unit Test Plan using Quality Center
- Project manage monthly commission system deployment for dealer commissions
Program Manager
Confidential, Redmond WA
Responsibilities:
- Gather Business requirements for client reporting users
- Deployed custom ASP.NET web site to corporate data center ( Corp net)
- Design, Develop and Maintain SSRS Standards Reports
- Design, Develop and Maintain custom web site XML/ Javascript Standards benchmarking tool
- Design, Develop and Maintain custom SharePoint reporting application
- SQL 2008 used for relational database development. SSRS and XML used for data reporting.
Technical Program Manager
Confidential, Redmond WA
Responsibilities:
- The project was completed on time and on budget, resulted in improved automated ETL processing, including reduced ETL re-statement time.Database/.NET DeveloperMicrosoft, AWS, on contract (EXCEL DATA), Redmond WA Manager: Robert Ashby
- Confidential Office On-Line is a web site providing support content. Web analytics was used to gain insights on the effectiveness of the content.
- The project featured ETL and web analytics to build a large data warehouse.
- Services were provided using SSIS, SharePoint, Access and EXCEL Power Pivot.
- Analyze and document business requirements for ETL process and scorecard Visio UML
- Responsible for design, code and build data warehouse to support MS Office on-line scorecard reporting solution, web analytics.
- Responsible for developing SQL Server Integration Services (SSIS) solution to transform data from Webtrends into reporting scorecards.
Program Manager
Confidential Redmond WA
Responsibilities:
- Technical Program manager for large scale business requirements.
- Responsible for gathering business requirements for network operations. Interact with Network Operations and NIS architecture, project managers and product managers for capturing business requirements.
- Responsible for national software development project initiation, evaluating business systems and budget plans. Visio UML
- Tools used: Oracle, Confidential SharePoint, MS Excel Pivot Tables, Business Objects
Program Manager
Confidential, Redmond WA
Responsibilities:
- Technical Program manager for Responsible for MSN advertising business reporting.
- Face to face Interaction with Technical Account Managers for gathering requirements
- Analyze, Design, Build, and Test custom performance reports, using Confidential SQL Server 2005, Excel 2007, and SharePoint.
- Tools used: T-SQL (stored procedure), MS Excel Pivot Tables, SharePoint
Co-facilitator
Confidential, Seattle WA
Responsibilities:
- Responsible for college graduates in enterprise consulting, using Confidential ASP.NET. Visio UML
- Active participation in simulated consulting assignment, learning about customer relations and the art of consulting.
Database Consultant
Confidential, Seattle, WA
Responsibilities:
- Responsible for first-level customer support in Western Region.
- Supported desktop application and web application for Customer Relationship Management. MS Project
- Responsible for hands-on supporting: Transact-SQL stored procedure, SQL Server 2005, Crystal Reports, SharePoint, MS Office, data conversion.
Senior Analyst Confidential
Confidential, Bothell, WA
Responsibilities:
- Responsible for administering IT program. MS Project
- Manage courseware to for role-based program related to software development life cycle (SDLC). Visio UML
- Responsible for internal Intranet web application for IT Methods and Processes.
- Hands-on Tools used: Oracle, HTML, SharePoint, MS Project, LiveMeeting, and MS Office.
Military Officer
Confidential
Responsibilities:
- Responsible for command and control systems development, plans, and programs.
- Taught Introduction to Programming, Structured Programming, and various languages.
- Managed application development resulting in tactical command and control system.
- Recognized for superior performance with two Air Force Commendation Medals.