SUMMARY:

• Over 5 + years of SQL Server database and SQL Business Intelligence Development experience in different domains like secondary market, retail, finance, Healthcare etc.
• Experienced in writing T - SQL, working on SSIS, SSRS, Data Cleansing and Data Migration.
• Experienced in developing Parameterized, Chart, Graph, Linked, Dashboard, Drill-down and Drill-through reports using SSRS.
• Experienced in Extracting and Transforming data SSIS in SQL Server 2005/2008/2008 R2 and SQL 2012 Data Tools and Parallel Data Warehouse (PDW/APS).
• Experienced in installation and configuration of MS SQL Server, 2005, 2008 and 2008R2 versions
• Experienced in Error and Event Handling: Precedence Constraints, Logging.
• Hands on experience in troubleshooting database issues, debugging SQL Server stored procedure/triggers and documenting issues/resolutions of SQL Server Applications.
• Experienced in creating indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency
• Experienced in creating users/logins and providing appropriate and required permission in SQL Server and Analytics Platform System (APS/PDW).
• Extensive experience and knowledge in T-SQL - DML, DDL, DCL, Transactions, Stored Procedures, Triggers and Functions in SQL Server 2005/2008/2008 R2/2012 and Parallel Data Warehouse (PDW/APS).
• Hands-on working experience with analyzing query plans, Code Reviews, managing indexes and locks, troubleshooting deadlocks
• Good hands-on working experience with using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), Writing Transact SQL (T-SQL) Queries, & Dynamic-queries
• Hands on Experience in using SQL Profiler and Database Tuning Advisor for Monitoring and Tuning SQL Server Performance
• Good knowledge of System Development Life Cycle (SDLC)
• Experience in creating Jobs, Sending Alerts using DB Mail
• Experience in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures
• Strong inclination for finishing job within project deadline and good time management skills
• Extremely attentive, strong team player with ability to take new roles and work in high pressure environments

TECHNICAL SKILLS:

Databases: MS SQL Server 2012/2008R2/2008/2005/MS Access

SQL Server Tools: Management Studio, Business Intelligence Development Studio, Integration Services (SSIS),Reporting Services (SSRS), Query Analyzer, SQL Profiler, Parallel Data Warehouse ( PDW/APS)

BI and Other Tools: Visual Studio 2005/2008/2010/2012

Languages: T-SQL,VB 6.0,VB Script, HTML

Operating Systems: Windows 2008/2003/2000/ NT 4.0,Windows XP/VISTA/7

PROFESSIONAL EXPERIENCE:

Confidential, Irving TX

SQL Server Database Developer

Responsibilities:

• Perform Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources having billons of records per table of daily users logins and account creating process from Confidential (BSA) sites
• Performed optimization of existing query, Stored Procedures, SSIS package and SSRS reports.
• Developed complex Stored Procedures to generate various Drill-through reports, Drill-down reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Immediate data extraction from various sources for mass mailing to Customers and vendors.

Confidential

SQL Server SSIS/ETL Developer

Responsibilities:

• Monitor existing and scheduled SQL jobs.
• Complete validation of data from source to stage and to destination once the job execution is complete.
• Fix data and re-execute the jobs individually if it fails.
• Monitor PDW processes using Admin Console
• Create Daily, Weekly and Monthly Report to manager with complete load execution metrics.
• Identify the cause of failures of SQL job and report to management and respective development teams.
• Develop database objects (tables, Views and Stored Procedures) in PDW
• Create/Modify robust ETL packages to extract, transform and Load data from different source systems.
• Used SSDT transformation components like Derived Column, Conditional Split, Lookup, and Merge, Merge Join etc. to apply business rules and cleanse data.
• Create User Logins, create permissions, grant and revoke permissions to Databases and Database Objects
• Create Database roles, alter logins, unlock Logins, add user to database or database objects with specific permissions
• Identify and Optimize slow running queries and implement it

Environment: Microsoft SQL Server 2008 R2 Enterprise edition SP3, BIDS, SSMS, SQL (Parallel Data Warehouse (PDW), Windows Server 2008 R2, SharePoint, Team Foundation Server (TFS) 2010 and Oracle

Confidential, Carrollton, TX

SQL Server SSIS/ETL Developer

Responsibilities:

• Worked with Business analyst, Data architect and business users to understand business processes, document project requirements and translate them into functional and non-functional specifications for BI reports and applications
• Worked with Business Analysts in gathering and documenting requirements with development perspective.
• Wrote transformations to extract data from multiple homogeneous and heterogeneous information sources (CSV, Excel, SQL 2005 and 2008).
• Created packages in SSIS with error handling as well as created complex SSIS packages using various data transformations like conditional split, lookups, aggregations, expressions, fuzzy look up, for each loop, multi cast, column conversion, fuzzy grouping, script components
• Worked with tabular, matrix, chart reports, drills down reports as well as interactive reports according to business requirements.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.
• Designed and developed report with running value, interactive sorting as well as conditional formatting.
• Created sub-reports to present more detailed information about the summary.
• Experience on created reports using stored procedure. Involved in scheduling, creating snapshot and subscription for the reports and triggers to facilitate consistent data entry into the database.

Environment: Microsoft SQL Server 2005/2008/2008 R2 Enterprise edition SP3, BIDS, SSMS, Windows 2008 Server, SharePoint, Team Foundation Server(TFS) 2008/2010

Confidential, Ohio

SQL Database Developer

• Actively involved in analyzing the old database system and mapping tables, relationships, columns to SQL Server 2005.Efficiently worked in installation, configuration, design, implementation of staging database for data migration and data entry
• Created numerous simple to complex queries, views and store procedures involving
• Multi-table joins and self joins and correlated sub queries.
• As a part of the team, analyzed the business requirements and systematically designed
• Database for parking management and details.
• Employed best practices in creating database objects like tables, views, indexes (clustered and no clustered), stored procedures and triggers.
• Build ETL processes utilizing SSIS including FTP data from remote location, transform it, merge it to data warehouse and provide proper error handling and alerting.
• Created triggers to keep track of changes to the fields of tables when changes are made.
• Planned, design, and implement application database code objects, such as stored procedures and views.
• Actively involved in extracting data from database tables and write the data to text files
• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using BCP.
• Data migration (import & export - BCP) from Text to SQL Server.
• Used Crystal Reports to generate ad-hoc reports Filtered bad data from legacy system using complex T-SQL statements, and implemented various constraint and triggers for data consistency
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedures.

Environment: MS SQL Server 2000/2005, Windows 2003 Server, SSIS, SSRS, MS Visio, T-SQL, Business Intelligence studio, Management Studio

Confidential, Seattle, WA

SQL Server SSIS Developer

Responsibilities:

• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, Merge Join and Union all.
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple information sources (CSV, Excel, DB2, SQL 2000, SQL 2005 and 2008).
• Created Configurations to make package portable and created Event handlers for handling package error.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.
• Created and modified various Stored Procedures used in the application using T-SQL.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.
• Created Project Expense Statements in all Data marts and other Financial Reports using SSRS. Developed yearly and quarterly company expense reports.
• Tuning SQL query for better performance using SQL Profiler.

Environment: MS SQL Server 2000/2005/2008, SSIS,SSRS, SSIS, BCP, SQL-Profiler

Confidential, Dallas, TX

T-SQL/SSRS Developer

Responsibilities:

• Involved in gathering Report Development Specifications (RDS) and SOWs for creating reports.
• Developed complex parameterized reports which were used for making current and future business decisions.
• Good knowledge in developing and designing reports through SSRS and Excel
• Developed complex Stored Procedures to generate various Drill-through reports, Drill-down reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Created reports that projected business goals for future.
• Employed Filtered Indexes to improve query performance and reduce the storage and maintenance cost.
• Used table variables and Common Table Expressions (CTEs).
• Worked closely with the offshore team in finding solutions to arising problems.
• Involved in heavy White box and Unit Testing ensuring the delivery of defect free reports to Book Squared clients.
• Helped ETL teams to evaluate databases and application architectures using ACID concepts.
• Followed a priority based methodology to address clients issues on stipulated time window.
• Helped ETL team find solutions on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, SQL 2000, SQL 2005, SQL 2008, SQL 2008 R2)

Environment: MS SQL Server 2005/2008R2/2012, BIDS 2005/2008/2008 R2, Windows Enterprises 2003 servers,SSIS, SQL-Profiler, SSRS, Quality Center, TFS, SharePoint, MS Excel, MS Word.