Professional summary:

• Over 7 years of IT experience as SQL developer/DBA in design and development of various applications for Financial, Insurance, and Manufacturing Industries.
• Strong Transact-SQL query writing skills (DDL, DML, and DCL) to handle complex queries and writing Stored Procedures, User-Defined Functions, Triggers, Views and Indexes.
• Developed complex stored procedures and Queries for implementing business logic and process in backend, for data extraction, reports and other client interfaces.
• Experienced working on Normalized Databases and designed database/tables and the requisite relationships, designed partition tables and partition views.
• Implemented cursors for rebuilding indexes.
• Managed all database services in production, staging, development and testing environments.
• Strong Experience in SQL database design, architecture, data modeling using Erwin; Data Warehousing and analysis skills: ETL tools, MDX, OLAP (MOLAP, HOLAP, and ROLAP), dimensional modeling, star schema and snowflake schema.
• Designed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, xml files and flat files into SQL Server 2008 for further Data Analysis and Reporting by using multiple transformations.
• Experienced in ETL (Extracting, Transforming and Loading) development using DTS and SSIS for migration of data between legacy systems to SQL Server 2000/2005.
• Experienced in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages
• Proficient in implementing Error Handling Tasks, Event Handlers, Checkpoints, and Breakpoints to identify package status and handle error tasks to troubleshoot the packages.
• Experience in design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting using SQL Reporting Services (SSRS).
• Proficient in creating, parameterizing and formatting different types of reports such as Cross-Tab, Drill-down, Sub reports and cascading reports using SSRS 2008/2005.
• Proven knowledge of enterprise Reporting and Business Intelligence.
• Experience in working creating Multidimensional cubes using SSAS.
• Involved in Implementation and maintenance of security integrity controls (logins/roles) of applications and security groups.
• Experienced on Performance monitoring using SQL Profiler scheduled and monitored all maintenance activities of SQL Server 2000/2005/2008 including database consistency checks and index defragmentation.
• Experienced in developing Logical and Physical data models using data modeling tools such as Erwin, MS Visio and ER/Studio.
• Knowledge of SQL Server solutions including Log shipping, Replication and clustering.
• Hands on installing, configuring, managing, monitoring and troubleshooting SQL Server 2008/2005.
• Experience in Database Backup, Recovery and Disaster Recovery procedures and Good Knowledge on Clustering, Replication, Data Mirroring, Linked Servers and Log Shipping.
• Experience on Disk management, Storage management, Data Integrity and Planning Database maintenance.
• Excellent communication, presentation and interpersonal skills.

Education:

• Bachelor of Technology in Computer Science Engineering

Technical Skills:

RDBMS

SQL Server 2000/2005/2008, MS Access, Oracle 8i/9i/10g, Enterprise/SQL Server 6.5/7.0

LANGUAGES

C, C++, C#, VB.Net, SAP(ABAP), Visual Basic

DATAADMINISTRATION

SQL Server DBA activities (performance tuning, and import/export of data using DTS packages, writing scripts for automating various tasks)

OPERATING SYSTEMS

Windows 95/98/2000/2003/XP-Pro, Windows NT, Windows XP, Unix

DATABASES

SQL Server 2000/2005/2008, Oracle 8i,9i,10g

SQL Server TOOLS

DTS, BIDS(SSIS, SSAS, SSRS), BIMS, Query Analyzer, Enterprise manager

Professional Experience:

Confidential,Atlanta, GA Mar10-till date
SQL Server DBA/BI Developer

Confidential,is an American retailer of home improvement and construction products and services operating 2,193 big-box format stores across the United States.
Customer Information Management System (CIMS)
This system was created to bring together the Customer and sales information from various business locations and centralize its distributed inventory management system. CIMS provided a centralized storage of customer, sales, and inventory information to facilitate better business decision making.

Responsibilities:

• Responsible for the design, development and implementation of mappings/transformations based on source-to-target specifications, defining ETL (extract, transform, load) development standards and conventions.
• Import/Export and successfully migrated the Databases such as DB2 and MS Access to SQL Server 2005 using SSIS. Scheduled the same packages by creating the corresponding job tasks.
• Designed and developed various Service Management Reports, sub-reports, charts, parameterized reports, conditional and dynamic reports using SSRS.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server 2005.
• Designed and implemented Parameterizedand cascading parameterized reports using SSRS.
• ScheduledReports to run thereports Hourly, Daily, Monthly Accordingto end user requirements.
• Involved in report creation using SQL Server Reporting Services (SSRS), and Excel spreadsheet as per the client Requirement and for the periodic analysis.
• Created and modified complex TSQL batches / stored procedures. Involved in Creating Stored Procedures and Optimizing existing queries and Stored Procedures.
• Mentored and provided backup for Production Support DBA
• Involved in SQL Server 2005/2008 installation and Upgrade in Test, Development, QA and Production servers. Developed cursors to rebuild indexes on all tables.
• Created, developed, maintained the stored procedures, triggers to interpret complex business rules, history data and audit analysis
• Experienced in Backup and recovery of Master, MSDB and Application databases.
• Hands on Creation of New NT Logins and granting privileges to users/Groups and objects.
• Responsible for Query optimization and Performance tuning using SQL Server Profiler.
• Used DBCC commands to check physical and logical consistency of the databases and Rebuild indexes.

Environment: Server 2005/2008 Enterprise, BIDS, MSMS, Microsoft Reporting Service (SSRS), SQL Server Integration Services (SSIS), .NET, C#, ASP.NET, ADO.NET

Confidential,Atlanta, GA May08- Feb10
SQL Server Developer/BI Developer

Confidential,provides information technology services as well as business process outsourcing solutions to businesses, government agencies and non-profit organizations. This project is comprised of GUI and Reports/Invoice sub modules. Report Selection Criteria is based on various factors like Location/Site, Date/Range, Cost Center, Department, Investor, Custodian and Document Status.

Responsibilities:

• Installation of MS SQL enterprise servers on test and development boxes.
• Actively participated in gathering User Requirements and Online System Specifications.
• Actively involved in different stages of Project Life Cycle.
• Modified current database by adding tables and relationships to support online system.
• Defined constraints, rules and defaults.
• Created views as required by front end developer for easier implementation on web pages, and triggers on those views to provide efficient data manipulation.
• Created complex stored procedures and functions to support efficient data storage and manipulation.
• Optimized the performance of queries with modification in index system for online system.
• Wrote triggers (After and Instead Of) and stored procedures to capture updated and deleted data from OLTP systems.
• Created dynamic packages in SSIS to meet the requirements and created Database Maintenance Plans for the various data Sources and centralizing the data using SSIS.
• Used Error handling and Error logging techniques to capture data in SSIS in various ETL solutions.
• Wrote VB.NET code in script components in SSIS and SSRS.
• Wrote queries on Oracle data bases and performed tuning on queries and stored procedures on Oracle data bases.
• Creating Reports as per user requirements using MS Reporting Services 2000/2005
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Experience in creating different types of reports like parameterized reports, sub-reports using SSRS with drill down specialty.
• Developed different charts using SSRS for analysis purpose.
• Involved in taking backups of SSAS database and restoring them when needed.
• Developed the Data access layer using ADO.NET
• To analyze long running queries and tune the same to optimize application and system performance and rebuilding the indexes at regular intervals for better performance.
• Documented all processes involved in maintaining the database for future reference.

Environment: MS SQL Server 2005, SSIS, SSRS, SSAS, Windows 2000/NT, ASP .Net, VB.net, Management Studio, SQL Profiler, Oracle 10g, PL/SQL.

Confidential,Portland, Maine Apr07-May08
SQL Server Developer/SSRS Developer

Confidential,is a leading banking and financial services company which provides a comprehensive range of financial services: personal banking, commercial banking, insurance, and investment planning and wealth management.
My responsibilities in this bank were to support multiple SQL Server 2000 and 2005 databases, SQL Server 2000 to 2005 upgrading, and also developed and monitored SSIS packages.

Responsibilities:

• Hands on Experience in ETL (Extracting, Transforming and Loading) development using DTS and SSIS. Extensive experience in design techniques, ETL processes, relational database theory.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Extensive experience in data migration between homogenous and heterogeneous system using various tools (Data Transformation Services (DTS), BCP, SSIS).
• Administered the day-to-day operations of the financial system, making sure all processes run effectively.
• Created matrix reports, drill down reports anddevelopedreports with graphs using SSRS.
• Createddifferenttype of reports with charts using SSRS.
• Designed and developed various Service Management Reports, sub-reports, charts, parameterized reports, conditional and dynamic reports using SSRS.
• Worked on optimization and tuning of SQL queries and indexes.
• Created scripts and SQL jobs to facilitate database backup and recovery, server and data processing monitoring
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Created/developed/maintained the stored procedures, view, triggers to interpret complex business rules, history data and audit analysis
• Scheduled jobs and setup maintenance plans for monitoring the performance of SQL Server databases.

Environment: SQL Server 2000/2005 Enterprise, Windows Enterprise Server 2003,IIS 6.0, .NET, Microsoft Visio 2003, SFTP, Microsoft Reporting Service(SSRS) and SSIS.

Confidential,Newark, NJ Jan06– Mar07
SQL Server Developer

Confidential,with assets of $616 billion under management serve individual and institutional customers worldwide and include The Prudential Insurance Company of America, one of the largest life insurance companies in the US. These companies offer a variety of products and services including mutual funds, real estate brokerage franchise, relocation services and more.

Responsibilities:

• Involved in the Study of the business logic and understanding the physical system and the terms and condition for sales.
• Developed backup restore scripts for SQL Server as needed.
• Upgraded to latest version from SQL server 2000 to 2005.
• Involved in Disaster recovery and database maintenance plan.
• Performed replication of data (Transactional method used).
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Responsible for planning, executing, and maintaining data integration projects and database upgrades.
• Involved in Performance tuning and Query Optimization.
• Managed and coordinate with remote user for change request and optimization of application.
• Developed SSIS packages to bring data from Oracle, Excel and Flat Files using MS Business Intelligence (BI) tool.
• Involved in Job scheduling and alerts.

Environment: SQL Server 2000/2005, SQL Server Reporting services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), and Visual Studio.

Confidential,INDIA May04- Dec06
DB Developer
Confidential,is a division of the Conga Group, Provides software engineering services and solutions to consumers around the globe.
Responsibilities:

• Involved in designing and writing Stored Procedures, functions, views, joins and packages using T-SQL for SQL Server 2000.
• Involved in complete SDLC, which includes requirement gathering, analysis, design, development and Implementation.
• Maintained and implemented the database using SQL Server 2000 back-end tools and DTS.
• Designed, developed and administer the E-Work platform website.
• Upgrade enhancements, maintenance, support and bug fixing for the product.
• Served as a SSRS 2000 Reports Developer and SQL Server Developer in support of Service Management System
• Performed SQL Server 2000 database development, database modeling and database programming.
• Performed tasks through Enterprise Manager, Query Analyzer, Import/Export wizard.

Environment: SQL Server, T-SQL, Query Analyzer, Outlook, DTS, BCP, Enterprise Manager and Windows 2000 Server.