SUMMARY

• 8 years of experience as Database Developer in the analysis, design, development, implementation, testing, and maintenance of application systems in Client Server environments.
• Expert in planning, modeling, designing, developing, implementing, administering, and maintaining Microsoft SQL Server 2008, 2005, 2000 and Oracle 8i, 9i, 10G, 11G databases.
• Highly proficient in the use of T - SQL and PL/SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions, Relational Database models and Data integrity, and SQL joins.
• Excellent experience in creating indexes, indexed views, in observing business rules and creating effective functions and appropriate triggers to assist efficient data manipulation and data consistency.
• Experienced in Logical and Physical Database design & development, Data Conversion, Normalization and Data modeling using Power Designer and SQL Server Enterprise manager.
• Experienced in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous Systems using SSIS of MS SQL Server 2005/2008.
• Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using Bulk Copy Process (BCP), Data Transformation Services (DTS) and SSIS with MS SQL 2008/2005.
• Experienced in creating many complex SSIS packages with complicated transformations using SQL Server Integration Services.
• Experienced in normalizing databases for OLTP environments and de-normalizing tables for use in OLAP environments.
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, dimensional modeling and reporting tools, worked with high volume databases with partitioned data.

TECHNICAL SKILLS

Databases: MS SQL Server 6.5, 2000, 2005, 2008; Oracle 7.3, 8, 9i, 10g; MySQL, Sybase Adaptive Server Enterprise 11.5; Informix 7.2; Microsoft Access

Data Modeling: Sybase PowerDesigner DataArchitect, Embarcadero ER/Studio

Software: Visual Studio 2008, MS Office, Crystal Reports 8, 9, 10, XI

Languages: Delphi, C#, VB.NET, SQL, PL/SQL, HTML, CSS, PHP, Ruby

Systems: Windows (95 through 7), Windows Server (NT through 2008 R2)

Virtualization: VMware vSphere 4.1, VMware Workstation (6.5 - 8), Microsoft Hyper-V

PROFESSIONAL EXPERIENCE

Confidential, CO

Database Developer

Responsibilities:

• Developed PL/SQL packages for data access layer. Helped access the PL/SQL subprograms from the VB.NET/ASP.NET application.
• Wrote complex SQL queries to retrieve data for the applications.
• Fixing defects related to PL/SQL packages, procedures, and functions.
• Unit testing of PL/SQL packages, procedures, and functions. Debugging of PL/SQL sub-programs from ASP.NET web front end application.
• Rewrote queries to improve performance.
• Rewrote PL/SQL code using BULK COLLECT, FOR ALL to improve PL/SQL performance.
• Converted PL/SQL procedures and functions to PL/SQL table functions.
• Developed testing programs using Selenium to automate testing of web application pages and functionality.
• Coordinated and assisted Front-End Developers in detecting and resolving the bugs.

Environment: Oracle 10G R2, Oracle SQL, PL/SQL, SQ*Plus, Toad 11, Microsoft Visual Studio 2008, SQL Server 2005, Microsoft Team Foundation Server

Confidential, Hillside, IL

SQL SEVER BI DEVELOPER

Responsibilities:

• Migrated DTS 2000 packages to SQL Server Integration Services (SSIS) and modified the packages using the advanced features of SQL Server Integration Service.
• Extracting and transforming data using Import/Export Data, Bulk Insert, BCP, and SSIS Packages
• Modified triggers and dynamic cursors, stored procedures to check the conversion errors in T-SQL
• Performed optimization of query, cursor and stored procedures, their testing focusing on stability and execution plan which has resulted up to 45% increase in performance of numerous modules.
• Created jobs for SSIS packages to transform daily, weekly and monthly jobs
• Used various SSIS tasks such as Conditional Split, Derived Column which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse
• Created SSIS packages to export and import data from CSV files, Text files and Excel Spreadsheets
• Enhanced performance using optimization techniques-normalization, indexing and Transaction Isolation levels

Environment: SQL Server 2008 Enterprise Edition, Visual Studio 2008, T-SQL, SQL Server 2008 Management Studio, SQL Query Analyzer, Enterprise Manager, and SQL Agent

Confidential, Hartford, CT

MS SQL Server SSIS/SSRS Developer

Responsibilities:

• Used the SSIS to migrate databases such as Excel files, flat files and SQL Server database to centralized IT destination.
• Assist data modeler to create tables needed for ETL processing and develop ETL framework.
• Involved in developing, monitoring and deploying SSIS packages and successfully created dynamic configuration packages in SSIS.
• Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view during extraction of data.
• Used SSIS transformations to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Generated reports on account information, detailed summary reports using ad-hoc reporting to be used by the clients and advisors.
• Created many complex database code objects such as stored procedures, views, and functions and used them in Reports directly.
• Created Queries in T-SQL, Stored Procedures, and Views to store the data of clients, advisors.
• Created User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updates to improve the query performance.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2005.

Environment: MS SQL Server 2005, SSIS, SSRS, T-SQL, Visual Studio 2005, Business Intelligence Development Studio, MS Office 2007, SQL Profiler

Confidential, Mettawa, Illinois

MS SQL Server/SSIS Developer

Responsibilities:

• Designing standards for the database tables, columns, procedures and views.
• Created Database, creating tables, views, indexes, stored procedures, triggers and constraints.
• Analyzed the requirements and fine tune the stored procedures to improve performance.
• Data transferred between various servers using BCP and SSIS in SQL Server Integration Services.
• Implemented Data Transformation Services Packages in SQL Server Integration Services (SSIS) for transferring data and Data Loads.
• Involved in writing T-SQL programming for implanting stored procedures and functions for different tasks.
• Involved in Query Optimization using extensive use of Index implementation and Index Tuning Wizard SQL Server 2005.
• Used profiler to find badly performing queries and deadlocks.
• Tuned SQL queries using execution plans.
• Used SSRS to write complex formulas and to query the database different to generate different types of ad-hoc reports.
• Created Database Maintenance Planner for the performance of SQL Server 2005, which covers Database Integrity checks, Database Statistics update.
• Created views to facilitate easy user interface implementation and triggers on them to facilitate consistent data entry into the database.
• Worked on DTS Packages in SQL Server Integration Services (SSIS), DTS Import/Export for transferring data from heterogeneous database.
• Generated ad-hoc reports using MS-Access and Crystal Reports.

Environment: MS SQL Server 2005, T-SQL, MS Excel, MS Access, Crystal Reports 10.0 and Windows NT, ASP.Net, Visual Basic, SQL Server Integration Services, SQL Server Reporting Services

Confidential, Bronx, NY

SQL SEVER BI DEVELOPER

Responsibilities:

• Developed database tables satisfying the 3rd Normal form, and complying with referential integrities.
• Scheduled reports for daily, weekly, monthly reports for executives
• Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Designed and Developed parametric Reports, Cross-Tabbed and Sub-Reports in SSRS 2005.
• Generated reports using the Crystal Reports and Reporting Services 2005.
• Migrated reports from Crystal Reports to SSRS reports.
• Conducted data migration processes in the SQL Server environment using SQL Server Integration Services.
• Developed SSIS packages to conduct simple and complex transformations, and executed these packages using the execution package.
• Conversion of DTS packages from SQL Server 2000 into SSIS packages SQL Server 2005.
• Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Extensive use of T-SQL DDL and DML commands for various applications.

Environment: SQL Server 2005/2000, SSIS, SSRS, DTS, BCP, T-SQL, .Net, ADO.Net, MS-Excel, Visual Studio 2005, XML