SUMMARY

• Having 8+ years of IT experience on MICRO SOFT BI TOOLS like SSIS, SSRS, SSAS and SQLSERVER 2005, 2008, 2012, 2014.In this tenure, involved in design, analysis, development and implementation of various applications in Client/Server environment. Good experience in SSIS ETL tool, SSRS Reporting Tool and SSAS Analysis Tool.
• Experience of database restore from one server to another database server. Backup test Restore from RMAN, EXPDP/IMPDP utility and User Managed backup.
• Cloning\Refresh SQL Server, Oracle Applications and Databases
• Hands on experience on installing Sql server 2008/2012/2014 and troubleshooting.
• Extensively worked on supporting the Sql server databases of different projects for different clients in different environments like production, UAT, Development and test servers.
• Managed Microsoft Active\Active and Active\Passive Clustered SQL Server 2000, 2005 and 2008 environments.
• Managed the use of disk space, memory and connections.
• Good working knowledge one Performing DBCC utilities and fixed data corruption in application databases.
• Involved in managing the production requirements gathering and analysis
• Worked on Monitoring and troubleshooting ETL jobs daily using BCP and SSIS.
• Good working Knowledge on ETL Process using SQL Server Integration Services (SSIS).
• Good working Knowledge on setting the Transactions, isolation levels and providing security options for the SSIS Packages.
• Hands on experience in deploying the developed SSIS packages into integration services catalog and file share location in different environments
• Extensively worked on Optimizing the Performance of SSIS Packages and sql storedproceures.
• Developed various weekly and monthly business Reports, Tabular, matrix, list and Drilldown, Drill through reports using SQL Server Reporting Services (SSRS).
• Good working Knowledge on Deploying the SSRS Reports into Share point portal, Report manager, Report server.
• Extensive working knowledge on using visual studio to develop c#.net code required in script task.
• Worked on Optimizing the Performance of SSRS Reports and scheduling reports using subscriptions.
• Good working knowledge on creation of cube in SSAS.
• Created Calculations,Aggregations,KPI’S,Perspectives,Partitions for CUBES.
• Extensive working Knowledge on MDX Queries
• Knowledge on data warehouse concepts like star schema, snow flake schema, dimension and fact tables.
• Having excellent analytical and Database skills.
• Hands on experience in installing, configuring, managing, monitoring SQL Server 2014/2012/2008/2005
• Expert in developing T - SQL (DDL, DML, DCL) statements, Data Integrity (constraints), Rules, Performance Tuning, Query Optimization and Validation issues, used SQL DBA DBCC (Database Consistency Checks) Utilities to check the physical and logical consistency of the database
• Extensive knowledge in writing Queries, Stored Procedures, Functions, Cursors, Triggers and views.
• Regular monitoring of all the scheduled SQL SERVER AGENT JOBS.
• Extensive working knowledge in Optimizing Database performance
• Good working knowledge on SQL DBA concepts Like Backup strategies and options, Replication, Log shipping, Database security.
• Good Working Knowledge on SQL Server 2005
• Having good working knowledge on SQL Server 2008
• Having good working knowledge on SQL Server 2012
• Having good working knowledge on SQL Server 2014
• Highly motivated and a conceptually strong individual with exceptional analytical and design skills.
• Excellent professional written and verbal communication and interpersonal skills. Proficient in technical writing and presentations.

TECHNICAL SKILLS

Operating Systems: Windows Server 2000/2003/2008 Windows XP/Vista

Languages: T-SQL, C#.Net, XML

Tools: /Utilities Enterprise Manager, SQL Server Management Studio(SSMS), Query Analyzer, Business Intelligence Development studio, Analysis Manager, SQL Profiler, SSIS, SSRS, SSAS, Visual Studio 2005/2008/2012/2014 , SQL * Plus

Databases: MS SQL Server 2005/2008/2008 R2/2012/2014

Software: MS Office, Adobe, Adobe Photoshop, Ms Excel, MS-Project 2000

Reporting Services: Excel, SQL Server Reporting Services, SQL Server Analysis Services Power BI Reports,MSRA

Functional Experience: Banking, Finance, Sales & Retail

PROFESSIONAL EXPERIENCE

Confidential, NYC

SQL Server BI Developer\SQL DBA

Responsibilities:

• Involved in requirements gathering and analysis.
• Attending and hosting meeting with customer and internal teams
• Performing RCA for database and application related issue
• Performing Health Check for better performance of the database and application
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing
• Code and Package Deployment.
• Configuring Backup for database and restoring database
• Experience of database restore from one server to another database server. Backup test Restore from RMAN, EXPDP/IMPDP utility and User Managed backup.
• Cloning\Refresh SQL Server, Oracle Applications and Databases
• Performing Health Check for better performance of the database and application
• Performance tuning using various tools
• Responsible for supporting the databases monitoring jobs and logs.
• Involved in software installation and troubleshooting of sql server 2012, 2014 and windows.
• Responsible for database backups restores and replication and security.
• Responsible for optimization of sql queries and SSIS Packages.
• Used script task to make web service calls to get the information from .net webservices as per requirement.
• Used ado.net to get records information and updated in the destination table.
• Used script component to get the timestamp.
• Used visual studio to work on C#.net code while using script task
• Responsible for Issues Handling, raised by the User.
• Enhancing the SSIS packages, and CUBE as per the source on quarterly basis, yearly basis.
• Responsible for deploying the packages, cubes using.
• Responsible for Creating and deploying reports onto Report Server
• Responsible for doing unit testing
• Involved in code reviews.
• Involved in UAT issue logs.

Environment: Microsoft SQL Server 2012,2014,SSIS,SSRS,SSAS,T-SQL, MS-Excel, Windows XP/7, VS Business Intelligence Tool, TFS, SharePoint,visual studio

Confidential, Pittsburgh PA

SQL Server BI Developer\MDS Developer\SQL DBA

Responsibilities:

• Managing SQL Servers in development and production and QA environment.
• Install SQL Server Management tools using SQL Server Setup Program. Test the Installation of SQL Server.
• Automation of data exports/imports using SSIS.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers
• Database Integrity Checks, Update Database Statistics and Re-indexing.
• Maintained production database, along with supporting development and testing environment.
• Troubleshoot production database server, user administration, configure SQL Server, creating databases for development and testing environments, capacity planning, performance tuning and database monitoring.
• Migrated from Sybase ASE 11.9 to SQL Server 2012 using SQL Server Migration Assistant(SSMA)
• Have worked on Log shipping to create Stand-by Server.
• Database and Log Backups and restores, backup strategies, scheduling backups.
• Remote configuration, fine tuning of database objects and server
• Job Monitoring and making sure all jobs ran successfully every night.
• Managed MS SQL Servers in Virtual Environments using VMWARE.
• Creating and managing schema objects such as tables, views, indexes, procedures, triggers.
• Perform recovery of the database. Import tables schema as requested.
• Actively involved in migrating from SQL Server 2000 to SQL Server 2012
• Creating tables, views, indexes, stored procedures, triggers and constraints.
• Used Change Data Capture to record inserts, updates and deletes.
• Monitoring and fixing replication issues.
• Managed and involved in requirements gathering and analysis.
• Responsible for supporting and enhancing the MDS Packages, Model and Creating Entiites,Hierarchies,BusinesRules,Security.
• Developed ssis packages using LOOKUP,SCD,DERIVEDCOLUMN,DATACONVERSION Transformations
• Responsible for Building and deploying ssis packages in .ispac format into all Environments.
• Responsible for developing the ssis Packages to pull data from source to MDS Layer.
• Responsible for Raising Tickets for Issues and communicating with client regarding MDS Issues.
• Responsible for database backups, Restore, Replication and deploying MDS Packages in Prod, Dev, Test.
• Responsible for daily monitoring jobs and Loads using sql agent.
• Involved in supporting the databases and troubleshooting the database.
• Involved in UAT testing.

Environment: MS SQL Server 2012, BIDS/Data tools (SSIS), T-SQL, Master Data Services 2012, C#,Linux, Share Point Portal Server, Notepad++, TFS, Oracle 11g, Toad for Oracle 9.7.2.5, IBM DB2 9.5.1,Teradara, Visual Studio 2012.

Confidential - Redmond WA

SQL Server BI Developer \SQL DBA

Responsibilities:

• Involved in requirements gathering and analysis.
• Responsible for supporting the databases monitoring jobs and logs.
• Involved in software installation and troubleshooting of sql server 2012 and windows.
• Responsible for database backups restores and replication and security.
• Responsible for Issues Handling, raised by the User.
• Enhancing the packages, and CUBE as per the source on quarterly basis, yearly basis
• Responsible for deploying the packages, cubes using.
• Responsible for Creating and deploying reports onto Report Server
• Responsible for doing unit testing
• Involved in code reviews.
• Involved in UAT issue logs

Environment: Microsoft SQL Server 2008, SSIS,SSRS,SSAS,T-SQL, MSRA, MS-Excel, Windows XP/7, VS Business Intelligence Tool, TFS, SharePoint. iGATE

Confidential

Sr SQL server BI Developer\SQL DBA

Responsibilities:

• Responsible for requirement gathering and communicate with client.
• Involved in database support, backup, restore and replication.
• Creation of datasets in SSRS to populate report data
• Creation of Drill Down, drill through repots in SSRS
• Implementing Groups in Reporting tables to display totals and sub totals
• Creation of matrix report for dynamically expanding columns
• Repeating of matrix for each group using list.
• Responsible for deploying reports onto Report Server
• Involved in code reviews for all the reports
• Involved in UAT issue logs
• Involved in analyzing Custom Reports, Ad-hoc Reports by using SQL Server Reporting Services (SSRS)

Environment: MS SQL Server 2008, SSRS 2008, T-SQL, OLAP Service, Visual Studio 2005, SQL Server Profiler, Windows Sever 2000/2003/2008 R2, SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS). iGATE

Confidential

SQL Server BI Developer\SQL DBA

Responsibilities:

• Involved in software installation and requirement gathering.
• Responsible for Troubleshooting and optimization of performance of databases.
• Creation of BrExpressions for validating data.
• Creation of T-sql statements using brexpressions
• Involved in database support, backup, restore and replication.
• Responsible for supporting monitoring of jobs using BCP,SSIS Tool.
• Creation of storedprocedures for inserting data into destination
• Creating ssis package for calling sp’s for different sources.
• Deploying and sheduling the ssis packages

Environment: MS SQL Server 2005,2008, Windows 2000/2003, Excel, TSQL, Microsoft Visual Studio 2005,SQL Reporting Services, SQL integration services. iGATE

Confidential

SQL Server, SSRS Developer

Responsibilities:

• Involved in software installation and requirement gathering.
• Responsible for Troubleshooting and optimization of performance of databases.
• Creation of datasets in SSRS to populate report data
• Creation of Drill Down, drill through repots in SSRS
• Implementing Groups in Reporting tables to display totals and sub totals
• Responsible for deploying reports onto Report Server
• Generated cube for ad-hoc reporting.
• Involved in code reviews for all the reports
• Involved in UAT issue logs

Environment: SQL Server 2005, 2008, MS-Office, Ms-Excel, VSS.

Confidential

SQL Server, SSRS Developer

Responsibilities:

• Created Stored Procedures and Functions
• Created Tables and Relationship between tables using constraints
• Created ssis package for developing DWH.
• Deploying and scheduling ssis package.
• Created ssrs reports for annual,quarter,monthly updates
• Responsible for code review
• Involved in UAT issue logs.

Environment: SQL Server 2005, 2008, MS-Office, Ms-Excel, VSS.

Confidential

SQL Server Developer

Responsibilities:

• Creation of Data Bases, Tables, and maintain table relationships as per Requirement.
• Created Stored Procedures, Views, Indexes, Roles and maintained database users
• Development and implementation of backup and recovery strategies.

Environment: SQL Server 2005, MS-Office, MS-Excel.