SUMMARY

• Over 8+ years of IT experience as a MS SQL Server Developer 2008/2005/2000 in various Industry verticals like Banking, HealthCare and Insurance.
• Experience in data analysis, design and development of databases for business applications in a client/server and data warehouse environments in SQL 2000/2005/2008 .
• Extensive experience with different phases of software development life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client - server based applications).
• Excellent knowledge in creating Databases, Tables, StoredProcedure, SQLJoins, DDL/DMLTriggers, Views, User defined data types, Cursors and Indexes using T-SQL.
• Worked with T-SQL, DBCC, DCL, DDL, DML Scripts and established relationships between tables using Primary Keys & Foreign Keys
• Ability to write complex Transact SQL (T-SQL) queries, Sub queries, Co-related and Non-correlated sub queries, Dynamic SQL queries etc.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Highly experienced in complete cycle of SQL Server Integration Services (2005/2008), Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing data transfers and ETL purposes across different servers.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), DataTransformation Services (DTS) and SQL Server Integration Services (SSIS) (2005/2008).
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Used ETL methodology for performing Data Migration, Extraction, Transformation and Loading using SSIS and designed data conversions from wide variety of source system.
• Involved in migrating DTS packages from SQL Server 2000 to SSIS packages in SQL Server 2008/2005 database.
• Experience in providing Logging, Error Handling by using event handlers and custom logging for SSIS Packages.
• Created, designed and deployed Tabular, Matrix, Chart, Drill-down and Ad-Hoc reports on report server.
• Highly Proficient in creating SQL Server Reports, handling sub-reports and writing queries to perform roll-up and drill down operations in SSRS 2005
• Experience in creating complex drill down reports, parameterized reports, dropdowns and images, charts using SSRS 2005/2008, Crystal Reports and MS Excel for analyzing the data at an enterprise level.
• Detailed depth knowledge in Oracle architecture.
• Well-versed in Object - OrientedProgramming like JAVA.
• Excellent analytical and critical thinking skills
• Good planning and prioritization skills.
• Ability to work independently and also as a part of the team.
• Excellent written and oral communication skills.

TECHNICAL SKILLS

Operating Systems: Windows XP/NT/2000,98/95, DOS, Unix, Linux

Programming languages: ANSI C, C++, VC++, JavaScript, C#, Java, SQL, T-SQL, PL/SQL,Perl

Reporting Tools: SQL Server Reporting Service (SSRS), Crystal Reports XI/10/9

ETL Tools: SSIS(SQL Server Integration Services), DTS(Data Transformation Services), Import Export Data, Bulk Copy Program (BCP)

Web Technologies: HTML,XML

Script Languages: JavaScript

Tools: SQL Query Analyzer, ERWIN, SQL Enterprise Manager, SQL Server Management Studio(SSMS), SQL Server 2005 Query Editor, Solution Explorer, Analysis Manager, Reporting Server, Business Intelligence

Database: Oracle 10g/9i/8i, MySQL, MS SQL Server, MS Access 2000, SQL server 2000/2005/2008

Others: Object Oriented Designing Methodology, RDBMS Concepts

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

SQL/BI Developer

Responsibilities:

• Worked with the End users to gather the requirement and Analyzing business processes and performing in-depth work analysis, Confidential .
• Scheduling Jobs and Alerting using SQL Server Agent.
• DDL Scripts for generating Tables, Views, Functions.
• Developed SQL Scripts to Insert/Update and Delete data in MS-SQL database.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Performance tuning, query optimization and execution plan of queries for better performance.
• Involved in providing the structure, to store data and to maintain database efficiently, worked extensively in writing complex Queries and debugging complex stored procedures, Tables, Cursor, Views, Functions, Triggers and Indexes in the databases using T-SQL.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS to SQL server.
• Creating SSIS package to load data from Flat Fileto Flat File and Flat File to Data warehouse and Report-Data mart using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Worked in importing and cleansing of data from various sources like DB2, Oracle, flat files, Excels to and from SQL Server 2008R2with high volume data.
• Experience in Error and Event Handling: Precedence Constraints, BreakPoints, Check Points, Logging, TRY and CATCH blocks
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS)
• Involved in creating different types of reports (Tabular Reports, Matrix, Cross Tabs, Drill Down, Charts, Functions and Maps) by extracting data from tables, store procedures into report builder and SQL server reporting service (SSRS). And customizing reports by adding Filters, Calculations, Prompts, Summaries and Functions.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS
• Identified and worked with Parameters for parameterized reports in SSRS 2008R2
• Also involved in creating other reports like Cascaded Parameterized, Sub-Reports.
• Formatted the SSRS reports using the Global variables, expressions and Functions
• Developed reports using SSRS and published as PDF, Excel, and CSV formats.
• Designed and implemented stylish report layouts.
• Scheduled the reports to refresh and run on daily, weekly and monthly basis in the report manager and SharePoint.
• Created stored procedures for datasets in SSRS reports to run calculations at database level.
• Wrote expressions in SSRS to provide flexibility to users by providing them with variety of options for seeing the business information in tables/charts etc.
• Involve in scheduling SQL jobs which execute the stored procedures and reports and load the data into CSV/Excel files to the report server.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time
• Experience in performancetuning, queryoptimization, DatabaseMaintenance plans

Environment: SQL Server 2008R2, BIDS 2008R2, (SSIS) Integration Services 2008R2, SSRS, Report Builder, T-SQL, MS Access.

Confidential, Pittsburgh, PA

SQL/SSIS/SSRS Developer

Responsibilities:

• Coding of several database Triggers, Stored Procedures, Creating Views and Indexed views and maintaining Integrity Constraints.
• Designed Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Rules and Defaults
• Created SSIS packages to get data from different sources, consolidate and cleanse the data and merge it into one single source.
• SchedulingJobs and Alerting using SQL Server Agent.
• Responsible for ETLoperations using SQL Server Integration Services (SSIS) and Worked with users in training and support and also has experience in incrementaldata loading.
• Implemented Logging in SSISPackages
• Designed and developed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 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.
• Built SSIS Packages for Processing cubes and Dimensions.
• Developed Custom Sales, Inventory for seasonal, quarterly, monthly and weekly using SSRS.
• Developed various kinds of Tabular, Parameterized, cascaded, Sub-Reports, Matrix, Drill-down, Drill-through, Charts, and web receiving reports using SSRS.
• Generated Reports using GlobalVariables, Expressions and Functions based on the requirements in SSRS2005
• Responsible for scheduling the reports based on the subscriptions defined.
• Used various transformations in SSIS like Lookup, Fuzzy grouping and Row Count Transformations
• Generated and formattedReports using Global Variables, Expressions and Functions, designed and implemented stylish reportlayouts.
• Developed Custom Reports, Ad-hoc Reports by using SQL Server Reporting Services (SSRS)

Environment: .NET Framework, C#, ASP.NET,, XML, MS Access, ER Studio, T-SQL, Crystal Reports, SQL Server 2008, SQL Server 2005, SQL Server Management Studio, SQL Server Business Intelligence Studio SSIS, SSRS,VisualStudio.NET IDE.

Confidential, DE

SQL Server/SSRS Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirement and provided documentation.
• Gathered data and documenting it for further reference.
• Maintained the table performance by following the tuning tips like Normalization and Creating Indexes.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled jobs for executing the stored SSIS packages which were developed to update the database on daily basis.
• Designed, Developed and Deployed reports in MS SQL Server2008 environment using SSRS.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Generated various reports using SSRS 2008.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard.
• Responsible for Monitoring and TuningReportperformance.
• Scheduled reports and exported in PDF format.
• Finely tuned SQL Queries for maximum efficiency and performance.
• Provided documentation for all kinds of SSIS packages.
• Designed and implemented Stored Procedures for automating tasks.

Environment: MS SQL Server 2005/2008, T-SQL, MS SQL Server Integration Services 2005, MS SQL Server Reporting Services 2005, MS SQL Profiler, SQL Query Analyzer, Visual Studio 2005, Erwin v4.1, Windows XP, MS Office 2003/2007, MS Access.

Confidential, NJ

SQL Developer

Responsibilities:

• Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data.
• Supported Oracle database applications written in SQL*Forms 5.0, Pro*C, PL/SQL,UNIXshell scripts, stored procedures, functions, and triggers.
• Used SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries.
• Used SSIS to unite data from existing system and performed transformations on MS SQL 2005.
• Used various transformation components in the data flow task to implement business logic.
• Configured SSIS packages using Package configuration wizard to allow package run on different environments.
• Migrated data using ETL Tool in SSIS.
• Deployed SSIS packages and Reports to Production Servers.
• Used SSIS for data population from different sources and create packages for data conversions and load data into flat flies or excel files.
• Conversion of DTS packages SQL Server 2000 into SSIS packages SQL Server 2005.
• Created complex variables, multiple breaks, sorts in the reports.
• Created Tabular and Matrix reports using SSRS.
• Created datasets for reports using T-SQL and stored procedures
• Developed multiple reports using reporting services.
• Creating functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Created ETL package for data conversion using various transformations tasks.
• Created various scheduled jobs to handle the data migration from SQL periodically.
• Created Stepped and Block reports using SSRS.
• Experience in building star schema and snowflake schema depending on the business data requirement.Rebuilding Indexes and Tables as part of performance tuning exercise.

Environment: SQL Server 2000/2005 Enterprise Edition, SSIS 2005, SSRS 2005,.NET Framework, C#, ASP.NET, ADO.NET, Erwin, XML, T-SQL, SQL Server 2000, SQL Server 2005, VisualStudio.NET IDE, Windows 2000/2003 Advance Server, ASP, XML, T-SQL, MS Excel, MS Access, Visual Studio 05.

Confidential

Systems Engineer

Responsibilities:

• Involved in different stages of Project Life Cycle.
• Actively participated in gathering Business Requirements and System Specifications.
• Created new Databases, tables, established relationship among tables in a database.
• Created stored procedures and functions to support efficient data storage and manipulation.
• Created views to display required information on user interface, and triggers to validate consistent data entry into the database.
• Defined Constraints, Indexes.
• Used SQL Server System Catalog to find Stored Proc, UDF, Triggers, indexes and constraints on existing databases.
• Implemented batch processing using Jobs and DTS.
• Migrated data from Flat files to SQL server 2000 using DTS (Import and Export Wizard)
• Created and Scheduled DTSpackages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
• Scheduled Jobs using SQL Server Agent.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Maintaining jobs for data messaging from development server to test server for generating daily reports for financial and marketing team.
• Designed and implemented several complex reports using SSRS.
• Developed Reports to generate daily, weekly, monthly, quarterly, yearly Reports using crystal Reports.
• Created different user level groups, and assigned appropriate permission level to the database.
• Preparation of project documentation.

Environment: SQL Server 2000, DTS, MS Access, MS EXCEL, T-SQL, Windows 2000 server.

Confidential

Associate Support Engineer

Responsibilities:

• Interacted with end users to gather Requirements. Created technical, user documentation.
• Studied and designed the system.
• Install, Update, Configure and Maintain the MS SQL Server.
• Created database objects like tables, views, indexes, stored-procedures, triggers, and user define functions.
• T-SQL queries for the retrieval of the data.
• Created a report interface using Visual Basic 6.0, which allowed users to select reports and dynamically filter reports.
• Tuning front-end applications like Visual Basic, which query the SQL Server databases.
• Written Various ASP codes for user interactions.
• Written Java Script for different validations
• Used SQL Statements to Present Query responses.

Environment: SQL Server 2000, T-SQL, .NET, VB Script, JavaScript, ASP, Microsoft Excel, FrontPage 2000.