SUMMARY

• 12+ years of IT experience in Analysis, Design, Development, Testing and Administration activities of business application on SQL Server database technologies.
• Worked extensively on all facets of the project (Complete SDLC).
• Proficient in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS Import or Export Data, Bulk Insert and BCP.
• Proficient in Data Modeling, Data Mapping using ERWin and MS Visio tool.
• Experience in developing the applications using T - SQL Programming (DDL, DML).
• Proficient in creating DB Objects such as Tables, Views, Stored Procedures, User Defined Functions (UDF), Indexes, Cursors and Triggers.
• Experienced in using SQL Profiler, Index Tuning Wizard and Windows Performance for maintaining performance.
• Skilled in tuning SQL queries and improving the query performance.
• Proficient in Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export, Troubleshooting, and Database Objects authorization.
• Expertise in planning and implementing MS SQL Server Security and DB permissions.
• Proficient in analyzing and translating Business Document (BRD) to Technical Document (TRD) specification.
• Experience in scheduling and implementation (pre-implementation- implementation- post implementation actives) of medium/major size projects.
• Experience in creating reports using SSRS (SQL Server Reporting Services), Crystal Reports.
• Expert in automating process by creating jobs and error reporting using Alerts, SQL Mail Agent, FTP and SFTP.
• Proficient in Designing and Developing DTS/SSIS packages.
• Proficient in upgrading/migrating from DTS packages to SSIS packages.
• Experience in Agile, Scrum and Rational Process (waterfall) models.
• Manages team effectively and deliver critical projects on schedule.
• Enthusiastic, Dedicated, Well-organized, Goal-Oriented with excellent analytical, designing, programming, troubleshooting and problem solving skills.
• Highly motivated conceptual individual with exceptional communicational, work ethics and capable of quickly learning skills.
• Experienced in industry application areas include Transportation, Healthcare, Education, Insurance, Automobile and Banking.

TECHNICAL SKILLS

Databases: SQL Server 2008/2005/2000/7 , MS Access 2003, MySQL 5.1

Platforms: Windows Server 2008/2003/2000/ NT, UNIX, WAMPSERVER 2.0, Apache 2.2.

Reporting Tools: SSRS, Crystal Reports 8/9/10/XI, Crystal Enterprise 10

Languages/Utilities: SQL, T-SQL, PL/SQL, VB 6.0, VB.NET, ASP, ASP.NET, XML, XSL, PHP 5.3, VBScript

Tools: Visual Studio 2003/2005/2008 , BCP, BIDS, SSMS, SQLCMD, DTA, Profiler, SQL Agent, MS VISIO, ERWin 4.1/7.0, PHPDesigner 7.0

Web Technologies: HTML, DHTML, CSS, UML

Business Intelligence: SSIS/DTS, SSAS

Version Control: VSS, TFS, PVCS

PROFESSIONAL EXPERIENCE

Confidential, Milford, OH

Technical Consultant

Responsibilities:

• Worked closely with business constituencies to translate business requirements into technical architectures.
• Interacting with client, functional experts and developers to isolate & resolve issues.
• Provide end to end visibility of Logistics Management System.
• Import and export data between databases and between the system and applications such as CSV, MS Excel and MS Access.
• Created packages using Integration Services (SSIS) for data extraction from Flat Files, Excel Files, Access, DB2, Oracle etc.
• Created SSIS packages to extract data from OLTP to DW systems and scheduled Jobs to call the packages and Stored Procedures.
• Designed and mapped using SSIS Transformations like OLEDB Command, Conditional Split, Aggregator, Multicast and Derived Column.
• Designed and developed SSIS packages to move data from staging environment to production environments.
• Strong knowledge and working experience in Backup/Restore, Point-in-Time Recovery and DR (Disaster Recovery) Solution.
• Developed Different Maintenance Plans for database monitoring.
• Created stored procedures, functions and database triggers to validate the data into the database.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Partook in Logical and Physical design of database for projects using ERWin
• Performed defect fixes in various environments like UAT, SIT to ensure the proper delivery of the developed jobs into the production environment.
• Created summary report, lists the name of the facility, reporting period, stock on hand, receipts, quantities issued or dispensed and ending stock on hand.
• Generated ad-hoc queries and daily\weekly\monthly\yearly feed and reporting on contracts using SSRS (SQL Server Reporting Services).
• Attended daily status call with internal team and weekly calls with client and updated the status report.
• Used TFS tool for source control, data collection and project tracking.
• Supports & provides guidance to team to achieve personal, team & professional goals.
• Ensures internal process compliance at the managed team level.

Environment: Windows 2008 Server, Visual Studio 2008, VB.NET 4.0, ADO.NET, VBA, MS SQL SERVER 2008, SSIS, SSMS, SSRS, MS Excel 2010, MS Word 2010, TFS, ERWin.

Confidential, Illinois, IL

Technical Consultant/ Sr.Developer (SQL ETL\ DB Developer)

Responsibilities:

• Identified innovative ways to improve the process flow - efficiency and agile.
• Denormalize databases and created some redundant columns for performance.
• Created packages in SSIS Designer to implement business rules.
• Created SSIS packages to load data from Source like Excel, Access and Flat files.
• Transformed data from various data sources using OLE DB connection by creating various SSIS Packages.
• Created mappings such as sort, derived column, conditional split, pivot and lookup etc.
• Configured Server for sending automatic mails to the respective people when a DTS process success or failure.
• Created Triggers to enforce data and referential integrity.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Provided technical leadership/management skills in functional/program areas to execute projects.
• Generated Report using SSRS (SQL Server Reporting Services).
• Present periodic dashboard reports on the current program, opportunities and issues.
• Setting reasonable, challenging and clear performance goals for direct reports, monitors performance & provide appropriate feedback.
• Writing ad-hoc queries and stored procedures for custom reporting.
• Identify the potential risks and classify them based on criticality.
• Prepare back up plans to mitigate or reduce or eliminate risks or recurrences.
• Used Data Viewers in SSIS Packages to see whether the data flow properly or not.
• Ensuring delivery in line with customer expectations for projects.
• Prioritize the requirements and delegates the task to team according to their capabilities.
• Tracks competency gaps that exist among team members & ensures that relevant learning / appropriate tasks are assigned.
• Used TFS tool for source control, data collection and project tracking.

Environment: MS SQL Server 2008, Windows 2008 Server, Visual Studio 2008, SSIS, SSMS, SSRS, TFS, Visual Web Ripper, Excel 2007, Access, SQL Query Analyzer.

Confidential, Vallejo, CA

Consultant/ Sr.DB Developer

Responsibilities:

• Interacting with client, functional experts to translate business requirements into technical architectures.
• Created PHP scripts for display dynamic data retrieved from MySQL database, account creation and management, data input into database, to upload files onto server and into database.
• Managed user and data security which includes login, user and role creation.
• Created procedures and functions to manage the data and triggers for data automation.
• Normalized database tables and performed extensive query optimization.
• Design pattern driven by MVC (Model-View-Controller).
• Created the Indexed Views for better performance.
• Based on the business needs created replication models on applications.
• Detailed documentation of code and maintenance of all changes made to system.
• Generated reports on weekly and monthly basis as per the client requirements.
• Maintained consistency in programming to support proper testing and maintenance.
• Followed code standards as per requirement.

Environment: HTML, CSS, XML, OOP, JavaScript, Apache 2.2, PHP 5.3, PHPDesigner 7.0, MYSQL 5.1, WAMPSERVER 2.0.

Confidential, Hartford, CT

Sr.SQL Server Developer/DBA

Responsibilities:

• Consult and mentor technical resources concerning standards to be used.
• Developed SSIS packages to transfer data from heterogeneous databases & different files format (Text File, Spread Sheet, and XML) to SQL Server 2005.
• Designed and mapped using SSIS Transformations like OLEDB Command, Conditional Split, Multicast and Derived Column.
• Distributed data from one database to another and then synchronizing between databases to maintain consistency.
• Developed stored procedures, triggers to handle complex business rules.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Scheduled and monitored all maintenance activities of SQL Server 2005 including database consistency check and index defragmentation.
• Planning for backup and recovery of SQL database information.
• Automated process to ship transaction log backups to another server.
• Deployed database objects from development to testing environment and to production environment.
• Developing database policies and ensuring that databases are maintained in accordance with these policies.
• Refreshing database from production to various environments (Test, Dev) as per request.
• Managed user and data security which includes login, user and role creation.
• Partitioned tables, which have frequent insert, delete and update to improve performance.
• Monitor SQL Server Error Log, space usage.
• Ensuring that SQL database problems are investigated, diagnosed and resolved.
• Used Visual Source Safe (VSS) tool for Version Control.

Environment: SQL Server 2005, Windows Server 2003, SSIS, SSMS, T-SQL, IIS 6.0, Profiler, DTA, VSS.

Confidential, Hartford, CT

Sr.SQL Server Developer/DBA

Responsibilities:

• Work together with business analysts, team members for requirement gathering.
• Defined database upgrade strategy to relocate database to new servers.
• Involved in installation and configuration of SQL server 2000 on servers.
• Applied patches and service packs to keep the database at current patch level.
• Upgrade the SQL Server 2000 databases to SQL Server 2005.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Based on the business needs created replication models on applications.
• Implementing Log Shipping standby servers.
• Performed back-ups, restores, scheduled SQL jobs and maintained SQL Server databases.
• Created clustered index & performed index tuning for optimization.
• Developed triggers to enforce data and referential integrity.
• Wrote SSIS Packages to migrate logins, stored procedures and functions.
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
• Generated script files of the databases whenever changes are made to stored procedures or views.
• Periodically check all databases with DBCC commands for maintaining data consistency and integrity.
• Creating and reviewing trace file using SQL Profiler to troubleshoot issues, as required.
• Used Visual Source Safe (VSS) tool for Version Control.

Environment: MS SQL Server 2005/2000, Windows Server 2003, T-SQL, DTS, SSIS, SSMS, BIDS, EM, IIS 6.0, VISIO 2003, VSS, SQL Query Analyzer.

Confidential

Sr.SQL Server Developer/DBA

Responsibilities:

• Automated and scheduled SFTP to transfer data from other systems.
• Created DTS packages to load data from Source like CSV, Excel, ORACLE, SQL 2000 and MS Access.
• Developed and modified stored procedures, triggers to handle complex business rules.
• Managed databases including performance tuning, database consistency checks.
• Developing guidelines for database activity with the view to ensure access to data.
• Creating roles and managing user permissions, resolved deadlocks.
• Created alerts, notifications and emails for system errors, insufficient resources, fatal database errors, hardware errors and security breach.
• Used SQL Profiler for troubleshooting and monitoring SQL Server.
• Tested and implemented Log Shipping and Replication for HA solution for databases.
• Setting standards for SQL database objects (e.g. naming conventions, index creation etc.) and ensuring compliance to these standards.
• Writing ad-hoc queries and stored procedures for custom reporting needs.
• Maintain all the SQL documents include installation and data transfer procedures documents.
• Worked closely with the team to create and modify functionalities to modules as per business rules.

Environment: MS SQL Server 2000, Windows Server 2000, DTS, T-SQL, IIS 6.0, ASP.NET, Crystal Reports 10, SFTP, SQL Query Analyzer, .NET Framework.

Confidential

SQL Server Developer/ DBA

Responsibilities:

• Data Transfer from other systems to master tables using DTS-Import/Export wizard.
• Manage Database environments including trouble shooting, performance and backup/recovery.
• Proactive monitoring of databases including database optimization and health checking.
• Performed daily tasks including check for failed processes, analyze errors and validate disk space.
• Developed SQL scripts for maintaining administration tasks.
• Proactively monitoring the database including daily backup check, performance, server disk space, logs etc.
• Applied patches and service packs to keep the database at current patch level.
• Troubleshoot and resolve database and/or application problems encountered by end users.
• Collaboratively work with team to ensure the issues don’t crop up.
• Used PVCS tool for revision control of files, in particular source code files.

Environment: MS SQL Server 2000, Windows Server 2000, T-SQL, DTS, .NET Framework, ASP.NET, PVCS.

Confidential

SQL Server Developer

Responsibilities:

• Created VBCOM Components for transferring data from the front-end to the database.
• Developed Help file for OFA module (Order Fulfillment & Advanced Shipping Notification) with index and searches.
• Involved in OFA, VMI (Vendor Managed Inventory) and SSI (Self Service Invoicing) modules.
• Designed VB forms and view reports in VB form using Crystal Reports.
• Created Triggers to enforce data and referential integrity.

Environment: Windows NT 4.0, ASP 2.0, VB 6.0, VB Script, XML, SQL Server 7.0, Crystal Reports 8.0.

Confidential

SQL Server Developer

Responsibilities:

• Created VBCOM Components for transferring data from the frontend to the database.
• Coded Stored Procedures, functions and triggers at high level.
• Developing RFQ (Request For Quotation) module and was responsible for developing COM/XML components and developed ASP Pages.
• Designed VB forms and view reports in VB form using Crystal Reports.

Environment: Windows NT 4.0, ASP 2.0, VB 6.0, VB Script, XML, SQL Server 7.0, Crystal Reports 8.0.

Confidential

Programmer

Responsibilities:

• Involved in screen designs, development and testing of the programs.
• Created procedures for calculation and database triggers to validate the data into the database.

Environment: Windows NT 4.0, ASP 2.0, VB 6.0, VB Script, HTML, XML, SQL Server 7.0.