SUMMARY

• Microsoft Certified IT Professional with 7+ years of Development experience in MS SQL Server with various verticals such as Retail and Service, Food, Education, Insurance, and Pharmaceutical industry.
• Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Extensive experience in MS SQL Server 2012/2008r2/2008 and 2005, and Business Intelligence tools such as SSIS, SSRS and SSAS.
• Expert in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from heterogeneous databases such as Oracle 10g and 11g, DB2, Sybase (Adaptive Server Enterprise) 15.0, 15.0.1, and 15.5, and MS Access.
• Highly proficient in using T - SQL for developing Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Data Integrity, SQL joins and Query Writing.
• Strong experience in designing and developing more than 100+ enterprise reports (SSRS/ Business Objects) using the data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Expert in creating MOLAP Cubes using SSAS and in creating multiple cubes with dimensions and facts and in optimizing MOLAP Cubes by partitioning, designing aggregations, implementing hierarchies and calculated members.
• Hands on experience in implementing Key Performance Indicator (KPI) Objects and Create Calculate member using drag option in SSAS 2008 and 2005.
• Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.
• Extensive experience in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2008r2,2008 and 2005.
• Experienced in Conceptual, Logical and Physical Database design and development, Normalization and Data modeling using Erwin and MS Visio.
• Strong experience in SQL Server Installation, Capacity Planning, Creating and Implementing Backup and Recovery Strategy, Log Shipping, Replication, Attaching and Detaching the database, and database designing.
• Expert in using tools like MS SQL Profiler, Performance Monitor, Database Engine Tuning advisor, Index Tuning Wizard, and Execution Plan for Query Optimization, resolving Dead Locks, and Long/Slow running queries.
• Experienced in upgrading SQL Server and r2.
• Scheduled jobs and alerts using SQL Server Agent and troubleshoot any failures or alert problems.
• Maintained positive communications and working relationships at all business levels.
• Excellent experience in working independently as well as in team-oriented environments.

TECHNICAL SKILLS

• MS SQL Server 2012/2008r2/2008/2005
• MS SQL Server 2012/2008R2/2008/2005 SSAS
• SSRS and SSIS
• Microsoft Access 2010/2007
• Microsoft office
• Report Builder 3.0
• Java
• C++
• MS SQL Profiler
• Query Analyzer
• Enterprise Manager
• Index Tuning Wizard
• Loader and Export/Import
• Erwin 8.0/7.3
• Microsoft Visio 2010/2007
• Data Modeler
• Third party tool Red Gate and Idera
• Cognos crystal Report
• T-SQL
• P-SQL
• Windows 2008/2003 Advanced Server
• UNIX and Linux environment and Microsoft SharePoint 2010 and 2007.

PROFESSIONAL EXPERIENCE

Confidential, Exton, PA

MS SQL Server Developer/SSIS Developer

Responsibilities:

• Extracted data using SSIS packages (ETL) from different server locations and data sources like Excel, CSV, flat file, and Text Format Data, and load data using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate and Slowly Changing Dimension.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse databases.
• Improved Performance Tuning of slow running SSIS Packages by using Merge statement from T-SQL and look up as an alternative of slowly changing dimensions
• Implemented existing Stored Procedures and Triggers for automating tasks.
• Created and maintained Triggers, Functions, Indexes, Tables, Views, and SQL Joins for applications using T-SQL.
• Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the data depending on the requirement.
• Also took responsibility of maintaining Backup of the data, created Job failure alerts using SQL Server Agent and restore data from the backup on request.

Environment: MS SQL Server 2008, SSIS, T-SQL, Cognos, Windows 2008 Server, and Erwin 8.0

Confidential, New York, NY

MS SQL Server Developer/BI Developer/DBA

Responsibilities:

• Wrote from simple to complex T-SQL queries in SQL Server Management Studio, for extraction of data from staging environment based on the requirement and pushed the required data to UAT environment.
• Created simple to complex Store Procedure to re-use all the complex queries that I wrote for the Confidential ’s Enterprise Data Warehouse (EDW) in a specific format with the help of given template.
• Responsible to create various Tables, Views and Functions based on the requirement specified by EDW team and wrote complex Join statements for combining data from various Databases and tables in different relational model database server such as Oracle and DB2.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Fine tuned SQL queries for maximum efficiency and performance using MS SQL Profiler, Database Engine Tuning Advisor, Execution Plan and Index Tuning wizard.
• Involved in improving database performance using SQL Profiler, Trace Flags, Execution plan and Index Tuning Wizards.
• Fine tuned SQL queries for maximum efficiency and performance using MS SQL Profiler, Database Engine Tuning Advisor, Execution Plan and Index Tuning wizard.
• Helped in Rebuilding the Indexes at regular intervals for better performance.
• Worked with a Cognos team and helped to create complex by weekly, quarterly and annual report by writing code based on the requirement.
• Produced operational reports in SSRS 2012/2008R2 i.e. Drill-Down, Drill-through, Dashboard, Sub-Report, and Matrix reports.
• Attained legacy data to use as a source to develop new reports previously compiled and maintained manually.
• Created SSRS Data Model projects using Microsoft Visual Studio 2010/2008 and using Report Builder for report server to create reports.
• Converted manual reports pasted together into parameter driven stored procedures to be used with Microsoft Reporting Services 2012/2008R2.
• Involved in configured the report viewing security for various users at various levels using Report Manager.
• Maintained Backup of the data, created Job failure alerts using SQL Server Agent and restore data from the backup on request.
• Extracted data using SSIS packages (ETL) from different server locations and data sources like Excel, CSV, flat file, and Text Format Data, and load data using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse databases.
• Helped in planning out the coding and offered different solutions in initial planning of the project.

Environment: MS SQL Server 2008r2, SSIS, T-SQL, Cognos, Windows 2008 Server, and Erwin 8.0.

Confidential, Rosemont, IL

MS SQL Server Developer/SSRS Developer/DBA

Responsibilities:

• Planned, Defined and Designed data based on business requirement using Erwin data modeler and provided documentations for further reference.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SSRS.
• Developed various operationalDrill-throughandDrill-downreports usingSSRS
• Developed different kind of reports such aSub Reports,Charts,Matrix reports,Linked reports.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart databases.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on daily basis using SQL Server Agent.
• Worked in setup logging environment to track the status of the events like error raise, task fail.
• Responsible for Monitoring and Tuning Report performance.
• Created various database objects such as Stored Procedures, Functions, Tables, and Views and wrote T-SQL queries to retrieve data from various tables.
• Configured the report viewing security for various users at various levels using Report Manager.
• Fine tuned SQL queries for maximum efficiency and performance using MS SQL Profiler, Database Engine Tuning Advisor, Execution Plan and Index Tuning wizard.
• Designed a backup and recovery solution based on the link between disk design, database layout, backup retention, database performance for efficient backup and restore.
• Work on Performance Tuning of complex queries using SQL Profiler, Index Tuning Wizard and Execution Plan.

Environment: MS SQL Server 2008r2, SSIS, T-SQL, Windows 2008 Server, and Erwin 8.0.

Confidential, Somerset, NJ

MS SQL Server Developer/SSIS Developer

Responsibilities:

• Extracted data using SSIS packages (ETL) from different server locations and data sources like Excel, CSV, flat file, and Text Format Data, and load data using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Created Complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, T-SQL code and SQL Joins for applications.
• Created SSIS packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing diversified data sources.
• Designed SSIS packages to transfer data from various sources like XML files, Excel, MS SQL Server 2008R2/2008 to and from Oracle 10g and 11g.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse databases.
• Analyzed and designed the business rules for Data Cleansing using various transformations such as Lookup, Fuzzy Lookup and Derived Column that are required by the staging OLAP and OLTP databases.
• Involved in maintaining batch log tables and error logging tables to handle errors using event handlers.
• Migrated packages from development server to production server using package configuration.
• Worked with application developers and production teams across functional units to identify business needs and discussed solution options.
• Defined the browsing perspectives and browsing translations since most transactions were online.

Environment: MS SQL Server 2008r2/2008, SSIS, Microsoft Performance Point Server 2010, Microsoft Share Point Server, T-SQL, Java, Microsoft Office, Erwin 7.3, Report Builder 3.0.

Confidential, New York, NY

SQL Server DBA/Developer

Responsibilities:

• Successfully installed and configured MS SQL Server 2008 on the production server and helped in migrating from SQL Server 2005 to SQL Server 2008.
• Provided 24x7 dedicated production support for SQL Server problem resolution and server outages.
• Using third party tool Red Gate, ensuring all the databases are backing up on the regular basis and then restoring this databases on requests.
• Involved in improving database performance using SQL Profiler, Trace Flags, Execution plan and Index Tuning Wizards.
• Responsible for securing SQL Server, user management, and taking care of permissions and roles.
• Involved in database and log backups and restoration, planning backup strategies, and scheduling.
• Verify backups and error logs on the servers and troubleshoot any failures or alert problems, and open trouble tickets if necessary to work with technicians from other departments.
• Automated the migration of data from Oracle 10g to MS SQL Server 2008/2005 and converted the Oracle database objects to MS SQL Server database objects like tables, views, and stored procedures using Microsoft SQL Server Migration Assistant (SSMA).
• Designed SSIS packages to transfer data from various sources like Flat flies, CVS files, Excel, SQL Server to Oracle 10g, and My SQL and from Oracle 10g, and My SQL to MS SQL Server 2008/2005.
• Generated assessment reports to analyze the scope and complexity of the migration projects.
• Improved Performance of the queries by creating Clustered and Non Clustered Indexes and by optimizing the T-SQL statements using MS SQL profiler, Job Activity Monitor and Performance monitor.
• Created SSIS packages to load data from the OLTP system to Data Warehouse and Data mart for analysis of data.
• Improved Performance Tuning of slow running SSIS Packages by using Merge statement from T-SQL and look up as an alternative of slowly changing dimensions.
• Performed various transformations like conditional split, sorting and included data about the environment using the audit transformation.
• Defined referential relationships with the measure groups and fact tables.
• Generated automatically grouping attribute members and implemented the calculations to aggregate physical measures.
• Defined granularity within a measure group and drill through actions.
• Created cube reports that can be browsed at summary level and can be drilled down to the detail level.
• Scheduled and maintained Backups, defined user roles and maintained Log Shipping and Replication.
• Responsible for performance tuning and query optimization using inbuilt SQL tools and third party tool Red Gate.

Environment: MS SQL Server 2008/2005, SSIS,SSRS, Microsoft Visual Studio 2008, T-SQL, MS Access, Windows 2008/XP, Red Gate and Remedy Ticketing tool.

Confidential, Woodbury, NY

MS SQL Server Developer/DBA/SSIS/SSRS Developer

Responsibilities:

• Used the SSIS to migrate databases to and from various sources such as Oracle and Access database, flat files to centralized IT destination.
• Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages.
• Implemented slowly changing dimension on 500,000 records that took 11minutes to complete. Improved the performance by replacing it with checksum to approximate 8minutes.
• Designed DTS/SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager and on SQL Server 2008/2005 environment, and deploy the data. Used Event Handlers for Exception Handling in SSIS packages.
• Generated reports on wealth information, account information, research reports using Ad Hoc reporting to be used by the clients and advisors.
• Developed Report Models using report builder and distributed reports in multiple formats using SSRS in Business intelligence development studio (BIDS).
• Created Queries in T-SQL, Stored Procedures, and Views to store the data of clients and advisors and also Created User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updations to improve the query performance.
• Conducted performance tuning by using SQL Profiler, Performance monitor, Job activity monitor, and index tuning wizard.
• Created and maintained Backups and restore strategy for production, test and development environments, defined user roles and maintained Log Shipping, Replication and Mirroring.
• Worked with capacity planning, database sizing and monitoring.
• Scheduling jobs and alerts using SQL Server Agent and configured database Mail for any job failure.
• Involved in Creation of Crystal Reports, Created ODBC Connections and database Connections.
• Created many complex Stored Procedures/Functions and used them in Crystal Reports directly to generate reports on the fly.
• Scheduled, maintained, and supported the distribution and access to reports through Crystal Server.

Environment: MS SQL Server 2008, SSIS, SSRS, T-SQL, Crystal Reports 10,Visual Studio 2005, MS Office 2007, SQL Profiler, Performance Monitor, SQL Server Index Tuning Wizard, Windows 2008/2003.

Confidential, Lyndhurst, New Jersey

Junior MS SQL Server Developer/SSIS Developer

Responsibilities:

• Extensively used SQL server reporting services to generate reports on a weekly basis for a particular sales and manufacturing type in given period.
• Involved in scheduling reports to run weekly, quarterly, monthly based on the data to be reviewed by the manager.
• Implemented conditional formatting in reports to get a list of customers who have improper payment history.
• Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the data depending on the criteria into the tables of hub.
• Wrote T-SQL queries, created dynamic Stored Procedures that calculates the loan sanctioning details taking the customer details as input.
• Designed high level SSIS architecture for overall data transfer from the source server to the Enterprise Services Warehouse.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2005.
• Extensively used BCP and BULK INSERT to import and export data from flat files, Excel and MS Access to MS SQL Server databases.
• Applied monthly patches and hot fixes.
• Converted DTS packages to SSIS packages.

Environment: MS SQL server 2005, SSIS, DTS, SSRS, SSAS, SQL Profiler and T-SQL, Windows 2003 server, and Visual Studio 2005, Microsoft Office.

Confidential, Greenville, North Carolina

Junior MS SQL Server Developer

Responsibilities:

• Worked as a developer on MS SQL Server 2005/2000.
• Involved in migration of SQL server 2000 to SQL server 2005 using Upgrade Advisor.
• Designed SSIS packages to transfer data between servers, load data into database, archive data file from different DBMS’s using SSMS/SQL Enterprise Manager on SQL Server 2005/2000, deploy the data, and scheduled the jobs to do these tasks periodically.
• Tuned SQL Statements using Indexes, Stored Procedures and Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Maintained database for inventory, billing and invoice systems and Created dynamic stored procedures to retrieve the sales and production, customer and connection details, payment history by giving the related parameters.
• Responsible for tuning and configuration of production and development servers.
• Created the stored procedures, views and scripts for application development.
• Worked with DBCC commands to check physical and logical consistency of the databases.
• Performed quality assurance by using tools and testing of SQL server environment.
• Created various reports using SQL Server 2005/2000 Reporting Services.
• Involved in Performance tuning and optimizing queries for SQL Server Application by using performance monitor.
• Generated test data and tested database to meet the functionalities/deliverables in the project documentation and specifications.

Environment: MS SQL Server 2005/2000, SQL Profiler, SQL Data Collector, Job Activity Monitor, MS office 2003, SSIS, DTS, T-SQL