Shufang Fu

Mail: PO Box ***, South Lyme, CT ***76; Cell: 860-***-****; Email: adzz44@r.postjobfree.com

Objective

An enthusiastic, dedicated, self-directed team player is looking for Data Analyst/Data Engineer/BI Developer/BI Administrator position in IT field utilizing my extensive experiences of 25 years and expertise in data analysis, data science, BI reporting and system administration, data warehouse/data-mart development, and project management.

Summary of qualifications

• 9-year of experience on data analysis, ETL, data warehouse and data mart development

• 8 years in Cognos BI report development

• 7 years in Cognos BI production support and system administration

• 1 year in Microstrategy report development

Expertise and Competencies

• Strong critical thinking, problem solving and analytical capabilities

• Self-directed and result-driven, quick learning and creative

• Strong leadership and project management skills

• Strong background in MS SQL Server

• Expert in data analysis, data warehouse and data mart development

• Expert in relational database concepts, data modeling and OLAP technologies

• IBM certified expert in BI predicting, planning, and reporting system design, development

o Cognos framework modeling/Data module/dataset

o Ad-hoc reporting, Report studio reports, Dashboard, Active report, Dynamic cube, and Cognos cube

• Expert in Cognos BI system (version 8x, 10x and 11x) installation, configuration, upgrading and maintenance

Skill Sets

• Platforms/Systems:

o UNIX, LINUX, Mainframe, Windows

• Databases:

o Informix, SQL Server, Oracle, DB2, Teradata, Sybase, Hadoop

• Programming Lauguage:

o Java, C, C++, SQL, SQL Plus, BTEQ, JCL, Kornshell

• Tools:

o IBM Cognos Reporting tool sets, Microstrategy Reporting tool sets, Informatica ETL tool

o Microsoft Office, Excel Pivot Tables, SharePoint

o Arcadia, Composite, BMC Remedy ITSM Incident, Change, and problem management, Autosys Scheduling, Motio, Toad Data Point, ITRS Geneos. Bladelogic, Agile, JIRA, Nexus

Accomplishments

• Support business users to be more productive

o Work as Cognos BI system administrator to keep Cognos BI system running effectively 24X7, support business users and resolve issues, do annual disaster recovering exercise.

o Worked as team lead to develop Cognos BI reporting systems for banking, investing, and mortgage Line of Business

• Improve performance:

o Creatively utilized Composite, a data virtualization tool, to improve performance. The new functionality allowed the report to now process in seconds and not minutes.

o Developed a mart loading system. The system led to tremendous efficiency improvement (14 hours loading time is reduced to 3 hours. The system works as the standard tool in the mart data migration

• Solve Business Issues

o Provided solutions to meet business need. My demonstrated ability to solve problems quickly led to being added to the development team by the business partner

Education

Master's Degree : 1998, major in Computer and Information Science, the College of William & Mary, Williamsburg,Virginia, USA

Bachelor's Degree: 1988, major in Dynamic Engineering; minor in Electrical and Mechanical Engineering, Huazhong University of Technology and Science, China

Certifications:

• IBM Certified Cognos BI Author

• IBM Certified Cognos BI Metadata Model Developer

• IBM Certified Cognos 10 BI OLAP Model Developer

• IBM Certified Cognos BI Professional

• IBM Certified Cognos BI Solution Expert

• MicroStrategy 10 Certified Associate Analyst

• MicroStrategy 10 Certified Application Designer

• MicroStrategy 10 Certified Administrator

Work Experience

Bank of America, Farmington, Connecticut, USA

Vice President; Architect 2 / Data Engineer 2, BI / Analytics and ETL COE, 05/2016 - Present

• Work as Cognos system administrator

• Responsible for software installation, system maintenance and upgrade, business support, issue resolution, disaster recovering exercise

Vice President; Architect 2, BI / Analytics and ETL COE, 10/2006 – 04/2016

• Lead team to develop Business Intelligence predicting, planning, and reporting systems for banking, investing, and mortgage Line of Business

• Responsible for relational/dimensional database modeling/Cognos application design, review, and Cognos COE standard work and technology training

Senior Business Analyst, 01/2006 – 09/2006

• Responsible for leading data analysis, Teradata and Informix data warehouse design, and ETL process development

Consultant-Applications Programmer, 04/2004 – 12/2005

• Responsible for Oracle/SQL Server data mart design and development

• Led data mart production support and user support

Technical Project Manager I, 08/1998 – 03/2004

• Project manager for data mart application design and development

• Developed a mart loading system. The system led to tremendous efficiency improvement and works as the standard tool in the mart data migration

Visinet INC., Virginia, USA

Oracle Database Developer, 06/1997 – 08/1997

• Responsible for developing Oracle database, forms, and reports for a wholesale management warehouse system.

Beijing Electric Power College,China

Instructor, 09/1988 – 10/1992

• Teaching course " Engineering Dynamics" and "Engineering Fluid Flow and Heat Exchange"

Contact this candidate