SUMMARY:

• Over 13+ years of professional experience in IT industry as SQL Server Database/SQL/BI Developer. Worked with very big and well - coordinated team. Enthusiastic in learning new system and environment.
• Extensively worked on SQL Server 2012/2008R2/2008/2005/2000/7/6.5 tools like Management Studio, Business Intelligence Development Studio, SS Data Tools, SSIS, SSRS and SSAS.
• Excellent knowledge in developing Stored Procedures, Views, Triggers, Cursors, Indexes and Indexed Views etc.
• Well versed with Tuning SQL Queries & Stored Procedures to improve performance.
• Experienced in using SSIS for data extraction, transformation and loading. Experienced in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Experienced in scheduling SSIS Packages and stored procedures with SQL server agent, windows batch file script, Windows PowerShell Script and Dollar Universe.
• Involved SQL Server 2008/2008R2 to 2012, 2000/ 2005 to SQL 2008 R2, 6.5/7 to 2000 database migration.
• Implemented partitioning of tables to purge old data in SQL 2005 & 2008 R2 Environments.
• Experienced in extracting data from flat files and transforming and modifying the data to the destination format and loading into the data warehouse.
• Experienced in creating SSIS packages. Experience in DTS Migration and Metadata Management: MigratingDTS packages to SSIS, Package Migration Wizard, and Storage Management.
• Experienced in data migration (using tools like DTS, Bulk Insert, and BCP) between different homogeneous/heterogeneous systems and SQL Server.
• Experienced in SSIS package scripting, scheduling, monitoring, deployment and production support.
• Experienced in creating both forms of reporting like ad-hoc reporting as well as enterprise reporting using SSRS.
• Extensively worked on three stages of enterprise reporting like Authoring, management and delivery using SSRS.
• Experienced in creating Report model using SSRS so that non-technical users can create their own reports.
• Experienced in creating various types of reports (table, chart and matrix report, web reporting by customizing URL Access etc.).
• Expert in automating process by creating jobs, and error reporting using Alerts, SQL Mail Agent, FTP and SMTP.
• Experience in designing Database Models using MS Visio and ER-Win.
• Intensive experience in monitoring database performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.
• Worked on creating client reports and custom reports (Ad Hoc Reports, Sub Reports, Drill-down, dynamic grouping, graphical etc. using SSRS 2005/2008/2012.
• With each client designed and developed enormous number of reports so far using SQL Server Reporting Services (SSRS).
• Worked on SSAS cubs as Source for SSIS source.
• Experienced in working with different version controls like Visual Source Safe (VSS), Rational Rose and Team Foundation Server (TFS).
• Experience working with extremely huge databases up to 3 Terabytes and experience in supporting highly transactional databases.
• Experienced in using various 3rd party tools like Quest software Toad for SQL Server, Red Gate (SQL Compare, SQL Data Compare).
• Experienced in Unit Testing and gathering requirements along with writing Technical Specification Document.
• Worked on different team projects with good project implementation experience (SDLC), team skills, troubleshooting, presentation abilities and issue resolution capabilities.
• Excellent verbal, written communication and interpersonal skills. Ability to work both in teams and individually, interact with functional teams to get optimal system performance.

TECHNICAL SKILLS:

ETL: SQL Server Integration Service, Informatica 6.x/.x/9.x, Business Objects Data Services XI

Reporting Tool: SQL Server Reporting Service(SSRS), Crystal Report 2011, Business Objects XI

RDBMS: MS SQL Server 6/6.5/7/2000/2005/2008/2008R2/2012, Oracle 8i/9i/10g/11g, DB2 8.x/9.5.

VLDB: Teradata V2R5.

OS: Linux (Redhat enterprise 6), AIX 5.x, HP-UX 11i, MS Windows Advance server (2000/2003/2008R2/2012).

Programming Languages: Microsoft Visual Basic/VB.Net/C#.Net, VBScript, Windows PowerShell, Java Script and UNIX Shell Scripting.

Tools: Microsoft Office Tools (Words/Excel/PowerPoint) X-Windows emulation (X-Win32, Reflection X, Exceed Hummingbird); Case / Workflow Tools MS Visio 2007/2010, MS Project 2007/2010 .Rational Rose, SQL * Loader

PROFESSIONAL EXPERIENCE

Confidential, MO

Senior Consultant

Responsibilities:

• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008andSSIS in Business Intelligence Development Studio (BIDS).
• Involved in RCPS Data & Apps migration from TOG environment to Parallon/HCA environment.
• Taking care of Clients recon (Reconciliation) process using SSIS packages.
• Createdparameterized reports, Sub Reports, Charts, Matrix reports, Linked reports, Drill downandDrill throughreports using SSRS.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data mart.
• Used SSRS to develop different kinds of reports like canned, ad-hoc reports for the State and Local Agency users.
• Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Performed operations like Datareconciliation, validation and error handling after Extracting data into SQL Server.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports.
• Developed complex stored procedures to create various reports.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2008 using SSIS, BCP and Bulk Insert.

Environment: MS SQL Server 2008 R2, SSIS, SSRS, Prevasive Data Integrator, FICO Debt Manager/DM9 (R 9.5.1), Tortoise SVN, Windows Server 2008 R2.

Confidential, PA

Senior Consultant.

Responsibilities:

• Worked closely with business/accounts team to translate business requirements into technical requirements.
• Interacting with client, functional experts and developers to isolate & resolve issues.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data marts.
• Created and implemented various SSIS packages to transfer data from their legacy system to new system which is under development.
• Implemented Incremental load, Event Handlers to clean the data from data sources.
• Created stored procedures, functions and triggers to validate the data into the database.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Performed Index Fragmentation analysis on high transaction tables and fixed the issues.
• Done query optimization using MS SQL tools such as Query Analyzer, Profiler, and index tuning wizard.
• Generated periodic reports based on statistical analysis of the data using SSRS.
• Developed various operational Tabular and Drill-down reports using SSRS.
• Developed SSRS reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Worked on various modification on legacy Report Builder 1.0 for the legacy system.
• Performed defect fixes in various environments like UAT, SIT to ensure the proper delivery of the developed jobs into the production environment.
• Attended daily status call with internal team and weekly calls with client and updated the status report.
• Used TFS tool for source control, data collection and project tracking.

Environment: MS SQL Server 2008/2008 R2/2012, SSIS, SSRS, ASP.Net, MVC, Entity Frame Work (EF), Windows Server 2008 R2/2012. Microsoft Team Foundation Server

Confidential, OH

Senior Database Consultant.

Responsibilities:

• Worked closely with business constituencies to translate business requirements into technical architectures.
• Interacting with client, functional experts and developers to isolate & resolve issues.
• Migrated data from heterogeneous data sources (Excel, Access, DB2, Oracle and Flat Files) to SQL Server using SSIS.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts.
• Implemented Incremental load, Event Handlers to clean the data from data sources.
• Designed and mapped using SSIS Transformations like OLEDB Command, Conditional Split, Aggregator, Multicast and Derived Column.
• Used DBCC Statements to perform maintenance tasks before backing up the databases.
• Created stored procedures, functions and triggers to validate the data into the database.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Performed Index Fragmentation analysis on high transaction tables and fixed the issues.
• Done query optimization using MS SQL tools such as Query Analyzer, Profiler, and index tuning wizard.
• Partook in Logical and Physical design of database for projects using ERWin
• Generated periodic reports based on statistical analysis of the data using SSRS.
• Developed various operational Tabular and Drill-down reports using SSRS.
• Worked with the reports team in gathering requirements, building, creating and deploying SSRS reports for various departments. Ad-hoc reports based on the requirements given by the business users
• SSIS package that pulls data from various department data marts to Central data warehouse.
• Developed SSRS reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Performed defect fixes in various environments like UAT, SIT to ensure the proper delivery of the developed jobs into the production environment.
• Attended daily status call with internal team and weekly calls with client and updated the status report.
• Used TFS tool for source control, data collection and project tracking.

Environment: MS SQL Server 2008/2008 R2, SSIS, SSRS, SSAS, Oracle 10g/11g, DB2 v9.5/9.7, Windows Server 2008 R2. Redhat Linux 6.1, Microsoft Team Foundation Server, Microsoft Visual Source Safe, Toad for SQL Server.

Confidential, CA

SQL Server BI Consultant

Responsibilities:

• Participated in all phases of data migration, including design, development, and testing.
• Created stored procedures which compares the existing data in the database table to flat file data and loads the new data or updates the existing data in the tables provided by daily feeds in flat file.
• Created the SSIS packages which look for current day file and process data to load into database tables on daily basis according to the client requirements.
• Created various reports with report builder 2.0 and SSRS.
• Created reports which calls stored procedure; retrieves the data from database tables and displays data in the reports.
• Scheduled SSIS Packages, reports and stored procedures with SQL server agent, Windows batch file commands and Dollar Universe scheduling tool.
• Created SSIS packages to extract the millions of records data (13GB) from flat files (comma delimited, fixed width) and loaded into relational tables.
• Created more than 240 reports standard and ad-hoc reports using SQL Server Reporting Services (SSRS).
• Different types of reports like Tabular, Matrix, sub report, click-through reports using SSRS.
• Used various types of transformations such as Conditional Split, Derived Column, Data Conversion and OLEDB command, Merge, Union All to validating data and redirecting the data to insert and updating the data.
• Used the SSIS Script Task, Execute SQL Task, For-each-loop container, Data flow task in control flow to create the SSIS packages according to the client requirements.
• Involved in creating configuration file with contents like (variables, connection managers) to run the package in QA and Production without making any changes inside the package.
• Extensively used Joins, sub-Queries, merge statement to simplify complex queries involving multiple tables and also optimized the procedures.
• Used various logging methods in SSIS packages to track the errors and generate the log files
• Scheduled the process in Dollar universe scheduling tool which executes the stored procedure and generates the flat file and sends it to control point with executing batch file FTP process.
• Used For-each-loop container to process multiple flat files according to naming convention and current date.
• Extracted data from many operational systems, including flat files, spread sheets and RDBMSs like SQL Server
• Used T-SQL queries for writing stored procedures, created variables, user define functions, triggers, cursor, views.
• Optimized the performance of queries with modifications in T-SQL queries and created indexes whenever necessary
• Involved in Unit testing to ensure the correct functioning of the stored procedure and SSIS packages.
• Used staging tables, table variable and temporary tables to improve the performance.

Environment: MS SQL Server 2005/2008, SSIS, SSRS, SSAS, Oracle 9i/10g, Teradata V2R6/12, Windows Server 2003 R2/2008. Redhat Linux 5.6, Rational Rose, Red Gate SQL DB tools.

Confidential

SQL BI Developer

Responsibilities:

• Created Sales Data mart and loaded data from DB2 Database and DB2 source files to SQL server 2000/2005 database tables using SSIS
• Experience in configuring with checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS
• Worked with SSIS Execute SQL task, script task, data flow tasks, look up, conditional split, script component, row count, union all, multicast, derived column transformations and written T-SQL and Visual Basic (VB) scripts.
• Deploying the packages (both the methods File system & SQL Server system) to different environments (test environment, production environment)
• Implementing error handling strategies for the packages which includes error logging and error handling methods
• Work with the data quality analyst, business objects team and enterprise architects to deliver business improvements using data in the data warehouse
• Maintaining the documents and packages in Team Foundation Server as a version control
• Documenting each and every process from creation to deployment of packages.
• Created new Documentation, schema designing, creating new ERD’s using Visio
• Performed the Unit, Integration, system testing, User Acceptance Testing and written Test Cases and Test Scripts
• Involved in designing of Star, Snowflake schemas and dimensional data models.
• Designed/implemented the information access and delivery effort for the data warehouse.
• Extensively Worked on SQL Server Reporting Services (SSRS) for Sales Summary Reports
• Generated various types for SQL Server Reporting Services (SSRS) reports on Ad-hoc basis.
• Responsible for deploying reports to Report Manager and Troubleshooting for any error occurs in execution.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.

Environment: MS SQL Server 2000/2005, SSMS, DTS, Informatica 6/7, Teradata V2R5, DB2 Database, Oracle 9i, Visual Studio 2005, Windows XP, Windows Server 2000/2003/2003R2, HP-Unix. Sun Solaris.

Confidential

SQL Consultant.

Responsibilities:

• Managed the migration of SQL Server 6.5 databases to SQL Server 2000. Implemented new concepts like Data partitioning, Snapshot isolation. Created Documentation for steps need to be taken while DB upgrade.
• Rebuilding indexes at regular intervals for better performance. Monitored & modified Performance using execution plans and Index tuning.
• Created Reports using Crystal Reports for the various business requirements
• Wrote and debugged Stored Procedures and (DDL) Triggers, Functions as per client requirements.
• Implemented Replication on Disaster Recovery Process.
• Extensively worked on troubleshooting and fine-tuning of databases for its performance.
• Handled Backup plan and disaster recovery activities on Dev environment. Hands on experience in trouble shooting database issues. Update statistics, database integrity check and Backup operations. Worked on call 24/7 Support on weekly basis.
• Gather requirements, analyze it and prepare Design document.
• Based on Design document prepare Technical Specification.
• Developed Stored Procedure, Function and Triggers.
• Helped to wrote Data transfer Scripts on Mass Data Transfer.
• Majorly worked on Data migration from Oracle to SQL Server and SQL Development.
• Unit/Integrated testing.
• Tools or RAD used Visual Studio 6, SQL Server 6/6.5/7/2000, Oracle 7.x/8.x