TECHNICAL SKILLS:

Software: BIRT, Eclipse IDE, NetBean, Visual Studio, CSS, JavaScript, SSRS, SSIS, SSAS. Java related (Log4j, Junit, Ant, Ivy, Maven, JavaFX, etc.), C/C++ related (makefile, scripting, etc), Consensus, Erwin, Toad, DBDesigner, Weblogic (EJB, JMS, JSP, etc.), SAS Enterprise Miner, Pentaho, JFree Report, Mondrian OLAP server (star schema, snowflake schema), Spoon (Kettle), Netezza (parallel) server certificate, Actimize (rule) engine.

Databases: SQL Server 2000/2005/2008/2012 , Oracle (7, 8, 9, 10, 11), MySQL

Technical Skills: Data Modeling (Relational and Star/snowflake Schema. OLTP and Data warehouse), Business language complex SQL translation, SQL Server administration, web site security (http to https automatic redirect, apply SSL, etc). Programming in C, C++, Java, MDX, PL/SQL(Oracle), T - SQL(SQL Server), C#(.NET), Fortran, UNIX/Linux Shell Scripting (K, C, t), SAS (Basics). IBM Cobol/Copybook.

Most used and recently used programming languages: C, Java, C++, SQL.

Most familiar OS: Unix/Linux

EXPERIENCE:

Developer

Confidential

Responsibilities:

• Support a rule-based (logic in stored procedure) system for monitoring abnormal activities. Daily work involves translating business (email, verbal) requests into actions with complex SQL and vice versa (updating data, data investigation, special data report, etc.)
• Tracing data from IBM DB2 datasets, Cobol/Copybook, and eventually load into Oracle database.
• Programmed a software to package large amount of data from a variety of file types and databases into files that fit the archive format to be archived. Initial the prototype was written in C++, then it was written (managerial decision) in C#/.NET, eventually it was rewritten (managerial decision) and fully developed in Java (Eclipse, Junit, Log4j, CSS, database to XML processing, etc).

Data Architect

Confidential

Responsibilities:

• Re-design and rebuild a funding proposal (about 200 principal investigator/professors, yearly about 1000 funding proposals) data warehouse.
• The source data of the data warehouse come from eTrac system, a research proposal and funding process management system and Navision system, a research project accounting system. The data store of eTrac system is an object oriented database and both system do not have documentation for data structure.
• To understand the data store (a database) of eTrac meant to at least partially understand the way eTrac system works, and then identify the parts of the data in the system that relevant to business reports. In the data warehouse, the data from these source systems are to be loaded into a relational database, and then into a star schema database, and then be used to construct OLAP cube or to some reporting tables, directly used by users.
• I have conducted old legacy code investigation, old reports investigation (as part of requirement gathering), and data modeling (both relational as well as star schema), and ETL design and coding.
• Extensive SQL coding have been done.
• The final ETL method is using SSIS packages as control modules and using SQL (so complex data transformation can be done at that SQL layer) to extract data.

Senior Data Architect/Analyst

Confidential, Columbus, Ohio

Responsibilities:

• Main challenge in this project is that surveys and survey data date models are different from year to year and we have to load them into a database with common reporting schema.
• Extensive ETL work using SQL Server 2008 SSMS, SSIS, and stored procedures/T-SQL.
• There were numerous iterations from requirements
• Extensive ETL work using SQL Server 2008 SSMS, SSIS, and stored procedures/T-SQL.
• There were numerous iterations from requirements to implementation, to get verifications.
• Used Perl to write scanner software to scan for computer language patterns in a large repository of deployed programs.
• Built Pilot Business Intelligence Solution extracted from multiple OLTP databases, transformed with extensive data cleaning, and loaded into a consolidated Data Warehouse for deployment to two data marts.
• Used full MS BI Suite (SSMS, SSIS, SSRS, SSAS, as well as stored procedures/T-SQL)
• Mentored OPERS IT on data warehouse design and ETL design, using SQL Server Integration Services (SSIS) packages and T-SQL stored procedure in the ETL link; also completed analysis requirement gathering, conducted source data investigation and designed a data mart design.
• Coordinated and promoted communication of issues discovered from requirements gathering, ETL development, and data warehouse design, despite real world complexities of data rules and variable taxonomies of multiple data sources.
• Extensively used SQL Server Integration Services (SSIS) and MS SQL Server stored procedures to migrate data between multiple databases.
• Used C# code to modify programs.
• Proposed new IT departmental overall data architecture (logical partitions of different subject areas and their interface and relationships); also included the potential business needs, specific feasibility, rationale, cost, effectiveness, success measure criteria, and goals of using data mining to assist in marketing and data warehouse to organize their data and provide OLAP capability.
• Conducted source data and target data matching for an inventory control system.
• The source system was an OLTP database of an Axapta ERP system in MS SQL Server 2005, the target system was a Cognos authorized reporting data mart in MS SQL Server 2005.
• Conducted analysis on an MS SQL Server database for data access control, sensitive data protection and web page based data access.
• Examined a large volume of SQL and .NET code in the data access layer as part of the engagement.
• Proposed improved system architecture for the database system as well as data access methods.
• Conducted data analysis, data mart design, and wrote ETL code (in Oracle PL/SQL, UNIX shell script, and C ) to extract, transform, and load data from an Oracle database into an MS SQL Server database.
• Designing the data mart in a star-schema to ensure report-generation using Cognos based on tables in the data mart requiring "within-seconds" response time. o Phase IV: Wrote a set of new ETL code in Oracle PL/SQL scripts, C code (for complex data transformation) and UNIX Shell Scripting (for job scheduling) to replace the original Cobol program to extract data from Oscar and load into the data mart.
• Conducted an ETL tool evaluation.
• Confidential 's' IT department, initial screening of ETL tools (DataStage, Informatica Power Center, Microsoft SSIS, Sunopsis, Ab initio, iWay DataMigrator) by going through white papers, data sheets, published research reports, etc. Based on this work, came up with a methodology for ETL tool evaluation and applied it to the Confidential 's' case.
• The methodology lists the methods used to evaluate (differentiate) ETL tools, the source of information channels to go through, and criteria for determining the choice of the tool. o Phase II: Performance tests: On the basis of above work, designed test cases and conducted extensive ETL test runs using Informatica Power Center, iWay DataMigrator, and SQL Server Integration Services (SSIS) package. o Phase III: Conclusion and report writing: Based on Phase I and Phase II, compiled a report sent to Confidential 's' IT as the deliverable for the evaluation.
• Conducted meetings with various Ohio State government agency leaders and IT staff to gather information about needs, complaints, system usages, and system architectures regarding the Medicaid data warehouse and the related systems. Along with four other team members, conducted three Joint Application Requirement Sessions. Conducted software tools evaluation, including comparing data mining tools such as SAS Enterprise Miner and SPSS Clementine, ETL tools such as Informatica, metadata (data integration) tools such as MITI and SuperGlue, and business intelligence tools such as Business Objects, Medstat (data mining and profiling tool for medically related data), and SAS BI Server Suite.

Confidential

Project Leader/Data Architect

Responsibilities:

• Conducted extensive data analysis, and re-designed the data model of databases and data warehouses of Confidential Human Resource, Financial, Contracts, Products, Engine, and Parts. The work involved data modeling of hundreds of tables in over thirty interconnected databases.
• Used PL/SQL to investigate legacy systems; ERwin was the modeling tool. Used C and UNIX Shell Scripting on a Unix (AIX) system to write an application for message processing, job scheduling and dispatch. Used C, PL/SQL (Oracle) stored procedure for processing data to implement data transformation rules.

Confidential

IT Consultant

Responsibilities:

• Implemented Tibco communication software (C code based) for a fund research group.
• Analyzed a large legacy system in order to understand the overall functionality and general architecture; created one large data flow diagram of the system.
• The project used C, UNIX Shell Scripting, Oracle (Pro*C, PL/SQL), ERwin and Tibco.

Confidential

Principal/Lead Engineer

Responsibilities:

• Led a group of seven Engineers in order to complete a large central data warehouse project for the auto-pricing system of Confidential the system was implemented on an Oracle database. The volume of initial data loading is approximately one TB.
• The project used UNIX Shell Scripting, Toad, Oracle 8i, PL/SQL, Pro*C and Erwin. Wrote many stored procedures in Oracle and used many Oracle 8i special features to speed up the loading process.