Nianwu E Email & Phone Number

Greater Chicago Area

Working at BI developer in Business Intellegent team on various projects, Resposible for a dozen SQL server applications, maintaining SQL server databases, design,create, and test SSIS packges and extract data, creating tables and jobs. creating SAS extracts by using SAS, SQL, SAS Macros.

Working as a reporting analyst, provide support to current datamart and group reporting, create and develop Crystal reports and Cognos reports for CRU group users, create and run SQL queries for group reporting, design, develop, and test ETL packages for CRU datamart and run daily ETL packages, extract data from Siebel applications, and develop new.

Providing services to DDB Information Management Application System. As a ETL developer of the project, I work closely with the business analyst of the project, design, and implement the whole ETL processes extracting data from AS400, transforming and loading data to SQL server 2008 databases using SQL server SSIS, taking Database administrator role to.

• Interact with the users and business analysts to gather system requirements, prepare use cases, and create software requirement specifications for users.
• Design logical and physical data models for the MIS Data and HR data warehouses.
• Design ETL processes and create data mappings for MIS Data and HR warehouses.
• Create and develop system test plans and test cases for upgrading Business Object 5.1.6 to Business Object XI.
• Create and maintain universes for Retail Bank Dashboard and PRED systems using BO XI and SQL Server 2005 (SSIS, SSRS, SSAS).
• Create and maintain Retail Bank and PRED Dashboards by using Web intelligence, Crystal reports, Crystal Xcelsius, interactive metrics, and analytical.

• Created Access databases, collected data from national surveys, and synchronized data integrity.
• Designed data interface into SAS system and used SAS and SPSS statistical software to do both descriptive and inferential researches on the data set to find out certain patterns and predict regressions.
• Evaluated the statistical results from ANOVA, Factor Analysis, and HLM to create reports. Interpreted and presented results at various groups and committees for decision-makings and policy changes.
• Built different statistical models to fit the samples and populations.
• Assisted professors with statistical analysis, reviewed the results, and provided training to team members.

• Created high-level design documents such as process flows, process descriptions, file layouts, and program descriptions.
• Worked as a technical owner of the data model and managed all aspects of the Data Warehouse Environment.
• Reviewed the early dimensional model and recommended improvement actions for the model and architecture
• Created test database and tables for testing and extract and modify test data. Built the new Oracle databases.
• Maintained ETL processes and create data mappings for GET data warehouse.
• Designed interface between web front end and back end legacy system and implemented preventive, detective, and corrective controls to ensure data integrity.

• Followed the system life cycle methodology to develop new functions for the system.
• Collected users’ requirements from various user groups.
• Created high level design and detailed design for the web applications.
• Used HTML, Java, and Java Applets to code GUI user interface and tested it in Internet Explorer.
• Coded programs to create user reports and tested the Java applications querying and updating databases using Java, Java Servlet, CGI scripts, HTML, JDBC, and SQL in system integration and user acceptance test.
• Used SQL, JCL, CICS, Perl, Shell Scripts to run batch jobs, scheduled daily jobs, and online jobs on MVS/390 and UNIX platforms.

• Used SAS and SPSS statistical software to do both descriptive and inferential researches to provide statistical analysis assistance to students and professors.
• Assisted users with statistical software problems and supported the software.
• Set up computers and did computer administrator works.

Master, Computer Science

Master, Educational Psychology

Activities and Societies: a member of AERA (American Educational Research Association)