SUMMARY

• SQL Developer wif 7+ year experience and exposure to all phases of SDLC which includes Design, Data Modeling, Analysis, Development, Coding, Testing, Performance tuning, Production Support, Configuration and implementation using databases and SQL server Business Intelligence / Data warehouse using Microsoft Technologies. Good noledge and experience of key Oracle performance - related features, such asQuery Optimizer, Execution Plans, Hints, Indexes, views.
• Experienced in relational database design, SQL queries, Stored procedures, Functions, Triggers, Performance tuning.
• Experienced in Integration Services (SSIS) ( Extraction, Transformation and Loading)
• Experienced in Reporting Services (SSRS).
• Knowledge in STAR Schema, Snow Flake Schema, FACT Tables and Dimension Tables.
• Experienced wif DBA activities like creating users, granting and revoking privileges on database objects and taking backups.
• T-SQL coding and testing: functions, views, triggers, stored procedures, etc.
• Good Knowledge in system tables and stored procedures using T-SQL.
• Created parameterized reports, cascading reports, drill down reports, drill through reports, sub reports and ad-hoc reports in SSRS. Created linked reports using report builder.
• Implemented error handling techniques like Loggings, Checkpoints and redirection in SSIS Packages and created configurations for successful deployment of ETL Packages in various environments.
• Experienced in transforming complex business logic into Database design and maintaining it by using SQL functionality such as Stored Procedures, User Defined Functions, Views, and DTS.
• Developed skills in stored procedures, Ad-Hoc SQL Queries, triggers, UDF, custom DTS packages using Visual Basic.
• Debugged complex SQL scripts and Stored Procedures, implemented error handling techniques and query optimization techniques by analyzing execution plans, index maintenance and updating statistics.
• Reviewed, analyzed, and modified programming systems including stored procedure and TSQL code in database, testing, debugging.
• Domain noledge of CRM, Insurance, and Finance.
• Provided after hours and 24/7 Database Maintenance and Production Support.
• Possess excellent management and communication skills.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.

TECHNICAL SKILLS

Databases: SQL Server 2008,2005,2000, Microsoft Access

SQL server Tools: (DTS), SSIS,SSRS,SSAS, Erwin

Operating Systems: Windows 7/XP/2008/2003/2000/NT/98/95

Testing Tools: Quality Center, Manual Testing

PROFESSIONAL EXPERIENCE

Confidential, FL

DBA/BI Developer

Responsibilities:

• Worked wif project lead and business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications.
• Debugging and testing TSQL code and stored procedure. Log and manage the defects by using JIRA system. Staging DB to Data warehouse
• Provided 24 x 7 Production support for the database and application issues.
• Used calculations, sorts, filters and sections to enhance data presentation in reports. Created many Cascaded parameters in the reports using SQL SSRS.
• Developed many Tabular Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS). Also created many multi valued parameters in the reports.
• Tuning of Slow Running Queries or inefficient Queries for Optimal Performance using SQL Profiler and Managing Indexes and Statistics.
• Experience in tuning Stored Procedures, Functions and Index, Triggers.
• Created user defined roles and granting privileges to access database and database objects.
• Created SSIS packages to download data from FTP sites and populating into different databases and tables.
• Implemented error handling techniques like Loggings, Checkpoints and redirection in SSIS Packages and created configurations for successful deployment of ETL Packages in various environments.
• Designed various Star schema as directed by the management for different departments
• Applied various data transformations like Data Conversion, Multicasting, Conditional Split, Derived column in SSIS.
• Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers.
• Responsible for creating database objects like table, Views, Joins, Store Procedure, Triggers, Functions etc. using T-SQL to store data and to maintain database efficiently.
• Union Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, Staging DB to Data warehouse.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.

Environment: SQL Server 2005/2008, MS Visual Studio 2005/2008, Windows 2003, SSRS, SSIS.

Confidential, GA

SQL Developer

Responsibilities:

• Wrote simple and complex queries to analyze the production databases.
• Wrote DML to manipulate data when requested insert, update and deletes.
• Created cubes using SQL server Analysis Services (SSAS) and optimized these cubes.
• Designed and deployed reports wif Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly including current status. Staging DB to Data warehouse
• Implemented Event Handlers and Error Handling in SSIS packages.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Developed various types of complex reports like Drill Down, Drill through, Link reports.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Created ETL packages wif different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Used differentControl Flow Tasks and Data flow Taskfor Creating SSIS Packages. Used different types ofTransformationsfor Data Conversion, Sorting and cleaning the data from different Sources into Company Format.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Sequence Container etc.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.

Environment: SQL Server 2008/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSIS, SSRS) and Windows Server 2003

Confidential, GA

SQL Developer

Responsibilities:

• Created several tables, views, stored procedures, functions using SQL Server 2005 T-SQL. These objects were created based upon the functional specification.
• Migrated DTS objects to SQL Server Integrated Services (SSIS) environment. Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2008.
• Developed daily, weekly and monthly reports regarding assigned projects which requested by managers and clients.
• Developed Report Models for building Ad hoc reports using Crystal Reports. Developed optimal stored procedures and queries to create data sets for reports.
• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers. Created Indexes to speed up the queries

Environment: Windows Server 2003, SQL Server 2005/2000, SQL Server Business Intelligence Development Studio (SSIS, SSRS)