SUMMARY:

• Over 7 years of SQL Server Development and Database Administration experience in SQL Server 2000/2005/2008 with an emphasis on design, development, enhancement, and automation, tuning and optimizing databases for high Availability, Performance and Security.
• Expertise in MS SQL Server Installation, Configuration, Migration and Maintenance, applying patches.
• Experienced in working with SQL Query Analyzer, SQL Server Management Studio and Business Intelligence Development Studio, scheduling jobs with SQL Server Agent, SQL Server Storage Structures, Index and Security Architecture and SQL Profiler
• Experience in supporting web based, mission critical applications including Logical and Physical Database Design, Development, Performance Tuning and Change Management
• Experience in using Audit functions and extensively used exception handling for catching and reporting errors
• Experience in data warehousing including business intelligence tools- DTS, SSIS and SSRS.
• Very Good Experience in BI Development (SSRS, SSIS, SSAS)
• Experience in migrating SQL 2000 servers to SQL 2005.
• Expertise in defining Database Backup, Recovery and Disaster Recovery Procedures.
• Extensive knowledge and experience in developing scripts using T-SQL for querying against databases
• Expertise in implementing business logic using Triggers, Views and Stored Procedures.
• Proficient at Performance Tuning with a solid knowledge of Optimizing Code
• Installed, Configured and Maintained SQL Server Failover Clustering.
• Experience in Replication, Clustering, Mirroring and other distributed data issues
• Experience in data normalization and de-normalization.
• Experience with SQL Server Security and SQL Server Auditing.
• Very Strong on tools such as Erwin Data Modeler, Visio, TFS and have full understanding of the Software Development Life Cycle.
• Very good communication skills, good interpersonal skills & desire to excel, fast learner, hardworking and a versatile team player

EDUCATIONAL QUALIFICATION:

BTech in Computer Science and Information Technology

TECHNICAL EXPERIENCE:

Languages

T-SQL, PL/SQL, C, C++, Java, HTML, COBOL

RDBMS

MS SQL Server 2005, 2000, MS Access, Oracle 9i and 10g

Database Tools

SSRS, SSIS, SSAS, DTS, BCP, Business Intelligence Studio, Query Analyzer, SQL Server profiler, Enterprise Manager

Operating Systems

Windows 98/2000/XP/NT/Vista, Windows 2000/2003 Advanced Servers, Mac

Architecture

Relational DBMS, Client-Server Architecture, OLTP, OLAP

Version control Tools

Rational Clear Case, Visual Source Safe

Other Tools

Reporting Services, Crystal Reports, Microsoft Visual Studio 2003/2005

EXPERIENCE:

Confidential,Atlanta, GA Mar’10-Till Date
MS BI Developer
Project: Closed Loop Project

InComm is the industry leading marketer, distributor and technology innovator of stored-value gift and prepaid products. InComm\'s retail network features most of the premier brands in the big box, grocery, convenience, chain drug, discount, electronics, office supply and other categories.

Responsibilities:

• Involved in the analysis of the requirements and gathering requirements for closed loop project.
• Involved in creating tables and their relationships in the data warehouse.
• Created Technical Report Requirement document for the Standard Reports.
• Developed large number of standard and customized reports using SSRS for data feeds and for Reports on server.
• Developed Dynamic Report Engine for creating the customized reports in SSRS.
• Involved in creating Dynamic Stored Procedures and views.
• Involved in analyzing and gathering the requirements for Row level Security and Role based security.
• Created the technical requirement Documentation for Row level Security and Role Based Security ETL’s.
• Implemented Row level security and Role based Security in the Standard Reports.
• Involved in creating the tree view folder structure in the application using C#.net to handle different reports.
• Involved in Creating and Testing the SSIS packages developed for security.
• Involved in creating SSIS packages to migrate large amounts of data.
• Involved in using SSAS datasources in SSRS reports.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Involved in performance tuning of queries for query efficiency.

Environment:
MS SQL Server 2008, MS SQL Server Integration/Reporting Services/ Analysis Services 2008(SSIS/SSRS/SSAS), XML, Visual Studio 2008, C#.net.

Confidential,Mc Donough, GA Feb’09-Nov’09
MS SQL Server SSRS /SSIS/SSAS Developer

Nvision Global is a Logistics Company and is a leading global Freight Bill / Invoice Audit, Payment & Logistics Management Services Company offering enterprise-wide supply chain management solutions.

Responsibilities:

• Involved in database development using stored procedures, triggers, views and cursors.
• Used the Object Oriented Analysis and Design specification Unified Modeling Language (UML) for visualizing, specifying, constructing, and documenting data.
• Followed the Agile Methodology in the SDLC.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Wrote efficient stored procedures for the optimal performance of the system
• Monitored performance and optimized SQL queries for maximum efficiency.
• Responsible for Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data
• Created indexed views, and appropriate indexes to reduce the running time for complex queries
• To keep track of data manipulations using Audit functionalities.
• Generated custom and parameterized reports using SSRS
• Created reports that call sub reports in SSRS
• Configuration and Deployment of all the Reports(RDL,RDS) across various SDLC environments
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs
• Responsible for creating datasets using T-SQL and Stored Procedures and also involved in Data visualization.
• Created several packages in SSIS.
• Custom components for SSIS packages were written in VB.net.
• Scheduled the packages to keep extracting the data from OLTP at specific time intervals
• Used various transformation tasks to create ETL packages for data conversion.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities
• Assisted in the design of star schema and snow flake schema
• Responsible for rebuilding the indexes and tables as part of performance tuning
• Used SQL Server Agent for scheduling jobs and alerts
• Active part in creating OLAP and ROLAP cubes and used MDX queries to retrieve data from the cubes.
• Performed Query optimization & Performance Tuning
• Optimized queries using SQL Profiler and Database engine tuning advisor

Environment: SQL Server 2005/2008 Enterprise Edition, SSIS 2005, SSRS 2005,.NET Framework, VB.net, ASP.NET, ADO.NET, WCF, Erwin, T-SQL, VisualStudio.NET IDE, Windows 2000/2003 Advance Server, XML, MS Excel, MS Access, Visual Studio 2005.

Confidential,Birmingham, AL Feb’08-Jan’09
SSIS Developer

Event Form is a system built for a premier healthcare, sales and marketing company. The system is used by the sales representatives for entering the expenses made towards each event. An event is defined as a visit by the sales representative to the doctor\'s office and an event can have multiple event types and expenses. The system validates the expenses according to certain business rules set by the pharmaceutical companies, as part of government compliance.

Responsibilities:

• Upgrade experience of SQL Server 2000 to 2005. Experience in applying Service Packs at database and OS Level.
• Helped in the Installation and configuration of MS SQL Server
• Responsible for developing Stored Procedures, Triggers, Views and User defined functions
• Efficient use of Joins and sub-queries in queries that involve data from multiple tables
• Fine tuning of stored procedures to improve the performance
• Performed Performance tuning on SQL queries, triggers and stored procedures
• Used Audit functions to keep track of the changes made to the database
• Responsible for design and Normalization of the database tables.
• Used Exception handling to catch and report the errors.
• Created custom and Ad hoc reports using SSRS
• Generated several drill down and drill through reports using SSRS
• Responsible for creating SSIS packages to extract data from different sources consolidate and merge into one single source.
• Used DTS packages to implement Extraction, Transformation and Load (ETL)
• Modified existing SSIS packages to meet current business needs
• Wrote stored procedures to be used in the SSIS packages
• Played Active part in the development of SQL Server Maintenance plan, scheduling of Jobs, Alerts and Troubleshooting
• Had to modify the current stored procedures to meet the current design
• Responsible for creating indexed views, and appropriate indexes to cut the complex query time.
• Involved in system testing
• Active part in maintenance of data cubes for OLAP.
• Monitored performance and optimize SQL queries for maximum efficiency
• Identified and defined the Datasets for report generation
• Wrote T- SQL queries, MDX queries for data retrieval.
• Took part in the normalization and de-normalization of database.
• Implemented the AGILE Method of Development.

Environment: MS SQL Server 2000/2005, SSRS, SSIS, SSAS, Business Intelligence Development studio, Visual source safe, Visual studio 2005, Erwin, VB.net, MS Excel, MS Access
Confidential,Chicago May’06 –Jan’08
SQL Developer
Headquartered in Chicago, Aon Corporation is the leading provider of risk management services, insurance and reinsurance brokerage and human capital and management consulting.
Responsibilities:

• Created Stored procedures, Triggers and functions.
• Resolved deadlock issues of the application using SQL Profiler.
• Worked with developers to tune the queries, run scripts and move the database production to development servers.
• Configured and maintained Snapshot and Transactional replication for 3 environments.
• Troubleshooting replication errors and handling logs.
• Created logical and physical data modeling for development database using ERWIN tool.
• Created SSIS packages for transforming data.
• Created schema objects, rules and granted roles to the users.
• Worked and coordinated with developers in writing and tuning new stored procedures.
• Worked on DTS packages to import the data from Oracle, Access and text files.
• Responsible for stored procedures optimization, performance tuning and index tuning.
• Configured RAID (Redundant Array of Independent Disks) levels.
• Automated processes using SQL Server Jobs.
• Set up backups for the newly created databases.
• Scheduled transfer of backups and log files to different servers.
• Provided a support for data issues and given appropriate solutions.
• Provided training to development team on performance tuning and SQL best practices for enhancing application output.
• Created tabular and matrix Reports using SSRS.
• Created the documentation for SQL server and service packs installations.

Environment: MS SQL Server2005, MS Access, Oracle, Windows 2000/2003, VB.NET, ERWIN, XML, SQL Profiler, SSIS, SSRS UNIX.

Confidential,MO Jan’05 – April’06
SQL Developer
Monsanto is an agricultural company. They apply innovation and technology to help farmers around the world produce more while conserving more. They help farmers grow yield sustainably so they can be successful, produce healthier foods, better animal feeds and more fiber, while also reducing agriculture\'s impact on our environment.

Responsibilities:

• Set up new SQL Servers 2000 and configuring the required users.
• Restored and copied Production Database.
• Responsible for MS SQL Server Installation and configuration as well as applying service packs and hot fixes.
• Provided User Access at all levels for both the network and the SQL Server databases; configured and audited SQL Server security; managed SQL Server logins and user accounts/passwords; managed database object permissions.
• Involved in creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers, Rules and Defaults.
• Worked on DTS packages, DTS Import/ Export for transferring data from heterogeneous databases.
• Created regular backups of databases and transaction logs.
• Implemented Log Shipping to move the database to another server at regular intervals.
• Responsible for 2-node Clustering.
• Responsible for capacity planning, monitoring Disk I/O, CPU and memory
• Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing.
• Extracted query plans and made sure each and every query is using appropriate indexes.
• Created Logical & Physical Database modeling for in house development application.
• Involved in disaster recovery procedures.

Environment: MS SQL Server 2000, Sybase, Windows 2000, Windows XP Professional.

Confidential,Atlanta GA Aug’03 - Dec’04
Production Server DBA
FSL Group is one of the world’s largest transaction processors and offers worldwide, world-class electronic transaction processing services through our high speed, robust electronic information networks. These networks process billions of business and consumer payment card and money transfer transactions annually for customers in the United States, Canada, Europe and Latin America.

Responsibilities:

• Created and managed schema objects such as Tables, Views, Clustered and Non-Clustered Indexes and referential integrity depending on user requirements and converting them into technical specifications.
• Responsible for MS SQL Server 2000 configuration, tuning and provide 24 X 7 dedicated support to all Production, development and clustered servers.
• Performed all aspects of database administration, including data modeling, backups and recovery.
• Configured Transactional replication between Primary Server and three ReadOnly servers, with separate Distributor server and experience in troubleshooting replication problems.
• Configured the Log shipping and created the Standby server.
• Created the logical and physical data modeling using Erwin tool.
• Maintained Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules.
• Monitored connections, locks and performance of SQL server.
• Assigned permission to users, roles and object, Supported column level permission. Administered server’s logins (Windows and SQL Accounts).
• Created and granted permissions on various Objects.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes.

Environment: MS SQL-Server 2000, DTS, Erwin, Windows 2003 Server, MS Access, ASP, Diagnostic Manager.

Confidential,India Jan’02 - July’03
Position: .Net and SQL Developer
Project: Issue Tracker
Description: Issue-Tracker allows authenticated users to view, modify, and add projects and tasks that are shared with other users. It may be used in any number of scenarios, from bug tracking to managing work orders or customer service requests. Its primary purpose is to provide quality, sample source code to developers interested in building smart client applications and XML Web services using the .NET Framework.

Responsibilities:

• Involved in gathering of all the requirements for the project. Implemented the SDLC concept.
• Used Rational Rose for UML diagrams and ER diagrams.
• Developed a web application using C#.net and ASP.net.
• Created user controls for login pages and also used validation controls.
• Provided authorization to control user access to application features.
• ADO.net data accessing using stored procedures.
• Created tables and wrote stored procedures using SQL Server 2000.
• Developed web services and consumed them in the project.
• Created Reports and designed graphical representation of analyzed data.
• Designed screen shots for the frontend users and also handled the backend.
• Involved in checking of coding standards and code review for application code.

Environment: C#.net, ASP.net, SQL Server 2000, Rational Rose, Crystal Reports, Web Services, ADO.net.