SUMMARY

• Over 8 years of IT Professional experience in Development, Client Analysis, Database Design, and Presentation using SQL Server 2000/2005/2008 .
• Vertical industry experience includes Financial Services, Insurance, Retail, Telecom and Utility.
• Good knowledge of Normalization/De - normalization, data design methodology and building Referential Integrity.
• Experienced in TSQL (DDL,DML), documenting, coding, programming, modifying and implementing Business Intelligence solutions using SQL Server 2000/2005/2008 .
• Expertise in creating Complex Stored Procedures, Queries for the application team and for the end users based on the business requirement.
• T-SQL coding and testing: functions, views, triggers, cursors, dictionary, stored procedures, etc.
• Good Knowledge in system tables and stored procedures using T-SQL
• Creation such as Tables, Views, User Created Data Types, Indexes, Stored Procedures, Cursors, Triggers and more.
• Experienced in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Data Transform Services (DTS).
• Knowledge on SQL Server 2005 Analysis Services (SSAS) delivers online analytical processing (OLAP) and data mining functionality for business intelligence applications.
• Creation and maintenance of Databases, creating Roles and managing user permissions, resolving deadlocks.
• Experienced in transforming complex business logic into Database design and maintaining it by using SQL tools such as Stored Procedures, User Defined Functions, Views, and DTS.
• Experienced in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools like SSIS, Data Transformation Services (DTS), Bulk Insert, BCP, and XML.
• Understanding of various source transformations, including flat files, XML and relational systems.
• Development skills in stored procedures, Ad-Hoc SQL Queries, triggers, functions, views, cursors, custom DTS packages using Visual Basic.
• Reviewed, analyzed, and modified programming systems including encoding, testing, debugging and installing to support an organization's client/server software applications.
• Experienced in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server 2005 Reporting Services (SSRS).
• Experienced in generating reports like matrix, parameterized and drill through reports using SSRS and developed stored procedures using functions to generate various kinds of reports using SSRS.
• Configured and maintained Report Manager and Report Server for SSRS.
• Extensively used ADO.NET objects such as Typed Datasets, Data Tables and Data Views for consistent access to SQL Server 2005 data source.
• Integrated SQL server reporting services with ASP.Net to view generated reports in Crystal reports.
• Generated reports using SQL Server Reporting Services integrated and deploying them using web applications onto the web servers.

TECHNICAL SKILLS

• Enterprise Manager
• Profiler
• Query Analyzer
• Export & Import
• MS SQL Server 2000/2005/2008
• MS Access
• Oracle
• DTS
• SSIS
• SQL
• T-SQL
• VB.Net
• C# and Oracle
• HTML
• XML
• CSS
• My SQL
• Software Development Life Cycle (SDLC)
• Cognos
• Project Management
• Windows 2000/NT
• Windows 2000 Server/Windows95/98/2000/XP.

PROFESSIONAL EXPERIENCE

Confidential, Louisville,KY

MS SQL Server /SSIS/SSRS Developer

Responsibilities:

• Involved with the Business Analyst and Quality Assurance teams to decide the business requirement according to the vendor specifications and developed Business Decisions Documents, Supplied to team using Team Foundation Server.
• Responsible for the designing the advance SQL queries, procedure, cursor, triggers, scripts and Also created, modified, maintained and optimized SQL database.
• Created, tested, performance tuned and implemented stored procedures and queries in Microsoft SQL Server 2000 & 2005.
• Modified the existing database by adding the tables and maintained relationships between the Databases and used complex query statements like sub queries, correlated queries, and derived tables to insert the data depending on the criteria for the integrity in the server according to the Business Rules.
• Maintained the documents and create reports for the business analysts and end-users.
• Performed migration of Crystal Reports to SSRS and responsible for schedule the reports using Report Server.
• Responsible for developing Cross-tab, Cascading reports to get physicians interactions, events, publications, topic discussions, activities for particular duration using SQL Server Reporting Services (SSRS) from Crystal Reports as a model.
• Developed Dynamic and parameterized reports for the different departments and related physicians using SQL Server Reporting Services (SSRS). Involved in deploying, configuring and managing reports using Report Manager and Report Builder.
• Involved in table and index partitioning for performance and Manageability in cognos.
• Created, Managed and Support existing reports using SSRS and Crystal Reports.
• Performed Migration of Extracts that is Data Transformation Services (DTS) to SQL Server Integration Services (SSIS) using DTS Package Migration Wizard by using ODBC connectivity.
• Responsible for developing a SQL Server Integration Services (SSIS) Framework for Providence Health Plan (PHP) - Dual Framework Phase in Extracts Database.
• Extracted the data from the TIDAL in Type Word format using SQL Server Integration Services (SSIS) packages for the Insurance Vendors with appropriated rules.
• Developed C# scripts for the looping of the data between Departments with respective to BATCH ID and created SSIS packages.
• Expert in writing Store Procedures for better performance to retrieve data from the backend database.
• Transferring the Data from Legacy Database, Flat-Files and Excel to SQL Server using SSIS and also developed Config, cmd files added to TFS by ODBC connectivity.
• Designed and developed User Interface with C# and Asp.Net, used C# validation controls for performing Form Validation, developed and executed severaloptimized queriesin SQL using Team Foundation Server.

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

Confidential, MountainView,CA

MS SQL Server /SSIS/SSRS Developer

Responsibilities:

• Designed Data warehouse to integrate centralized SQL Server to manage all the clients’ Personal health information and architected in simplified manner and made available to the entire DQ Teams like Web extracts and Reports, Extracts and Interface and Web Portal.
• Developed and executed SSIS packages to populate data from the various data sources like Oracle, created packages for different data loading operations for many applications.
• Created complex Stored Procedures, Functions, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for optimizing and
• Developed Master Child package using variables and Execute Package Task in SSIS, executing with bat files and moving along with different servers.
• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions, implement best practices to maintain optimal performance.
• Extensively used SSIS Import/Export Wizard for performing the ETL operations and various containers to do the looping operations.
• Used multiple transformations in SSIS to meet the business requirements by collecting data from various operations.
• Organized Error and Event Handling by giving Precedence Constraints, Break Points, Check Points, Logging to send the result files to the clients and vendors.
• Created SSIS Packages using Lookup, Merge, Sort, Derived Columns, Condition Split, Aggregate, Execute SQL Task, and Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel, Text file and MS Access to different data Marts.
• Created different forms of tablix, dropdown, parameterized reports and integrated with front ends like C#.net and SharePoint.
• Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
• Configured Connection Manager Files and CMD files for SSIS packages to dynamically execute on QA Server and Production server
• Involved in working with web services and soap.
• Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).
• Deployed, Tested and Scheduled SSIS packages using SQL Agent.
• 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.

Environment: Microsoft SQL Server 2000/2008, SQL Server Integration Services (SSIS) 2005/2008, SQL Server Reporting Services (SSRS), MS Excel, Team Foundation Server, VSS 2005, Team Explorer, TWS Scheduler.

Confidential, Bellevue,WA

MS SQL/Report Server Developer

Responsibilities:

• Developed T-SQL code, Views, Functions and Stored procedure using T-SQL to get data from Different data and with best execution plan.
• Scheduled SQL jobs in SQL Server 2005 to generate alerts to the subscribers to the alerts in RAN 2G & 3G and CORE alerts.
• Created different user-defined functions using T-SQL Query for the creating Datasets and Data Adapters to use them in SSRS 2008 and SSIS.
• Configured SQL Mailing Agent for sending alerts to the subscribers by mails upon SSIS packages, SSRS reports2008 and T-SQL Stored Procedures.
• Involved in developing and deployed Reports from OLAP in SSRS with Charts and PIE Diagrams.
• Created Drill Down and Drill through reports with user defined parameters with sub reports, Pie diagrams and Charts in SSRS.
• Configured in report architecture and report security for reports in SQL Server Reporting Services.
• Involved in invoking reports created in SSRS to front-end like Share-Point server for the managerial and client verification.
• Developed Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server 2005 Reporting Services (SSRS) in Crystal reports.
• Built advanced reports using query parameters, report parameters, filters, interactive sorts to compare the rates among the four major regions, to generate the alerts history in active reports.
• Developed Templates for the reports for the managerial cadet so that they need to drag and drop the fields which they need exclusively for Non-technical person in SQL Server Reporting Services (SSRS).
• Created report models for ad hoc reports when the end user wants to see the reports on fly in SQL Server Reporting Services (SSRS) in Data Dynamics report with VB.NET.
• Created Ad-hoc reports for manager using SSRS to find all the work items open for Developers.
• Developed, tested and implemented Referential Integrity rules and regulations through constraints, triggers and views in the centralized Confidential SQL database.
• Migrated data from Heterogeneous Data Sources and legacy system (ORACLE (OSS), Access, Excel) to centralized SQL Server databases using SQL Server Integration Services (SSIS)
• Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS.
• Created SSIS package to Export and Import data from SQL Server to Access, Text and EXCEL files and Configured SQL mail agent for sending mails upon package deployment.
• Generated Crystal reports using SQL Server Reporting Services integrated and deploying them using web applications onto the SharePoint web servers in Data Modeling.

Environment: Microsoft SQL Server 2005/2008, SQL Server Integration Services (SSIS), BIDS, SQL Server Reporting Services (SSRS), Windows Server, MS Visio, Oracle, MS Excel, crystal Reports, Business Objects

Confidential, San Jose, CA

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Installed upgraded and migrated databases from Oracle database to MS SQL Server 2005.
• Developed Cascading, Drill-down Reports to get monthly card details and profits using SSRS 2005.
• Involved in deploying, configuring and managing reports using Report Manager and Report Builder.
• Formatted the reports using the Global variables and expressions.
• Integrated SSRS with ASP.Net and deployed them using web applications on to web server and production server.
• Responsible for creating the reports basing on the requirements using SSRS 2005.
• Created Cross-Tab and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.
• Identified the data source and defining them to build the data source views in SSRS 2005.
• Identified and added the report parameters in SSRS.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created, Managed and Support existing reports using SSRS in various environment.
• Involved in creating, deploying and configuring reports according to the requirements using SSRS.
• Involved in the analyzing and solved problems doing the Client Application system's installing, upgrading and running stages.
• Created new logical and physical design of database to fit new business requirement and implemented new design into SQL Server 2005.
• Wrote SQL scripts to Insert/Update and Delete data in MS SQL database.
• Involved in table and index partitioning for performance and Manageability.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize performance.
• Involved in writing different testing scripts for the testing of the Codes in ASP.Net and C#.Net.
• Created star schema in SSAS and developed SSRS reports based on the cubes.
• Generated Sales Ranking reports using SQL Server Reporting Services for different subjects.

Environment: Microsoft SQL Server 2005, SQL Server Integration Services tools (SSMS, BIDS and SQL Server Manager), SSRS, SSAS, Windows Server, MS Visio, Oracle, MS Excel

Confidential, Irvine, California

MS SQL Server/SSIS Developer

Responsibilities:

• Upgraded databases from SQL Server 2000 to SQL Server 2005
• Actively involved in designing the logical and physical architecture for Liberty group database.
• Created Cross-Tab, Drill-down, Drill-through and Sub-Report using RDL. Promoted RDLs to Reporting Service Server. Wrote the queries for the drill down reports.
• Formatted the reports using the Global variables and expressions.
• Created detailed reports for the customers to help them decide which property to purchase by showing demographic information based on various parameters.
• Authored performance based reports for the managers to show sales against various measures like Time, Area, and Price-Range.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation in Environment and Health Packages.
• Created and modified data driven subscriptions, fine-tuning subscription execution.
• Data migration (import & export - BCP) from Text to SQL Server.
• Configured Dimensions, Measures and Measures Groups using SQL Server 2005 Analysis Services.
• Created and Configured OLAP Cubes using SQL Server 2005 Analysis Services and Performance tuning and scaling to large numbers of users.
• Identified and worked with parameters for parameterized reports in SSRS 2000/2005.

Environment: MS SQL Server 2000/2005, Excel, DB2, MS Performance Point Server, Visio 2000, T-SQL, Advanced Windows 2000 Server, Crystal reports, IIS, XML Parsing, TOAD, SOAP and Microsoft Access, ASP .Net, C#, VB .Net.