PROFESSIONAL SUMMARY:

• Over 7 years of IT experience in the Analysis, Design, Development, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite Development, UAT and Production Environment.
• Experience in Design and Development of Database and Business Intelligence with SQL Server 2008R2.
• Strong technical knowledge in MS SQL Server development including DTS, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Extensive experience with different phases of project life cycle Analysis, Design, Implementation, Testing, and debugging new and existing client-server based applications .
• Experience in writing the TSQL Statements, stored procedures, functions using SQL Server.
• Experience in creating the packages or batch jobs for loading the data from one server to other using SSIS.
• Experience in creating the reports for proving the monthly and quarterly reports to the clients.
• Worked with QA team for fixing the bugs in the code and used Jiira and Spira Test tool for updating the defect status.
• Experience in using TFS 2012/2008 for maintaining the source code like check-in, check-out, merging and branching the source code.
• In-depth knowledge of T-SQL, SSRS, SSIS, Reporting and Analytics.
• Experience in SQL Server DTS and SSIS Integration Service package design, constructing, and deployment.
• Transformed data from one server to other servers using tools like Data Transformation Services DTS and SQL Server Integration Services SSIS 2005/2008/2013 .
• SQL Server 2005/2008 RDBMS database development including T-SQL programming.
• ETL implementation using SQL Server Integration Services SSIS .
• Experience with adhoc reporting, Parameterized, Custom Reporting using SSRS for daily reports and SSIS projects.
• Knowledge on integration of BI suite of products with Microsoft Office range of products like Business Scorecard Manager, Dashboards, Performance Point Server.
• Worked in Data modeling, creating star and snowflake schemas in SSIS.
• Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

CONFIDENTIAL

Role: MS SQL Server / BI Developer

• CONFIDENTIAL is one of the most highly respected crop insurance providers in the industry. CONFIDENTIAL is staffed with highly qualified professionals that set the standard in the crop insurance industry for timely, efficient and effective service.
• CONFIDENTIAL, Inc. assisted the American farmer manage risk and make decisions to continue to preserve their financial future. Heartland has developed a wide network of partnerships with independent agents in over 25 states to bring their expertise and products to the marketplace.

Responsibilities:

• Developed SSIS packages to Extract, Transform and Load ETL data into the SQL Server database from the legacy mainframe data sources.
• Developed packages using SSIS from different data sources like SQL Server, Flat Files and Excel etc and performed different kinds of transformations.
• Created Stored Procedures, Functions, Indexes, Tables, and Views and wrote T-SQL code and SQL joins for applications.
• Worked with Business users and other SME for understanding the business needs and created the high level and detail design documents before developing the code.
• Involved in the implementation and development of the technical design of the some of the processes that related to the data conversion.
• Developed SSRS reports that are related to the packages based on the business needs using SQL Server Reporting Services 2013 and deployed the reports to report server.
• Used Script tasks, execute SQL tasks, Sequence container, different source and destination connection managers etc while developing the packages.
• Developed SSRS reports that are related to the packages based on the business needs using SQL Server Reporting Services 2013 and deployed the reports to report server.
• Developed custom reports and deployed them on server using SQL Server Reporting Services SSRS .
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services SSRS
• Created SSIS packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column etc.
• Implemented database standards and naming convention for the database objects and documentation of all the processes involved in maintaining the database for future reference.
• Worked on SSIS Error Handling, Event Handling, SSIS logging, package configurations, variables, expressions etc.
• Wrote T-SQL procedures to generate DML scripts to perform the database operations and modified database objects.
• Created stored procedures to transform the data and wrote T-SQL statements for various needs of the transformations while creating the packages.
• Used TFS 2012 for check-in, check-out, adding, merging and branching the solutions to TFS.
• Used JIRA for the updating the tickets and provided the daily status of the critical and medium level issues.
• Generated the scripts in SQL Server 2012 for deploying them to TEST, MODEL and PROD environments and maintained the version of scripts in TFS.
• Worked with DBA's for monitoring Performance of SQL server using SQL Profiler, Query Analyzer, Database Engine Tuning Advisor DTA , Performance monitor.
• Worked with the Batch team for making sure the packages/jobs work properly in TEST, MODEL and PROD environments and did the code fixes.
• Worked on production issues, resolved and deployed them to Test, Stage and Prod environments.

Environment: SQL Server 2012, Integration Services 2012, Team Foundation Server 2012, Reporting Services 2013, Windows 7, MS Business Intelligence Design Studio, MS Office, JIRA.

CONFIDENTIAL

Role: MS SQL Server / BI Developer

Facets 5.01: The overall objective of this project is to Implement Facets system Version 5.01. The GEHA's Primary line of business application was TriZetto ClaimFacts system and other mainframe system based applications. GEHA has made the decision to migrate the primary line of Business application to the Trizetto Facets Application since ClaimFacts application is going to be sunset which is not ICD10 complaint.

Responsibilities:

• Worked with Business users and other SME for understanding the business needs and created the high level and detail design documents before developing the code.
• Involved in the implementation and development of the technical design of the some of the processes that related to the data conversion.
• Created Stored Procedures, Functions, Indexes, Tables, and Views and wrote T-SQL code and SQL joins for applications.
• Using Integration Services SSIS , built high performance Data Integration Solutions, including extraction, transformation and loading ETL packages for data warehousing.
• Developed SSRS reports that are related to the packages based on the business needs using SQL Server Reporting Services 2008 R2 and deployed the reports to report server.
• Developed custom reports and deployed them on server using SQL Server Reporting Services SSRS .
• Worked with different methods of Logging in SSIS.
• Developed the SQL Server Integration Services SSIS packages to transform data from SQL 2005 to MS SQL 2008 as well as created interface stored procedures used in SSIS to load/transform data to the database.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server
• Created tabular, matrix, chart, drilldown reports, parametric, cascaded reports and dashboards and scorecards reports according to business requirement.
• Deployed the generated reports directly on the client's workstation.
• Created complex Stored Procedures for better performance to generate reports.
• Ensure that periodic daily, weekly and monthly reports are delivered in a timely and accurate fashion using Reporting services SSRS.
• Develop and support reports built with Microsoft Reporting Services SSRS on SQL 2008R2.
• Used TFS 2008 for check-in, check-out, adding, merging and branching the solutions to TFS.
• Used Jira tool for updating the tickets and provided the daily status of the critical and medium level issues.
• Worked on production issues, resolved and deployed them to Test, Stage and Prod environments.
• Generated the scripts in SQL Server 2008R2 for deploying them to TEST, MODEL and PROD environments and maintained the version of scripts in TFS.

Environment: SQL Server 2008R2, Integration Services 2008 R2, Team Foundation Server, Reporting Services 2008R2, Windows 7, MS Business Intelligence Design Studio, MS Office, SpiraTest.

CONFIDENTIAL

Role: SQL Server Developer SSIS/SSRS

CONFIDENTIAL is a professionally monitored Security 2.0 product that combines the benefits of a traditional home security system with advanced features such as remote access, video, and home automation. Currently about 17 of U.S. households subscribe to a traditional monitored security system. CONFIDENTIAL research has shown that the market can grow due to the new Security 2.0 features, evidenced by the 10-12 down-weighted purchase intent in CONFIDENTIAL

subscriber households that do not currently have a monitored security system.

Responsibilities:

• Worked with business users and BA's to understand the business requirements.
• Involved in developing the technical design documents by the understanding the business requirements and legacy code.
• Created Stored Procedures, triggers, cursors, tables, views and other wrote SQL joins and statements for applications by using T-SQL.
• Wrote T-SQL for developing user defined functions, views, indexes, user profiles, and relational database models and data integrity.
• Used Controls Flow task, Data flow task, Execute SQL task, script task, connection managers, logging, package configurations etc while developing the SSIS Packages.
• Transformed data from one data source to other destinations using various transformation techniques like Derived column, conditional split, Look up, Merge, Row Count and etc using SSIS 2008.
• Created batch jobs and worked with the batch team for scheduling the jobs to run periodically.
• Worked with different methods of logging like SQL Server, Text, and XML in SSIS log providers.
• Worked with deployment team for deploying the code to other environments.
• Installed and configured SQL Server 2008 R2/2005 in Test environment with latest service packs and migrated few databases.
• Used SQL Reporting Services and Report Builder Model to generate custom reports.
• Designed and created Report templates, bar graphs and pie charts based on the data, wrote queries to generate reports for analysis of data Used table control, matrix control to create cross tab reports handled sub reports and defined query for generating drill down reports in SSRS.
• Wrote T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers and SQLCMD
• Implemented Complex business logic with User-Defined-Functions, Index Views and also created User Defined Data type, Clustered Non-clustered Indexes.
• Responsible for debugging the stored procedures and scripts while trouble shooting the issues.
• Provided daily status to the lead as the development goes on and discuss the technical challenges.

Environment: MS SQL Server 2008R2/2005, SQL Server SSRS/SSIS, OLAP, and Microsoft Windows 2003 Advanced Server, ASP.NET, C , ETL, .NET, Enterprise Edition, Microsoft Visual Basic 6.0, SQL LiteSpeed, OLAP, TFS 2008.

Role: SQL BI Developer

CONFIDENTIAL is a property and casualty insurer domiciled in the State of Ohio with primary interest in Property and causality, Health, Banking and Mortgage, Life insurance Retirement Savings and Asset Management. The project primarily involved Extracting Underwriting, Rating and Product rules from online and batch process of Policy Administration System. These rules will be loaded into a rule engine as a next phase. The project involved in converting multiple BizTalk Applications to SSIS

Responsibilities:

• Analyzing the business requirements and building logical and physical data models.
• Designing several ETL processes to Load data from Text or Excel Files
• Extensively used T-SQL in constructing User Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL
• Created Packages in SSIS with error handling.
• Developed ETL process using SSIS with Various Control Flow, Data Flow task and Store Procedures for Work Order Validation process.
• Excellent report creation skills using Microsoft Reporting Services SSRS with proficiency in using Report Designer as well as Report Builder.
• Developed custom reports and deployed them on server using SQL Server Reporting Services SSRS .
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services SSRS
• Well versed in defining/creating and handling Data Sources, Data Source views and parameterized Reports in SSRS 2005.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Successfully Extracted transformed and load data into data warehouse.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server
• Created Family of stars using dimensional modeling concepts of Degenerated dimension, Fact less fact table, Aggregate fact tables in multi dimensional model.
• Designed logical / physical data models and defined primary key, foreign key using Erwin tool.
• Involved in creating Dimensions, KPI, Measures and calculations in SSAS 2008.
• Worked with different methods of Logging in SSIS.
• Developed the SQL Server Integration Services SSIS packages to transform data from SQL 2005 to MS SQL 2008 as well as created interface stored procedures used in SSIS to load/transform data to the database.

Environment: SQL Server 2008R2, MS Access, Excel, Windows Server 2008, Visual Source Safe, ADO.Net, VB.Net, XML Parsing and C , SSRS, SSIS.

CONFIDENTIAL

Role: SQL Server Developer/ SSRS Developer

Description: Successfully developed and maintained ETL maps to Extract, Transform and Load data from various sources like Flat files, relational data and XML files into the Enterprise Data warehouse called Pharmacy Data Warehouse Management system. This includes creating and running scripts. Data warehouse collects full life cycle data for Biological Pharmaceutical products right from the new product introduction through its manufacturing, testing, shipping, and success and failure analysis. The data is used to make decisions for new product improvements, failure analysis of existing products, improve customer service. Various reports were generated using Microsoft reporting services SSRS .

Responsibilities:

• Writing stored procedures, triggers, cursors, and views to improve the quality of application, and manage mission-critical information using T-SQL.
• Develop and support reports built with Microsoft Reporting Services on SQL 2005 SSRS.
• Created/developed/maintained the stored procedures, triggers to interpret complex business rules, history data and audit analysis.
• Designed logical / physical data models and defined primary key, foreign key using Erwin tool.
• Created packages to migrate data from different data sources to data warehouse
• Created packages for database maintenance.
• Executed Back up database task, check database integrity, rebuild indexes, update statistics task for maintenance
• Using Integration Services SSIS , built high performance Data Integration Solutions, including extraction, transformation and loading ETL packages for data warehousing.
• Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting.
• Migrated data from the DB2 database using SSIS Packages.
• Optimized performance and capacity planning of various data transformation processes related to the reports.
• Provided technical support to internal developers and external clients.
• Documentation for all kinds of reports and DTS and SSIS packages.
• Develop and support reports built with Microsoft Reporting Services SSRS on SQL 2005.
• Maintain and monitor the data warehouse to ensure its proper operation, performance and availability.

Environment: SQL Server 2008 R2 /2005, SSIS, SSRS, OLAP, Share point, ETL, Visual Studio.NET, Erwin, Windows NT/2003

CONFIDENTIAL

Role: MS SQL Server Developer

combines Photonic Integration with our unique Bandwidth Virtualization technology to create the Digital Optical Network.

Responsibilities:

• Interact with the clients and gather the requirements and analyzed.
• Responsible for gathering business requirements, developing and reviewing of design documents
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Transferred data ETL to Data ware house Environment using SSIS.
• Developed complex stored procedures using T-SQL to generate Ad hoc reports within SQL Server Reporting Service
• Migrated data from different data sources.
• Created SSIS package to automate maintenance, database back up, update statistics, re-build indexes as well as create error log for event during data load.
• To analyze long running queries and tune the same to optimize application and system performance.

Environment: MS SQL Server 2005/2000 Enterprise Edition, SSIS, SSRS and Windows Server 2003, MS Access.

CONFIDENTIAL

Role: SQL Server Developer

Description: Administration of GE-SBI Credit Card Databases, SBI/SBBJ ATM Card databases and CONFIDENTIAL databases. CONFIDENTIAL is the largest bank in CONFIDENTIAL of which GE is supporting entire credit card business for CONFIDENTIAL

. I as a team member used to maintain risk and remittance server for the business and high availability.

Responsibilities:

• To ensure trouble free access to SQL Server databases 24 hours a day.
• Timely completion of activities for database backup, restoration and health of databases.
• Security issues related to logins, database users, and application roles and linked Servers.
• Involved in trouble shooting and fine-tuning of databases
• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.
• Successfully implemented indexes on tables for optimum performance.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Created SSIS packages to import data from MS Access, Excel to SQL 2005.
• Filtered bad data from legacy system using Derived column, Lookups, Fuzzy Lookups, Conditional split.
• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions implement best practices to maintain optimal performance.

Environment: SQL Server 2000/7.0. Windows 2003/2000 Server and SQL LiteSpeed.

CONFIDENTIAL

Role: SQL Server Developer

CONFIDENTIAL is one of the leading providers of auto, home and CONFIDENTIAL . As a consultant for the CONFIDENTIAL , part of an ERP, I developed and helped to implement CONFIDENTIAL to handle human resource activities. CONFIDENTIAL , a web based three-tier architecture system which provides information about employee data, new hire, applicants, promotion, demotion, absence, payroll data, and change of certain business rules that required development of new modules to the system.

Responsibilities:

• Involved in logical modeling and physical modeling of the database.
• Involved in requirements gathering, analysis, design, development and change management,
• Successfully implemented physical database on MS SQL Server 2000. Supported complex relationship using triggers.
• Tuned database by creating proper Indexes on different tables that improve the performance of T-SQL queries on the database.
• Facilitated simplified access of database for end users using de-normalized views and created triggers on them to maintain to database integrity.
• Created Cursors to facilitate the users credit officers to scroll through the Queues to perform manual operations on the payment.
• Assisted in the scheduling and the deployment of the reports and assisted in uploading files to a report server catalog from the report manger.

Environment: MS SQL Server 2000, T-SQL, Visual Basic 6.0 and Windows NT.