OBJECTIVE

Database Analyst /BI Developer/ Reporting Engineer

• Master of Computer Science with experience of Oracle SQL, SQL Server 2008, Access 2007 database, data loading and Reporting tools such as SSIS,SSAS,SSRS and Crystal Report 2008.
• Strong data manage and reporting experience on quantitative analysis.
• Professional experience on load variety of large volume data files into SQL Server 2008 database tables, migrate Oracle tables into SQL Server 2008 databases and generate Report with SSRS.
• Experience on high performance data integration solutions- Microsoft SQL Server Integration Service (SSIS), including extraction, transformation, and load (ETL) packages for data warehousing.
• Robust MS Access and Excel skill with Pivot tables.
• Experience of generating report with Crystal Reports from Oracle database, SQL Server 2008 and MS Access databases
• Database Analyze using advanced SQL queries to generate Matrix Report and Report with parameter to using SSRS from data warehouse
• Ability to prioritize and complete multiple tasks and detail oriented
• Proven capability to approach problems effectively and creatively in complex environment
• Quick learner, take initiator, and hard worker. Willing to take responsibilities

Database: Oracle 11g, SQL Server 2008, Access 2007 
Reporting: Access 2007, SSRS, Crystal Report
Languages: SQL, T-SQL,PL/SQL
Internet: MS SharePoint 2010 
MS Office: Word, Excel, PowerPoint

PROFESSIONAL TRAINING

• Oracle 11g, SQL Server 2008, SSIS, SSAS, SSRS, Crystal Report

• Successfully downloaded and installed Oracle 11g into database server
• Configured Oracle parameter file to adjust the memory usage
• Professional experience of most advanced Oracle 11g Database server, user account setup, SQL, sqlplus, SQL*Loader, load variety of data into Oracle database tables
• Oracle 11g SQL single row and group functions, multi table joins, subqueries and advanced SQL queries
• Extracted data from Oracle 11g database tables into flat data files and excel sheet
• Loaded data from flat data file and excel sheet into Oracle database tables
• Generated varieties kind of business reports use Oracle sqlplus and excel
• Successfully downloaded and installed SQL Server 2008 into database server.
• Configured SQL Server 2008 parameter files to adjust the memory usage and file size.
• Create many database tables with many constraints including primary key, foreign key, unique, check and not null.
• SQL query use SQL Server 2008 Single row and group functions, multi table joins, subqueries and set options.
• Extracted data from SQL Server2008 database tables into flat data files and excel sheet.
• Loaded data from flat data files into SQL Server 2008 database tables using bcp, bulk insert, or table export, import.
• Generated all sorts Reports use advanced SQL and SSRS with multi-table join, group functions, subquery and set operations.
• Employed SSIS Designer to create Microsoft SQL Server Integration Services package to extracted data from a flat file, reformat the data and insert the reformatted data into a fact table.
• Generated variety of business reports using SQL Server 2008, SQL Query, SSRS, Crystal Report 2008 and Excel 2010Pivot table.

SELECTED ACHIEVEMENTS on Business Intelligence

• Created ETL packages using SQL Server 2008 SSIS Designer to extracted data from flat file, reformat the data, and insert the reformatted data into fact table, loaded different types of dimension and fact tables into data warehouse, deployed SSIS packages and solutions into production system using SQL Server Business Intelligence Development Studio (BIDS).
• Developed projects using SQL Server 2008 SSAS, created data source/data source view/cube with measure and dimensions, configured attributes of dimension table with hierarchy relationships; modified cube and dimensions, deployed KPIs on SSRS and created different metrics, added new measure groups and dimensions; created data-mining solutions in BIDS, deployed them to SSAS instance, trained the model and queried the model using MDX.
• Generated variety of business reports using SQL Server 2008 SSRS including matrix report, parameter report, dashboard with charts and drill down function; built reports from Analysis Services cube using MDX query designer; configured report server and deployed reports on web server and SharePoint, built Performance Points Dashboards in SharePoint 2010.

PROFESSIONAL EXPERIENCE;

Database Analyst , Confidential 2008--present

• Responsible for designing and developing custom programming applications.
• Create tables based on the client requirements, loading data and pursue data cleansing and auditing.
• Design data flow and extra data from a SQL Server database, transform the data and then load into different database or flat file.
• Upload the weblog files into different database and analyze the weblog data.
• Create a mining structure to predict business need in the future.
• Generated variety of business reports using different tools.

Research Assistant, Confidential 2000-2004

• Maintain the research database, update and upgrade it from time and ensure safe storage of medical image data.
• Designing and developing project–specific SAS programs like producing analysis datasets, graphics and reports
• Generated report using Excel
• Assisted Biostatisticians in creating database infrastructure, analyzing datasets and reports.

Software Engineer, Confidential 1994-2000

• Handled the tasks of designing, developing and maintaining databases
• Responsible for identifying and procuring database software tools for efficient database development and usage
• Assigned the tasks of developing structural designs of various databases based upon logical data models
• Determined user requirements as well as sets up and tests computer databases
• Prepared, oversaw and coordinated database and application designs
• Worked closely with system users to make sure that the information system strategies meets with the program requirements
• Ensure client satisfaction through completion of project within schedule.

• B.S., Computer Science
• M.S., Software Engineering