SUMMARY

• 5 plus years of working experience in IT industry as SQL developer with Computer Science background.
• Expertise in MS SQL Server with SSIS/SSRS 2008/2012, ETL.
• Extensive experience in developing Stored Procedures, Views, Indexes, Joins, User defined data types, Functions and other Complex Queries on SQL Server 2008/2012.
• Strong T - SQL skills including tune queries, assigning proper indexes, creation of cursors, triggers and stored procedures, Indexed views, User Defined Functions (UDF).
• Expert in creating, configuring and fine-tuning ETL (Extract, Transform, Load) workflows designed in DTS (Data Transformation Service) and SSIS.
• Experience in using variables, expressions, functions for the Reports and in handling Parameterized reports in SSRS.
• Experience with Database Backup and Recovery Procedures and also in Disaster Recovery (DR)
• Well experienced in SSIS packages, SQL Mail Setup, Jobs, and Alerts in MS SQL Server.
• Experience in using tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Experience in Testing SQL Server.
• Good knowledge of SSAS, SSMS
• Hands on experience with Java programming and using JDBC
• Experience with C#, .NET, MS Access, MDX Queries
• Experience with creating all types of reports and integrate multiple report definitions into a single report object.
• Familiar with Agile project and has the ability to work in a fast paced environment, Good team player and can work independently.
• Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and maximize performance, implementing technology solutions, and training supporting end users.

TECHNICAL SKILLS

Operating Systems: Windows XP, Windows 7, Windows 8

Database Technologies /Tools: MS SQL Server Enterprise Manager, Business Intelligence tools (SSIS, SSAS, SSRS), SQL Profiler, Data Transformation Services (DTS), MS SQL Server Query Analyzer, SQL Server Management Studio (SSMS), SQL Performance Monitor, Database Tuning Wizard, Event Viewer, Index Tuning Wizard, Upgrade Wizard, DML, Data Migration, Import/Export Wizard

Programming Languages: SQL, T-SQL, Java, XML, C, C++

RDBMS: SQL Server 2008/2012, MySQL, MS Access

Other Tools: MS Visio 2003, MS Office 2010

PROFESSIONAL EXPERIENCE

Confidential - Chicago, IL

Database Consultant

Responsibilities:

• Worked with Data Modeling and handling OLTP Databases and ability to design databases upon requirements.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Created daily queries involving self joins, correlated sub-queries, CTE and XML techniques for diverse business requirement. Tuned and optimized queries by altering database design, analyzing different query options, and indexing strategies.
• Created databases, tables, stored procedures, indices, foreign keys and any other objects within the databases based on requirements from Developers.
• Wrote stored Procedure, scripts, cursors for the bulk application, tested them on the test servers and moved them to the production.
• Created triggers to keep track of changes to the fields of tables when changes are made.
• Strong experience with SQL Server performance tuning and optimization, query optimization, index tuning, caching and buffer tuning.
• Create a Microsoft Access project and connect it to an existing Microsoft SQL Server database.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from Access, OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2008
• Designed and developed SSIS Packages (.dtsx files) to import and export data from MS Excel, Access, SQL Server 2005 and Flat files
• Worked on different kinds of Transformations in SSIS as per the client’s Requirement.
• Created Extract, Transform and Load (ETL) processes
• Designed and developed various complex reports such as Drill down, Drill Through, Cross Tabbed using MS Reporting Services
• Involved in design and deployment of Report Models for generating Ad-Hoc reports as per the client requirements
• Development of system maintenance tasks such as Database Backup & Recovery, database mirroring and replication and apply in Dev and Testing Environment
• Assigned permission to user(s), roles, and object. Administrate security for servers logins (Windows and SQL Accounts)
• Skills into maintaining, writing, debugging and testing code in applicable programming languages
• Monitored growth of data and managed space allocation accordingly
• Provided 24x7 production support for the US client's mission critical database environments

Environment: MS SQL Server 2008/2012, Visual Studio 2008/2012(SSIS, SSRS, SSAS), OLTP, OLAP, T-SQL, Excel VBA, MS Access 2007, and SQL Server 2012 Manager Studio, SQL Analyzer and Enterprise Manager and SQL Agent.

Confidential - Chicago, IL

Database Developer

Responsibilities:

• Involved in requirements gathering and knowledge transfer sessions.
• Collected requirements from the end user. Tried to learn more about it to gain clear understanding about the work we should do.
• Responsible for installing and configuring MS SQL Server along with Visual Studio on a network domain system.
• Created SQL Server Integration Services (SSIS) packages to export and import data from various sources systems to SQL Server 2012.
• Created the mappings using transformations such as the Derived Column, Union All, Pivot, Sort and Conditional Split.
• Used most of the tools in SSIS packages like looping, data formatting, check points, error handling, email notification etc.
• Deployed SSIS packages to production, schedule them to run on routine basis and monitor the error log for any errors.
• Created necessary queries. Tuned and optimized queries by analyzing different query options, and indexing strategies.
• Responsible for the development of the report layout based on the requirements of the end users.
• Various types of reports (Drill down, Matrix, and Navigating) with charts were created using SQL Reporting Services 2012 (SSRS).
• Created complex variables, expressions, parameters, predefined conditions, joins, multiple breaks, sorts in SSRS.
• Daily/Weekly/Monthly Reports were scheduled to be executed and sent to end users via email.
• Responsible for responding to end-user questions, requests and concerns.

Environment: MS SQL Server 2012, SSIS, SSRS, Import and Export Data Wizard, SQL Query Analyzer, Windows 7.

Confidential

Database Developer

Responsibilities:

• Involved in migrating data from various sources into the SQL Server 2008 using ETL (Extract, Transform, Load) tool SQL Server Integration Services (SSIS).
• Migrated from SQL Server 2008 to SQL Server 2012.
• All data were migrated to the staging server and then those data were later populated to the OLAP (Online Analytical Processing) Server to use with SSAS for analysis purpose.
• Involved in reporting solutions to improve asset management, incident management, data center services, system events support and billing.
• Successfully migrated data between heterogeneous sources such as flat file, Excel and SQL Server 2008 using SSIS, BCP (Bulk Copy Program) and Bulk Insert.
• Migrated all DTS (Data Transformation Service) packages to SQL Server Integration Services (SSIS) and modified the packages according to the advanced feature of SQL Server Integration Services (SSIS).
• Implemented and supported OLAP reporting user interface enabling ad-hoc queries and multidimensional views for data analysis.
• Monitored performance and optimized SQL queries for maximum efficiency and implemented fine tuning of database objects and server to ensure efficient data retrieval.
• Involved in creating SSIS process design architecting the flow of data from heterogeneous sources (flat file, excel, access) into target.
• Performed data mapping and transferred data from staging tables to database tables using SSIS transformations.
• Performed data consistency and performance tuning effectively with SQL Profiler, Index Tuning Wizard and improved data load performance by analyzing database design and query plans.
• Involved in designing database objects like indexes, views, user defined functions, triggers, stored procedure, constraints, and roles and documented all the procedures involved in the database for future reference.

Environment: MS SQL Server 2008/2012, SSIS, SSRS, Import and Export Data Wizard, SQL Query Analyzer, SQL Profiler, Window performance monitor, Windows 7.

Confidential

Engineer Trainee

Responsibilities:

• Dealt with documents such as sales contracts, order confirmations, purchase orders powers of attorney, cash expense vouchers and project protections.
• Translated some product information from English to Chinese.
• Doing some TA/secretarial tasks.