王雅娟 Email and Phone Number

“Daily Maintain: maintain Cognos planning system to keep a good performance; technical support on application owner, end user on troubleshooting data problem and debug each data load process; prepare new version (monthly and budget) regarding to related systems, verify related data; manage all the ETL process ; manage user security (add, delete and change); study relationship between Cognos Planning and other systems, then summary related knowledge (business knowledge, technical knowledge, and… Show more “Daily Maintain: maintain Cognos planning system to keep a good performance; technical support on application owner, end user on troubleshooting data problem and debug each data load process; prepare new version (monthly and budget) regarding to related systems, verify related data; manage all the ETL process ; manage user security (add, delete and change); study relationship between Cognos Planning and other systems, then summary related knowledge (business knowledge, technical knowledge, and process knowledge).“Design and Develop: Clarified business targets, designed and discussed related solutions, and then adjust function model, measures, dimensions, and organization structures; Developed SSIS packages and adjust libraries, models and reports in Cognos Planning.“Upgrade Tools: Upgrade Cognos Planning(8.4->10.1->10.4) and SQL Server(2005->2012), Migrate existing applications/jobs/maintenance plans/SSIS Packages to new server, change deploy mode in SSIS packages, and change security from Access Manager to AD group.“Audit Systems: Prepare related documentations in order to assist internal audit team and external auditors to check data flow, change, disaster and discovery, and user security, display related evidence and explain issues.“Team Work: Helped team members to ramp up at their very beginning after they joined the team. Performed a lot of knowledge transfer work; Communicated and exchanged information with business team; Communicated with clients to sync up our work with them; assist leader to consolidate team and achieve business’s trust then extend existing team. Show less

“Reviewed Business Requirement Documents and Functional Specifications for BI projects.“Clarified business targets, designed workflow processes and develop packages in use of Framework and reports.“Designed test cases that reflected an accurate understanding of business requirements and application-level conditions, which resulted in test cycles that efficiently identified critical defects; Support user acceptance test.“In Britain ability and experience of design, communicate… Show more “Reviewed Business Requirement Documents and Functional Specifications for BI projects.“Clarified business targets, designed workflow processes and develop packages in use of Framework and reports.“Designed test cases that reflected an accurate understanding of business requirements and application-level conditions, which resulted in test cycles that efficiently identified critical defects; Support user acceptance test.“In Britain ability and experience of design, communicate, coordinate, and manage is believed by business so that Beijing team would be established to serve as team leader, working with British team together. Show less

“Requirement analysis in support of Data Warehousing efforts.“Mapped accepted business requirements to work flow design.“Adjust existing report mode, develop Fund transaction cube and stock business cube, and assist other team to develop multi-channel reports.

“Analysis all kinds of measures (premium, loss ratio, and claims) regarding to car insurance coverage, car insurance sales, car insurance claims and other departments, design reports according to relationship between measures then discuss with business team, complete requirement specification.“Take part in model designation and development.

“Discuss solution with client and complete requirement specification, then developers design and develop related report and ETL process according to it.

“Created, managed, and delivered reports (ETF statistic weekly, Investors statistic report, fund sales weekly).“Optimize fund net management-fee and fund day-scale statistic reports.“Be familiar with business process, database structure, and fund terminology.

“Complete project accident and health insurance by myself (analysis requirement, design and implement ETL process in use of DataStage, develop reports, UAT support, go live, and technical support).“Complete designation and development regarding centralized underwriting report, service time report, KPI report, and data look-up report.“Change report (channel and business source are same between financial report and planning report , add dimensions in calendar year report, full claim ratio… Show more “Complete project accident and health insurance by myself (analysis requirement, design and implement ETL process in use of DataStage, develop reports, UAT support, go live, and technical support).“Complete designation and development regarding centralized underwriting report, service time report, KPI report, and data look-up report.“Change report (channel and business source are same between financial report and planning report , add dimensions in calendar year report, full claim ratio report, and performance report, and add measures in performance report).“Extract data and debug data according to business requirement. Show less

“Claim measure monitoring system: maintain system to keep a good performance, ensure data can be loaded correctly in time, technical support on end user on troubleshooting data problem and debug each data load process.“Data express system: analysis requirement, design database, design and develop transformer model and generate cubes, develop reports; maintain system.“Accident health insurance and liability insurance system: analysis requirement, design database, design and develop… Show more “Claim measure monitoring system: maintain system to keep a good performance, ensure data can be loaded correctly in time, technical support on end user on troubleshooting data problem and debug each data load process.“Data express system: analysis requirement, design database, design and develop transformer model and generate cubes, develop reports; maintain system.“Accident health insurance and liability insurance system: analysis requirement, design database, design and develop transformer model and generate cubes, develop reports; maintain system.“Vehicle insurance system (upgrade existing system): analysis requirement, design database, design and develop transformer model and generate cubes, develop reports; maintain system.“New claims system (upgrade existing system): analysis requirement, design database, design and develop transformer model and generate cubes, develop reports.“Operation and analysis system: analysis requirement, explore and analysis data, develop transformer model and reports, UAT support.“Security: Manage user security (add, delete and change).“Summary knowledge: understand and be familiar with system, insurance business process, BI architecture and principle, use of related tools, communication skill with client, and experience for project management. Show less