Summary:

• 7 + years of experience in IT industry as a SQL Developer.
• Expert in MS SQL Server suite of products like SSRS, SSIS of MS SQL Server 2005/2008 and in addition SQL server 2000.
• Excellent knowledge in RDBMS concepts and constructs along with database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers in T-SQL.
• Well versed in defining Data sources for creating Data Source views.
• Experienced in data loads, database integration/conversations, performance tuning and optimization.
• Hands on experienced in troubleshooting database issues in T-SQL (DDL and DML).
• Experienced in Data Modeling Relational, Multi-Dimensional Modeling and involved in creation of Star Schema and Snowflake dimensional schema using Erwin data modeling tool.
• Experienced in Performance tuning, Query Optimization and running database.
• Worked on administrative tasks such as data loading, batch jobs, data unloading, backup and Recovery, user and application table management, upgrades, creating databases/File groups/files/Transaction logs.
• Expert in ETL and Data warehousing.
• Expert in using tools such as Bulk copy (BCP) and Data Transformation Service (DTS) and SSIS with SQL server 2000/2005.
• Design and developed SSIS (ETL).
• Proficient in creating SQL server report, handling sub reports and defining query for generating drill down reports using SSRS 2005/2008.
• Experienced in creating SSIS and DTS packages for ETL purposes.
• Extracted and transferred source data from different databases like OLEDB providers like DB2,

MS Access, Flat File, Excel, Oracle and Automate the ETL.

• Provided technical support to internal developer and meet standards of Client.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possesses strong analytical skills.

Professional Experience:

Confidential,CA May 2010- current
MS SQL Server/SSIS Developer
Bank of America (BOA) is an American global financial services company, the largest bank holding company in the United States, by assets, and by capitalization. Bank of America serves clients in more than 150 countries. The company is a member of the federal Deposit Insurance Corporation and the component of both the S&P 500 Index and the Dow Jones Industrial Average. The project is to create SSIS packages, for migrating data to Data Warehouse and generating reports by extracting data from data warehouse for different Investors during a month end close.
Responsibilities:

• Designed SSIS Packages to transfer data between servers, load data into database, archive data file from different sources using SQL Enterprise Manager/SSMS on SQL Server 2005 environment, and deploy the data; scheduled the jobs to do these tasks periodically.
• Work on development of Data mart and different SSIS packages to load staging, fact, dimension and metric data into data mart.
• Responsible for creating Packages using SSIS which compared two different files
• Added configure files to Packages, so that various properties like variables, connection managers could be changed when moving the Package from one environment to another.
• Created Log Files so that in case of Package failures the errors could be trouble-shooted.
• Created Script tasks to check for existence of Source files for a specified amount of time.
• Responsible for maintaining and scheduling Packages.
• Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting.
• Migrate / redevelop Data Transformation Services (DTS 2000) packages to SSIS 2005/2008 for server enhancement.
• Designed ETL architecture for overall data transfer from source server to the enterprise services warehouse.
• Created SSIS packages to load customer information from flat file.
• Have a very Good Experience with all the Control Flow and Data Flow tasks in SSIS.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, data dictionary and Metadata using SSIS.
• Provided technical support to internal developers and external clients.
• Worked with financial systems team members to document systems and process environments.
• Created Technical and Functional documents including detailed description and screenshots showing functioning of the package.
• Administered SQL Server security, SQL server automatic e-mail notification and SQL Server backup strategy and automation.
• Responsible for elevating and automating successful code to production environment

Environment:
MS SQL Server 2005/2008, MS SQL Integration Services 2005/2008, Reporting Services(SSRS), Analysis Services(SSAS), Visual Studio 2008, VB.Net, C#, .Net Framework 3.5, DTS, T-SQL, PL/SQL, MS Visio, MS Access 2003, VB.Net, MS Excel, Window XP, MS word, Oracle 8i/9i.

Confidential,LLC, NJ March 2009-April 2010
MS SQL Server Developer
Core Pharma is a US based developer, manufacturer and marketer of highly quality, targeted, generic prescription pharmaceuticals. The Project was built to facilitate the data warehousing of various business departments like sales, inventory management, budgeting, Production and Forecasting.
Responsibilities:

• Used multiple join statements to retrieve data from multiple tables.
• Performed backup/restore, database objects such as tables, stored procedures, triggers, constraint, indexes and views.
• Created SQL server Reports using SSRS 2005 from initial stage.
• Worked with business analysts to identify, design and implemented solutions for extraction and integration of data to and from databases and data marts for the purposes of data extraction and reporting using SSRS and SSIS.
• Used highly complex T-SQL Queries and SQL Scripts to perform effective data load based complex business rules and provided backend SQL support.
• Created clustered indexes and optimized various T-SQL queries and done performance tuning using execution plan.
• Created SSIS packages using different talks and transformations and moved data from various sources to appropriate destinations.
• Used SSIS Import/Export Wizard, for performing the ETL operations.
• Extracted data using SSIS from OLTP to OLAP. Based on required reports, identified various data sources and established the connections using SSIS and constructed data source view.
• Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirement.
• Responsible for testing to optimize the procedures and triggers to be used in production.
• Involved in project planning also schedule for database module with project managers.

Environment:
MS SQL server 2005/2008, MS SQL Reporting Service(SSRS), MS SQL Integration Service(SSIS), Visual Studio 2005/2008, C#, .Net Framework 3.5, XML, MS Excel, T-SQL, VB.Net, PL/SQL, MS Access, MS Word, MS Visio, IIS 6.0, Windows 2000/ XP/2003,Visual Basic.

Confidential,Greenwich, CT June 2008 – Feb 2009
MS SQL Server/ SSRS Developer
Paloma Partner is one of the hedge funding groups. Its clients are spread all over Europe, Australia, Asia and America. Project was to develop interactive reports using SSRS from scratch and setup whole report server over testing and production environment.
Responsibilities:

• Configured report server in development and production.
• Configured IIS web configuration for report server web pages.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Developed stored procedures and triggers in T-SQL
• Created and deployed report RDLs in the Visual Studio 2005 as per requirements.
• Responsible for monitor and tuning report performance.
• Created and scheduled report history according to business requirement.
• Responsible for documentation for building new application layer over reports by using Visual studio 2005.
• Designed and maintained data caching in report server by using SSMS and Report Manager.
• Configured report manager and report builder.
• Planned, defined and designed data based on the business requirement.
• Responsible for documentation of various business activities.

Environment:
MS SQL Server 2000/2005, MS Access, MS SQL Reporting Service 2005(SSRS), MS SQL Integration Service 2005, MS SQL Analysis Service 2005, Business Objects, Crystal reports, MS Excel, C# 2005, Visual Studio 2005, Oracle 8i/9i/10g, MS Visio.

Confidential,Boston, MA Oct 2006 – May 2008
MS SQL Developer
Boston based Liberty Mutual Group is diversified global insurer and sixth largest property and casualty insurer in the United States. Based on 2005 direct written premium the Company also ranks 95th on the fortune 500 list of the largest corporations in the U.S. Project was about to create parameterized and drill down reports using global variables and functions and deployed generated reports on client’s workstation.
Responsibilities:

• Actively supported business users for change in requests.
• Extensively used T-SQL to manipulate and architect to produce results for users.
• Created stored procedures, views, triggers, users defined function to incorporate the flow of business and called various stored procedures from DTS to make the flow of DTS effective.
• Performed backup/restore, database objects such as tables, procedures, triggers, constraint, indexes and views.
• Involved in writing Query for generating drill down reports, identified and worked with the parameters to generate parameterized reports along with that extensively used global variables, expressions and functions.
• Created various DTS package for data transfer and migration.
• Analyzed reports and fixed bugs in stored procedures on the ongoing database operations, as needed, to resolve business problems.
• Created complex Stored Procedures, views, Triggers, Tables and other T-SQL joins.
• Responsible for deploying the generated reports directly on client’s work stations.
• Maintained data integrity by performing validation checks.
• Created clustered indexes and optimized various T-SQL queries and done performance tuning using execution plan.

Environment:
MS SQL Server 2000/2005, T-SQL, Windows 2000/2003, SSRS, SSIS, MS Word, MS Excel, SQL Query Analyzer, .Net framework, MS Visio 2000.

Confidential,Bangalore, INDIA June 2003 – August 2006
MS SQL Server Developer
Infosys Technologies Limited is a multinational information technology Services Company headquartered in Bangalore, India. It is one of India\'s largest IT Company. As part of team I worked with multiple clients including Citigroup & JPMCHASE. As part of development team, I involved in developing DTS packages, Stored Procedures & XML.
Responsibilities:

• Created Database Objects in TSQL - Tables, Indexes, Views, and Roles.
• Created Customized Stored Procedures, Triggers, and Cursors.
• Involved in job scheduling using MS SQL server Agent.
• Prepare and set up environment for Disaster recovery.
• Transformation of data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS).
• Data conversions from legacy systems to SQL server Using DTS.
• Wrote DTS scripts for data transfer.
• Responsibilities also included transferring of customer, personal financial history information from various ODBC driver files to SQL server database files using DTS.
• Performed Data transfer (Import & Export) using BCP.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using Execution Plan.
• Generated Daily, Weekly and Monthly reports for the analysis of managers and end users.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Designed index, statistics and optimized queries by using execution plan for performance tuning of the database.

Environment:
MS SQL Server 2000, XML, T-SQL, Stored Procedures, C

Educational Qualification:

Bachelor of Engineering .