SUMMARY:

With more than 11 plus years of experience in the information technology industry, developed a wide range of experience in analysis, development, documentation, coding, testing and implementing solutions.

TECHNICAL SKILLS:

ETL: Microsoft SQL Server Integration Service (SSIS), Informatica 7.2, Oracle,Warehouse Builder, SAP BIW and BI 7.0.

Platforms & OS: Windows NT/2000/ XP, Windows 7, LINUX.

Database: MS - SQL 2012, MS-SQL 2008 R2, MS-SQL Server2008, MS-SQL Server 2005, MS-SQL Server 2000, Oracle 10g, Oracle 9i, DB2.

Reporting: SQL Server Analysis Services (SSAS), SQL Server Reporting Service (SSRS), SAP Business Explorer (BEX), Business Objects (BOBJ), Crystal Report.

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

Packages: Microsoft Office 2000,2003,2007,2010

PROFESSIONAL EXPERIENCE:

Confidential

Senior Database Engineer

Responsibilities:

• Managing SQL Server 2000,2005,2008,2008 R2, 2012 and Oracle 11G Servers in 24*7 mission critical hospitals Environment.
• Successfully installed and configured SQL Server 2008 R2 Cluster in Windows 2008 R2 Environment.
• Successfully installed and configured SQL Server 2012 Cluster in Windows 2012 VM Environment.
• Successfully implemented AlwaysOn Availability Groups- between a SQL Server Clustered 2012 and Standalone 2012 instances.
• Migrate and upgrade the databases to 2012 server.
• Trouble shoots the query performance and the application slowness.
• Build SSIS packages to do SQL Auditing and implementing Audits all the SQL Servers.
• Supporting and backing up the 8 terabyte size EPIC- Clarity database running in the Oracle 11g Environment.
• Supporting the data warehouse, BI, PeopleSoft and Kronos databases running in Oracle and SQL Server.
• Implemented DTC in SQL Server 2012 and SQL Server 2008 R2
• Configured SQL instance as CMS (Central Management Server) in SQL Server 2008 R2 and SQL Server 2012 by using SQL Server Management Studio (SSMS).
• Build, configure and support SQL Server 2012 SP2 -Epic Cogito Data ware house databases for reporting.
• Successfully completed in place upgrades from SQL Server 2005 SP4 to SQL Server 2008 R2 SP3 for multi instances of SQL Server.
• Successfully completed side by side upgrades of SQL Server databases from SQL Server 2000. 2005, 2008, 2008R2 to SQL Server 2012.

Confidential

Senior Database Administrator

Responsibilities:

• Worked with 50+ different clients in the fitness club industry and converted there data to Fiserv’s ( Confidential ) COMPETE software using SQL SERVER, T-SQL and SSIS.
• Administered all development, QA and production SQL Servers/databases.
• Supported and trained new IT DB staff on administration, replication, backup and restore of relational databases, specifically Microsoft SQL Server 2008 R2
• Completed SQL Installation, database creation and service pack installation successfully
• Use Light Speed to compress and restore the back up in SQL SERVER 2005.I use spot light to discover and resolve performance issues before they impact the end users and service levels.
• Helped and performed all aspects of database administration including restore, backups and replication. Got hands on experience with SSIS in Business Intelligence environment.
• Hands on experience with Red Gate tool to compare Schema .Run database patches in every Quarterly release using Red Gate multi-script functionality.
• Create/Perform Backups, Restores and other Maintenance Jobs. Import the flat files to database using export and import wizard. I did data mining, data analysis and data conversion on SQL Server 2008.
• Maintain internal software that is written in C#/VB .Net. Work with end users to resolve software and database issues.

SQL/SSIS Developer

Confidential, New York

Responsibilities:

• Converted the complete ETL process from SQL to SSIS 2008.
• Improved performance of the system from 10-15 min to less than 3 minutes.
• SQL Stored Procedure Tuning for better performance. Re-wrote some of the Stored Procedures.
• Index tuning for better performance.
• Partitioning of tables for performance improvement.
• Used SQL Tuning Advisor for tuning.
• Creation of Technical Specification documents for migration.
• Data load for development environment.
• Release management activities for Development environment.
• Production support.

Environment: SQL Server 2008, SQL Server Business Intelligence Studio, SSIS.

Confidential, Boston, MA

Responsibilities:

• Led the development team working on data migration.
• Data migration using SSIS 2008.
• Database design for new sets of data.
• Data Manipulation and Data Definition using SQL 2008.
• Creation of SQL Stored Procedures and Functions for data migration.
• Creation of SQL Scripts for data cleansing.
• Creation of data model using Visio 2007.
• Creation of Technical Specification documents for migration.
• Data load for development environment.
• Release management activities for Development environment.
• QA/UAT support.
• Production support.

Environment: SQL Server 2008, SSIS, SSRS.

Confidential, Hartford, CT

Responsibilities:

• Working with various business groups while developing their applications, assisting in Database design, creating E-R diagrams.
• Writing the stored procedures, checking the code for efficiency using T-SQL.
• Creation of user Databases and installation of MS SQL Server 2008.
• Created and maintained various databases for development and testing environment using SQL Server 2008.
• Using SQL Server Integration Services (SSIS) to populate data from various data sources using the concept of OLE DB.
• Worked on building the mockup reports using SSRS and Excel for prototype.
• Create reports in SQL server using SSRS as per the requirements provided by the Front End users.
• Used MS Excel for exporting the reports (Pivot Reports) so that they can be slice and dice as per the requirement by the client.

Environment: SQL Server 2008, Windows 2003/2007 server, SQL Server Configuration Manager, T-SQL, DTS, SSIS, SQL Server Reporting Services (SSRS), SSAS, SQL Profiler2007 - 2008

Confidential

Software Engineer

Responsibilities:

• Understanding the requirement specifications involved in designing of ETL (Extract transform and loading) mapping document.
• Extracted data from various source systems like relational data bases, flat files and load data into the data warehouse.
• Importing source and target.
• Extraction and load process, monitor task and workflow, using the workflow manager and workflow monitor.
• Created reports from SSRS, as main data providers and using the functionality for user response.
• Adding new fields and functionalities to the reports.
• Creating complex report using graphs, pie charts and multiple data providers on daily, weekly, monthly and quarterly basis.
• Used drill Up/Down operations done for different aspects of client business.
• Performed all Database Administration tasks (PL-SQL, Stored Procedures, constraints etc.).
• Mentored and supported the new Team Members.
• Prepared RS, FS and High Level Design Documents.

Environment: SQL Server 2005, Oracle 9i, Informatica, SSRS, SSAS

Confidential

Software Engineer

Responsibilities:

• Worked closely with the business experts to understand the source data.
• Involved in the Requirements gathering meetings.
• Designed Star Schema based on data model with Dimensions and Facts.
• Used relational sources and flat files to populate the data mart.
• Created the reports using Business Objects functionalities like Combined Queries, Slice and Dice, Drill Down, @Functions, Cross Tab, Master Details, Formulae etc.
• Created reports like sales by years, sales by region, sales by stores, sales by persons, comparison reports etc.
• Generated reports using slicing and dicing, drill down etc.
• Analyzing the source system data and Creating work flows and session
• Knowledge Transfer to new team members and Guide and assign work to junior Team members.
• Prepared RS, FS and HLD documents.
• Created Stored Procedures and SQL Queries by joining multiple tables for the generation of Reports.