Summary:

• Over 14 years of IT Industry experience in client-server applications, worked as Application Developer in Java 1.2, Database Developer in Oracle 8i/10g/11g and in SQL Server2000/2005/2008R2.
• Experience in Installation, Configuration and Maintenance of SQL Servers 2000/2005/2008R2 and Oracle8i. Experience in configuring and managing Linked Servers.
• Experience in Data Architecture, Data Analysis for OLTP systems, Data Modeling and Data Warehousing applications.
• Experience in designing DFD's, Flow Charts, Conceptual, Logical and Physical Data Models.
• Experience in ETL Process, used Informatica 5.7, SQL Server 2000 DTS and SQL Server 2008 R2 SSIS .
• Designed ETL package to load data from CSV, Excel, Oracle, SQL Servers databases to SQL Server and Oracle database using DTS SQL2000 and Microsoft SQL Server Integration Services SSIS Tool .
• Good understanding of SQL Server Internals Relational Engine, Storage Engine, and Buffer Pool .
• Expert in performance optimization query tuning , studying execution plan, statistics, table fragmentation.
• Experience with SQL Server DMV's, DMF's, DBCC Utilities, SQL Profiler and Performance Monitor.
• Expert programmer in Transact-SQL, Stored Procedures, Functions, Database Triggers and SQL Server2008 New Data type Hierarchy ID. Exclusively worked on Dynamic SQL coding.
• Over 9 years of development experience in Oracle 8i/9i/10g//11g writing PL/SQL Block, Queries, and Packages . Proficient in Oracle Tools and Utilities such as SQL Plus, SQL Loader, TOAD and SQL Navigator.
• 5 years of programming experience in Java and XML. Generated statistical analysis reports for Mgmt.
• Worked with Source Control Management like TFS and SVN and Task Management Tool like Jira.
• Exposure in overall SDLC and Agile processes. Ability to work independently as well as work with teams having varying backgrounds on complex issues and have strong verbal and written communication skills.

Technical Skills:

Professional Experience:

Confidential

Sr. SQL/SSIS Developer

• Worked in GWIM Technology team, Global Wealth Investment Management provides comprehensive wealth management to affluent and high-net-worth clients.
• Involved in two major tasks: 1. Data Migration 2. Understanding and tuning existing stored procedures.
• Involved in understanding existing requirements plus gathering new requirements from Business Analyst and Business Users converting them into low level design documentation.
• Map the requirements to process-flow, designed flow charts, data flow diagrams DFD's , Logical and Physical Model.
• Conducted team meetings involved Project Manager, Database developers and Off-Shore development team. We followed agile methodology.
• As part of Data Migration process, migrated Client's Data in phases from one Data Center to Internal Bank Data Center through ETL process. Analyzed existing data, database objects, identified bottle necks. Prepared the DFD's, documentation and test case scenarios.
• Trained team members to evaluate and provide error free data migration solution. Took complete responsibility of the project.
• Identified the slowing running queries, by running the SQL Profiler captured the SQL's statements, studied the E-Plan. Applied recommended indexes, removed redundant code and replaced with optimized SQL queries/statements.
• Created database maintenance plans, tuning database transaction log files, schedule jobs to rebuild indexes daily for few heavily used transaction tables.
• Designed SSIS packages to copy data from production server to development server to trouble shoot emergency QC's. Used different tasks, transformations, containers and source/destination components to create SSIS packages ETL process .
• Extract data from access, excel, flat file, and different databases and load in SQL base tables using SSIS packages ETL process . This package is part of clients nightly feed data load process.

Technologies used: SQL Server 2008 R2, SSIS, Transact-SQL, Stored Producers, Functions, MS-Word, MS-Access, MS-Visio, Windows 2008 Server.

Confidential

Sr. SQL/BI Developer

• International SOS is the world's leading international healthcare, medical assistance, and security services. Help organizations manage the health and security risks facing their international travelers and expatriates.
• I was involved in existing system optimization database objects tuning , designing Excel Reports, Auditing, SQL 2008 Data Migration and Client Support.

Programming Skills:

• Closely worked with Business Analyst, Business Users, Product Manager, Project Manager and other Team members regarding collecting requirements. Attended many sessions until the requirements are finalized. Converted requirements into Conceptual, Logical and Physical model.
• Closely worked with Application Development, QA and Business user's regarding login/access issues, in-correct/data validation and mostly the application performance.
• Fully involved in the projects until the products were successfully delivered to the clients. Followed agile methodology.
• Responsible for Optimizing Stored Procedures in legacy applications SQL Server 2000 .
• Identified missing indexes in existing Transact-SQL Queries with the help of DMV's and DMF's System views and functions. Recommend the necessary indexes looking at the Execution Plan.
• Wrote Transact-SQL, Stored Procedures and functions. Wrote DML Triggers for auditing the user changes on few important transaction tables.
• Used SQL Profiler to identify slowly running queries and also trap the SQL calls made by Front-end Application for troubleshooting and fixing the defects.
• Created Database Maintenance Plans for heavily fragmented tables re-build indexes , Update Statistics, schedule daily Backups and clear Transaction Log files.
• SSIS: Designed and scheduled SSIS packages to load data from OLTP to OLAP system for data analysis and generating KPI reports.
• Converted existing SQL load process to SSIS packages, improved the data load performance.
• Deployed SSIS Packages into Production and used Package configuration to export various package properties to make package environment independent.
• SSRS: Installed and configured SQL Server Reporting Services SSRS tool .
• Designed and created new custom Reports. Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports.
• Developed different kind of reports such a Sub Reports, Matrix reports, Linked reports and Dashboard.
• Configured and trained users to use Reporting Services.
• Involved in database migration from SQL 2000 to 2008.

Technologies used: SQL Server2000/2005/2008 R2, Transact-SQL, Stored Producers, Functions, Database Triggers, SSIS and SSRS, MS-Word, MS-Access, MS-Visio, Erwin, Windows 2008 Server.

Confidential

Software Engineer

• Nielsen Claritas is a product based company and has many products of its own, provides fully integrated software and service solutions. I was involved in two major projects iMark and ConsumerPoint, fully responsible for entire applications back end support.
• Nielsen iMark is a marketing information analysis system that provides access to all of our Nielsen Claritas demographic, geographic, business, and segmentation databases.
• Nielsen ConsumerPoint is a dynamic target marketing system that can use to analyze markets and create profitable media strategies.
• Work closely with Requirements Team, Product Managers, Project Managers, Data Warehouse Group, Testing and Application Development team.

Responsibilities:

• Involved in SDLC process until the products are successfully delivered to the clients.
• Installed different versions of SQL Server 2005 engines on different OS. Supported client's in troubleshooting issues with database/application installation configuration setup.
• Involved in physical logical design process, created normalized tables up to 3NF, choose best suitable data types, created UDT, wrote optimized T-SQL queries, sub-queries, standard views with computed columns, functions and stored procedures.
• Involved in optimizing databases Index Design/Creation, Statistics Index Fragmentation .
• Establish Snapshot Replication process to move data into testing server from staging server.
• Created testing environment to test every function, user defined types and procedures.
• Support different groups with SQL server connection/access issues. Help team members by writing Oracle and Sybase SQL queries.
• Wrote NAnt script complete automation process Build SQL scripts, SQL test cases and send status via email to team .
• POC Migrate SYBASE IQ database to MySQL and Infobright database. Compared the performance results of each of the product and produce the analysis report to the product manager. Wrote detail documentation from start to end installing Infobright database, change data types for compatibility purpose, query performance metrics and so on .
• Wrote Java class to sustain the data access layer for some of the system components to extract data from XML and insert them into RDBMS tables for Analytics, Statistical Analysis and Product usage Prediction of the customers.
• Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.

Technologies used: SQL Server2000/2005, MySQL 5.1.41, Infobright 3.3.1, Sybase Adaptive Server IQ 12.7, Transact-SQL, Stored Producers, User Defined Functions, Views, SSIS, BULK INSERT, SQLCMD, Oracle, XML, Java, Windows NT, Windows 2003 Server.

Confidential

SQL Server /Epiphany Epicenter Developer

• Specialized Marketing Solution SMS contains many DataMart's which pull data from Enterprise Data Warehouse/Data Marts like MS Sales, Siebel and WWE using Epiphany Analytical Manager. Data pulled into Data Marts are displayed through Campaign Management UI.
• Technologies used: Epiphany Analytical Manager 5.0.8/6.0.6/6.0.8 , Campaign Management, SQL Server2000, T-SQL, Views, Stored Producers, User Defined Functions, Visio 2003, Product Studio, VSS, ER-Win4.0, Transact-SQL, Windows NT.

Confidential

SQL Server/ETL Developer

National Sales Tracker NST an extensive reporting and analytical tool know as National Sales Tracker NST . NST is access through the Verizon corporate portal. Verizon employees including marketing, sales, and senior management use NST for the development of reports and analysis.

Technologies used: MS SQL Server2000, Oracle8i, Transact-SQL, DTS, XML, C , ASP, ADO.NET, PL/SQL, and SQL Loader, ER/Studio 4.0, and Windows 2000 Advance Server.