SUMMARY

• Around 8 years of IT experience with over 7 years of experience in SQL Server Suite of products (SSIS and SSRS) and involved in all phases of Software Development life cycle from gathering requirement, development, implementation, testing and support with various business domains like Telecom, Health Management, Banking and Insurance.
• Quick learner and Good Performer both in team and independent job environments.
• Extensive experience in using Microsoft BI studio products like SSIS,SSAS,SSRS for implementation of ETL methodology in data extraction, transformation and loading .
• Expert in Data Warehouse development starting from inception to implementation and ongoing support, Strong understanding of BI application design and development principals.
• Install and configure database software, associated database tools and performance monitoring software.
• Experienced in up gradation from MS SQL Server 2000 to MS SQL Server 2005 and MS SQL Server 2005 to MS SQL Server 2008.
• Extensive experience in creating Tables, Views, Indexes, Stored Procedures,ComplexInner and Outer joins, Triggers, Except Clause using T - SQL (DML and DDL) as well as analyzing and debugging existing Complex stored procedures. Hands on using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Check, Unquiet).
• Experienced in Sub-queries, CTE’s (common table expressions), Table Variables and Physical Temp Tables.
• Experienced in using Normalization and De-Normalization techniques.
• Experienced in using Performance Monitor, SQL Profiler and Database Tuning Advisor to solve Dead Locks / long running queries.
• Used DBCC Utilities for Performance Tuning, Query Optimization and Client Server Connectivity & Database consistency checks.
• Experience in Extraction & Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle, DB2 to MS SQL Server by using Import Export Wizard, DTS SSIS, BCP & Bulk Insert utilities
• Expertise in designing SQL Server SSIS packages to import and transform data between databases and external data sources.
• Involved in migration of DTS Packages (2000) to SSIS (2005/2008) and troubleshoot migration issues.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Cube designing in Business Intelligence Development Studio (SSAS) to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Expert in calculating measures and dimension members using Multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets.
• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2000/2005/2008 ) generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2005/2008.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Expert at creating reports using SSRS (SQL Server Reporting Services), SSAS (SQL Server Analytical Services) and OLAP (Creating cubes) including Interfaces with BIDS.
• Experience in deploying created reports in various sources like Web browser, XML and PDF.

TECHNICAL SKILLS

Relational Databases: MS SQL Server 2000/2005/2008, MS Access

Database Tools/Technologies: ADO.Net, SQL Server Integration Services, Data Transformation Services(DTS), SQL Server Analysis Services, SQL Server Reporting Services, OLAP(Online Analytical Processing, Multi-dimensional Cubes and Business Intelligence & Development Studio)

Development skills: T-SQL, PL/SQL,SSIS/SSRS/SSAS,HTML,ASP.Net

Programming Languages: VB.net, T-SQL, HTML, XML, C, C#

Reporting Packages: SQL Server Reporting Services, MS Excel.

Tools: /Methodologies MS Visio, Erwin, Star Schema/Snowflake Schema modeling, FACT& Dimensions tables, Physical & logical data modeling and De-normalization techniques, Kimball &Inmon Methodologies

Operating Systems: Windows NT/98/2000/XP/7, Windows 2003 Server,Linux

Utilities/Applications: MS-Word (97/98/00/XP), MS-Excel(97/98/00/XP), MS-PowerPoint(97/98/00/XP), Adobe Photoshop 6/7, Acrobat Reader/Writer, Visio

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

MS SQL Server/SSRS/ SSIS Developer

Responsibilities:

• Migrated data from Heterogeneous data Sources and legacy system (DB2, Access, Excel) to centralized SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformations constraints.
• Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers form the existing diversified data sources.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them.
• Created drill down and sub reports from SSAS cubes dat can be browsed on web.
• Developed report specifications, created and modified reports using SSRS 2012.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler Index Tuning Wizard
• Created OLAP Cubes from the integrated data and generated reports on those cubes.
• Involved in creating relationships and hierarchies between attributes and measure groups and defined granularity with in a measure group and drill through actions in SSAS (SQL Server Analysis Service).
• Worked on error handling a module consisting of data from bank, transactions, currencies, countries, master and static.
• Implemented multidimensional cubes with MDX calculations to support analysis needs and fast data retrieval.
• Created cube structure for the analysis of business condition and for creation of report using SSAS.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Actively involved in Normalization (3NF) & De-normalization of database.
• Designed, deployed, and maintained of various SSRS Reports in SQL Server 2008.
• Used “SQL Profiler T-SQL Duration” template for tracking execution time of T-SQL Statements.
• Planned a complete backup on the database and restored database from disaster recovery.
• Performed daily tasks including backup and restore by using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Environment: MS SQL Server 2008,SQL Server 2012, SIS, SSRS, SSAS, Visual Studio 2005, VSS 2005, Erwin r7.2, Windows NT/2003, ASP.NET, MS Access.

Senior SSIS/SSRS Developer

Responsibilities:

• Actively involved in gathering requirements and acquiring application knowledge from Business Managers.
• Worked with Business users to clearly identify QNXT Requirements and rules
• Involved in designing the process flow for extracting the data across various source systems.
• DesignedSSIS Packagesto transfer data from various sources likeText Files, XML Files, Excel, Flat files to SQL Server 2008.
• Involved in building and maintainingSSIS Packagesto import and export the data from various data sources usingBIDSbased on the design data models.
• Worked on various tasks and transformations likeExecute Sql Task, DFT, Execute Package Task, Conditional split, Script Component, Row Count, Unpivot, Merge and Lookupwhile loading the data into Destination.
• Designed, reviewed, and created objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints.
• Involved in creating database objects like tables, views, stored procedures and triggers as required.
• Wrote numerous SQL scripts to perform data cleaning/loading task once data is loaded into staging area.
• Created Clustered and Non-Clustered index to improve the access of data within the database.
• Involved in performance tuning of the slow running queries and stored procedures.
• Wrote variousT-SQLqueries,Stored Proceduresand used them to build packages.
• Created Triggers, Tables, Views and SQL Joins for various applications.
• Experience in Change Data Capture in SQL server 2008.
• Worked with SQL server security and auditing SQL server systems
• Responsible for Database and Log backups & Restoration, backup strategies and scheduling backups
• Scheduled theSSISpackages and Jobs.
• Designed, Developed and Deployed reports inMS SQL Serverenvironment usingSSRS-2008.
• Created reports to retrieve data usingStored Proceduresdat accept parameters.
• Using SQL Server Reporting Services(SSRS)delivering enterprise, Web-enabled reporting to create reports dat draw content from a variety of data sources.
• Created traces using SQL server profiler to find long running queries and modify those queries as a part ofPerformance Tuningoperations.
• Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, Recovery and Disaster Recovery procedures. Planned the complete Back-up of various Databases for Disaster recovery scenarios.
• GeneratedSub-Reports,Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Performed daily tasks including backup and restore
• Created various types of reports like chart, tabbed, matrix and linked reports.
• Created and maintained accurate and complete documentation for all packages.
• Resolvedandclosedthe Production tickets generated due to failure of daily incremental production jobs.

Environment: MS SQL SERVER 2008, MS SQL Server 2005, SSIS, SSRS Business Intelligence Studio, SQL Profiler, Windows XP / NT / 2000/2003, Microsoft Access, Microsoft Visio, Visual Studio 2008TriZetto’s QNXT.

SQL Server BI Developer

Responsibilities:

• Wrote several SQL Scripts such as finding tables dat has Identity Columns, finding tables dat do not has primary key.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
• Automated the SSIS jobs in SQL scheduler as SQL server agent job for daily, weekly and monthly loads.
• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Created Parameterized reports and Linked reports and thorough knowledge of report serving architecture using SSRS.
• Extensively involved in replication and implemented Snapshot, Merge and Transactional Replications.
• Developed and performed data modeling studies, support data selection, extraction and cleansing of mediation applications.
• Migrated legacy database and spreadsheets (Access/Excel) to SQL Server 2000 using Data Transformation Services (DTS) and T-SQL scripts.
• Reduced the T-SQL overhead successfully by avoiding unnecessary use of The UNION, <>, statement & using the TOP operator to limit the Select statement in certain queries.
• Created views to restrict access to data in a table for security.
• Developed computer information resources, providing for data security and control, strategic computing, and disaster recovery.
• Developed various Procedures, Functions, Packages and Database Triggers. Also used Oracle inbuilt package UTL SMTP for automatic mail forwarding.
• Involved in development of various critical Master Detail Forms, Reports, Procedure, Functions, Packages and Database Triggers using Oracle.
• Used Index usage statistics to determine how useful an index is and if an index is improving or hindering application performance.
• Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2005 for further Data Analysis and Reporting by using multiple transformations, scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Enhanced performance of databases using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes.
• Supported Application Development team with any database issues, updates or new releases. and deadlock issues, best practices in structuring SQL Queries, debugging unexpected SQL results, etc.

Environment: SQL Server 2005/2000, XML, MS Access 2005/2000, ERwin 4.x, Oracle 10g, MS SharePoint 2003.

BI/SQL Developer

Responsibilities:

• Converted all existing DTS packages of MS SQL by adding SSIS task using the different tools like SSMS (SQL Server Management Server), BIDS (Business Intelligence Development Server) and SQL Server Manager.
• Responsible for creating batches & scripts for implementing logical design to T-SQL.
• Developed stored procedures and triggers in T-SQL.
• Planned, defined and designed data based on the business requirement.
• Created OLAP models based on Dimension and Facts for efficient loads of data based on Star Schema structure.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created SSIS process design architecting the flow of data from various sources to target.
• Created calculated fields with MDX code to meet additional measures needs dat are calculated from existing measures.
• Constructed Cubes based on data volumes mostly adhering to Star Schema.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Created various Database Objects - Tables, Indexes, Views, and Roles.
• Fine-tuned database objects and server to ensure efficient data retrieval.
• Assisted the front end application developers with their queries.
• Involved in project status report updates/creation of issue items for reviews/updates of technical and transformation files on timely basis.

Environment: MS SQL Server 2000, MS Access 2000, MS SQL Analysis Services 2000, MS Excel, Visual Studio 2005, Windows Server 2003, Toad, ERWIN