OBJECTIVE: BI developer Database Analyst

SUMMARY

• Six years experiences in SQL Server 2008/2012, Oracl, Access 2010 database and Data Loading, Analysis and Reporting tools such as: SQL, SSIS, SSAS, SSRS and SharePoint.
• Strong data manage and reporting experience on quantitative analysis.
• Professional experience of most advanced SQL Server 2008/2012 Database server installation, login and user creation, role and permission configuration.
• Professional experience on load variety of large volume data files into SQL server 2008/2012 database tables, migrate Oracle tables into SQL Server 2008 database tables 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.
• Professional experiences on Microsoft SQL Server Analysis Service SSAS , including creation of data source and data source view, edition of user defined hierarchy, creation of calculated members and KPI with MDX. MOLAP data processing automation, partition and aggregation.
• Professional experiences on SharePoint 2010/2013 farm installation, configuration and integration with SQL Server 2008R2/2012SP1, creation of web application, site collections and web sites, BI application services PerformancePoint, SSRS, Excel, PowerPivot
• Robust MS Access and Excel skills with Pivot tables.
• Strong team player with great verbal, written communication and interpersonal skills.
• Proven ability to approach problems effectively, prioritize and complete multiple tasks.
• Quick learner, take initiator, and hard worker. Willing to take responsibilities.

EXPERIENCE

BI Developer

Confidential

• Designed and created CW Data Warehouse with 4 fact tables and 15 dimensions based on Kimball's 'star schema'. Designed and implemented SSIS packages integrating, loading, and updating sales data and inventory data from multiple data sources SQL Server, Oracle, DB2 into data warehouse.
• Designed and created SSAS SalesCube for the Sales Department and CategoryCube for the Purchase Department. Designed and implemented SSIS packages for the cube processing. Created user defined hierarchy. Created calculated members and KPI with MDX. Designed and implemented MOLAP data partition and aggregation.
• Designed and created more than 30 real time and interactive SSRS reports for sales, category managers, operation managers, and system administrators including tabular, matrix, charted, and parameterized reports. Deploy and manage SSRS reports in Report Manager and SharePoint 2013.
• Installation, configuration, and integration of SharePoint 2013 farm with SQL Server 2012 SP1. Created 2 web application, 2 site collections, and 8 web sites. Manage web site contents and user role permission. Configuration and deployment of SSRS reports on SharePoint sites. Configuration of PerformancePoint Service and creating dashboards with Dashboards Designer. Configuration Excel Service, creating and deploying Excel reports on SharePoint sites. Creation and configuration SP2013 search service. Created SP2013 usage report usage and web usage monitoring reports.. Install and configuration SP2013 workflow service.

Confidential

Database Analyst/BI Developer

• Database design, create tables, loading experimental data and patient data from flat files, Excel spread sheet, Access database into SQL server 2008 using advanced SQL, T-SQL and SSIS packages. Migrating data from Access database and oracle database to SQL server database. Design, deploy and implement SSIS packages with BIDS and SQL server agent. Loading large amount of data from different resources to the Fact table and Dimension table of data warehouse.
• Manage and analyze data with SQL server management studio and SQL queries. Create Cube and establish attributes hierarchy using SSAS tools. Create data mining model use SSAS data mining tool using different kind of Algorithms.
• Prepare dashboard reports with SSRS, Performance Point, Power Pivot and Crystal Report reporting tools. Use T-SQL, stored procedure creating dataset. Create various kinds of ad hoc reports including tabular, matrix, parameterized and charted reports in BIDS, deploy reports to SSRS Reporting Server and SharePoint.

Confidential

Research Scientist

• Loading DNA sequencing and Microarray assay data into SQL server and Access database, analyze and explain the results using SQL Server and Access as an important tool. Presenting data with crystal report 2008.
• Retrieve and modify patient data and disease information from oracle database.

SELECTED ACHIEVEMENTS ON BUSINESS INTELLIGENCE

• Created ETL packages using SQL Server 2008/2012 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/2012 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.
• Generated variety of business reports using SQL Server 2008/2012 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.
• Installed, configured, and integrated SharePoint 2010, SharePoint 2013 farms with SQL Server 2008R2, SQL Server 2012 SP1. Create web application, site collections and websites. Configuration of Performance Service, Excel Service, and SSRS Reporting Service. Create KPI, scorecard and analytical charts with dashboards designer.

SELECTED ACHIEVEMENTS ON SQL SERVER 2008/2012 DATABASE AND ORACLE DATABASE

• Configured SQL Server 2008/2012 and Oracle SQL 10g/11g/11gR2 database parameter files to adjust the memory usage and file size.
• Created database tables with various constraints including primary key, foreign key, etc.
• Loaded data from flat data files into SQL Server 2008/2012 database tables using bcp, bulk insert, and table export/import loaded data from flat data files and excel sheet into Oracle database using SQL Loader and SQL Developer.
• Extracted data from SQL Server 2008/2012 database tables and Oracle database tables into flat data files and Excel sheet.
• Power user of advanced SQL queries with multi-table joins, group functions, subqueries, set operations and T-SQL or PL/SQL functions.
• Generated variety of business reports using SQL queries, sqlplus, SSRS and Excel.
• Generated variety of business reports using SQL Server 2008/2012 sql query, SSRS, Crystal Report 2008 and Excel 2010 Pivot table.

COMPUTER SKILLS

Database: SQL Server 2008/2012, Oracle, SSIS, Access 2010,

Reporting: Access 2010, SSRS, Crystal Report 2008

Language: SQL, T-SQL Excel Visual Basic

Internet: MS SharePoint

MS Office: Word, Excel, PowerPoint, Access