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 teh 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 teh 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 noledge in query optimization & performance tuning.
• Expertise in designing complex SSIS packages for migrating teh data and used various containers and Task that are available and used enhanced Error handling mechanism and check points in SSIS.
• Expert in Migrating teh 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 noledge 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 teh 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 teh 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 noledge of Normalization and Relational Database Management Systems.
• Excellent communication and interpersonal skills and has 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 teh Variance between teh 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 teh packages and used appropriate Isolation Level and Transaction Options in in SSIS package.
• Designed new SSIS packages for daily and weekly process and Modified teh 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 teh new MDX calculation for prior year variance, sum, and average and optimize teh 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 teh 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 teh XML.
• Designed whole new automated process for executing SSRS subscriptions and giving ability to hold teh 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 teh 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 teh 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 noledge 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 teh data of teh 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 teh SSIS packages to handle bad data and avoid package failures.
• Developed SQL Server Integration Services (SSIS) packages to automate teh nightly extract transform and load jobs.
• Experience with database communication mechanisms: .NET, ODBC and TCP/IP
• Experience in implementing teh SQL server Service Broker and hands on experience in trouble shooting issues.
• Implemented CDC (Change Data Capture) in SQL Server 2008 and Partitioning of teh tables.
• Experience in code migration, database change management and data management through teh various stages of teh development life cycle
• Designed and built prototype for access certification challenge on teh wholesale end to integrate with Enterprise access certification tool.
• Database migration is done from SQL Server 2005 to SQL Server 2008 to enable teh applications to run better and reduce teh amount of time you need to spend managing them. Regular dropping and construction of indexes.
• Good noledge 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 teh 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 teh 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 teh 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 teh MS SQL Clustering architecture and Replication Setup.
• Maintaining documentation related to database server configuration, database change management and Technical Design Document.
• Managed teh historical data in teh 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 teh 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 teh date according to teh change of teh request made by teh 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 teh Trace.
• Proven Knowledge to Work with TFS (Team foundation server) and Seeding teh 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 teh packages using Sql jobs and experienced in validating teh 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 teh details of weekly calls for various location for assessing teh 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 teh 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 teh 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 teh 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 teh data entry and payment verification.
• Created views for teh users according to their roles.
• Helped teh 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 teh databases, troubleshooting, managing teh 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 teh critical errors.
• Daily monitoring of teh database performance and network issues.
• Captured and analyzed teh long running stored procedures using SQL Profiler and tuned teh same to improve application performance.
• Created various complex T-SQL Queries, Stored Procedures, Views, Cursors and User Defined Functions to implement teh business logic.

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