SUMMARY:

• Over Eighteen years of experience in Database Design, Development and implementation of Large scale Data Models which includes conceptual, logical and physical data models.
• Hands on Experience in working with Informatica for ETL
• Expert in ETL strategies and creating Source to Target Mapping.
• Proficient in Analysis of Business and Technical requirements and liaison Business and technical teams.
• Expert in ETL tools like Data Transformation Services (DTS), Bulk Insert, BCP for OLTP and DSS (Data Mart/Data Warehouse) environment.
• Experience with index Analyzer and Query analyser for SQL Server 2008.
• Proficient in ETL using SQL Server 2008 using SSIS and Visual Studio 2008.
• Proficient in SQL Server 2005 Analysis Services and Reporting Services.
• Experience in Crystal reports, reporting services and access toolsets.
• Experience Pervasive SQL and SharePoint.
• Experience in up gradation/Migration of MS SQL Server 2005 to MS SQL Server 2000 and SQL Server 2008.
• Experience in writing stored procedures, Functions, Triggers, building the packages, testing and implementing on production boxes.
• Worked extensively on Ardent Data Stage to Extract and Load Data on to Staging Boxes.
• Performed Regression Testing to understand the Performance Bottlenecks in SQL Server Databases.
• Worked on 64 Bit Sql Server 2008.
• Experience in creating Entity Relationship Diagrams.
• Experience in developed and review Perl Scripts
• Expertise in client server application programming using Developer 2000, VB, Forms 5.0 as front ends and Oracle 8.0 as back end, developing commercial application systems.
• Successfully maintained multiple databases operated by over 000 users.
• Provide necessary training and support for the users.

TECHNICAL SKILLS:

RDBMS: MS SQL Server v 2008/2005/2000/7.0/6.5 , ORACLE v 9i/8

Database Tools: TOAD, SQL EM, SQL Profiler, SQL Query Analyzer, Index Analyzer, DTS tools, ISQL, Backup Server, Replication server, OLAP Services, SQL Agents, SQL Alerts, SQL Jobs, SQL Mail, PL/SQL, SQL Client Configuration utility

Development skills: T - SQL, PL/SQL, DDL

Tools: Informatica 6.2, Ardent Data stage,svn, MS Team Foundation

Front End Tools: Developer/2000, VB v6.0, PB v6.0

Hardware: IBM ES/9000 mainframe, Pentium and IBM Compatible PC s

Software: COBAL, DB2, CICS, JCL, VSAM, IIS

Operating System: MVS, HP-Unix 10.2, Solaris 8, Windows NT/2000

Languages: Java 1.2

Source Code: Clear Case, Clear Quest

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Lead Database Developer

Responsibilities:

• Managing a team of 3 off shore and 2 Onsite team members.
• Lead several Design related activities in existing and new initiatives.
• Create Design Documents, Functional Specification documents and Source to Target mapping documents.
• Involved in collecting Business Requirements directly from Internal and External clients.
• Provide requirements for other projects which needs Business Input as a client to other projects.
• Initiate all the planning necessary to identifying the Environment needs for various development activities.
• Present Data model, Functional Specification document and all other documents to Sponsors, Business and Technical Audiences.
• Translate Business needs into Data Design.
• Work with other Analytical groups across Enterprise to co-ordinate the Business process changes where multiple groups are involved.
• Provide guidelines and inputs for Data and Process standards.
• Lead efforts involved in understand and implanting off shore support model for all the database implementations.
• This is an Agile Work Environment where in we identify all the Goals and milestones at the beginning of the sprint and provide the deliverables at the end of sprint.
• Database design involving Netezza databases in Development, UAT and Production environment.
• Planning Development, Testing and Deployment efforts as part of agile methodology. worked closely with .Net Developers in Integrating C# .Net Assemblies into CLR.
• Designed SSIS Packages and wrote Stored Procedures.
• Worked in building the Database build in accordance to CSG Standard.
• Expert in creating Logical and Physical Data Models using Embarcadero ER Studio and Enterprise Architect.
• Hands of experience working with SQL 2008 SSIS (Integration Services)
• Experience working with Netezza Servers.
• Prepared the functional specifications and product documentation.
• Proficient in MS Office, Visio, ProClarity,MS Project and Team Foundation Server.
• Experience with Index Analyzer and Query analyzer for SQL 2000.
• Interacted with developers and system analyst to communicate various business processes among them.

Environment: Windows 2003,Windows XP, SQL Server 2005/2008, SSIS, Oracle 10g Team Foundation Server, Reporting Services,Netezza

Confidential, Tampa, FL

Lead Data Architect /SQL Server DBA

Responsibilities:

• Managing a team of 3 members.
• This is an agile development environment.
• Supporting the Data warehouse applications hosted on Netezza server and writing Shell scripts along with SSIS to perform ETL, ELT operations.
• Maintains Metadata store which is used by Data warehouse Framework.
• Worked on setting up High Availabilty in SQL Server boxes using Mirroring.
• Worked in a multi - tier Development environment where in supporting 50 or more SQL Servers in each PWC Territory.
• As part of Agile development, Design planning, Development and Testing needs are identified and worked on as part of Scrum methodology to provide the deliverables by the end of Sprint.
• Designing Highly Scalable Distributed Database Architecture in SQL Server to achieve Load Balancing.
• Worked closely with .Net Developers in Integrating C# .Net Assemblies into CLR.
• Code reviewing C# .Net Assemblies to make sure Business requirements are met.
• Expert in writing DTS packages and Stored Procedures.
• Co-ordinating with Development team is resolving the database related issues.
• Involved in Logical and Physical Data Modeling using Embarcadero ER Studio and Enterprise Architect.
• Experience installing, configuring and Managing Clustering for active/active and active/passive nodes in Sql Server.
• Hands of experience in working with SQL 2005 SSIS (Integration Services) and SQL 2005 Analysis Services.
• Experience in Configuring Linked Servers.
• Experience with SQL PROFILER for tracing, auditing and Performance Tuning.
• Experience with routine DBA activities like Query Optimization, Performance Tuning, and Effective SQL Server configuration for better performance and cost reduction.
• Prepared the functional specifications and product documentation.
• Took lead in configuring and managing Replication Services.
• Proficient in MS Office, Visio, ProClarity,MS Project and Team Foundation Server.
• Experience with Index Analyzer and Query analyzer for SQL 2000.
• Interacted with developers and system analyst to communicate various business processes among them.

Environment: Windows 2003,Windows XP, SQL Server 2005/2008, SSIS, Oracle 10g Team Foundation Server, Reporting Services

Confidential, CA

Lead Data Architect /SQL Server DBA

Responsibilities:

• Managing a team of 3 members.
• Involved in Data Warehouse Design and Architecture for DXPv2 Product.
• Expertise in writing DTS packages and Stored Procedures.
• Hands of Experience in working with SQL 2005 SSIS (Integration Services) and SQL 2005 Analysis Services.
• Responsible for getting requirements from End users for Designing the Web Application used for the Data warehouse.
• Lead in Managing Design and Implementation of complete Data Warehouse/Website Packaging using Install Shield.
• Experience in Managing/Coding and implementing all the Service Pack changes related to Data Warehouse and Website.
• Hands on experience in Importing and Exporting Data from/to DB2 to SQL Server and other database servers using ETL.
• Experience with routine DBA activities like Query Optimization, Performance Tuning, and Effective SQL Server configuration for better performance and cost reduction.
• Installed and configured SQL Mail client for SQL 2000.
• Developed and review DB2 and SQL Server 2000 Code.
• Prepared the functional specifications and product documentation.
• Involved in configuring and managing Replication Services.
• Experience with Index Analyzer and Query analyzer for SQL 2000.
• Interacted with developers and system analyst to communicate various business processes among them.
• Reviewing the Crystal Reports and Stored Procedures related to them.
• Supporting all sorts of Data related issues which arise in ETL.
• Maintaining and Supporting all the Credit Unions Data Warehouses which require all sorts of maintenance activities like configuring and setting up DBCC jobs and Tuning up the Warehouse from time to time.

Environment: Windows 2003, SQL Server 2000/2005, DTS, DB2, Crystal Reports

Confidential, FL

Lead SQL Server DBA

Responsibilities:

• Managing a team of 5 members.
• Experience with index Analyser and Query analyser for SQL 2000.
• Involved in designing REPORTS using REPORTING SERVICES.
• Worked on Informatica Power Center 6.2 - Used Source Analyzer and Warehouse designer to import the source and target database schemas and the Mapping Designer to map the sources to the target, Mapplets and Transformation Developer. Analyzing the data model and Identification of heterogeneous data sources. Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level. Involved in Data Loading Sequence and Populated Data into Staging Area and Warehouse with Business Rules. Extensively used ETL to load data from Sql Server to Staging area (Oracle 9i) using Informatica Power Center 6.2. Worked with pre and post sessions, and extracted data from Transaction System into Staging Area.
• Hands on Experience in writing DTS packages and Stored Procedures.
• Experience in Configuring Linked Servers.
• Hands on experience in Importing and Exporting Data from/to Oracle to SQL Server and other database servers.
• Experience with SQL PROFILER for tracing, auditing and Performance Tuning.
• Experience with routine DBA activities like Query Optimization, Performance Tuning, and Effective SQL Server configuration for better performance and cost reduction.
• Installed and configured SQL Mail client for SQL 2000.
• Developed and review Oracle 9i and SQL Server 2000 Code.
• Prepared the functional specifications and product documentation.
• Interacted with developers and system analyst to communicate various business processes among them.

Environment: Windows 2000, SQL Server 2000, DTS, Reporting Services, Oracle 9i

Confidential, Little Rock, AR

SQL Server DBA/Developer

Responsibilities:

• Managing a team of 5 members.
• Designing and implementing Standby Servers
• Experience with Log Shipping and disaster recovery planning and implementation.
• Designed and installed merge and transactional replication for SQL 2000.
• Experience with index Analyzer and Query analyser for SQL 2000.
• Designed Backup and Recovery Strategies and Point in Time Recovery.
• Creating, Managing and Troubleshoot SQL Server Agent Jobs.
• Experience in Configuring Linked Servers.
• Hands on experience in Importing and Exporting Data from/to Oracle to SQL Server and other database servers.
• Experience with SQL PROFILER for tracing, auditing and Performance Tuning.
• Experience with routine DBA activities like Query Optimization, Performance Tuning, and Effective SQL Server configuration for better performance and cost reduction.
• Created number of jobs, alerts and operators to be paged or emailed in case of failure for SQL 2000.
• Developed and Review Oracle 9i and SQL Server 2000 Code.
• Developed and Review Perl Scripts
• Managed the customer related problems concerned with the product upgrade (Database).
• Prepared the functional specifications and product documentation.
• Interacted with developers and system analyst to communicate various business processes among them.

Environment: HP UX 10.2, Solaris 8, Windows 2000, SQL Server 2000, Oracle 9i, PL/SQL, Perl.

Confidential

SQL Server DBA/Developer

Responsibilities:

• Planned, created, scheduled, rescheduled the backup jobs of various databases present in desktop, development, transaction and production boxes.
• Managing Data Files and Transaction Log files and Estimate space requirement.
• Provide support in Tuning of Database Application, Stored procedures and Triggers.
• Performed Regression Testing to understand the Performance Bottlenecks in SQL Server Databases.
• Experience of creating Entity Relationship Diagrams.
• Training the Database Developers in Tuning their Stored Procedures, Functions and Triggers.
• Successfully performed Security & Controls rollout for MS SQL Server 7.0 Servers.
• Working on technology evaluation for occasionally connected users to the Database Servers.
• Loading of various Feeder Files coming from various EMEA countries into a Staging Database Server and Loading back onto a SQL Server Production Boxes.
• Provided 24X7 supports to databases for data warehouses.
• Installed, configured and upgraded SQL Servers as per standard practice.
• Wrote stored procedures, packages, testing and implemented to production boxes.
• Monitored the problems faced in ETL of various Data Warehouses.
• Worked Extensively on Ardent Data Stage to Extract and Load Data on to Staging Boxes.
• ETL was designed using various methods like Data Staging software, Log shipping and various DTS packages.
• Scheduling various DTS packages depending on the Business Requirements.
• Involved in the Capacity Planning of various Development, QA and Production Boxes.
• Tuned SQL databases and improved the performance of databases.
• Upgraded (Plan, implement and document) all the boxes with various SQL Server service packs.

Environment: Windows 2000, SQL Server 7.0, DTS, Data Stage.

Confidential

SQL Server DBA/Developer

Responsibilities:

• Database Design, Optimization of Quires and Database, Performance Tuning using Index wizard, SQL Profiler and Query Analyzer.
• Installed SQL Server Desktop Database & Standard Database.
• Configured the SQL Server to increase the Server Performance, Creating Database Maintenance Plans, writing Stored Procedures and Triggers.
• Created users and user permission and maintaining the Database Security.
• Database and maintaining the OLAP Services.
• Took Daily Transactional and Differential Database Backups and weekly full Database Backups.
• Monitored Server performance with the help of Performance Monitor and tuning the server.
• Worked on the 200 MD Database containing 400 tables and around 60 users connecting to the Database.

Environment: Windows 2000, SQL Server 7.0

Confidential

SQL Server DBA/Developer

Responsibilities:

• Database Design, Optimization of Queries and Database, Performance Tuning using Index Wizard SQL Profiler and Query Analyzer.
• Installed SQL Server Desktop Database & Standard Database.
• Created Database Maintenance Plans, writing Stored Procedures and Triggers.
• Created users and user permission and maintaining the Database Security.
• Database and maintaining the OLAP Services.
• Took Daily Transactional and Differential Database Backups and weekly full Database Backups.
• Working on the Confidential Database that is of 70 MB size containing 150 tables and around 60 users connecting to the Database.

Environment: Windows 2000, SQL Server 7.0