SQL Developer

Professional Summary

Five plus years of IT experience in Software Development, Banking and Financing and Support of MS SQL Server 2005, MS SQL Server 2008, Oracle 11g, Test, Development Replication & Cluster Server Environments

Experience in working with Operating System such Linux(Ubuntu) and Windows OS (7/2003) administration activity and Security

Excellent knowledge using the Dictionary Tables (system tables and system stored) procedures using T-SQL

Strong experience with Object-Oriented Programming with C#.NET

Good Hands on programming with JAVA and C++

Good Hands on experience with Performance tuning, query optimization

Experience with SQL Server 2005 and MS SQL Server 2008 and worked extensively on Integration services (SSIS), Reporting services (SSRS)

Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints and Good Hands on dimensional Modeling concepts

Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Rules, Defaults, user defined data types and functions

Experience with SQL Server 2005/2008, DDL/DML Triggers, Database Mirroring Concept, Migration, Up-gradating process

Good Hands on experience with Security implementation worked hands on with creation and maintenance of databases, creating roles and managing user permissions

Experience in migration of Data from Excel, Flat file, Sybase, Oracle to SQL Server by using various Loading technique such as BCP.

Good Hands on experienced in the installation and configuration of SQL Server 2008

Experience in Database backup and disaster recovery procedures

Experience in MS SQL Server upgrades from 2000 to MS SQL Server 2005 and from 2005 to MS SQL server 2008

Design and document Logical and Physical data models using various tools like Erwin and Visio

Good hands on using the Custom ETL process using the SSIS and TSQL process and provided support for large ETL integration process.

Has Knowledge of SQL Server Analysis Services (SSAS)

Has very strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.

Good hands on experience with production support on Large VLDB instance and provided support 24x7 on level1 and level2 support

Worked with OLAP and OLTP application good hands on working with Data Mart, Data warehouse application provide support for BI reports for daily, weekly and monthly reports.

Good hands on experience with large volume data integration, cleansing, transformation operation and worked with building scalable solution using SQL Server technology

Proficient with creating Use Cases, Sequence Diagrams, Component Diagrams, Collaboration Diagrams, Activity Diagrams, and Class Diagram

Good knowledge of various mathematical modeling methods for financial derivatives and risk modeling, hedging.

Good hands on experience in Insurance Sales and Marketing domain

Excellent communication, presentation and interpersonal skills Strong troubleshooting and organizational skill

Has the ability to work in a fast paced environment, Good team player and can work independently. Helped the database developers on technical issues

Self learning ability and Leadership Quality

Technical Skill Set

Operating Systems Windows 2003 Server, Windows 2000, Windows XP, Windows Vista, Windows 7, Linux

MS SQL Server components/environment SQL Server Management Studio, Business Intelligence tools (SSIS, SSAS, SSRS), Crystal Report, BO, Performance Tuning, Capacity Planning, Database modeling by using Erwin Data modeler

Languages C, C++, SQL, T-SQL, PL-SQL, Visual C#, Python, VBA, HTML, PHP, JAVA. JAVA Script, XML

RDBMS SQL Server 2005/2008,MySQL,MS Access, My SQL

CASE Tools Erwin, Visual Studio, .NET, C#, VB.NET, ASP.NET, JAVA, Eclipse, Perl & Shell scripts, MATLAB.

Database Query Tools MS SQL Server Query Analyzer, SQL Profiler, SQL Server Management Studio (SSMS).

Professional Experience

Cook County Chicago – Chicago, IL October 2010 – Present

Cook county has around 40.5 percent of all Illinois residents. Cook County's population is larger than that of 29 individual US states and the combined populations of the seven smallest states. There are over 130 incorporated municipalities in Cook County, the largest of which is Chicago, which makes up approximately 54% of the population of the county.

Database Consultant

Wrote T-SQL statements using DDL and DDL for retrieval of the data

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

Provided 24x7 production support for the US client's mission critical database environments

Created databases, tables, stored procedures, indices, foreign keys and any other objects within the databases based on requirements from Developers

Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2008.

Verified the technical accuracy of documentation

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

Created and managed schema objects such as tables, views, index, and procedures

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

Supported Development Team in deploying and testing the application, which uses SQL Server backend

Monitored growth of data and managed space allocation accordingly

Environment: MS SQL Server 2008/2005, T-SQL, MDX, Web Services, C#, Visual Studio 2005, Oracle 10g/9i,Excel VBA, Microsoft SharePoint Foundation 2010, FAST Search Server 2010 for SharePoint, Microsoft Office SharePoint Server 2007 (MOSS 2007), Windows SharePoint Services 3.0 (WSS 3.0),Performance Point Services (PPS), SAS Performance Management, SharePoint Portal Server 2003, SharePoint Portal Server 2001, SharePoint Team Services, SQL Server Management Studio, OLTP, OLAP, Stored Procedures, SQL Server reporting services (SSRS), J2EE 1.4, Web logic 9.0, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Crystal Reports, Office, Excel, Windows XP, Unix (AIX).

Harbin Bank – Harbin, China September 2009 – August 2010

Harbin Bank is a Commercial bank, It was established in 1997 as Harbin City Commercial Bank, opened its branches in Harbin City only, but changed its name to Harbin Bank in 2007 and has since opened branches in Dalian, Tianjin Shuangyashan and Jixi

SQL Server Developer

Developed stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction

Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server

Configured, tuned, and optimized SQL Server 2008

Involved in requirement gathering, analysis, design, development, change management, deployment and user training

Designed and analyzed databases

Created Windows applications that gets all data from SQL Server and displays in DataGrid by C#

Used C#.NET to create applications that connects to database and downloads all the columns into DataSet

Login and User Management: Adding logins, roles, groups to the Window NT and MS SQL Server and maintaining proper security procedures

Proactive and Reactive tuning of databases in every stage of the project

Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery

Involved in System testing

Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers

Environment: MS SQL Server 2008,SQL Server 2005 Enterprise Edition, OLTP, OLAP,T-SQL, MDX, Web Services, Excel VBA, Microsoft SharePoint Foundation 2010, FAST Search Server 2010 for SharePoint, Microsoft Office SharePoint Server 2007 (MOSS 2007),Performance Point Services (PPS), SAS Performance Management, Oracle 10g, ASP.NET, MS Access 2007, T-SQL, and SQL Server 2005 Manager Studio, T-SQL, SQL Analyzer and Enterprise Manager and SQL Agent.

Harbin Anzhixin Technology Co. Ltd – Harbin, China June 2007 – September 2009

Database Consultant

Developed and maintained Database administration with SQL Server 6.5/7.0/2000

Developed stored procedures, advanced queries, trigger, views, indexes by using T-SQL

Maintained databases, configured permissions, and conducted backup and recovery

Performed daily administration, monitoring, and documentation of SQL Servers

Responsible for tuning data, indexes, and queries

Provided assistance to development teams on tuning data, indexes and queries

Automated and enhanced daily administrative tasks, including space management, backup & recovery and performance monitoring

Environment: Windows NT, Power Builder, Excel VBA,MS SQL Server 2005, SQL, T-SQL, .NET, SQL Query Analyzer, Profiler, XML, Web logic, Java, Cognos, JavaScript, Erwin, VSS.

EDUCATION

Heilongjiang University – China

• Bachelor of Science

Contact this candidate