SUMMARY

• 6+ years of IT experience as a SQL developer, extensive experience with analyzing, designing, development and maintenance of SQL Server 2014/2012/2008 R2/2008 in Production, QA & Development environments with strong coding skills.
• Experience in Software Development Life Cycle (SDLC) phases like Requirement Gathering, Analysis, Design, Development, Integration and Testing, and Implementation.
• Profound understanding of Entity Relationship Diagram and Database Normalization. Knowledge in Database design and design of Physical and Logical Structure.
• Highly proficient in the use of T - SQL for developing complex Stored Procedures, Triggers, Functions.
• Skillful in creating Tables, Views, Indexes and other SQL joins and complex query writing.
• Experienced in data loads, database integration/conversions, performance tuning and optimization.
• Expert in High Level Design of ETL Package for integrating data from heterogeneous sources like Oracle, Excel, CSV, flat file, Text Format Data.
• Utilized control flow items such as Execute SQL Task, Execute package task, script task, For-each, For loop, File System Task and maintenance tasks such as Rebuild/Reorganize Index, Shrink Database and Update Statistics task using SSIS.
• An expert in utilization of data flow items such as ADO.NET and OLE DB sources for data source setups, Lookup component, Derived column, Multicasting, Conditional split, Data conversion, Aggregate, Character map, Slowly changing dimension, Merge and Merge join using SSIS.
• Designed, developed and implemented ETL design for incremental analytical data loads for the Enterprise data warehouse solution.
• Designed, developed and implemented various SSIS Packages and deployed using Deployment wizard.
• Developed and implemented custom logging structure in Event Handlers for all the SSIS packages using SSIS system variables. Designed archive structure for error logs for auditing purposes using T-SQL and Integration Services.
• Experience with job scheduling using SQL Server Agent to perform hourly/daily/nightly updates.
• Designed and deployedreportswith Drill Down, Drill Through, Drop Down, Parameterized, Sub-reportsand Linkedreports.
• Developed and maintained report models to be used as data source for ad-hoc reports.
• Expert in designing reports using SQL Server Reporting Services (SSRS), which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting services.
• Hands on experience in generating on-demand and scheduled reports for business analysis or management decision using SSRS.

TECHNICAL SKILLS

Database: SQL Server 2014/2 R2/2005/2000, Oracle 10g/9/8i

Performance: Tuning, Capacity Planning, Installation, Migration, SSIS.

Reporting Tools: SQL Server Reporting Services

Data Mining Tools: SQL Server Analysis Services

DBMS Tools: SQL Server Management Studio

ETL Tools: SSIS

Languages: T-SQL, SQL, PL/SQL.

Virtualization: VM Ware, Virtual Box.

Scheduling Tools: SQL Server Agent, MS Task Scheduler.

Operating Systems: Windows 2008/2003/2000/ NT, Windows XP, Windows Vista, Windows 7, MS-DOS, UNIX, Linux, Macintosh.

PROFESSIONAL EXPERIENCE

Confidential, St Paul, MN

SQL/SSIS/SSRS Developer

Responsibilities:

• Worked with Business Analysts in gathering requirements and translating them to technical specifications.
• Developed Stored Procedures, User Defined Functions, Views, T-SQL Scripting for complex business logic.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Increased the performance necessary for statistical reporting after performance monitoring, tuning and optimizing indexes.
• Used Joins, CTE’s, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases and implemented triggers and Stored Procedures and enforced business rules via checks and constraints.
• Extracted large volumes of data from various data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration services (SSIS).
• Developed and deployed SSIS packages for ETL fromOLTP and various sources to staging and staging toData warehouseusingLookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimensionand more. Performed ETL mappings using MS SQL Server IntegrationServices.
• Created SSIS packages for Uploading of different formats of files (Excel, Access, dbf) and databases (SQL server, Flat files) into the SQL Server data warehouse using SSIS.
• Created Jobs in SSIS and was responsible for ETL job scheduled to run daily. Solved the issues associated with ETL Data Warehouse Failure.
• Used Script task to write custom code using Vb.net.
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Created jobs for automatically running Stored Procedures for day-end operations using SQL Server agent such as index rebuild, data loads and summary reports.
• Involved in Performance Tuning of Code using execution plan and SQL profiler and added Indexes to improve performance on tables.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2012/2008.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Designed SSRS reports with dynamic sorting, defining data source and subtotals for the report.
• Created different types of reports such as Cross-Tab, Drill-down, Drill Through, OLAP and formatting them using both SSRS 2005/2008.

Environment: MS SQL Server 2012/2008R2,Reporting Services (SSRS), Integration Services(SSIS), Microsoft Performance Point Server 2007, Microsoft Share Point Server, T-SQL, .NET, C# MS Access and Excel.

Confidential, Columbus, Ohio

SQL/SSIS/SSRS Developer

Responsibilities:

• Interacted with end users to define, create, implement, and maintain their reporting requirements and documented the designs.
• Created Reports on Oracle database using SSRS 2008.
• Created SQL Server Reports using SSRS 2008, and used parameters to design the parameterized reports.
• Designed reports for end user by creating multiple operational Drill-through and Drill-down, parameterized, cascaded, Matrix type reports and charts using SSRS.
• Managed migration from Crystal Reports to SQL Server Reporting Services.
• Designed and created Report templates, bar graphs and pie charts based on the data.
• Created SSIS/DTS packages for an application that would transfer data among servers and perform other data transformations and scheduled the same SSIS packages by creating the corresponding job tasks.
• Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component and etc.
• Extensively used T-SQL in constructing Stored Procedures, Common Table Expressions (CTEs), User Functions, Indexes, User Profiles, Relational Database Models, Data Dictionaries, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Planned, defined and designed data flow processes for data migration to the Data Warehouse using SSIS.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Extensively used T-SQL Pivot and Un-pivot for de-normalizing and normalizing source data for designing daily data loads for Warehouse.
• Designed logical/physical data models and defined primary key, foreign key using Erwin tool.

Environment: MS SQL Server 2012, SSRS, T-SQL, SSIS, Visual SourceSafe, Win 2003 Advanced Server, PowerBuilder 5, Erwin v8.0, ASP.Net, C#.

Confidential, Dallas, Texas

SSIS SSRS Developer

Responsibilities:

• Designed the Functional Requirements and Mapping Technical Specifications on the basis of Functional Requirements.
• Creating Database objects - Tables, Views, and Functions and developing Procedures for implementing application functionality at the database side for performance improvement.
• Performing query plans and making sure each and every query is using appropriate useful Indexes
• Creating and Modifying T-SQL Stored Procedures/Triggers for validating the integrity
• Used Performance Monitor and SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries, other etc.
• Deployed the created SSIS packages in Development and Testing environments.
• Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases
• Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all and Script component.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created Drill-down, Parameterized and Sub-Reports using SSRS.

Environment: MS SQL Server Management Studio (SSMS) 2012/2008R2, SQL Profiler, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS).

Confidential, Columbus, OH

MS SQL Developer/SSIS/SSRS Developer

Responsibilities:

• Maintain MS SQL Server 2005 and 2008, including security, configuration and install service packsupgrades.
• Build ETL processes utilizing SSIS and DTS, including FTP data from remote location, transform it, mart it to data warehouse and provide proper error handling and alerting.
• Implemented the Data Cleansing using various transformations such as Lookup, Fuzzy Lookup and Derived Column.
• Involved in maintaining batch log tables and error logging tables to handle errors using event handlers.
• Create triggers to keep track of changes to the fields of tables when changes are made.
• Worked with business stakeholders, application developers, productionteams and across functional units to identify business needs and discuss solution options.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Created/Updated database objects like tables, views, Stored Procedures,function, packages.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Rigorously tested and debugged the Stored Procedures and used Triggers to test the validity ofthe data after the insert, update or delete.
• Deployed and scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
• Developed and delivered dynamic reporting solutions using MS SQL Server 2008R2 Reporting Services (SSRS).
• Involved in monitoring and tuning report performance by analyzing the execution plan of the report.
• Generated Drill down, Drill through, Ad-hoc, Matrix Reports, parameterized reports using SSRS.
• Designed and developed monthly, quarterly and yearly reports at branch and bank level.
• Involved in table and indexpartitioning for performance and Manageability.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensuredatabase optimization.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Automated and enhanced daily administrative tasks including database backup and recovery.
• Helped create process logging and new monitoringtools, integrity reports, and mapping tools.

Environment: MS SQL Server 2008R2, T-SQL, SQL SSIS, SSRS, SSAS, Windows server 2003, Visual Source Safe, SQL Profiler, Erwin 7.2, Oracle 10g, DB2, VB.Net, Query Analyzer, BCP.

Confidential

MS SQL Server Developer

Responsibilities:

• Installed and configured MS SQL Server 2005 along with Visual Studio on a network domain system.
• Created logical and physical data models using Erwin for new requirements after discussion with technical team and application users.
• Designed DTS/SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager/SSMS on SQL Server 2000/2005 environment, and deploy the data.
• Used Event Handlers for Exception Handling in SSIS packages.
• Generated reports on wealth information, account information, research reports using ad hoc reporting to be used by the clients and advisors.
• Created Queries, Stored Procedures, and Views to store the data of clients, advisors.
• Created User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables to improve the query performance.
• Conducted performance tuning by using SQL Profiler and index tuning wizard.
• Created many complex Stored Procedures/Functions and used them in Reports.

Environment: MS SQL SERVER 2005/2000, SSRS20005/2008, SSIS 20005/2008, Erwin, Visual Studio 2005, MS Office 2003, Windows 2003.