Professional Experience Summary

• Over 6 years of Experience in Development, Reporting, Data Modeling, support for MS SQL SERVER 2008/2005/2000/7.0 in development and Production environment.
• Development experience
• Expertise in ETL- Data Extraction, Transformation and Loading from various heterogeneous sources like SQL Server, Oracle, Access, Excel.
• Created SSIS Packages to support business processes and data transformation.
• Developed packages using some of the transformations like OLE DB, Derived Column, Script Task, Flat file, Conditional Split, Aggregate, Lookup, Execute SQL Task, Merge, Condition Split, OLE-DB command, slowly changing dimension and some other transformations.
• Using Checkpoints, Breakpoints and Data Viewers in debugging packages.
• Knowledge about Surrogate keys, Slowly Changing Dimensions, Star and Snowflake schema, Dimension and Fact tables.
• Experience with DTS packages, migration and testing of DTS to SSIS packages
• Experience in implementing business logics using stored procedures, functions and triggers.
• Experience in writing batch and T-SQL scripts.
• Experience in using tools like SSMS(SQL Server Management Studio), BIDS(Business Intelligence Development Studio)
• Involved in SDLC life cycle of the project and also have an experience from collecting data from the end user to production environment.
• Monitored Indexes, File Growths and analyzed Blocking Locking issues to remove the performance bottlenecks.
• Experience in migration of data using BCP utility, Import/Export Wizard and Bulk Insert.
• Knowledge of SSRS in creating and working with some of the some standard reports.
• Created Drill-down, Sub-Reports, Parameterized and Multi-valued parameter reports.

• MS SQL Database administration experience
• Logical modeling and physical database configuration in a clustered Windows environment
• Data migration, upgrade and cutovers
• Disaster Recovery planning
• Replication design and implementation, Mirroring setup
• Operational DBA – Performance tuning, disaster recovery, log monitoring/shipping, Level 1, Level 2 production support, applying patches, service packs and DB hot fixes.
• Experience in Troubleshooting and resolving databases and server issues.
• A Team Player with excellent communication, analytical, verbal and writing skills. A quick learner, organized, resilient and self-motivated.

Education: Bachelor in Electronics and Communication Engineering

Skills / Tools:

Databases: MS SQL Server 7.0/2000, 2005 & 2008, MS Access, FoxPro 2.6, Clipper
SQL Server 2000 Tools: Enterprise Manager, DTS, Query Analyzer, Client Network Utility, Server Network Utility, Profiler, Index Tuning Wizard
SQL Server 2005 Tools: Query Editor, SQL Profiler, Database Engine Tuning Advisor, SSMS, SSIS, SSCM, SQL Server Surface Area Configuration.
SQL Server Third Party Tools: Veritas 4.5, 5.0 and Quest SQL LiteSpeed 4.0, Erwin 3.5, 4.1
Reporting tools: SSRS, Crystal Reports 7.0
.Net Technologies: ASP.NET, XML, HTML
Programming Languages: SQL, Perl, VBScript, and VB 6.0
Front End Tools: MS Office 2000/2003/2007, MS Visio, MS Project, Business Objects.
Servers: Windows Computer Cluster Server, Microsoft Virtual Server, VM Ware
Operating Systems: MS Windows Server 2000/2003 Standard/Enterprise Edition, Windows NT 4.0 Work Station/ Enterprise Edition, Windows XP Professional.

Professional Experience:

Confidential,Glen Mills, PA November 2009 to Till Date

MS SQL/BI Developer for FundSuite ARC (for N-MFP) and FundSuite ARC Reporting at RR Donnelley (formerly Bowne | GCOM2 Solutions).
Client provides financial, marketing and business communications services around the world.
It also provides integrated solutions for Investment managers and third party fund administrators to streamline the document processes and produce high quality communications for their shareholders.

MS SQL/BI DEVELOPER

• Created new database objects like tables, views, indexes, stored procedures, user defined functions and triggers on Production database in SQL Server 2008.
• Performed ETL process for Data Extraction, Data Transformation like data cleansing, data manipulation, data consistency and loaded the data to the Production Databases using standard SSIS control flow and data flow tasks.
• Large scale ETL experience within SQL Server.
• Developed SSIS Packages to Import data from the user and load it to the database.
• Performed various Data Transformation tasks in order to meet the business requirements.
• Designed complex Stored Procedures to migrate data from Staging to Production environment.
• Migrated old legacy SQL Server 2000 DTS Packages to SQL Server 2005 and SQL Server 2008 SSIS Packages
• Optimizing SQL Queries and troubleshooting for best performances
• Install SQL Server databases, services, patches, and/or hot fixes.
• Worked on DTS Packages, DTS Import/Export for transferring data from Heterogeneous Databases.
• Configured SSIS logging for logging the detailed information.
• Migrated data from old legacy databases to new database using SSIS
• Performed Performance Tuning and Query Optimization by studying the execution plan and using the profiler to locate long running queries.
• Performed Performance tuning by having Indexes on the Tables.
• Analyzed the bottlenecks in the Stored Procedures, SQL queries and tuned them for better performance of Data Migration, also created new Stored Procedures and scripts for enhancements of the existing application.
• Respond to production and/or mission-critical issues and needs support on 24x7 basis
• Enforced referential integrity via creation of constraints on database objects
• Working in SQL Server Reporting services (SSRS) for Reports.
• Created and tested various reports depending on the business requirement using controls like Table, Chart, Matrix and Image to create reports with Drill-down, sub-reports, Parameterized and Multi-valued parameter reports using SSRS

Environment: MS SQL 2008/2005 Servers, SQL Cluster Servers, MS Windows Server 2000/2003 Enterprise Edition, Query Analyzer, SQL Profiler, SSIS, SSMS,C# .Net.

Confidential,Wilmington DE July 2008 to October 2009

Client is a leading personal and business investment planning and banking service provider.
The business portfolio database contains sensitive customer information including fixed assets, expansion and expense portfolio.

MS SQL DEVELOPER/DBA

• Created new database objects like tables, views, indexes, stored procedures, user defined functions and triggers on user databases in SQL Server 2005.
• Created and deployed SSIS packages on development, QA and Production servers.
• Developed some of the SSIS packages to load the data from the data warehouse.
• Used various transformations like Execute SQL Task, Merge, Condition Split, OLE-DB command, slowly changing dimension and some other transformations.
• Modified some of the existing packages to increase the performance by adding new logic.
• Designed and developed STAR schema data marts.
• Worked on DTS Packages, DTS Import/Export for transferring data from Heterogeneous Databases.
• Handled conditional data and data conversion using Integration services.
• Installed and configured SQL Server 2000/2005 Enterprise Edition.
• Provided maintenance support to existing SQL Server 2005 installations and new SQL Server 2008 installations.
• Granted, updated and revoked privileges to database users on database objects in SQL Server 2005.
• Populated user databases in SQL Server 2000 via DTS and BCP command line utility.
• Configured database backups via Full, Differential and Transactional Log database backup in VERITAS backup tool.
• Configured and worked on database replication, log shipping, database snapshots and database mirroring.
• Monitored lock Escalation, Dead Locks, resources utilization by sessions, capturing long running SQL queries.
• Created Database Maintenance Plans for Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.

Environment: MS SQL 2005/2000 Servers, SQL Cluster Servers, MS Windows Server 2000/2003 Enterprise Edition, Query Analyzer, SQL Profiler, SSIS, SSMS, VERITAS 4.5/5.0.

Confidential,Stamford CT May 2007 – June 2008.

Client is a global leader in office automation, management and security products and solutions. The databases I worked on supported their global logistics operations. The BI suite on MS SQL helps the client to manage and optimize shipping and fulfillment costs.

SQL SERVER DEVELOPER /DBA

• Objects moving between Development, Staging, Pre Production and Production.
• Design and development of new packages and Data flows depending on the user requirement.
• Configured SSIS objects including Dimensions, Measures and Cubes using UDM and BIDS
• Checked the source data quality against a standard data set using a Multicast.
• Assisted clients with integration and data conversion activities using SSIS.
• Automation of packages using SQL Server Jobs and creating tables to keep track of Audit.
• Maintained SQL Script for creation of Database Objects.
• Enforced referential integrity via creation of constraints on database objects.
• Populated user databases in SQL Server 2000 via DTS utility.
• Writing Stored Procedures & Functions based upon request.
• Created SQL Server traces using SQL Server Profiler for optimal performance monitoring.
• Created new user databases, database files, database files groups in SQL Server 2005 via SSMS and T-SQL.
• Created reports based on data selected such as Drop-down.
• Used variety of controls such as Table, Matrix, Chart and Image for the reports.
• Upgraded SQL Server 2000 Enterprise Edition to SQL Server 2005 Enterprise Edition.
• Granted, updated and revoked privileges to database users on database objects in SQL Server 2005.
• Scheduled backups configured database mail profiles for sending automatic mails to respective users upon failure of a database task.
• Configured and worked on log shipping, database snapshots and database mirroring.

Environment: MS SQL 2005/2000 Servers, SQL Cluster Servers, MS Windows Server 2000/2003 Enterprise Edition, Query Analyzer, SQL Profiler, Business Intelligence Development Studio, SSMS

Client is a national medical group that comprises the nation\'s leading provider of neonatal, maternal-fetal and pediatric physician subspecialty services as well as anesthesia services. I worked on and managed their main in-patient databases, and assisted in development of BI layers for disease analysis.

SQL SERVER – Production & Application Support

• Developed and designed SSIS packages using SQL Server Integration Services for loading data into SQL Server tables.
• Transformed stored procedures into a SSIS package using relevant transformations like Dataflow Task, Execute SQL Task, For Each Loop Container.
• Used Log Providers to keep track of the Log History.
• Using XML Configurations to make dynamic changes to packages.
• Deployed the SSIS Packages to the MSDB as well as File System depending on the requirements
• Automation of Packages using SQL server jobs.
• Designed, implemented, and administrated databases in SQL Server 2000.
• Maintained databases, configured permissions, and conducted backup and recovery.
• Developed stored procedures, advanced queries, trigger, views, and indexes by using T-SQL.
• Performed daily administration, monitoring, and documentation of SQL Servers.
• Automated and enhanced daily administrative tasks, including space management, backup & recovery and performance monitoring.
• Used SQL Profiler and Performance Monitor for troubleshooting, monitoring, tuning of SQL Server and SQL code. .
• Generated analysis reports using SSRS.
• Created Entity Relationship Diagrams (ERD) to successfully design a flexible database. Maintaining online documentations for entire source code
• Created Analysis reports in Crystal Reports in 7.0.
• Wrote application in VB 6.0
• Performed scheduled data uploads to database using nested queries and joins.
• Scheduled and managed jobs for data transfer using DTS packages.

Environment: MS SQL 7.0/2000 Server, MS Windows Server 2000 Enterprise Edition, Query Analyzer, SQL Profiler, SSEM, Crystal Reports 7.0, VB 6.0,

Confidential,Hyderabad, India December 2004 – March 2006

Worked as a member of corporate data group supported MS SQL, Oracle and DB2 databases for global clients, including data modeling, performance and security. Also involved in reporting applications.

Senior Software Engineer

• Designed, implemented, and administrated databases in SQL Server 2000.
• Involved in database design (Logical and Physical).
• Developed stored procedures, advanced queries, trigger, views, and indexes by using T-SQL in MS SQL 2000 and Oracle 8i.
• Performed daily administration, monitoring, and documentation of SQL Servers.
• Automated and enhanced daily administrative tasks, including space management, backup & recovery and performance monitoring.
• Installed, maintained and upgraded application software tools, on servers and client computers.
• Wrote code and creating jobs to automate repetitive tasks.
• Performed Application implementation on Client site.
• Did Visual Basic Programming and Report Designing in Crystal Reports 7.0
• Handled End user Training and software maintenance.

Environment: MS SQL 7.0/2000 Servers, Windows 2000/NT servers, Crystal Reports 7.0, Visual Basic 6.0.

Worked with data modeling, database development and support of several SME client database applications.

• Developed stored procedures, advanced queries, trigger, views, and indexes by using T-SQL in MS SQL 7.0.
• Writing code and creating jobs to automate repetitive tasks.
• Designed and Developed applications in VB 6.0 and FoxPro 2.6
• Involved in User Interaction, Requirement Analysis.
• Involved in Visual Basic Programming and Report Designing in Crystal Reports 7.0
• Performed daily administration, monitoring, and documentation of SQL Servers.

Environment: MS SQL 7.0, Crystal Reports 7.0, VB 6.0, FoxPro 2.6