Job Objective:

An energetic professional with a positive outlook, seeking contract or direct placement career opportunities SQL Developer/SSRS/SSAS/SSIS Developer BI Developer Data Warehouse Developer

Highlights of Qualifications:

• Extensive experience in SSRS, SSIS, SSAS SQL Server 2008R2/2012 , SharePoint/configuration/report deploying and Crystal Report 2008.
• Exceptional knowledge of Access 2007, Oracle 10g/11g , Data Mining, Data Mart, Data Warehouse and MDX as well as T-SQL and PL/SQL
• Excellent understanding of database structures, principles, theories and practices Proficient in Microsoft Visual Studio, SQL Server Enterprise Management Studio, Toad for Oracle 11g, Oracle Developer and Excel/PowerPivot/Data Mining
• Excellent grasp of data warehousing and such processes as extracting, transforming and loading ETL Good communication and organizational skills
• Excellent in teamwork environment able to communicate clearly and get along well with other coworkers Outstanding ability to handle multiple projects

Computer Skills:

• Database: SQL Server 2008R2/2012 Oracle 10g/11g Access 2007 /2013 and SQL Server Administrative
• BI Tool: Access 2007 Microsoft BI stack included SSIS/SSAS/SSRS SAP Crystal Report 2008 SAS BI
• ETL: SSIS T-SQL
• Language: SQL T-SQL Excel Visual Basic C PL/SQL
• Intranet: MS SharePoint 2010 /PerformancePoint Services
• MS Office: Word Excel PowerPoint Access

SUMMARY OF SELECTED ACHIEVEMENTS ON BUSINESS INTELLIGENCE /SQL SERVER

I am a SQL /MSBI developer with more than 10 years experiences in the IT database /data warehouse industry. I have been working on Microsoft Stack mostly with SQL Server /MSBI tools as a developer for the last 10 years. I have excellent technical skills and communication skills especially in writing . I have either independently worked on project by project or team-work on some big projects for the industries in Transportation, Telecommunications, Healthcare, Manufacture and Financial industry for many years and handled multiple tasks with confidence while successfully delivering the creative of BI solutions to businesses. I have advanced data analytic skills and extensive experience with MSBI especially SQL Server 2008R2 and SQL Server 2012 . Also I have strong ability in writing SQL code Transact-SQL /Stored Procedure as well as the deep understanding of the logical /physical of database /data warehouse.

PROFESSIONAL EXPERIENCE PROJECTS SUMMARY

SSIS/SSAS/SSRS/SQL/BI Data Warehouse Developer

Confidential

Responsibilities:

• Designed, developed, integrated, completed, supported and maintained all reports for customers Involved in Migration from heterogeneous sources including Oracle to MS SQL Server
• Generated periodic reports based on the statistical/dynamic analysis of the data from various time frame monthly/quarterly/yearly and division using SQL Server Reporting Services SSRS
• Generated variety of business reports Enterprise Reports using SQL Server 2008 SSRS including matrix report, parameter report, dashboard with charts, drill-through 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
• Using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS and Crystal Report
• Created complex ETL package using SSIS to extract data from multi-sources and scheduled jobs to automatically run
• Created numerous simple to complex queries involving self joins, correlated sub-queries, functions, trigger, cursors, dynamic T-SQL as well as writing Stored Procedures as necessary to meet business requirement
• Utilized T-SQL on a daily basis in creating customs view for data and business analysis
• Tuned and optimized queries by altering database design, analyzing different query options, and indexing strategies
• Optimize existing T-SQL code
• Utilize Dynamic T-SQL within functions, stored procedures, views, and tables
• Customized script utilizing expressions and C scripting to enhance tasks in SSIS package
• Excellent knowledge in creating MDX cubes and dimensions using star snow flake schemas
• Expertise in performance tuning and trouble shooting on database objects and Expert in defining and deploying Cubes using SQL Server Analysis Services SSAS
• Used slowly changing dimensions methodologies to maintain the history of the data using SSAS
• Involved in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data
• Involved in Analyzing, designing, building, testing of OLAP cubes with SSAS and in adding calculations using MDX
• Working with Microsoft Dynamics CRM 2011. Demonstrated the functional aspect of Microsoft Dynamics CRM 2011.
• Modules of CRM Marketing, Sales and Services
• Software and Hardware requirements
• Setting up Microsoft Dynamics CRM 2011
• Use of Reporting
• Setting Security Roles
• Creating Product Catalog
• Managing Contracts
• Creating services and service resource for service scheduling
• Using Email, Contract and Article Templates
• Familiar with Settings modules for CRM Administrator
• Microsoft Dynamics CRM 2011 Customization
• Entity Customization
• Form Customization
• View Customization
• Writing Client side scripts
• Using MS Access 2007 to generate business reports
• Developed and Optimized Stored Procedures, Views, and User-Defined Functions for the Application Coordinated deliveries of project milestones with other company employees to ensure release dates are met. Updated and maintained documentation for all applications developed as needed
• Recent Project Demo I
• Business financial requirement:
• Design SSRS report and print the report as payroll check
• Use Week Number as parameter the report should contain report name, payroll check number, line amount and date
• The payroll check printing every other week The payroll check number may be not in order must greater than the last biggest printed check number and the check date must to be set to two weeks after the work date
• In order to build the SSRS report, I created two stored procedures:
• Using three parameters: WeekNumber, LastCheckPrinted and CheckDate Using ISNULL and MAX fn to find and define the number of the last check that was printed Creating records in the PayrollChecks table for the hours worked in the the selected week by using table-join and SUM, CONVERT and DATEPART fn Updating the PayrollCheckNumber field in the TimeEntry table Using DATEADD to set the CheckDate two weeks after the work date Then select all of the records added to PayrolChecks table.
• In order to pass the value to WeekNumber from another dataset , I created the 2nd procedure: using CONVERT, DATEPART and ISNULL fn, and WHERE clause, ORDER BY to return WeekNumber value.
• Building the report: Creating two datasets from the stored procedures above Setting WeekNumber as parameter and passing the 2nd dataset value into the parameter Using custom-code to calculate its tax deductions in the report-level Using the expressions to set Line Amount values Using the Global PageNumber as its page number Then deploying the report. The report is now ready to print as a payroll check.
• Recent Project Demo II
• Business requirement:
• Show top five sales by state
• Show bottom five sales by state
• Chart with function on Click
• Subreport must break at a custom-row number by users
• Prefer colors of OliveDrab and Khaki appear on Subreport for every other row
• This was a typical task for building a dashboard report:
• Creating a dataset for the subreport by using inner-join tables and where clause and set STATE as parameter Adding PageBreak as another parameter Building the report from the dataset Adding a parent group by setting its expression on using CEILING fn to define PageNumber value Using Rownumber and Mod fn to deliver the custom-color-rhyme on rows for the subreport.
• Using inner-join tables to return the values they wanted as dataset Building the dashboard report from the dataset Creating placeholder value for STATE and Using Action fn to connect to the subreport Functioning the chart-adding the total value SUM into the chart and choosing category group by state and again using Action fn to connect to the subreport Set Interval as 1 to show all states in the chart X-axis so that bringing an option for users they can click on any state between top-5 and bottom-5 to see details.
• Recent Project Demo III
• Business requirement:
• Many flat files needed to be loaded into database, so a staging table created is needed
• All files must to be moved to another location after loading
• All files must to be renamed with adding the date when moving into the new location
• Package should automatically run every day
• In this case, the directory for the set of flat files was confirmed, so Foreach Loop Container could perfectly apply the same control flow task to each file.
• Building SSIS package:
• Dragging a Foreach Loop Container and configure it Choosing Foreach File Enumerator and the folder path in the Collection section Dragging Data Flow Task and configure it Creating a connection manager to connect to the flat files location Setting FileName, FileLocation and DestinationLocation as variables and variable-values In the Connection Manager Property, using expression to set up its Connection String Creating a staging table in Management Studio Dragging Flat File Source and configure it then connect to OLE DB Destination Then dragging File System Task into Foreach Loop Container and configure it and in the DestinationConnection Property, set expression with conversion, DatePart and GetDate fn in order to remove and rename the flat files from one location to another to define its ConnectionString The SSIS package completed and ready to deploy The last step Scheduling a job for automatically run the package under SQL Server Agent in Management Studio.

Sr. Data Analyst

Confidential

• Working for the networking and telecommunications equipment factory, taking the data analytical responsibilities
• Involved in Migration from heterogeneous sources including Oracle to MS SQL Server
• Extraction, Transforming and Loading ETL using For Each Loop in SQL Server Integration Services SSIS Developed and Optimized Stored Procedures, Views, and User-Defined Functions for the Application
• Development of custom scripts and stored procedures for data import and manipulation
• Created tables with various constraints including primary key and foreign key create SSIS package both design and code to process data and scheduled jobs to automatically run created stored procedures, indexes, user defined functions as needed created data mining solution in BIDS created logging in SSIS
• Wrote the ETL scripts to load data into database from various data source files. Migrated data from Heterogeneous Data Sources and legacy system DB2, Access, Excel to SQL Server databases using SQL Server Integration Services SSIS to overcome transformation constraints
• Delivered reporting timely utilizing SSRS and Crystal Report 2008 Assisted with documentation and code deployments from Development, QA and Production environments
• Case for Analyzing and optimizing query performance IV
• The real-world query is just simply like the following one:
• Create Procedure uspGetContacts LastName nvarchar 50 ' 'AS
• SELECT BusinessEntityID , FirstName , LastName , EmailPromotion , Demographics , ModifiedDate
• FROM Person . Person
• WHERE LastName like ' ' LastName ' '
• It looks the query is to search for a string of characters insider a string of characters. Actually, in this case, it was to implement logic where by the value of last name could be omitted and all contacts returned. By setting the LastName variable to an empty string allows the stored procedure to run with a specified last name value or with no last name value specified. As a result, the stored procedure will only return matching rows or all rows. Therefore, the query looks fine without any question.
• But NO. Every time when this query runs, a full scan will occur, even when one is not necessary. The code was similar to the one in a production system that scanned more than 36 millions rows when running.
• So when the manager asked me to optimize the query performance, I wrote a bit more code and save the database system a significant amount of processing a T-SQL query similar like the one as following :
• Create Procedure uspGetContacts LastName nvarchar 50 ' '
• Conclusion: using some conditional logic in the stored procedure can save a large amount of overhead any time when the procedure is run with a specific last name value.
• Case for the SSAS project V
• As we know, the fact tables hold measures, which are the numeric columns that will be used on reporting. The dimensions hold the columns in which we'd like to filter the data.
• That was a big project. Here I'm just to demo some key points for the creation of KPI.
• The management team had identified the goal of 15 growth for sales revenue year over year. If current sales revenue is over 95 of the goal, sales revenue performance is satisfactory If the sales revenue is within 85-95 of the goal, management must be alerted If the sales revenue drops under 85 of the goal, management must take immediate action to change the trend.
• When I completed the basic of the creation on new KPI page, by using the ParallelPeriod fn to get the previous year time members for each current year time member, I wrote the following MDX to translate the sales revenue goal to increase 15 over last year's revenue into the expression:1.15
• Measures . Sales Amount ,
• ParallelPeriod
• Date . Fiscal . Fiscal Year , 1,
• Date . Fiscal .CurrentMember
• In the Status section of the KPI template, I selected the Traffic Light indicator and programmatically associated the KPI Status with the graphical indicator by the following MDX:CASE
• When kpiValue Sales Revenue KPI / kpiGoal Sales Revenue KPI > .95Then 1
• When kpiValue Sales Revenue KPI / kpiGoal Sales Revenue KPI .85
• The MDX defines for Status by returning a value between -1 and 1. The KPI browser displays a red traffic light when the status is -1 and a green light for 1, yellow light for 0.
• The next, I again wrote another MDX to compare current KPI values with last year's values from the same time period and to calculate the TREND indicator of the KPI by using CASE fn.
• The KPI creation was completed and then deploying.

ETL Data Analyst

Confidential

• Working closely with Project Managers, involved in planning, designed and developed by using DTS tool of extracting, transforming and loading data ETL
• Based on the business of Air/Ocean Cargo, created new database objects as necessary used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures Working closely with team member to write T-SQL for data manipulation and validation unit test , to create various snapshots and materialized views for remote instances
• Upon the request for business purpose, doing data cleansing
• Well versed in ETL processes, performance based systems, and ETL process flow and standards
• Possess excellent team management, communication, and analytical skills
• Assisted with documentation as needed

PROFICIENT SKILLS

• Advanced analytic skills and extensive experience with MSBI SQL Server , Access, SAP Crystal Report and Oracle. Plus, SAS Enterprise Guide 4.3 and SAS BI. Expert in designing and implementing relational database model as per business needs
• Expert in creating indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions CTEs and Triggers to facilitate efficient data manipulation and data consistency
• Personal and group work organization coupled with time management skills Excellent communication and project management skills
• Multiple complex tasks-handling and excellence in self-audit work Well-developed interpersonal skills with demonstrated ability to effectively interact with all levels within and outside of the organization
• Completion Course of CS1156X Learning from Data from California Institute of Technology Online program
• Completion Course of CS50X Introduction to Computer Science from Harvard University Online program
• Advanced Desktop Databases educated The University of
• MBA Program educated The University of Redlands San Diego, CA USA Bachelor Degree in Accounting, Wuyi University, China