PROFESSIONAL SUMMARY:

• Over 7+ years of IT proficient experience as MS SQL Server Developer in various domains such as Healthcare, Energy Management, Marketing and Finance.
• Extensive knowledge and Experience in dealing with Relational Database Management Systems (RDBMS), including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, Cursors.
• Experienced in transforming complex business logic into Database design, Migration and maintaining it by using SQL tools such as Stored Procedures, User Defined Functions, Views, Data Modeling and DTS.
• Strong experience in Writing Stored Procedures, User Defined Functions and Complex Views.
• Expertise in PL/SQL, T - SQL languages.
• Expert in SQL Server tools like SQL Server Reporting Services (SSRS), SQL Server Integration services (SSIS), SQL Server Analysis Services (SSAS).
• Experienced in developing Custom Report and different types of Chat Reports, Tablix Reports, Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using Visual Studio 2005/2008/2012 Reporting Services (SSRS).
• Experience in configuring and managing Linked Servers, data transfer between SQL Server and other heterogeneous relational databases such as Oracle and DB2.
• Experienced in generating reports like matrix, parameterized and drill through reports using SSRS and developed stored procedures using functions to generate various kinds of reports using SSRS.
• Experienced in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools like SSIS, Data Transformation Services (DTS), Bulk Insert, BCP, and XML.
• Expert in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources to SQL server.
• Created and maintained Databases, creating Roles and managing user permissions, resolving deadlocks.
• Reviewed, analyzed, and modified programming systems including encoding, testing, debugging and installing to support an organization's client/server software applications.
• Strong experience in SQL Server development, System Analysis, Design, Development & Support of MS SQL Server 2008,2005 and 2000 in Production, Development.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills.

TECHNICAL SKILLS:

Languages: C, C++, PL/SQL, T/SQL, HTML, XML, VB.net, ASP.net

RDBMS: MS SQL Server 2000/2005/2008, Oracle9i/10g, MS-Access

Operating Systems: Windows2000/2003 Advanced Server, Windows NT, Windows XP, Vista, Windows 7

Defect Tracking & Office Tools: VSS 6.0, MS-Office 2007, TFS, TortoiseSVN, Red Gate Source Control, JIRA, StarTeam, FogBugz, Team City

Other Tools: SSIS, SSAS, MS SQL Server Management studio, MS Visual Studio 2008, MS Visio, ER Studio

Reporting Tools: SQL Server Reporting Services, Oracle Business Intelligence

PROFESSIONAL EXPERIENCE:

Confidential, Franklin, TN

SQL Server \BI Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Designed ER diagrams (Physical and Logical using Erwin) and mapped the data into database objects.
• Used MS Report Designer to provide a Report Data pane to organize data used in the reports.
• Performed source/target analysis of data structures & content.
• Converted crystal reports to SQL Server reports using Reporting Services.
• Published reports and dashboards on WEB.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Used Merge in development, test and production for changing the d data.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Created SSIS package to get data from different sources consolidate and merge into one single source.
• Created package configuration using environment variables.
• Configured and maintained Report Manager and Report Server for SSRS.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Generated ad-hoc reports using MS Reporting services and Crystal reports.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query.
• Used data compression techniques for Back Up.
• Performed Documentation for all kinds of reports, DTS and SSIS packages.
• Performed CDC and Change tracking on OLTP systems.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Created Linked Servers for data retrieval using OLE DB data sources and providers.

Environment: Windows 7, MS SQL Server 2008/2012, T-SQL, SQL Server Data Tools, SSIS,SSRS, MS Excel, SQL Analyzer and Enterprise Manager, SQL Agent, Microsoft Visual Studio 2010/2012.

Confidential, Atlanta, GA

SQL Server \ BI Developer

Responsibilities:

• Requirements gathering, Analysis and Design of all the client requirements.
• Designing the data marts from the existing EDW Data ware house and also by analyzing the business with analysts.
• Building SSIS Packages to load the data marts from the data ware house.
• Working on the current production tickets related Data Transfer Services.
• Worked on the Stored Procedure fixes and Package Configuration in order to fix the bugs.
• Developed several SSIS packages using custom logging and Package Configuration.
• Deployed the packages in to different environments for testing purposes.
• Worked on different kind of package configurations mostly SQL Server.
• Create and redesign procedures, functions, and triggers.
• Working on performance tuning using SQL profiler and Database tuning advisor of SQL server.
• Identified and worked with Parameters for parameterized reports in SSRS 2008.
• Developed stored procedures with multi-valued parameters for generating complex reports.
• Tested and configured automated routine maintenance tasks like performance tuning, indexes and stored procedures, checked deadlocks and created jobs and scheduled them.
• Extensively used Event Handlers for logging and Error Handling in SSIS packages and notified process results to various users using send email Task.
• Modified the Import process for various clients based on their requirement as part of ticketing system.
• Involved in assisting my peers with creating the SSIS 2012 packages and troubleshooting the packages. Documenting of all the Business logic insuring maintenance is easy for the Peers.
• Experience with designing and building data models with Star/Snowflake Schema and use standard ETL to load the data marts.

Environment: SQL Server 2008/2005, DTS, SSIS, SSRS, SQL Server OLAP 2000,BCP, Reporting Services 2000, T-SQL, MS Access, Windows XP/2003 Server

Confidential, New York City, NY

SQL Server \ BI Developer

Responsibilities:

• Familiarized the team with the user needs, specifications, design layouts, the development process, design standards, techniques and tools to support task performance.
• Worked with project managers, analysts and business users to understand business processes, document project requirements and translate them into functional and non-functional specifications for BI reports and applications.
• Hands on experience with SQL Server 2008 Reporting Architectures.
• Hands on experience with customer facing role in order to develop and produce reports that meet customer's needs by providing timely information that enables them to make various program and policy-related key decisions.
• Hands on experience report scheduling from report server using the report subscriptions and also in report server administration.
• Monitoring the nightly running jobs on regular basis and fixing the issues on time mostly related to SSIS Packages.
• Developed an Import and Export process using SSIS for a client from scratch, deployed them to prod and automated the process using SQL Agent.
• Developed Stored Procedures, functions as part of Import/Export processes.
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services. Handled the Production Issues regularly.
• Designed SQL SSIS Packages in Business Intelligence Development Studio (BIDS), to extract data from various data sources such as Excel spreadsheet, flat files into SQL Server 2008, 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all; Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks in Visual Studio 2008.
• Provided production support for ETL jobs.
• Migrated existing crystal reports to SSRS reports. Deployed the reports and subscribed the reports into a specific client location.

Environment: SQL Server 2005, Windows 2003/2000, VBScript, HTML, Microsoft Visual Studio 2005, JAVA, Crystal Reports, Teradata, DTS Packages.

Confidential, NJ

SQL Server \ Report Developer

Responsibilities:

• From the business requirements found out the data elements and then created data model design for that. Once it got the approval then created technical specs and design docs for development.
• Mainly worked for Hedge Reporting and User data Entry and Black stone Modules.
• Created the Stored procedures for each page by analyzing the web application.
• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for web applications.
• Created boot strap seed data scripts for the new applications.
• Generated multiple Enterprise reports (SSRS/Crystal) from SQL Server Database (OLTP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports etc.
• Created different Parameterized Reports (SSRS 2005/2008) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Deployed and Subscribed the Created Reports to desired location via e-mail subscribing or using file system.
• Implemented security to restrict the access to users and to allow them to use only certain reports.
• Worked with SQL Profiler for troubleshooting, monitoring and optimization of SQL Server and non production database code as well as T-SQL code from developers and QA.
• Worked with SQL Profiler to trace the slow running queries and tried to optimize SQL queries for improved performance and availability.
• Generated Reports using Global Variables, Expressions and Functions.
• Scheduled the subscription reports with the subscription report wizard.
• Deployed the generated reports directly on the client’s workstation.
• Improved Report Performance and performed unit testing.
• Handling 24/7 production issues.

Environment: SQL Server 2008R2 Enterprise Edition, T-SQL, SQL Server 2008R2 Management Studio, SQL Analyzer and Enterprise Manager, SQL Agent, SQL Profiler 2008, Microsoft Visual Studio 2008, Tidal Job Scheduler, ER Studio, BI Xpress.

Confidential, Duluth, GA

SQL Server\ETL Developer

Responsibilities:

• Actively involved in gathering and analyzing the user requirements in coordination with Business.
• Performed the scope analysis of the user requirements.
• Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements.
• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Performance tuning, and optimization of procedures and queries.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc to SQL Server using SSIS/ETL using various features like data conversion etc. Created derived columns from the present columns for the given requirements.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Developed, monitored and deployed SSIS packages.
• Loaded the database by creating tables for which I used to get the data from csv and tsv files overnight and I have automated the process of loading using SQL Agent and also by sending an e-mail of success or failure to the concerned manager.
• Worked on designing an Unsubscribe web form using CSS and HTML for a .net application which uses web services to call the DB to do a business validation.

Environment: SQL Server 2000/2005, SQL Server 2008, Windows 2003/2000, VBScript, HTML, SSIS, SSRS, ADO.NET.

Confidential

SQL Server

Responsibilities:

• Actively involved in Normalization & De-normalization of database.
• Designed DDL and DML for MS SQL Server 2005
• Create rules, defaults, tables, views, clustered & non-clustered index, user defined data types, and user defined functions.
• Actively designed the database to fasten certain daily jobs, stored procedures.
• Optimized query performance by creating indexes.
• Involved in writing SQL batch scripts.
• Write T-SQL statements for retrieval of data and Involved in performance tuning of TSQL
• Queries and Stored Procedures.
• Involved in merging existing databases and designed new data models to meet the requirements.
• Create joins and sub-queries for complex queries involving multiple tables.
• Developed complex stored procedures to create various reports.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Installed and Configured SQL Server 2005 on development server for designing and testing

Environment: MS SQL Server 2005, SSIS, SSRS, DTS, SQL Management Studio, and SQL Server Business Intelligence tools, Windows 2003, SQL Server Query Analyzer, SQL Profiler, and Crystal Reports.