Professional Summary

• More than 19 years experiences in Information Technology industry, including system and database administration, network maintenance, storage and backup, SQL coding, application development and testing.
• More than 6 years experiences in generating reports by using Microsoft SSRS, Crystal Reports and Excel spreadsheet, scheduling and deploying reports using report manager.
• Strong experience in developing SQL scripts, stored procedures, triggers and functions.
• In-depth knowledge of complex Transact-SQL and PL/SQL. Power user of advanced SQL queries with multi-table joins, subqueries.
• Expert in creating indexes, views, complex triggers, effective functions and stored procedures to facilitate efficient data manipulation and data consistency.
• Professional experiences in loading variety of large volume data files into SQL Server 2012 or Oracle database, migrating Oracle data into SQL Server 2012 database .
• Solid hands-on experiences in extracting, transformation and loading ETL data using various tools including Bulk insert, BCP, Import/Export data, DTS/SSIS packages. Creating mapping / workflows to extract data from Oracle, SQL Server, legacy systems, and other data sources, and loading into various business entities in SQL Server database.
• Extensive knowledge of software quality assurance methodology, and hands-on experience in database/data warehouse testing.
• Sufficient skills of monitoring and optimizing report system performance by optimizing SQL queries, using report cache and snapshot.
• Solid knowledge and experiences of software development life cycle and project manage methodology.
• First hands-on experience with Microsoft SharePoint platform.
• Results-Driven with ability to take initiatives and meet deadlines in a fast paced changing environment Strong analytical and communication skills with the enthusiasm to learn new technologies

Technical Skills

Professional Experiences

Confidential

Position: Senior Microsoft BI / SSRS Developer , Consultant

• Extracting data from third-party application and mission critical ODS database, Gathering requirements, analyze data, develop and build SSRS reports and dashboard, supporting more than 50 USCC's vendors/partners' general business reports and benefit plan administration processes.
• Design and deploy USCC's employee/benefits census report, benefits statement report, enrollment count summary report, billing report and other insurance / payroll reports by using SSRS and SQL Server 2012.
• Designed and deployed various different professional reports with SSRS tools, utilizing Dynamic and Cascading Prompts, sub-reports, charts, parameterized reports, conditional and dynamic reports. Set up Advanced functions, dashboard, Drill-Trough/Drill-Down, KPI/Indicators in reports.
• Design Cube, import sales data into SQL database from various data sources such as Oracle and flat text files.
• Identify and analyze expensive T-SQL stored procedure by using the SQL Profiler, SQL analyzer, Index tuning wizard and running home-cooked SQL scripts, create the necessary indexes and SQL hints to improve query performance.
• Assemble and convert user requirements into standard reporting solution and customize specific user requests when necessary
• Manage and maintain stored procedures and standard reports. Build reports from Analysis Services cube using MDX query designer
• Configure report server and deploy reports on web server and SharePoint, build Performance Points Dashboards in SharePoint.
• Schedule and manage daily / weekly / monthly sales and operational reports based on the business requirements.
• Develop SQL queries, stored procedures, and functions. Investigate and optimize reporting system performance by optimizing queries, and using report cache and snapshot.
• Create ETL packages with SSIS tools to extract data from various source of record, transform and cleanse the data, and load the data into data warehouse
• Write, maintain and update technical documentation.

Confidential

Position: Senior Microsoft BI / SSRS Developer , Consultant

• Responsible for requirements gathering, status reporting, creating various metrics, project deliverables.
• Work closely with the data modeler and the DBA in the design of business intelligence solutions on the data warehouse.
• Build SSIS ETL packages to reformat data into fact and dimension tables and deploy the packages to SQL server instance.
• Create BI multidimensional cubes establish the star schema modeling and configure dimension tables with hierarchy relationships in SSRS.
• Identify KPI and build SSRS cubes using MDX query designer.
• Designed, developed, wrote, tested, and implemented SSRS reports with multi-parameter, chart, drill-down, drill-through, sub-report and interactive sorting capability for administration department, accounting department.
• 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.
• Developed T-SQL Procedures, Functions and Packages and used home-cooked Perl scripts to load data into the SQL Server 2005/2008 database.
• Developed Complex SQL queries using various joins and developed various dynamic SQL's thorough out the projects.
• Tuning long-running SQL Queries, Procedures, Functions and Packages using SQL Profiler, SQL analyzer, Index tuning wizard.

Confidential

Position: Microsoft SSRS Developer

• Design SQL queries, stored procedures, and functions for extracting data from SQL Server databases and Oracle Databases.
• Design ETL packages using SSIS, import data into SQL Server databases from various data sources such as SQL Server, Oracle and flat files.
• Gathered requirements, analyze data, develop and build SSRS reports and dashboard, supporting business partners department general business reports.
• Developed and implemented SSRS reports with multi-parameter, chart, sub-report and interactive sorting capability for administration and accounting department. Set up Advanced functions, dashboard, drill-trough/drill-down, KPI/Indicators in reports.
• Optimized reporting system performance by tuning SQL queries and using report cache and snapshot.
• Performed unit testing on reports generated with SSRS. Configured report server and deployed reports on web server and SharePoint.
• Managed and maintained stored procedures and SSRS reports. Scheduled and managed business operational reports based on the business requirements.

Confidential

Position: Senior IT Consultant

• IBM whole storage product line technical support, including DS8000 Series, XIV, NSeries OEM NetApp FAS , Storwize V7000, SVC, TS3500 Tape library, TS7650 Series Virtual Tape, TPC, TSM
• Conduct Storage infrastructure optimization consulting services
• Storage and backup solution design and implementation
• Project management on IBM storage solution key project
• Team technical skill build up, team knowledge base build up and maintain
• Conduct IBM pSeries Server advanced technical support to large accounts, including solution Design, capacity planning, technical presentation, installation, performance tuning, trouble shooting, upgrading, crisis handling and other consulting services on IBM pSeries and related storage technologies
• System Configuration Assurance
• Conduct IBM pSeries product professor services, including AIX planning, installation, upgrading, troubleshooting, performance tuning and product issue handling..

Confidential

Position: PC and Network Engineer

• Maintained and administered an IBM PS/2 using Unity software with OS/2 for a front end to integrate Trane Tracer 100, Honeywell Excel, Delta 1000, 2000 Building Automation/Management System for 1.2 million square footage building
• Implemented comprehensive Inventory control and record keeping system for purchasing service related parts for the Maintenance Department to increase the quality of service by 40 in a 440-bed trauma Hospital.
• Coordinated Activities, Operations, and Scheduling of Maintenance Personnel to motivate maximized effectiveness and morale of staff by assigning tasks related to their interest and promoting teamwork rather than competitiveness establish a higher level of productivity.
• Served as project troubleshooter, interpreting blueprints, and making final decisions on last minute design details and changes with Building Automation and HVAC systems in a 1.2 million-footage building.
• Tested newly written programs for any bugs, program weaknesses, strengths, and documented them for the programmer.
• Procured the parts necessary to assemble computers and build an entire network from the ground up for supporting the entire engineering department and allow the other departments to interact with the inventory to cut duplication of parts.
• Resolved hardware and software communication problems with newly installed Building Automation System for remote access, and local communications of the sub-panels.
• Enforced contract compliance carefully monitoring quality of both labor and materials.