JOB OBJECTIVE:

An energetic professional with a positive outlook, seeking higher level of opportunities (SQL Developer /Oracle Developer /T - SQL /PL-SQL /PostgreSQL; Data Architect; ETL/SSIS/SSRS/SSAS Developer; BI /Data Warehouse Developer)

SUMMARY:

• I am a SQL /MSBI developer with more than 15 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.
• 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
• R Programming

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

COMPUTER SKILLS:

Database: SQL Server 2005/2008/2012/ 2014 ; Oracle 10g/11g; Access 2007 /2010/ 2013

Reporting: MS-Access 2007; SSRS/ReportServer/ Data-Driven Subscription; SAP Crystal Report 2008; SAS BI

ETL: SSIS; T-SQL; BCP

Cube /Data Warehouse: SSAS (SQL Server 2008R2 & 2012 &2014)/ Cube creation/ Partition/ Calculation

Tool: SSMS; DTS; MVS 2010/ 2012/ 2013 ; MS TFS 2010/ 2012; BIDS Studio and Excel

Language: SQL; T-SQL; Excel Visual Basic; C#; MDX; VBA; PL/SQL

Intranet: MS SharePoint 2010 /PerformancePoint Services

MS Office: Word; Excel; PowerPoint; Note; Access; SharePoint 2013 Online /SharePoint 2010

Windows: Windows 7/XP/2008 server.

PROFESSIONAL EXPERIENCE:

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

Confidential, Minneapolis, St Paul

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
• 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
• 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
• Many flat files needed to be loaded into database, so a staging table created is needed
• All files must to be moved to Archive folder in another server after loading
• All files must to be renamed with adding the current date when moving into the new location
• Package should be scheduled automatically run about twice or more per week

Sr. Data Analyst

Confidential

Responsibilities:

• 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

ETL Data Analyst

Confidential, New Jersey

Responsibilities:

• 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