Management Software Engineer

Grace Ge

Cell: 503-***-**** ***** Oak Meadow Lane,

Email: ********@*****.*** Lake Oswego, Oregon 97034

Executive Summary

Innovative, passionate, and solutions-oriented IT Manager who drives initiatives focused on

increasing project efficiency. Motivates and energizes small to large-scale teams of 4 to 40+ employees through numerous software development projects while adhering to stringent

deadlines.

Key Tech Skills

BI Architect, MS SQL2012, T-SQL, ETL, SSIS, SSRS, PowerBI, SSAS, Tableau, Crystal, C#, JavaScript, Java, C++, Microsoft Dynamics, Real Page, SAP, SharePoint 2010 and 2013 Designer

Experience

2014. 4- Present Holiday Retirement Lake Oswego OR

Software Engineer Manager – BI and SharePoint Team

Manage team of 4 developers who support BI and SharePoint applications used by 13000 users across the company.

Working with vendors to migrate 60 production servers to Azure environment.

Manage BI projects from inception to delivery, which includes 150+ reports and KPI dashboards to operations, FP&A, sales and marketing management teams as well as executive teams.

Lead the BI team automation of 80+ manual reports, which saved the company 230+ man hours a month.

Worked with the executive team to design the Holiday reporting road map and establish the data management strategy across the company.

Architected and streamlined processes to establish a centralize data center in order to accept data from different sources such as CRM, JDE, Yardi, vendor provided flat/csv files, website data extracts by using different ETL tools and big data technology. Enabled real time reporting and data mining practice.

Additionally, worked with IT infrastructure team set up a disaster recovery process to minimize risks.

Lead SharePoint team develop and maintain SharePoint solutions in office 365/ SharePoint online environment to enable knowledge sharing among headquarter and divisions. Additionally, designed work flows to streamline business processes for maintenance, dining and hospitality departments.

Manage hardware and software license budgets, deliver annual reviews to team members, and coach team members.

Host training sessions from 30 to 900 people across the company on best practices of usage of SharePoint and BI.

Documented administration process for on-call procedures, test plans, data management strategies, coding standards, etc.

2012.4 – 2014.4 Epiq Systems Beaverton, OR

Manager - Data Services

Manage 3 team leads, 25+ data analysts and 12 business analysts. My responsibilities include hiring and firing, business planning, infrastructure planning; creating and implementing data architect roadmaps; resource management, performance managing, risk management, disaster recovery management, change management and budget management. Also work closely with executive team to set up company’s enterprise data management strategy.

Manage day to day operations using both waterfall and agile methodologies in a fast paced environment. Solve day to day production issues, prioritize projects, and coordinate efforts among IT, DBA, different development and business groups to meet difficult deadlines during critical project phases. Average manage 120+ cases per month, including 7 billion dollar case

Lead several year-long key process improvement projects. I am a key player and decision maker on company and department wide strategy decisions regarding department restructure and creating new business model processes to meet dynamically changed marketing environment.

Work with external vendors and internal customers to create and implement process improvements to increase operational efficiency, reduce development time and minimize risks.

Research, evaluate and provide recommendations on IT and Data Modeling tools, project management tools for the organization. Giving recommendation for DBA team and software team on hardware resource and IT configurations on clustered environment.

Initiate change management process to the organization, set up process to approve risky requirement changes. Schedule cross function group lessons learned meetings to call out risks in order to avoid production issues. Ensuring underline team leads and team members to use strong positive two-way communications methodology during solving conflict situations

Give recommendation to software engineer group on how to reach top performance for critical projects. Provide final solutions to solve complex technique issues among different development teams.

Create measurement strategy to evaluate team members and project in an ethical principle. This includes executing post mortems and following recommendations to ensure continuous improvement to policies, processes and performance.

Provide daily reports and project plan using Microsoft Project Management tools

Help HR and management to solve personnel issues for team members

Coordinate IT and Internal Audit on different government and industry regulations

Initiate and Implemented Change Management Process among different functional groups

2011.7 – 2012.4 Huron Consulting (Consultant) Lake Oswego, OR

Senior BI Developer

Plan development cycle with Project Managers in Agile development environment. Using TFS team foundation system set up PBIs, SBIs.

Collect requirements from different stakeholders and distribute knowledge to junior developers.

Design and implemented multidimensional Hospital Process BI System in SQL 2008 environment.

Design and implemented ETL system to load daily files from Hospital

Execute Performance Tuning to improve production BI system.

Train and perform design and code review for Junior Developers.

Create testing data for stress test environment.

Work with build engineers to improve build system.

2005.8 – 2011.6 Vesta Corporation Portland, OR

Lead Database / BI Developer

Setup and developed strategy, design and implementations for OLTP and OLAP databases, and guided junior team members through business and modeling problems.

Key Projects and Achievements:

Design and implemented multidimensional financial reporting Data Mart for Finance Department to publish accurate income statement and balance sheet.

Design and implemented cash consolidation relational database back office application for Accounting Department using SSIS to process AR/AP files.

Design and developed an efficient and stable ETL model using SSIS 2008 for publishing corporate financial reporting that was delivered via SSRS and crystal report.

Collect requirement and provide ad-hoc analytics support to senior management, sales

marketing and operations departments.

Design and implemented a SSRS reporting system for sale and marketing Department of Europe division to monitor key sales and daily operation performance

Design and implemented a SQL Server 2005 OLTP database architecture to track the entire lifecycle of IVR call paths.

Design and implemented an OLAP solution to analyze customer call trends. Used SQL 2005 SSIS to accomplish ETL process, including import and transformation of aggregate transaction data from OLTP to OLAP system. Provide a near real time reporting systems to assistant quick business decision making process. Also used MDX to query data from the data warehouse cube.

Crafted Vesta’s first partition solution to successfully improve the system performance in both the OLTP and the OLAP sides for IVR CRM system.

Built a centralized backend repository data warehouse to help business make informed decisions. Worked with all levels of the organization, from sales & marketing department to account managers to executives, to refine the requirements and define the development strategy while helping coordinate team efforts in a variety of geographic locations.

Authored a series of best practice documents for ETL processes and multidimensional data warehouse design for the organization. Mentored team members in architecting solutions with an emphasis on building simple, self-healing and easy-to-maintain processes. Weighed a diverse range of opinions to derive the best solution for the organization and drove it to completion.

Worked with the DBA team to set up measures and solutions to improve database performance as well as setting up appropriate backup and maintenance plans. Additionally, I participate a five-node clustering solution for migrating to clustered database architecture for disaster recovery.

Worked with the application developer group and the revenue assurance department to implement Vesta’s universal fraud warning systems (UFA).

Helped to setup and refine a process to create an integration group to combine code from different engineering departments before QA efforts were needed.

2005 Certegy Inc Portland, OR

Software Engineer (Contract)

Implemented an e-Banking, e-Payment System for Credit Unions and Community Bank using SQL 2000, DTS, JDBC, and Java.

2003 – 2004 ACS (Affiliated Computer Services) Inc. Beaverton, OR

Software Engineer

Design and implemented an inventory RFID tracking system with the goal of achieving high performance, flexibility, and robustness in their operations and supply chain management.

Participated in CMM/CMMI software process improvement cycles.

1998-2000 ABB Ltd., China Beijing, China

Project Lead

Created processes to improve the company’s ERP process in order to reduce production and delivery cycles.

Worked with internal and external customers to execute on contracts.

Led area marketing and sales personnel to accomplish bidding activities on a number of

billion dollar government contracts.

1995-1998 Siemens Ltd., China Beijing, China

Project Coordinator

Coordinated processes between Siemens’s German headquarters and local joint ventures. Corresponded with internal and external customers to collect requirements, resolve issues, and negotiate contracts.

Responsible for training new team members

Maintained accounting records in an Oracle database.

Education

MBA 2008-2010 Sarasota, Florida

Argosy University

Focus on Finance Management with 4.0 GPA

Master Degree in Computer Science 2002-2004 Beaverton, OR

OGI School of Science & Engineering at OHSU

Focus on database and HCI (Human Computer Interaction).

PMP Project Management and ITIL Training

Management Trainings on Labor law (2013) and Positive management.

Management Trainings on How to Excel supervising People by Skill Path.

Management Trainings For Technique Presentations

HIPPA Trainings in 2012 and 2013

Honors: Mentor Graphics Foundation Scholarship, Sept 2003

Contact this candidate