SUMMARY:

• 7 years of experience in IT industry as SQLDeveloper, Database Administration in MS SQL Server 2012/2008R2/2008/2005 in Production, Quality & Development environments.
• Experience in Installation, configuration and maintenance of SQL server 2005/2008/2008 R2
• Worked on Software Development Life Cycle (SDLC), data modeling and business analysis.
• Experience in design of logical and physical data modeling using ERWIN data modeling tool.
• Expert in creating Database Objects - Schemas, Tables, Indexes (clustered and non-clustered), Views, User defined functions (UDFs), Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Worked withT-SQL, PL/SQL, DBCC, DCL, DDL, DML Scripts and established relationships between tables using Primary Keys & Foreign Keys.
• Experience in creating various types of reports like drill down, drill through, Parameterized, Cascading, Conditional, Table, Matrix, Chart, Sub Reports, Adhoc reports, Crystal Reports.
• Experience in Data Conversion and Data Migration using SSIS across different databases like Oracle, MS access and flat files.
• Experience indeveloping,monitoring, extractingandtransformingdata using SSIS, Import Export Wizard.
• Experience in writing expressions in SSRS and fine tuning the reports.
• Experience in maintenance and Administration ofSSISby creating Jobs, Alerts, SQL Mail Agent, and scheduleSSIS Packages.
• SharePoint 2010 development and Performance Point Services (PPS
• Created shared dimension tables, measures,hierarchies, levels, cubes and aggregationson MS OLAP/ Analysis Server (SSAS).
• Experience in Creation and deployment of cubes onSSAS.
• Experience in ETL Process using SSIS Package.
• Experience in SSIS package design, development and deployment.
• Hands on experience in writing, testing (unit testing) and debugging stored procedures, triggers and troubleshooting database issues
• Transformed Data from one server to other Servers using SSIS.
• Expertise in source code changes using source control tools like Visual source safe.
• Experience in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using SSIS.
• Experience in performance tuning and query optimization.
• Partly involved in administration tasks such as data loading, configuring IIS, data uploading, backup & recovery.
• Experience implementing high availability using Log shipping, and knowledge of DB mirroring.
• Experience in Database administration activities for DB security (creating logins, users, roles, and assigning permission to them).
• Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.

SKILL:

Operating Systems: Windows 2008/2003 Server, Windows XP/7/8/ Vista, LINUX & Unix.

MS SQL Server components/environment: SQL Server Management Studio, Business Intelligence tools (SSIS, SSRS, SSAS), ETL.

Languages: C++, C#, T-SQL, VB.NET, ASP.NET, HTML, PL/SQL.

RDBMS: SQL Server 2005/2008/2008 R2/2012, MS Access, Oracle 10g/11g, MySQL.

Application: MS-Visio, Erwin, Visual Studio, TFS, Clear Case, Clear Quest, FTP

Database Query Tools: MS SQL Server Query Analyzer, SQL Profiler, SQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS).

Hardware: HP Manager.

WORK EXPERIENCE:

Confidential, New York, NY

MSBI Developer

Responsibilities:

• With SSIS, worked on multiple sources and destinations like SQL Server, MS Access, SharePoint, Excel 2008/10, Oracle 11g and text files.
• Responsible for designing ETL solutions/ framework with SSIS. Also responsible for the performance tuning of the ETL packages.
• Responsible for database development and performance tuning of the T-SQL queries using SQL Profiler and Activity Monitor.
• Designing and developing SQL Server 2012 Database, Tables, Indexes, Stored procedures, Views, Triggers.
• Design/Build Extract Transform Load procedures in SQL Server Integration Services
• Worked on creating SSIS packages to upgrade SQL Server 2008 R2 to SQL Server 2012.
• Responsible for converting Client’s online reporting tool to SSRS and Business Objects based on the requirement.
• Developed user defined financial reports to provide on demand financial data analysis using SSRS.
• Developed numerous ad-hoc reports using SSRS for day to day financial reporting.
• Created interactive reports with SSRS, using the report parameters, query parameters, Filters and Expressions.
• Involved in design, programming, deploy and Unit Testing of requested Reports.
• Worked on SharePoint 2010 and Performance Point Services with the knowledge of MDX. Created share point pages, master pages, navigation and security, charts, score cards, KPI, SSRS reports and lists. Also worked on Excel 2010, Power Pivot for providing ad-hoc reporting for the clients.
• Worked on the enhancement of SSAS, Processing multi-dimensional cube (In MOLAP storage mode), querying multi-dimensional cube using knowledge of MDX.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Designed and developed logical and physical data model under guidance of project Solution Architect.
• Communicated effectively with clients to understand enhancements/defects in the existing applications.

Environment: MS SQL Server 2012, SSRS, SSIS,MDX, PL/SQL, Oracle11g, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL, TFS, SharePoint, Business Objects.

Confidential, Quincy, MA

MSBI Developer

Responsibilities:

• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Successfully migrated data from CRM Saratoga to Pivotal component using SSIS.
• Created traces using SQL server profiler to find long running queries and modify those queries as a part of Performance Tuning operations.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2012 using SSIS.
• Created and when required, modified already existing stored procedures, triggers, views, indexes.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Loading data from various sources like OLEDB, flat files to SQL Server database Using SSIS Packages and created data mappings to load the data from source to destination.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Created SSIS packages to retrieve data from Legacy sources, retrieve user data from the Flat files on monthly and weekly basis, File Transfer from one location to the other using FTP task.
• Used Kimball methodology to create data warehouse using SSIS
• Worked on Sub Reports, Graphing, Data Drill-Down, and Data sorting/grouping, Crystal Report Design.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Designed, developed and deployed reports in MS SQL Server environment using SSRS-2008 R2.

Environment: MS SQL Server 2008R2/2012, SQL server Reporting Services 2008R2, SSIS, SSAS, PL/SQL, VSS, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL, TFS, CRM Saratoga and Pivotal.

Confidential, Hartford, CT

ETL/SSIS Developer

Responsibilities:

• Involved in creating Complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Worked with SSIS for transferring and reviewing data from heterogeneous sources like (Oracle, Excel, CSV, flat file, XML, Text Format Data).
• Prepared technical design/specifications for data Extraction, Transformation and Loading.
• Involved in analysing theICD 9andICD 10for the data mapping fromICD 9 - ICD 10andICD 10- ICD 9in source and target level.
• Used SSIS and T-SQL, PL/SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
• Prepared the completedata mappingfor all the migrated jobs using SSIS
• Involved in building and maintaining SSIS Packages to import and export the data from various data sources (Oracle, Excel etc.) using BIDS based on the design data models.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Used subversion to control the SSIS packages.
• Participated actively in client meetings daily and produced detailed level design document for the customer portals.
• Expert in creating parameterized reports, Drill down, Drill through, Sub reports, Linked reports, Snapshot, Adhoc reports usingSSRS 2008 R2.
• Created SSIS packages for File Transfer from one location to the other using FTP task.
• Generated SSRS Reports using Global Variables, Expressions and Functions for the reports.
• Extensively used joins and sub-queries for complex queries involving multiple tables from different databases.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
• Performance tuning and optimization of stored procedures.

Environment: MS SQL Server 2008R2/2012, SSIS, SSRS, PL/SQL, Oracle 11g, VSS, Microsoft Visual Studio, SQL Server Management Studio, T-SQL,TFS, Toad, Unix

Confidential, Denver, CO

SSRS & SSIS Developer

Responsibilities:

• Gathered functional requirements and Business requirements and written the technical specifications.
• Performed some DBA Tasks like checking the jobs, data consistency and troubleshooting the issues.
• Designed and developed data load jobs usingSSISpackage and scheduled in SQL Agent.
• Developed T-SQL and PL/SQL stored procedures and User Define scalar Functions (UDFs) to be used in theSSISpackages and SQL scripts.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Developed, deployed, and monitored SSIS Packages.
• Requirements and design goals ofdata warehouse.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2005/2008.
• Performed operations like Datareconciliation, validation and error handling after Extracting data into SQL Server.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• CreatedSSISpackages for File Transfer from one location to the other using FTP task.
• Expert in creating parameterized reports, Drill down, Drill through, Sub reports, Linked reports, Snapshot, Adhoc reports.
• Prepared the detailed project layout, analyzed existing technology involved, and documented work performed and stored in VSS.
• Helped the production team in analyzing bugs & resolving them.
• Developing Crystal Reports used to generate all daily, weekly, monthly and quarterly Reports including current status.
• Created Database Objects - Schemas, Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Traced long running queries and deadlocks using SQL Profiler
• Installed and configured SQL Server Reporting Services.
• Experience in using Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Designed, tested (unit testing and integration testing) and implemented stored procedures and triggers for data processing of huge volume of data.
• Created and managed Clustered indexes and Non Clustered indexes and optimized queries using execution plan.
• Managed logins, roles, assigning rights and permissions.

Environment: SQL server 2005/2008/2008 R2, IIS, Visual Studio, T-SQL,SSIS,SSRS, SSAS, Oracle10g/11g, Crystal Reports, Framework Manager, BIDS and SSMS, TFS, PL/SQL, SQL Profiler, SharePoint

Confidential, Springfield, MO

SQL Server Developer

Responsibilities:

• Create Stored Procedures, SQLScripts for development and testing etc.
• Created Views to facilitate easy user interface implementation, and triggers on them facilitate consistent data entry into the database.
• Designing and implementation of OLAP environment that would serve different users in different locations.
• Analyzed the current OLTP system to interface with legacy OLTP System.
• Created mapping spread sheet to map columns from current OLTP System (Source SQL Server) to legacy OLAP System (Target SQL Server).
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Successfully deployed reports in various sources like XML, Web browser and PDF.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Scheduling the SSIS packages and Jobs.
• Performed Stored Procedures development and testing as well as Database Report design and implementation.
• Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system to Staging Environment and finally in Data Warehouse.
• Secured and Configured SSIS packages for deployment to production using Package Configurations and Deployment Wizard.
• Involved in creating multiple parameterized stored procedures, which were used by the reports to get the data.
• Migrated SSRS 2005 reports to SSRS 2008.
• Worked on formatting SSRS reports using the Global variables and expressions.
• Reports writing based on tickets submitted from front end people using SQL Server Reporting Services (SSRS).
• Generated matrix reports, chart reports and parameterized reports.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server 2008.
• Using SSRS, creating well-formed reports and web-based reports for financial applications and transactions.

Environment: SQL server 2005/2008, IIS, Visual Studio, T-SQL,SSIS,SSRS, Enterprise Manager, SQL Profiler, SharePoint, Dashboards, Clear Quest

Confidential, Stamford, CT

SQL Server Developer

Responsibilities:

• Created Database Objects - Tables, Indexes, Views, User-defined functions, Triggers, Stored Procedure, Constraints and Roles.
• Created T-SQL scripts using common table expression to apply business logics.
• Used tuning advisor for query optimization, finding missing index and optimized existing index.
• Created SSIS packages to perform day to day ETL tasks including data cleansing, loading flat files into the warehouse.
• Created indexes on tables for performance enhancement.
• Created mail alerts for job failure notification purpose.
• Set up linked server to run ad-hoc distributed queries.
• Reorganized and rebuild indexes based on fragmentation to improve performance for data retrieval.
• Tuned database queries and stored procedures for performance improvement.
• Created complex stored procedures using CTE, SQL Joins, Cursors etc.
• Used SSIS and T-SQL, PL/SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
• Used 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 SSIS Packages.
• Created SQL server configurations for SSIS packages.
• Identified the database tables for defining queries to generate reports for analysis of data using SQL Server Reporting Services in Report Builder.
• Developed, implemented and maintained various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
• Created Packages to group logically related column types and to transfer data.
• Enhanced existing windows form application by creating new modules using VB.NET.
• Created program to convert flat files into non-Unicode file format using .NET.

Environment: MS SQL Server 2005/2008, MS Access, SSIS, SSRS,VS 2008, VB.NET, PL/SQL, Excel 2007,Clear Case, Business Objects, SQL Profiler, Enterprise Manager.

Confidential

SQL Server Developer

Responsibilities:

• Installation and configuration of SQL Server 2005.
• Created Tables, indexes and constraints.
• Created and maintained Database Objects.
• Created T-SQL stored procedures, functions, tables, views and SQL joins and other statements for various applications, maintained referential integrity and implemented business logic.
• Created backups for databases.
• Created Drill down reports, Ad-hoc Reports and Drill through reports using SSRS.
• Worked with Implementation team and closely moved with end users to implement manufacturing solutions.
• Optimized SQL statements for customer summary reports.
• Client side implementation and testing.
• Partly involved in Performance Tuning.
• Monitored user accounts, user permissions and backup.
• Involved in analysis and Design Documentation, User Requirements and maintained good documentation.

Environment: SQL Server 2005, T-SQL, Crystal Reports, Business Objects, SSRS 2005, MS Access, MS Excel, HTML.