Professional Summary:

• Microsoft Certified Professional with Six years of IT Experience in Database Design, Development and Implementation of Microsoft SQL Server 2005/2008/2008R2 in Development, Test and Production Environments with various business domains such asFinancial, Retail and Healthcare.
• Experience in working on full Software Development Life Cycle (SDLC).
• Knowledge in the .Net Framework.
• Integrated SQL Server 2005 reporting services with Microsoft Share point Portal Server.
• Experienced in working in cross-functional teams and tight schedules.
• Worked in tandem with the end users for understanding the business requirements and recommending feasible solutions.
• Excellent communication skills and team player.
• Ability to grasp new technologies/concepts.

Database Development and Performance Tuning:

• Experience in developing optimized SQL using best practices.
• Expertise in writing dynamic-SQL, complex stored procedures, functions and views.
• Hands on Experience in performance tuning using execution plans, SQL Profilerand DMVs.
• Incorporated complex business logic into stored procedures and functions for reusability.
• Experience in creating packages, jobs, sending alerts using SQL Mail and extended stored procedures.
• Experience in Configuring and Managing Linked Servers, data transfer between SQL Server and other heterogeneous relational database such as Oracle and DB2.
• Strong debugging skills and the ability to solve complex problems.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Experience in Creating and Updating Statistics to improve the SQL Server Performance.

MS-BI Stack (SSIS,SSRS,SSAS):

• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Experience in creating SSIS packages using with Error Handling.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Experience in working with row, partially blocking and fully blocking transformations and adept at performance tuning of SSIS Packages.
• Adept at capturing the execution errors in SSIS for analysis purposes.
• Experience in sync processes between two databases using SSIS.
• Experience in importing/exporting data between different sources like Oracle/XML/Excel etc. using SSIS/DTS utility.
• Experienced in working with C#.Net in SSIS.
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Strong experience in generating drill-down, drill-through and cascaded-parameterized reports on top of relational databases and cubes.
• Created stored procedure for generating reports using SQL Server Reporting Services (SSRS).
• Experienced in creating various SSRS Reports involving variety of features like Charts, Filters, Sub-Reports and Multi-valued parameters.
• Experience in administrating the created reports and assigning permission to the valid users for executing the reports.
• Experience in deploying created reports to report server.
• Experience in developing cubes using SQL Server Analysis Services (SSAS)

DataWarehousing:

• Experienced in designing and developing ETL logic for moving data into data warehouses
• Involved in collaborating with Database Architects for basicData Warehouse Design.
• Good understanding of star schema and snowflake schema.

Certifications:

• Microsoft Certified Technology Specialist – MS Business Intelligence - Development and Maintenance
• Microsoft Certified Professional -MS SQL Server - Implementation and Maintenance

Technical Skills:

Languages

C, C++, T-SQL, C#.Net, VB.Net

RDBMS

MS SQL Server 2005, 2008, 2008 R2, MS-Access 2007, Oracle 10g, DB2.

Web Technologies

HTML, XML

Reporting Tools

SQL Server Reporting services (SSRS), Crystal Reports

ETL Tools
Data Modeling Tool

DTS, SQL Server Integration Services (SSIS)
ER Studio, Microsoft Visio

Operating System

Windows 2000 Advanced Server, NT, 2003, 2008

Professional Experience:

Confidential, Brecksville OH Sep ‘12 –Till Date
SQL Developer

Confidential operations include a regional banking franchise operating primarily in nineteen states and the District of Columbia, specialized financial businesses serving companies and government entities. The scope of the project was to understand the complex data structures, loading the same into target databases and also reporting on top of the target databases.

• Gathered business requirement from the end users.
• Involved in creating complex stored procedures according to business logic and also for the creation ofRDL for reporting.
• Worked with nested Stored Procedures and Functions.
• Involved in the performance tuning of the existing SQL code.
• Coded with complex customer data related to events such as Delinquency, Bankruptcy, and Collections etc.
• Created objects like tables and views and developed SSIS packages to load data.
• Implemented Incremental Loading into the target tables/views in SSIS.
• Created SSIS packages for moving data between databases.
• Involved in maintaining the Error-Logging for the SSIS packages.
• The data is moved with one to many relationships between tables and many to one relationship between tables.
• Created Jobs, Alerts using SQL Server Mail Agent in SSIS.
• Developed SSIS Packages and stored procedures to retrieve all accounts from various systems like Settlements, Foreclosures, Transactions and Mortgage to name a few.
• Created mock-up data for testing the reports.
• Involved in the performance tuning of table valued functions.
• Responsible for creating reports using SSRS.
• Created Drill Down, Drill Through and Cascaded Parameterized reports according to the customer requirement.

Environment: 
Microsoft SQL Server 2008, T-SQL, SQL Server Integration Services, SQL Server Reporting Services, Microsoft Team Foundation Server.

Confidential.,Miami, FLMar ‘11 – Sep ‘12
Programmer Analyst

Confidential. is a FORTUNE® 500 provider of leading-edge transportation, logistics and supply chain management solutions. The Data Services team at Ryder is an integral part of the IT department that takes ownership of the ETL. The scope of the project included but not limited to developing and automating ETL logic. Apart from ETL, it also involved database maintenance and documentation.

Responsibilities:

• Actively involved in all the phases of Software Development Life Cycle (SDLC).
• Created detailed design and requirements documents with logic to help team members understand the requirements and design.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into enterprise data warehouse (EDW).
• Dealt with a variety of data sources including OLEDB Oracle Source, XML sources and Flat File Sources.
• Implemented incremental loading into the destination.
• Created alerts for both success and failure of jobs.
• Designed ETL for implementing Slowly Changing Dimensions in order to maintain historical data.
• Created configuration files to deploy SSIS packages across all environments.
• Used SSIS Script Task to write C# Code Snippets to generate error reports to be sent out.
• Coded in C#.Net for Assigning Values to objects dynamically and checking for conditions.
• Created the complex stored procedures, user defined functions to encapsulate the business logic.
• Createdviews, indexes, and user defined data types and implemented the cursors, triggers as needed.
• Followed best practices in writing T-SQL queries as a regular daily routine.
• Involved in the de-normalization of tables in order to make query retrieval faster.
• Involved in performance tuning of queries using query execution plans, SQL Profiler and also DMVs.
• Responsible for creating the reports using the SQL server reporting services.
• Created various types of reports including drill-down, drill-through, cascaded parameterized reports and sub-reports.
• Deployed the reports to the report server.
• Designed and implemented the database replication for reporting database.
• Knowledge Transferred to co-workers &prepared Technical Documentation.
• Used Visual Source Safe for version control.
• Worked extensively on the data changes as per the user specified improvements on each release of the application build.
• Created numerous test cases for testing the application.
• IntegratedSQL Server 2005 reporting services with Microsoft Share point Portal Server to deliver automatically generated reports to the Share Point Site.

Environment: SQL Server 2008, SSIS, SSRS,T-SQL,Visual studio 2008, C#.NET, XML, VLDB, HTML,ER Studio, Visio, Microsoft Visual Source Safe, Microsoft Share point Portal Server.

Confidential, Oklahoma City,OK May’10 - Mar‘11
SQL Server Developer

Confidential is the world’s largest fully integrated producer of titanium ore andtitanium dioxidethe world’s third largest producer of titanium feedstockand second largest producer of zircon. The project involved development and enhancement of ETL data flows along with performance tuning. It also involved some basic reporting and creating database objects.

Responsibilities:

• Designed, Developed and Tested ETL logic for moving data from sources that were updated on daily basis.
• Worked with variety of file sources such as flat files, excel files and XML files.
• Incorporated incremental loading into destination database.
• Worked with different types of transformations such as row transformations, partially blocking transformations, fully blocking transformations and involved in performance tuning of SSIS packages.
• Established logging in packages and directed the log files to the concerned authority using Send Mail Task.
• Deployed SSIS packages to different environments such as production and testing in the SDLC.
• Performed VB and C# scripting in script Component.
• Used C# for Error Reporting.
• Involved in Performance tuning, and optimization of procedures and queries.
• Created complex storedprocedures, functions, triggers, and other database objectsfor applications using T-SQL.
• Created tabular and matrix reports based on custom requests from the end user.
• Created reports using SSRS from OLAP and OLTP data sources and deployed on report server.
• Generated ad-hoc reports using SSRS and Crystal reports.
• Created custom reports using Tableau and evaluated the tool as per client request.
• Constantly updated and maintained statistics for better performance.
• Incorporated complex business logic into functions and stored procedures.
• Created packages in SSIS with error handling.
• Created SQL Server Profiler tracesfor optimum performance of queries.
• Actively involved in Normalization (3NF) & De-normalization of database.
• Rebuilt indexes on various tables as per need.

Environment:Microsoft SQL Server 2000/2005 Enterprise Edition, MS SQL Server Management Studio, MS SQL Server Business Intelligence Development Server (BIDS), Tableau,Microsoft Visual Basic 6.0

Confidential, Chicago, IL Jan’09 -- Apr’10
Programmer Analyst

Confidential is a global pharmaceutical giant devoted to discovering new medicines, new technologies and new ways to manage health. The project mainly involved maintenance of database objects such as tables and stored procedures. It also involved enhancement of some existing functionalities and ETL logic.
Responsibilities

• Involved in Installation and configuring of SQL Server 2005
• Created database objects such astables, indexes and designing constraints for data integrity.
• Experience in using T-SQL for creating stored procedures, indexes, cursors and function
• Performed data transfer using BCP.
• Added additional functionality to the specified business logic as per customer demand.
• Created linked servers to connect various OLEDB servers and providers.
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Automated SSIS Packages by creating jobs and also created alerts.
• Identified and defined the report datasets.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Wrote stored procedures for report generation in SQL Server2005.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS

Environment:SQL Server 2000/2005, SSIS, SSRS, Crystal Reports,Microsoft Excel

Confidential, Roanake, VAMay’08 --Jan’09
SQL Server Developer

Confidential is the second-largest retailer ofautomotivereplacement parts and accessories in theUnited States. The project involved a major shift of practices for ETL. A domestic application that used JAVA scripting and BCP files to load data into the target database feeding most of the Client’s front end applications were being modeled in SSIS. Key roles included creating test plans and supporting test data for the proposed data flows and maintaining the database objects.
Responsibilities:

• Created technical specifications, test plans and test data to support ETL data flows
• Assist the Development staff with the testing and implementation of the application.
• Used Toad Client for accessing Oracle databases that contained views of the domestic application.
• Created SSIS Packages that mimics the nature of the domestic application.
• Created complex stored procedures, triggers, cursors, tables, views and other database objects using T-SQL.
• Troubleshoot SQL Server performance issues for internal and external customers.
• Used T-SQL to create queries and stored procedures to produce reports for end-users
• Configured Transactional Replication between the Production server and Reporting server and to move the data to servers in various locations.
• Create Linked Server to transfer data to legacy systems.
• Created Reports using stored procedures as per customer requests.
• Configured mail profile for sending automatic mails to respective people when job is failed or succeed.

Environment: MSSQL Server 2005, BIDS, Toad For Oracle, Microsoft Excel