SUMMARY

• Highly motivated IT Professional over six years of experience in database analysis, design, development and Support of MS SQL Server 2012/2008R 2/2008/2005/2000.
• Experience working with OLTP, OLAP, Data Warehousing and Business Intelligence solutions.
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Extensive Experience in creating database objects like Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE, Table Variables.
• Performing Data transfer between different heterogeneous systems (Excel, MS Access, Flat Files, XML file, Oracle and DB2) and SQL Server as a part of Data Migration, Data Maintenance and other ETL tasks.
• Expert in usage of SSIS Control Flow items (for each Loop, Execute package/SQL tasks, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Union all, Pivot).
• Expertise in creating and managing Package Configurations, Logging system, Package deployment and User - defined Variables for SSIS Packages.
• Strong Experience in generateng On-demand (Table format, Matrix format, Drilldown, Drill-Through, Multi-valued parameters etc.) and Scheduled reports for Business Analysis or Management decisions using MS SQL Server Reporting Services (SSRS).
• Experience in developing and extending MS SQL Server Analysis Services 2008 (SSAS) Cubes, Deploying and Processing SSAS cubes.
• Experience in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, Database Engine Tuning Advisor (DTA), DBCC & Index statistics, Windows Performance Monitor and Query Execution Plans.
• Proficient in performing DBA tasks including installing and configuring SQL servers and backups/restore and recovery of databases.
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tune the same to improve performance.
• Experience in implementing efficient Disaster Recovery Strategies and High availability like Snapshot, Transactional and Merge Replication, Log shipping, Clustering (Active/Passive) and Database Mirroring.
• Full knowledge of Software Development Life Cycle (SDLC). Worked in agile environment. Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and quick learner.

TECHNICAL SKILLS

Languages: C#, Visual Basic .NET, ASP.NET, Visual Basic, HTML, VBScript

RDBMS: MS SQL Server 2005/2008/2012 , Oracle 9i/10g/11i, PL/SQL, MS Access 2007

Operating Systems: UNIX, Linux, Windows Server 2003, 2008, 2008 R2

Tools: SSMS, SSIS, SSRS, SSAS, Erwin, Oracle Form and Report Builder 6i, SSH Secure Shell 3.1.0, Putty, FTP, VMWare ESX Server 2.1, VMWare Workstation 4.2, Rational ClearCase, Idera, Informatica, Crystal Report 11.x.

PROFESSIONAL EXPERIENCE

Confidential, Lowell, MA

SQL Developer

Responsibilities:

• Installed and maintained multiple SQL server 2008 instances in non-production (test, staging) environments.
• Handling installation and creation of new instances of SQL server databases, managing user creations, assigning roles, security to SQL databases.
• Created several tables, views using SQL Server management studio (SSMS), based upon the functional specifications and primary key & foreign key constraints.
• Deployed database objects from development/testing environment to production environments.
• Design, Develop and Maintain complex queries, views, store procedures, triggers, cursors and SSIS packages.
• Implemented database standards and naming convention for the database objects and database server best practice.
• Used multiple join statements to retrieve data from multiple several tables.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
• Created a SSIS packages to cleaned dirty data of excel sources using Fuzzy lookup and Fuzzy group transformation and load back to database.
• Run adhoc queries on reporting requirements and export out data in excel sheets and provided it to analyses team.
• Performed daily tasks including backup and restore by using SQL Server Management Studio (SSMS).
• Setup profiler traces to support trouble shooting activities in production environments.

Confidential, Boston, MA

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
• Performed various SSIS tasks such as Conditional Split, Derived Column, lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Developed and deployed data transfers packages to the appropriate destinations using SSIS.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSISPackages.
• Created SQL server configurationsforSSISpackages.
• Responsible for creating reports based on the requirements using SSRS 2008.
• Identified the database tables for defining queries to generate reports for analysis of data using SQL Server Reporting Services in Report Builder.
• Defined the report layout and identified Datasets for the report generation.
• Successfully created different type of reports including Cross-tab, Conditional, Drill-down, Sub reports also parameterized reports.
• Created numbers of complex formula in sub report.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Scheduled the monthly/weekly/daily reports to run automatically.
• Developed, implemented and maintained various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
• Successfully Developed and implemented procedures to ensure the quality, usability and accuracy of reports.
• Implemented Star Schema for OLAP cubes using SSAS.
• Created Packages to group logically related column types and to transfer data.
• Used VSS to store, run, view, edit and revert back to different versions of the design in case of a system crash.
• Designed both logical and physical data models in Erwin r 7.2.

Confidential, Haverhill, MA

Responsibilities:

• Installed and maintained multiple SQL server 2005 instances in non-production (test, staging) environments.
• Handling installation and creation of new instances of SQL server databases, managing user creations, assigning roles, security to SQL databases.
• Designed the database and table structure and data partitioning and indexes for optimum query performance.
• Created several tables, views using SQL Server management studio (SSMS), based upon the functional specifications and primary key & foreign key constraint
• Deployed database objects from development/testing environment to production environment.
• Design, Develop and Maintain complex queries, views, store procedures, triggers, cursors and SSIS packages.
• Implemented database standards and naming convention for the database objects
• Extensively used TSQL to manipulate and architect to produce results for users
• Used multiple join statements to retrieve data from multiple several tables
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
• Experience in generating reports and deploying it in to the server using SSRS (SQL Server Reporting Services)
• Provided back-end support for functional testing and performance testing.
• Organized data from a data warehouse into multidimensional cubes with SQL Server Analysis Services (SSAS) to allow the execution of sophisticated reports and complex queries.
• Cleaned dirty data of excel sources using Fuzzy lookup and Fuzzy group transformation and load back to database using SSIS.
• Performed daily tasks including backup and restore by using SQL Server Management Studio (SSMS).
• Setup profiler traces to support trouble shooting activities in QA environments.
• Created report for policy holders by using Excel pivot table and using Crystal Reports.

Confidential, Chelmsford, MA

Responsibilities:

• Gathered the data from different sources using SQL Server Integration Services (SSIS) 2008 using different transformation, constraints, checkpoints and configuration settings.
• Created OLAP cubes on top of the data warehouse with user-defined hierarchies based on different fact and dimension tables for analysis purposes using SQL Server Analysis Services (SSAS) 2008.
• Involved in setting up and implementation of the 2005 reporting server and Created/modified a variety of parameterized, drill down, click through, chart, matrix, sub reports using data from a variety of sources and from the OLAP cubes.
• Worked with SQL Profiler, Tuning Wizard, Execution Plan and Performance Monitor in order to analyze and optimize the queries, procedures.
• Added/modified users, groups, folders, Permissions and involved in the implementation of log shipping, mirroring to maintain the high availability of the servers.
• Identified and defined Key Performance indicators (KPIs) for vendor reporting.
• Created Tabular reports, Cross Tabs, Drill down, Charts, Functions and Maps.
• Creation of user’s databases, and installation of MS SQL Client software. Creating and managing schema objects such as tables, views, indexes, procedures, triggers, and maintained referential integrity.
• Server & application fine-tuning & troubleshooting. Monitoring MS SQL Server performance and network issues. Created the complicated Stored Procedures for Asia and Greater China Reports.
• Developed SSIS packages to load the data from Order database and load into Sales Data mart.

Confidential, Hopkinton, MA

Responsibilities:

• Involved in gathering the requirements and converting them in to design specifications.
• Created logical and Physical database design, data structures, primary key, foreign key and implemented large databases using Erwin.
• Involved in extracting the data using DTS from OLTP to OLAP.
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic email notification and SQL Server backup strategy and automation.
• Used Active-X Scripting in DTS (Data Transformation Services) for transformation of data in to staging tables and also to extract data from database tables and write the data to text files.
• Proper use of Indexes to enhance the performance of individual queries for very fast and efficient reporting process.
• Developed and optimized database structures, Stored Procedures, Indexes, Views, Triggers, Cursors and User Defined Functions (UDF).
• Perform weekly database checkup, shrink database according to instructions, and document weekly database activities.
• Monitoring the CPU usage, IO statistics, Memory usage to identify any OS level performance killers, enabling database level trace for performance test.
• Extensively involved in maintaining & updating the database documentation.
• Experience in migration Oracle Store Procedure into T-SQL Stored procedure.
• Developed T-SQL scripts to enforce business rules and creating reports from OLAP database