SUMMARY

• Over 7+ years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2000/20 in Development, Test and Production Environments on various business domains like Financial, Insurance and manufacturing.
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2000/2005/2008 R2/2012.
• Expertise in SQL Server Integration Services(SSIS) and SQL Server Reporting Services (SSRS).
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
• Excellent in High Level Design of ETL DTS Packages& SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
• Developing reports on SSRSon SQL Server ( 2000/20 ).
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Very strong experience in ad - hoc reports, Tabular and Charts reports in SSRS.
• Good Knowledge and experience on SharePoint.
• Experience in creating dashboards, scorecards and building reports using performance point server and Silverlight.Experience in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, Relational Database Models and Data Integrity, SQL joins.
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Experience in using T-SQL in SQL Server 2000/2005/2008 and 2012 platforms.
• Experience in Performance Tuning and Query Optimization.
• Experience in SQL ServerDTS and SSIS (Integration Service) package design, constructing, and deploymentSQL Server 2005/2008/2008 R2/2012 RDBMS database development including T-SQL programming.
• Experience in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using DTS/SSIS.
• Developed Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc Reports and distributed Reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Expert in creating Parameterized Reports.
• Hands on experience in Creating Star Schema and Snow Flake Schemas.
• Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.
• Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.

TECHNICAL SKILLS

SQL Server Tools: Enterprise Manager, T-SQL, SQL Profiler, Query Analyzer, SQL Server Management Studio, DTS, SSIS, SSRS, SSAS

Database: MS SQL Server 2012, 2008 R2, 2005, 2000, SQLCMD, Microsoft Office 2007/2003, MS-Access.

Language: C,C++,HTML,XML,TSQL,MYSQL,DHTML,VB.NET,ASP.NET,.NET Frame Work, C#, JavaScript

Operating System: Windows XP/NT/ 2000/2003/2008 , DOS

Tools: Erwin Data Modeler, MS Visio, SAS/Access, Crystal Reports8.5,10,XI,R2,BusinessObjects,Microsoft office 2003/2007

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

SQL Server BI Developer

Responsibilities:

• Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.
• Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services (SSIS).
• Created various Tabular and Matrix Reports using SSRS.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Involved in migration from SQL Server2005 to SQL Server2008and2012.
• Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Involved in designing, developing, debugging and testing of reports in PowerView.
• Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).
• Used SSIS to unite data from existing system and performed transformations on MS SQL 2008.
• Extract Transform Load(ETL) development Using SQL server2012, SQL 2012 Integration Services(SSIS)
• Generated several drill down and drill through reports using SSRS.
• Used Report Builder or Report Designer in Business Intelligence Development Studio (BIDS) to create new reports based on PowerPivot workbooks.
• Created new ad hoc reports based on PowerPivot workbooks that are published to the same location.
• Used Performance Point Server to create reports, scorecards and dashboards.
• Deployed these reports into the SharePoint after developing the reports.
• Involved Performance Point Server to create interactive reports with an ability to drill down into details.
• Created excel reports from relational databases, cubes and using powerpivot.
• Experienced in integrating different Microsoft BackOffice Components such as SharePoint and IIS with MS SQL Server
• Did a C#, ASP.Net / VB.Net / SQL Server project converting their existing VB6 desktop application to a web application.
• Actively participated in interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.

Environment: T-SQL, MS SQL Server2005/2008R2/2012, SQL Server Integration Services (SSIS),SQL Server Reporting Services (SSRS),SQL Server Analysis Services (SSAS), Performance Point Server 2007, MS Visual Studio.NET# 2008, TFS (SharePoint), Visual Basic6.0/VB.net, VB Script and Windows 2008 Server.

Confidential - Plano, Texas

SQL Server BI Developer

Responsibilities:

• Created SQL server Reports using SSRS 2008.Identified the data source and defined them to build the data source views
• Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design(SSRS)
• Used scripts and variables, email notifications for ETL process using Data Integrator.
• Experience in creating complex SSISpackages using proper control and data flow elements with error handling.
• Designed Data flows, Workflows and jobs to load data from source to target in BO Data Integrator.
• Enhancing and deploying the SSIS packages from development server to production server.
• Involved in the performance tuning and optimization of T-SQL queries.
• Created Packages in SSIS with error handling.
• Knowledge on integration of BI suite of products with Microsoft Office range of products like MOSS (SharePoint), Business Scorecard Manager, Dashboards, Performance Point Server.
• Used various ETL tools like SSIS/DTS for data flow from source files like XML, Excel, Tables and views to other databases or files with proper mapping.
• Generated parameterized reports, sub reports, tabular reports using SSRS2008.
• Created reports in SSRS with different type of properties like chartcontrols, filters, Interactive Sorting, SQL parameters etc.
• 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.
• Extensively used T-SQL in constructing User defined Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Developed Various reports involved in Tabular, Matrix, Ad-hoc, Drill down reports using SSRS in SQL Server 2008 R2Back end Experience in MS SQL Server development, writing T-SQL stored procedures, coding, triggers and cursors.
• Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development
• Created complex SSIS packages using proper Control and Data flow elements.
• Used System Tables, System Stored Procedure, DBCC commands for Database maintenance.
• Migrated DTS packages from SQL Server 2005 to SQL Server 2008 as SSIS Packages.
• Involved in migration from SQL Server 2005 to SQL Server 2008.

Environment: MSSQL Server 2008 and 2005, T-SQL, SSRS, SSAS, SSIS Packages, SSRS,ETL, ODBC, Erwin, ASP.Net 3.0, Ado.Net 3.0, C#.Net, Excel, Business, Business Objects Data Integrator 6.5, SharePoint Server, MDX, ProClarity, OLAP, OLTP, DB2, Access, Windows 2003 Server, IIS 6.0.

Confidential, Pittsburgh - PA

SQL Server BI Developer

Responsibilities:

• Created SSIS packages and used Analysis Services processing task to update the cube with current data.
• Created SSIS packages to load data from Oracle to Sql Server using various transformations in SSIS.
• Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views).
• Back end Experience in MS SQL Server development, writing T-SQL stored procedures, coding, triggers and cursors
• Analyzed the existing tool and participated in meetings with the business users to gather
• Requirements and design goals of data warehouse.
• Created various Tabular, Cross-tab, Matrix and Ad-hoc reports using SSRS.
• Created Parameterized reports, Cross-Tab reports, Drill down reports& Summary reports by Using SSRS.
• Created report snapshots to improve the performance of SSRS.
• Combined Dundas chart control with .NET Grid view control and bind both the controls to a common data source.
• Responsible for managing daily activities of department including compliance initiatives, group practice agreements, managing health care claim strategies and other.
• Responsible for helping manage the daily operation of the company, meeting with clients and brokers for brokerage, holding employee meetings, resolving conflicts.
• Created T-SQL Functions, Cursors, views, indexes, stored procedures and triggers.
• Migrated database from SQL server2000 to SQL server2005 using utilities i.e. exp/imp and attach/detach for SQL servers 2005 futures.

Environment: SQL Server 2005, Windows 2000/2003, Microsoft office 2003,XML,T-SQL, SQL Server Integration Services, SQL Server Reporting Services, T-SQL, SQL Server Analysis Services, SQL Profiler, MS Excel 2003, Visual Studio 2005,.NET Frame Work 1.0,SharePoint 2007.

Confidential, Overland Park - KS

SQL Server Developer

Responsibilities:

• Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages.
• Performed cost benefit analysis of different ETL packages (SSIS) to determine the optimal Process.
• Created ETL metadata reports using SSRS, reports include like execution times for the SSIS packages, Failure reports with error description.
• Responsible for Data migration from SQL Server2000 to SQL Server 2005 Databases.
• Developed an automated report subscription process using SSRS.
• Applied conditional formatting in SSRS to highlight key areas in the report data
• Used Report Builder to do Ad-hoc Reporting.
• Created report links to refer other reports in a particular report.
• Resolved any deadlocks issues with the Databases/Servers on a timely basis.
• In-Depth working knowledge of ODBC.
• Handled Underwriting and pricing of renewal accounts within underwriting authority for
• Property Casualty, General Liability, Business Automobile, Umbrella Liability, Crime and Workers
• Compensation. Assisted (via remote) with payroll, tax, and account processing.
• Imported and exported data into MS Access databases and Debugged VBA scripts linked to said databases.
• Created multiple hierarchical aggregates for faster performance.
• Installed SQL server 2000 on Windows 20003 servers and involved in Physical and logical Database Design using Erwin tool.
• Created database objects like tables, users, roles, stored procedures, triggers.
• Worked on solving issues by doing data recovery in existing database.
• Used various formatting techniques like interactivesorting, grouping to created user friendly reports.

Environment: SQL Server 2005, Windows 2000/2003,MS Access 2000/2003,T-SQL,Windows 2000 Advanced Server, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services.

Confidential

SQL Server Developer

Responsibilities:

• Gathered requirements to identify and create database objects such as tables, views, triggers and indexes.
• Involved in Normalization of the database and bringing it to 3NF.
• Involved in creating the constraints, rules, defaults and triggers to maintain the data and referential integrity.
• Created ER diagrams using Visio.
• Created Views to enforce security and data customization.
• Created Non-Clustered indexes to improve query performance and query optimization.
• Involved in the performance tuning and optimization of T-SQL queries.
• Responsible for Data migration from SQL Server7.0 to SQL Server 2000 Databases.
• Created Stored Procedures for commonly used complex queries involving join and union of multiple tables.
• Developed user requested reports using Crystal Reports and Excel.
• Created Drill down and Drill through reports using Crystal Reports

Environment: SQL Server 2000, Windows XP/2000, Crystal Reports, Excel.