SUMMARY:

• Highly organized, dedicated, and accomplished IT professional with extensive years of project management experience.
• Analyze large datasets to provide strategic direction to the company.
• Quality - focused, diligent, and solutions-driven Business Analyst, equipped with many years of diverse experience in the development and delivery of cost-effective, high-performance technology solutions and software.
• Create customer focused, business savvy, and user friendly communication as appropriate.
• Armed with hands-on experience leading all phases and aspect of various IT projects, including risk analysis, requirement gathering, business needs validation, systems design, enterprise architecture, development, training, and maintenance.
• Expert at interfacing with subject matter expert, customers and business line owners from different backgrounds and translate their requirements into functional specification documentation to development team.
• Retrieve and analyze large datasets using custom SQL queries and Excel models
• Expert MS Excel user and financial modeler able to build complex analytical models from scratch, and manipulate and analyze large datasets.
• Creative thinker and analytical problem solver, with demonstrated ability to data-mine and analyze data in support of business functions and enhance business process work flow to maximize efficiency.
• Strong working experience on Microsoft word, excel, Access, PowerPoint and Strong communications skill (oral and written)
• Skilled in manage complex and large-scale projects, from planning to execution within fast-paced, time-sensitive, and highly secured environment.

TECHNICAL SKILLS

Databases: SQL Server 2017/2014/2012/2008/2005/2000/7.0/6.5, TeraData, Oracle 10g and Microsoft Access, OLAP, OLTP, Data Analysis, Data Mining, Data Modeling and Database Design SQL, SSIS, DTS Packages, Stored Procedures, Functions, Triggers, Performance tuning

Operating System: Windows Server 2018/2013, Sun Microsystems UNIX

Data Mining Tools: Weka, Rapid Miner, Edit Distance.

Network: Configuration, implementation and administration of ISDN/DSL/TCP/IP Network switches/ Routers

Business Intelligence: Micro Strategy 7.1.4/7.2/7.2.1/7.2.2. Configuration, implementation and administration of MicroStrategy Intelligence Server and Micro Strategy Web Server

Programming: C#, ASP.NET, ASP, VBScript, JavaScript, HTML/DHTM

Reporting Tool: SQL Server Reporting Services, Crystal Report

PROFESSIONAL EXPERIENCE

Confidential, Beaverton, Oregon

Consultant

Responsibilities:

• Project managed, assists and prepare our clients in new clinic information system implementations.
• Planned data migration from different data source.
• Familiar with clinic information system such as EPIC Clinicals, Emds-Solution Series Suite, e-Clinical Works and Soapware.
• Gathering and documenting requirements, specifications, business processes and recommendations for proposed action.
• Performing quality analysis to identify course of resolutions.

Environment: Microsift SQL Server 2017, Visual Studio 2015, SQL SSIS.

Confidential, Hillsboro, Oregon

Systems Analyst

Responsibilities:

• Major contributor to the CDocs Migration project. Implementing Alfresco content management system to replace ICMTL. Assist in requirements gathering, design, data transformation, validation, testing and problem solving.
• Administrator for IBM Maximo user’s access. (EAM entitlement)
• Involved in a data transformation project to maximize the usage of the IBM Maximo maintenance modules.
• Content management for Corporate Services Circuit website using Adobe CQ.
• Content Management for EHS website using Microsoft Expression.
• Sharepoint administration for renovation planning.
• Gathering and documenting requirements, specifications, business processes and recommendations for proposed action.
• Performing quality analysis to identify course of resolutions.

Environment:Microsift SQL Server 2014, Visual Studio 2015, SQL SSIS.

Confidential, Portland, Oregon

Operations Manager

Responsibilities:

• Managing an online ordering business.
• Developed an orders assignment, scheduling, and tracking system.
• Experienced in tech-savvy with strong analytical and problem-solving skills.
• Worked, Implemented and followed a Scrum Agile development methodology in daily operations.
• Increasing the efficiency of online Marketing and Sales process through integrating Service and Identity Management with Analytics and Customer relationship Management tool.
• Gathering and documenting requirements, specifications, business processes and recommendations for proposed action.
• Performing quality analysis to identify course of resolutions.
• Responsible for analyzing the needs of the various functional business areas.
• Worked collaboratively on online ordering launch and associated marketing

Environment:Microsift SQL Server 2012, Visual Studio 2012, SQL SSIS.

Confidential, Vancouver, Washington

Business Analyst

Responsibilities:

• Project: Confidential Quotes Center:
• Involved in the business and data analysis for the re-design of Confidential Quotes Center. Interviewed with subject matter expert, users, product owners, products analysis and used various methods to gather users’ interests and requirements.
• Another important task was to perform data mining and data cleansing of the sales data of Home Depot. The metrics compiled from this exercise were used as a basis to revolutionize major changes in the Special Order Department.
• Implemented and followed a Scrum Agile development methodology within the cross functional team and acted as a liaison between the user group and the technical team.
• Involved in defining the source to target data mappings, business rules and data definitions.
• Designed and developed Data Extraction, Transformation and Loading (ETL process).
• Extensively used of SQL for accessing and manipulating database systems.
• Used UML, flow charts, data flow diagrams, state transition diagrams, use cases to document current system process to present to users and propose system process to developer for development.
• Assumed full responsibility in development/deployment of new reports in Microsoft SQL SSRS based on requirements.

Environment: .NET, Microsoft windows 2012 Servers and SQL Server 2012.

Confidential

Executive Director

Responsibilities:

• Project: IT Infrastructure and Logistics Operation: Implemented applications that supported the company’s business operation. Software Implemented was Transport Management System and Microsoft Dynamics NAV Accounting Software.
• Environment: Microsoft windows 2008 Servers and SQL Server 2008.
• Main role in the company was to overseas the entire business operation. At the same time to take care of using IT to help the business to be more effective. Fully involved in detailed study and analysis of the entire company’s operations. Identified the company’s strengths and weaknesses and suggested continuous improvement process to enhance the business processes.
• Used UML, flow charts and data flow diagrams to document the process flows.

Confidential

IT Manager

Responsibilities:

• Project: IT Infrastructure: Created an IT infrastructure to connect all offices within the entire fourhectare operations compound with fiber optics. Implemented a suite of applications that support the company’s business operation, such as central purchasing system, warehouse management system, Transport Management System, Container Management System, Microsoft Navision Accounting Software, HR Payroll System, E-Ordering System, CCTV system and Access Entry System.
• Environment: Microsoft windows 2003 and 2008 Servers. Sun Microsystems Unix OS. The data was stored in Oracle 10g and SQL Server 2003/2008.
• Main priority was to create an IT department for the company. I was leading all major projects for the company.
• Collaborated with all department heads to identify project scope, objective and vision.
• Personally involved in conducting interviews, requirements analysis, defining business process and operations requirements.
• Documented all process changes, enhancements, reviews and modifications in the manner that could easily be understood by users, managers and department heads.
• Utilized UML, dataflow diagrams, use cases and flow charts to create functional specifications for development.
• Managed all vendors and oversees the entire budgeting exercise of all IT expenditure, timeline, justifications, impacts, effectiveness and ROI analysis.
• Provided expert oversight in creating test plans, test data, test cases and performed in-depth testing to ensure quality solution for all users. Co-ordinated user reviews, developed easy to understand training materials, trainings and provide continuous support to the better use of all applications implemented.
• Assumed full responsibility in development/deployment of operations report in SQL SSRS.
• A member of the ISO IQA team and created process and procedures that met the ISO standard.

Confidential

Business Analyst

Responsibilities:

• Supporting Intel Developer Services. Microstrategy was used to generate reports for management analysis.
• Environment: MicroStrategy 7.2.1 reporting platform, which included MicroStrategy Intelligence Server, MicroStrategy Web Server and Microsoft Cluster Server. The data was stored in Oracle and SQL Server 2000.
• Actively involved in interacting with customer, gathering new requirements. Including database design, create metadata database in Microstrategy and create ETL scripts for data migration. Administration, performance tuning, migration (data and project) and implementation of Microstrategy 7.2.2. Create facts, attributes, hierarchies, prompts, filters, metric and reports.
• Provided continuous support for new reporting requirements.

SMART Financial Tools

Confidential

Responsibilities:

• SMART Financial Tools is a Decision Support System for the financial analysts.
• It was developed to provide four main key functions, create and copy user data sets, maintain data hierarchies, provide cost and revenue allocation, and import/export data from/to Excel.
• There were three technologies that were used to leveraged to accomplish this: the Excel spreadsheet Office Web Component (OWC), MicroStrategy Web/SDK, and custom ASP code.
• Environment: Developed based on the MicroStrategy 7i reporting platform. Including MicroStrategy Intelligence Server and MicroStrategy Web Server. Microstrategy SDK, MS Office Web Components, XML, XSLT, DHTML/HTML, VBScript and ASP. The data was stored in MS SQL2000.
• As a project consultant, was actively involved in the entire project life cycle of the development of this project. Main focus was to provide consultancy, analysis, design, programming and implementation.

Confidential

Data Warehouse

Responsibilities:

• This project involved extensive process analysis, data analysis and data mining to create a data warehouse for decision support. DTS packages were developed within SQL Server 7.0 and it scheduled daily downloads from the corporate data warehouse to retrieves the latest information and consolidated them into one data source.
• An intranet web application was developed to integrate demand forecast, flash (inventory), sales & distribution (SAP), and consolidate information into one single data point. It enabled the management to generate up-to-date web reports such as on demand forecast verses inventory and delinquent backlog & billings information using Microstrategy. By implementing this application, backlog is minimized and product was not over manufactured.
• Environment: Confidential Data Warehouse was developed using Microstrategy 7.1, MS SQL 7.0 DTS package, HTML, VBScript, JavaScript, Visual Interdev and ASP.
• As a project consultant, was actively involved in the initial discovery, presentation of solution, data mining, and assisted in preparation of budget and schedule of the entire development project life cycle of this project.
• Main focus was to provide consultancy, data mining, analysis, design, programming and implementation.
• Extensive use of Microstrategy Architect and Agent Objects.
• Installed and configured Microstrategy Intelligent Server.