Professional Summary

• Over 8+ years of experience in IT including 6+ years as MS SQL Server 2008R2/2008/2005/2000/7.0 Database Developer and 17 Months of experience as a Oracle8i/11G Developer in Windows environments.
• Experience in Data Modeling and Database Architecture based on functional requirements and system design of the client using RDBMS concepts and constructs.
• Strong RDBMS concepts including expertise in Transact-SQL queries like DML, DDL, Stored Procedures, Views, User Defined Functions (UDF), Triggers, Cursors etc.
• Hands on Optimization of code and efficiency in databases including Re-Indexing, updating statistics, Recompiling Stored procedure.
• Experience in MS-SQL including SSIS and Data Transformation Services (DTS).
• Experience in design and development of reports using Crystal Reports 9.0/8.0 and SQL Server Reporting Services (SSRS) 2005/2008.
• Experience in designing reports for the end user using SQL Server Reporting Services (SSRS) and creating multiple reports in Drill mode using Tables, Financial tables, Cross tabs, Matrix type reports and Charts using SSRS.
• Strong experienced in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL Server Integration Service (SSIS).
• Experience in Creating Cubes and MDX Queries.
• Good knowledge of defining and deploying Cubes using MS SQL Server 2005/2008 Analysis Services (SSAS).
• Experience in Transformations like - Look Up, Filter, Joiner, Source qualifier, router etc…
• Good experience in analyzing the Performance Issues and Fine Tuning the Transact-SQL queries, stored procedures and Functions.
• Proficient in Maintenance and optimization of Database and Server using various SQL tools (SQL Profiler, Indexes, Statistics, File Groups and DBCC).
• Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools like SSIS, Data Transformation Services (DTS), Bulk Insert, BCP, XML.
• Good experience in creating Jobs, SQL Mail Agent, Alerts and Schedule SSIS, DTS Packages.
• Involved on administration tasks such as Data Loading, Batch Jobs, Backup and Recovery, Creating Databases, Files, File groups and Transaction logs.
• Involved in Creating/Updating of Database Full setup in Production Environments and Test Environments.
• A well-organized, goal-oriented, highly-motivated effective team member with excellent analytical, troubleshooting, and problem solving Skill.
• Provided primary level support for Frontend application using C#.Net (3.0), VB.Net.
• Experience with Source Control Management tool i.e. TortoiseSVN.

Education:

Bachelors of Science, Andhra University, India.

Masters of Science, Andhra University, India.

Technical Skills

RDBMS/DBMS : MS-SQL Server, 2008 R2, 2008, 2005, 2000 & 7.0, Oracle 8i, 11G,
My SQL, MS Access
Database Technologies/Tools: SQL Server Entreprise Manager, SQL, SSIS, SSRS, SSAS, T-SQL, Data Transformation Services (DTS), DBCC, BCP, Informatica.
Reporting Tools : Crystal Reports.
Operating Systems : Windows XP, 2000, 2003, 2008.
Programming Languages : Visual Studio, C#.Net (3.0), T-SQL
Internet Technologies/Tools : XML, FTP, TCP/IP, LAN, WAN, MS Office Professional.

Professional Experience

Confidential East Brunswick, NewJersy, USA Aug 10 – Till Date
Project: Ceres – Timesheet and Pay roll Process
Role: SQL Server/SSIS/SSRS/SSAS Developer

Ceres Terminals Incorporated’s proven business performance has been the true test of our ability to deliver the best services at a reasonable price. Ceres’ experience and operational diversity is unsurpassed as stevedores, container/cargo handlers and terminal operators. Growth-oriented and financially sound, we are dedicated to providing the highest quality, most reliable, cost-effective stevedoring, terminal operations and ancillary services available in the business of transportation. Ceres’ progressive vision and outstanding reputation for leadership has distinguished the company as one of the best in the industry. Ceres Terminals Incorporated operates as a stand-alone company in the Harbor Division of the NYK Group. Ceres is ISO 9001:2008 Certified in all of its Major Port Operations.

Responsibilities:

• Involved in complete life cycle of Timesheet and Pay roll process including design, development and testing.
• Applied various types of Control Flow tasks and Data Flow tasks like Container, Execute task, Script task, Transfer For Loop Container, Aggregate, Derived column and Transfer Database Task according to need of Data Transform and Data Cleansing and insert new data into Database using SSIS 2008 R2.
• Developed and created the new database objects including tables, views, index, stored procedures and functions,Advanced queries and also updated statistics using Query Analyzer and Enterprise Manager on the existing servers.
• Defined check constraints, rules, indexes and views based on business requirement.
• Create and Execute the Stored Procedures, Views, User Define Functions and Complex Queries.
• Developed Tablix Reports, Matrix Reports, Parameterized Reports, Sub reports using SQL Server Reporting Services 2008(SSRS).
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Created Data warehouse environment for OLAP & Data mining in SSAS
• Experience in creating adhoc reports Using Report Builder 1.0 and Report Builder 2.0.
• Imported the huge text files, CSV files data from FTP through SSIS to local environment.
• Migrated XML data file, Flat file into SQL Server.
• Use SSIS script task using vb.net and C# Script to create XML File and Flat File.
• Worked with SSIS to load data files to SQL Server and the other way. Maintaining the data, database Backups and Restoration, backup strategies, scheduling backups.
• Deployed the SSIS Setup and Database Setup in production environments.
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL
• Optimized the performance of queries with modification in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created Clustered/Non-Clustered indexes wherever necessary.
• Create Batch File, checkpoint file and Logging file for Data Integrity.
• Create Standard Tabular and List Report for Management Purpose.
• Create Temporary Table and Common Table Expression (CTE) for query Optimization.
• Create Jobs using SQL Agent to run SSIS Package from Server.
• Use ADO.net to connect SQL Server with application.
• Backing up master & system databases and restoring them when necessary. Supported production environment.
• Deployment of Scripts in Production and Test environments.
• Resolved Bugs in production Environment created by Quality Assurance.
• Reporting on a weekly basis to the project manager.

Environment: Microsoft SQL Server 2008, SSIS, SSRS, SSAS, Crystal Reports, MDX, XML, ETL, OLTP, OLAP, FTP, ASP.Net, C#, VB.Net, SQL Profiler, Java Script, Windows XP and TortoiseSVN.

Confidential, Mobile, Alabama, USA Nov 08 – Jul 10
Project: Injury Claims Management System (ICMS)
Role: SQL Server/SSIS/SSRS/SSAS Developer

Confidential is a leading provider of value added services related to workers’ compensation, both for injured Workers and their Insurers, to ensure timely and effective service to the injured worker, at the same time minimizing cost to their Insurers. CMI has been in business for more than 25 years and has grown to serve about 200 Clients presently.

Responsibilities:

• Actively involved as part of a team for gathering and analyzing the needs of End User Requirement and Online System Specification.
• Involved in ER diagrams and mapping the data into database objects.
• Developed and created the new database objects including tables, views, index, stored procedures and functions,Advanced queries and also updated statistics using Query Analyzer and Enterprise Manager on the existing servers.
• Generated Monthly and quarterly Reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS.
• Generated pivot tables using the cube data in SSAS and delivered reports using SSRS by using the connection string as SSAS.
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS
• Defined check constraints, rules, indexes and views based on business requirement.
• Involved in creating Data mappings in SSIS and created data models using ERWIN tool.
• Create and Execute the Stored Procedures, Views, User Define Functions and Complex Queries.
• Imported the huge text files, CSV files data from FTP through SSIS to local environment.
• Applied various types of Control Flow tasks and Data Flow tasks like Container, Execute task, Script task, Transfer For Loop Container, Aggregate, Derived column and Transfer Database Task according to need of Data Transform and Data Cleansing and insert new data into Database using SSIS 2005 R2.
• Use SSIS script task using vb.net and C# Script to create XML File and Flat File.
• Migrated XML data file, Flat file into SQL Server.
• Worked with SSIS to load data files to SQL Server and the other way. Maintaining the data, database Backups and Restoration, backup strategies, scheduling backups.
• Deployed the SSIS Setup and Database Setup in production environments.
• Optimized the performance of queries with modification in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created Clustered/Non-Clustered indexes wherever necessary.
• Create Batch File, checkpoint file and Logging file for Data Integrity.
• Create Standard Tabular and List Report for Management Purpose.
• Create Temporary Table and Common Table Expression (CTE) for query Optimization.
• Use XML task, Web services task to create flat file Interface.
• Create Jobs using SQL Agent to run SSIS Package from Server.
• Did numerous databases full, transactional, and differential backup and restore for the purpose of testing the scripts.
• Job Monitoring and making sure all jobs ran successfully every night
• Backing up master & system databases and restoring them when necessary. Supported production environment.
• Deployment of Scripts in Production and Test environments.
• Reporting on a weekly basis to the project manager.
• Resolved Bugs in production Environment created by Quality Assurance.

Environment: Microsoft SQL Server 2005, SSIS, SSRS, SSAS, Crystal Reports, ASP.Net, C#, VB.Net, SQL Profiler, Java Script, Windows XP and TortoiseSVN.

Bank Confidential Indonesia May 07 – Oct 08
Project: Banking Transactions Information System
Role: SQL Server, SSIS and Informatica Developer

Bank’s initial goal is – to build the capability to better analyze the bank’s accounts. The designing system will help the management to achieve their goal. The major objective is to market more effectively by offering additional products to households that already have one or more accounts with the bank.

Responsibilities:

• Extensively involved in data Extraction, Transmission and Loading (ETL) from source to target systems.
• Actively involved as part of a team for gathering and analyzing the needs of End User Requirement and Online System Specification.
• Used star schema to populate the data.
• Identification of various data sources and development environment.
• Used different ETL transformations like Look Up, Filter, Joiner, Source qualifier, router etc…
• Scheduled sessions to update the target data using work flow manager.
• Developed Cubes and written MDX queries to analyze the data.
• Developed and created the new database objects including tables, views, index, stored procedures and functions,

Advanced queries and also updated statistics using Query Analyzer and Enterprise Manager on the existing servers.

• Defined check constraints, rules, indexes and views based on business requirement.
• Create and Execute the Stored Procedures, Views, User Define Functions and Complex Queries.
• Migrated XML data file, Flat file into SQL Server.
• Optimized the performance of queries with modification in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created Clustered/Non-Clustered indexes wherever necessary.
• Create Standard Tabular and List Report for Management Purpose.
• Create Temporary Table and Common Table Expression (CTE) for query Optimization.
• Create Jobs using SQL Agent.
• Use ADO.net to connect SQL Server with application.
• Job Monitoring and making sure all jobs ran successfully every night
• Resolved Bugs in production Environment created by Quality Assurance.
• Backing up master & system databases and restoring them when necessary. Supported production environment.
• Reporting on a weekly basis to the project manager.
• Deployment of SQL Scripts, SSIS setup in Production and Test environments.

Environment: Microsoft SQL Server 2000, SSIS, ETL-Informatica, Cubes, MDX Queries, Visual Studio 2000, SQL Profiler, Windows XP and TortoiseSVN.

Confidential UK Jan 06 – Apr 07
Project: BrightHouse
Role: Oracle Developer

IRIS is a software application used by all Bright House stores for the purpose of managing our in-store operations, the handling of customer payments and reporting. Bright House is the sole owner of the IRIS software and associated intellectual property rights IRIS itself is accessible via a Windows-based GUI interface and is controlled by a series of drop-down menus and icons covering all key functionality.

Responsibilities:

• Actively involved as part of a team for gathering and analyzing the needs of End User Requirement and Online System Specification.
• Involved in ER diagrams and mapping the data into database objects.
• Developed and created the new database objects including tables, views, index, stored procedures and functionsand advanced queries.
• Modify and added check constraints, rules, indexes and views based on business requirement.
• Create and Execute the Stored Procedures, Views, User Define Functions and Complex Queries.
• Optimized the performance of queries with modification in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created Clustered/Non-Clustered indexes wherever necessary.
• Create Standard Tabular and List Report for Management Purpose.
• Backing up master & system databases and restoring them when necessary. Supported production environment.
• Create and Execute the Stored Procedures and Complex Queries for Reports.
• Deployment of Scripts in Production and Test environments.
• Reporting on a weekly basis to the project manager.
• Resolved Bugs in production Environment created by Quality Assurance.
• Reporting on a weekly basis to the project manager.

Environment: Oracle 11G, JAVA IceFaces, spring, Hibernate, Jasper, Web Services, Windows XP and TortoiseSVN.

Confidential UK Sep 04 – Dec 05
Project: AON
Role: SQL Server Developer

The aim of this project is to develop a web based application for the business requirements of AON Tree Insurance. Line of business deals with insurance of property, that is the plant and equipment associated with timber processing.
This application will provide different policy coverage’s like Fire, Fire & Storm on different crops and the premium calculation will get differ based on that. Premium calculations involves
Sum insured, total gross premium, insured crop premium, Property owners liability etc..
This web-based application will be externally hosted and supported by Aon and will be used by Agents and Broker (AON). This application will have various functions/features like creating new quotes, submission, batch processing, quote selection, binding, document production, correspondence, mid-term adjustments, Upload bounded policy and bordereaux/reporting.

Responsibilities:

• Migrated database from old database schemas to new database schemas.
• Actively involved as part of a team for gathering and analyzing the needs of End User Requirement and Online System Specification.
• Optimized the performance of queries with modification in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created clustered/non-clustered indexes wherever necessary.
• Actively involved in creation of database, modified tables, triggers, procedures to clean and validate the data about the table layout, so as to meet the company specifications.
• Create and Execute the Stored Procedures and Complex Queries for Reports.
• Maintaining the data, database backups and restoration, backup strategies, scheduling backups.
• Backing up master & system databases and restoring them when necessary. Supported production environment.
• Reporting on a weekly basis to the project manager.
• Created stored procedures, Views, Functions using SQL Query Analyzer for the fast retrieval of the data and manipulate data using ADO.NET.
• Did numerous databases full, transactional, and differential backup and restore for the purpose of testing the scripts.
• Resolved Bugs in production Environment created by Quality Assurance.
• Deployment of Scripts in Production and Test environments.
• Reporting on a weekly basis to the project manager.

Environment: Microsoft SQL Server 2000, ASP.Net, C#, SQL Profiler, Java Script, Windows XP and TortoiseSVN.

Confidential Nov 03 – Aug 04
Project: Bloodstock
Role: SQL Server Developer

The Willis Group is one of the world's largest professional services firms specializing in risk management. Our experienced and highly knowledgeable employees provide a wide range of strategic and operational risk management services across all industries, worldwide.

This web-based application will be externally hosted and supported by Willis and will be used by Agents, Broker (Willis), Underwriter and 2nd pair of eyes. This Bloodstock application will provide the insurance on horse’s blood. In this application we captured insured person details, horse details like – name, sire, dam, breed etc... And total sum insured brokerage amount, midterm adjustment details, renewals and reports.

Responsibilities:

• Passed through all phases of SDLC according to Business Needs and analyzed requirements.
• Installed MS SQL Server 2000 and Configured MS SQL Server 2000 requirements on Windows XP Professional Edition server.
• Actively involved in creation of database, modified tables, triggers, procedures to clean and validate the data about the table layout, so as to meet the company specifications.
• Transformed various text based files, Excel spreadsheets, and Access to SQL Server databases using OPEN ROWSET and BCP.
• Created Stored Procedures that generated Reports according to Business needs and load them on to servers.
• Passed through Testing of Queries along with T-SQL Commands, Stored Proc, Views and Joins and Triggers and modified them as far as they needed on Database on Server Side.
• Passed through Performing and Tuning of Different Queries and Stored Procedures to increase performance and Decrease run time of Queries and Stored Procedures by using SQL Profiler.
• Optimized Indexes on columns by analyzing them by using Index tuning wizard.
• Used DDL and DML to writing Triggers, Stored procedures to check the Data Integrity.
• Created clustered/non clustered Indexes for fast and efficient reporting process.
• Analyzed the tuned Database Growth and Space Requirement as data were growing day by day.
• Extensively use Import/Export wizard to convert T- SQL Queries, Data and Reports from different forms like XML file, MS Excel file, TTF file, PDF file and other formats to SQL data type and Vice versa.
• Resolved Bugs in production Environment created by Quality Assurance.
• Deployment of Scripts in Production and Test environments.
• Reporting on a weekly basis to the project manager.

Environment: Microsoft SQL Server 2000, ASP.Net, C#, SQL Profiler, Java Script, Windows XP and TortoiseSVN.