SUMMARY

• Over 10+ years of experience in database design and development in SSIS Developer, SSRS Developer with good experience in SQL Server 2008R 2/2008/2005/2000 of Healthcare, Telecom, Retail, Banking and Transportation domain in OLTP and OLAP background.
• Strong experience in Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS) packages, Reporting Services (SSRS) and Analysis Services (SSAS), Experienced in Migrating databases from SQL Server 2000 to SQL Server 2005.
• Highly experienced in row and column oriented databases and also experienced in SQL performance tuning.
• Experience in analytical Database Design and Data Modelling skills using MS Visio and ERWIN.
• Expert in ETL - Extraction Transformation Loading/SSIS, Data warehousing, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies.
• Expert knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL/SSIS processes, dimensional modelling and reporting tools.
• Hands on experience in using technologies such as Log Shipping, Clustering and Database Mirroring.
• Capable in troubleshooting and handling production duties.
• Hands on experience in designing, Installing, Creating, Maintaining of Databases, Performance Tuning, Backup and Recovery, Optimization and Database Security.
• Created extensive reports using SSRS (Tabular, Matrix) and Crystal reports.
• Expert in developing Drill through and Drill down reports using Crystal Reports and MS SQL Server Reporting Services (SSRS).
• Experience in using SQL Server Reporting Services (SSRS) 2008/2005 for generating reports.
• Experience in developing and monitoring SSIS Packages and DTS.
• For accessing cube data and query cubes, created cubes in SSAS and build lot of MDX queries.
• Development and automation of ETL using SSIS to Performance Point Server.
• Excellent knowledge and experience in creating source to target mapping, edit rules and validation, transformations, and business rules.
• Highly Experienced in T-SQL for writing complex queries, triggers, user defined functions, views, indexes, user profiles, relational database models, and maintaining data integrity.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.
• Hands on experience in creating Jobs, Alerts, schedule DTS /SSIS Packages using SQL Server Agent.
• Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.

TECHNICAL SKILLS

RDBMS: SQL Server 2012/2008 R 2/2008/2005/2000 , Access 2003

Operating System: Windows Server 2008/2003/2000/ NT, UNIX

Reporting Tools: SSIS, SSRS, Crystal Reports 9/10/XI, Crystal Enterprise 10, Excel, PowerShell, Auto sys.

Languages/Utilities: T-SQL, PL/SQL, VB 6.0, VB.NET, ASP, ASP.NET, XML, XSL, VBScript, JavaScript

GUI Tools: Visual Studio 2003/2005/2008 , BCP, DTS, SSIS, SSAS, SSMS, DTA, SQLCMD, Profiler, Erwin 4.1/7.0, MS VISIO, SQL Query Analyzer, JQuery.

Web Technologies: HTML, DHTML, XLST, XPATH, CSS, UML

Version Control: PVCS, VSS, TFS, Ms Visio

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

Sr. BI\SQL Developer

Responsibilities:

• Worked with various upstream and downstream systems and customers in interfacing various systems for data extractions, ETL, Analytics and Reporting needs.
• Wrote multiple stored procedures and other database objects handling complex business logic and effective performance.
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources.
• Building UAT and Test environments using Production backups.
• Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Experience in SQL Server Analysis Services (SSAS) for data mining to identify rules and patterns in the data.
• Created SQL server Analysis Projects using MS SQL Server 2008.
• Created the Cubes and Dimensions.
• Defined relationships between Measure groups and Dimensions.
• Defined granularity with in a measure group and drill through actions.
• Querying and manipulating multidimensional cube data through MDX Scripting.
• Created report models using the report model designer to support Ad hoc reporting.
• Scheduling the SSIS packages and Jobs.
• Created SSIS Packages to migrate slowly changing dimensions.
• Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema.
• Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.
• Scheduled Reports based on a particular Day and sent them through Email in required format (Excel, PDF, etc.)
• Created technical designs and user documentation.
• Managed the day-to-day activities to ensure the completion of deliverables on time by providing a weekly status report on progress made.
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
• Creating some scorecards and Dash Board Reports Using SSRS 2008.

Environment: SQL Server 2008 Enterprise Edition, SSAS, SSIS, T-SQL, SSRS, Windows Server 2003, CSV, Excel, XML, JQuery.

Confidential, Tampa, FL

Sr. SQL\BI Developer

Responsibilities:

• Involved in design and analysis sessions with other BI teams to provide flawless design.
• Created and monitor SQL Server Agent Jobs to schedule weekly backup of logs to reduce database size and secure the logging data.
• Creation of Clustered and Non-Clustered Indexes for Query Performance and fine-tuned existing stored procedures by re-writing sub queries as inner and left joins.
• Offered production support at regular periods for migration and data issues.
• Created several database constructs such as views, triggers and extensively worked on performance tuning.
• Extensively imported data from various sources such as MS Excel and MS Access using Import Export Wizard.
• Developed SSIS packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Designed ETL structures for data imports from various sources such as Oracle, Tera Data, Excel, Access and DB2.
• Implemented Data Warehouse ETL design structure utilizing Star Schema. Designed and developed Fact and Dimension structures for various types of data related health information of the patients.
• Successfully migrated SSIS packages from development to test to Production environments using SSIS Config files and deployment wizard.
• Developed and implemented custom logging structure in Event Handlers for all the SSIS packages using SSIS system variable such as Package Name, Package Start Time, etc.
• Implemented parallel execution of SSIS Packages and actively utilized parent propagate property in event handlers for uninterrupted execution of SSIS packages.
• Implemented system stored procedure sp send dbmail for notifications upon encountering job failures by sending notification emails for distribution lists.
• Designed archive structure for error logs for auditing purposes using T-SQL and Integration Services.
• Proficient in writing distributed queries such as openrowset using Linked Servers in T-SQL.
• Extensively used T-SQL Pivot and Unpivot for de-normalizing and normalizing source data for designing daily data loads for Warehouse.
• Analyzed existing stored procedures using DB Tuning advisor for performance improvements.

Environment: MS SQL Server 2005/2008, Windows 2003/2008, SSIS, SQL Server, Management Studio, SQL Server Business Intelligence studio, SQL Profiler, Microsoft Excel and Access, JQuery.

Confidential, Raleigh, NC

Lead SQL\BI Developer

Responsibilities:

• Worked on all activities related to the development, implementation, administration and support of ETL processes for large scale Data Ware houses using SSIS.
• Created ETL packages to extract, transform and load data to data warehouse databases.
• Designed and developed SSIS packages and dynamically deployed them into Development, Testing and Production Environments using Package configuration.
• Used various SSIS transformations such as conditional split, derived column and look up for data scrubbing and data validation checks before loading the data into Data Warehouse.
• Used various data transformations in SSIS including importing data from files, moving data from.
• One database platform to another and building star schema data marts from OLTP.
• Used Bulk copy program (BCP) to import and export data in and out of tables into data files.
• Used ETL to implement Slowly Changing Dimension to maintain historical data in Data Warehouse.
• Creating Tabular, Matrix reports, Charts and graphs as per customer requirements using SSRS.
• Created a number of cubes, dimensions with business critical KPIs using SSAS.
• Involved in analyzing, designing, building & testing of OLAP cubes with SSAS and in adding calculations using MDX.
• Developed wind forms using C# and .net.

Environment: Windows XP, MS SQL Server 2008 R2, Business Intelligence Development Studio, SSIS, SSRS, SQL Server Analysis Services, BCP,.Net, C#, JQuery.

Confidential, Irving, TX

SQL Developer

Responsibilities:

• Provided support to 75 database Servers. Support included Production, QA and Development.
• Worked on Migration from SQL Server 2000 to 2005.
• Installed SQL Server 2000/2005 on Stand Alone and Clustered Environments on Windows 2000/2003.
• Wrote complex T-SQL Scripts for generating reports.
• Wrote stored procedures and designed triggers.
• Scheduled Backups of databases and recovered them periodically to verify integrity of Backups.
• Worked in evaluating various high availability technologies such as Log Shipping, Clustering and Database Mirroring.
• Involved in performance tuning issues by running Profiler Trace and analyzing the output.
• Ensured Security by defining access control to data.
• Generated reports using SSRS.
• Designed and developed DTS packages for data import and export.
• Configured Linked Servers.
• Worked on OLAP and OLTP.
• Interacted with development and testing team.
• Importing and exporting of Databases using various techniques like BCP, DTS.
• Analyzed and Installed Security patches as required.

Environment: SQL Server 2005, SSRS,SSIS 2005,SSAS, T-SQL, ODBC, Excel, Access, Windows 2000/XP, IIS, .net Framework, Visual Studio, Visual Source Safe, JQuery.

Confidential, Hartford, CT

SQL Developer

Responsibilities:

• Designed and developed databases for OLTP and OLAP Applications.
• Created complex Stored Procedures for data retrieval.
• Created SSIS Packages using Pivot Transformation, Execute SQL Task, Data Flow Task, etc to import data into the data warehouse and export data as extracts.
• Created SSIS packages to transfer data across heterogeneous data sources.
• Developed, scheduled and generated variety of reports like List, Matrix, Drill-Down, Chart and Sub Report and standardize company report by implementing SQL Server Reporting Services (SSRS).
• Optimized performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
• Created triggers, UDF, views, tables and generated TSQL script for application.
• Analyzed execution plan and optimized queries by creating indexes.
• Created linked servers to fetch data from Oracle.
• Created user defined functions in SSRS using VB script.
• Deployed SSRS reports on Microsoft office SharePoint (Moss).
• Designed SSIS packages to export and import data from SQL Server to MS Access, Oracle10g, text files and Excel files.
• Created dashboards and scorecards using Dundas charts.
• Created standard report Subscriptions and Data Driven report Subscriptions.
• Tested the data with complex queries, joins and sub queries.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Maintained Oracle database backup and recovery. Implemented replication to the production database as part of the SQL migration project.

Environment: SQL Server 2005,SSRS 2005,SSIS 2005,SSAS, T-SQL, ODBC, Excel, Access, Windows 2000/XP, IIS, .net Framework, Visual Studio, Visual Source Safe

Confidential, Virginia Beach, VA

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Planned, Defined and Designed database based on business requirement and provided documentation.
• Coordinated with DBA in creating and managing tables, indexes, triggers, database links and privileges.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Fine tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.
• Created SSIS package to load data from staging environment to production environment using Lookup, Fuzzy Lookup, Derived Columns
• Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Performed Database code Migration from SQL Server 2000 to 2005 in SDLC environment using Bridging Scripts, Column Mapping Tool and Source Control Explorer in Visual Source Safe
• (VSS) and finally passing all triggers, views under Unit Testing for validating data insert, update and delete.
• Configured the report viewing security for various users at various levels using Report Manager.

Environment: SQL Server 2008/2005 enterprise edition SP3, SSRS, SSIS, SSAS, Oracle 10g, Windows server 2003, JQuery.

Confidential, New Jersey

MS SQL Server/SSIS Developer

Responsibilities:

• Created Logical and Physical data models using ER-Win data modeling tool.
• Developed complex Functions, Tables, Views, Indexes and joins for applications.
• Involved in writing stored procedures to parse the full name and split it into First Name, Middle Name, and Last Name based on the business rules.
• Created Triggers to enforce data and referential integrity.
• Created views for the users according to their roles.
• Developed ETL specifications, data mapping and other documentation required for ETL development.
• Created ETL packages by extracting data from heterogeneous sources like Excel, Text files into SQL Server using SSIS.
• Scheduled jobs and alerts using SQL server job agent.

Environment: SQL Server 2005 Enterprise Edition, T-SQL, SSIS, BIDS, SQL Server Management Studio, ER-Win, JQuery.