SUMMARY

• Around 7+ years of IT experience in the area of SQL Development, Integration Development using SSIS 2012/2008R2/ 2005 and Report Development using SSRS 2012/2008 R2/2005, Cube Development using SSAS 2008R2/2005.
• Involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects.
• In depth noledge of Relational Database Systems, Normalized and De - normalized data models, Dimensional data Models like Star and Snow flake schemas.
• Worked on several reporting and data analysis projects involving Finance and Sales Data.
• Experienced in creating Databases, Tables, Stored Procedure, DDL/DML, Triggers, Views, User defined data types, Cursors, Indexes, Derived Tables and Common Table Expressions (CTEs) using T-SQL programming to facilitate efficient data manipulation and data consistency.
• Good noledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Primary Keys and Foreign Keys.
• Experience in Extracting, Transforming and Loading (ETL) data
• Expert in Query Optimization and tuning the query, creating Indexes to improve the query performance.
• Expertise in Data Extraction, Transforming and Loading (ETL) between different System using SQL tools (SSIS, DTS, Bulk Insert, and BCP)
• Experience in SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Experience in database Designing/Modeling of new applications and database changes to existing applications.
• Upgraded the existing environments from SQL Server .
• Experience in creating jobs, Alerts, SQL Mail Agent, Database Mails and Scheduled DTS and SSIS Packages.
• Participates in Disaster Recovery exercises, QA Stress tests and testing and reporting during hardware/software upgrades.
• Knowledge on Replication Models such as Transaction, Snapshot and Merge in SQL Server 2005.
• Good in implementing SQL Server Security and Experience in Creating Roles and Assigning Permissions to the users.
• Extensive experience in developing, enhancing and maintaining web application.
• Great ability to write clear, maintainable, well-documented, commented and efficient queries.
• Excellent communication skills to discuss the projects wif technical and non-technical SME’s.
• Excellent communication skills, team player, quick learner and self-motivated.

TECHNICAL SKILLS

Languages: C,C++,C#,Core Java

Databases: SQL Server 2012/2008R2/2005,Oracle 9i,10g,11g

Reporting Tools: SQL Server Reporting Service (SSRS)

ETL Tools: SSIS(SQL Server Integration Services), DTS(Data Transformation Services), Import Export Data, Bulk Copy Program (BCP)

Other Software: MS Office, Microsoft Visual studio 2012, 2010 and 2008. Team Foundation Server.

Database Tools: SQL Server Management Studio(SSMS), Solution Explorer, Reporting Server, Business Intelligence Development Studio(BIDS)

Web Technologies: HTML, HTML5, DHMTL, CSS (2/3), JavaScript

Methodologies: Logical and Physical Database Design, Database Design and Normalization, Data Modeling

PROFESSIONAL EXPERIENCE

Confidential, Webster, NY

SQL Server Developer

Responsibilities:

• Created Databases, Tables, Stored Procedure, DDL/DML, Triggers, Views, User defined data types, Cursors, Indexes, Derived Tables and Common Table Expressions (CTEs) using T-SQL programming to facilitate efficient data manipulation and data consistency.
• Designing ETL packages dealing wif different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Worked on different kinds ofTransformations (Data Conversion, Lookup, Derived Column, For Loop, For Each Loop, Conditional Split, Look up, Slowly Changing Dimension, Union All)inSSISas per the clients Requirement.
• Increased the performance of the SSIS packages which is currently running in production.
• Developed stored procedures using T-SQL Transactions, Commit and Rollback. Used TRY CATCH for Error Handling.
• Developed and maintained SQL Server stored procedures to support reporting.
• Developed Summary reports, Trend Reports, Aging Bucket Reports to provide Monthly, Quarterly and Yearly Aggregates.
• Developed transactional level detail reports to provide most granular level details.

Environment: Windows, ASP.Net, ASP, MSSQL, VBScript, JavaScript, MS access, Html, XML, BCP, DTS Import/Export, SQL Agents, SQL Mail, SQL Server Management Studio, SQL Server Integration Services, SQL, Team Foundation Server (TFS).

Confidential, OR

SQL Server Developer (SSIS/SSRS)

Responsibilities:

• Converted Logical Database Diagram into Physical Schema using the balanced Normalization in 2nd and 3rd Normal Form for highest performance.
• T-SQL programming for writing Stored Procedures, User-Defined Functions, Triggers, Cursors, Views.
• Creating and executing SQL Server Integration Service packages to populate data from the various data sources
• Upgraded the existing environments from SQL Server
• Migrating DTS 2000 packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Service
• Designing ETL packages dealing wif different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Deployed SSIS packages from development environment to UAT / Stage & Prod environments
• Performed Data Extraction, Transforming and Loading (ETL) between different System using SQL tools (SSIS, DTS, Bulk Insert, and BCP)
• Design, deployment, and maintenance of various SSRS Reports in SQL Server
• Creating various Data Sets, Writing complex queries, optimizing the queries and tuning the performance of Reports (SSRS).
• Developing stored procedures, triggers, views, and adding/changing tables for data load and transformation, and data extraction.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Used SQL Server Profiler and Database Tuning Advisor for query optimization.
• Managing the security of the servers, creating the new logins and users, changing the roles of the users
• Provided 24/7 production support for the production database and also deployed the code into the production environment.
• Strong experience in development, and testing phases of software development life cycle.
• Lead and coordinated wif offshore team for completion of tasks.
• Created BRD and FRD documents based on business needs.
• Performing code peer-peer reviews.
• Performed the role of a Configuration Manager maintaining internal version control system and performing quality audits.
• Worked onsite at the client place involved in the UAT Build, Configuration, Deployment and Integration.

Environment: SQL Agents, SQL Mail, SQL Server Management Studio, SQL Server Integration Services, SQL Server Reporting Services, Business Intelligence Development Studio, Team Foundation Server (TFS).

Confidential, Chicago, IL

SQL Server Developer

Responsibilities:

• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications.
• Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data.
• Defined requirements and comprehended the complex business rules required for writing the code..
• Responsible for identifying and defining Data Source and Data Source views.
• Developed Multi-dimensional Objects (Cubes, Dimensions) using MS Analysis Services (SSAS)
• Scheduled SSIS Packages for loading Facts and Dimensions.
• Involved in making mappings and transformations using DTS Transform Data Task, Data Driven Query Task
• Dealt wif huge amount of data and used SSAS in order to retrieve the data.
• Created and managed subscriptions for the reports
• Developed Drill down Tabular, Matrix and List Reports using SSRS.
• Designed and deployed Reports wif Drop Down menu option and Linked reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Created reports on both relational databases as well as against analytical cubes.
• Migrated some crystal reports to SSRS reports.
• Implementing the calculations to aggregate physical measures.
• Developed and coded applications in T-SQL
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance.

Environment: MS SQL Server 2008R2/2008/2005, T-SQL, Windows 2000/2003, Crystal Report 8.5, MS SQL Server Integration Services, MS Access, MS Excel, HTML, XML.

Confidential

SQL Server Developer

Responsibilities:

• Gathered requirements from the business users, created technical specification documents.
• Created/modified SQL Joins, sub-queries, and other T-SQL implement business rules.
• Upgraded the existing environments from SQL Server .
• Designed packages for Extracting, Transforming and Loading (ETL) data from Excel, Flat file and any OLE DB data source to MS SQL Server by using BCP utility, DTS and SSIS services.
• Deployed SSIS packages from development environment to UAT / Stage & Prod environments.
• Custom ETL solutions using T-SQL stored procedures schedules as jobs.
• Developed Reliable Packages by implementing Logging, Error Handling, Transactions and Checkpoints.
• Monitored and Optimized SSIS package performance to reach the expected timeframe for data loading.
• T-SQL programming for writing Stored Procedures, User-Defined Functions, Triggers, Cursors, Views.
• Experienced in generating reports using MS Reporting Services (SSRS).
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports
• Carried out numerous optimizations and fine-tuning of stored procedures.
• Involved in fine-tuning issues on the Database Server by re-indexing, index de-fragmentation and updating the statistics.

Environment: Windows, ASP.Net, ASP, SharePoint, Visio, MSSQL, OPC, Visual basic, VBScript, JavaScript, Putty, MS access, Html, XML, BCP, DTS Import/Export, SQL Agents, SQL Mail, SQL Server Management Studio, SQL Server Integration Services, SQL Server Reporting Services.

Confidential

SQL Server Developer

Responsibilities:

• Generated SQL Scripts for copying/migrating databases and database objects.
• Gathered data for validation and populate them into tables using stored procedures.
• Modified current database by adding tables, altering referential integrity and relationships to support online system.
• Extensive use of Stored procedures, Writing new stored procedures and modifying existing ones and tune them such dat they perform well
• Involved in designing various reports to flat files generated by the database script.
• Create Stored Procedures, Triggers, Views, joins and Functions for the Application
• Create, debug, and execute T-SQL scripts and stored procedures
• Extensively involved in error handling stored procedures
• Imported various Sources, Targets and Transformations using Transact-SQL Server.
• Used SSIS for data population from different sources and create packages for data conversions and load data from flat flies or excel files.
• Actively involved Normalization & De-normalization of database
• Extensive Testing on the Performance of the Stored Procedures.
• Worked closely wif Application Developers and Business Analysts to produce all required documentation
• Identified, tested and resolved database performance issues to ensure database optimization.
• Created complex views, partition views for the application to increase the performance and reduce server load.
• Write complex T-SQL statements for retrieval of data.
• Testing the Performance of the database and fine-tuning is also done for complicated queries dat take time to carry out, Analyzing and creation of appropriate indexes to optimize application performance
• Create joins and sub-queries for complex queries involving multiple tables.
• Design and create SQL Database, tables, indexes

Environment: MS SQL Server 2005, Windows 2003 Server, Transact-SQL, SSIS, SSRS