SUMMARY

• PhD of Biology with 8 years experiences of SQL Server 2008/2014/2017 , Oracle 10g/11g, Access 2007/2010/2013 database and Data Loading and Reporting tools such as: SSIS, SSRS and Crystal Reports 2008/2011.
• Strong Power BI, Power Pivot experience for data transformation, data visualization.
• Strong data management and reporting experience on quantitative analysis.
• Professional experience with advanced SQL Server 2008/2014 Database server installation, login and user creation, role and permission configuration.
• Professional experience loading a variety of large volume data files into SQL Server 2008/2014 database tables, and generate report with SSRS.
• Experience in 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 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 initiative, and hard worker. Willing to take responsibilities.Architect role for data warehouse including logic and physic table design, choose and decide dimension tables and fact table, choose the primary key and foreign key. Design and create Multidimentional OLAP - including create data source view and build hierarchy and cube using SSAS. Create data mart for claim management domain including design SSIS package to extract data from different data source including flat files, excel, oracle, and remote SQL SERVERS, transfer different data type to one data type then load into data mart. Create tabular data model to facilitate a fully automated SSRS and power PI requirement.
• Created ETL packages using SQL Server 2008/2014/2017 and Visual Studio 2010/2012/2015 SSIS Designer to extracted data from flat file, reformat the data, and inserted 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/2014/2017 and SSAS of Visual Studio 2010/2012/2017 , created data source/data source view/cube with measure and dimensions, configured attributes of dimension table with hierarchy relationships, 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/2014/2017 and Visual Studio 2010/2012/2015 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.
• Azure data warehouse creation including create server, database server firewall configuration. Loading azure DW using data factory.
• Conceptual/logical/physical data model design. Data flow diagram. Created table with primary key/ foreign key/index.
• Database code design, review, and optimization. Create Tables, Views and Stored Procedures in MS SQL, SQL server configuration and management.
• Configured Oracle SQL 10g/11g and SQL Server 2008 database, adjusted the memory usage and file size.
• Created database tables with various constraints including primary key, foreign key, etc.
• Loaded data from flat data files and excel sheet into Oracle database using SQL Loader and SQL Developer; Loaded data from flat data files into SQL Server 2008 database tables using BCP, bulk insert, and table export/import.
• Extracted data from SQL Server 2008 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 functions.
• Generated variety of business reports using Crystal Report 2008, SQL Server 2008 SQL query, SSRS, Access2007/2013, and Excel 2007/2010/2013.

TECHNICAL SKILLS

Database: Azure database, SQL Server 2008/2014, Oracle 10g/11g, MSBI 2008/2012, SSIS, SSAS, Access 2007/2010.

Reporting: SSRS, Crystal Reports 2008/2011. Language SQL, VBA. MS Office Word, Excel, PowerPoint, Access.

PROFESSIONAL EXPERIENCE

Confidential

Senior BI Developer

Responsibilities:

• Collaborated with enterprise data warehouse, data governance, and business teams on data quality issues, as well as architecture or structure of data repositories.
• Created and maintained data visualizations that educated, informed and engaged business partners on key metrics and performance measures.
• Work in a consultative role to provide automated ETL, incremental Database refreshment solutions, as well as data extraction from variety of data sources including SQL, Oracle, Elasticsearch, Apps, Sharepoint for Power BI Report.
• VBA coding for excel data automation, power query M language for advanced query editing in Power BI.

Confidential

Business Intelligence Analyst

Responsibilities:

• Create azure data warehouse, migrate data base from on-premises server to azure data warehouse.
• Architect role for designing ETL strategies, create data bases, Schemas, tables.
• Design and script ETL packages dealing with different data sources and loaded data into target data destination by performing Execute SQL Task, Execute Package Task, conditional split, Script component, union all and Lookup using Visual Studio 2015, creating staging schema.
• Automation of ETL packages, and downstream dashboard and reports which are trigged by data source refresh.
• Data quality control for upstream ETL processes and downstream reports and Dashboards.
• Create interactive visualization dashboard using Power BI and using DAX to modify columns, to create measures, variables, virtual tables.
• Generated reports with complex SQL queries including table join, subquery, group function and other T-SQL syntax. Develop various reports, such as tables, matrix, graphics, and dashboard reports, with drill down, drill through and sub report features by using Visual Studio 2015 Report Designer or Report Builder.
• Generated reports from Oracle data base using Crystal Report and SSRS.
• Involved in Data modeling to create data warehouse. Create tabular models to facilitate Power BI and SSRS report,
• Financial analysis for business decision maker. HEDIS data analysis for public medical decision maker.

Confidential

Business Intelligence Developer

Responsibilities:

• Involved in logical and physical data model design and creation of data flow diagrams.
• Database code design, review, and optimization. Create Tables, Views and Stored Procedures in MS SQL, SQL server configuration and management. Involvement and support of development life cycle and release process of ETL and report packages.
• Provide data flow diagrams and documents the process.
• Designed ETL packages dealing with different data sources and loaded data into target data destination by performing Execute SQL Task, Execute Package Task, conditional split, Script component, union all and Lookup using Visual Studio 2012/2015
• Developed SSAS project using SQL Server 2012 and Visual Studio 2012, created data source view, cube, and established hierarchies and attribute relationship. Created data-mining solutions, deployed them to SSAS instance.
• Load database using Bulk insert and BCP.
• Generated complex reports use complex SQL queries including table join, subquery, group function and other T-SQL syntax. Develop various reports, such as tables, matrix, graphics, and dashboard reports, with drill down, drill through and sub report features.
• Create and automation of Access reports and forms. Maintain SQL databases, Monitor eDocket performance by scripting a set of complicated SQL queries. Transformed tables by pivoting table.

Confidential, Indianapolis IN

Responsibilities:

• Administered the MS SQL server 2008 by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, granting the privileges to users.
• Logical and physical data model Design of relational DB and data warehouse. Created biological databases, used different biological databases cross-reference other database with primary key, foreign key and linked their related knowledge together in cartilage Kidney gene therapy research. Designed and create Data Source View and Cube using Visual Studio 2010’s SSAS.
• Remotely logged in Server and worked on distributed databases.
• Created packages, jobs and sending alerts using SQL mail, database backup, and recovery.
• Successfully loaded the data from RNAseq and Microarray experiments to SQL Server and analyzed and explained the result using SQL Server 2008 and BIDS for Visual Studio 2010.
• Retrieved and modified data using SQL Server 2008 and BIDS and acquired disease information from different database.
• Designed data warehouse and analyzed the relationship of disease, gene expression, and metabolism pathway.
• Administered oracle database by creating user logins with appropriate roles, creating tables.
• Used SQL Loader to Load experiment data into Oracle database and using SQL Developer and Putty to query and analyze data.
• Used Crystal Report to produce dashboard, sub-report, drill-through, drill-down reports.

Confidential

Research Associate

Responsibilities:

• Built access data base, loaded data from excel.
• Designed and created bound and unbound form which were used for clinical and animal experiment data collection using Access.
• Created navigation and sub-forms and auto-connection between sub-forms.
• Automated data analysis and report processing by using VBA.