OBJECTIVE:

BI Developer/ SQL Developer /Data Architect/DBA/Data analyst

SUMMARY:

• More than 8 years’ work experience in Insurance industry, Healthcare Company, Retailer, and Education System
• Experience on SSRS, SSAS, SSIS, SharePoint, SAP Database Objects BI, Crystal Reports, Tableau, Oracle, CRM, Sybase, PixelPoint POS
• Production support: process, analyze, diagnose, and trouble shooting
• Experience on SQL, TSQL (Stored procedure, function, trigger, and cursor)
• Experience on logical and physical design schema, data modeling, and creating Database, Data mart, and Data Warehouse
• Experience on creating and maintaining cube and data mining
• Maintenance of data warehouse for loading data daily, monthly and cube processing
• Worked on database of projects related to retailer, clinic trail, healthcare, insurance, finance, home and auto loan processing, school events, human resources, lawyer office business, and weblog
• Experience on automation, marketing campaign, data mining models and prediction analysis
• Experience on Team foundation server (Agile)
• Marketing campaign, customers predictive analysis
• Design, architecting, and maintaining database, data mart, data warehouse
• Creating and maintaining SSIS package, cubes, data mining models, SSRS report, Crystal Reports, dashboard and Power view report
• Work experience on SQL Server 2005/2008/2012 , Sybase, Oracle, Access 2007/2010 database and Data Loading and Reporting tools such as: SSRS, SSAS, SSIS, SAP Crystal Reports 2011/2013, Tableau
• Production support, troubleshooting, maintaining database server possess daily
• Installation and configuration of database and BI services ( SQL Server 2008/2012,SSIS, SSAS, SSRS, and Oracle 11g, 12c), creating database, partitioning of tables, creating indexes, login and user creation, role and permission configuration
• Migration and upgrade of database and BI solutions
• Worked on auditing and monitoring database validation using stored procedure, trigger
• Worked on performance tuning, query optimization, and database optimization by optimizing code, creating index, trigger, automation procedure and partition
• Worked on maintaining and monitoring database performance by creating customizing logging, SQL profiler, and check points. SQL server maintenance plan backup/restore, and partition
• Experience on load variety of large volume data files into SQL server 2008/2012 database tables, migrat e Oracle tables into SQL Server 2008/2012 database tables and generate Report with SSRS
• Installed, configured, and maintaining Virtual machines for windows
• Installed and configured the integration of QA developer with report viewer
• Translating business requirements into conceptual, logical, and physical data model
• Architecting data modeling using ER diagram, Dimensional/Hierarchical data modeling, Star Schema modeling, Snowflake modeling
• Designed star schema data warehouse to convert Sybase OLTP to SQL server OLAP model using SSAS
• Architecting and implementing BI solutions:
• Crated SSIS package to load data to data warehouse and monitor performance
• Created cube, data mining in SSAS for report and predictive analysis
• Created database, table with constraints
• Extracting data from different Data Sources (SQL database, oracle, FTP, flat file, Access, etc.)
• Loading data into various destinations (SQL database, flat file, excel, etc.)
• Transforming data following business requirements, creating mappings and workflows, using various Data Flow elements: Derived Column, Aggregate, Row Count, Data Conversion, Lookup, Merge, Union, Conditional Split, etc.
• Used system variables and created user defined variables
• Scheduled job and deployed SSIS package
• Monitored and troubleshooting using SSIS logging and Event Handler, Precedence Constraints, Break Points, Check Points, Logging, etc.
• Created various types of reports, managed report security, deployed and developed web reports using SAP Crystal Reports, Tableau, Excel and SSRS (SQL Server 2008R2/2012)­
• Created SSRS report
• Created Crystal Reports
• Created Tableau reports
• Created dashboard report using SSRS, excel with MS macros, and Tableau
• Create SharePoint report, power view report
• Migrated Jasper Reports to SSRS
• Migrated Crystal Reports to SSRS
• Built various report based on business requirements: matrix report, parameter report, dashboard report with charts and drill down function, cascading report, custom coded report and linked report, etc.
• Created datasets and cubes for reports using complex SQL Query ( T - SQL, Stored Procedure) and MDX
• Created and managed roles for security in SSRS reports, subscription report, and data-driven subscription reports on SSRS Report manager
• Creating pivot tables, dashboard, and charts in Excel using data sources (SQL Server, SSAS cubes, Access), PowerPivot, and SSRS list
• Created various report using Crystal Reports
• Created dashboard report using SSRS, excel, Tableau, and web reports in SharePoint
• Created SSRS package including datasets and customizing logging
• Created data mart, cube and large dataset view for data analysis, used SSAS and PowerPivot
• Created cube with measure and dimensions for reporting
• 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/SSDT, created large dataset and view, deployed them to SSAS instance
• Trained the model and queried the model using DMX
• Evaluated models and used ideal model for prediction of business
• Used excel2010 PowerPivot for data mining and analysis
• Installed, configured SharePoint, maintained services and settings
• Planed and designed SharePoint environment
• Created, modified, and maintained SharePoint accounts as directed and in compliance with all standard operating procedures
• Document SharePoint configurations and architectures
• Created Document Libraries, Content Types, RSS and Custom Lists , deployed SSRS report and excel report to SharePoint
• Created SharePoint power view report
• Advanced SQL queries with multi-table joins, group functions, single row functions, subqueries, Set operation T-SQL (Stored procedure, function, trigger, cursor) and Oracle PL/SQL
• Recursive CTEs, CTE, temp tables, derived tables, and effective DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications
• MDX query

COMPUTER SKILLS:

Databases: SQL Server 2005/2008R2/2012, Oracle, Sybase, CRM, Access

Reporting: SSRS, SAP Crystal Reports 2011\2013, Tableau, iReport (Jasper Report), web reports-ShorePoint2010, SSRS-Report Builder

Analyzing: SSAS, Excel 2007/2010 (Power pivot, Data mining, V Lookups, merge data, cross referencing), FlowJo DataAnalyzer, JMP,SAS

Language: SQL, T-SQL, PL/SQL, MDX , Visual Basic, MS macros, ASP.NET

Internet: MS SharePoint 2010

MS Office: Word, Excel, PowerPoint, Access, Outlook, Visio

Operating Systems and GUI: Windows Server 2008R2, Windows XP, Windows 7/8, Virtual Machine, VMware, SQL developer, SQL*Loader, TODA, Installation

Configuration and migration hands on skills: Microsoft SQL Server 2008/2012, SSIS, SSAS, SSRS, SharePoint 2010, Oracle11g, Oracle12c, Sybase, SQL Anywhere (10, 12)

WORK EXPERIENCE

BI Developer

Confidential

Responsibilities:

• Installed and configured PixelPoint POS Sybase and integrated Crystal reports viewer for end user, built and maintained developer for report test
• Design and architecting data mart for different departments
• Modified and maintaining marketing campaign mining models
• Creating reports with sub reports, parameterized reports, nested groups, complex formulas, running totals, summaries and conditional formatting
• Generating reports using tables, views, stored procedures
• Worked on performance optimization of various reports
• Automated reports for weekly, monthly and yearly schedule using Crystal Reports, VB and RDC (Report Designer Component) and delivered via Adobe PDF format. Exported reports to formats like PDF, Excel, and HTML
• Extracted data from Sybase, custom manufacturing Pixel POS application, using Crystal Reports
• Generated SSRS reports for department of Loss and Prevention
• Generated Crystal Reports for all departments in the whole retail company
• Troubleshooting and tickets solution on Crystal Reports
• Wrote complex code of hierarchy for SSRS report
• View codes and optimizing codes for performance tuning

SQL Developer

Confidential

Responsibilities:

• Maintenance of data warehouse for loading data daily and monthly
• Maintenance and development of cubes and dashboards, make sure the daily jobs are running and up to date
• Modified and maintained cube, SSRS pivot reports, and SSIS packages
• Created automation procedure for loading fact tables or dimension tables
• Reviewed code, troubleshooting SSIS package implement and SSRS reports
• Reviewed and modified the macro automation code to generate the end of month report using Access, DB2, Oracle and SQL Server
• Created store procedure, function, and cursor for optimization of production performance
• Production systems support, including the investigation and resolution of incidents, problems, service requests, and working assigned tickets
• Perform a follow-up consultation and documentation related to the handling and resolution of issues
• Maintenance of reports and documents on SharePoint site and TFS (team foundation server)

Business Intelligence Developer

Confidential

Responsibilities:

• Created, implemented and maintained over 63 SSRS reports while also customizing many reports to meet individual client needs
• Used ICD9 and CPT codes
• Created drill down, drill through, sub and linked reports using MS SSRS 2008, including matrix report, parameter report, dashboard report with charts, cascading report
• Generated cascading report and pass multiple values to parameters by User-Defined function
• Managed the subscription of the reports and data-driven subscription reports on SSRS Report manager
• Provided MS SSRS 2008 training and documentation to end user in order for them to develop their own ad-hoc reports
• Reviewed query and improved the performance of SSRS report

Data Analyst

Confidential, VA

Responsibilities:

• Created large data view from data warehouse using complex SQL queries. Built different mining models (e.g. decision tree, clustering, time series ) used historic data, evaluated models and mail campaign.
• Generated daily, monthly, and quarterly reports using SSRS packages and schedule job. Monitored performance by creating logging tables
• Installed, configured, maintained all components of SQL Server 2008R2 and SharePoint 2010 to support client's applications included monitoring, performance, environment stability and supported
• Documented installation, testing, configuration, analysis, report, and troubleshooting
• Reviewed SQL query plans and logs, optimized database performance to support the solution
• Generated SSIS packages, SSRS for end user
• Created, configur ed and customiz ed W eb Application, Sites including Site Collection, Lists
• Designed and maintained databases for basic and clinical research, created tables with constraints, maintained data integrity
• Gathered data from laboratories and clinical-associated research databases and data warehouse, cleansed and loaded data to SQL Server, Access and Excel
• Developed database programmer, wrote SQL queries with advanced group functions and sub queries
• Extracted, transformed, and loaded data with SSIS packages, schedule job
• Analyzed data using SSAS, FlowJo-DataAnalyzer, Excel, JMP,SAS
• Generated various types of reports (such as matrix report, parameter report, dashboard report, cascading report, and custom coded reports) according to the requirements of scientist and physicians using SSRS and Excel
• Developed and maintained databases such as performance tuning
• Deployed and maintained reports on internal SharePoint 2010