PROFESSIONAL SUMMARY:

• 8+ Years of IT experience as a Database Developer/Analyst using MS SQL Server 2008, 2005 and 2000 in OLTP/OLAP environments working with various domains such as Retail, Insurance, Banking & Healthcare.
• Worked extensively on system analysis, design, development, testing and implementation of projects (SDLC).
• Strong experience in using Microsoft BIDS (SSAS, SSIS, SSRS).
• Hands on experience in database development using Stored Procedures, Cursors, Indexes, Views and User - Defined Functions to facilitate efficient data manipulation and data consistency.
• Extensive experience in Writing Transact SQL (T-SQL) Queries, Dynamic-queries and implementing SQL Server Indexing.
• Good experience in using performance monitor/SQL profiler for handling Performance Tuning of long running queries and dead lock issues.
• Experience in creating Jobs, Alerts and scheduling Packages.
• Experience in developing ETL packages using SSIS with various transformation tasks.
• Experience in using Precedence Constraints, Break Points, Check Points, and Logging using SSIS.
• Good experience in designing and scheduling complex SSIS Packages for data migration from various sources like SQL Server, Oracle Database, Excel and Flat file.
• Experience with SSIS performance tuning using counters, error handling, event handling
• Experience 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.
• Experience in building various types of SSRS reports like table, matrix, and chart report, web reporting by customizing URL Access.
• Experience in Migrating MS SQL 2000 to MS SQL 2005 using SQL Server upgrade advisor.
• Exposure of Data Warehousing methodologies such as Multidimensional modeling (Star / Snowflake Schemas).
• Good Understanding of OLAP Cubes, Dimensions, Slowly Changing Dimension phenomenon, surrogate key assignment.
• Good communication skills, quick learner and good performer both in team and independent job environments with strong logical and analytical skills.

TECHINAL SKILLS:

Databases: MS-SQL Server 2000, 2005, 2008, Oracle 8i,10g, Microsoft Access

Programming Languages: TSQL, Java, ASP.Net, C#.Net, HTML, DHTML, XML,

IDE Tools: Visual Studio .Net 2005/2008, Team Foundation Server

Framework: Microsoft .Net Framework 2.0

ETL Tools: SQL Server Integration Services (SSIS), Data Transformation Services (DTS)

Reporting Tools: SQL Server Reporting Services (SSRS)

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development studio, Enterprise Manager, SQL Profiler, Query Analyzer, Import & Export(DTS)

Operating System: Windows Server 2003, Windows 2000 Advanced Server/Professional, Windows XP Professional

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

SQL Migration Developer

Responsibilities:

• Perform system and requirement analysis, design and writing technical design documents and test plans.
• Developed and maintained tables, queries, stored procedures and views to support business needs and reporting requirements.
• Design and implement SSIS packages and T-SQL scripts for transforming data from staging tables to full cycle layout text files required by FICO ETLs for adding new debts, debtors, creditors, and transactions
• Design and develop mappings, sessions and workflow as per requirements and conversion standards
• Providing PAR, ORT, UAT support and production rollouts
• Monitoring and resolving issues in the area of data management and integration services (SSIS)
• Designing and developing reports for end users in bankruptcy, work groups and Specialty areas
• Created SSIS Packages to import data daily from OLTP Applications to data warehouse.
• Created Ad-hoc reports and provided the result sets in excel sheets for user convenience.
• Applied conditional formatting in SSRS to highlight key areas in the report data.
• Created reports like Drill-Down, Drill-Through, Chart, Sub Reports using SQL Server Reporting Services (SSRS).
• Create processes and procedures for application code and database object migrations to support an efficient and reliable system development lifecycle. 
• Responsible for Performance and tuning of SQL servers and application issues related to migration. 
• Responsible for creating reports based on Business Required Document (BRD) using SSRS 2008.
• Generated reports using Global Variables, Expressions, and Functions for the reports.
• Develop and maintain stored procedures for deploying sets of table schema, views, user-defined functions, and stored procedures across development, test, and production environments.
• Use TFS for managing code, validation scripts, and defect tracking for advanced accounting programming issues pertaining to debt placement, transaction codes, payments, and financial bucket balances.

Environment: MS SQL Server 2012, SQL Server Integration Services 2012, T-SQL, Windows Server 2012, Windows7 Professional, MS Office 2013, SQL Compare

Confidential, Charlotte, NC

MSBI Developer

Responsibilities:

• Used metadata tables which can extract data from different sources using dynamic SSIS package and Linked Servers.
• Created Complex SSIS Packages to extract data.
• Involved in production support, error debugging and performance issues while job executions.
• Worked as a developer in creating complex Stored Procedures, Functions, Views and complex SQL statements.
• Wrote and enhanced Stored Procedures and User defined functions.
• Involved in troubleshooting stored Procedures and SSIS Packages in development and production environments.
• Working with customers on Application rollouts and server migrations.
• Created batch files and created Autosys Jobs for execution of SSIS packages.
• Deployed SQL scripts and SSIS packages into DEV environment using Anthill build tool.
• Created AUTOSYS jobs and worked on Jil code.
• Used SQL Compare tool to do DB Comparison in order to compare schema objects in PROD VS DEV environments for Pre-Production release.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Prepared Unit test case documents for PROD release items and reviewed all test cases of the team for Production release items.
• Co-ordinated and guided offshore team to achieve the timelines of tasks.

Environment: MS SQL Server 2008, MS Reporting Services 2008, SQL Server Integration Services 2008, T-SQL, Windows Server 2003, Windows XP Professional, MS Excel 2007, VB.NET, SQL Compare, Autosys Scheduler tool, Anthill build\deployment tool.

Confidential, Louisville, KY

SSIS/ETL Developer

• Involved in Design, Development and maintenance of new Installs and Existing SSIS Packages, including creating technical specifications for new SSIS requirements.
• Responsible for the Migration of existing Data Junction System to SSIS (SQL Server Integration Services).
• Analyzed the requirements and framed the business logic for the Migration from SQL 2000 to SQL 2008 and Data Junction to SSIS ETL process.
• Developing code for the process of loading the data into our databases and following the process of cleansing the data before loading.
• Developed T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Involved in building the ETL design process and implementation.
• Responsible for building Trauma and Non-trauma logic for all of the clients.
• Responsible for creating Dynamic SQL store procedures to create the tables and manipulate the data on the fly.
• Migrated all the ETL’s from Data junction to SSIS 2012.
• Create SSIS Packages to extract, transfer and load (ETL) existing data into SQL Server 2008 from different environments.
• Implemented the process for finding claims missing patient or subscriber information.
• Implemented complex business requirement in backend using efficient stored procedures and flexible functions, and facilitated easy implementation to the front end application.
• Loading source files in to raw tables for data mining and data ware housing tasks.
• Performed performance tuning for longer running store procedures.
• Used Merge function to check against old patient, subscriber and provider information against new data.
• Developing quality documentation/procedure for both internal and external use; ensuring technical and process documentation for both internal and client use.
• Collaborate with business Intelligence and business department team members to identify and prioritize the enterprise requirements.
• Performing intensive data analysis, testing for quality assurance, and migrating releases into stage and production environments.
• Testing the new applications in various environments including Dev, QA and Production.

Environment: MS SQL Server 2012, SQL Server Integration Services 2012,MS SQL Server 2008, SQL Server Integration Services 2008,T-SQL, Data Junction, ASP.Net, Windows Server 2003, Windows XP Professional, MS Excel 2003, Visual Source safe

Confidential, Rochester, NY

MSBI Developer

• Involved in the development of SSIS Packages & SSRS reports using BIDS.
• Created and executed SQL Server Integration Service (SSIS) packages to populate data from the various data sources, created packages for different data loading operations for different applications.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages.
• Developed Stored Procedures, Functions, Triggers, Tables, Views, SQL joins and statements for applications using T-SQL.
• Used CTEs for recursive functionality to bring the organization structures.
• Built table valued functions, scalar valued functions to suffice the needs for business rules and for the implementation in stored procedures.
• Performing extract/transform/load (ETL) routines using SQL Server Integration Services(SSIS).
• Interacted Business Analysts to understand the requirements and the impact of the ETL on the business.
• Used existing ETL standards to load into staging tables and then to Dimensions and Facts.
• Perform Data Analysis, determining business logic and applying them to Development.
• Creating new jobs or using the existing jobs, reviewing the results to determine success/failure, documents success/failure, troubleshoots failures, provides up-to-date communication and maintains documentation.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Created user defined functions in SSRS using VB script.
• Worked on row and column grouping, filtering and sorting the data in the repots using SSRS.
• Responsible for building the Dimensions and cubes with star schema and snowflake schema using SQL Server Analysis Services (SSAS).
• Created cubes in SSAS to be used as data source in the reports

Environment: MS SQL Server 2005/2008, MS Reporting Services 2005/2008, MS Analysis Services 2005/2008, SQL Server Integration Services 2005,T-SQL, Windows Server 2003, Windows XP Professional, MS Excel 2003, Team Foundation Server

Confidential, Charlotte, NC

Sr.SQL Developer/ Analyst

• Gathered requirements from users to better understand the business logic of the company.
• Developed complex stored procedures and user defined functions for the reports using T-SQL.
• Created User Defined Functions to encapsulate frequently and commonly used business logic.
• Involved in the development real time and scheduled reports(Jasper).
• Used Temp Tables to reduce the number of rows for joins, to aggregate data from different sources for different reports.
• Built table valued functions, scalar valued functions to suffice the needs for business rules and for the implementation in stored procedures.
• Performing intensive data analysis, testing for quality assurance, and migrating releases into stage and production environments.
• Used sub reports functionality based on the user requirements in Jasper.
• Modified existing java scripts to implement the changes required by users.
• Responsible for performing T-SQL tuning and optimizing queries for reports which were taking longer time in execution.
• Used SQL Profiler and Index Tuning Wizard for the performance tuning of SQL queries and Stored Procedures.

Environment: MS SQL Server 2000, iReport 2.0.5, Windows Server 2003, Windows XP Professional, MS Excel 2007, Subversion

Confidential, Alpharetta, GA

SQL BI Developer

• Involved in the development of SSRS reports using BIDS.
• Developed Stored Procedures, Functions, Triggers, Tables, Views using T-SQL.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Developed various operational Drill-through and Drill-down reports using SSRS
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Used cascaded parameters to generate a report from two different Data Sets.
• Involved with Query Optimization to increase the performance of the Report.
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Involved in designing, developing and testing assigned reports using Microsoft Reporting Services (SSRS).
• Developed Sub Reports, Tabular Reports using MS SQL Server Reporting Services (SSRS).
• Used sub reports functionality for complex report calculations.
• Rendered reports in different formats like pdf, excel etc to be executed automatically on weekly or monthly basis.
• Involved in building the dimensions and cubes with star schema and snowflake schema using SQL Server Analysis Services (SSAS).

Environment: MS SQL Server 2005, MS Reporting Services 2005, SQL Server Integration Services 2005,T-SQL, Windows Server 2003, Windows XP Professional, MS Excel 2003, Team Foundation Server

Confidential, Chicago, IL

ETL Developer

• Responsible for performing T-SQL tuning and optimizing queries for reports which were taking longer time in execution.
• Used Temp Tables to reduce the number of rows for joins, to aggregate data from different sources for different reports.
• Created Views and Index Views to reduce database complexities for the Reports.
• Wrote complex stored procedures and user defined functions for the reports using T-SQL.
• Extensively used complex joins involving multiple tables from different databases.
• Used SQL Profiler and Index Tuning Wizard for the performance tuning of SQL queries and Stored Procedures.
• Created SQL Server SSIS packages (ETL) to upload data to the ware house from the staging area.
• Scheduled jobs to run the SSIS packages on daily basis using SQL Server Agent.
• Utilized Pivot tables to provide structure to Reports in proper format.
• Designed, Developed and Deployed reports in MS SQL Server using Microsoft SQL Server Reporting Services (SSRS).
• Developed single value and multi valued parameterized reports for Business Users using Microsoft SQL Server Reporting Services (SSRS).
• Created Drill Down reports using Microsoft SQL Server Reporting Services (SSRS).
• Enhanced reports by the charts and graphs using Microsoft SQL Server Reporting Services (SSRS).

Environment: MS SQL Server 2005, T-SQL, SSIS, SSRS, Business Intelligence Development studio, Windows 2003, Visual Studio 05