Professional Summary:

• Over 7 years of experience in IT industry as a MS SQL server developer.
• Extensive experience in MS SQL Server 2000, 2005 & 2008 with Business Intelligence in SQL Server Reporting Services and SQL Server Integration Services of 2005/2008.
• Experienced in creating complex SSIS and DTS packages for ETL purposes. Data Migration, Data Conversions, Data Extraction/ Transformation/Loading (ETL) using DTS and SQL Scripts.
• Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, BCP, and XML), package configurations and logging.
• Expert in Creating, Configuring and Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Experienced in generating On-demand and Scheduled reports for Business Analysis or Management decisions using MS SQL Server Reporting Services 2005/2008 (SSRS).
• Proficient in creating SQL Server reports, handling sub reports and writing query for generating drill down reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2005/2008.
• Highly experienced with the Full Life Cycle and Methodology for implementing OLAP (Online Analytical Processing) data warehouses (star and snow flake schemas) and business intelligence reporting systems.
• Expertise in multidimension data modeling and creating ER diagrams using Erwin and Microsoft Visio.
• Experience in Designing Aggregations and pre-calculating the same in SSAS 2005, in creating groups and measures, KPIs.
• Highly proficient in the use of T-SQL, creating Relational Database models and maintaining Data integrity.
• Experienced in Performance Tuning, Query Optimization, Execution Plan, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
• Extensively used tools like SQL Profiler, Index Tuning Wizard, and Database Engine tuning wizard, Windows Performance Monitor for monitoring and tuning MS SQL Server performance
• Using Performance Monitor/Profiler to solve Dead Locks/Long running queries and creating Queries using global variables, expressions and functions for the reports.
• Experience in Database Administration activities like Installation, Configuration, Backup, Recovery, Database Security, Data Transformation Services, Database designing and Replication, Migration from MS SQL Server 2000 to MS SQL Server 2005.
• Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).
• Experience in application development using the .NET framework 3.5 along with C# and VB.Net.
• Highly motivated and competent individual with good communication and analytical skills.
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.

Education Qualifications:
Bachelors in Computer Science

Skillset:
MS SQL Server Management Studio 2000/2005/2008, T-SQL, MS SQL Server Reporting Services (SSRS) 2008/2005, MS SQL Server Integration Services (SSIS) 2005, DTS, MS SQL Server Analysis Services (SSAS) 2005, Data Transformation Services (DTS), ODBC, OLAP, OLTP, MS SQL Server Enterprise Manager, SQL Query Analyzer, SQL Profiler, Web Services, Office XP, 2000,2007/2010, MS Access, VISIO, T-SQL, E-R Win, ASP.NET, Unix/Linux Shell Scripting, Visual Studio, HTML, XML, ER model, MOSS 2007, ASP.NET, LINQ, Visual Basic 6.0.

Projects Summary:

Confidential, Santa Cruz, CA 8/2009 - 12/2010
MS SQL Developer / SSRS/SSAS/SSIS Developer
Confidential specializes in developing and manufacturing computing, data storage, and networking hardware, designing software and delivering services. Contracts for manufacturers, retailers and distributors of consumer electronics, appliances through a global organization providing innovative business solutions, which operates in all most every country.
The project involved to generate report for product cost planning where you can plan costs for desktop accessories without reference to orders, and set prices for desktop accessories and other cost accounting objects. The project was also involved to design and develop database for SQL server 2008.
Hardware/Software:
MS SQL Server 2005/2008, MS SQL Server Reporting Services 2005/2008, Integration Services (SSIS), DTS, T-SQL,VB, MS Excel, DB2, Access and Excel.

Responsibilities

• Studied the current transactional database in order to understand the existing system and created the approach documents for the migration task.
• Created and documented the mapping of the database objects from source to target database.
• Migrated data from MS SQL Server 2005 to MS SQL Server 2008 using OLE DB connection by creating various SSIS packages.
• Created SQL server configurationsfor theSSISpackages.
• Filtered bad data from legacy system using Derived column, Lookups, Fuzzy Lookups, Conditional split.
• Create store procedure specifically for cleansing data and used the same in SSIS Execute SQL Task.
• Created Complex Stored Procedures, Triggers, Functions, Tables, Views and other T_SQL code and SQL joins to ensure efficient data retrieval.
• Created SQL Agent Jobs for scheduling SSIS Packages, SSRS reports and alerts.
• Configured and fine-tuned all the ETL (Extract, Transform, Load) workflows.
• Created SSIS script task with vb.net code for obtaining parameters from the applications.
• 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 generating sales ranking reports using the migrated data.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Identified and worked with parameters for creating cascading parameterized reports in SSRS 2008.
• Involved in Debugging and Deploying reports on the production server and analyzed reports and fixed bugs in stored procedures on the ongoing database operations, as needed, to resolve business problems.
• Migrated SSAS cubes using the Analysis Services Execute DDL Task and built reports from the cubes.
• Deploying and scheduling Report subscriptions using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Created report models and configured the report builder for building adhoc reports.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler Index Tuning Wizard
• Created SSIS Templates for developing SSIS Packages that can be dynamically deployed into Development, Testing and Production Environments.
• Experienced in critical problem solving, building tools to integrate and manage large sets of data.

Confidential, Miramar, FL 3/2008 - 7/2009
MS SQL Developer / SSRS/SSAS/SSIS Developer
Confidential has developed a custom ERP solution which is implemented for many medium and large scale businesses. TIMS (Task Information Management System) is a task management of products to be shipped. As a developer I was involved in interacting with clients and providing technical support for TIMES database. This also included customizing and developing new reports for customers.
Hardware/Software:
MS SQL Server 2005, ETL, SSIS, SSAS, SSRS, OLTP, T-SQL, Erwin 4.1, Windows XP, MS Access, MS Excel, Microsoft Visual Studio.Net 2005, Visual Source Safe

Responsibilities:

• Studied the functional requirements and specifications. Worked with the DBA and lead to modify the design document for the TIME Database.
• Migrated data from Heterogeneous data Sources and legacy system (DB2, Access, Excel) to centralized SQL Server databases
• Created SQL Server Integration Service (SSIS) packages between enterprise databases and Third party data source to transfer data.
• Created Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules
• Assisted DBA in Experience in implementing Data and Database Security using various Default Database and Server roles and also by creating User-defined as well as Application roles.
• Developed stored procedures and views for managing efficient data retrieval and also for application development
• Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics.
• Defined the report layout and identified Datasets for the report generation.
• Built different types of chart reports using SSRS for the business requirement like column chart, Pie Charts and also created parameterized reports passing parameter through report screen.
• Prepared the Layouts by placing the fields to the appropriate place according to the requirement of the final Report.
• Rendered reports in different formats like pdf, excel etc. to be executed automatically on weekly or monthly basis and managed subscriptions.
• Responsible for deploying the generated reports in Microsoft Share Point.
• Performed some DBA Tasks like checking the jobs that fail and troubleshooting the issues.
• Worked closely with developers, manager and DBA to create the datawarehouse design based on the business process and data representation.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi Dimensional Expression (MDX) to access them.
• Extensively worked on star schema for building the OLAP cubes.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
• Responsible for enhancements and Maintenance of the data warehouse.
• Documented the detailed project layout, systems involved, and all the workflows into Visual Source Safe.

Confidential, Philadelphia, PA 1/2007- 2/2008
MS SQL Developer/BI Developer (SSIS, SSRS, SSAS)
The project is about to create new data warehouse and analyzing various healthcare claims from different markets, applying business rules (HIPPA Rules), error checking and finally sending those claims (837 Extracts) to the state. The major roles in this project were to extract data from different sources including Facets using SQL Query Analyzer and My Eclipse, creating serial files.
Hardware/Software:
Windows 2003, MS SQL Server 2005, ETL, SSIS, OLAP, OLTP, SSAS, SSRS, T-SQL

Responsibilities:

• Worked as a developer on databases like MS SQL Server 2005, MS Access (using DTS, T-SQL, scripts, stored procedures and views).
• Maintained the client relationship by communicating the daily statuses and weekly statuses of the project.
• Managed requests from the clients and from the development teams.
• Designed and developed the Logical and Physical model of the database.
• Increased query performance 30%, 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 automated the regular jobs.
• Managed and monitored the system utilization. .
• Managed the security of the servers (Logins and users).
• Developed complex T-SQL code for the application. .
• Worked on complex data loading (implemented the batch data cleansing and data loading).
• Created SSIS packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations with the use of different transformation like Column, Merge join, Sort, Union all, Conditional Split, look up and more.
• Designed stored procedures for cleansing data after create packages use this store procedure into execute SQL test.
• Created complex queries to automate data profiling process needed to define the structure of the pre staging and staging area.
• Optimized cubes for better query performance and Extracted data from XML files.
• Created reports by dragging data from cube, wrote MDX scripts and create reports by extracting data from cube.
• 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.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases
• Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.

Confidential, OH 5/2005 - 12/2006
MS SQL Server Developer
Commercial & individual banking products and services like online Banking, Bill Pay, and Cash management Services, Telephone Banking round the clock. The main tasks involved a lot of ETL activities through extracting data from various sources and creation of OLAP structures for analysis purposes and reporting purposes.
Hardware/Software:
MS SQL Server 2000, 2005, ETL, SSIS, SSAS, SSRS, OLTP, T-SQL, Erwin 4.1, Windows XP, MS Access, MS Excel

Responsibilities:

• Gathered technical and functional specifications and created the approach documents for the tasks involved.
• Created database objects like tables, views, indexes , triggers and stored procedures.
• Developed stored procedures and views for managing efficient data retrieval
• Wrote various Stored procedures for the purpose of application development
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
• Extensively used SSRS to create reports as per user requirements
• Optimized queries using SQL Profiler and performance monitors to enhance the performance of database servers.
• Performed some DBA Tasks like checking the jobs that fail and troubleshooting the issues.
• Worked closely with developers, end users and Administrator in designing database and creating
• Developed the data warehouse to design the business process data representation, dimensions and fact tables using SQL Analysis services.
• Extensively worked on star schema and snowflake schema
• Responsible for enhancements and Maintenance of the product
• Prepared the detailed project layout, analyzed existing technology involved, and documented work performed and stored in VSS
• Worked in Development, Testing and Production environment

Confidential, Columbus, OH 1/2004 - 5/2005
MS SQL Server Developer/ Reports Developer
Confidential offers a wide variety of health and life insurance products, ranging from hospital and medical insurance policies to Medicare Supplement, from dental insurance to long-term care coverage, and from annuities to whole and term life insurance. The Project was to create accurate and frequent reporting system. Using SQL Server 2000 and SQL server reporting service, was able to cut reportingtime in half and able to make business decisions that increase profitability.
Hardware/Software:
MS SQL Server 2000, SQL Server Reporting Service 2000, DTS ,MS Access 2000, DTS, T-SQL, MS Excel, Agile Methodology.

Responsibilities:

• Actively supported business users for change requests.
• Provided Full Reporting Life Cycle support using SQL Server Reporting Service 2000.
• Responsible for Installation, Configuration, Security, Maintenance, Restoration of SSRS on Windows Server 2003.
• Designed, developed and deployed reports in MS SQL Server environment using SSRS-2000.
• Gauged the effectiveness and efficiency of existing reporting systems. Develop and implement strategies for improving and further leveraging these reports in order to transfer/convert existing Reports to SQL Server Reporting Service.
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance.
• Performed Report Testing and Verification as per Internal Reporting system requirements.
• Administrated interface to organize reports and data sources, schedule report execution and delivery, subscription of reports and track reporting history.
• Generated Daily, Weekly and Monthly Trigger based reports regarding assigned projects to designated Managers and Clients.
• Applied Security to Web Server and Database Server that affects Report server installation. Manage role-based security to reports and reporting resources.
• Responsible for back up and Restoration of SQL Reporting Service.
• Provided Documentation support on SSRS 2000 as assigned.

Confidential, Hyderabad, India5/2003 - 11/2003
Junior SQL Server/Application Developer
Confidential provides different financial services. The scope of the project that worked on was to facilitate in the maintenance and development of the application, which supported personal banking on wealth management, asset management dealing with different types of accounts and services.
Hardware/Software:
MS SQL Server 2000, T-SQL, DTS, SQL Server Enterprise Manager, SQL Server Query Analyzer

Responsibilities:

• Involved in entire life cycle including database design, development, testing, optimizing and deploying on development and production servers.
• Responsible for creating the tables, views, stored procedures, triggers.
• Participated in creating indexes to improve the performance of database.
• Created Constraints, Defaults and Views.
• Active part in performance tuning and query optimization.
• Generated reports using Crystal reports.
• Used Data transformation Services (DTS) to export and import data.
• Assisted in taking database backup and restore.
• Used SQL server profiler to troubleshoot the problems.
• Involved in creating users and assigning permissions to access the database.