Resume of Chen Yihua
Resume
Name: Chen Yihua
Mobile: +1 302 898 5351
Email:
EDUCATION
BACHELOR DEGREENanchang Hangkong University2001
MasterDEGREE Nanjing University2013
PMPProject Management Institute2013
TECHNICAL SKILLS
Operating SystemWindows-95/98/2000/XP/2003/7, Windows 2000 advance server, Windows Server 2008
Programming LanguagesSQL script, certain knowledge on Java, JSP, AJAX
RDBMSNetezza, Oracle, Sybase, SQL Server 2000/2005/2008, PL/SQL Designer
Reporting ToolsMicrostrategy 7, 8.1, 9.0, 9.3, 10.2, 10.4, Cognos 8.4, 10.0.2, PB
ETL ToolsInformatica, SSIS
Web ServersApache Tomcat, IIS
Other UtilitiesTivoli, VSS, CVS, StarTeam, Powerbuilder
Professional Summary:
- Over 16years of experience in data warehouse industry, and over 12years ofprofessional experience in implementing Business Intelligence, expertise in Data warehousing, BI architecture, Data modeling in MicroStrategy 7, 8.1, 9.0.0, 9.3.0, 9.4.1, 10.2, 10.4
- Served variety accounts in retail, healthcare, pharmaceutical and life science, consumer goods and FMCG, life insurance, auto insurance industry, strong domain knowledge.
- Extensively worked in BI architectureand data modeling based onthe project requirement and implementation the same with Microstrategy suite.
- Extensively worked on creating and integrating MicroStrategy standard reports, documents and mobile dashboards with variety of objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Security Filters, Dashboards and Derived Elements)
- Skilled in MicroStrategy Enterprice Manager, Metadata Management, Migration and Integration, Object Manager, Command Manager, Visual Insight, VLDB Setting, Performance Tuning, Cubes Monitor and Distribution Service.
- Good Experience in Microstrategy SDK and Customization development, Web Server (Java, .Net), Mobile Server configuration and publish.
- Installation and configuration of MicroStrategy 7, 8.1, 9.0.0, 9.3.0, 9.4.1, 10.2in Windows/Linux environment with clustering.
- Upgradeand Migration of the Micorstrategy version 7 to 8.1, 8.1 to 9.0, 9.0 to 9.3, 9.4 and 10.2
- Strong Knowledge in data warehousing and SQL query coding, good knowledge on various ETL and database development tools like Informatica, SQL Server and SSIS, Netezza, Oracle, etc.
- Full life cycle implementation experiences for small, middle and large Data Warehouse/BI projects, from requirementsgathering and analysis, design, development, testing, deployment, and support
- Excellent troubleshooting skills with strong technical background and good interpersonal skills.
- Excellent communication skills, analytical, problem solving and Self-motivated to work individually as well as in a team.
EMPLOYMENT HISTORY :
Name of the Company / Designation / From / To / Duration(Years)Cognizant Technology Solutions / Sr. Manager /Architect / 2010/12 / Present / 6.5
Unisono Fieldmarketing (Shanghai) Co., Ltd. / DW/BI Team Leader / 2005/06 / 2010/12 / 5.5
Shanghai LC PR & Media Group / Event Manager / 2004/10 / 2005/6 / 0.5
Shanghai Institute of Computer technology / Software Engineer / 2001/2 / 2004/10 / 4
2010/12—Present:Cognizant technology solutions(>500 people)
Industry:Computers,Software
Sr. DW/BI Architect / Project Manager
As the Sr. Architectand project manager in Microstrategy BI team, my main responsibility ison below and any other issue troubleshooting in Microstrategy,
Requirement gathering, business solution analysis, to come up a good project design
Design the DWH data model and BI architecture
Schemas and objects semantic layer design like Attributes, Partitions, Metrics, Filters, Prompts design, graph/grid reports, cubes and dashboards design
Microstrategy server installation and configuration in Windows environment consisting of 2 BI servers in clustering, 2 Web and Mobile servers with load balancer plus 2 SQL Server/NetezzaDatabase servers.
Project / Report migration from development server to production server using Object Manager.
Checking BI DSS error logs during issues.
Managing user accounts and distribution service.
Work with offshore team, knowledge transfer and guide the team on development and issues.
Monitoring Cubes performance and status
Design User/Object/Data level security model for various markets and brands at territory / region / area / nation level.
MSTR performance tuning and tracing by VLDB setting and SQL generation, Enterprise Manager if need
In addition, I’m alsokeeping fluent connection with all the stakeholders and customers, gathering client requirements from business to technology, business solution analyzing and technical designing, leading BI team to finish all the development, testing, and deployment and delivery management.
______
2005/6--2010/12:Unisono Fieldmarketing (Shanghai) Co., Ltd.(150-500 people)
Industry:FMCG (Food,Beverage,Cosmetics), IT
Team Leader / Senior Business Solution Engineer
As the Team Leader in DW/BI team, my responsibility is
Requirement gathering, business solution analysis and designing
Designing data model, Dashboard design and project migration.
Installed MSTR 9.0.0 in Windows environment.
Upgraded the MicroStrategy version 8.1 to 9.0.0. Windows environment consisting of 2 BI servers in clustering, 2 Web servers with load balancer and 2 SQL Server database servers.
Project / Report migration from development server to production server using Object Manager.
Checking BI DSS error logs during issues.
Managing user accounts and distribution service.
Apart from Report development guided the team during issues.
Publishing, Refreshing and monitoring Cubes.
Partition management in MSTR
Designed a security model for various brands at region / area / nation level.
Performance tuning by VLDB setting and tracing details in Enterprise Manager
______
2004/11--2005/5:Shanghai LC PR & Media Group
Industry:Public Relations/Marketing/Exhibitions
Exhibition & Event Manager Exhibition/Event Manager
Provides services covering communication plan development, media relations management, event planning and organization.
______
2001/2--2004/10:Shanghai Institute of Computer technology
Industry:Computers,Software
Database develop Software Engineer
Develop tools: Powerbuilder + Sybase
Develop ERP, MIS system for clients.
PROJECT EXPERIENCE
Project Experience: (Cognizant)
2017/08 — Present:Project Supporting and Maintenance
Software Environment:Microstrategy, Netezza, SQL Server
Development Tools:Microstrategy, DB Visualizer, SQL Server
Responsibility:
Provide the Microstrategy supporting to all the business on EDW and Guidewire reporting system.
Involved in all the discussion with business users to understandthe issues and problems they have occurred.
Troubleshooting, look into the ETL/Reporting code and figure out the root cause and fix the issues
Maintain the EDW and Guidewire Reporting systems for enhancement or change request
Monitoring Cubes performance and status
2017/04 — 2017/08:GuideWireUnderwriting Reporting
Software Environment:Microstrategy, Netezza, SQL Server
Development Tools:Microstrategy, DB Visualizer, SQL Server
Project Description:Business need a near-real-time Microstrategy reporting solution which would help providing quick access to data being entered/modified in Guidewire application system for underwriting.“Near-real-time” assumes that the proposed solution will address the need to run just-in-time reports that are dependent on business processes, or at defined intra-day times.
Business is able to get the Real time reporting capabilities for transaction and operational reports which is more robust and scalable solution, and they can stop increasing dependency on messaging process of application.
Responsibility:
As an architect and project manager, my key responsibility is to lead offshore to complete ETL and MSTR Development/Testing,
Oversee day-to-day activities and resolve any impediments by working in collaboration with Mercury
Track milestones against the Program Plan and report the Program status on a periodic basis.
Involved in all the meeting with business users to discuss and finalize the requirements gathering, analysis and design of the reports.
Completely work on data model design, delivering to offshore team with some best practice from Microstrategy model perspective.
Completely work on architecting the solution focusing on development of reusable components, complete all the semantic layer schema design and leading offshore on other objects design
Performed full software development life cycle process (SDLC) of Initiation, Analysis, Design, Development, Testing, End User Acceptance presentations and Implementation.
High and detailed level design/development for various modules of the Reporting solution including reporting technical design, semantic layer design, data abstraction design, business abstraction design, report components/objects design for all dynamic grid/chart, flash, dashboard and various interactive reports
Project / Report migration from development server to production server using Object Manager.
Managing user accounts and distribution service.
Guiding offshore team on development and issues.
MSTR performance tuning and tracing by VLDB setting and SQL generation, Enterprise Manager if need
Liaison with Mercury SMEs and stakeholders for all clarifications during onsite hours.
2016/04 —2017/03:GuideWireFinancial Reporting
Software Environment:Microstrategy, Netezza, SQL Server
Development Tools:Microstrategy, DB Visualizer, SQL Server
Project Description:Business need a near-real-time Microstrategy reporting solution which would help providing quick access to data being entered/modified in Guidewire application system.“Near-real-time” assumes that the proposed solution will address the need to run just-in-time reports that are dependent on business processes, or at defined intra-day times.
Business is able to get the Real time reporting capabilities for transaction and operational reports which is more robust and scalable solution, and they can stop increasing dependency on messaging process of application.
Responsibility:
As an architect and project manager, my key responsibility is to lead offshore to complete MSTR Development/Testing,
Oversee day-to-day activities and resolve any impediments by working in collaboration with Mercury
Track milestones against the Program Plan and report the Program status on a periodic basis.
Involved in all the meeting with business users to discuss and finalize the requirements gathering, analysis and design of the reports.
Extensively work on data model design with ETL team and data architect, guiding them with some best practice from Microstrategy model perspective.
Participates in architecting the solution focusing on development of reusable components, complete all the semantic layer schema design and leading offshore on other objects design
Performed full software development life cycle process (SDLC) of Initiation, Analysis, Design, Development, Testing, End User Acceptance presentations and Implementation.
High and detailed level design/development for various modules of the Reporting solution including reporting technical design, semantic layer design, data abstraction design, business abstraction design, report components/objects design for all dynamic grid/chart, flash, dashboard and various interactive reports
Project / Report migration from development server to production server using Object Manager.
Managing user accounts and distribution service.
Guiding offshore team on development and issues.
MSTR performance tuning and tracing by VLDB setting and SQL generation, Enterprise Manager if need
Liaison with Mercury SMEs and stakeholders for all clarifications during onsite hours.
2015/08 —2016/04:GuideWireBilling Reporting
Software Environment:Microstrategy, SQL Server
Development Tools:Microstrategy, DB Visualizer, SQL Server
Project Description:Microstrategy Development to completeGW Billing Reportingdata model and reports based on new GuideWire source system.
Responsibility:
As an architectand project manager from onsite for leading offshore to complete MSTR Development/Testing,
Oversee day-to-day activities and resolve any impediments by working in collaboration with Mercury
Track milestones against the Program Plan and report the Program status on a periodic basis.
Ensures adherence to Mercury standards, policies and quality compliance while bringing Cognizant’s program governance principles
Acts as primary escalation point for issues and problems
Involved in all the meeting with business users to discuss and finalize the requirements gathering, analysis and design of the reports.
Complete the data model design and BI model design
Participates in architecting the solution focusing on development of reusable components, complete all the semantic layer schema design and leading offshore on other objects design
Performed full software development life cycle process (SDLC) of Initiation, Analysis, Design, Development, Testing, End User Acceptance presentations and Implementation.
Strong delivery management makes sure work of onsite/offshore teams are synchronized well
High and detailed level design/development for various modules of the Reporting solution including reporting technical design, semantic layer design, data abstraction design, business abstraction design, report components/objects design for all dynamic grid/chart, flash, dashboard and various interactive reports
Project / Report migration from development server to production server using Object Manager.
Checking BI DSS error logs during issues.
Managing user accounts and distribution service.
MSTR performance tuning and tracing by VLDB setting and SQL generation, Enterprise Manager if need
Liaison with Mercury SMEs and stakeholders for all clarifications during onsite hours.
Responsible for all deliverables
Offshore Co-ordination.
QA testing Co-ordination.
2014/08 —2015/08:GuideWire Claims Reporting
Software Environment:Microstrategy, Netezza
Development Tools:Microstrategy, DB Visualizer
Project Description:Develop a comprehensive data model for GuideWire Claims system in alignment with industry best practices which can also accommodate current and scalable for future reports.
Develop the data model architecture which is a combination of EDW (includes Datamart), Data Stage and Replication DB from different database (Netteza, SQL Server).
Develop 60 main Claims subject area reports in Microstrategy with variety styles including dynamic grid, chart, and geography map, trend analysis with drill down/up and through navigation.
Responsibility:
As an architectand project manager from onsite for leading offshore to complete MSTR Development/Testing,
Involved in all the meeting with business users to discuss and finalize the requirements gathering, analysis and design of the reports.
Designing data model, MSTR and Data Warehouse Hierarchies
Schemas and objects design like Attributes, Partitions, Metrics, Filters, Prompts design, graph/grid reports, cubes and dashboards
Microstrategy server installation and configuration in Windows environment consisting of 2 BI servers in clustering, 2 Web and Mobile servers with load balancer plus 2 SQL Server Database servers.
Project / Report migration from development server to production server using Object Manager.
Checking BI DSS error logs during issues.
Managing user accounts and distribution service.
Guiding the team on development and issues.
Monitoring Cubes performance and status
Design User/Object/Data level security model for various markets and brands at territory / region / area / nation level.
MSTR performance tuning and tracing by VLDB setting and SQL generation, Enterprise Manager if need
2014/04 — 2014/07:AZ AD Amundsen Reports
Software Environment:Microstrategy, Netezza
Development Tools:Microstrategy, Netezza
Project Description:Development of Amundsen reports/views from SIMON using Microstrategy technology with multisource data.
Responsibility:
As anarchitect and project manager from onsite for leading offshore to complete MSTR Development/Testing,
Requirement gathering & analysis from end users
POC for prototype with offshore
Architecture model and objects design
Architecting the solution focusing development of reusable components
Coordination with offshore to complete dashboard and Graph/Grid Report Design, Development and Delivery
Work and give guidance tooffshore to complete attributes, facts, Cubes and relationships between various attributes
Provide technical and business solution on variant dashboards with multiple panels and graphsin DHTM Interactive Mode.
Troubleshooting and challenge guidance to offshore.
Periodically review all project schedules and deliverables
Participates in reviews and weekly meetings, prepare status report and risk/issue log
Ensures adherence to AZ standards, policies and quality compliance, enterprise metadata definition while bringing Cognizant’s BI program governance principles
Interacts with AZ/ Cognizant Quality group to ensure maintenance of quality standards
Ensures incorporation of best practices and lessons learned from prior projects
Ensures maintenance of process-centric knowledge management
Acts as primary escalation point for issues and problems
Allocates work and monitor activitieson offshore team
2013/11 —2014/04:AZSIMONAcceleratorInitiatives Project
Software Environment:Microstrategy, Netezza
Development Tools:Microstrategy, Netezza
Project Description:A new mobility project for their EBD/CBD team.
Responsibility:
As an Architect and project manager from China team in this project,
Requirement gathering & analysis
POC for prototype
Dashboard and Graph/Grid Report Design, Development and Delivery
Worked with MicroStrategy desktop to build attributes, facts, Cubes and relationships between various attributes
Developed dashboards with multiple panels and graphs in iPad.
Extensively worked and developed on selectors and widgets to give decision makers a handy tool to choose the criteria for report and view information in different perspective.
Used security filter to restrict data at various level.
Configured Mobile server for iPads.
Periodically review all project schedules and deliverables
Participates in reviews and weekly meetings
Work with Cognizant global architect team to achieve the architect work
Ensures adherence to AZ standards, policies and quality compliance, enterprise metadata definition while bringing Cognizant’s BI program governance principles
Interacts with AZ/ Cognizant Quality group to ensure maintenance of quality standards
Participates in architecting the solution focusing development of reusable components
Ensures incorporation of best practices and lessons learned from prior projects
Ensures maintenance of process-centric knowledge management
Acts as primary escalation point for issues and problems
Allocates work and monitor activities in China Team
______
2013/3 — 2013/11:AZSDM Project
Software Environment:Microstrategy, Netezza
Development Tools:Microstrategy, Netezza
Project Description:AZ has recognized the need to provide reports systemfor their sales team on IPAD. This is a new mobility project.
Responsibility:
As an Architect and project managerfrom China team in this project,
Requirement gathering & analysis,
POC for prototype
Dashboard and Graph/Grid Report Design, Development and Delivery
Worked with MicroStrategy desktop to build attributes, facts Cubes and relationships between various attributes