Professional Summary

• A Microsoft Certified Professional with around 7 + years of total IT experience in the Design, Modeling, Development, Implementation and Support of SQL Server 7.0/2000/2005/2008.
• Expert in analyzing, designing, developing, installing, configuring and deploying MS SQL Server suite of products with Business Intelligence in SQL Server Reporting Services 2005/2008, SQL Server Analysis Services of 2005/2008 and SQL Server Integration Services.
• Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors
• Experience in using recursive CTEs, CTE, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility.
• Expert in generating writing parameterized queries, drill through reports and formatted SQL server Reports in SSRS 2005/ 2008/2008 R2 using data from ETL Loads, SSAS Cubes and various heterogeneous data sources
• Experienced in installing and configuring Reporting services and assigning permissions to different levels of users in SSRS.
• Defining data warehouse (star and snow flake schema), fact table, cubes, dimensions, measures using SQL Server Analysis Services.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS) (2005/2008).
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging
• Strong Experience in creating Ad Hoc, parameterized reports, Linked reports, Snapshots, Drilldown and Drill through reports using SQL SSRS 2005/2008 and even involved in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Worked with report manager for deploying the reports across all the environments.
• Expertise in using global variables, expressions and functions for the reports with immense experience in handling sub reports in SSRS 2008 R2.
• Ability to handle Multiple tasks, Initiative and Adaptable. Self-motivated, organized team player with strong problem solving and analytical skills and total commitment to the organization goals and good ability to quickly grasp and master new concepts and technologies

Technical Skills

Operating Systems : Win 2000/NT/2003/2008 server.
RDBMS : MS SQL SERVER 2008 R2/2008/2005/2000/7.0, MS Access2007,
Oracle 8i
Database Tools : SQL Query Analyzer, SQL Enterprise Manager, Management.
Studio, SQL Server 2008, Query Editor, Solution Explorer
Reporting Server, Ms-Access.
ETL Tools : Data Transformation Services (DTS), MS SQL Server Integration
Services (SSIS).
Reporting Tools : MS SQL Server Reporting Services (SSRS),Crystal Reports XI/X
Data Modeling : ER-Win 4.0, MS Visio 5.0.
BI Tools : SSIS,SSAS,SSRS
Programming Languages : Unix, Asp.Net XHTML and XML.

Professional Experience

Confidential,San Antonio, Texas May’11 – Present
SQL Server Developer/SSIS/SSRS

Confidential,is a leading multimedia companies with business in publishing, digital and broadcasting. In publishing, Tribune’s leading daily newspapers include the Los Angeles Times, Chicago Tribune, The Baltimore Sun

Responsibilities:

• Prepared the complete data mapping for all the migrated jobs using SSIS
• Involved in Performance tuning of ETL transformations, data validations and stored procedures
• Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Flat files)
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 in Business Intelligence Development Studio (BIDS)
• Scheduled tasks to run every day to update changes in the base tables
• Designed and developed various types of reports using SSRS
• Worked on formatting SSRS reports using the Global variables and expressions
• Created SSIS Packages using multiple transformations like Fuzzy Lookup,Data Conversion, Derived Columns, Pivot Transformation, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Created SSIS package to transfer data between OLTP and OLAP databases using Incremental Load.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent
• Created parameterized reports, Drill down and Drill through reports using SSRS
• Deployedanduploaded the SSRS reportstoSharePoint Serverfor the end users and involved in enhancements and modifications
• Published reports on to Share-Pointandcreated Web Parts in Share-Pointto show various reports generated fromExcel andSSRSin one Page.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse

Environment:
Microsoft SQL Server 2008, Windows Server 2003, Windows XP, Microsoft Visio, SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS).

Confidential,San Antonio, Texas July’ 09 – Apr’11
SQL Server/SSIS/SSRS Developer

Confidential,is an entertainment company based in San Antonio, Texas. It is specialized in both mobile and on-demand entertainment and information services for local communities and premiere opportunities for advertisers. It includes radio and outdoor displays.The project involved in Analysis, Design, Develop, and Deploy Extraction Transformation Loading (ETL) and Reporting applications using SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).

• Created SSIS packages to extract data from OLTP and transformed to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Experience in creating Jobs, Alerts, SQL Server Mail Agent, and schedule DTS/SSIS Packages.
• Developed SSIS packages for File Transfer from one location to the other using FTP task
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Generated ad-hoc reports using MS Reporting services and Crystal reports.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Involved in Planning, Defining and Designing data, based on business requirements and provided documentation.
• Upgraded MS SQL Server 2005 database to MS SQL Server 2008, by using Detach/Attach, Back up & Recovery.
• Incorporated the DTS Packages into MS SQL Server 2005/2008 Integration Services by using Package Migration Wizard and Execute DTS 2000 Package task.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Used MS Report Designer to provide a Report Data pane to organize data used in the reports.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Generated reports using SSRS which were sent to different Clients, and managers
• Performed Documentation for all kinds of reports and SSIS packages.

Environment: Windows 2003 Server/XP, SQL Server 2008/2005, SQL Integration Services(SSIS), SQL Reporting(SSRS), Business Intelligence Studio, Visual Studio 2008/2005, OLE DB, DTS Package, SharePoint MOSS 2007, Crystal Reports

Confidential,Orlando, Florida Dec’ 08 – June’ 09
Balance Checking System
SQL Server/SSIS/SSRS Developer

Project Description:
BCS is a credit validation application of funds transfer system with a Corba server catering requests coming from different interface systems. It maintains different queues and it allows credit officers to take the decision and perform manual operation. Based on the aggregation logic, BCS will perform credit validation and sends appropriate response for the message received from the interface system. Customer can have multiple accounts in multiple countries and it also processes different messages at a rate of 30000 payments per hour. BCS follows Client Server model and core processing logic is implemented in Java and SQL Server 2000/2005

Responsibilities:

• Successfully implemented physical database on MS SQL Server 2005. Supported complex relationship using triggers.
• Moved the static data from various heterogeneous sources like Oracle, MS Access, and MS Excel and text files to SQL Server 2000 database using BCP and dynamic DTS/SSIS packages.
• Tuned database by creating proper Indexes on different tables that improve the performance of T-SQL queries on the database.
• Facilitated simplified access of database for end users using de-normalized views and created triggers on them to maintain to database integrity.
• Created audit trails of activities on database using triggers on backend.
• Active Interaction with clients to understand business requirements.
• Actively Participated in logical design of database design to meet new product requirement using ERWIN.
• Implemented the business logic and processing of the payment by developing stored procedures and scripts.
• Created Cursors to facilitate the users (credit officers) to scroll through the Queues to perform manual operations on the payment.
• Automated many operations by scheduling multiple SSIS packages using jobs.
• Involved in requirement gathering, analysis, design, development, change management, deployment and user training.
• Used SQL Server Profiler to trace the slow running queries and optimized query execution with the use of Index Tuning Wizard and Rebuild indexes if necessary.

Environment:MS SQL Server 2005, XML, SSIS, MS Analysis Services.

Confidential,Irvine, California Mar’ 07 – Nov’ 08
SQL Server/SSIS/SSAS/SSRS Developer

Confidential,is a 60 yr old Insurance provider which helps financial institutions protect their customer portfolios. It is a nationwide leader in mortgage and auto lender-placed insurance tracking services, and also offer consumers a variety of innovative home and life products.
Responsibilities:

• Followed the Microsoft recommended best practices in designing, developing, and implementation and testing of the ETL using SQL Server Integration Services.
• Created the Data Model for the Marketing Information System Team using Erwin
• Built various packages in SSIS to load the data coming from various interfaces like OMS, Orders, Adjustments and Objectives.
• Used multiple transformations in SSIS to meet the business requirements by collecting data from various sources.
• Migrated Organization, Orders, Adjustments, Objectives and Callidus data in various formats like text based files, Excel spreadsheets, to SQL Server databases using SQL Server Integration Services (SSIS) to overcome the transformation constraints.
• Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
• Scheduled and maintained daily and monthly loads of OMS, Orders, Objectives and Adjustments data through jobs, tasks, and alerts.
• Created stored procedures to build the Fact tables in the data mart for Multi-Dimensional analysis using (SSAS) and produced ad-hoc, standard and super user reports using (SSRS).
• Created OLAP cubes using SSAS for data mining and created reports from the OLAP cubes using SSRS
• Created components, tools, techniques, methods and procedures used in an on On-Line Analytical Processing (OLAP) environment for accessing and translating data into understandable and usable business information using SSAS
• Used MDX to create named sets, named members and other calculations.
• Worked with the team in building the daily dollar, summary, funnel genie, objective and adjustments reports.
• Created different user level groups, and assigned appropriate permission levels to the reports, to ensure access to the information for the right persons with authorizations based on their levels in the Organizational hierarchy.
• Migrated data from legacy system (text based files, Excel spreadsheets, and Access) to SQL Server databases using DTS, SQL Server Integration Services (SSIS) to overcome the transformation constraints.
• Migrated data from SQL server 2000 to SQL server 2005 and worked with implementing data mapping, cap analysis to migrate hybrid environment.
• Worked with migrating data from flat files, mainframe data, Oracle, Db2 data to SQL server 2005 using SSIS services.
• Creating application Schema (Database, Tables, Views and Indexes) and implemented various SQL, Transact-SQL statements, stored procedures and UDF (User Defined Functions) according to the requirements of the project.
• Generated various reports using reporting services.
• As a technical specialist assisted in solving technical and non technical issues.
• Debugging and troubleshooting the technical issues while implementing the applications.

ENVINORMENT: Windows XP, Windows 2003, Terminal Server, T-SQL, BCP, SQL Jobs, SQL Server Management studio, SQL Server 2005, SSIS, SSRS, SSAS, ERWIN.

Confidential,India Feb’ 05 – Nov’ 06
SQL Server Developer

This project involved mainly database administration and supporting highly critical production servers. The client engages in e-commerce, retail and electronic payment processing.

Responsibilities:

• Involved in creation of new database, planning the location of data, index and transaction log files on the disks
• Created Users and Roles, and managed security and permission of database
• This project involved migrating the packages from full load to Incremental load
• Used SQL task to track the count
• Added features like auditing, logging to the packages
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent in SSAS
• Working knowledge in Data modeling, creating star and snowflake schemas in SSAS
• Developed the reports in the form of Table, Matrix, Text and Chart Using SSRS (SQL Server 2005 Reporting Services)
• Generate the Snapshot Reports for each subject area according to client requirements
• Developing parameterized reports including multi-parameters
• Developed the reports with Drill-Down features

Environment:
MS SQL Server 2005 Enterprise Edition, MS SSAS 2005, MS SSRS 2005, MS SSIS 2005, DTS, T-SQL, Windows Server 2003

Confidential,Bangalore, India Jun’ 04 – Jan’ 05
SQL Server Developer/DBA

.

ICICI Insurance Company is one of the biggest commercial insurance and banking company that provides dependable, competitive priced insurance coverage to farm and ranch families. It’s mainly located in India. The job was to develop, implement and maintain all databases including stored procedures, triggers, and complex queries, which include the administration of various databases in both development and production environments.

Responsibilities:

• Worked as a developer role on MS SQL Server 2000, MS Access databases
• Logical and physical database development (using Erwin, normalization, dimension modeling and Enterprise manager).
• Looked at the reports and fixing bugs in stored procedures, tables and ETL process.
• Worked as a developer in creating complex Stored Procedures, triggers, tables, and views and other SQL joins and statements for applications.
• Worked on MS SQL Server tasks such as data loading, batch jobs, BCP, Instances and Indexes.
• Created and automated the regular jobs.
• Managed the security of the servers (Logins and users).
• Developed complex T-SQL code for the application.
• Designed and implemented the stored procedures and triggers for automating tasks.
• Did backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views, user security management, implementation of version control with Visual Source Safe.
• Testing to optimize the procedures and triggers to be used in production.
• Developed reports with Crystals Reports 8.5 and informix.
• Developed various reports such as dynamic and static.
• Report is grouped and sorted at the front end according to the requirement .extensively used formulas are added to calculate fields and maintain its running total and group totals.
• Sub reports are used to incorporate, which cannot be included through the main report

Environment:
SQL Server 2000, MS Access, DTS, Query Analyzer, Enterprise Manager BCP, Erwin, Windows 2003, Crystal Report 8.5.