• 8+ years of solid Database development experience with some  Database administration(DBA) duties
• Experience with software development life cycle (SDLC) and project management methodologies
• Expertise in designing, implementing, maintaining, and documenting complex database applications, and data warehouse in financial environments
• Extensive experience with data modeling, logical and physical database design using Erwin
• Design entity relationship diagrams and dimensional data models
• Extensive experience with SQL Server and T-SQL, Oracle PL/SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity
• Extensive experience with SQL scripts, stored procedures, triggers, functions, SQL Performance tuning and transactions analysis, thorough understanding of indices and statistics.
• Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2000
• Experienced in the installation and configuration of SQL Server 2000 and SQL Server 2005
• Hands on Experience in Integration Service, Analysis Service, Reporting Service(SSIS,SSAS,SSRS)
• Hands on Experience in Extracting and transforming Data with SQL Server 2000 /2005
• Experience with establishing and maintaining security integrity controls in conjunction with the applications and security groups and assist in the design and implementation of development, testing, QA, and production environments.
• Excellent report creation skills using Microsoft Reporting Services
• Strong experience in design and construction of data marts and data views.
• Hands on experience Crystal Report, and Crystal Analysis
• Industry working experience in SQL Server and Oracle database management, maintenance, performance tuning, and troubleshooting
• Extensive experience in providing Enterprise Tier-N Platform Services operational technical support
• Experience in UML, data-flow, Rational Rose, and DTS package design and construction
• Proficient with creating Use Cases, Sequence Diagrams, Component Diagrams, Collaboration Diagrams, Activity Diagrams, and Class Diagrams
• Excellent communication, presentation and interpersonal skills
• Strong troubleshooting and organizational skill

PROFFESSIONAL EXPERIENCE

Confidential,
                        Northwood,                                     4/2008 – TillDate
Sr. SQL Server Developer (CONTRACT)

I worked for the department responsible for maintenance Database Servers including Microsoft Sql Server 2000 and SQL Server 2005 and Oracle 9i, 10g. My responsibilities including designing and  modeling  the database, writing store procedures, triggers, Cursors and DML DDL queries,   designing DTS/SSIS packages, Design entity relationship diagrams and dimensional data models, ETL works including transfer data from OLTP Database to OLAP Database. Also responsible to monitor and tune large databases for performance and availability, modify database structures, develop database backup/recovery procedures, provide support and guidance to operational models, and forecast database and platform resource utilization, consistence check, security administration, data quality, documentation, and technical support.

Responsibilities:

• Performed business requirement analysis to derive function specification and use cases
• Designed physical and logical data models collaborated with team leader by using Erwin and Rational Rose
• Designed, implemented, and maintained very complex and large databases with all database respect to access methods, access time, validation checks, security management, device allocation, database organization, documentation, and statistical methods
• Conducted logical and physical database design including data modeling, maintenance, problem diagnosis and resolution
• Responsible for support the develop Team which are developing Applications.
• Created and developed the stored procedures, triggers and Functions to handle complex business rules, history data and audit analysis
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager
• Responsible for implement Replication
• Transfer Data using Integration Service(SSIS)/DTS
• Extract Transform Load(ETL) development using SQL Server Integration Services (SSIS).
• Dimensional Data Modelling and cube development in SQL Server Analysis Services (SSAS).
• Advanced extensible reporting skills using SQL Server Reporting Services (SSRS).
• Transfer Data From OLTP Database to OLAP Database.
• Creation of OLAP cubes using Analysis service (SSAS) and DTS scripts
• Created and administered multiple development, training and production databases
• Work with business teams and obtain relevant business logic to efficiently translate business requirement into code and improve the services in customer relationship management CRM.
• Developed and created data dictionary, stored procedures, advanced queries, triggers, views, indices, and functions for databases
• Monitored strategies, processes and procedures to ensure the data integrity, optimized and reduced data redundancy, maintained the required level of security for all production and test databases
• Maintained databases, performed software installations and upgrades, monitored database performance, performed capacity planning, and SQL Server clustering, managed database quality assurance including database consistency check
• Responsible for creating standards and operating procedures to maintain all databases
• Worked with development teams in the design of physical databases and in modification
• Ensured developers coordinated their efforts in managing and maintaining different application databases
• Troubleshoot databases and custom application issues
• Eased administrative work through automatic script performing daily/weekly backups
• Reduced systems downtime risk through automatic offsite backup and recovery over network
• Responsible for database security of the operational and developmental application system databases
• Managed the granting of access to operational and developmental application system databases

Environment: SQL Server 2000/2005/2008 Oracle 8i, 9i, 10g, Windows Enterprise Server 2003,  IIS 6.0, .NET, Erwin, Microsoft Visio 2003, FTP, SQL Server Integration Services (SSIS),Microsoft Reporting Services (SSRS).

Confidential,
                                              Ft Washington, PA                                              01/2007 – 3/2008
Sr. SQL PL/SQL Developer

GMAC is one of the nation\'s largest Mortgage company, I worked for the software department which responsible for developing the applications and maintenance Database servers including Microsoft SQL SERVER 2000/2005 and ORACLE.  My responsibilities including designing and  modeling  the database, writing store procedures, designing DTS/SSIS packages, Design entity relationship diagrams and dimensional data models, ETL works including transfer data from OLAP Database to OLAP Database. Also responsible to monitor and tune large databases for performance and availability, modify database structures, develop database backup/recovery procedures, provide support and guidance to operational models, and forecast database and platform resource utilization, consistence check, security administration, data quality, documentation, and technical support.

Responsibilities:

• Designed physical and logical data models collaborated with team leader by using Erwin
• Performed business requirement analysis to derive function specification and use cases
• Responsible for support the develop Team which are developing Applications.
• Created and developed the stored procedures, triggers and Functions to handle complex business rules, history data and audit analysis
• Transfer Data using Integration Service(SSIS)/DTS
• Transfer Data From OLTP Database to OLAP Database.
• Creation of OLAP cubes using Analysis service (SSAS) and DTS scripts
• Advanced extensible reporting skills using SQL Server Reporting Services (SSRS).
• Created and administered multiple development, training and production databases
• Developed and created data dictionary, stored procedures, advanced queries, triggers, views, indices, and functions for databases
• Monitored strategies, processes and procedures to ensure the data integrity, optimized and reduced data redundancy, maintained the required level of security for all production and test databases
• Maintained databases, performed software installations and upgrades, monitored database performance, performed capacity planning, and SQL Server clustering, managed database quality assurance including database consistency check
• Responsible for creating standards and operating procedures to maintain all databases
• Worked with development teams in the design of physical databases and in modification
• Ensured developers coordinated their efforts in managing and maintaining different application databases
• Troubleshoot databases and custom application issues
• Eased administrative work through automatic script performing daily/weekly backups
• Reduced systems downtime risk through automatic offsite backup and recovery over network
• Responsible for database security of the operational and developmental application system databases
• Responsible for implement Replication
• Designed, implemented, and maintained very complex and large databases with all database respect to access methods, access time, validation checks, security management, device allocation, database organization, documentation, and statistical methods

Environment: SQL Server 2000/2005 Enterprise, Oracle 9i, Windows Enterprise Server 2003,Oracle 9i/10g, CRM, IIS 6.0, .NET, Erwin, Microsoft Visio 2003, SFTP, SQL Server Integration Services (SSIS),Microsoft Reporting Services (SSRS) Oracle 9i.

Confidential,
                                    Chicago, IL                                                        12/2005 – 12/2006
Sr. SQL Server Developer/DBA

Aircell Telecom, the brand name of Spice Communications Limited is going to operate Phone Services in planes all over the world In India and some Asian countries, considered as one of the best service providers of mobile telephony in India. Spice Communications Limited is a leader in delivering broadband and other wireless communication innovations to mass market, business, government and wholesale customers. It is deploying the nation’s most advanced fiber-optic network to deliver the benefits of converged communications, information and entertainment services to customers.
Responsibilities:

• Implemented and maintained database security.
• Created DTS packages for the loading the data.
• Used the reporting services to create, schedule and publish the reports required.
• Administrator tasks like managing users, roles, and profiles.
• Performed Database backups (operating system, flat file backups & export/import).
• Used Snapshot replication for creating multiple instances of a database for distributing the workload.
• Configured Snapshot Replication (Creating Distribution Databases, updating Publishers, creating & managing Publications, managing Replication monitors).
• Tuned SQL statements and SQL Procedures.
• Combined a few simple, unrelated Database Accesses to improve performance.
• Used Query Analyzer to optimize SQL Queries.
• Maintained the physical Databases by monitoring Performance, Space utilization and Physical integrity.
• Coded Procedures & User defined Functions in TSQL.
• Established and documented a complete Disaster Recovery Plan for the Database servers.
• Created Crystal Reports for Business Intelligence.
• Daily monitoring of the database performance and network issues.
• Rebuilding indexes on various tables.

Environment: Oracle 9i, MS SQL server 2000, Windows 2000, Crystal reports 6.5/8.0, Foglight, Enterprise manager, Veritas backup solution, DTS, SQL profiler.

Confidential,
                        Hyderabad, India               8/2003 – 12/2005
Sr. SQL Server Developer(CONTRACT)

Satyam Computer Services Ltd. is a leading global consulting and IT services company. It has excellent domain competencies in verticals such as Automotive, Banking & Financial Service, Insurance & Healthcare, Manufacturing, and Telecom-Infrastructure-Media-Entertainment-Semiconductors (TIMES). As a diverse end-to-end IT solutions provider, Satyam offers a range of expertise aimed at helping customers re-engineer and re-invent their businesses to compete successfully in an ever-changing marketplace.

Responsibilities:

• Designing and implementing the module based on the business requirements given by the business analysts.
• Generating Script files of the databases when ever changes are made to stored procedures or views or any other database objects and checking the objects in VSS.
• Used Visual Studio. Net to run the scripts in different environments of development databases and to check-in the scripts into VSS.
• Using Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Managing the use of disk space, memory and connections.
• Running DBCC consistency checks, and fixing data corruption in application databases.
• Installing SQL Server service packs based on the errors and flaws that are found in the application.
• Monitor and tune SQL scripts. Creating upgrade scripts for production database and supporting it.
• Creating and managing schema objects such as tables, views, clusters, indexes, procedures, triggers & maintaining Referential Integrity.
• Server & Application fine-tuning & trouble shooting. Monitoring MS SQL Server performance and network issues.
• Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Helping Development Team in deploying and testing the application, which uses SQL Server as a database.
• Database and Transaction log backups & restoration, backup strategies, scheduling the backups.
• Backing up system & user databases and restoring them when ever necessary.

Environment: MS SQL Server 2000, Enterprise Manager, Query Analyzer, and System Monitor/Performance Monitor, Event Viewer, Database Maintenance Plan Wizard and Data Transformation Services, SQL LiteSpeed T-SQL,Third party Application, Windows 2003/2000 server, Window 2000.

Confidential,
                                    Bangalore, India                           1/2002 – 3/2004
SQL Server Developer
 
Canara Bank, Bangolore (INDIA) is headquartered in India, a suburb of Canara has branch offices located in All over India. Its predecessor bank was founded in 1969

Responsibilities:

• Database planning in relation to physical and logical data architecture.
• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.
• Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning.
• Managed user access. Created and managed new security accounts.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Created the DTS interfaces to vendors in which records were loaded daily, also to other data resources such as Excel, Access, Lotus, XML in order to create and maintain a centralized data warehouse.
• Creation of OLAP cubes and DTS scripts. 
• Assisted with various ad hoc query requests.
• Provided back-end support for functional testing and performance testing.

Environment: SQL Server 2000 Enterprise Edition, Windows 2000 advanced server, IIS 6.0, .NET, Erwin, Microsoft Visio 2003, SFTP, Crystal Reports 6.5.

Bachelor Of Engineering in Computer Science
                   JNT University, India

PGDCA Post Graduate Diploma In Computer Applications
                             Kakathiya University

Brainbech Certified MS SQL Server 2005 Developer.