SUMMARY

• Over 7 years of IT experience as SQL developer/DBA in design and development of various applications for IT, Pharmaceutical, Financial, Insurance, Manufacturing, and Healthcare Industries
• Experience in writing and debugging Store Procedures, Triggers and User Define Functions
• Experienced with scripting in T - SQL in constructing tables, joins, user functions, views, indexes and user profiles
• Expertise working on Online Transaction Processing (OLTP), Data Warehousing and Online Analytical Processing (OLAP) environments
• Master in T-SQL Programming, SQL stack including SSIS, SSRS and SSAS
• Experienced working on Normalized Databases and designed database/tables and the requisite relationships, designed partition tables and partition views
• Implemented cursors for rebuilding indexes
• Extensive knowledge of Relational Database Management Systems (RDBMS)
• Successfully created Fact Tables, Dimensions and joined them to extract meaningful data
• Experience in assisting the Application Developers in creating conceptual database designs that meet the business and technical objectives of various projects
• Involved in Logical Design of the Database & transforming it into a Physical Design
• Experience in creating and maintaining Database objects in SQL SERVER 2012 in SQL Server Management Studio
• Experience in data acquisition from upstream level to lower stream level using SSIS packages, Stored Procedures
• Skilled in writing Transact-SQL in SQL Server Management Studio and Query Analyzer to handle database objects
• Tuning and Optimization of Transact-SQL Stored Procedures
• Experienced in ETL (Extracting, Transforming and Loading) development using SSIS for migration of data from one server to other servers using SQL Server Integration Services (SSIS)
• Transformed database objects from one server to others servers using SSIS
• Experience in SQL Server Migration and Migration of DTS Packages to SSIS.
• Have a good experience in merging data from various data sources using SSIS
• Experience in working creating Multidimensional cubes with MDX queries using SSAS
• Experience in design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting using SQL Reporting Services (SSRS)
• Experience in Database Backup and Recovery procedures to protect database from data loss due to any failure
• Prepare dashboard and Excel reports using power BI
• Experience in establish Database Mirroring, Log Shipping and Linked Server.
• Experience with VBA macros in Excel to enhance the Excel reports
• Good team player, quick learner and detail oriented, strong technical and communication skills, organizational and report writing skills, presentation skills combined with self-motivation.

TECHNICAL SKILLS

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

RDBMS: SQL Server 2008/2012, Oracle 8i/11g and MS Access 2000/97

Internet Technologies: ASP.NET, VB Script, HTML

Front End: VB.NET, VB 6.0

Operating Systems: Windows XP/2003/2000/NT

SQL Server Tools: SQL Server Management Studio, Enterprise Manager, Query Analyzer, Profiler, Export & Import (DTS), SQL Server Integration Services (SSIS )

PROFESSIONAL EXPERIENCE

Confidential, Issaquah, WA

SQL Database Developer

Responsibilities:

• Worked on different Stored Procedures to improve the Stored Procedure performance, Testing and Performance Tuning
• Created new stored procedures, tables, indexes, etc.
• Fine-tuned Stored Procedures using Execution Plan in T-SQL for better performance.
• Migrates the data from one database to other on different servers.
• Performed data acquisition from upstream level databases to lower level databases.
• Involved in daily loads (FULL & INCREMENTAL) into Staging and ODS areas, troubleshooting process issues and errors.
• Created SSIS Packages for different programs and worked on Incremental data SSIS package.
• Performed ETL task using transformations like OLE DB Source, OLE DB Destination, Derived Column, Data Conversion, OLE DB command, Slowly Changing Dimension, Union All, Execute Script Task, Conditional Split, Merge, Lookup, etc.
• Designed and developed the SSIS packages that extract data from various sources include CSV, Excel, DBs, SQL 2012 DB Sources
• Created and modified complex stored procedures and Optimizing existing queries and Stored Procedures, Error handling to increase the query performance, Database Consistency Checks using DBCC Utilities.
• Created clustered/non clustered Indexes on columns for fast and efficient reporting process of the stored procedure, improve performance tuning by creating missing indexes using SQL Profiler.
• Used SQL Server Agent for scheduling jobs and alerts

Environment: SQL Server 2012 Enterprise Edition, SQL Server 2012 Reporting Service, Windows Server 2008, Business Intelligence Data Tool 2012/2013, SQL Server Integration Services (SSIS), MS Visio.

Confidential, North Wales, PA

SQL Database Developer

Responsibilities:

• Responsible for the design, development and implementation of mappings / transformations based on source-to-target specifications, defining ETL (extract, transform, load) development standards and conventions
• Import/Export and successfully migrated the Databases such as DB2 and MS Access to SQL Server 2012 using SSIS. Scheduled the same packages by creating the corresponding job tasks
• Developed ETL’s using transformations like OLE DB Source, OLE DB Destination, Derived Column, Data Conversion, OLE DB command, Slowly Changing Dimension, Union All, Script Task, Flat file Source, Flat file Destination, Conditional Split.
• Created the dimensional & Relational models for various databases for monitoring tools
• Designed & developed the various SSIS packages for the daily, Hourly, Weekly & Monthly Loads.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server 2012
• Designed and developed the SSIS packages that extract data from various sources include CSV, Excel, MS access DBs, Oracle DB, SQL 2012 DB Sources
• Designed and implemented Parameterizedand cascading parameterized reports using SSRS
• ScheduledReports to run thereports Hourly, Daily, Monthly accordingto end user requirements
• SQL Query Performance Tuning, system Performance Analysis, analyzing the Query Execution Plans, Use SQL Profiler for optimizing the store procedure
• Expert in designing Star Schema and snowflake schema with Facts, Dimensions, Measures and Cubes
• Create database, Maintain Security and perform Optimization of the SQL server/Oracle Database Performance
• Created and modified complex TSQL batches / stored procedures
• Involved in Creating Stored Procedures and Optimizing existing queries and Stored Procedures, Error handling to increase the query performance
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services
• Mentored and provided backup for Production Support DBA using different software like Red Gate software to maintain availability and security of the database

Environment: Confidential SQL Server 2008/2012, Crystal Report 8.0/10.0, Management studio, Windows 2007, SQL Server Integration Services (SSIS), MS Visio,Asp.net

Confidential, Atlanta, GA

SQL Server Developer

Responsibilities:

• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2005
• Tested, Scrubbing and Standardized business requirements using Fuzzy /exact lookups
• Modified current database by adding tables, altering referential integrity to support online system
• Created views to reduce apparent database complexity for end users and preventing sensitive columns from being selected
• Generated complex stored procedures and functions for better performance and flexibility.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard
• Created/Maintained clustered/non clustered Indexes on columns for fast and efficient reporting process
• Created indexed views and appropriate indexes to cut the complex query time. Implemented new indexing system reduced report-processing time by average of 28%
• Developed cursors to rebuild indexes on all tables
• Created automated reports using SSRS (SQL Server Reporting Services)
• Worked on optimization and tuning of SQL queries and indexes
• Createddifferenttype of reports with charts using SSRS
• Created scripts and SQL jobs to facilitate database backup and recovery, server and data processing monitoring
• Scheduled jobs and setup maintenance plans for monitoring the performance of SQL Server databases by SQL Profiling, Database Mirroring and Log Shipping

Environment: MS SQL Server 2008/2012, Windows 2000, Windows XP, Windows 2007, Clear Quest, ER Studio, T-SQL, Data Transformation Services (DTS), Analysis Services (SSAS), Reporting Services (SSRS), Integration Services (SSIS)

Confidential, Parsippany, NJ

SQL/Database Developer

Responsibilities:

• Experienced working on Databases, Tables, Indexes, Unique/Check Constraints, Views, Stored Procedures, joins and User-defined functions
• Developed SQL Scripts to Insert/Update and Delete data in MS-SQL database
• Experienced working on Aggregate, financial and Date time in Development ofreports
• Involved in report creation using SQL Server Reporting Services (SSRS), and Excel spreadsheet as per the client Requirement and for the periodic analysis
• Experienced in Extraction Transformations and Loading (ETL) tools like Data Transformation Services (DTS) and SSIS
• Extensive use of T-SQL statements to write complex queries
• Extensive use of Stored Procedures. Writing new stored procedures and modifying existing ones and tune them such they perform well
• Database Integrity Checks, Update Database Statistics, Re-indexing and data backups
• Scheduled and maintained routine jobs and alerts
• Developed cursors to rebuild indexes on all tables
• Responsible for Query optimization and Performance tuning using SQL Server Profiler
• Responsible for providing daily and weekly reports to the immediate supervisor and actively involved in the daily and weekly meeting to discuss project status

Environment: Windows NT server, Visual Basic 6.0, ASP 3.0, SQL Server 1008/2012, ERWIN, Crystal reports, SQL Server 2008 Reporting Service, Oracle 10.g/11g

Confidential, Portland, Maine

SQL BI Developer

Responsibilities:

• Extensively used DDL Scripts for generating Tables, Views, Functions
• Developed SQL Scripts to Insert/Update and Delete data in MS-SQL database
• Created views to reduce apparent database complexity for end users and to prevent sensitive columns from being selected
• Generated and debugged complex stored procedures and functions for better performance and flexibility.
• Scheduled and maintained routine jobs and alerts.
• Performed performance tuning by studying execution plan, analyzing indexes and using SQL Profiler
• Developed complex stored procedures and functions to create various reports.
• Generated, modified and published reports using SQL Server Services
• Developed custom reports using SSRS/SQL Server BI studio
• Scheduling Jobs, Backups and Restore database
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables
• Extensively used T-SQL to create triggers and stored procedures used by the enhancements modules to update the SQL Server database.

Environment: SQL Server 2008/2012 Enterprise Edition, SQL Server 2012 Reporting Service, Oracle 10.g/11g, IIS 6.0, Windows Server 2007

Confidential, Bethesda, MD

SQL Server BI Developer

Responsibilities:

• Developed ER diagrams (Physical and Logical using MS Visio) and mapping the data into database objects
• Actively involved in Normalization (2NF) of database
• Involved in designing and writing Stored Procedures, functions, views, joins and packages using T-SQL for SQL Server 2008
• Involved in Creating Stored Procedures and Optimizing existing queries and Stored Procedures
• Used system stored procedures and DBCC commands
• Identified and resolved the query performance using and Index tuning wizard
• Involved in performing Extraction, Transformation and Loading (ETL) using DTS & SSIS
• Designed and developed various Service Management Reports, sub-reports, charts, parameterized reports, conditional and dynamic reports using SSRS
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008
• Create Reports using SQL Server Reporting Services (SSRS) and analyzed using Server Analysis Services (SSAS)
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary
• Monitored and scheduled existing/new jobs on production environment
• Generated the Insert script for the Lookup tables
• Performed Database backups (operating system, flat file backups & export/import)

Environment: MS SQL Server 2008/2012, Windows 2000, Windows XP, Windows 2007, Clear Quest, ER Studio