PROFESSIONAL SUMMARY:

• Over 9+ years of IT experience in teh 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 wif 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 wif Drop down menu option, sorting teh data, defining subtotals in SSRS 2008.
• Extensively worked wif 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 wif OLAP and Data warehouse application and worked wif star schema, type1/type2/type3 dimensions and worked wif implementing SSAS, and SSRS to support large Reporting needs.
• Performed Back-ups, Restores, Scheduling, Maintenance and Disaster Recovery planning.
• Worked wif writing teh ETL process to implement teh 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 wif motivation and ability to work independently, worked closely wif teh Case Teams, Business Analysts and Data Analysts and Functional Design Teams.
• Worked wif performance tune teh complex queries using teh Microsoft Query analyzer and used to support batch process
• Worked very closely wif Customers, End users and powered users collect requirements and 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, Atlanta, GA

SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

• Involved in designing teh 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 teh 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 teh structure of teh pre staging and staging area.
• Migrated SSIS Packages from 2005 to SSIS 2012.
• Designed and developed matrix and tabular reports wif drill down, drill through and drop down menu option using SSRS.
• Created reports using SSRS wif MS SharePoint.
• Excellent report creation skills using Microsoft SQL Server 2012/2008 Reporting Services (SSRS) wif proficiency in using Report Designer as well as Report Builder and MS SharePoint.
• Worked on content management and document management using MS SharePoint.
• Increased teh 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 teh windows file share and implemented three layer securities for teh reports, SSRS website, and in teh 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 teh 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, Atlanta, GA

SQL Server SSIS/SSRS Developer

Responsibilities:

• Worked on teh reporting module of teh project as a developer using T-SQL scripts, stored procedures and views.
• Generated monthly and quarterly reports as bar charts for teh 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 teh environment stability of more TEMPthan 3 database servers in BACARDI system and responsible for teh deployment/migration of teh 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 teh existing database design in MS SQL Server 2005.
• Worked on different kinds of transformations in SSIS as per teh client’s Requirements.
• Expert in performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Created multiple reports wif drop down menu option having complex groupings wifin teh 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 teh 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) wif proficiency in using Report Designer as well as Report Builder and MS SharePoint.
• Created SQL Server Reports based on teh 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 teh 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 wif drop down menu option having complex groupings wifin teh 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 wif teh new concept of Tablix Data Regions in teh Report Layout, Created a stack of stepped reports using teh 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 wif application developers, productionteams and across functional units to identify business needs and discuss solution options.
• .Developed teh Complex T-SQL queries using Joins, Stored Procedures, Views, Triggers to implement teh business rules and transformations.
• Worked on activities related to teh development, implementation, administration and support of ETL processes for large-scale Data Warehouses using Bulk Copy Process (BCP) wif MS SQL 2005.
• Developed and deployedSSIS packages for Data warehouseusingLookup, Fuzzy Lookup, Derived Columns, Condition Split, and Slowly Changing Dimension. Performed ETL mappings using SQL Server IntegrationServices 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 developedSSIS Packagesto import and export data fromMS Excel, SQL Server 2005 and Flat files and validated teh data.
• Utilized SSRS (SQL Server Integration Services) to produce Data Mart for reporting.
• Designed and build teh dimensions and cubes wif star schema and Snowflake Schema using SSAS.
• SSAS storage and partitions, and Aggregations, calculation of queries wif MDX, Data Mining Models, developing reports using MDX and SQL.
• Tested and debugged teh stored procedures and used Triggers to test teh validity ofthe data after teh DML operations like insert, update and delete.
• Generated Drill down, Drill through, Ad Hoc, Matrix, parameterized reports using expressions to Calculate, Group, Filter, Parameterize teh 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 teh data.
• Involved in setting up SQL Server Agent Jobs for periodic Backups wif 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

Confidential, Columbus, OH

SQLServer Developer

Responsibilities:

• Actively involved in Normalization and De-normalization of database.
• Designed and developed a Front Office database system.
• Create tables, views, clustered & non-clustered indexes, user defined data types, and User-defined functions.
• Involved in administration of teh SQL Server by creating users & login ids wif appropriate roles and grant privileges to users and roles.
• Created and used stored procedures for database transactions in SQL Server.
• Used T-SQL statements for retrieval of data and involved in performance tuning of T-SQL.
• Created automatically running Stored Procedures and Triggers.
• Created and customized DTS packages and used to load data from different sources.
• Extensively used teh SQL Analyzer and Profiler for studying teh SQL statements and Stored Procedures.

Environment: Windows 2003, MS SQL Server 2000, Business Objects and ETL tools.