SUMMARY

• I have 8+ years of IT experience, which includes analysis, design, development, testing and implementation of applications, reports and databases (MS SQL Server 2008/2005/2000 ) in production environments.
• Experience in developing and implementing Microsoft SQL Server integration services (SSIS), Microsoft SQL Server Reporting Services (SSRS).
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems.
• In - depth knowledge of Transact-SQL (DDL, DML, DCL), and in Design and normalization of the database tables.
• Good hands on experience in writing and debugging complex stored procedures, cursors, triggers, Inner Joins & Outer Joins, SSIS Export & Import, views and user-defined functions.
• Good understanding indatabaseanddata warehousingconcepts (OLTP & OLAP).
• Good understanding ofMicrosoft ReportingService(SSRS)with Report authoring, Report management, Report delivery andReport security.
• Experience in developingCustom Reportsand different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats usingSQLServerReporting Services(SSRS) in Business intelligence development studio (BIDS).
• Developed various business reports. Reports are provided in PDF-format, HTML-format, and can be printed directly to the specified printer.
• Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Experience in backup and disaster recovery procedures.
• Experience in creating packages, Jobs, Sending Alerts using SQL Mail.
• Having good knowledge in C# and .NET. Updated and Supported VB.net applications.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.
• Strong Technical background with excellent problem solving skills.
• Ability to work on multiple technologies.

TECHNICAL SKILLS

Programming Languages: C, C++, PL/SQL, C#

Databases: SQL Server 2000/2005/2008 , Oracle 11i, MySql

Microsoft Technologies: SSIS, SSRS, DTS, SQL Management Studio

Operating Systems: Windows 7/XP/Vista/2000/NT 4.0/98/95, Linux, UNIX, Mac OS.

SAP Technologies: Business Objects Data Services (BODS)

PROFESSIONAL EXPERIENCE

Confidential, Durham, NC

Sr. SQL BI Developer

Responsibilities:

• Worked with Business Analysts and Users to understand the requirement.
• Created database objects like Tables, User Defined Functions, Triggers, Procedures, Indexes and Views, SQL joins and statements as per the team’s request through team tracks.
• Used different Control Flow Tasks and Data flow Task for Creating SSIS Packages.
• Involved in supporting database & BI (ETL and Reporting) activities for various applications and teams across all business units.
• Created SSIS packages using SSIS script task to import the data into CRM.
• Designing, processing and deploying Cubes from the different fact and dimension tables based on the business requirement using SSAS.
• Worked on facets to get the data from claim Tables.
• Developed reports from these OLAP cubes using SSRS.
• Created Excel based reporting tools using SSAS cube driven data sources.
• Involved in dimensional modeling by Identifying the fact and dimension tables based on the user & reporting requirements.
• Created Monthly portfolio reports using SQL Server Reporting Services (SSRS).
• Created Tabular, Matrix, and Drill down reports for different levels of risk officers and sectors.
• Designed large number of reports using table filters, single value parameters, multi value parameters, dependent parameters and Cascading Parameters.
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
• Created Report Email Subscription using Data Driven and Time Driven Report Subscriptions.
• Queried against Heterogeneous Data Sources like SQL Server, Oracle, to retrieve records for data loads using SSIS 2005/2008.
• Worked with various upstream and downstream systems and customers in interfacing various systems for data extractions, ETL and Reporting needs.
• Used different Control Flow Tasks and Data flow Task for Creating SSIS Packages.
• Used different types of Transformations for Data Conversion, Sorting and cleaning the data from different Sources into Company Format.

Environment: MS SQL Server 2008 R2/2008/2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Facets, Business Intelligence Development Studio (BIDS), MS Excel, Windows XP, SQL Server Management Studio (SSMS).

Confidential, Minnesota, MN

BI Developer

Responsibilities:

• Actively involved in design and development of Centralized Data Warehouse using Microsoft SQL Server 2008.
• Involved in Source Data Analysis, designing Mappings for data extraction, and designing and developing SSIS Packages to load the data from various databases and files.
• Migrated data from Heterogeneous Data Sources and legacy system (Flat file, Access, Oracle, Excel) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Participated in upgrade/migration of MS SQL Server 2005 to MS SQL Server 2008 without service interruption using side-by-side migration.
• Used various Transformations such as Multicast, Merge Join, Lookup, Fuzzy Lookup, Fuzzy Grouping, Slowly Changing Dimension, Aggregate, Conditional Split, and Derived Column Transformations in the SSIS Packages.
• Worked on de-bugging package execution using break points in control flow and data viewer in data flow.
• Used Deployment Utility to deploy the SSIS Packages from Development to Production Environment.
• Scheduled SQL Jobs using SQL Agent to automate all the SSIS packages.
• Involved in design and development of Reports representing information in textual and graphical formats using SQL Server Reporting Services (SSRS).

Environment: MS SQL Server BIDS 2008, Microsoft Visual Studio, SQL Server Management Studio, SSIS, SSRS

Confidential, Pittsburgh, PA

SQL BI Developer

Responsibilities:

• Installed and configured SQL Server 2008 on new machine.
• Migrated SQL Server and DTS to SSIS (ETL).
• Scheduled jobs and monitored job failures to diagnose the problems.
• Experience with high availability ends like Peer to peer Replication and Clustering as well log shipping.
• Hands on experience with backup and restoring databases.
• Dealt with database and table privileges and permissions in SQL 2008/2005.
• Performed database tuning and application tuning to increase Production Database response time.
• Responsible for data portioning and disaster recovery plans in SQL 2005.
• Worked with integration services for transferring and reviewing data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse, which encompassed server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
• Established Inner Join, Outer Join and created Indexes whenever necessary.
• Modified report content and exported reports in multiple formats based on user input.
• Modified existing reports according to requirements of the end users.
• Responsible for gathering/refining requirements from the customer for developing database structure, cube design and reporting.
• Created an SSIS Package for data importing and cleansing. Extracted cleaned and validated.
• Monitored scheduled jobs and alerts. Improved report performance and performed unit testing.
• Provided Full Reporting Life Cycle support using SQL Server Reporting Service 2008.
• Developed Tabular Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS).

Environment: SQL Server 2005/2008, Query Analyzer, SSIS 2005, T-SQL, Excel, Microsoft SQL Reporting Services 2008 (SSRS),MS SQL Analysis Services(SSAS), Windows 2000/XP.

Confidential, Bellevue, WA

SSRS Developer

Responsibilities:

• Responsible for Database design and ER between tables.
• Tuned the database to perform efficiently by managing databases using the options to grow or shrink database files and monitored the size of the transaction log.
• Performed data modeling and design of database schema for ER.
• Created database using SQL Server Enterprise Manager, Database Wizard and Transact SQL and PL/SQL Statements. Specified size and automatic growth options.
• Cleaned up data before transferring it in staging area.
• Created SSIS packages for transferring the data from different systems.
• Configured SQL mail agent for sending automatic emails when a SSIS package is failed or succeed
• Created ad-hoc reports, and complex Enterprise reports (drill down, and drill through reports, Parameterized reports, cascading report) using SQL Server Reporting Services and report manager. Created linked reports using report builder.
• Completed documentation about the database. Analyzed long running, slow queries and tuned the same to optimize application and system performance.
• Performed daily backup and created named backup devices to backup the servers regularly.
• Generated Script files of the databases whenever changes were made to stored procedures or views.

Environment: MS SQL Server 2005, SQL server Reporting Services 2005, SQL, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL.

Confidential, Houston, TX

SQL BI Developer

Responsibilities:

• Developed complex programs in T-SQL, writing Stored Procedures, Triggers and Queries with best execution plan.
• Rewrote Dynamic SQL queries to upgrade SQL Server performance using SQL Server 2008/2005
• Wrote T-SQL queries for (Data pulls) as Per the End Client requirements
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Developed Scripts stored in TFS ( like Version Control )so that any authorized user can access the scripts
• Created SSIS packages for transferring the data from different systems.
• Used SSIS to create Dynamic ETL Packages to validate, extract, transform and load data from Online transaction Processing (OLTP) databases to ODS then loaded to data warehouse databases and involved in Data cleansing in the data transfer
• Involved in High Level Design of ETL Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data)
• Migrated data from Heterogeneous Data Sources and legacy system (Flat file, Access, Oracle, Excel) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Configured SQL mail agent for sending automatic emails when a SSIS package is failed or succeed.
• Generated periodic reports based on the statistical analysis of the data using Report designer of SQL Server Reporting Services (SSRS).
• Involved in creating Stored Procedures to generate SSRS-Reports according to the Business Requirement Documents(BRD)
• Used cascaded parameters to generate a report from two different Data Sets.
• Deployed all the reports to Report server and managed through Report manager

Environment: SQL Server 2005, Query Analyzer, T-SQL, Excel, Microsoft SQL Reporting Services 2005 (SSRS),MS SQL Integration Services (SSIS), Windows 2000/XP.

Confidential

SQL Developer/DBA

Responsibilities:

• Actively involved in gathering User Requirement and Online System Specification.
• Developed ER diagrams and mapping the data into database objects as well as scheduled jobs for backup, and created alert for error reporting.
• Created views as required by front end Java developer for easier implementation on web pages, and triggers on those views to provide efficient data manipulation.
• Created stored procedures and functions to support efficient data storage and manipulation.
• Transformed data from various data sources by creating various DTS packages.
• Optimized the performance of queries with modification in index system for online system.
• Monitored the growth of the database objects for capacity planning.
• Successfully applied schema change scripts to existing objects to synchronize with changing business rules.
• Participated in different testing and debugging of the system.
• Created and managed SQL Server login, database users and Roles.
• Used SQL Server Reporting Services to generate different types of ad-hoc reports.

Environment: SQL Server 2000, T-SQL, Query Analyzer, DTS, Windows 2000 Advance server, Windows NT.