Professional Summary:

• 7+ years of administration and development experience on Database Design and Development in SQL server 2005/2000 system in OLTP and OLAP environment.
• 7 years of experience in BI of MS SQL Server.
• Excellent command on SQL SERVER 2008.
• Data modeling using Erwin Data Modeler and MS Visio.
• In-depth knowledge of Transact-SQL (DDL, DML).
• Expert in creating indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.
• Excellent skills in implementing ETL Packages using SSIS 2008/ 2005.
• Experiencein creating master and child packages, package configurations and logging.
• Excellent knowledge of using variables and expressions in packages.
• Migrated DTS packages to SSIS and modified using DTS editor
• Experience in Importing/Exporting Data from various data sources like Excel, Oracle ,DB2 and Flat file using BCP, Bulk Insert & DTS utility. Involved in transformation of OLTP data to the Data Warehouse using DTS and SQL commands.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• Expertise in generating reports using MS Reporting Services 2008/2005.
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services..
• Excellent hands on experience scheduling and the deployment of the reports and uploading files to a report server catalog from the report manger.
• Excellent command on subscriptions, report snapshot and report cache.
• Worked extensively on system analysis, design, development, testing and implementation of projects (Complete SDLC) and capable of handling responsibilities independently as well as a proactive team
• Some experience in DB2 queries.
• Experience in .NET coding.
• Good skills in MSACESS.
• Worked on development/staging/production environments and used Team foundation server/visual source safe for version controls and communication’s well as defining Actions, translations and perspectives.
• Good skills with computer science concepts and programming.
• Very good communication skills, good interpersonal skills & desire to excel, fast learner, hardworking and a versatile team player.

Technical Skills:

RDBMS/DBMS: MS-SQL Server 2005/2000/7.0, Oracle 8i/9i/10g, MS Access,BI.
Programming Languages: T-SQL, PL/SQL, C, C++, C#, HTML, XML, Java, ASP .NET, VB6 .NET,COM+

Software/Databases: MS SQL Server 2005 / 2000/7.0, MSSQL Server Reporting Services 2008/2005/2000 (SSRS), MSSQL Server Analysis Services 2005(SSAS), MSSQL Server Integration Services 2005 (SSIS), Data Transformation Services (DTS), Oracle 9i/10g, ODBC, OLTP, OLAP, SQL Server Management studio (SSMS), MS SQL Server 2000 Enterprise Manager, SQL Query Analyzer, Web Services, SQL Profiler, Bulk Copy Program (BCP),ProClarity

Operating Systems: Windows 98/2000/2003/XP/NT/Vista, Windows 2000Advanced Server, Windows 2003 Enterprise Server.

Version Control: Visual SourceSafe (VSS), Team Foundation Server (TFS).

Web Servers: IIS 6.0, Apache, Share Point(MOSS), Performance Point Server.

IDE & BI Tools: SQL Server BI Development Studio (BIDS), MS Visual Studio 2008/2005,Crystal Reports

Data modeling Tools: Erwin 7.2/4.5/4.0, MS Visio 2003/2007, Rational Rose

Design Methodology Unified Modeling Language 1.1 using Rational Rose.

Reporting Tools SQL server Reporting Services(SSRS),Crystal Reports,Dundas Chart

ETL Tools SQL Server Integration Services(SSIS),DTS

Academic Qualifications:

• Bachelors in Computer Science

Certification:

• Microsoft Certified Technology Specialist (MCTS)-SQL Server 2005

Professional Experience:

Confidential,OCT 2009-Dec 2010
SQL SERVER DEVELOPER SSRS/SSIS FL

SPG llc development firm for client needs. Celebrity cruise the client requirement was to send emails to customers listed in requirement and report the result of emails.

Responsibilities:

• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), DB2 and Excel Spreadsheet to SQL Server 2005.
• Worked extensively on DTS Package designs for Import/Export from various Data Sources; Flat file, Excel, MS Access to MSSQL Server
• Wrote store procedures for cleansing and loading data.
• Created and executed SQL SSIS packages using BULK load task to populate large volume of data from the various data sources.
• Migrated DTS 2000 packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Service.
• Developed ETL packages with different data sources (SQL Server, Oracle, Flat Files, Excel source files, XML files etc) and loaded the data into target tables by performing different kinds of transformations(Control flow transformations such as Ftp Task, For Loop Container, For Each Loop Container, Execute package task, Execute process tasks, Script tasks, send mail task, Data Reader Task, XML Task and Data flow transformations such as Lookup, Conditional Split, Derived Column, Audit, Merge, Merge Join, Sort ) using SQL Server Integration Services (SSIS).
• Migrated the Existing DTS packages to the SSIS Batch jobs and enhanced the packages with monitoring features so that audit information of the packages and their execution results are loaded in to the audit table.
• Provided notifications for error,success and load details of packages.
• Designed, deployed, and maintained of various SSRS Reports in SQL Server 2005.
• Wrote Stored Procedures for various reports such as Grouping, Sorting, Drill-down, and Parameter prompts using SQL Server SQL Server 2005.
• Created subscriptions.
• Deployed reports on report server
• Developing stored procedures, triggers, views, and adding/changing tables for data load and transformation, and data extraction.
• Provided production support for the ETL jobs and also to the code deployed into the production environment.
• Documented details of packages,store procedure and reports for reference.

Environment: MSSQL Server 2000/2005, MSSQL Server Reporting Service 2005, MSSQL Server Analysis Services 2005, MSSQL Server Integration Services 2005, MS Access, MS Excel , Erwin, Windows 9x/NT/2000/XP/Server 2003, T-SQL,TFS,VSS, HTML, XML, ODBC, MS Visio 2003.

Confidential, Columbus, OH Jun 2008 –june 2009
SQL Server/BI Developer

Cardinal Health is a leader in technologies and services that help hospitals manage all medications from the moment they arrive until they are administered to the patient; store and track specialty supplies; and identify and prevent hospital-acquired infections. The scope of the project was a CRM based inventory-management service a application provided by cardinal health which enables customers to track their orders and manage the inventory by reports provided based on business. The project requires Extract and loading data to data warehouse , creating reports and cube.

Responsibilities & Accomplishments:

• Created SSIS packages to clean and load data to data warehouse.
• Documented framework as proto type of package design.
• Created package to transfer data between OLTP and OLAP databases.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, 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 a table to save dirty records.
• Extracted data from oracle,DB2 to load to data warehouse.
• Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated
• Created complex queries to automate data profiling process needed to define the structure of the pre staging and staging area
• Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Prepared the Layouts by placing the fields to the appropriate place according to the requirement of the final Report.
• Created standard report Subscriptions and Data Driven report Subscriptions
• Created report snapshots and cache for better performance.
• Used Notification services to generate error messages and send them.
• Created ad-hoc reports, drill down, and drill through reports.
• Reviewed and adjusted deliverables involved during SDLC involving database changes/development.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications
• Sucessfully designed reports in MS BI tool.
• Provided knowledge transfer to the company’s SQL programmers.
• Designed stored procedures and cursors.
• Successfully tested all task in staging and stored all versions of data using team foundation server(TFS).

Environment: SQL Server 2005, BIDS 2005, Reporting services 2005, Integration services 2005, Windows Server 2003, HealthCare database, Oracle 9i,DB2,Share point server.MS BI,Visual studio

Confidential,Aug 2007- Jun 2008
SQL Server Developer/SSIS/SSRS

HMC, a wholly owned subsidiary of WellPoint Inc., an independent licensee of the Blue Cross and Blue Shield Association and the largest health insurer in the United States, works with insurers to keep healthy those who suffer from chronic medical conditions such as asthma, circulatory problems, or diabetes.The data warehouse was on MS SQL Server 2000. Because of the company’s growth and so growth of database that was 3.8 TB,WellPoint increased requirements led them to move to MS SQL Server 2005 having some enhanced features. This project requires monitoring for billing services by creating reports and report model using SSRSaccording to business requirement. Migrated from SQL Server 2000 to SQL Server 2005. The data warehouse was populated using SSIS Packages.

Responsibilities & Accomplishments:

• Worked with Business Analysts and Users to understand the requirement.
• Implement logical design into physical design.
• Maintained design structure (Schema) by directing implementation of SQL standards and guidelines.
• Created a virtual machine and migrated databases.
• Migrated DTS packages using DTS editor wizard in SSIS ,validated and tested all packages on development server
• Tested all stored procedures on testing server
• Created Stored Procedures, triggers, UDF, views, tables and generated TSQL script for application
• Created indexes for better performance
• Tested the data with complex queries, joins and sub queries.
• Successfully migrated the data from SQL Server 2000 to SQL Server 2005.
• Created packages to migrate data from different data sources to data warehouse.
• Created packages for database maintenance.
• Executed Back up database task, check database integrity, rebuild indexes, update statistics task for m
• Data migration (Import & Export using BCP) from text to SQL Server2005.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, 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.
• Used BI tools to create packages and reports.
• Identified the Measures and Dimensions from the Excel Sheet.
• Successfully Extracted transformed and load data into data warehouse.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server
• Created tabular, matrix, chart, drilldown reports, parametric, cascaded reports and dashboards and scorecards reports according to business requirement.
• Deployed the generated reports directly on the client’s workstation.
• Created complex Stored Procedures for better performance to generate reports.
• Created standard and data driven Subscription, used report manager for securities.
• Created report model for Ad-hoc reporting, generate report in XML format.
• Used Team Foundation Server (TFS) for version control, source control and reporting.
• Documentation for all kinds of reports and DTS and SSIS packages.

Environment: SQL Server 2005, SSIS, SSRS, Query Analyzer, Index Tuning Wizard-SQL MS Access, MS Excel, ERWIN, Windows Server 2003 Enterprise Edition.

Confidential,San Mateo, California Nov 2006 –Aug2007
SQL Server Develper(SSIS/SSRS/SSAS)/ETL
Franklin Resources Inc. is an investment firm specializing in conservatively managed mutual funds. It offers products under the Franklin, Templeton, Mutual Series and Fiduciary brand names. The sales feed from Central Data Warehouse (CDW) to the CRM had to be modified to fit the new report server, as the existing process was bound to the old schema which was to be discontinued. Project was to alter the process to meet the new business requirements.

Responsibilities:

• Extracted required mapping fields from different sources (schema, CDW) to Sales Force Warehouse for Staging Table.
• Performed all Conversion goals and objectives which include identifying data for processing sales, and validating of historical sales is available in CDW for migrating the data to Sales Force.
• Analyzed and performed Data mapping which involves identify source data field, identify target entities and their lookup table id’s, and translation rules. Evaluation of data groups and data critically and developed automated conversion process.
• Developed and modified many Scalar Valued Functions, Stored Procedures for parsing data required for mapping in Sale Force. Tweaked low performance functions.
• Developed Store Procedure and Staging table for data push from CDW to Sales Force.
• Preformed QA Testing for all the Store Procedures to validate the sales results.
• Developed SSIS Packages not only for particular table’s fields and required data types for lookup tables in Staging but also for data Warehouse requirements of CDW.
• Increased query performance by 20%, which is necessary for statistical reporting after monitoring, tuning, and Optimizing Indexes by using Performance Monitor and SQL Profiler. Reduced and obliterated unnecessary joins and indexes.
• Created and scheduled SSIS packages for running AM and PM feeds from various departments and multiple servers and resources to Development Servers.
• Created SSIS Packages by using advanced tools (i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicasting).
• Created Packages by testing and Cleaning the Standardized Data by usingtools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more)for existing/new packages and huge CSV file import to Sale Force from different data sources and other ongoing tasks for mapping.
• Developed and modified the existing reports from basic Chart and tabular to parameterized reports including Single/Multi/Boolean valued parameters and linked reports based on new business logic.
• Created SQL server configurations for SSIS packages and XML & Windows event logs.
• Used sub reports functionality for complex report calculations.
• Created parameterized reports passing parameter through report screen.
• Rendered reports in different formats like pdf, excel etc to be executed automatically on weekly or monthly basis and managed subscriptions.
• Using MDX created calculated members for customized calculated measures.
• Analyzing the Performance of a Cube by partitioning it and creating Perspective Cubes.
• Documented all database objects, procedures, views, functions & packages for future references.
• Performed all QA testing and match results for different environments.
• Experience in working with stocks and bonds.
• Documented all old and migrated Store Procedures and scripts for future references.

Environment:
Windows XP/2003 Enterprise edition, MS SQL Server 2005, Excel 2003, Visual Studio 2005, TFS, VBScript, Database Engine Tuning Advisor, Profiler SQL Server Management Studio 05, SQL Server Business Intelligence Development Studio, Reporting Services Configuration, SSIS, SSRS.

Confidential, New York, NY Jan 2006- Oct 2006
SQL Server Developer/ SSIS/SSRS Developer

Multiplan is one of the most progressive and integrated health insurance organizations in the nation providing services to more than two million residents. The project was to migrate data from various heterogeneous data sources such as oracle, DB2, MS Access, MS Excel and flat files into SQL Server 2005 and maintain Database for the Facility search and Provider search. This was an OLTP database with the data storage of 2.2 TB in size with 210 tables. The presentation Tier was on .Net Framework 2.0 with C# and ASP.Net User Interface.

Responsibilities & accomplishments:

• Developed and created logical and physical database architecture using ERWIN.
• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.
• Successfully implemented indexes on tables for optimum performance.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Created SSIS packages to import data from MS Access, Excel to SQL 2005
• Creyed expressions using VB6.
• Filtered bad data from legacy system using Derived column, Lookups, Fuzzy Lookups, Conditional split.
• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using BCP in staging database from MS Access, excel.
• Developed scripts to migrate data and the database objects to/from multiple sources.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Involved in creating front end user interface to allow customers to interact with the application using C# objects and HTML.
• Created effective functions, appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
• Developed complex stored procedures using T-SQL to generate Ad hoc reports within SQL Server Reporting Service (SSRS).
• Built different types of chart reports using SSRS for the business requirement like column chart, Pie Charts.
• Created SQL Server Integration Service (SSIS) packages between enterprise databases and Third party data source to transfer data.
• Created SSIS package to automate maintenance, database back up, update statistics, re-build indexes as well as create error log for event during data load.
• Responsible for the creation and the maintenance of Analysis Services objects such as cubes, dimensions and MDX queries.
• Used MDX queries for pre calculated measures.
• Created report Model on SSAS Cubes as well as changing default configuration on existing Cubes.
• Configured replication servers and transactional replication between production and standby server for high availability / disaster recovery.
• Held responsibility for database maintenance plans.
• Actively involved in gathering and analyzing stakeholders requirements.
• Created alerts, notifications, and e-mails for system errors.

Environment: SQL Server 2005, SSIS, SSRS, Query Analyzer, Database Engine tuning wizard, C#, MS Access, MS Excel, ERWIN, Windows Server 2003 Enterprise Edition, HTML