Professional Summary:

• 7+ years of IT Experience as MS SQL Server Database Developer in Database Design, Testing and business intelligence of Microsoft SQL Server 2000/2005/2008(R2) in Development and Production Environments with various business domains like Financial, Healthcare, Retail and Insurance services.
• Strong experience in MS SQL Server 2008(R2) with Business Intelligence in SQL Server Integration Services (SSIS), SQL Server Reporting Services(SSRS).
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2008(R2)/2005/2000.
• Experienced in creating and using Stored Procedures, Views, User Defined Functions, Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.
• Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization/ De normalization Techniques on database Tables.
• Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating Effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Very good T-SQL Programming skills. Used SQL Profiler, Execution Plan, and Performance Monitor to monitor the SQL server for deadlocks, long running queries and tune the same to improve performance.
• Experience in creating and managing fragmentation of Indexes to achieve better query performance. Experience in Performance Tuning and Query Optimization.
• Good understanding of (SDLC) software development life cycle process methodologies and principles.
• Experience with logical and physical data modeling, FACT and Dimensional tables and database design using Data Modeling Tools like Erwin.
• Expert in data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS), creating Dynamic packages for Incremental Loads.
• Thorough Knowledge of Various SSIS Objects such as Dataflow Components, Control Flow Elements, Connections Managers, Runtime Events, Log Providers etc.
• Experienced in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
• Experience in enhancing and deploying the SSIS Packages from development server to production server by using package configurations.
• Excellent Report creation skills in developing reports like Tabular Reports, Matrix Report, Charts, Custom Reports, using Report Designer as well asReport Builder in SQL Server Reporting Services (SSRS) in Business Intelligent Development Studio (BIDS).
• Experience in creating snapshots of reports to reduce the load on the server. Managed subscriptions to provide timely reports to the clients and end users and also worked on integration of SharePoint with SSRS.
• Developed Drill Down, Cascading, and Drill through, Sub reports and conditional formatting, grouping, Charts using Global variables, Parameters Expressions and Functions for the Business Users.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Excellent analytical, Interpersonal and Communication skills, fast learner, hardworking and good team player.

Technical Skills:

Database: MS SQL SERVER 2008(R2) / 2005 / 2000, MS Access 97/2000/2003.
Operating Systems: UNIX, Windows XP/2000/2003.
Programming Languages: Transact SQL, C and VB, .NET
Web Technologies: HTML, XML.
Productivity Applications: MS Word, MS Excel, MS Access, MS FrontPage.
DB Tools: SQL Server Management Studio, SQL BIDS, SQL Enterprise Manager, Query Analyzer and SQL Profiler.
ETL Tools: DTS, SSIS.
Reporting Tools: MS Access, MS SQL Reporting services (SSRS). Microsoft Excel.
Data Modeling Tool: ERWIN, Visio.

Professional Experience:

Confidential Nov '10 - till date
ATLANTA, GA
SQL Server SSIS/SSRS Developer
Description: TSI Logistics is a Third Party Logistics Company offering global transportation and logistics services. We are industry leaders in the volume of information captured from each customer transaction, thus increasing supply chain visibility to our customers, and bringing verifiable value to their bottom line.

Responsibilities:

• Understanding Customer requirement via interaction and writing functional specifications.
• Involved in the System study and Database Design using MS SQL Server 2005/2008.
• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc on various database objects to obtain the required results.
• SQL Server Index Maintenance Performance Tuning for Large Tables.
• Microsoft SQL Server management and performance tuning. Focuses on index tuning, query modifications, partitioning and hardware optimization.
• Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability.
• Designed and populated reporting tables, views and stored procedures.
• Transferred data from various data sources/business systems including Oracle, DB2, Teradata, Flat Files etc. to SQL Server using SSIS using various features like data conversion etc. Created derived columns from the present columns for the given requirements.
• Participating in defining ETL strategies, preparing transformation rules and mappingdatafrom source to target.
• The effective use of Team Foundation Server and Visual Studio Team System including project planning, defect tracking, source control repository organization, and code metric tracking.
• Created SSIS packages and scheduled them as jobs to run automatically to Process the cube, load data etc.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Developed, monitored and deployed SSIS packages.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Implemented and enhanced existing reports like Group By, Drilldown, Drill Through , Sub-reports, List, Tabular , matrix , navigation reports, standard parameter and cascading Parameter ,Multivalve Parameters.
• Created numerous Dashboard Reports (Metrics) for different business modules.
• Experience inDataWarehousedataand dimensional modeling, Business Intelligence and ETL design and development.
• Designing and developing SSRS reports using SQL for retrieving data.
• Integrated SSRS Reports in Share point server and Developer Custom workflows with C#( Filter Tool bar)
• Experience with SharePoint workflows, Microsoft InfoPath form development, ASP.Net, and SQL Server Reporting Services reports.
• Deployed and Published the Created Reports to Microsoft Share Point Server and also uploaded them to Microsoft Performance Point Server.
• Implemented security to restrict the access to users and to allow them to use only certain reports.

Environment:
SQL Server 2005, SQL Server 2008(R2), MS Excel 2003-2007, SQL Profiler, ETL, T-SQL, MS SQL Server Reporting Services, MS SQL Server Integration Services.

Confidential
Hartford, CT Sep'08 - Oct'10
SQL Server SSIS/SSRS Developer

Description: Confidential is a health care company which provides different health insurance solutions from health management, monitoring to diagnosis. It also provides many health care products which treat infections, disorders and provide remedy for chronic and solutions to clinical care. Work revolved around the department which acts as liaison between the government and the health care receivers. Worked in the department to help maintain and provide effective solutions to manage the data.

Responsibilities:

• Developed various T-SQL stored procedures triggers, views, and adding/changing tables for data load and transformation, and data extraction.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, and UDFs.
• Created Indexes for fast retrieval of the data. Involved in Performance tuning and Query Optimization.
• Created new database/tables to put in the extracted data and rebuild the relationship.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2008 from different environments for the SSAS cubes.
• Created the SSIS /DTS packages and scheduled them.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Utilized event handling effectively to generate audits and logs for the generated packages.
• Performed archiving and achieved automated processing of the raw data through the ETL process in SSIS.
• Created reports as per user requirement using SQL Server reporting services (SSRS) which delivers enterprise and Web-enabled reports.
• Developed Stepped and Block reports using SSRS. Designed and implemented Parameterizedand cascading parameterized reports using SSRS.
• Developed custom reports using SQL Server Reporting Services (SSRS) to review score cards, business trends based on the data from different locations.
• Performed Identification, analysis and resolved report defects within time scope and established development guidelines.
• Created Snapshot Replication for the Development and Testing Databases across different Servers.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and developer database code as well as T-SQL code from developers and QA.

Environment:
SQL Server 2005, SQL Server 2008, MS Excel 2003-2007, SQL Profiler, ETL, T-SQL, MS SQL Server Reporting Services, MS SQL Server Integration Services, MS SQL Server Analysis Services.

Confidential Jun'06 - Aug'08
Chicago, IL.
SQL Server SSIS/SSRS Developer

Description: Confidential, a wholly-owned subsidiary of Coinstar, Inc. offers new-release DVD, Blu-ray Disc and video game rentals through its network of conveniently located, self-service kiosks. Redbox has rented more than 1.5 billion discs and is available at approximately 34,400 kiosks across over 28,000 locations nationwide, including select leading grocery, drug and convenience stores, select Walmart locations and Walgreens locations across the United States.

Responsibilities:

• Participated in gathering User Requirements and System Specifications.
• Developed Stored Procedures, functions and database triggers and maintained referential integrity and implemented complex business logic.
• Involved in installation and configuration of SQL Server 2000 and SQL Server 2005 with latest Service Packs.
• Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.
• Created and when required, modified already existing stored procedures, triggers, views, indexes.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Tested queries to optimize the procedures and triggers to be used in production.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
• Created the SSIS /DTS packages and scheduled them.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Created SSIS Packages and used OLEDB Source as an existing Oracle Database.
• Involved in Performance tuning and Query Optimization.
• Designed and implemented Parameterizedand cascading parameterized reports using SSRS.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non production database code as well as T-SQL code from developers and QA.
• Created simple Reports using SSRS.
• Experience in creating snapshots of static reports and configure subscription.
• Created and managed the databases in development environment.

Environment:

Windows 2000/2003 Advanced Server, Windows XP, MS SQL Server 2005/2000, SQL Server Management Studio (SSMS), Query Analyzer, Enterprise Manager, T-SQL, SQL Server Integration Services (SSIS), Microsoft Excel, SQL Server Agent.

Confidential, Wisconsin Apr '05- May'06
SQL Server Developer

Description: Confidential is a Health Service focus on specific strategy and guiding principles in all of our work for the people in Wisconsin. The Department supports policies vital to a fair and vibrant marketplace that delivers affordable, high-quality healthcare to our citizens and leverages our state\'s tradition of strong health outcomes, innovation and world-class provision of healthcare.
Responsibilities:

• Creation, manipulation and supporting the SQL Server databases.
• Involved in the Data modeling, Physical and Logical Design of Database
• Created and when required, modified already existing stored procedures, cursors, triggers, views, indexes.
• Stored procedures and triggers were used to implement business rules.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Helped in integration of the front end with the SQL Server backend.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Import & Export of data from one server to other servers using tools like Data Transformation Services (DTS)
• Write T-SQL statements for retrieval of data and involved in performance tuning of TSQL queries
• Created documentation as required.

Environment: MS SQL Server 2000, T-SQL, DTS

EDUCATION:
Bachelor of sciences
Post Graduate Diploma in Computer Applications