Shuyi Yang, M.B.A Email & Phone Number

Norwalk, Connecticut, Us

Provide architectural leadership and project support for a broad range of complex IT development projects. Design effective and sustainable architecture solution and draft creative design to solve problems. Oversee performance, quality and data integrity of applications. Support data analysis for projects and business users. Doing capacity planning for database growth. Define solution, provide guideline and direction for development and production support teams. Collaborate with inter-department teams to ensure satisfactory solution for business. Managing the architecture activities. Evaluating IT tools and provide recommendation.Technical background: Oracle 12c, Actian Columnar database, JBoss SOA architecture, Oracle Siebel, Xerox home grown software, Mainframe, Visio MS Project, Toad, Pl/Sql developer

Rochester, New York, Us

Act as the president for APEX, a Kodak employee network, set vision and strategy for the organziation, work w/ board of directors. Leading activities, monitoring progress and measuring deliverables. Managing budget and work w/ peer networks on collaborated events.Co-chaired Asian Pacific American Leadership Development Program with United Way of Rochester

Rochester, New York, Us

Lead Business Intelligence project implementation allowing business users spot opportunities to increase revenue; reducing cost of goods sold as well as understanding Kodak’s customers better. Work with business user to collect requirement; Design, scope the project and write up project rollout plan; Set up project delivery schedule and executing the project. Spot opportunity to drive business process improvement; driving for data quality and project integration and process simplification. Worked as a project technical lead, coordinate with offshore vendor and outsourcing team on Business Intelligence application implementation. Responsible for design, architect solution. Manage project implementation and schedule. Data modeling for Business Intelligence project; Lead Technical implementation for BI project. Being the design steward for business intelligence application. Create functional spec, work with development team to ensure satisfactory delivery.Technical Background: Oracle 11i, Sql Server, MS BI stack, SSAS, SSIS, SSRS, BO XI, Webi, VSS, Microsoft Project, Adobe Professional, ProClarity, ER/Studio

Rochester, New York, Us

Lead database development team to provide reliable and accurate information through out company-wide and external customers; Monitor completion of project; Lead project and coordinate between business liaison including project scoping; Estimate and risk analysis; Disaster recovery plan; Project implementation plan and rollout; Plan production release; Plan database capacity; database design solutions; provide performance tuning; trouble shooting production problem, provide database operation support for system expansion and integration; Architect and plan new release rollout. Re-engineering process to provide faster performance and better presentation. Coordinate inter-department projects; Project planning and budgeting. Mentoring team member for development, code review and best solution design. Lead technical implementation for Business Intelligence application P1677, Phase III, EPS.Technical Background: Oracle 10g, Pl/SQL developer, Trigger, PL/SQL, Loader, Oracle Enterprise Manager Console , Clearcase, Oracle GRID, ERWIN, ER/Studio, Visio

Co-chaired Asian Pacific American Leadership Development Program with United Way of RochesterChairing Asian Pacific Heritage Celebration event, committee member of Leadership Conference, advisory board of Memorial Art Gallery's Asian Family Day, Rochester Area Network Committee for Summer Picnic.

Rochester, Ny, Us

Provide inputs on designing the knowledge management solution for medical device manufacturer. Responsibility includes management presentation, design and develop go forward strategy and roadmap, engaging with business to understand needs and requirements, solution and methodology drafting, process flow visualization for knowledge management, creating templates for architect diagram, functional specification, interview workshop, data dictionary, recommend standard, provide architectural guidance, promote best practice, research Big data and MDM technology and solutions; competitor research and analysis, tool evaluation and assessment, promote Data Governance process and standard

Norwalk, Connecticut, Us

Lead the developers on the Xerox Fenix 11.5.9 ERP implementation by architecting an overall solution for Mexico business requirements using the Oracle application, COTS and interfaces; Provided guidance and best practices approach for business process design; Re-engineering process for better solution; Ensure Sarbane Oxley (SOX) compliance; Configuration and set up; Design and analyze requirements; Interact and communicate with Mexico users for requirements, enhancements and issues; Troubleshooting production problem and finding interim solution while waiting for solution from Oracle. Create TAR and interact with Oracle supports; Scope development effort for change controls; Involve in setup user account and securities; Act as the focal point for development issues, concerns, and support; Lead Design Reviews and Peer Reviews; Ensure code compliance with XEROX standards and adherence to the architecture solution plan; Design and develop code to meet requirements Plan/lead development system integrated tests; Inspect execution of development unit test plans; Performed functional analysis; Support functional activities, integrated, and volume testing; Research/create/maintain project tools; Advise the project team on environment sourcing strategies; Mentor new staff; Manage and track Change Control Requests(CCR); Negotiating on project scope and timeline. Use MS Project for project planning. Follow through project tasks and make sure delivery and user satisfaction is met.Technical Background: Oracle 9I, TOAD, Oracle Financial Apps 11.5.9, GL, AP, AR, Order Management, Workflow, Alert Manager, Reports 6i, Forms6i, Trigger, PL/SQL, Loader, UNIX, SCCS, Remedy

Norwalk, Connecticut, Us

data modeling, architect and design new project

Client: Wake County Public School System, Raleigh, NC Using reengineering process to redesign the web reporting interface and the data base. Gather the business requirement; perform data analysis and database architecture design. Write codes and perform test using Oracle tools and Cold fusion. Use PVCS for version control and code move.Technical Background: Oracle 8ITOAD, Reports 6i, Trigger, PL/SQL, Loader, Cold Fusion, PVCS, UNIX, Java script, AWK, PVCS

Client: Genencor International Inc, Rochester, NYProvide solution to client's need. Interact with clients, gather requirements, deliver specification and customer satisfaction assurance. Provide production support and functional analysis. Worked on PO, Inventory, BOM, Shipping modules. Create/modified customized Oracle reports. Help on Oracle manufacturing 11.5.7 upgrade from 11.5.5. Identify and map tables from Oracle OPM to Oracle manufacturing 11.5.7. Work on Oracle Distribution and Supply Chain 11.5.7. Develop and testing programs. Others include troubleshooting, performance tuning.Technical Background: Oracle 8ITOAD, Oracle Manufacturing 11.5.7, Reports 6i, Trigger, PL/SQL, Loader, Oracle Manufacturing 11.5.3, 11.5.7 PO, Inventory, BOM, Shipping, UNIX

Rochester, Ny, Us

Managed database application projects and implement business solution for the Human Resources and Finance Department through out complete software life cycle. Create TAR and interact with Oracle supports. Design, enhance and provide production support for PO, AP, GL, HRMS, FSG modules for 10.7nca and 11.5.3. Upgrade an Oracle Financial 10.7 based system to Oracle Financial 11i. Led all major technical activities such as customization, interface specification and quality.Technical Background: Oracle 8I, shell scripts, UNIX, Window 98, TOAD, Oracle Financial 10.7nca, Oracle Financial 11i, PO, AP, GL, HRMS, CE, MS, FSG, Project, Forms4.5, Forms 6i, Reports 4.5, Reports 6i, Trigger, PL/SQL, Loader

Norwalk, Connecticut, Us

As a development team leader for Market Customer Knowledge Base (MCKB) data warehouse for Xerox. Work with upper level management regarding open issues, gathering requirements from users. Interact with client and gather requirements. Involved in architecture design, coding and manage the work team. Provided assistance to QA group for a smooth transition. Others include debugging, system enhancement, unit testing and training team members.Technical Background: Oracle 8i, shell scripts, UNIX, NT, docushare, TOAD, VSS, ERWIN, MS PROJECT, MS TEAM MANAGER, Razor web project tracking tool

Worked in customization area for Vibrant Solutions Inc, the leading software maker in Bill consolidation for telecommunication industry. Tasks include analyzing data, re-engineering the software work flow, writing software design specification, PL/SQL, communication with software tester for quality assurance, building package and release, system enhancement and debugging. Tools used include Sybase, SQL builder, shell scripts, PERL to produce account payable feed to world class clients.Technical Background: Sybase, Oracle 8i, SQL builder, SQL advantage, PERL, shell scripts, UNIX, NT, Lotus notes

Rochester, New York, Us

Served in KODAK KWWIC/ERP unit. Tasks include database design, analyzing data, writing control files, PL/SQL, form, database triggers, data loading and debugging. Implement user interface using Oracle Developer 2000 Form 4.5 and Report 2.5. Design/implement on upgrading Oracle form 6.0 from Form 4.5. Lead the project for migrating 450 users from using mainframe SNA interfaces to UNIX. Coordinate with ERP tech team to make sure the transaction is smooth and completed. Interact with users for system enhancement and migrations. Providing direction and helping new team members. Others include hotline call, troubleshooting and PC configuration.Technical Background: Oracle 7.2, Oracle Developer 2000 Form 4.5, Report 2.5, NT, UNIX, Lotus notes, MS, SQL 3.1, MQ series, Vantive, Oracle 7.3, IBM MQ Series, Oracle Form 6.0

Norwalk, Connecticut, Us

Worked in XEROX global solution delivery group. Use web tools, ERWIN, Oracle tool to develop information directory project, which establishes a metadata repository for XEROX business users and developers. Helping client on information searching, tool searching and evaluation, contacting vendors, gathering user requirements, data model design and project development, etc. Others include designing on Payroll /Benefit Data Warehouse and writing PL/SQL code.Technical Background: Oracle 7.3 , MS MAIL, MS Exchange, UNIX, Office 98, ERWIN 3.5, SQL, Netscape communicator, MS project 97, Visio 5.0, XEROX docusahre

Rochester, New York, Us

Used JAVA and Oracle to develop Internet Dealer Locator project to meet critical mission for maintaining KODAK's competitive advantage. Gather business and users' requirements. Use Visual cafe, HTML to develop the web page. Search for software vendors and participate in making purchase decision. Other Tasks include data analysis, data model design using ERWIN 2.0, creating views, and writing PL/SQL packages on UNIX-based Oracle server. Technical Background: Oracle 7.2, Visual Cafe, JDK, Lotus notes, UNIX, Office 97, ERWIN 2.0, SQL, Netscape communicator.

Rochester, New York, Us

Worked on Account Receivable project, Order Tracking System application and Point of Sale project. Tasks include communicating with users, database design, analyzing data, writing control files, PL/SQL packages on UNIX Oracle Server, data loading, testing. Implement front-end user interface using Oracle Developer 2000 Form 4.5 and technical document writing. Assisted migration of cron jobs to SQL Operator. Wrote Excel VBA codes to customize the financial reports for CI customers. Technical Background: Oracle 7.2, Oracle Developer 2000 Form 4.5, Window workgroup, UNIX, Lotus notes, MS Office 4.3, ERWIN 2.0, SQL OPERATOR, Window NT 4.0, SQL 3.1, Excel VBA

Us

Enhanced Xerox internal user application used by the technical reps on the fields. Tasks include coding, communicate with end-user, identify user's requirements, debugging existing codes, updating help files, setup new release and evaluating software. Technical Background: Oracle 7.0, C++, OWL, MS Office 4.3, E-MAIL, Window 3.11 , NOVELL, ROBOHELP, UNIX

Us

Investigate the system structure and use re-engineering technology to redesign XEROX account payable computer process. Transplant the system from Mainframe to Client/Server platform through out development life cycle. Using ACCESS 2.0 and VISUAL BASIC 3.0 and Window API and Oracle 7.0 to develop the project. Modifying company assessment application in ACCESS 2.0. Communicate with client, define business requirements. Design, Analyze system and database architectures. Coordinate the project with others, and assign tasks to co-workers. Write technical documents. Doing Quality Assurance, ensure customer's satisfaction. Technical Background: Oracle 7.0, ACCESS 2.0, Visual Basic 3.0 Professional, Window API, MS Office 4.3, E-MAIL, Window 3.11 , NOVELL LAN 3.12, , IBM IMS, Chameleon, FTP, Netscape, Winsock., HTML

Contributed as a programmer in the area of Finance, Accounting, Human Resources, and Collections for Albany, Buffalo, Rochester internal clients. Main tasks include project development involving the full cycle of application development by using ACCESS, program modifications, report development of billing and POS system, and documentation. Using SQLASSIST, REPORT WRITER, ISQL, IQ, Embedded SQL, C, AWK, EXCEL, ACCESS on UNIX and PC platform to perform tasks. Technical Background: Window 3.11 , NOVELL 3.12, HP 9000, UNIX, AWK, SED, Database, Report Writer, ISQL, Embedded SQL/C, EXCEL, ACCESS, MS Office

Us

Served over 1500 end users on 22 NOVELL LANs. Main tasks include supervising the networks, establishing and modifying Ids, Troubleshooting E-MAIL system, Windows, and LANs problems, installed, upgraded and performed maintenance on file servers, and Synoptic Ethernet management. Others include user menu and network bulletin board editing and maintenance. Worked closely with Help Desk to identify end users' problems. Technical Background: NOVELL 3.12, Windows 3.1, MS Word, Excel

Worked at Finance Bureau, Taipei City Government. Involved in two major projects : as part of a five member team, coded and maintained Personnel System in DBASE III; as part of twelve people group, programmed and documented Accounting System in COBOL. Technical Background: Tandem Non-stop, PC, Window 3.x, Dbase III, COBOL

Education record

Education record

Education record

Diploma, Computer Science

Ms, Computer Science (Concentration In Artificial Intelligenance, Neural Network And Optiimzation)

Mba, Computer Information System And Entrepreneurship