SUMMARY

• Having 8 plus years of experience of Database Design and Development in MS SQL Server 2000/2005/2008.
• 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
• Experience in building new SQL Server 2012 with tabular mode systems and Always On with high availability and Replication with Log Shipping and applying patches to the existing system and Configuring Report Server
• Expertise in T - SQL and PLSQL (DDL, DML), inline Views, Stored Procedures, 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 dat 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.
• Having expert knowledge in creating reports using Performance Point Server, Share Point Designer, MS Office Front Page and Team Foundation Server Admin (TFS).
• Expertise in generating on-demand reports, Tabular Reports, Matrix reports, List Reports and sub reports for business analysis using SQL server reporting services and Created the Dashboards using DUNDAS components (Maps, Gauges, Charts, Calendar).
• Expert in creating Cubes, aggregations, Measure Groups, KPI’s, Perspective, Calculated Measures in SSAS.
• Expert in writing MDX calculation for prior year variance, sum, and average and optimize the existing MDX calculation for better performance using various functions (NONEMPTYCROSSJOIN, SETTOSTR, STRTOSET, LEVELS, and ANCESTOR).
• Expert in Tuning SSAS cube using Usage based Optimization and SSAS Query log.
• Data Modeling using Microsoft Visio and Erwin.
• Proficient in working with .NET features like Inheritance, Polymorphism, Abstract, Classes, Generics & Collections, threading, Exception, handling, Debugging, and Tracing in .NET application.
• Working in an agile Environment to deliver higher-quality software, more taking up rapid requirement changes and also for faster product releases.
• Extensive knowledge of Normalization and Relational Database Management Systems.
• Excellent communication and interpersonal skills and TEMPhas ability to handle multiple tasks; can take initiative to handle responsibilities independently as well as a proactive member of a team.

TECHNICAL SKILLS

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

Workstation: Windows 2003/2008 Server

Databases: MS SQL Server /2000/2005 and 2008R2

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: Compaq Proliant, IBM Netfinity Servers and Dell Servers

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

Languages: VB.NET, C, C++, HTML.

PROFESSIONAL EXPERIENCE

Confidential, Baltimore MD

MS SQL Server /SSRS/SSIS/ 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 Tera data.
• Designed new SSIS packages for new Project called Karma and also designed new Data model for new project and added Event handling mechanism in the packages and used appropriate Isolation Level and Transaction Options in in SSIS package.
• 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.
• Designed the new MDX calculation for prior year variance, sum, and average and optimize the existing MDX calculation for better performance.
• Created various SSRS reports with MDX calculations and report types 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 Adhoc 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 SSRS reports using Tablix, Sub reports, Drill Down, Drill Through, Chats, Gauges etc…
• Designed and develop user-interface screens using .Net technologies: ASP.Net and C#. (4.0 Framework).
• Designed the application with extensive use of Object Oriented Programming techniques like inheritance, data hiding, encapsulation and polymorphism.
• Created T-SQL scripts like Store Procedures, CTE, Functions, Indexes and other database objects.
• Created Teradata Views and used Teradata client for pulling data into SQL server using SSIS.
• Designed SSAS cube for different business segment and created Calculated Measures using MDX and Tuned Cubes for better performance by deleting unused Aggregations by using Usage Based Optimization tool in SSAS.

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.
• A thorough understanding of relational databases and SQL
• Experience with MS SQL Server 2005 and 2000 environments with some emphasis in Database Administration, including management tools.
• Advanced knowledge of SQL query development using MS SQL-Server 2005
• Strong Experience in SQL Performance Tuning using various performance matrix gathering techniques.
• Strong Experience in SSIS and heavy duty SQL Development using SQL Server internal database metadata structures, XML and Encryption
• Worked extensively on SSIS Packages for extracting the data of the file system and transformed dat 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 with database communication mechanisms: .NET, ODBC and TCP/IP
• Experience in implementing the SQL server Service Broker and hands on experience in trouble shooting issues.
• Implemented CDC (Change Data Capture) in SQL Server 2008 and Partitioning of the tables.
• Experience in code migration, database change management and data management through the various stages of the development life cycle
• Designed and built prototype for access certification challenge on the wholesale end to integrate with Enterprise access certification tool.
• Database migration is done from SQL Server 2005 to SQL Server 2008 to enable the applications to run better and reduce the amount of time you need to spend managing them. Regular dropping and construction of indexes.
• 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.
• Management of the database environment by defining database maintenance tasks, such as backup & restore, indexing, statistics, alerts and notification for database servers.
• Creating Database objects - Tables, Views, and Functions and developing Procedures for Implementing application functionality at the database side for performance improvement.
• Implemented new features in SQL 2008 like Policy based Management, Table Compression & Backup compression; SQL Server Auditing and MERGE statement in T-SQL and spatial data types provide powerful and easy to use application development enhancements.
• 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:

• Reviewed, developed and designed data models, in conjunction with the application development team by MS Visio.
• 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.
• Involved in using Dashboard for making Request or Fulfillment for different components and Title-alpha.
• Experienced in updating and inserting the date according to the change of the request made by the UI Team.
• Hands on Experience on using Performance Tools such as Sql Profiler, Database Tuning Advisor.
• Experienced in improving performance by creating Clustered indexes and Non-clustered indexes by looking at the Trace.
• Proven Knowledge to Work with TFS (Team foundation server) and Seeding the data for different test cases.
• 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 dat 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.
• Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• 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.
• Performed low-level scripting, fixing of codes and software enhancement process.
• Working on different environments and a key resource for deployment of modified objects to production environments.
• Creating DTS Packages for data import and export and scheduled jobs for backups.
• Job Monitoring and making sure all jobs run successfully every night.
• 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 silver spring

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 has 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.
• Helped the front end application developers with their queries.
• Responsible for Providing 24x7 fast paced DBA support for production, development and testing environment.
• Involved in performance tuning of the databases, troubleshooting, managing the use of disk space (capacity planning), memory and connections.
• Created SSIS packages to import data / export data, send reports as email attachments and upload tab delimited txt data files to client ftp sites.
• Responsible for scheduling and monitoring SQL server agent jobs and Database Maintenance process in production and internal environment.
• Created jobs, alerts, logs to monitor the critical errors.
• Daily monitoring of the database performance and network issues.
• Captured and analyzed the long running stored procedures using SQL Profiler and tuned the same to improve application performance.
• 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.