Christopher Chen Email & Phone Number

Oak Brook, Il

Greater Chicago Area

Chicago, Il

Project Manager and Senior Developer for data-focused consulting company.• Analysis: Gathered business requirements and translated into technical specifications for client signoff. • Data Modeling: Designed and built application model in Cognos TM1 system.• Project Management: Developed project plan based on requirements and specifications, managed project budget and hours worked, tracked project tasks and progress.• ETL: Designed and authored Microsoft SSIS and Cognos TM1 jobs to populate the application model.• Research: Significant coursework and internal proof-of-concept projects for Microsoft Azure cloud, involving data modeling and lift-and-shift of virtual machines from on premise to the cloud. Tested and provided infrastructure support for internal Slack bot using node.js and PostgreSQL.• Mentoring: Mentored junior analyst, authored and delivered analyst’s evaluations semi-annually, recommended compensation increases and promotion to management team.Client: Omron: Project Manager and Senior Developer for engagement at electronic component manufacturing and industrial automation subsidiaries.• Budget and Forecasting: Designed and built an application for yearly finance and sales budgeting and quarterly forecasting in Cognos TM1. Added workflow for approval/rejection of departmental numbers by supervisors. Enabled access to application via web and Excel. • Data Migration: Migrated financial and JD Edwards ERP data into TM1 cube model using Microsoft SSIS. • Demand Planning: Enabled conversion of sales forecasts stored in TM1 application into demand planning for manufacturing plants.

Chicago, Il

Supported finance, accounting, marketing and operations departments.• Data Modeling: Designed MicroStrategy data model used for reporting metrics in PostgreSQL-based proprietary loan web app.• QlikView Dashboards: Designed, developed and supported QlikView dashboards that combined data from web app with data from Lawson, Responsys, Genesys, Jira and Acunote. • ETL: Supported and maintained Microsoft SSIS jobs which exchanged customer data with Responsys, an external email marketing vendor.• Ad-hoc SQL: Wrote custom SQL queries for analysts in finance, accounting, marketing and operations departments.

Skokie, Il

Engagement Manager, Project Manager and Senior Developer at technology consulting group. • Management: Managed client expectations and provided regular updates to project stakeholders. Delivered and negotiated cost and delivery dates for project change orders. Monitored project teams and managed scope through build, test and implementation phases. Managed budget, tracked progress of tasks and deliverables against project plan, identified and mitigated issues and risks.• Analysis: Interviewed project stakeholders to develop business and technical requirements, documented requirements and created project vision. Designed data warehouses and data marts design using Kimball dimensional methodology.• ETL: Design, coded and implementation of ETL processes and jobs to populate data warehouse / data mart, SAP BusinessObjects software installation.• Sales Engineering: Demonstrated solutions to prospective clients, developed and documented proof-of-concept technical solutions, wrote client proposals, responded to RFPs, and authored statements of work.• Mentoring: Oversaw career progress of junior consultants, tracked certifications and training opportunities, wrote and delivered consultant evaluations quarterly and annually, recommended compensation increases and/or promotions.Clients:• PepsiCo: Engagement manager, project manager and developer for data warehouse engagement for PMO. Tracked global SAP implementation using SAP BusinessObjects, Informatica and Oracle.• Groupon: Project manager and developer for data warehouse engagement. Included third-party marketing and Salesforce data, used SAP BusinessObjects and MySQL.• Wolcott, Wood & Taylor: Project manager and developer for a data warehouse engagement at medical billing agency, used SAP BusinessObjects and SQL Server.• Nufarm: Engagement manager and developer for staff augmentation engagement at chemicals manufacturer using SAP Crystal Reports, SQL Server and Infor MRP.

Chicago

Business, data and QA analyst for retirement and health benefits administration system.

Evanston

Project manager and data analyst for 403(b) plans of US conferences of the United Methodist Church.

Chicago

Project manager for installation and customization of Net-Funds, the company’s web and IVR retirement fund product.