SUMMARY

• Over 7 years of IT experience as SQL developer in design, development and administration using MS SQL Server 2008, 2005 and 2000 of various applications for e - business, Financial, Insurance, Healthcare and Freight Audit Company.
• Strong experience in Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS) packages, Reporting Services (SSRS) and Analysis Services (SSAS), Experienced in Migrating databases from SQL Server 2000 to SQL Server 2005.
• Experience in developing, monitoring, extracting and transforming data using DTS/SSIS Import Export Data, Bulk Insert and DTS/SSIS Packages.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2005 and SQL Server 2008.
• Excellent report creation skills using Microsoft SQL Reporting Services (SSRS).
• Worked on creating client reports and custom reports (On demand, Ad-hoc Reports, Frequency reports, Summary Reports, Sub Reports, Drill-down, dynamic grouping, Cross-Tab, graphical, aging reports etc) using SQL Server Reporting Services 2005.
• Extensive experience in creating multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and charts.
• Strong experience with SQL Server and T-SQL in constructing complex stored procedures, triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, exceptional handling, and data integrity.
• Written Complex Stored procedures as well as analyzing and debugging existing complex stored procedures, suggested creating Clustered and Non Clustered indexes on tables.
• Created and scheduled Jobs, Alerts, SQL Mail Agent and DTS/SSIS Packages.
• Experienced using in FTP and SFTP servers to upload files.
• Experience with SQL Performance tuning and transactions analysis, thorough understanding of indexes and statistics.
• Designed and developed OLAP Cubes and Dimensions using SSAS.
• Experience in Designing and Building the SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using Analysis Services.
• Experience and outstanding knowledge of high availability SQL Server solutions, including Log shipping, Replication and SQL Server clustering.
• Extensively worked on system analysis, design, development, testing and implementation of projects (SDLC) and capable of handling responsibilities independently as well as a proactive team member.
• Experienced in generating reports like matrix, parameterized and drill through reports using SSRS and developed stored procedures using functions to generate various kinds of reports using SSRS.
• Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
• Experience in using tools like server objects (linked servers), Index Tuning Wizard, SQL Profiler, CLR Functions and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Good hands-on experience with creating Partitioned Tables and Partitioned Views.
• Extensive knowledge of normalization and relational database management systems.
• Proficient in Logical and Physical database design & development (using Erwin, normalization, dimension modeling, Data Modeling and SQL Server Enterprise manager).
• Expert in data architecture and data modeling, using Erwin in Transact-SQL (DDL, DML), views, stored procedures and also using database triggers and VB Script.
• Identifying & resolving blocking and deadlocks.
• Excellent problem resolution and communication skills with ability to work under pressure in a highly visible role and 24x7 on call Production support.

TECHNICAL SKILLS

Programming Languages: C, C++, T-SQL, XML, Visual Studio.Net 2003/2005/2008.

RDBMS/Database: Ms Access, MS SQL Server 7.0/ 2000/2005/2008 , DB2.

Reporting Tools: SQL server Reporting Services (SSRS), Crystal Reports

Database Tools: SQL Profiler, Query Analyzer, DTS, SSIS, SSRS.SQL Mail, Erwin, Toad

ETL Tools: Data Modeling

DTS,SSIS: Logical and Physical Data Modeling, Star Schema Data Modeling, Snow-Flake Modeling, Fact, Dimension tables, Erwin 4.0/3.0, Visio 2000.

MS Suite: MS outlook, Microsoft office 2003/2010, MS Access, Excel

Operating Systems: Win 7/XP/2003/2000, Windows NT/98 & UNIX (Linux)

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

SQL Server Developer

Responsibilities:

• Involved in analysis of the system that included an interaction with top level management and customers to gather the requirements.
• Prepared the SRS documentation, which includes work estimation.
• Developed the functional prototype to get end user approvals for further system implementation.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS packages.
• Actively involved with Backup/Restore Strategy team.
• Creating tables, views, indexes, triggers and constraints in SQL Server 2008.
• Created Stored Procedure, Functions, Triggers, Indexes, User defined Functions, Constraints from various complex multi-table relationships for various DTS/SSIS packages.
• Created various kind of reports like f004, f006, f003, Aging, Summary lane reports using Reporting Services.
• Automation of creating Accounting code module for each bill using SQL server agent.
• Bulk data migration using SSIS from flat files.
• Designed SSIS packages to pull the data from FTP site to SQL Server 2008.
• Designed DTS/SSIS packages to populate the data into reporting forms.
• Responsible for creating DTS/SSIS packages, Scheduling packages in SQL Server 2008 database.
• Improved data load performance by analyzing database design, query plans and database settings.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Experience on Query optimizations techniques in performance tuning.
• Created technical documentation to for future reference.
• Designed Microsoft Excel Templates according to the client’s requirement and choice by writing VBA macro to populate the data and format the Excel file.
• Designed Excel formulas to validate the data in the reports.
• Developed Chart Reports, Drill Through Reports, Master Detail Reports and Multiple Reports.
• Created various weekly and monthly reports using Table, Matrix and List Controls in SQL Report Services.
• Involved in designing and developing of Intranet Portal using ASP.NET
• Analyzed data by using SSAS and building a series of MDX statements to query your SSAS cube and produce Pivot tables
• Built SSAS cubes that used the built-in SSAS features for the time dimension and associated time intelligence.
• Providing 24/7 On-call Support.

Environment: SQL Server 2000/2005/2008 , Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer, MS SQL Server DTS, SSIS, ASP.NET, C#.NET, SSRS 2005/2008, VBA, VB Script, IBM Informix, and UNIX.

Confidential, San Francisco, CA

SQL Server Developer

Responsibilities:

• Created and developed tables, views, functions, stored procedures, cursors and triggers.
• Involved in Installing SQL Server 2008 and creating users and Groups.
• Designing logical and physical design for the database for the given user requirements.
• Created complex Stored Procedures, Triggers, Cursors, Tables, Views and SQL Joins and other statements for various applications, maintained referential integrity and implemented complex business logic.
• Developed various T-SQL triggers and stored procedures to retrieve updated and deleted data from different servers.
• Created and integrated user defined functions and stored procedures for reporting purposes.
• Created DTS packages for the extracting, transforming and loading the data.
• Created database tables, indexes and rules.
• Used Query Profiler to optimize queries in SQL.
• Helped in translating business requirements into technical design specifications and preparing high-level documentation for the Database design, Database objects etc.
• Designed and developed various complex reports.
• Generated reports that can handle dynamic grouping and dynamic sorting.
• Used SQL Server Profiler to tune the performance of the stored procedures and functions to improve the report generation time.
• Fixed issues in the existing crystal reports.

Environment: SQL Server 2005, SS Integration Services (DTS), T-SQL, MS Excel 2003, MS Access 2003, Enterprise Manager, MS SQL Query Analyzer, SQL Profiler, MS SQL Server Reporting Services, Crystal Reports 9.

Confidential, Raleigh, NC

SQL Server Developer

Responsibilities:

• Created design documentation, test plan, Audit check off sheets and user guides.
• Designing logical and physical database structure to facilitate analysis of data from both operational and customer perspectives.
• Developed highly scalable report automation system utilizing SSIS, T/SQL, stored procedure, cursor, Enterprise Manager, Query Analyzer.
• Investigated various platform, languages, database designing tools and suggested the best solution to upper management considering reusability, scalability and maintainability.
• Using SQL Profiler to estimate the Slow Running queries and performance tuning purpose.
• Designed SSIS packages to extract, transform and load data to SQL tables from txt and csv file received from various clients.
• Created standard tables and mapped columns from various client tables.
• Gathered various business logics and developed numerous reusable stored procedures compatible for all clients.
• Created SSIS packages to integrated window application to DTS and set control file path and timeout value.
• Created SSIS package to re-import data to SQL table from output file and mapped column appropriately.
• Analyzed output files, applied necessary business logics and created stored procedures accordingly.
• Created stored procedure to check errors and to extract records for Reporting.
• Designed SSIS to extract appropriate records and output them to DM Warehouse.
• Developed several scripts to synchronize stored procedures, SSIS to log messages and outputs.
• Created SSIS tasks to email output and log messages using ActiveX script.
• Designed a master SSIS to execute all synchronized stored procedures, other SSIS.
• Develop script to set parameters for various clients and schedule SSIS appropriately.
• Participated in data mining and validation process.
• Effectively hosted several web meeting and showed many design and code review demonstrations.
• Completed many Unit and Integration, functional and acceptance testing.
• Trained team members for future enhancement and maintenance of the system.

Environment: SQL Server 2005, Visual Studio 2005, C#.NET, Windows Application, Enterprise Manager, Query Analyzer, T-SQL, Visual Source Safe, Excel.

Confidential, Troy, MI

SQL server Developer

Responsibilities:

• Monitor and manage transactional and snapshot Replication.
• Involved in Installing SQL Server 2005 and creating users and Groups.
• Creating stored procedures, scripts, cursors for the Bulk application, testing on the test servers and moving them to production.
• Experience in Database Backup and recovery.
• Created Replication strategies.
• Managed Disk space, memory and User connections.
• Working on different DR strategies with Log Shipping, Replication and Clustering.
• Managing databases for website.
• Developed DTS Packages to transfer the data between SQL Server and other database and files.
• Job Scheduling & Re-Scheduling on Production Databases.
• Responsible for database creation, database tuning, performance planning and database administration.
• Monitored and modified Performance using execution plans and Index tuning.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Process Code Promotion Requests for QA, Staging and Production environments.
• Create and manage user accounts and track their activities as and when required.
• Interacting with the users and troubleshooting the problems.
• Assisted to create Disaster Recovery plans.
• Manage data transfer between SQL Server and other heterogeneous databases including IBM DB2 and Oracle.
• Providing 24/7 On-call Support.

Environment: SQL Server 2005, SQL Server 2000, PL/SQL, Windows 2003 Advanced Server, VB Script, DTS, Oracle, SSIS, Excel, Visio, Access, ASP.Net, IIS and VB 6.0, ERWIN.

Confidential

SQL server junior Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development, change management, deployment and user training.
• Involved in Physical / Logical design of database, creating and managing the database and all the database objects.
• Designed and developed tables, view, stored procedures, functions, cursors and triggers in MS SQL Server database on Windows NT platform using TSQL.
• Created SQL reports, data extraction and data loading scripts for different databases and schemas.
• Designed and developed a fully functional database by creating the logical database design and implementing the physical database design using MS Access and SQL Server 2000.
• Designed and developed forms using Visual Basic.
• Designed and developed reports using SQL Reporting Services.

Environment: Visual Basic 6.0, SQL Reporting Services, SQL Query Analyzer, SQL Server 2000, T-SQL, and Windows 2000, MS Access 2000, MS Excel 2000.