PROFESSIONAL SUMMARY:

• Over 8+ years of IT experience in the use and development, design, support and migration of Microsoft SQL Server 2008/2005/2000 databases.
• Designing, testing and implementation of high availability solutions for databases for large, medium and small customers.
• Experience in Banking, retail and telecom domain.
• Experience in SQL Replication models, Stored Procedures, Triggers, Indexes, Views, Locks, Data Transformation Services, and Analysis services.
• Coding of Database objects like Triggers, Procedures, Functions and Views.
• Expert in MS SQL Server suite of products like SSAS, SSIS and SSRS of MS SQL Server 2008.
• Experience in Database Backup, Recovery and Disaster Recovery procedures for large, medium and small database instance.
• Exposure to T - SQL programming and Architecture, and translated complex legacy process with T-SQL procedure, functions and package.
• Extensively worked on developing and deploying applications using: SQL Server 2008/2005, Microsoft office, VBA and macros.
• Experience in developing and monitoring SSIS and DTS Packages.
• Proven ability in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2008.
• Extensively worked with SSIS for extracting data from legacy systems to stage and then to Cleanse, Process and Loading into Data Marts and Data Warehouse.
• Experience in designing logical and physical data models using ERWIN and ER/Studio tools.
• Very good experience in developing reports using SQL Server 2008 Reporting Services (SSRS).
• Hands on experience in creating ETL packages using SQL Server 2008 Integration Services (SSIS).
• Worked with OLAP and Data warehouse application and worked with star schema, type1/type2/type3 dimensions and worked with implementing SSAS, and SSRS to support large Reporting needs.
• Performed Back-ups, Restores, Scheduling, Maintenance and Disaster Recovery planning.
• Worked with writing the ETL process to implement the hybrid data environment using SSIS and custom query.
• Hands on experience in creating OLAP cubes using SQL Server 2008 analysis services (SSAS).
• Extensively worked on system analysis, design, development, testing and implementation of projects (SDLC) and capable of handling responsibilities independently as well as a proactive team member.
• A Team-Player with motivation and ability to work independently, worked closely with the Case Teams, Business Analysts and Data Analysts and Functional Design Teams.
• Worked with performance tune the complex queries using the Microsoft Query analyzer and used to support batch process
• Worked very closely with Customers, End users and powered users collect requirements and training or resolve any business process related issues. Intensive experience in monitoring and tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor.
• Have worked in fast paced AGILE environment & attended daily scrum meeting.

TECHNICAL SKILLS:

• Microsoft -SQL Server 2012/2008R 2/ 2008/2005/2000 /7.0
• Oracle 8i & 9i
• MS Access
• MS SharePoint
• Microsoft SQL Server Reporting Services 2008/2005/2000
• ETL
• Crystal Reports
• DTS
• SSIS
• Erwin and Visio
• Windows 9x/Windows 2000/Windows NT/ Windows Server 2003/Windows XP
• IIS 5
• 6
• T-SQL
• C/C++
• C#
• VB 6.0
• VB Script
• SQL*Plus
• VB.NET
• ASP .NET
• SQL Server Management Studio
• SQL Server Profiler
• SQL Server Business.

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

• Involved in designing the physical databases model on SQL Server 2005 RDBMS using different Data Definition and Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Created interface stored procedures used in SSIS to load/transform data to PRMS
• Created complex queries to automate data profiling process needed to define the structure of the pre staging and staging area.
• Migrated SSIS Packages from 2005 to SSIS 2012.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Created reports using SSRS with MS SharePoint.
• Excellent report creation skills using Microsoft SQL Server 2012/2008 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder and MS SharePoint.
• Worked on content management and document management using MS SharePoint.
• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2008/2005(SSAS)
• Created Parameterized reports and linked reports using Bookmark links and Hyperlinks.
• Created subscription for the windows file share and implemented three layer securities for the reports, SSRS website, and in the Intranet web application.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
• Diagnosed and tuning the server optimal performance using SQL server 2005, Dynamic management views, Profiler and Index Tuning Wizards.

Environment: Microsoft SQL Server 2005/2008, SQL Server 2012, Enterprise Edition, T-SQL, SQL Server Reporting Services, SQL Server Integration Services, SQL Server Analysis Services, MS Visio,MDX, Windows server 2003 and IIS 5.0, MS SharePoint.

Confidential, Washington, DC

SQL Server SSIS/SSRS Developer

Responsibilities:

• Worked on the reporting module of the project as a developer using T-SQL scripts, stored procedures and views.
• Generated monthly and quarterly reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS.
• Worked on Performance tuning, and optimization of procedures and queries.
• Verified/Compared results in database tables using DB Visualizer.
• Expert in script tasks, look up transformations and data flow tasks using SSIS.
• Used DTS and T-SQL store procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Set-up and maintained the environment stability of more than 3 database servers in BACARDI system and responsible for the deployment/migration of the code across ETL environment.
• Proven ability in utilizing ETL tools including SQL Server Integration Services (SSIS), Data Transformation Services (DTS) and ETL package design.
• Used Erwin to reverse engineer the existing database design in MS SQL Server 2005.
• Worked on different kinds of transformations in SSIS as per the client’s Requirements.
• Expert in performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Created multiple reports with drop down menu option having complex groupings within the report using MS SharePoint.
• Worked on content management and document management using MS SharePoint.

Environment: MS SQL Server 2005/2000, SSRS, DTS, T-SQL, XML, Erwin, MS ProClarity, Windows 2003 Advanced Server, MS SharePoint.

Confidential, Hartford, CT

SQL Server SSIS/SSRS Developer

Responsibilities:

• Created various Data Interfaces using SSIS 2012 as per the specifications.
• Migrated packages from SQL Server 2008 to SQL Server 2012 as SSIS packages.
• Migrated data from heterogeneous data sources (Data mart, Access, Excel, Flat file) to centralized SQL server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Excellent report creation skills using Microsoft SQL Server 2012/2008 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder and MS SharePoint.
• Created SQL Server Reports based on the requirements using SSRS 2008.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Worked on performance point server to create dashboard and scorecards for business intelligence.
• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Created complex reports which involve more number of groupings and multi-value parameters
• Developed reports like Claim Statements, Fee Bills Transactions and some end request user reports on periodic basis.
• Created applications and utilities using PL/SQL.
• Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
• Created multiple reports with drop down menu option having complex groupings within the report.
• Worked on content management and document management using MS SharePoint.
• Worked on relational DBMS and object oriented DBMS.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Used VB scripting for version control.
• Handful experience in working with the new concept of Tablix Data Regions in the Report Layout, Created a stack of stepped reports using the Tablix.

Environment: Windows server 2003, IIS 6.0, MS SQL Server-20012 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, Erwin VB.NET, OLAP, OLTP, Erwin, Performance Point Server, UNIX, Office-2007, MS Excel, C#.NET, ProClarity Analysis, MS SharePoint.

Confidential, Charlotte, NC

MS SQL Server/SSIS/SSRS/ Developer

Responsibilities:

• Worked with application developers, production teams and across functional units to identify business needs and discuss solution options.
• .Developed the Complex T-SQL queries using Joins, Stored Procedures, Views, Triggers to implement the business rules and transformations.
• Worked on activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using Bulk Copy Process (BCP) with MS SQL 2005.
• Developed and deployed SSIS packages for Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, and Slowly Changing Dimension. Performed ETL mappings using SQL Server Integration Services and Error Handling using Script component in SSIS.
• Designed package which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container and conditional split.
• Implemented Email feature for sending notifications for SSIS jobs to concerned people for notification statuses.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2005 and Flat files and validated the data.
• Utilized SSRS (SQL Server Integration Services) to produce Data Mart for reporting.
• Designed and build the dimensions and cubes with star schema and Snowflake Schema using SSAS.
• SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Tested and debugged the stored procedures and used Triggers to test the validity of the data after the DML operations like insert, update and delete.
• Generated Drill down, Drill through, Ad Hoc, Matrix, parameterized reports using expressions to Calculate, Group, Filter, Parameterize the report data using SSRS.
• Migrated and upgraded data from MS SQL Server2000 database to MS SQL Server 2005.
• Actively participated in Normalization of Databases.
• Involved in writing MDX queries for various calculated members.
• Implemented Constraints on tables for maintaining Data Integrity.
• Optimized queries by looking at Execution Plan for better tuning of the data.
• Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.

Environment: Microsoft SQL Server 2005,SQL Server Reporting Services, SQL Server Integration Services, SQL Server Analysis Services, T-SQL, Windows server 2003, SQL Profiler, MDX, BIDS 2005,