OBJECTIVE:

Use the experience as a professional in the field of Information Technology to lead a team of quality individuals through project implementation and daily IT tasks. As a goal oriented, strategic thinker that obsesses on perfection, looking for a position that can utilize the management and technical skills obtained through my experience to provide a high standard of Information Technology service. I am an innovative and systematic software developer, programmer and lecturer with a wide and unique range of abilities, experiences in Hardware, Software, Teaching, Design, Administration and Marketing. A versatile and dedicated hard worker and researcher with proven leadership, communication and collaboration skills.

SUMMARY:

• Excellent experience in the use and development of SQL Server 2000/2005 database,IT experience as a SQL Server developer which includes three plus years in Microsoft Database Technologies with various Industries.
• Expert and Advanced knowledge Microsoft Office - Word, Excel, Power Point, Outlook, Visio, Access. Have hands on excellent Experience on Microsoft office for about more than 8 years.
• I have good hands on Microsoft Share point
• Extensive knowledge of Relational Database Management Systems (RDBMS)
• Expert in designing relational database model and implementing as per business needs.
• Efficiently used Microsoft SQL server 2005, SQL server management studio.
• Experience in Data Modeling using ERWIN. Overall database design, such as creating normalized databases, authentication, query tuning, assigning proper indexes, relational integrity constraints, OLAP, OLTP, creating stored procedures, functions, triggers and data types.
• Hands on Experience in installing, configuring, managing, monitoring, troubleshooting SQL Server 2005.
• Working Experience in designing, implementing, maintaining, and documenting complex database applications, and data warehouse in financial environments.
• Knowledge in RAID Technology.
• Expert in MS- Office Packages. (Experience in MS-Excel, MS-Access )
• Experience in Extracting, Transforming and Loading (ETL) data using DTS Import/Export utility and BCP
• Developed backup and recovery strategies for SQL Server databases.
• Experience in installing Service Packs for SQL Server and OS.
• Expertise in experience in Database Design, Development and Implementation using MS SQL Server 2000/2005/2008 in OLAP and OLTP environment.
• Experience in creating Store Procedures, Functions and Triggers.
• Experience to work with SQL Server 2005 Business Intelligence tools like Reporting Service (SSRS), Crystal Reports 8,9,10. Integration Service (SSIS) and Analysis Service (SSAS).
• Experience in designing, implementing, maintaining and documenting complex database applications.
• Extensive knowledge in Tuning SQL queries for improving the performance.
• Extensive experience in T-SQL to write Store Procedure, Tables, Functions, Views, Indexes and Relational Database Models.
• Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
• Experience with SQL Server 2005 DDL/DML Triggers, Database Mirroring, Migration, Upgrading.
• Experience in creating proper back up strategy for disaster recovery.
• Good team player with strong analytical skills
• Flexible, enthusiastic and project oriented team player with excellent communication and leadership skills to develop creative solution for challenging client needs

Work Experience

Confidential, Teaching Assistant (Dec. 2007 - Dec. 2008)
Department of Computer Science
Macomb, IL 61455 - DURING MY MASTER'S

• Responsible for teaching computer applications, Computers Software and Computer hardware lecture course for Undergraduates.
• Responsible for two lab sections where I was responsible for teaching Microsoft Office 2007Package each semester that includes Word, Excel, Power Point, Access, Outlook
• Installed software updates and maintained 75 laboratory computers and lab network.
• Plan and develop lessons for Computer Science, Computer Application, Computer Graphics and Foundation of Technology classes.
• Actively participate in parent conferences, student evaluations, core meetings, and department meetings.
• Tutor students who need extra help before and after school.
• Write curriculum for Computer Science, Computer Graphics, Computer Applications and Foundation of Technology classes.
• Implement effective and efficient classroom management.
• Plan, create powerful presentations and present formal briefings related to specific tasks.
• Assist in developing and implementing training programs for Information Technology.
• Manage Online Course Software - Create and manage accounts for students, staff and Parents.
• Assisted Professor in tutoring students on subjects related to Database
• Create and manage user accounts in Active Directory Services.
• Excellent organizational skills.

Confidential, Birmingham, AL
Aug 2007 - Dec 2007 SQL Server Developer/Report Writer

Description: Regions Financial Corporation is a member of the S & P 100 Index and Forbes Magazine\'s "Platinum 400" list of America\'s best big companies. With $146 billion in assets, Regions is one of the nation\'s largest full-service providers of consumer and commercial banking, trust, securities brokerage, mortgage and insurance products and services.

The Project that I worked is "Regions CMP Environment Upgrade". In this project I was responsible for upgrading process of the old database environment of which uses SQL server 2000 to new environment which uses SQL server 2008. The task was to upgrade all the SQL packages and Jobs to new environment and make sure that all the tasks pointed to appropriate databases and also created new DTS and SSIS packages for existing and new processes. Created SQL reports using crystal report and SQL server Reporting Services for the output data generated by the SQL packages. Major Responsibilities are as follows

• Transformation and loading into the target SQL Server databases using ETL tools, DTS 2000 and SSIS 2005
• Created SSIS packages with which data resources such as Flat files, Excel files, PDF files were loaded daily in order to create and maintain a centralized data warehouse.
• Made the package dynamic so it fit the environment.
• Expertise experience with administering and debugging DTS and SSIS.
• Created scheduled jobs to execute DTS and SSIS packages.
• Transferred/Rewrote DTS packages to SSIS programs. Hands on working experience with configuring every aspects of SSIS 2005.
• Created alerts, notifications, and emails for scheduled SSIS packages execution.
• Coordinated other Reporting Analysts in analyzing data and creating management reports.
• Assisted internal and external report needs and designed solutions based on specific requirements using SQL Server Reporting Service (SSRS) and crystal reports.
• Developed reports without formal specifications often.
• Created and developed the stored procedures, triggers, views, and user-defined functions to support application development.
• Worked closely with IT project managers, programmers, and testers.
• Develop Provision Tax Reports, as per customer requirements for Provisions Tax Software, to include but are not limited to parameter and drill-down reports, sub reporting, multi-grouping and reports sectioning.
• Tax formula development. Develop and program, as applicable, Wise installation scripts supporting the Provisions Installer Program used to distribute The Provisions Tax Software Suite.

Confidential, Hyderabad, India Jan 2006 - Jun 2007 SQL Server Developer
Description: Confidential, is one of the largest retail banking and financial services, conducts the business though retail banking & financial services, home loans, commercial banking, and card services. The goal of this project was to upgrade the SQL Server database from 2000 to 2005.Generate reports from different data source and monitor the system using built in SQL Server tools, crystal reports. As a consultant, I was able to successfully achieve this goal within the time of deadline.

Responsibilities:

• Responsible for installation, configuration and maintenance of SQL Server database on different platforms.
• Experience in creating complex Store Procedure, Triggers, Tables, Views and several other SQL statements and Joins for applications.
• Created reports using SSRS and crystal reports.
• Involved in generating the reports for a variety of topics SQL Server 2005 Reporting Services.
• Created DTS packages to import and export data from SQL Server to Access, Text and Excel files.
• Set up the DTS for Exchange of data between different data sources (SQL Server, Oracle and DB2).
• Upgraded the database SQL Server 2000 to SQL Server 2005 and migrated DTS objects to SQL Server 2005 (SSIS) Integrated Services environment.
• Created Tables, Store Procedures, Function and Triggers to perform task.
• Involved in design and generation of reports for different data source, performing transformation and loading that data into another data sources.
• Created proper back up strategy using Full, Transaction and Differential to minimize data lose and Simple, Full and Bulk-Logged Recovery models to restore and recover the data.
• Ran SQL Profiler to identify expensive queries and used database Tuning Adviser.
• Designed and created Views for security purposes, implemented rules, defaults, user defined data types, documented the table relationships with diagrams.
• Imported and mapped the data to create tables and temp tables to research issues.
• Documented data process and business rules.
• Created and managed logins, roles, assigning rights and permissions to the users.
• Created and modified database objects, including tables, indexes, views and store procedures.
• Monitored database performance and rebuilt indexes on tables using index tuning wizard to return quicker response time.
• Configured SQL Server 2005 in-built log shipping from primary server to standby server and generated Reports.
• Utilized various replication methods to synchronize data at multiple targets.
• Created and modified Jobs on day to day basis, and set up the email notification on unsuccessful Jobs using SQL mail.
• Involved in Documentation.

Confidential, Mumbai, India
June 2005 - Dec 2005 SQL Server Developer

Description: The Housing Development Finance Corporation Limited (HDFC) was amongst the first to receive an \'in principle\' approval from the Reserve Bank of India (RBI) to set up a bank in the private sector, as part of the RBI\'s liberalization of the Indian Banking Industry in 1994. The bank was incorporated in August 1994 in the name of \'HDFC Bank Limited\', with its registered office in Mumbai, India. HDFC Bank commenced operations as a Scheduled Commercial Bank in January 1995.
Responsibilities:

• Creation, manipulation and supporting the SQL Server Database
• Created Stored Procedure, User-defined Functions to take care of back end validations when transferring data to Production Server
• Extensively involved in designing the DTS packages to make the automated synchronization of data from one system to another system
• Created queries with Inner Join, Outer Join, Co-related sub-query with String function, Mathematical function, Aggregate function, Date and Time function.
• Involved in migration of Data from Excel, Flat file, Oracle, XML files to SQL Server by using BCP and DTS utilityConfigured SQL Server 2000 in-built log shipping from primary server to secondary server
• Analyzed and implemented backup and database maintenance plans
• Configured Mail Profile for sending automatic mails to the respective people when a job is failed or succeed. Maintaining SQL Script for creation of Database Objects
• Fine-tuning Stored Procedures to improve performance that was achieved by removing unnecessary cursors, temporary tables wherever possible
• Administering MS SQL Server by Creating Logins and assigning appropriate roles
• Developed Index tuning stored procedures

Environment:
MS SQL Server 2000, Windows NT 4.0, Erwin.

Confidential, Hyderabad, India Aug 2004 - Apr 2005
SQL Server DBA /Developer
Description: Quad one, the largest home improvement specialty retailer with the stores in every state across the nation. The goal of this project was creating, managing and maintaining the database as well as generating reports and transferring and retrieving the data between the different locations.
Responsibilities:

• Performed routine Backup and Restore data and troubleshooting Backup and Restore Procedure.
• Imported and Exported data using DTS utility to transfer data from between different locations.
• Worked as a developer in creating complex Store Procedure, Triggers, Cursors, Tables, Views and several other SQL statements and Joins for applications.
• Implemented Constrains on tables.
• Developed Capacity Planning, Performance Tuning and Disaster Recovery.
• Worked on Link Server to run distributed Queries between SQL Server and other data source like Excel using ODBC, OLE DB drivers.
• Configured customized Log Shipping for SQL server 7.0 and built in Log Shipping with SQL Server 2000.
• Improved Performance of SQL Server by Rebuilding and Reorganizing Indexes.

Environment: SQL Server 2000/2005, Windows 2003, Enterprise Manger, Management Studio, MS Reporting service, MS Visual Studio , Data Transformation service, T-SQL.

Technical Skills:

RDBMS

MS SQL Server 2005(Expert), MS SQL Server 2008, MS Access

Tools

SSRS, SSAS, SSIS, Data Modeling, ER-Win, SQL server management studio, Business Intelligence Development Studio, Query Analyzer, Excel

Platforms

MS-Dos, Windows

Languages

Transact SQL, PL/SQL, XML, HTML, C, C++, and Java.

Packages

Expert in MS Excel, MS Access, MS word, MS Power point, MS Front Page, MS Outlook

Web Tools

HTML, XML, Dream weaver, Flash, Adobe Photoshop

Operating Systems

Windows 2K/NT/XP, Mac 0S, Linux

Hardware Skills

Build PC's from parts; install peripherals and devices, setting up hubs/routers, troubleshooting.

Educational Qualifications:

Master of Science in Computer Science

Bachelor of Technology in Computer Engineering