SUMMARY

• Over 7+ years of IT experience in Design and Development of SQL Server Database (SQL Server 2008/SQL Server2012) and SQL Server Business Intelligence.
• Hands - on experience in managing, monitoring and troubleshooting SQL Server 2008, SQL Server 2012.
• Up to par with performance, scalability, high availability, and security and compliance best practice guidelines in database design, performance tuning, implementation, and maintenance in a SQL Server 2008/ SQL Server 2012 environment.
• Knowledge in Dimensional modeling using Star Schema/Snowflake modeling concepts.
• Knowledge of building a Data Warehouse using Kimball/Inman strategies.
• Hands on experience with scripting in complex T-SQL in constructing Triggers, Tables, User Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity, Optimized Indexes and Statistics in relation to reporting data model.
• Extensive experience as SQL Server Developer in utilizing Stored Procedures, Functions, Triggers, Cursors.
• Expert in creating complex Stored Procedures, User Defined Functions, and effective Triggers to facilitate efficient data manipulation and data integrity
• Developed complex Stored Procedures to generate various Drill-through reports, parameterized reports, sub-reports and linked reports using SSRS.
• Extensive experience with legacy system data conversions.
• Experience in supporting large customer base, working directly with end-users and supporting all the requirement changes, issue tracking systems request and data related issues.
• Demonstrated talent for identifying, improving, and streamlining complex work processes through highly Analytical Thinking and analysis.
• Excellent communications skills for both highly technical and non-technical audiences
• Passionate learner with ability to quickly grasp and master new concepts and technologies.

TECHNICAL SKILLS

Databases: SQL Server 2008/2012, Oracle 11 g2

Operating Systems: Windows 2000/2003, Windows XP, Unix, Linux

Data Warehouse Tools: SSIS, SSRS, Cognos, Crystal Reports

Languages: SQL, T-SQL, C, C++, Java, C#

Source Code Control: Team Foundation Service, Visual Source Safe

Case Tool: MS visual Studio 2008/2012

Web Languages: HTML, Java Script

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

SQL Server Developer

Responsibilities:

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using Complex T-SQL in SQL Server.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports.
• Used SSIS packages for complete ETL process and loaded into Data Warehouse.
• Responsible for implementing ETL processes in a production data warehouse, relational and multi-dimensional data modeling.
• Created SSIS Packages to import and export data from and to SQL Server database.
• Identify critical integration issues and develop corrective solutions.
• Developed SQL Server Reporting Services SSRS as per client needs and requirements.
• Developed complex Stored Procedures to generate various Drill-through reports, parameterized reports, sub-reports and linked reports using SSRS.
• Used SSRS Subscription to generate the large set of reports.

Environment: Microsoft SQL Server 2008/2012 Enterprise Edition, SQL Server Integration Services tools (SSMS,BIDS and SQL Server Manager), Team Foundation Service, BIDS 2012.

Confidential, Chicago, IL

SQL Server

Responsibilities:

• Involved in Physical / Logical design of database, creating and managing the database and all the database objects. one database.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XML etc) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Created SSIS Packages to import and export data from and to SQL Server database.
• Performed various project tasks in the development life cycle including requirement, analysis, design, development, and testing for SSIS package.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Defined relationship between tables and enforcing entity referential integrity.
• Made changes to the existing Crystal Reports.

Environment: SQL Server 2008, ASP.NET, HTML, T-SQL, Crystal Reports.

Confidential, Salt Lake City, UT

SQL Server

Responsibilities:

• Normalized and De-normalized the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Rebuilding the indexes appropriately as the application design expanded with newly added modules.
• Created complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications by using T-SQL.
• Problem identification, troubleshooting, resolution, and index tuning databases.
• Converted Oracle PL/SQL to SQL Server.
• Created matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.

Environment: MS SQL Server 2008/2008(R2), Windows 2008 Server, TSQL, ASP.NET.

Confidential, Salt Lake City, UT

Database Developer

Responsibilities:

• Experienced in Creating simple to complex queries involving Joins, Correlated Sub queries and Stored Procedures as per business requirements.
• Active participation in and gathering requirements from workgroup meetings and making changes to existing logic as per business requirements.
• Creating connections to external Web Applications using simple and complex Stored Procedures, Views, Joins and Queries.
• Wrote and modified existing simple and complex procedures, Triggers, CTE’s and User-defined functions in SQL 2005/2008 environments.
• Experienced in Creating, loading, and modifying a new package or an existing package or add and configure components, making changes object by using Control Flow and Data Flow Tools and then verifying it. .
• Wrote the ETL scripts to load the data into database from various source files.
• Experienced in development of Test Cases in various scenarios around the SQL Code in Dev, QA and UAT environments.
• Used the SQL Server Profiler to monitor the performance of SQL objects mainly Triggers, Stored Procedures, Service Broker.
• Experience in managing Alerts, Creating Jobs, and Operators through SQL Server Agent.

Environment: MS SQL Server 2008/2008(R2), Windows 2008 Server,SQL Server Integration Services tools, TSQL, ASP.NET.