SUMMARY

• Over 8 years of experience in IT as Sr. BI Developer/Database Developer/ Database Designer.
• Extensive experience in MS SQL Server 2012/2008R 2/2008/2005/2000 with Business Intelligence (SSRS and SSIS).
• Expertise in data models, data flows and data dictionaries.
• Good knowledge on Normalization and De - Normalization techniques.
• Experience in scripting in SQL Server - Stored Procedures, Triggers, User-defined Functions (UDF’s), Views, indexes and constraints.
• Experience in tuning Stored Procedures, T-SQL Queries, and SSIS Packages.
• Experience in designing and implementing Backup and Recovery strategies.
• Expertise in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services.
• Expertise in Merging data from various Heterogeneous Data sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
• Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Developing highly complex SSIS packages using various Tasks, Containers, Data transformations like Fuzzy Lookup, For Each Loop, For Loop Sequence Container and FTP.
• Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Extensive knowledge of Designing, Developing and deploying various kinds of reports using SSRS using relational and multidimensional data.
• Expertise in creating various Parameterized, Linked, Drill-through, Drill-down and Ad-hoc reports.
• Excellent knowledge in Dimensional Modeling using Kimball methodology, Star/Snowflake Schemas and ODS.
• Experience in Troubleshooting Report Processing, Subscription, Delivery and Configuration Problems.
• Experience in Database Backup, Recovery and Disaster Recovery procedures (Log shipping, Mirroring, Clustering and Replication).
• Good experience with Database Tuning Advisor, Performance Monitor and SQL Profiler for tracing and auditing.
• Experience in SQL administration activities like installation, configuration, maintenance, backup and restore of SQL Server databases.
• Extensively worked on Team Foundation Server (TFS), Visual Source Safe and Tortoise Subversion.
• Ability to learn quickly and work in a team and as an individual with minimal supervision.

TECHNICAL SKILLS

RDBMS: SQL Server 2005/2008/2008 R2/2012, Oracle, Teradata, MS Access, Sybase

Database Tools: SQL Server Management Studio, MS Access, MS Excel, Query Editor

Programming Languages: T-SQL, PL SQL, C#, VB.NET, HTML and Shell Scripting

Reporting Tools: Crystal Reports XI/X, SQL Server Reporting Services

ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services

BI Tool: Business Objects, SSIS and SSRS

Data Modeling: ER-Win, MS- Visio 2003/2007

Operating Systems: Windows 2000/2003/XP/Vista/2007

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

SQL/SSIS/SSRS Developer

Responsibilities:

• Understanding the business requirements.
• Extracted the data from the different sources and stored the data into the intermediate Staging Database using the SSIS ETL tool.
• Complex business requirements were transformed into ETL using a variety of transformations like Aggregate, Derived Column, Data Conversion, Union All, Merge Join, and Lookup.
• Maintained all the SQL documents include installation and data conversion Procedure documents.
• Conducted data migration processes in the SQL Server environment using SQL Server Integration Services 2012.
• Created SQL Server Reports for Management using SSRS. Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS 2008R2.
• Developed several reports with consistent drill-down functionality including Drilldown reports, Summary reports and Master Detail reports.
• Wrote complex Stored Procedures, coding and triggers to capture updated and deleted data from OLTP systems.
• Developed Custom Functions, Manual Running Totals and Complex Formulas for reports.
• Experienced in implementation of strong referential integrity and auditing by the use of triggers.
• Deployed the SSIS Packages to the MSDB as well as File System based on the requirements
• Involved in the development of custom SQL, T-SQL, custom stored procedures, functions and triggers.
• Created the automated processes for the activities such as database backup processes and SSIS, SSRS Packages run sequentially using SQL Server Agent job and windows Scheduler.
• Created copies of operational Databases using the Import/Export Wizard.
• Developed Cross-Tabbed and Sub-Reports in SSRS 2008R2.
• Designed and Developed matrix, tabular and parametric Reports in the SQL Server Reporting Services 2012.
• Used breaks, calculations, sorts, filters and sections to enhance data presentation in reports.
• ETL process was documented for future references.
• Created complex SSIS packages using various transformations.

Environment: MS SQL Server 2008R2/2012, BIDS (SSIS, SSRS), T-SQL, C#, Agile, Share Point Portal Server, Windows Server 2008, Erwin, Oracle, Visual Studio.NET 2010.

Confidential, Louisville, KY

SQL/SSIS/SSRS Developer

Responsibilities:

• Responsible for all project lifecycle phases, from specifications and coding through deployment, testing, debugging, documentation, and maintenance.
• Managing physical database design& creation, devising strategies for backups, recovery & fine-tuning.
• Tuning SQL statements and rendering support for MS SQL tool-sets and utilities.
• Responsible for every month releases and production support.
• Extensively working with off shore team and coordinating the workflow as per everyday Project Status.
• Modifying database programs to increase processing performance, referred to as Performance tuning.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• RobustSSISpackages with row counts, verifications, notifications, security, runs on test and production servers, ftp, compress txt files, indexing and table constraints.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2008R2.
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports.
• Define and develop Report Structure withdata definition, report layout and report definition language.
• Extensive experience in creating several reports such asdrill down reports, parameterized reports, linked reports, sub reports, Matrix Reports and Chart reportsusingSQL Server Reporting Services.
• Experience in scheduling and deployment of reports and uploading files to a report server catalog from the report manger.
• Experience inSharePoint & Performance Point Servers.

Environment: MS SQL Server 2008R2, SQL/SSIS/SSRS, SharePoint 2010, T-SQL, VSS, Visual Studio.NET 2008, Oracle, .XML, MS Office.

Confidential, Dallas, TX

SQL/SSIS/SSRS Developer

Responsibilities:

• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Created necessary steps to enhance user response time by improving queries and their index selections to minimize IO and eliminate table scans.
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Created and developed data dictionary, tables, views, indexes, functions and advanced queries for databases by using Query Analyzer and SQL Server Enterprise Manager
• Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
• Failover cluster testing and resolution on servers as well as monitoring and backup reporting setup with Microsoft Operations Manager and backup teams
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Experience in moving the data from heterogeneous data sources like oracle, xml etc. to SQL using SSIS.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.

Environment: SQL Server 2005, Query Analyzer, SQL/SSIS /SSRS, Visual Studio.NET, ProClarity Server, XML, BizTalk server 2006, MS Excel, Window XP, Oracle.

Confidential

SQL Server Developer

Responsibilities:

• Gathered functional requirements and written the technical specifications
• Designed logical / physical data models and defined primary key, foreign key using Erwin tool.
• Wrote T-SQL statements using DML and DDL for retrieval of the data.
• Created complex stored procedures, triggers and cursors in SQL Server.
• Developed source to target specifications.
• Developed stored procedures, functions, views and triggers.
• Developed stored procedures to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables.
• Created DTS package to schedule the jobs for batch processing.
• Performance tuning to optimize SQL queries using query analyzer.
• Created indexes, constraints and rules on database objects.

Environment: UNIX, Shell Scripting SQL Server 7.0/2000/2005, VB.NET, Enterprise Manager, SQL Profiler, DTS, T-SQL, Oracle, BCP, Replication

Confidential

SQL Server Developer/ DBA

Responsibilities:

• Designed, implemented and administrated SQL Server 2000 databases.
• Implemented Constraints (Primary Key, Foreign Keys Check and Not Null/Null) and fine tune Indexes on Tables.
• Create and Modify Stored Procedures, Triggers, Views according to the business.
• Developed various reports to validate the data between source and the target systems.
• Design of ETL processes to transfer customer related data from MS Access, excel to SQL Server.
• Used Database Engine Tuning advisor and SQL Profiler for Monitoring memory, processor, Disk I/O and SQL Queries.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.

Environment: SQL Server 2000/2005 Enterprise Edition, Enterprise Manager, Query Analyzer, Import & Export Data, VB.NET, Windows 2000, MS Access, MS Excel.