Professional Summary

• Having 7+ years of IT Experience in Database Design and Development of Microsoft SQL Server 2008/2005/2000 in Development, Test and Production Environments in various business domains like Financial, Pharmaceutical and Insurance
• Implemented complex business logic into database design and maintained the referential integrity via triggers and constraints.
• Expert in creating complex Stored Procedures, User Defined Functions, DDL/DML Triggers, Views, Cursors and Indexes to facilitate efficient data manipulation and data integrity.
• Experience in Creating and Updating Indexes to keep up the SQL Server Performance.
• Experience in writing complex T-SQL queries using joins.
• Experience in using Try Catch block introduced in SQL Server 2005.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using SQL Server Integration Services (SSIS).
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Expert in extracting and transforming data using DTS Import Export Data, DTS Packages, SSIS and experience in using BCP for Bulk copy operation and Bulk Insert.
• Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Worked with OLAP and Data warehouse application and worked with star schema and snowflakes schema dimensions.
• Created stored procedure for generating reports using SQL Server Reporting Services (SSRS).
• Expertise in designing complex reports like Drill-Down Reports, Drill-Through Reports, Parameterized Reports, Cascaded Reports and Sub Reports using SQL Server Reporting Services (SSRS) based on client requirement.
• Hands on experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture.
• Expert in deploying the SSRS reports on Report Server.
• Performed complex SQL and MDX Queries and generated reports.
• Experience in Designing and Building Dimensions and cubes with star schemausing SQL Server Analysis Services (SSAS).
• Experience in managing Alerts, Operators and Jobs through SQL Server Agent.
• Monitor the production server using tools like SQL Profiler, Performance Counters and SQL Server logs for Monitoring and Tuning SQL Server.
• Experience in MS SQL Server Configuration, Performance Tuning, Client-Server Connectivity, Query Optimization, Database Maintenance Plans and Database Consistency Check using DBCC commands.
• Experience in Creating and Updating Statistics to improve the SQL Server Performance.
• Experience in designing logical and physical data models using ERWIN and ER/Studio tools.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity.
• A Team-Player with motivation and ability to work independently, Worked closely with the Case Teams, Business Analysts and Data Analysts and Functional Design Teams.
• Good communication and written skills and can handle multiple projects simultaneously.

Educational Qualifications

Bachelor in Mechanical Engineering from Confidential University .

MICROSOFT CERTIFIED PROFESSIONAL 70-431 SQL Server 2005-Implementation and Maintenance.

Technical Skills

• RDBMS/DBMS: MS-SQL Server 2000/2005/2008, Oracle 8 /Oracle9i Enterprise, MS Access, Excel, ERWIN, TODD
• ETL Tools: DTS, SSIS , Data Junction, Informatica Power Center 7.1.1
• Database Utilities: MS DTS, MS Enterprise Manager, SQL Profiler, SQL Query Analyzer, Index Analyzer, DTS Backup Server, SQL Agents, SQL Alerts, SQL Jobs, Replication Tools
• Design Methodologies: UML, OOP. SDLC
• Data modeling : Erwin , MS Visio
• Programming Languages: Transact-SQL, VB 6.0, HTML, XML, VBScript, ASP.Net, VB.net
• Reporting Tools: SQL Server Reporting Services. Cognos Series 7, Business Object XI release 2
• Application Packages: MS Office 2010, MS VSS.
• Operating Systems: Windows - XP, Vista, windows server 2003,DOS, Unix, Novell LAN
• Internet Technologies: IIS, Ms-Front Page, TCP/IP, LAN, WAN
• Scripting : Unix shell scripting

Professional Experience

Confidential, San Diego,CA May 2011 – Present
Sr.SQL BI Developer [SSIS/SSRS]

ComplianceMAXTMis a technology platform composed of fully-integrated modules that brings convenience, confidence and cost savings to your compliance program. ComplianceMAX technology is relied on by over 200,000 users and is backed by the depth and breadth of NRS\'s compliance expertise.

Responsibilities:

• Created Database Objects – Schemas, Tables, Indexes, Views, User defined functions, Triggers, Stored Procedure, and Constraints.
• Implementation of MS SQL Server Management studio to create Complex Stored Procedures using T-SQL
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Designed dynamic SSIS to transfer data crossing different platforms, validate data during transferring, and archived data files for different RDBMS.
• Involved in designing the process flow for extracting the data across various source systems.
• DesignedSSIS Packagesto transfer data from various sources likeText Files, XML Files, Excel, Flat files to SQL Server 2008.
• Involved in building and maintainingSSIS Packagesto import and export the data from various data sources usingBIDSbased on the design data models.
• Have experience in doing excellent documentation on business requirements.
• Experience in working with various tools like OOD Visual Basic which is used for requirements gatherings in business.
• Designed and developed data load jobs using SSIS package and scheduled in SQL Agent.
• Created SSIS packages (.dtsx files) using SSIS to validate, extract, transform and load data to data warehouse databases and data mart databases.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Multicast and Derived Column.
• Created various complex reports Drill Down, Drill Through, parameterized reports, Matrix and chart reports according to user specifications.
• Created reports to retrieve data usingStored Proceduresthat accept parameters.
• Using SQL Server Reporting Services(SSRS)delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Created traces using SQL server profiler to find long running queries and modify those queries as a part ofPerformance Tuningoperations.
• Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, Recovery and Disaster Recovery procedures. Planned the complete Back-up of various Databases for Disaster recovery scenarios.
• GeneratedSub-Reports,Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also emailing them to director and analysts to be reviewed in Excel Sheet.

Environment:MS SQL SERVER 2000, MS SQL Server 2005, SSIS, SSRS, Business Intelligence Studio, SQL Profiler, Microsoft Visio, MS Office 2003,Excel 2003, .Net 2008/2005, Windows NT/2003.

Confidential, Minneapolis, MN June 2010 to Apr 2011 SQL Server Developer / Consultant 
Confidential is one of the leading diversified financial services companies in the U.S. Confidential Financial engages in business through its subsidiaries who provide a wide range of financial planning, products and services designed to be utilized as solutions for its clients’ cash and liquidity, asset accumulation, income, protection, and estate and wealth transfer needs, including wealth management, asset management, insurance, annuities and estate planning. The project was aimed toward facilitating user access to key services via the financial web portal.

Responsibilities:

• Created Complex Store Procedure for Medicare Reports using Recursive Queries using Common Table Expressions (CTE) ,derived table, Pivot Table.
• Involved in physical and logical data modeling using Erwin along with the architects.
• Created Stored Procedures, Triggers, Joins, Functions and Views in Data Warehouse.
• Back end Experience in MS SQL Server development, writing T-SQL stored procedures, views, triggers, cursors, UDFs for SSRS.
• Created and maintained databases, tables, users, logins, indexes, check constraints, and business rules using T-SQL.
• Created SSRS Reports for ReCredentiaing Reports For Analysis. Reports uses scheduling, formatting, Switches emailing Subreport.
• Developed & Deployed of various parameterized packages with SQL Integration Services 2005.
• Scheduling and monitoring the ETL packages. Job, Scheduling, batch, alert error-handling and E-mail notification setting.
• Perform optimization of SQL queries in SQL Server.
• Created Tables, Indexes, Views, Sequences, Constraints, Synonyms and Partitions (Range and List partitions).
• Documented the complete data warehouse environment, including all dimension and fact tables, the relationship between SSIS packages and the target tables, which packages were valid and in use, the relationship between the jobs and SSIS packages, and the relationship between the source tables and the OLAP tables used in the SSAS Cube.
• Create batch jobs to pull data from Database/user interface using T-SQL scripts/SSIS/DTS jobs to schedule them for periodic data backup for post-trade analysis.
• Design the ETL flow using SSIS and SQL Server 2005 and integrate it with existing system.
• Develop Exception handling process and audit process for each ETL package for each ETL package
• Developed different Scripts for the Data analysts for Verification of reports.
• Debugging reports and deploying reports.
• Involved in SSRS report deployment and report server configuration.
• Developed various types of reports like Drill down, Matrix, Cross tab, Ad- hoc, Parameterizedand Cascading parameterized reports using SSRS.
• Created Tabular reports, Cross Tab Reports and Sub Reports.
• Create Scheduling for Database Backup and SSIS,SSRS packages

Environment: SQL Server 2005, SQL Reporting Services SSRS, SSIS, T-SQL

Confidential, Iselin NJ Mar 2009 – May 2010
SQL Developer/SSIS/SSRS/SSASConfidential is one of the leading providers of auto, home and life insurance in the United States. Worked as a database consultant at Confidential for Human Resource Management System (HRMS), part of an ERP (Enterprise Resource Planning) group. 

Responsibilities:

• Created dynamic and customized packages to support future changes. Scheduled the same packages by creating the corresponding job tasks.
• Import/Export and successfully migrated the Databases such as Oracle, DB2, ERP (Navision) and MS Access to SQL Server 2005 using SSIS.
• Worked on the script components in SSIS using VB script for getting latest files and ETL logging areas.
• Created Configuration files with XML documents to support the SSIS packages in different environments.
• Created complex TSQL batches / stored procedures, Optimized existing queries and stored procedures.
• Defined check constraints, functions, indexes, synonyms and views.
• Experience in designing reports for the end user using SQL Server Reporting Services (SSRS) and creating multiple operational Drill-through and Drill-down, parameterized, cascaded, Matrix type reports and Charts using SSRS.
• Deployment and maintenance of various SSRS Reports in SQL Server 2005.
• ScheduledReports to run thereports hourly, daily, monthly accordingto client requirements for the periodic analysis.
• Involved in Analyzing, designing, building &, testing of OLAP cubes for GameStop Merchandising with SSAS 2005. Identified and defined fact and dimension relationships.
• Partitioned the cubes on daily, weekly and monthly based.
• Documented all the project work in support for maintenance.

Environment: Server 2000/2005 Enterprise, BIDS, MSMS, Microsoft Reporting Service (SSRS), SQL Server Integration Services (SSIS), SSAS, Enterprise Manager, Microsoft office share point portal server 2003 .NET, C#, ASP.NET, Red gate.

Confidential, Atlanta, GA Jan 2008 to Feb 2009
SQL Server SSRS/SSIS/SSAS Developer

Responsibilities:

• Determined the SQL Server Installation. Installed SQL Server Management tools using SQL Server Setup Program.
• Tested the Installation of SQL Server.
• Logical Data Modeling using ER-Win to fit business requirement.
• Implemented Triggers for checking complex business conditions, providing security for the tables.
• Used Data Modification Language (DML) to insert and update data, satisfying the referential integrity constraints and ACID properties.
• Physical Implementation of database into SQL Server 2000 using T-SQL.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity checks, Database Statistics update and Re-indexing.
• Created check constraints to maintain data integrity.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation.
• Worked on Import/Export for transferring data from heterogeneous database.
• Data migration (import & export/BCP) from Text to SQL Server.
• Migrated from SQL server 2000 to 2005. Installed SSIS and SSRS systems.
• Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.
• Involved and coordinated with users to gather new requirements and resolve existing issues.

Environment: SQL Server 2000/2005, SSMS, SSIS, SSRS, SSAS, HTML, CSS, Java Script, Team Foundation Server,IIS 7.0

Confidential Sep 2006 to Dec 2007 SQL Server Developer/SSRS Developer 
Windows Server 2003, MS Visio 2003,MS SQL Server 2005, SSRS 2005 , T-SQL, MS office 2007.

Responsibilities:

• Designed and developed ER diagrams (Physical and Logical using MS Visio) and mapping the data into database objects.
• Developed stored procedures, views and functions.
• Designed and developed different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports, Drill down reports.
• Created complex expressions, calculations, sorting, filtering to enhance data presentation in reports.
• Created insert, update and delete triggers on some tables in order to capture any DML activities happening on some crucial and confidential data.
• In order to perform Error Handling created each stored procedure with TRY and CATCH blocks.
• To get the best performance for SSRS reports and applied performance tuning on various SQL procedures and created proper indexes on tables.
• Created report snapshots to improve the performanceofSSRS.
• Created user defined functions to split the string for the multi valued parameters and pass to the main query.
• Involved in activities of Integration testing and deployment in various environments, like QA, staging and production.
• Involved in various activities of generating Insert and update scripts to load the data to and from production servers to dev servers.
• Designed and developer SSRS security architecture using Role based security model provided in SSRS 2005.

Environment: Windows Server 2003, MS Visio 2003,MS SQL Server 2005, SSRS 2005 , T-SQL, MS office 2007.

Confidential May 2005 – Aug 2006
SQL Server Developer/DBA

Responsibilities

• Created and developed the stored procedures, triggers to handle business rules, historical data and audit analysis.
• Conducted database management, performance measurement and tuning for new and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager.
• Conducted logical and physical database design including data modeling, maintenance, problem diagnosis and resolution.
• Created and administered multiple development, training and production databases.
• Developed and created data dictionary, stored procedures, advanced queries, triggers, views, indices, and functions for databases.
• Maintained databases, performed software installations and upgrades, monitored database performance, performed capacity planning and SQL Server clustering, managed database quality assurance including database consistency check.
• Responsible for creating standards and operating procedures to maintain all databases.
• Worked with development teams in the design of physical databases and in modification.

Environment:MS SQL Server 2000, T-SQL, SQL Server Enterprise Manager, SQL Profiler, Excel, Data Import, DBMS, C.