SUMMARY

• Over 7 years of extensive experience in the IT industry as a MS SQL Developer in MS SQL Server 2005/2008/2008 R2/2012.
• Experienced in working in various domains verticals like Healthcare, Banking, Insurance, support etc.
• Experienced in RDBMS Concepts, Database Management Systems, and Database Physical and Logical design & Data Modeling.
• Highly proficient in the use of SQL Server Management studio and T - SQL for constructing triggers, tables, user functions and stored procedures.
• Experienced in writing complex queries using joins, common table expressions and temporary tables.
• Experienced in tuning the performance of database and queries by creatingindexes, views and verifying execution plan.
• Excellent hands-on experience with data modeling tool like MS Visio.
• Analyzed business and technical requirements, as well as logical data model to understand the detailed data management requirements.
• Highly proficient in high level design of ETL SSIS/DTS packages for integrating data from heterogeneous sources (Excel, Xml, Oracle, flat file, Text Format Data) to MS SQL Server.
• Experienced in performing ETL tasks using DTS Import/Export utility, BCP and DTS Packages using SSIS.
• Worked in Data Warehousing environments and applied design methodologies in creating star & snowflakes schemas, while performing dimension modeling in OLAP system.
• Expertise creating various complex reports in SSRS 2005/2008/2008 R2/2012 including tabular reports, drill down reports, drill through, matrix reports, chart reports, sub reports and parameterized queries for generating cascading reports.
• Extensively worked on system analysis, design, development, testing and implementation of projects (SDLC) and capable of handling responsibilities independently as well as proactive team member.
• Good working knowledge of programmability enhancement features in SQL Server 2012
• Organized professional with excellent oral and written communication skills, excellent presentation, interpersonal skills, problem solving skills, fast learner and also adapt quickly new technology with ability to take new roles in minimum time and little .

TECHNICAL SKILLS

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio, Oracle 10g

Languages: C/C++, C#,T-SQL, My SQL, VB, HTML, XML

Operating Systems: Windows 95/2000/2003/ NT/XP/VISTA/7, UNIX, MS DOS

Databases: MS SQL Server 2008/2005/2000

ETL Tools: SSIS 2012/2008/ 2005 , DTS.

Scripting: UNIXShell Scripting

Reporting Tools: SSRS 2012/2008/2005

DB Utilities: SQL Server Management Utility, Query Analyzer

Application Software: Visual Studio 2008/2005, MS Office, MS Access

Other BI Tools: SSAS 2008/2005.

Data Modeling Tools: ERwin 7.2

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

Sr MS SQL Developer

Responsibilities:

• Designed, Developed and Optimized various medium to complex reporting solutions based on user requirements using SQL Server 2008 Reporting services (SSRS).
• Created drill down, drill through, sub and linked reports using SQL Server 2008 Reporting Services (SSRS).
• Created and configured SSRS subscriptions to deliver reports in different formats.
• Designed and developed multi-parameterized reports allowing users to make selections before executing reports.
• Scheduled the monthly/weekly/daily reports to run automatically.
• Designed, Developed ETL processes for BI solutions sourcing data from various types of source data from RDBMS, Flatfiles, and XMLs etc.
• Have written stored procedures (TSQL) that collected and summarized valuations, calculations and were used as source of SSRS reports.
• Involved in maintenance\enhancements of SQL Server 2008 Integration Services (SSIS) packages.
• Tested the reports, ETLs developed to confirm the quality, quantity, accuracy and efficacy of the data.
• Involved in using RS utility to write automatic deployment, subscriptions to SSRS reports.
• Converted MS SSRS 2005 and Excel based reports to MS SSRS 2008 based reports.
• Developed expertise of data model of the trading systems in various areas of application involving limits, margining, payment processing.
• Created various client reports that display client activity, positions of portfolio, margin information.
• Involved in collecting requirement from business users and working with them to create various reports.
• Worked with various external teams to provide solutions for the reporting needs of the business with accurate data and resolve any issues reported instantly with hot fixes and stream lined the month-end-loads to provide robust data on time, every time.
• Involved in documentation of test plans and user documents for BI solutions\ SSRS reports.

Environment: SSRS, SSIS, MS SQL Server 2008, T-SQL, MS Visual studio 2008, BIDS, Report Builder1.0 SQL Server Management Studio, Data Analyzer, Business Objects, MS Access, MS Excel, SQL Profiler, Windows XP, Erwin v4.2, VSS 2005.

Confidential, Seattle, WA

Sr. MS SQL Developer

Responsibilities:

• Designing Data Model and implementing changes in the earlier phase of the project to accommodate business logic and dynamic nature of the front end application.
• Designed and modeled Microsoft SQL Server 2008R2 data warehouse and data marts, including the modification of existing Microsoft SQL Server 2005 data warehouse and data marts.
• Used SSIS packages to roll our data to Live Tables and to Processing Database.
• Developed database objects such as SSIS Packages, Tables, Triggers, and Indexes using T-SQL, SQL Analyzer and Enterprise Manager
• Configure the SSIS Package for run time Parameters and Config file
• Develop the Documents for Logging/Error Handling for SSIS Packages
• Integrate the SSIS package, converting all existing DTS packages of MS SQL by adding extra SSIS task.
• Schedule Package using SQL Server Job for weekly/monthly basis.
• Used Checkpoint for avoiding re-executes Package from the first task.
• Develop the Slowly Changing Transformation to maintain the Historical Data.
• Handling the errors during data moving and Sequencing the task as per requirements.
• Developed packages using fuzzy task for data cleansing.
• Handling the orphan rows in Dimension and Fact tables.
• Participated actively in analysis and discovery phases of data warehouse implementation.
• Perform T-SQL tuning and optimizing queries for Reports which take longer time in execution SQL Server 2008R2.
• Developed interface and reporting stored procedures, views, UDF for efficient data storage and manipulation
• Migrated Crystal reports to SSRS reports manually
• XML result set from Stored Procedures to create custom XML file for third party data export.
• Extensively worked on SSIS creating all the interfaces between front end application and SQL Server 2008R2 database, then from legacy database to SQL Server Database and vice versa.

Environment: MS SQL Server 2005, 2008R2, SSRS, SSIS, SSAS, T-SQL, Visual Studio 2008, Oracle, MS Access, Excel and Windows 7.

Confidential, Benton Harbor, MI

SQL Developer

Responsibilities:

• Designed physical and logical database structures/diagrams.
• Created tables, relationships, triggers and indexes for enforcing business rules.
• Used SQL Profiler to estimate the Slow Running queries and performance tuning purpose.
• Wrote different complex SQL queries including inner, outer join and update queries.
• Developed reports for payment and BI Count to show organizational and seasonal comparison.
• Incremental and full database recovery with experience of complex recovery scenarios.
• Worked on DTS Package, DTS Import/Export for transferring data from various heterogeneous sources to SQL Server.
• Created packages using SSIS for data extraction from Flat Files, Excel Files OLEDB to SQL Server.
• Created Queries, Stored Procedures for generating drill down reports in SSRS.
• Designed and implemented stylish report layouts.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Responsible for report generation using SQL Server reporting services based on business requirements.
• Responsible to provide production support to the client.

Environment: Windows NT, Windows 2003, SQL Server 2005, DTS, SSIS, SSAS, T-SQL, XML, MS SQL Reporting Services.

Confidential, Nashville, TN

SQL Server Developer

Responsibilities:

• Responsible for creating reports based on the requirements using SSRS 2005.
• Created detailed reports for the customers to help them decide which property to purchase by showing demographic information based on various parameters.
• Authored performance based reports for the managers to show sales against various measures like Time, Area, and Price-Range.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Actively supported business users for change requests.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Identified and defined the Datasets for the report generation.
• Developed stored procedures and used SSIS 2005 to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables.
• Developed physical data models and create DDL scripts to create database schema and database objects.
• Identified and added the report parameters.
• Uploaded reports on to the report manager and organized them in folders.
• Delivered the reports using ‘pulled’ and ‘pushed’ methodologies.
• Formatted the reports using the Global variables and expressions.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
• Deployed the generated reports on to the server.
• Fine-tuned the database objects and server to ensure efficient data retrieval.

Environment: MS SQL Server 2005 (Query Analyzer, SSIS, SQL Profiler), MS SQL Reporting Services 2005.

Confidential

SQL Developer

Responsibilities:

• Participated in developing logical model and implementing requirements on SQL Server 2005
• Created the database for the reporting team
• Optimized SQL queries for improved performance and availability
• Monitored Strategies, Processes and Procedures to ensure the Data Integrity, Optimized and reduced Data Redundancy, maintained the required level of security for all production and test databases
• Designed and developed the database based on these requirements
• Actively involved in different stages of Project Life Cycle
• Carried out a Developer’s role on MS SQL Server 2000, MS Access Databases (using DTS (Data Transformation Service), T (Transact)-SQL, Stored Procedures and Views)
• Involved in migration of SQL server 7 to SQL server 2000 using Upgrade Advisor
• Installed and Configured SQL Server 2000, Created Logins, Users and Maintenance Plans managing use of Disk space, memory and connections to the database
• Involved in assisting QA team in deploying and testing the application, which uses SQL Server as a database
• Involved in creation of stored procedures, triggers using T SQL according to the requirement of the projects
• Involved in Performance tuning and optimizing for SQL Server Application by using performance monitor

Environment: SQL Server 2000/7, T-SQL, Query Analyzer, Windows NT/2000 server