SUMMARY

• Over 8 years of strong experience with Demonstrated success in the Database Design, Development and Deployment of large - scale enterprise applications.
• Experience in MS SQL Server 2008/2005/2000 suite of products like SSIS, SSAS and SSRS.
• Hands on experience with Database development in OLTP and OLAP.
• Experience in creating stored procedures, functions, triggers, cursors, tables, views, indexed views, temp tables, dynamic sql, CTEs, osql, sqlcmd commands.
• Solid knowledge of Relational Database Management Systems and Data Warehouse Concepts.
• Worked on T-SQL, DDL, DML, Primary Keys and Foreign Keys.
• Experience in using Try Catch block
• Designed and developed ETL process using SSIS to load data from various sources like Oracle, MS Access and DB2 into SQL Server 2008 R2/2005 databases.
• Created SSIS packages with Error handling, notifications and package configurations.
• Created audits/logging for SSIS packages on task level and package level.
• Worked on Control Flow tasks like For each loop, execute process tasks, execute package tasks, script tasks and Data Flow tasks like derived column, look up, merge, script, union.
• Used SSIS Checkpoints, property expressions and variables to customize data processing.
• Established ETL design practices for optimization and performance of packages and Parameterized SSIS packages with the use of environment variables.
• Extensive experience in report generation using SQL Server Reporting Services (SSRS) from OLTP, relational databases and OLAP cubes.
• Hands on experience in developing Custom Reports and different types of Tabular reports, Matrix reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Experience in developing various kind of reports like Cascading parameters, Drill down, Drill through, Sub Reports and Charts.
• Creating YTD, MTD and WTD sales and inventory reports on store level.
• Developing report models to give users flexibility to create dashboards of their own choice.
• Created and Executed the Stored Procedures and Complex Queries for Reports.
• Worked on setting up SSRS reports for data driven subscriptions.
• Experienced in creating Cubes with Star Schema and Snow Flake Schemas using SQL Server Analysis Services (SSAS) in SQL Server.
• Designing aggregations both manually and Usage based aggregations.
• Creating relations and attribute hierarchies in cube.
• Configuring user roles, groups, database email accounts and profiles.
• Deploying SSIS Packages, SSRS reports and SSAS cubes to production server
• Extensive experience in Administration Tasks like setting up batch jobs, configuring IIS, Data uploading, Backup and Recovery, Database mirroring, Log shipping, SQL Server Agent Jobs and monitoring day-day database activities.
• Creating Database partitioning, Databases/file groups/files/transaction logs.
• Understanding query flow using execution plan and tuning the query to use appropriate Scan/Seek (Index Seek, Index Scan and Table Scan).
• Using SQL server hints, DMVs and DBCC commands whenever necessary.
• Proven ability in Performance Tuning and Query Optimization.
• Experience in client interaction while providing technical support and knowledge transfer.

TECHNICAL SKILLS

Operating Systems: MS-DOS, Windows 95/98/NT 4.0/XP/2000/2003 Server, UNIX

Programming Languages: T-SQL, PL/SQL,DB2, C#, VB

RDBMS/Databases: MS Access, MS SQL Server 2000/2005/2008 R2/2012, Oracle 8i/9i

Data Modeling: MS Visio, ERWIN

Database Tools: SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, SSIS, SSRS, SSAS. TFS

Web Technologies: HTML, XML, XSL, XSLT, ASP, VB.

Web Servers: IIS

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, Arizona

Sr. SQL/SSIS/SSRS Developer

Responsibilities:

• Involved in analysis, design, development and enhancement of the application that applies business rules on the data on weekly basis.
• Studied the current transactional database in order to understand the existing system and created the approach documents for the migration task.
• Created Complex Stored Procedures, Triggers, Functions, Tables, Views and other T SQL code and SQL joins to ensure efficient data retrieval.
• Ensure best practices are applied and integrity of data is maintained through security, documentation and change management.
• Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse database from heterogeneous databases/data sources.
• Created loggings in the existing SSIS Packages.
• Developed various types of reports like Drill down, Drill through and parameterized reports using SQL Server Reporting Services 2008 R2.
• Created reports, sub reports, charts, Tablix, Matrix, Hyperlink reports.
• Inspected the reports and fixed bugs in stored procedures and also tuned Reports.

Environment: SharePoint, SQL Server 2008R2 Enterprise Edition, SQL, T-SQL, PL-SQL, DB2, MS Access, MS Excel,& Windows 2003 server, Business Intelligent technologies like SSIS,SSRS,SSAS, Tableau 7.1,8.1,8.2

Confidential, Phoenix, Arizona

Sr. SQL/SSIS/SSRS Developer

Responsibilities:

• Actively participated ininteraction with users, DBAs, System Admin and technical manager to fully understand the requirements of the system.
• Created audit events for master and child packages to track the status of the package execution.
• Created notifications, alerts to let support team know in case there are any failures.
• Established ETL design practices for optimization and performance of packages and Parameterized SSIS packages with the use of environment variables.
• Configured Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging, TRY and CATCH blocks
• Developed various types of reports like Drill down, Drill through and parameterized reports using SQL Server Reporting Services 2008 R2.
• Created reports, sub reports, charts, Tablix, Matrix, Hyperlink reports.
• Worked on Change Management Cases to resolve the production change request issues based on the Specifications provided.
• Worked on Mercurial source control to manage code.
• Monitoring Performance of SQL server using SQL Profiler, Query Analyzer, Database Engine Tuning Advisor (DTA) and Performance monitoring.

Environment: SQL Server 2005/2008R2/2012 Enterprise Edition, SQL, T-SQL, MS Access, MS Excel,& Windows 2003/2007 server, Business Intelligent technologies like SSIS,SSRS.

Confidential, Irving, TX

SQL/SSIS/SSRS Developer

Responsibilities:

• Responsible for creating reports based on the requirements using SSRS 2008 R2.
• Continuously interacted with users to gather the business requirements.
• Created design specification documents for the new reports developed through SSRS.
• Published ad-hoc reports through Report Manager.
• Used complex expressions to calculate, group, filter, parameterize, and format the contents of a report.
• Data Driven Subscription both Email And Windows File Sharing.
• Worked on generating reports using Crystal Reports, SQL Server Reporting Services and Excel spreadsheet.
• Created Complicated reports like Parameter based Reports, Graphical Reports, Excel Reports, Drill-Down Reports, Matrix Reports, Chart and Tabular Reports using SSRS 2008.
• Created notifications, alerts to let support team know in case there are any failures.
• Worked on SVN to manage code.
• Configured Error and Event Handling: Precedence Constraints, Break Points, Check Points,
• Logging, TRY and CATCH Blocks.

Environment: MS SQL Server 2008R2/2012, Management Studio(SSMS), ETL, DTS, Crystal Reports9.0, Data Modeling, OLAP, Data warehousing, T-SQL, PL/SQL,DB2,SQL Profiler, IIS 6.0, Windows 2008 R2, SSAS, SSIS, SSRS 2005/2008, community server, SharePoint 2007.

Confidential, Ft Myers, FL

SQL/SSIS/SSRS Developer

Responsibilities:

• Created Star schema Dimension Modeling for the Data Mart using Visio and created dimension
• And fact tables based on the Business requirement.
• Involved in Database design process and Data modeling process using Microsoft Visio 2007.
• The data was extracted, scrubbed, formatted so it could be loaded to tables of a data ware house (ETL).
• Using SSRS delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Experienceingenerating On-demand and ScheduledReportsfor business analysis or Management decision using SQL Server Reporting Services.
• Experience in creating multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and charts.
• Worked with report parameters and performed Parameterized and cascading parameterized reports using SSRS in Visual Studio.
• Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.
• Worked on Team foundation Server source control (TFS) to manage code.

Environment: MS SQL Server 2008R2, SSRS, SSIS, MS SQL Server Analysis Services 2008, OLAP, Performance Point Server 2007, ETL, UML, Erwin, DTS/SSIS, BIDS, SharePoint Portal Server 2007, Windows 2008.

Confidential, Coppell, TX

SQL/SSIS/SSRS Developer

Responsibilities:

• Installation and configuration of SQL Server.
• Worked with T-SQL to create Tables, Views, Triggers and Stored Procedures.
• Experienced in Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, and Sub reports using SQL Server Reporting Services 2008.
• Experience in writing MDX queries for cubes and Performance optimization of MDX queries.
• Regular responsibilities for updating and staging the dimensional databases as well as rebuild the Dimensions and cubes in Analysis Services.
• Experience in creating Ad-hoc reports Using Report Builder 1.0 and Report Builder 2.0.
• Involved in Analyzing, designing, Building and Testing of OLAP Cubes with SSAS and in adding calculations using MDX.

Environment: MS SQL Server 2008, SQL server Reporting Services 2008, SQL Analysis Server 2008, SSIS,VSS, Microsoft Visual Studio 2007, SQL Server Management Studio, MS Excel, T-SQL.

Confidential, Atlanta, GA

SQL/SSIS/SSRS Developer

Responsibilities:

• Installing different Hot fixes for Deadlocks, Blocking and indexes.
• Detection and resolving of Blocking and Deadlocks using Profiler.
• Monitored testing servers for long running stored procedures, queries using profiler and recommended clustered and non-clustered indexes using DTA.
• Used BCP command line utility to replicate a database.
• Used Erwin tool to visualize complex data structures, inventory information assets and establish enterprise-wide standards for managing data.
• Implemented SSIS data transformations scripts, created maintenance procedures and provided data integrity strategies.
• Developed reports using SSRS 2005. Used Table control, Matrix control for cross tab reports.
• Created standard Reports and Cross Tab Reports and Drill Through reports.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Environment: Microsoft SQL Server 2005, SSIS 2005, SSRS 2005, Visual Studio 2005/2008, Microsoft Office share point 2007, windows 2000/2003/XP, .NET Framework, C#, VB, ASP.NET, ADO.NET

Confidential, Port St. Lucie, Florida

SQL/SSIS/SSRS Developer

Responsibilities:

• Design and create Database, Tables, indexes, and Views, in SQL Server management studio.
• Create Stored Procedures, Triggers, and Functions for the Application, extensive testing on the Performance of the Stored Procedures.
• Created and maintained database, tables, views, indexes, and constraints to implement business rules by using Query Analyzer and SQL Server Management Studio.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP Data sources.

Environment: Microsoft SQL Server 2005, SSIS 2005, SSRS 2005, SSAS 2005, Visual Studio 2005/2008, Microsoft Office Performance Point Server, Planning Business Modeler, Microsoft Office share point 2007, windows 2003/XP/vista, .NET Framework, C#, VB, ASP.NET, ADO.NET.

Confidential 

SQL/SSIS/SSRS Developer

Responsibilities:

• Involved in ER diagrams and mapping the data into database objects.
• Installed and Configured SQL Server 2000 successfully.
• Design of the Database and the Tables.
• Build table relationships and wrote Stored Procedure’s to clean the existing data.
• Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery,
• Worked on Stored Procedures and Database Triggers. Worked on large number of Business Analytical Functions.
• Involved in Job scheduling and alerts.
• Generated database SQL scripts and deployed databases including installation and configuration.
• Designed and implemented user log in and security.
• Resolved any deadlocks issues with the databases / servers on a real-time basis.

Environment: SQL Server 2000/2005 Enterprise Edition, .NET Framework, C#, ASP.NET, ADO.NET, Erwin, XML, T-SQL, SQL Server 2000, SQL Server 2005, SSIS 2005,SSRS, SSAS, VisualStudio.NET IDE, Windows 2000 Advance Server, Windows 2003 Advance Server, ASP, MS Excel, MS Access, Visual Studio 2005