SUMMARY

• Over 7 years of Professional IT experience in Data Design and Development as MS SQL Server 7.0/2000/2005/2008 database developer/administrator involving in design, creation, maintenance and implementation of project requirements for Data Modeling and Data Management.
• Experience in Implementation of Microsoft Business Intelligence (BI) platforms including SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)
• Strong technical knowledge in MS SQL Server development including DTS, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Expert level skills in Objects creation such as Tables and Views, Table Normalization, User created Data Types, user functions, views, user profiles, data dictionaries, data integrity, Performance tuning, Indexes and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Developed Data warehouses using SQL Server 2005 database.
• Expertise in creating Reports using SSRS 2005 and crystal reports.
• Expert in Ad - hoc reports, drill down and drill through reports, cross tab reports and parameterized reports using SSRS 2005 and Expertise in designing stylish report layout.
• ETL expertise in using tools like DTS/SSIS, Bulk Insert, BCP and creating DTS and SSIS Packages.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
• Data migration using DTS services across different databases like Oracle, MS access and flat Files
• Proficient in Performance Tuning, Index Optimization, Query Optimization, Troubleshooting, Client/Server Connectivity, stored procedures and in checking Database Consistency using DBCC Utilities.
• Monitored and configuration of MS SQL Server and databases in clustered and un-clustered environments. And Tuned MS SQL Server databases with tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages and In-depth knowledge of Transact-SQL (DDL, DML, DCL), and in Design and Normalization of the database tables.
• Expertise in database activities like Data Modeling, Database Design, Development, Database creation and Maintenance, Performance Monitoring and Tuning, Troubleshooting, Normalization and Documentation.
• Proficient in DBMS and RDBMS concepts, strong understanding of ERD relationships and Database design and Implementations.
• Have knowledge on Data warehouse Architecture, Mainframes Environment.
• Good team player, strong analytical, verbal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS

Operating Systems: Windows 95/98/NT/XP/Vista, UNIX, Linux

Programming Languages: T-SQL, PL/SQL, MYSQL, C#.Net, VB.Net

RDBMS: SQL Server- 7.0/2000/2005/2008 , Access

SQL Server Tools: SSMS, Configuration Manager, Enterprise Manager, Query Analyzer, SQL Profiler, DTS, SSIS, SSRS, Database Tuning Advisor, Business Intelligence Development Studio.

BI Technologies: MS SQL SSIS, Data Transformation Services, MS SQL SSRS (2005 and 2008)

Web Technologies: HTML, DHTML, XML, CSS, Java Script, VBScript, AJAX, Web-Services

Web Server: IIS, Apache/Tomcat 4.1.24

Tools: Crystal Report, Microsoft-Office, Microsoft Visio, Cognos8.3, DataStage, Microsoft Visual Studio 2003/2005, Windows System Monitor, MOSS 2007Informatica, SCOM, Asset Management.

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

SSRS/SSIS BI Developer

Responsibilities:

• Created functional specification document and technical specification document.
• Involved in Data modeling to develop the database design using Erwin.
• Used the ETL tool for data modeling and Data mapping.
• Created and managed stored procedures, indexed views, user defined functions, triggers, joins database constraints to meet business requirements and policies.
• Extensively used T-SQL to manipulate and architect to produce results for users.
• Created and managed complex batch jobs and procedures which can exceed several hundreds of line of codes.
• Login and User Management: Adding logins, roles, groups to the Window NT and MS SQL Server and maintaining proper security procedures.
• Performed database tuning, monitoring, and Scalability Testing.
• Evolved in the creation and maintenance of index using database engine tuning advisor wizard, Query optimizer, and selected the best indexing plan to be deployed.
• Thorough analysis and testing of database objects such as stored procedures, views, T-SQL statements before deployment to the production server.
• Database Backup Compression and Encryption using SQL 2008.
• Created complex ETL Strategies to populate the data warehouse/data-mart facts and dimensions.
• Creating SSIS Packages from Different Heterogeneous Sources using Complex tasks like Scripting Task,
• Used Active-X Script tasks and Conditional split Tasks.
• Used multiple transformations including fuzzy lookups and fuzzy grouping in the data cleansing process.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups.
• 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).
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Used efficient task objects/connections/work flows in packages based on data volumes and data sources.
• Worked on migrating DTS packages to SSIS.
• Created drill down reports, ad-hoc reports and drill through reports using the ROLAP as a source.
• Creating Tabular, Matrix reports (also called as crosstab or pivot), Charts and graphs as per customer requirements Using SSRS.
• Assisted in the scheduling and the deployment of the reports and assisted in uploading files to a report server catalog from the report manger.
• Scheduled the reports to refresh and run on daily, weekly and monthly basis in the report manager and SharePoint.
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users to look at them.
• Created dimensions in the performance point server (PPS).
• Imported data into Performance point server (PPS) from SQL database through CSV files.
• Created dashboard to verify the data import and the rules execution at one go.
• Implemented Disaster Recovery plan using Log Shipping method.
• Resolved any deadlocks issues with the Databases/Servers on a real-time basis.
• Worked in huge replication environments. Set up the transactional replication between SQL server 2005 (publisher and distributer) and SQL Server 2000 (subscriber).
• Implementing and administering database replication between SQL Server databases as well as dissimilar databases, involved in System testing.
• Designed dynamic web pages using C# and Visual Studio tools.
• Developed applications with C#/SQL Server reporting services.

Environment: MS SQL Server 2005/2008, SSIS, SSRS, Windows 2003 server/ 2008, DTS, SQL Query Analyzer, SQL profiler, Crystal Reports, Enterprise Manager, C#, VB.Net, SQL Litespeed Backup, Visual Studio 2005, XML, SSMS, TFS, ERWIN Data Modeler.

Confidential, Montpelier, VT

SQL Server Developer/SSIS/SSRS

Responsibilities:

• Installed, Configured and Monitored SQL Server 2000/2005.
• Created and used Tables, Views, Indexes, Stored Procedure and Triggers
• Involved in Performance Tuning of Code using execution plan and SQL profiler. Added Indexes to improve performance on tables.
• Used multiple join statements to retrieve data from multiple tables
• Created Backend validations using Insert/Update and Delete triggers. Created views for generating reports
• Developed, monitored and deployed SSIS packages.
• Worked with transferring the data using SSIS (SQL Server Integration Services) packages.
• Extensively used SSIS Import/Export Wizard for performing the ETL operations
• Responsible for creating the reports based on the requirements using SSRS 2005
• Extensively worked in sorting the data, defining subtotals for the reports
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
• Identified and defined the Datasets for the report generation and wrote the queries for the drill down reports.
• Delivered the reports using ‘pulled’ and ‘pushed’ methodologies and formatted the reports using the Global variables and expressions.
• Deployed the generated reports on to the server and fine-tuned the database objects and server to ensure efficient data retrieval.
• Worked with ETL, Data Warehousing & OLAP Technologies.
• Extract, Transform and Load (ETL) source data into respective target tables to build the required data marts
• Creation of Clustered and Non-Clustered Indexes for Query Performance and Generated various reports using complex stored procedures
• Monitored ProClarity, performance turning and optimized SQL queries for maximum efficiency.
• Monitoring with SQL Profiler to capture and save data about the event to a file or table to analyze .
• Identified and added the report parameters and uploaded reports on to the report manager and organized them in folders.
• Creation of schema objects, granting roles and privileges to the users, compilation of procedures etc.
• Worked with Integration, Backup-Recovery and testing.
• Responsible for Database and Log Backups & Restoration, Backup Strategies and Scheduling Backups
• Worked in Configuring, Maintaining and Troubleshooting Replication

Environment: MS SQL Server 2005 Enterprise Edition, MS SQL Server Reporting Services 2005, Windows Server 2003, Query Analyzer, System Monitor/Performance Monitor, Event Viewer, SQL Profiler, Index Tuning Wizard, Database Maintenance Plan Wizard, Data Transformation Services (DTS), Windows XP, Crystal Reports, Shell script

Confidential, Dallas, TX

SSIS / SSRS

Responsibilities:

• Worked Extensively on SQL Server 2005 and 2008
• Involved in performing Extraction, Transformation and Loading using SSIS
• Developed all the required Stored Procedures, user defined Functions, Triggers, Views using T-SQL as per business logic.
• Used SQL Server 2005/2008 Reporting Services (SSRS) for generating reports.
• Worked extensively with client gathering requirements to generate customized SQL Reports (Subscriptions Created).
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon.
• Used “SQLProfiler TSQL Duration” template for tracking execution time of TSQL Statements.
• Development and Implementation of Backup and Recovery strategies.
• Database Backup Compression and Encryption using SQL 2008.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, Normalized Tables, established Joins and created Indexes whenever necessary.
• Used SharePoint Enterprise Portal for hosting Scorecards and SSRS Reports
• Promoted database objects from DEV/TEST to Production. Coordinated and Communicated production schedules within Development and Testing team.
• Worked extensively on all the Environments: Development, Testing and Production
• Worked with front-end application developers to understand their requirements and create Procedures and Reports.
• Automated Database Maintenance tasks by creating Jobs, Alerts and Operators through SQL Server Agent.

Environment: Microsoft SQL Server 2008, SQL Server Reporting Service, SQL Server Integration Service, Visual Studio, Windows XP, MS Office.

Confidential, Dallas, TX

SSIS / SSRS

Responsibilities:

• Responsible to meet the information demands of our business users by delivering timely, accurate, meaningful and standardized data and reporting.
• Excellent experience in developing complex Stored Procedures, Views and Indexed Views.
• Good experience in creating User Defined Functions (UDF’s) and Triggers in observing Business Rules.
• Responsible for the data and metadata management and Business Intelligence (BI) solutions using Microsoft SQL Server 2008 Integration Services (SSIS)
• Migrated DTS Packages to SSIS Packages and loaded the data from SQL Server 2000 to SQL Server 2005 as well as Sybase database.
• Deployed SSIS Packages in development server as well as in production server.
• Involved in ETL framework standards like error processing, reconciliation, validation.
• Experience of using Power Campus tool which is used to create reports and to load the database in to SQL.
• Worked with package configuration wizard to create configuration file, sql server table or environment variable to use in further packages.
• Created SQL jobs and scheduled them for nightly loads
• VB Script has been written for scripting the task in SSIS packages.
• Experience in designing Database Models for creating tables, indexes, optimizing views using MS Visio and Erwin
• Created several Complex Reports (sub reports, graphical, multiple groupings, drilldowns, parameter driven, formulas, summarized and conditional formatting) using SSRS.
• Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS)
• Used Query Analyzer, Profiler, Index Wizard and Performance Monitor for performance tuning.
• Setting and maintaining database logins, users, roles and permissions.
• Retrieve data from cubes using SSIS.
• Consolidated data from OLTP databases in to OLAP using SSIS as ETL.
• Designed and developed Data source views, Hierarchies and then Dimension and Fact Tables.
• Worked with technology features in SQL Server such as Partitioning, File Groups, Replication, Materialized Views, and Options available in executing database statistics.
• Actively involved in Normalization & De-normalization of database.
• Tuned the performance by making use of clustered and non-clustered indexes.
• Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks /user counts and connections/locks etc.

Environment: Microsoft SQL Server, SSIS 2008, SSRS 2008 Visual Studio, Microsoft Office Performance Point Server, Planning, Microsoft Office share point 2007, TARGIT, Windows 2003/XP/vista, .NET Framework, C#, VB.

Confidential, Chicago, IL

Database Developer

Responsibilities:

• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Migration of databases from MS SQL Server 7.0 to MS SQL Server 2000.
• Involved in Data modeling to develop the database design using Erwin 4.0
• Installation and configuration of MS SQL Server on Windows 2000/2003 Server.
• Involved in designing of Conceptual Logical Model and Physical Model.
• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
• Scheduling transfer of backups and log files to different servers.
• Creation of schema objects, rules and granting of roles to the users.
• Testing and implementing Database Backup Procedures, Restoration Procedures, Disaster Recovery procedures and Contingency plans.

Environment: SQL Server 2000/2005, Query Analyzer, SQL Profiler, DTS, HTML, T-SQL, Erwin 4.0, Windows Server 2000/2003, UNIX.