Professional Summary:

• 7 years of experience in Database design and development using MS SQL Server 2000 and SQL Server 2005/2008.
• Excellent in MS SQL Server 2005 suite of products like SSMS, SSIS, SSAS and SSRS.
• Experience in all phases of SDLC of a Project development life cycle through Requirements definition, Analysis, Functional & Technical design, Testing, Production Support and Implementation.
• In depth experience of T-SQL, Designing and Normalization techniques on the database tables.
• Expert in implementing business logic and procedure in backend using complex Stored Procedures, Effective Functions, Views and Indexed Views.
• Experience in creating User Defined Functions and Triggers in observing business rules.
• Experience in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server Performance.
• Experience in Performance Tuning and Query Optimization.
• Good at implementing Log Shipping and Database Mirroring.
• Experience in MS SQL Server Configuration, Performance Tuning, Client-Server Connectivity, Query Optimization, Database Maintenance Plans and Database Consistency Check using DBCC commands.
• Involved in Index Clustering (Active/Passive).
• Experience in supporting multiple Production database servers including backup and recovery, Performance Tuning and enterprise replication techniques
• Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX.
• Experience in Implementation of Microsoft Business Intelligence (BI) platforms including Performance Point Server 2007 (PPS), Analysis Services (SSAS), Integration Services (SSIS), Reporting Services (SSRS) and Microsoft Office SharePoint Server (MOSS) in SQL Server 2005
• Migrating/Upgrading from SQL Server 2000 to SQL Server 2005.
• Expertise in Extraction, Transformation and Loading (ETL) processes using DTS Import/Export, DTS Packages, SQL Server 2000 and SSIS, SQL Server 2005, Bulk Insert and Utilities like BCP.
• Expertise in creating packages using SSIS for integration services.
• Worked with data extraction using SSIS.
• Used SSIS to create packages to transfer SQL Server logins, Backup databases/tables, Rebuild indexes, Database integrity checks, also scheduled these packages to perform other SQL jobs.
• Experience in creating jobs, alerts, SQL Mail Agent and scheduled DTS Packages.
• Expert in creating simple and parameterized reports using SSRS 2005 and also complex reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
• Created many Drill through and Drill Down reports using SSRS.
• Experience in writing expressions in SSRS and Expert in fine tuning the reports.
• Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX.
• Expert in Expert in creating SSAS cubes and creating dashboards in PPS (Performance Point Server) using Business Modeler.
• Good experience in Dimensional Modeling, creating OLAP and building Cubes and Reports from them.
• Proficient in building Cubes and creating hierarchies with SSAS.
• Expert in calculating measures and dimension members using multi dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Experience in interacting with end users and gathering business requirements.
• Effective interpersonal, conflict resolution skills. Team oriented, technically motivated and creative.

Education: Bachelor’s in Electrical and Electronics Engineering
Technical Skills:

• Operating System : Windows NT/98/2000/XP/2003 server
• Languages : C, C++, Visual Basic 6.0. VB.Net, T-SQL, PL/SQL,

Visual studio 2003/2005

• Tools : DTS, SSIS, SSRS, SSAS
• Database : MS Access, MS SQL Server 7.0/2000/2005/2008, Oracle8i/9i, SQL

Plus, SQL, PL/SQL

• Tools/Utility : Enterprise Manager, SQL Server Management Studio (SSMS),

Database Tuning Advisor, DTS, Analysis Manager, BCP, SQL Profiler

• Software : MS Office, Visio, Adobe Photoshop, MS Excel, MS-Project 2000
• Reporting Services : Excel, SQL Server Reporting Services 2005

Professional Experience:

Confidential,Dublin, OH OCT 08-Current SQL DEVELOPER/SSIS/SSRS/SSAS

Confidential, is a leader in door-to-door transportation services. Through the combination of experience, expertise and market presence, Pacer has established the most reliable and comprehensive intermodal network. The main scope of the project is to load data from various operational systems (Progress DB, DB2, and Oracle) into MS SQL SERVER 2008.
Roles and Responsibilities:

• Actively involved as part of a team for gathering and analyzing the needs of End User Requirements and System Specifications.
• Involved in requirements gathering, analysis, design, development, change management, deployment and user training.
• Database planning in relation to physical and logical data architecture.
• Migrated Database from SQL Server 2000 to 2005 by using side by side migration.
• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Responsible for creating Databases, Tables, Indexes, Unique/Check Constraints, Views, Stored Procedures, User defined functions, Triggers, Rules and Defaults.
• Performed DBA tasks like Backup, Restoration of tables and Stored Procedures and Refreshing Database on weekly basis.
• Gathered required information and prepared documentations according to them.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2005 using SSIS and Bulk Insert.
• Used various transformation components in the data flow task (SSIS) to implement business logic.
• Created Stored Procedures which send mails in HTML format using Sp_send_dbmail.
• Created mail notifications to notify success and error notifications using Sp_send_dbmail.
• Used check points in SSIS for huge data loads.
• Used XML and environment variables in the package configuration for Deploying SSIS packages.
• Used SSIS to unite data from existing system and performed transformations on MS SQL 2005.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Installing and Configuring SQL Server 2008/2005, Integration Services (SSIS) and Reporting services (SSRS) for QA and DEV environments.
• Used Business Intelligence Development Studio to build reports using the wizards and designers, and deploy them to Report Server.
• Schedule tasks, eliminate blocking & deadlocks, monitor SQL error logs, database activity, user accounts and connections/locks etc. Scheduling jobs and alerting using the SQL Server Agent.
• Generated complex custom Reports using SSRS as per the customer requirement.
• Created datasets in T-SQL, stored procedures for SSRS.
• Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
• Responsible for maintaining cubes using SSAS and populate the cubes with the data.
• Scheduled the reports to refresh and run on weekly, daily and monthly basis in report manager and SharePoint.
• Deployed and uploaded SSRS reports to SharePoint server for end users to look at them.
• Converted Excel reports into SSRS reports and also into other required formats.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports.
• Identified and Defined Key Performance Indicators and created aggregations in SSAS 2005/2008.
• Identified and defined Fact relationships in SSAS.

Environment: SQL Server 2005/2008, SSIS, SSRS, SSAS,TSQL,ADO.Net, Erwin, .Net Framework 3.0/3.5, Windows 2000/2003 Advance Server, UNIX, Excel, Access.

Confidential,Los Angeles, CA JAN 07 – SEP 08 SQL DEVELOPER/SSIS/SSRS/SSAS

Confidential,provides a comprehensive platform for mortgage institutions to efficiently manage their Default process and Sell REO (Real Estate Owned) properties.Project dealt with creating SSRS reports on summary tables and cubes.

Roles and Responsibilities:

• Involved in requirements gathering, analysis, design, development, change management, deployment and user training
• Defined requirements and comprehended the complex business rules required for writing the code.
• Used Erwin tool for the database modeling/designing.
• Involved in analysis, design, development, and enhancement of the data warehousing application.
• Used ADO VBA programming in Access.
• Converted macros of Access to SQL stored procedures and involved in moving the Access database to SQL Server databases.
• Involved in all activities related to the development, implementation, administration and support of ETL processes for the Data Warehouse using, DTS and SSIS.
• Worked on DTS and BCP to transfer data from legacy server to SQL server, to load flat file to SQL Server.
• Created packages in SSIS, for data conversion using various transformation tasks
• Transformed data from various data sources using OLE DB connection; also scheduled automated tasks.
• Used DBCC commands to check physical and logical consistency of the databases and rebuild indexes.
• Creation of New NT Logins and granting privileges to users/groups and objects.
• Monitor NT Event log for system, application errors, available disk space, backup registry, keep emergency repair disk as current.
• Good knowledge on .net framework.
• Used NT Performance monitor to monitor CPU & Memory usage.
• Used SQL Server Profiler to monitor and record database activities of particular users and applications and to monitor Memory, Processor, Disk I/O and SQL Queries.
• Schedule tasks, eliminate blocking & deadlocks, monitor SQL error logs, database activity, user accounts and connections/locks etc. Scheduling jobs and alerting using the SQL Server Agent.
• Created reports that call Sub reports in SSRS. Created Custom reports, datasets for reports using TSQL.
• Used ADO.NET connectivity controls such as dataset, data view, data table, etc to create reporting pages and grid view control for displaying data.
• Worked on the CLR feature, for the .Net framework with SQL Server 2005.
• Involved in writing scripts for SSIS packages
• Developed Web forms, User controls and Custom controls for the web application in ASP.NET, C#Vb.net.
• Generated multiple reports (SSRS) in drill mode using tables, cross tabs and charts.
• Designed reports using SSRS and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports
• Created partitions for large measure groups in SSAS.
• Designed and Imported KPI’s into PPS score cards.
• Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures
• Created interactive reports with SSRS using report parameters, query parameters, filters and expressions.
• Performed Sorting, formatting, and Grouping to custom reports in (SSRS).
• Deployed and uploaded SSRS reports to SharePoint server for end users to look at them

Environment: SQL Server 2000/2005, SSIS, SSRS, SSAS,TSQL, DTS, C#.Net, VB.Net, ASP.Net, VBA , ADO.Net, Erwin, .Net Framework 3.0/3.5, Oracle 10g, Windows 2000/2003 Advance Server, UNIX, TOAD , Excel, Access.

Confidential,Alpharetta, GA SEP 06 – NOV 07

Confidential,provides specialty insurance and treaty reinsurance on a worldwide basis through operating subsidiaries and branch networks. Project was to build and maintain an ETL to load Location specific data to a repository. SAP uses this repository for further processing of data. The main objective of maintaining this data in MDM is to provide uniform consolidated data to SAP. Also, several reports and dashboards are created on MDM that gives valuable information to business.

Roles and Responsibilities:

• Used SSIS to unite data from existing system and performed transformations on MS SQL 2005.
• Used various transformation components in the data flow task to implement business logic.
• Configured SSIS packages using Package configuration wizard to allow package run on different environments.
• Conversion of DTS packages SQL Server 2000 into SSIS packages SQL Server 2005.
• Created complex variables, multiple breaks, sorts in the reports.
• Created Tabular and Matrix reports using SSRS.
• Developed multiple reports using reporting services.
• Creating functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data.
• Created packages and scheduled it to get data from OLTP.
• Created ETL package for data conversion using various transformations tasks.
• Created various scheduled jobs to handle the data migration from SQL 2000 to 2005 periodically.
• Created Stepped and Block reports using SSRS.
• Experience in building star schema and snowflake schema depending on the business data requirement.
• Monitor NT Event log for system, application errors, available disk space, Backup registry, keep emergency repair disk as current
• Rebuilding Indexes and Tables as part of performance tuning exercise
• Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks /user counts and connections/locks etc.
• Scheduling Jobs and Alerting using SQL Server Agent
• Created datasets for reports using T-SQL and stored procedures
• Created Cubes from which data can be retrieved rapidly by enterprise information consumers.
• Responsible for maintaining cubes using SSAS and populate the cubes with the data.
• Created different Data Layouts for the Business users depending on the requirement and providing them different Drill Down capabilities using ProClarity.
• Responsible for Query optimization and Performance tuning.
• Used NT Performance monitor to monitor CPU & Memory usage and SQL Server Profiler to monitor and record database activities of particular users, applications.
• Performing query plans and making sure each and every query is using appropriate useful indexes.
• Used SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries.
• Created logins, roles, and groups to the Window NT and MS SQL Server and maintaining proper security procedures.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Constructed Cubes based on data volumes mostly adhering to Star Schema.

Environment: SQL Server 2000/2005 Enterprise Edition, SSIS 2005, SSRS 2005,SSAS, .NET Framework, C#, ASP.NET, ADO.NET, Erwin, XML, T-SQL, SQL Server 2000, SQL Server 2005, VisualStudio.NET IDE, Windows 2000/2003 Advance Server, ASP, XML, T-SQL, MS Excel, MS Access, Visual Studio 05.

Confidential,San Diego, CA Oct 04 – Aug 06

Weather Tracker is a web application which is used by Qualcomm Employees, Technician\'s, Super Users. Application shows the Alarms generated from different Equipments like Batteries, Rectifiers and Generators which are affected by severe weather conditions. Alarms are collected from different Locations in USA called (CLLI Common Location Language Identifier). All these Data related to Alarms from different System\'s are consolidated into a Single Database (SQL Server) by running JOB’s. Qualcomm Employees use this Application to assign a technician to clear Alarms. Super User\'s use this application enter new equipments. Various different Reports are generated using SSRS (SQL Server Reporting Services) which are used by super users to analyze the number of Alarms raised and when they are cleared.

Roles and Responsibilities:

• Supported business functions through use of internally-developed and third party software solutions.
• Defined and developed a data migration strategy between different products and platforms.
• Created /Developed/maintained the stored procedures, triggers to interpret complex business rules, history data and audit analysis.
• Worked on optimization and tuning of SQL queries and indexes.
• Assisted in the application development, debugging, configuration and optimization from database perspective.
• Performed database design by analyzing business requirements.
• Assisted in troubleshooting and resolution of database issues.
• Data migration (import & export –BCP) from Text to SQL server.
• Designed database/tables and the requisite relationships, designed partition tables and partition views.
• Scheduled many Jobs using SQL Server Agent.
• Worked as a developer in creating complex stored Procedures, SSIS packages, triggers, cursors, tables and views and other SQL joins and statements for applications.
• Experience in Extraction Transformations and Loading (ETL) tools like SSIS.
• Created SSIS package to get data from different sources, consolidate and merge into one single source.
• Created datasets for reports using T-SQL and stored procedures.
• Created alerts and generate auto e-mails.
• Created various Weekly and Monthly reports showing detailed information.
• Created Jobs Performance report that queries sys tables and shows how long each job ran and weekly-average duration using SSRS.
• Used Business Intelligence Development Studio to build reports using the wizards and designers, and deploy them to Report Server.
• Performed Sorting, formatting, and Grouping to custom reports in SSRS.
• Developed Query for generating drill down reports in SSRS 2005.

Environment: MS SQL 2000/2005,SSIS,SSRS, Windows 2000 Advance Server, ASP, VB .Net, XML, T-SQL, MS Excel, SharePoint Portal Server 2003/2007, Windows SharePoint Services , MS Access, Visual Studio 05, Oracle 9i/10g.

Confidential,Hyderabad, India Aug 02 – July 04

Confidential,a wholly owned subsidiary of Standard Chartered Bank, UK, is
an integral part of the Bank’s strategy to consolidate and rationalize operations into Shared Services Centers. This is an ambitious project that the Bank undertook to prevent money laundering and today Scope International services over 80 million transactions a year. Reports are generated every day (both scheduled and intraday). Previous day transactions are sent to the Analyst team in required format to check against the earlier day’s transactions.

Roles and Responsibilities:

• Actively involved as part of a team for gathering and analyzing the needs of end User Requirements
• Used TSQL to create various queries
• Created new tables, wrote stored procedures and some user defined functions for Application Developers
• Performed data conversions from flat files into a normalized database structure.
• Created Triggers, Check Constraint and Primary/Foreign Key to enforce data and referential integrity.
• Managing of users including creation/alteration, grant of system/db roles and permission on various database objects.
• Extensively used joins and sub queries to simplify complex queries involving multiple tables.
• Planned the Complete Backing up of Database and Restoring the Database from Disaster Recovery.
• Worked on DTS Packages, DTS Import/Export for transferring data between SQL Server.
• Managed historical data from various heterogeneous data sources like Excel, Fixed Width Flat Files.
• Performed tuning of SQL queries and stored procedures using SQL Profiler
• Involved in generating summary reports using Crystal reports.

Environment: Microsoft SQL Server 2000, Windows XP, VB Script, DTS, Crystal Reports, Visual Studio 2002.