SUMMARY

• 7+ years of IT industry experience with Microsoft SQL Server 2000/ 2005/2008/2008 R2, in OLTP and OLAP (Data warehousing) environments.
• Good understanding of Normalization/De - normalization, Database design, Entity-Relationship (E-R) model and application oriented design.
• Experienced in OLTP and OLAP design and implementations and in dimensional modeling using Star /Snowflake schemas and knowledge of Ralph-Kimball Methodology.
• Good understanding and knowledge of database design.
• Strong Transact-SQL query writing skills (DDL, DML, and DCL).
• Good experience in creating objects such as Databases, Tables, Stored Procedures, Triggers and Cursors, Constraints, Indexes, Views in Microsoft SQL Server 2000/2005/2008/2012.
• Experience in optimizing the database by creating various Clustered, Non-clustered Indexes.
• Efficient usage of DBCC commands to increase the performance of the query.
• Experience in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor, DBCC Commands, Query Execution Plans.
• Experience in Database Backup and Recovery procedures.
• Experience in Performance Tuning and Query Optimization.
• Good experience in SQL Server Business Intelligence Tools like SQL Server Integration Services (SSIS) 2005/2008/2008 R2 and SQL Server Reporting Services (SSRS) 2005/2008/2008 R2.
• Strong Data Extraction, Transforming and Loading (ETL) experience in using various tools such as Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Bulk Insert/ BCP utility.
• Experience in creating/deploying Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS) packages using various data transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
• Designed, Developed and implemented SSAS OLAP Cubes using SQL Server Analysis Services.
• Expertise in report generation using SQL Server Reporting Services 2005/2008/2008 R2 (SSRS).
• Experience in creating different types of reports such as Cross-Tab, Drill-down, Tabular, Summary, Sub reports, Charts and Graphs and formatting them using SSRS 2005/2008.

TECHNICAL SKILLS

Operating Systems: Windows NT/95/98/XP/2000/Server 2003

Databases: MS SQL Server 2000/ 2005/2008/2008 R2, Oracle 8i/9i, MS Access, Netezza

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

Database Tools: SQL Profiler, SQL Query Analyzer, Management studio Index Analyzer, DTS Import/Export, Backup Server, Replication server, SQL Agents, SQL Alerts, SQL Jobs, Visual Source Safe.

Skills and Languages: Transact SQL (T-SQL), PL/SQL, C, C#, VB Script

DB Modeling Tools: MS Visio, Erwin

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal reports 8.0/9.0/10.0 , MS Excel.

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, North Carolina

BI Developer (SSIS,SSRS)

Responsibilities:

• Continuously interacted with end user to gather business requirements to develop Business Requirement Document (BRDs) and ETL specifications.
• Wrote T-SQL statements for retrieval of data and involved in performance tuning of T-SQL queries and Stored Procedures using SQL Profiler and execution plans.
• Used T-SQL to create database tables and database objects like functions, views, stored procedures, indexes and triggers.
• Worked with complex SQL statements using joins, sub queries, cte's and correlated sub queries.
• Deployed and Scheduled different SSIS packages and Jobs using SQL Server Agent.
• Created SSIS Packages using Pivot Transformation, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data to Excel Spreadsheets.
• Responsible for deploying the packages in both UAT and Production and for scheduling the SSIS jobs.
• Deployed and scheduled Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Generated the reports for AXA and other financial advisors using SQL Server 2005/2008R2 Reporting Services (SSRS).
• Created Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.

Confidential, Charlotte, North Carolina

BI Developer (SSIS,SSRS)

Responsibilities:

• Develop ETL Packages and Reports.
• Create tables,stored procedureswhen required.
• Served as the primary point of contact for most of the Enterprise Business intelligence design and development.
• Worked withT-SQLtocreateTables, Views, Triggers and Stored Procedures.
• Created complexjoinsand implementedConstraintson tables for maintainingData Integrity.
• Experience in creating complex SSIS packages using appropriatecontrol and data flow elementswithSSIS Standards likeerror handling, loggingand working withpackage config files.
• Hands on experience in using different transformations likedata Conversions,lookups, derived column transformationsetc, fordata cleansingto remove unnecessary columns, eliminateredundant,inconsistent dataand unnecessary Datalike removingempty rowsusing SSIS.
• Created DTS (SSIS) packages to get data from various sources (DB2, Oracle).
• Worked with Team foundation server (TFS) offeringsource control, data collection,reporting, and project tracking.
• Reduced the overallETL time bySQL Query performanceTuning. Discussed with user interface and external interface teams over the performance issues and provided solutions.
• Create databases, tables, and fields for data entry,performingdatabase capacity planning.
• Enhancing anddeploying the SSIS packagesfrom development server to production server andscheduled jobs.
• Supported the production team and other groups outside the team when issues rose in the packages.
• Create Tablix reports, Tabular based on requirements.
• Created Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.

Environment: SQL Server 2008, ORACLE, DB2, BIDS 2008,Visual Studio 2008

Confidential, Mountlake Terrace, Washington

BI Developer (SSIS,SSRS)

Responsibilities:

• Developed complex programs in T-SQL, writing Stored Procedures, Triggers and Queries with best execution plan.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Used dynamic SQL, to increase the readability, efficiency and quality of code.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Worked with Exception handling with @@error and with Try/catch.
• Designed SSIS Package for extracting data from heterogeneous source systems, transform and load into the Staging Data base.
• Created projects to transfer data from MS Excel to SQL Server in SSIS.
• Extensively worked in ETL and data integration in developing ETL mappings and scripts using SSIS.
• Worked on Data transfer from a Text file to SQL Server by using bulk insert task in SSIS.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into SQL server Database.
• Extensively used Derived column transformation for data conversion.
• Worked on data cleansing techniques using look ups, conditional split.
• Handling the errors during data moving and Sequencing the task as per requirements.
• Created SSIS Packages for Incremental Loading and slowly changing dimensions.
• Developed Query for generating drill down and drill through reports in SSRS 05/08.
• Uploaded reports on to the report manager and organized them into folders.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports. Designed and implemented stylish report layouts.
• Identified and worked with Parameters for parameterized reports in SSRS 2005/2008.
• Experience in Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
• Created Development and Production support documents.

ENVIRONMENT: MS SQL Server 2008/2005/2000/7.0 , SSMS, Business Intelligence Development Studio(BIDS) 2008/2005, MS Visual Source Safe, MS-Visual Studio, Team Foundation Server.

Confidential, Las vegas, Nevada

BI Developer (SSIS,SSRS)

Responsibilities:

• Worked withT-SQLtocreateTables, Views, Triggers and Stored Procedures.
• Created complexSQL stored procedures using Microsoft SQL Server 2008 and 2008 R2.
• Extensive use of dynamic SQL, to increase the performance, efficiency and quality of code.
• Continuously interacted with Business Analysts and end users to gather business requirements.
• Created SSIS packages to extract, transfer and load data into the data warehouse on a daily basis.
• Developed processes to extract the source data and load it into the data warehouse after cleansing, transforms and integrating.
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS.
• Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data mart.
• Extensively involved in designing theSSISpackages to export data ofheterogeneous data(like XML, Excel, CSV, PGP, Flat file) source to staging tables in SQL Server Database.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc 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.
• Developed Tablix Reports, Sub Reports, Matrix Reports, Charts, Ad Hoc reports using SQL Server Reporting Services (SSRS).
• Created Tabular, Charts and graphs as per customer requirements Using SSRS.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Worked on Dashboards using SSRS.
• Deployed reports on Microsoft office SharePoint (Moss).

Environment: MS SQL Server 2008/2008 R2, MS SQL SSRS 2008, SSIS 2008

Confidential, Fort lauderdale, Florida

SQL Server/BI Developer

Responsibilities:

• Implemented Complex business logic with User-Defined-Functions, Index, Views and also created User Defined Data type, Clustered & Non-clustered Indexes.
• Implemented dimensional data warehouse model using Ralph Kimball methodology.
• Created score cards with advanced set of dashboards using MS Office Performance Point Server 2007 Dashboard Designer.
• Developed Tablix Reports, Sub Reports, Matrix Reports, Charts, and Drill down reports, Ad Hoc reports using SQL Server Reporting Services (SSRS).
• Created various complex reports and manage them using SQL Server Reporting Services (SSRS 2008/2005) according to ERLC.
• Designed and developed Reports in SQL Server 2005 Reporting Services (SSRS).
• Involved in migration and Conversion of Reports from SSRS .
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Creating Tabular, Charts and graphs as per customer requirements Using SSRS.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve PII user data from the Flat files on monthly and weekly basis.
• Creating and running SSIS Packages for Import and Export of Heterogeneous Data.
• Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc 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.

Environment: SQL Server 2005/2008, ORACLE,MS Access, EXCEL, VBScript, HTML, XML, Visio, Windows Server 2000/2003, ASP.NET, VB.NET, BIDS 2005/2008,Visual Studio 2005/2008

Confidential, Mayfield village, OH

BI Developer(SSIS,SSRS)

Responsibilities:

• Created DTSX Packages to import and export data from Excel Spreadsheets, Text files and CSV files.
• Extracting the data from the different sources (CSV files, oracle, and MS SQL 2000) and stored the data into the intermediate Staging Database using the SSIS ETL tool.
• Created and scheduled SQL jobs to run SSIS packages on a daily basis.
• Configured the loading of data into Slowly Changing Dimensions using Slowly Changing Dimension wizard. Also implemented checksum SCD method to load the data into date warehouse.
• Experience in creating complex SSIS packages using appropriatecontrol and data flow elementswithSSIS Standards likeerror handling, loggingand working withpackage config files.
• Hands on experience in using different transformations likedata Conversions,lookups, derived column transformationsetc, fordata cleansingto remove unnecessary columns, eliminateredundant,inconsistent dataand unnecessary Datalike removingempty rowsusing SSIS.
• Created DTS (SSIS) packages to get data from various sources (netezza, Oracle).
• Created Tablix reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Created several Complex Reports (sub reports, graphical, multiple groupings, drilldowns, parameter driven, formulas, summarized and conditional formatting) using SSRS.
• Created Jobs Performance report that queries sys tables and shows how long each job ran and weekly-average duration using SSRS.
• Developed Stored Procedures and Views to be used to supply the Data to the Reports. Complex formulas were used to show derived fields and to format the data based on specific conditions.
• Maintenance and provide support to the users for the deployed reports.
• Created Ad-Hoc Reporting with Report Builder and Programming Reporting Services.
• Created Development and Production support documents.
• Developed Query for generating drill down reports in SSRS 2005/2008.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Created subscription to reports.
• Used ETL (Extraction, Transformation, Loading) from heterogeneous source systems. Assisted DBA in using the repository manager to give permissions to users to create new users and repositories.

Environment: MS SQL Server 2005/2008, MS SQL SSRS, SSIS, Visual SourceSafe, Windows 2003 server

Confidential

MS SQL Server Developer

Responsibilities:

• Created ER diagrams Logical/Physical using Erwin.
• Assisted in database design, creation of ER diagrams, phasing from development to QA and to production environment.
• Creation of user databases and installation of MS SQL SERVER 2000/7.0.
• Worked in Project planning, Designing & Implementation.
• Involved in creating tables, views, stored procedures, triggers, and cursors and other SQL joins and statements for applications.
• Worked with various business groups while developing their applications.
• Writing the stored procedures, checking the code for efficiency. Routine backups and restoration. Data transfers between various servers using BCP.
• Defining and creating indexes for query optimization and revising scripts for optimal performance.
• Resolving various performance issues and running DBCC commands, SQL trace SQL profiler and NT monitoring tools.
• Using data transformation services (DTS) to populate data from various data sources using the concept of OLE DB.
• Installing SQL SERVER service packs based on the errors and flaws that are found in the application.
• Testing the stored procedures performance and its path of execution by using SQL profiler.
• Recovering the backups of SQL SERVER production databases in test server environment.