SUMMARY:

• 8 plus years of experience of Database Design and Development in MS SQL Server (2000 - 2014).
• Extensive experience in Database activities like Data Modeling, Database design, database creation and maintenance, performance monitoring and tuning, troubleshooting, enterprise level replication.
• Involved in total Software Development Lifecycle (SDLC) by identifying the business requirements, documenting technical design documents, developing components to implement business requirements and creating and executing unit test plans
• Configured high availability like Replication, Log Shipping and Mirroring applying patches to the existing system and Configuring Report Server
• Expertise in T-SQL and PLSQL (DDL, DML), inline Views, Stored Procedures, Function, Triggers, Correlated sub queries etc… and in depth knowledge in query optimization & performance tuning.
• Expertise in designing complex SSIS packages for migrating the data and used various containers and Task that are available and used enhanced Error handling mechanism and check points in SSIS.
• Expert in Migrating the SSIS objects over environments and used transaction and isolation levels in SSIS.
• Experience in importing data from various legacy system using SSIS and DTS.
• Expertise in generating on-demand reports, Tabular Reports, Matrix reports, List Reports and sub reports for business analysis using SQL server reporting services

TECHNICAL SKILLS:

Operating Systems: Windows 2000/NT/XP/7/8

Workstation: Windows 2003/2008 /2012 Server

Databases: MS SQL Server 2014/2012/2008/2005

Testing Tools: Win Runner, QTP, Test Director/Quality Center, Load Runner

ETL Tools: DTS (Data transformation services), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS)Database Tools: Enterprise Manager, PowerShell, Query Analyzer, System Monitor/Performance Monitor, PAL, Event Viewer, SQL Profiler, Index Tuning Wizard, Upgrade Wizard, Database Maintenance Plan Wizard, Bulk Insert and BCP.

Reporting: Excel, MS SQL Reporting services, data Analyzer

Hardware: IBM Servers and Dell Servers

Software: VB 6.0, ASP.net, XML, MS Office applications.

Languages: C#, Java, HTML

PROFESSIONAL EXPERIENCE:

Confidential, McLean, VA

SQL Server/SSRS/SSIS/dev

Responsibilities:

• Gathering requirements and analyzing the specifications of Business Requirements.
• Designing SSIS packages using Containers, Script task using c# various transformation and following best practices.
• Designing new SSIS packages for daily and weekly process and Modified the existing SSIS package for better performance by following best practices.
• Creating parameterized reports, sub-reports, drill through reports & creating subscriptions and data driven subscriptions using SSRS.
• Loading Data, Configuring SSIS Catalog, and Troubleshooting errors.
• Migrating data from different Sources to sql server using SSIS.
• Creating and managing database objects, stored procedures, triggers, Functions, views and indexes.
• Modifying the existing Stored Procedures and batch jobs to get the new functionality depending on the client’s requirement.
• Perform system design, development, maintenance and deployment.
• Backing up entire user’s database and scheduled backup process.
• Scheduling Jobs and Alerting using SQL Server Agent.
• Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Environment: MS SQL Server 2012, 2014, 2008R2, MS SQL, Microsoft.NET, SSDT, SQL Server Integration Services (2012 SSIS), SQL Server Analysis Services (2012 SSAS), SQL Server Reporting Services (2012 SSRS).

Confidential, Baltimore MD

MS SQL Server /SSRS/SSIS/SSAS/ Developer

Responsibilities:

• Gathering requirements for new calculations, measure group, new date dimension.
• Created T-SQL script to find the Variance between the data and created in line Views, Stored Procedures, CTE and Correlated Sub queries etc… and created Dynamic SQL.
• Designed SSIS package using Script Task, Containers, Various transformation and followed best practice for handling Teradata.
• Designed new SSIS packages for daily and weekly process and Modified the existing SSIS package for better performance by following best practices.
• Enabled query logging for using usage based optimization for gaining performance and Designed New Measure groups in SSAS.
• Created various SSRS reports like Graphs, Charts, Sub Report, and Linked Report etc… and used several expressions and published the reports in SharePoint.
• Created Tabular reports, matrix reports, List reports and sub reports in SSRS.
• Created Ad hoc reports using Report Builder and used Drill down and Drill Through functionality.
• Designed SSIS packages to handle XML, Flat files and used power shell scripts to modify the XML.
• Designed whole new automated process for executing SSRS subscriptions and giving ability to hold the subscriptions using newly designed ASP.net UI pages called Subscription Management.
• Created T-SQL scripts like Store Procedures, CTE, Functions, Indexes and other database objects.

Environment: MS SQL Server 2012, 2008R2, MS SQL Server 2005, Microsoft.NET, SQL Server Integration Services (2008 SSIS), SQL Server Analysis Services (2008 SSAS), SQL Server Reporting Services (2008 SSRS)

Confidential, Bethesda, MD

MS SQL Server /SSRS/SSIS/ Developer

Responsibilities:

• Gather requirements and understand the specifications of Business Requirement.
• Worked extensively on SSIS Packages for extracting the data of the file system and transformed that data and load it into OLAP.
• Extensively used various SSIS objects such as Control Flow Components, Dataflow Components, Connection managers, Logging, Configuration Files etc.
• Designed, developed, debugged and tested SSIS packages, Stored Procedures, configuration files and implement best practices packages to maintain optimal performance.
• Developed and implemented error handling logics in all the SSIS packages to handle bad data and avoid package failures.
• Developed SQL Server Integration Services (SSIS) packages to automate the nightly extract transform and load jobs.
• Experience in code migration, database change management and data management through the various stages of the development life cycle
• Good knowledge in analyzing Execution plan, Performance and Optimization of Sql Scripts.
• Monitored, optimized and Performance Tuning of Regression Servers using Performance monitor, SQL Profilers, Activity Monitor.
• Created Database objects like Tables, Views, Functions, and stored Procedures.
• Generated reports using SQL Server Reporting Services integrated and deploying them using web applications onto the web server.
• Developed Tabular, Cross Tab reports, Charts reports, Parameterized, cascaded and sub-reports using SSRS.
• Understanding of logical and physical modeling concepts
• Experience with the MS SQL Clustering architecture and Replication Setup.
• Maintaining documentation related to database server configuration, database change management and Technical Design Document.
• Managed the historical data in the data warehouse from various data sources.

Environment: MS SQL Server 2008R2, MS SQL Server 2005, Microsoft.NET, SQL Server Integration Services (2008 SSIS), SQL Server Analysis Services (2008 SSAS), SQL Server Reporting Services (2008 SSRS), 24/7.

Confidential, Jacksonville, FL

MS SQL Server /SSRS/SSIS/SSAS/ Developer

Responsibilities:

• Involved in Designing and Developing Database using 4NF (Normal form).
• Created and Developed Different Client profiles, Master Specifications, Technical Specifications according to Business rules.
• Created and Developed Tables, Views, Triggers, Cursors, Dynamic Stored Procedures, User Defined Functions, T-SQL (DDL, DML) statements and other advanced queries for databases by using SQL Server Management Studio.
• Experienced in creating packages to import data to database using different Transformations such as Data Conversion, Lookup, Fuzzy Lookup, Derived Columns, and Condition Split, Term Extraction, Aggregate, Pivot Transformation, Merge, Multicast and Union All
• Involved in scheduling the packages using Sql jobs and experienced in validating the database for clean build.
• Developed Sub Reports, Matrix Reports, Charts, and Drill down reports, using SQL Server/BI Reporting Services (SSRS) and deploy it in SharePoint server.
• Scheduled reports on a weekly basis to generate the details of weekly calls for various location for assessing the business for that week.
• Knowledge in Database high availability features such as backup/restore, Database Mirroring, Transactional Replication and Database Mirroring.
• Proactive in getting work to be done before deadline.

Environment: Windows 2003, Microsoft SQL Server 2005, MS Access, Microsoft Excel, SQL Query Analyzer, 2005 (SSIS, SSRS, SSAS).

Confidential, Manassas, Virginia

SQL Developer/ DBA

Responsibilities:

• Modeling and architecture of the SQL Server 2005 database.
• Developing stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.
• Configuring, tuning, and optimizing SQL Server 2000.
• Performance testing on stored procedures, indexes, and triggers.
• Data migration using Bulk Copy Process, SSIS and DTS from SQL Server 2000 and Flat files.
• Creating DTS Packages for data import and export and scheduled jobs for backups.
• Extensively Worked in Design of the Dimension Modeling using Erwin
• Experience in Designing Star and Snow flake Schemas
• Developing Crystal Reports used to generate all daily, weekly, monthly and quarterly Reports including current status.
• Technical Analysis, Code Review, Implementation

Environment: Windows 2000, MS SQL Server 2000, MS SQL Server 2005 (SSIS, SSAS, SSRS) Microsoft.NET, MS Visio.

Confidential, MD

SQL Developer/ DBA

Responsibilities:

• Designed and developed for data download from external systems to verify revenues and commissions.
• Creation of database, tables and procedures to update and clean the old data.
• Merging data into a single server environment to have better control, consistency and security of data.
• Backing up entire users’ database and scheduling backup process.
• Used DDL and DML to writing triggers, stored procedure to check the data entry and payment verification.
• Created views for the users according to their roles.
• Involved in performance tuning of the databases, troubleshooting, managing the use of disk space (capacity planning), memory and connections.
• Responsible for scheduling and monitoring SQL server agent jobs and Database Maintenance process in production and internal environment.
• Created various complex T-SQL Queries, Stored Procedures, Views, Cursors and User Defined Functions to implement the business logic.

Environment: Windows 2000/XP, Microsoft SQL 7, Microsoft SQL Server 2000, MS Access.