SUMMARY

• Innovative, details - oriented SQL Server Developer/BI Analyst wif 5+ years’ experience in clinic and real estate fields
• Multiple-year experience on SQL Server 2008/2012
• Proficient on loading large volume of data into SQL Server database from a variety of sources, and migrating data from Oracle database to SQL Server database; Experience in loading data from flat data files and excel sheets into Oracle database using SQL*Loader, SQL Developer and Toad
• Experience on using various robust reporting tools to generate reports: SSRS, Crystal Report and Access
• Proficient on high performance integration package solution using Microsoft SQL Server Integration Service (SSIS), including extraction, transformation and load (ETL) of data from OLTP into OLAP database
• Experience on building CUBES from data warehouse using SSAS
• Strong team player wif great communication and interpersonal skills
• Efficient problem-solver, quick learner and hard worker

TECHNICAL SKILLS

Database: SQL Server 2008 R2, SQL Server 2012, Oracle, Access 2007

Reporting: SSRS, Crystal Report 2008, Access 2007

Programming Language: SQL, T-SQL, SAS, Visual Basic

Microsoft Office Tools: Word, Excel, Power Point, Access

PROFESSIONAL EXPERIENCE

BI Developer

Confidential, Richmond, Virginia

Responsibilities:

• Used BULK INSERT, BCP to extract data from clients to staging tables.
• Used SQL or SSIS to create ETL packages to Validate, Extract, Transform and Load data into various dimension tables and fact tables in Data Warehouse.
• Implemented SSAS Cubes, Facts and Dimension tables to perform analysis. Extract and review data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) using SQL Server Integration Services (SSIS) from OLTP to OLAP and generate daily/monthly reports, dashboard wif drill-down reports based on business requirements.
• Developed projects using SQL Server Analysis Service (SSAS) wif Microsoft Visual Studio, created data source/data source view/cube wif measure and dimensions, configured attributes of dimension table wif hierarchy relationships; modified cube and dimensions, added new measure groups and dimensions; deployed cube package to SSAS instance
• Generated ad-hoc reports wif SSRS and Crystal Report

Confidential, Virginia

Data Scientist

Responsibilities:

• Loaded data generated from Knock (in) out mice, diabetic patients and Microarray chip into SQL Server2008 database tables.
• Retrieved and modified data from Gene chip and Microarray experiments using SQL Server2008 and BIDS and query data from different database, analyzed and translated the data into useful information.
• Extracted data using SSIS packages from different server locations and data sources.
• Deployed reports of each quarter onto the Report Server to access it through browser.
• Created various geographical and time dimension reports of fiscal year, quarter reports for all domains and published through Report Server.
• Worked wif integration services for transferring and reviewing data from heterogeneous sources like Excel, CSV, flat file, Text Format Data.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Generated various reports like Cascade type reports, Tabular reports, and Dashboard wif drill down reports.

Research Associate

Confidential, Virginia

Responsibilities:

• Configured SQL Server 2008/2012 and Oracle SQL 11g database parameter files.
• Created database tables wif 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; evaluated, cleaned and reformatted raw data; Wrote T-SQL scripts to manipulate data loads and extracts; loaded data from flat data files and excel sheet into Oracle database using SQL*Loader, SQL Developer and Toad.
• 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 wif multi-table joins, group functions, subqueries, set operations and T-SQL or PL/SQL functions.
• Generated a variety of business reports using SQL Server 2008/2012 SQL query, SSRS, Crystal Report 2008 and Excel 2007 Pivot table.
• Created ETL packages using SSIS Designer to extract 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 using BIDS and SSDT.
• Developed projects using SQL Server 2008/2012 SSAS, created data source/data source view/cube wif measure and dimensions, configured attributes of dimension table wif hierarchy relationships; modified cube and dimensions, added new measure groups and dimensions; created data-mining solutions in BIDS, deployed them to SSAS instance, trained the model and queried the model.
• Generated a variety of reports using SQL Server 2008/2012 SSRS including matrix report, parameter report, dashboard wif charts and drill-down function; built reports from Analysis Services cube using MDX query designer; configured report server and deployed reports on web server.