SUMMARY

• An accomplished, quality - driven IT professional with over 7 years of experience in design, development and implementation of business requirements as a Microsoft SQL Server 2008/2005/2000 Developer/BI Developer.
• Domain expertise in Airline, Banking, Financial Services, Process Management and Transportation.
• Extensive experience in BI Solutions (ETL & Reporting) using SSIS, and SSRS
• Worked extensively on system analysis, design, development, testing and implementation of projects in Software Development Life Cycle (SDLC).
• Expert in designing and implementing relational database model as per business needs.
• Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects.
• Expert level skills in Data optimization and Performance Tuning of queries with modifications in T-SQL queries.
• Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, CTE’s Views and Cursors
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tune the same to improve performance
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Experience in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor, DBCC Commands, DMV’s, DMFs and Query Execution Plans.
• Expert in performing Data transfers between different homogeneous/heterogeneous systems (Excel and MS Access) and SQL Server as a part of Data Migration, Data Maintenance and other ETL tasks.
• Involved in conversion of DTS to SSIS packages and troubleshooting the migration issues.
• Experience in developing, deploying and monitoring packages for ETL tasks using SQL Server Integration Services (SSIS), DTS Import/Export Utility, BCP and DTS packages.
• Well-versed in usage of SSIS Control Flow items(For Loop, Execute package/SQL tasks, script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2005/2008).
• Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.
• Experience in handling Performance Tuning of SSIS using Horizontal Partitioning and Vertical Partitioning.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• Experienced in monitoring and scheduling ETL processes using DTS EXEC utilities and batch files.
• Experience in Data warehouse such as dimensional modeling, Star/Snowflake schemas, Data marts, fact and dimension tables identification, Kimball/Inman strategies and OLAP.
• Proficient in designing Data Mart and Data Warehouse using Star and Snowflake Schemas
• Created various SSRS Reports involving variety of features like Reports, Charts, Filters, Sub-Reports, Ad Hoc, parameterized reports, Linked reports, Snapshots, Cascaded, Drill-Down, Drill-Through, Multi-valued parameters etc. using SQL SSRS 2005/2008
• Worked with report manager for deploying the reports across all the environments
• Expert at developing ETL interfaces using SSIS and enterprise reports using SSRS utilizing latest versions (2005/2008) features.
• Integration of SSRS Reports using various web parts into Share point (MOSS 2007) and Performance Point 2010 and Dashboards.

TECHNICAL SKILLS:

RDBMS: SQL Server 2000/2005/2008/2008 R2, MS Access

Languages: C, C++, T-SQL, PL/SQL, Visual Basic 6.0., Unix Scripting

Operating Systems: Windows Server 2003, Windows 2000 Advanced Server/Server, Windows NT 4.0, Windows XP, Windows 7, MAC OSX

Tools: /Utilities: Enterprise Manager, SQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS), Database Tuning Advisor, SQL Profiler, Query Analyzer

Tools: & Packages: SQL Server Management studio, Enterprise Manager, Profiler, Business Intelligence Development studio (BIDS), DTS, ETL, Visual Studio .NET.

ETL Tools: SSIS, DTS (Data Transformation Services)

Reporting: SSRS (MS SQL Reporting Service), MS Access, Excel, Data Analyzer

PROFESSIONAL EXPERIENCE

Confidential

Business Developer

Responsibilities:

• Analyzing the Business Requirement Document (BRD) to design a conceptual model to be implemented with T-SQL, SSIS, and SSRS to develop a solution.
• Created Stored Procedures for complex business process in process control industry, SQL Agent jobs, and designed tables by following RDBMS rules.
• Administering SQL Server 2008 Management Studio tools including SQL Profiler and Database Engine Tuning Advisor.
• Working with design, development, implementation and support of ETL process using SSIS Packages in SQL Server 2008.
• Involved in Incremental Data Load from various sources into SQL Server Database Engine with ETL Operations.
• Working with different Control flow tasks in creating SSIS packages especially For Loop and For Each Loop containers with Execute SQL and Script Tasks.
• Working with a combination of multiple Dataflow Transformations to build packages in SSIS.
• Implementing major Event Handlers like OnError, OnProgress and OnTaskFailed for SSIS Packages.
• Working with Master SSIS packages to execute a set of packages that load data from various sources onto the Data Warehouse on a timely basis.
• Scheduling and Monitoring SQL Server Agent Jobs to run various SSIS packages in SQL Management Studio.
• Understanding the OLAP processing for changing and maintaining the Data Warehouse, Optimizing Dimensions and adding new Aggregations to the Cube.
• Analyze, design, develop, unit test, document, and implement reporting applications using SQL Server Reporting Services SSRS and other related technologies.
• Involve in generating Parameterized Tabular and Matrix Reports on data sets imported from SQL server Database Engine and also Analysis Services cubes.
• Migrating reports to SQL Reporting Services from Crystal Reports and Microsoft Access.
• Worked with Report Manager to configure Web URLs, E-mail and also Databases for reports.

Environment: SQL Server 2008R2 Enterprise, Windows Server 2003 Enterprise, Management Studio, Business Intelligence Development Studio (SSIS, SSAS, SSRS), Performance Point Server, Microsoft Office Share Point Server, OLTP, OLAP, XML.

Confidential, GA

Sr. SQL Server/SSIS/SSRS Developer

Responsibilities:

• Performance tuning of Stored Procedures and T-SQL Queries through improved indexes to reduce response time.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Created new SSIS package to extract date from legacy to SQL Server Objects using Business Intelligence Development Studio (BIDS) and Visual studio 2008.
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev. Test and Production Environments.
• Involved in extracting the data using SSIS from OLTP to OLAP from users in various sources like flat files and excel spreadsheets.
• Executing data validation stored procedures in SSIS packages in Business Intelligence Development Studio (BIDS).
• Involved in creating SSIS packages forloadingdata from data source (SQL database) to staging database and going through a complete SDLC (Software Development Life Cycle) by loading the data in the staging database and then loading the data in the final tables pushing into testing and then testing them and then pushing into productionDeveloped, monitored and deployed SSIS packages to generate reports for purpose of analysis.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent
• Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2008.
• Developed Report Models for building Ad hoc reports using Crystal Reports. Developed optimal stored procedures and queries to create data sets for reports.

Environment: SQL Server 2005/2008 Enterprise Edition, SSAS, SSIS, T-SQL and SSRS

Confidential, Rose Land, NJ

SQL Server/SSIS /SSRS Developer

Responsibilities:

• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse
• Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files)
• Created SSIS Packages using Fuzzy Lookup, Derived Columns, Pivot Transformation, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task 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.
• Created SSIS package to transfer data between OLTP and OLAP databases using Incremental Load.
• Scheduled tasks to run every day to update changes in the base tables for current and up-to-date information for reporting.
• Designed and developed various types of reports using SSRS to generate investment opportunities for the company and its clients.
• Worked on formatting SSRS reports using the Global variables and expressions
• Created parameterized reports, Drill down and Drill through reports using SSRS for interactive reports
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications
• Published reports on to Share-Point and created Web Parts in Share-Point to show various reports generated from Excel and SSRS in one Page.

Environment: Microsoft SQL Server 2005/2008, Windows Server 2003, Windows XP, Microsoft Visio, SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS).

Confidential, Atlanta, GA

SQL Server Developer/SSIS /SSRS

Responsibilities:

• Responsible for creating the 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.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).Monitored performance and optimized SQL queries for maximum efficiency.
• Identified and defined the Datasets for the report generation.
• Wrote the queries for the drill down reports pertaining to improved wealth and asset management.
• Planned the complete Back-up of various Databases for Disaster recovery scenarios.
• 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, MS Excel, Window XP, Toad.

Confidential, Erie, PA

MS SQL/BI Developer

Responsibilities:

• Created Query Parameters and Report Parameters to control data returned by the query and filter data at report level.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Created and administered all SQL Server databases, objects, logins, users, and permissions in each registered server.
• Created SSIS Packages to integrate data from Text files and Excel files.
• Created SSIS packages for File Transfer from one location to the other using FTP task.
• Involved in Data Migration of Packages from DTS to SSIS by using advanced features in SSIS (Aggregate, Sort).
• Used Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute Task, Email Task, and different Data Flow Tasks.
• Worked on Extracting Transforming and Loading data using SSIS Import/Export Wizard.
• Worked extensively with Key Performance Indicators (KPIs) and published them to SharePoint for further Business Analysis.
• Import Data Sets from various sources like Oracle, Flat Files, and Excel into SQL Server Data Warehouse.
• Developed Tabular Reports, Sub Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS).
• Performed Sorting, formatting, and Grouping to custom reports in (SSRS) and also published reports to the Report Server virtual directory.

Environment: SQL Server 2000/2005, Windows 2003/XP, Enterprise Manager, SQL Server Management Studio, SQL Server Business Intelligence Studio,.Net 2.0 Framework, SQL Server Profiler, SSIS, SSAS,SSRS, IIS, T-SQL, PL/SQL

Confidential

MS SQL Developer

Responsibilities:

• Created indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and scheduling the reports through standard and data driven subscriptions
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases. Using joins, database links and formatted the results into reports and kept logs.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Increased the performance necessary for statistical reporting after performance monitoring, tuning and optimizing indexes in T-SQL blocks.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Data migration (import & export - BCP) from Text to SQL Server using DTS.

Environment: MS SQL Server 2000, T-SQL, DTS, Windows XP, 2000, MS Visio 2000, MS Projects 2000.