SUMMARY

• SQL Developer with 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 knowledge 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)
• Knowledge on Agile
• Experienced in VB.Net
• Experienced in Reporting Services (SSRS).
• Knowledge in STAR Schema, Snow Flake Schema, FACT Tables and Dimension Tables.
• Experienced with 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 knowledge 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 teh 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 with 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 teh defects by using JIRA system. Staging DB to Data warehouse
• Provided 24 x 7 Production support for teh database and application issues.
• Used calculations, sorts, filters and sections to enhance data presentation in reports. Created many Cascaded parameters in teh 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 teh 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.
• Developing and maintaining a SQL Server Analysis Services (SSAS Tabular or Multidimensional) model.
• Designed various Star schema as directed by teh 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 teh 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 teh data on daily basis from teh OLTP system, Staging DB to Data warehouse.
• Designed and created Report templates, bar graphs and pie charts based on teh financial data.
• Worked on VB.Net
• Experienced in Agile

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 teh 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 with 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 teh 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 teh packages in both teh environments (Development and Production).
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded teh 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 teh data from different Sources into Company Format.
• Training sessions to business users for SSAS Tabular models, Power Pivot, and Power View Reports
• 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 teh business logic and also created clustered and non-clustered indexes.
• Advised optimization of queries by looking at Execution Plan for better tuning of teh database.
• Good Knowledge on VB.Net

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

Confidential, Atlanta, GA

SQL Developer

Responsibilities:

• Created several tables, views, stored procedures, functions using SQL Server 2005 T-SQL. These objects were created based upon teh 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 teh faster processing of reports.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance teh performance of database servers. Created Indexes to speed up teh queries

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