SUMMARY

• Over 8+ 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.
• Over 5+ years of strong experience in BI Developer (SSIS, SSRS, SSAS) with strong knowledge in Data Warehouse.
• Worked extensively on system analysis, design, development, testing and implementation of projects (SDLC).
• Knowledge in Dimensional modeling using Star Schema/Snowflake modeling concepts.
• Knowledge of building a Data Warehouse using Kimball/Inmon 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.
• Highly experienced in Sub queries, CTE’s, joins involving multiple tables.
• Highly Experienced in writing Complex Stored Procedure and Functions
• Experienced in Performance tuning, and optimization of procedures and queries, SQL Server Agent.
• 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.
• Extensive experience in Business Intelligence in MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS).
• Have good experience with designing and implementing MDX queries, OLAP architecture, MOLAP, ROLAP.
• Experienced in writing Parameterized queries for generating Tabular reports, Formatting report layout, sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS SQL Server Reporting Services in Business Intelligence Development Studio (BIDS).
• 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 Server 2012 r2,Windows 2000/2003, Windows XP, Unix, Linux

Data Warehouse Tools: SSIS, SSRS, Cognos, Crystal Reports,SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, BIDS

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

Methodologies: Logical and Physical Database Design, Star Schema, Snow Flake Model, UML, Database Design and Normalization.

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

SQL Server Developer

Responsibilities:

• Developed complex programs in T-SQL, writing Stored Procedures, Triggers and Queries with best execution plan.
• Extensively worked on Views, cursors, CTE’s, schemas, permissions and performance issues with client/server database design.
• Involved in creating Databases, Tables, Views, Cluster/Non-Cluster Index, Unique/Check Constraints, Rules and Defaults.
• Extensively used Joins and sub-queries or CTE’s for complex queries involving multiple tables from different databases.
• Created new database objects likeProcedures, 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.
• Analysis of Big Data, identify the data sources in Cosmos Streams.
• Expertise in big data analysis and cosmos development retrieving the data through scope language.
• Developing reports using SQL (SSRS, SSAS) and Cosmos (Vizfx, Power BI, I-scope, Lensexplorer, Power BI and R-studio).
• Creating reports using Vizfxframework, with the processed telemetry data from Cosmos streams and SQL tables.
• Quick analysis of the telemetry data using I Scope and R Studio.

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
• 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.
• Wrote Stored procedure in SSRS
• Extensively worked on Views, CTE’s, schemas, permissions and performance issues with client/server database design.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Created OLAP cubes using SSAS and starch schema techniques
• Involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases. Created SSIS packages to Export data from text file to SQL Server Database.
• Worked on transformations such as Checksum in SSIS where all of the rows in table need to compared for an update
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Developed SSAS Cubes using Star Schema with partitions, aggregations, hierarchies and perspectives.
• 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,SSIS, SSRS

Confidential, Salt Lake City, UT

SQL Server

Responsibilities:

• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraintsetc. on various database objects to obtain the required results.
• SQL Server Index Maintenance Performance Tuning for Large Tables
• Microsoft SQL Server management and performance tuning. Focuses on index tuning, query modifications, partitioning and hardware optimization
• 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 toSQL Server.
• Created matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Developed, monitored and deployed SSIS packages.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Implemented and enhanced existing reports like Group By, Drilldown, Drill Through, Sub-reports, List, Tabular, matrix, navigation reports, standard parameter and cascading Parameter, Multivalve Parameters

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

Confidential, Salt Lake City, UT

Database Developer

Responsibilities:

• Created tables, views, stored procedure as per design needs.
• Maintained data integrity by performing validation checks.
• Optimized queries tuned and monitored server performance.
• Involved in Fine tuning of database objects and server to ensure efficient data retrieval.
• Monitored performance and optimize SQL queries for maximum efficiency.
• 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 (SSAS/SSIS/SSRS) 2008/2008(R2), Windows 2008 Server,SQL Server Integration Services tools, TSQL, ASP.NET.

Confidential

Database Developer

Responsibilities:

• Created Indexes, Views, Index Views, Constraints, Stored Procedures, User-Defined functions, CTEs and effective DDL/DML triggers to facilitate efficient data manipulation and data consistency.
• Optimized cubes by assigning appropriate storage modes to partitions and created usage based optimizations for better query performance.
• Created automated backup of OLAP cubes as well as normal backup using SQL server management studio.
• Created many stored procedures /functions and used them in reports directly to generate reports.
• Created SSIS package to load data from XML files and SQL server 2008 to SQL 2012 by using lookup, Fuzzy lookup, Derived columns, Condition Split, Term Extraction, Aggregate and slowly changing dimension.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and Data Mart Databases.
• Scheduled the monthly/Weekly/daily reports to run automatically onto the dashboard.
• Created various database objects like stored procedures, functions, tables, views.

Environment: MS SQL Server 2008 R2, T-SQL, SSIS, SSRS, Crystal Reports 10, MS office 2003, Windows 2000/2003

Confidential

Database Developer

Responsibilities:

• Involved in all phases of SDLC
• Used stored procedures for updating servers.
• Used DDL and DML triggers, Stored Procedures to check the data integrity and verification at early stages before calling them.
• Used SQL server Integration Services (SSIS) and its tools to Extract, Transform and Load data into Data Warehouse.
• Developed, deployed and Monitored SSIS packages.
• Created/Maintained clustered/non-clustered indexes for fast and efficient reporting process.
• Responsible for performance tuning of SQL Commands and troubleshooting of the technical problems in SQL server 2008 R2 with the use of the SQL profiler, Execution plan and Database Engine tuning Wizard.
• Was involved in performing the overall data transfer from the OLTP to OLAP with the help of SSIS.
• Performed performance tuning of stored procedures using the SQL server profiler.

Environment: MS SQL Server 2008 R2, T-SQL, SSIS, SSRS, Crystal Reports 10, MS office 2003, Windows 2000/2003