SUMMARY

• Over 7 years of extensive experience in Database Solutions and BI Solutions using Microsoft Technologies
• Experience in installation, configuration of MS SQL Server 2005 & 2008
• Knowledge of upgrade from SQL Server 2005 to SQL Server 2008
• Extensive experience in Design, Development, Implementation & Administration of Database systems using MSSQL 2000/2005/2008 for Batch Processing using DDL, DML, DCL commands for various business applications and Data warehousing Systems (SSRS,SSIS, SSAS)
• Experience in database programming in writing T - SQL Stored procedures, Triggers, Constraints (Primary Key, Foreign Key, Unique) Indexes and Batch Scripts using various DDL and DML commands
• Master in designing and creating highly flexible database architecture to accommodate the requirements and enhancements of the client
• Experience in Writing Complex T-SQL Queries, Dynamic-queries and Complex joins
• Good experience with managing VLDB with SQL Server cluster for OLTP systems.
• Thorough knowledge of addressing Performance Issues and Involved in Query Tuning, Index Tuning, Data Profiling and other database related activities
• Involved in Huge Data Migrations and Data Transfers using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert
• Experience in conversion of packages from legacy systems (DTS to SSIS) and migrating, deploying the packages across Development, UAT and Production environments
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Access
• Involved in Installation, Configuration, Development, Deployment and Troubleshoot Reporting services using SSRS 2000/2005/2008 across various environments
• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2000/2005/2008 )
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS
• Experience in developing applications with ASP.NET, C#.
• Experience in Developing and Extending SSAS Cubes, Dimensions and Data Source views SSAS - Data Mining Models and Deploying and Processing SSAS objects
• Expert in Scheduling Database Backup and recovering the Database from Disaster
• Experience in creating Jobs, Alerts, Database Mail, SQL Mail Agent and scheduled DTS/SSIS Packages.
• Extensive experience in Database administration activities like DB Security (creating users, roles, and assigning permission to them)
• Good understanding of Data Marts, Data Warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services
• Worked with End Users / Customers to understand business requirements, recommended technical solutions and documented functional requirements

TECHNICAL SKILLS

RDBMS/DBMS: MS SQL Server 2000/2005/2008 , Oracle 9i, MS Access 2000/2003/2007

Operating Systems: MS-DOS, Windows Vista/95/98/NT 4.0/XP/2000/2003 Server, UNIX, Linux

Programming Languages: T-SQL, PL/SQL, Dynamic SQL, C, VBA, Visual Basic 6.0, C# .NET, VB .NET, ASP .NET, ADO.NET, XML, HTML, DHTML

Data Design Tools: ER/Studio, ERWIN, MS Visio, Rational Rose, Smart Draw

BI Tools: SQL Server Reporting Services (SSRS 2000/2005/2008 ), SQL Server Integration Services (SSIS 2005/2008), SQL Server Analytical Services (SSAS 2005/2008), Data Transformation Services (DTS), Visual Studio

Tools: /Database Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Performance Point Server, Business Intelligence Development Studio (BIDS), Crystal Reports 9.0, XML

PROFESSIONAL EXPERIENCE

Confidential, New York City, NY

SQL Server Developer/DBA

Responsibilities:

• Interacted with Business Analyst and Team Lead to understand business and system requirements
• Converted Logical Data Model into Physical Data Model using the balanced Normalization in 2nd and 3rd Normal Form for highest performance
• Successfully implemented Physical Database on MS SQL Server 2008
• Moved the static data from various heterogeneous sources like MS Access, MS Excel and text files to SQL Server 2008 Database using BCP, SSIS and dynamic DTS packages
• OLAP experience like Analysis Services, Reporting Services, Business Intelligence, Integration Services
• Created SSIS Packages to migrate slowly changing dimensions
• Fine Tuned Database by creating Indexes on different tables that improve the performance of T-SQL queries on the Database
• Maintained database response times, proactively generated performance reports
• Automated most of the DBA Tasks and monitoring stats using SQL Server Agent and Scripts
• Created Cursors to facilitate the users (credit officers) to scroll through the Queues to perform manual operations on the payment
• Automated many operations by scheduling multiple DTS packages using jobs
• Built Drill Down, Drill through, linked and sub reports using SSRS 2008 to generate all EOD, Weekly, Monthly and Quarterly Reports
• Used SQL Server Profiler to trace the queries with longer execution times and optimized the query execution with the use of Index Tuning Wizard and Rebuild indexes, where necessary
• Used Internet Information Services(IIS) to deploy test applications
• Designed GUI to run SSIS Package from Front End Application. Implemented Class And method with the use of C#, ASP.net
• Participated in designing Disaster Recovery plan for SQL Server Database and actively monitored the maintenance of database backup at scheduled time

Confidential, Albany, NY

SQL Server Developer/DBA

Responsibilities:

• Attended the Business Requirements walk through sessions and Design Walk Through sessions to understand about the project
• Worked closely with the Data Modeler during the creation of a Physical Data Model
• Involved in Logical and Physical Data Modeling Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, User defined Data Types and functions in SQL Server 2008
• Created Backups for Databases and automated the process in Production environment
• Created Transactional Replication, Pull Subscription and defined editions for data transfer
• Created Indexes on all the tables for fast retrieval of the data and involved in Performance Tuning of various scripts to reduce the execution time of the jobs
• Using SSIS, built high performance data integration solutions, including extraction, transformation, and load (ETL) packages for Data Warehousing
• Wrote Merge SQL scripts to incorporate the Insert Else Update Logic for the data extracted using ETL Tool (Ab Initio)
• Created audit trails of activities on Database using triggers on backend
• Helped the ETL Development Team during Historical Data Load ( Extracting few gigs of UNIX files received from the source team and bulk loading the same into the target)
• Created SSIS Packages to support business process and data transformations through Sql Server 2008/2005
• Developed and Tested SSIS (SQL Server Integration Services) Packages for data extraction, transfer, and loading for Aggregated Reporting
• Wrote stored procedures for Automatic Scripting to backup transaction logs
• Deployed and Scheduled the SSIS Packages to various destinations
• Good experience and knowledge of working with Report Manager, Report Builder, Reporting Security and Reporting Services Configuration manager
• Created different user level groups, and assigned appropriate permission level to the Databases
• Created Distributed Partitioned Views, Debugging / Troubleshooting Stored Procedures, upgrading existing ones
• Helped the team resolve pre-prod / UAT issues
• Provided Production support, for the application built, during warranty period (before transitioning the application to Level 3 Production Support Team)

Confidential, Northbrook, IL

SQL Server Developer

Responsibilities:

• Participated in the daily/weekly onsite & offshore calls to discuss about the requirements, design decisions and the deliverables / milestones
• Involved in System Analysis & Design of the Enterprise Data Warehouse implementation
• Identified various source systems for data feeds and worked closely with the source teams to understand the data file formats and file exchange methods
• Was responsible in the relational modeling of the Data Warehouse
• Created mappings to load data extracted from flat files, COBOL files and XML files to staging area using SQL Server SSIS
• Extracted customer data from SQL Server database and loaded to warehouse
• Implemented Ralph Kimball Star schema methodologies with subject area data marts
• Implemented SSIS with SQL Server stored procedures for data manipulations
• Analyzed, designed, developed, implemented and maintained moderate to complex initial load and incremental load mappings to provide data for Enterprise Data Warehouse (EDW)
• Implemented Type II slowly changing dimension to maintain current information and history information in dimension tables
• Hands on Development with ASP.NET and C#.
• Worked with the ETL Team for Creating Connected and unconnected transformations to look up the data and handle the claims
• Developed and maintained SSIS packages to load data into the warehouse using Extract, Transform, and Load (ETL)
• Created E-mail notifications tasks using stored procedure scripts
• Wrote stored procedures to implement business rules and validations
• Setup Log Shipping or Replication for mission critical databases for High Availability and Disaster Recovery
• Created procedures to drop and recreate the indexes in the target Data warehouse before and after the ETL loadings
• Performance tuning of SQL Scripts and stored procedures and Used scheduler for scheduling jobs as batch process on timely basis
• Troubleshoot and monitor of MS SQL Server issues

Confidential 

SQL Server Developer

Responsibilities:

• Participated in daily Offshore - Onsite Calls to understand about the module requirements, and about the weekly deliverables status
• Setup meetings with the Onsite Coordinator to get the issues/doubts clarified, before owning up responsibility for the respective module(s)
• Extensive participation in logical and physical database design, and normalizing the database to accommodate possible changes in the requirement
• Wrote Stored Procedures to handle complex calculations and wrote logic to maintain the history of entities which was also passed on to the application via Stored Procedures
• Explored the use of User Defined Functions to encapsulate commonly used logic in the stored procedures and maximized the readability of such Stored Procedures
• Transferred data from flat files, Excel spreadsheets and heterogeneous data to and from SQL Server using DTS and also used BCP and Bulk Insert
• Performance tuning of SQL queries and stored procedures using SQL Profiler, Estimated Query Plan and Index Tuning Wizard
• Created and managed users, roles and groups and handled database security
• Maintained database and Backup/recovery, Defined Database Maintenance Plan which was a scheduled job
• Enforced Referential integrity of data by creating different constraints
• Participated in monitoring Database performance and trouble-shooting at the server and database level
• Provided support during the release of various patches by creating tables, populating data and granting privileges to users and roles
• Coordinated with TRA/Commercial DBA’s and core group(working at Onsite) in solving Application problems