Professional Summary

• Over Eight years of experience in IT Industry as a SQL Server Developer / SSIS Developer / DBA.
• High proficiency with SQL Server Architecture (Fundamentals of SQL Server Architecture, Features of SQL Server, Relational Database Components, Database Architecture, Relational Database Engine Architecture, Administration Architecture, Application Development Architecture).
• Strong Transact-SQL Query writing skills (DDL- data definition language and DML- data manipulation language).
• Good understanding of Normalization/De-normalization, Normal Form and database design methodology.
• Strong SQL Server 2000/2005 Developer Skills including writing stored procedures, user defined functions, views, query writing.
• Experience in Tuning SQL queries and T-SQL queries & improving the performance of the Database.
• Scheduled jobs, alerts, DTS, SSIS Packages in SQL server.
• Experience in understanding ETL requirements and designing the ETL process and architecture and automation of ETL process
• Bulk data migration using SSIS from flat files.
• Knowledge of business intelligence/data warehousing practices and tools (including MS SQL Reporting Services).
• Created Reports with complex formulas and to query the database for business Intelligence.
• Involved in User Acceptance and system testing, bug fixing and documentation for the project.
• Excellent communication, learning, problem solving and conceptual skills. Proficient in technical writing and presentations.

Technical Skills

Databases: MS SQL Server 2008, 2005 & 2000, MS-Access97/2000, Oracle 9i & 10g, Teradata, Mysql 5.02
Database Tools: Enterprise Manager, Query Analyzer, SQL Profiler, SSIS, SSAS, SSRS, DTS, BCP, Management Studio, Business Intelligence Studio, ETL, Erwin
Languages: C, C++, VB.NET, XHTML, JAVA 1.4.2, SQL, T-SQL,XML 1.0
O.S: Win 2003, Win 2000, Win NT 4.0 & XP, UNIX.
Web Servers: IIS 5.0, Apache 1.3.
Other Tools: Microsoft Visual Studio 2003/2005, Microsoft Visio2003, Crystal Reports 8.0, Visual Basic, MS Excel,TFS,MS Visual Source Safe
Architecture: Relational DBMS, Client-Server Architecture, OLAP, OLTP

Work History

Midland Loan Services is a subsidiary of PNC Real Estate Finance. Midland is one of the largest providers of third-party loan servicing and technology solutions for the commercial real estate industry. Midland provides the full scope of commercial loan servicing for institutional, agency and commercial mortgage-backed securities (CMBS) portfolios - including loan payment collections, asset management, and advisory services.

Responsibilities :

• Interact with clients to analyze business needs. Provide software product design and developed technical roadmap for the solution through the project lifecycle and beyond.
• Worked with various tasks of SSIS include Transform Data Task, Execute SQL Task, FTP Task, For Each Loop containers etc
• Created SSIS packages for Uploading of different formats of files (Excel, Access, dbf) and databases (SQL server, Flat files) into the SQL Server data warehouse using SQL Server Integration Services (SSIS).
• Troubleshoot failed jobs on the server which involved stored procedures/SSIS packages.
• Scheduled the SSIS packages to run at different intervals to load the data.
• Responsible for creating schema objects like tables, views and indexes.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server
• Created stored procedures to be used by front end report development.
• Work with DBAs, QA and systems support personnel in elevating and automating successful code to production.
• Used TFS for version control.
• Created documentation as required for operational support.

Environment : SQL Server 2008, SQL Server 2005, SQL Server 2000, BIDS, T-SQL, ODBC, TFS, MS Excel, MS Access, Visio, OBIEE.

Hotels.com provides great prices on the places you want to stay for both leisure and business travel. Hotel experience is an important part of trip. This is why Hotels.com provides insight on broad selection of hotels through current, unbiased hotel reviews from discerning guests just like you who have stayed at the property. Hotels.com acts as a resource for like-minded guests to review and rate properties, give recommendations and gather information for upcoming trips. As a sole developer for Hotels.com – HCOM team, I was involved in various projects and phases of development.

Responsibilities :

• Create functional and technical specifications for projects.
• Responsible for logical and physical design of database for new projects using Microsoft Visio.
• Responsible for creating schema objects like tables, views and indexes.
• Created stored procedures to be used by front end application servers.
• Mentor end users about SQL Queries.
• Created numerous SSIS Packages for transferring and manipulating data from heterogeneous DBMS using various connections, workflows and tasks like ActiveX Scripting, Global Variables, different phases of Data Pump Task and more.
• Used BCP command and TSQL commands to bulk copy the data from Text files to SQL Server and vice versa.

Environment : SQL Server 2005, SQL Server 2000, BIDS, T-SQL, ODBC, TFS ,MS Excel, MS Access, Visio.

HCR Manor Care is a major provider of both short-term post-acute and long-term care in United States. It has more than 500 skilled nursing and rehabilitation centers, assisted living facilities, outpatient rehabilitation clinics, and hospice and home health care offices. This project is collecting all the patient and facility information from different sources into the data warehouse.

Responsibilities :

• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Created numerous SSIS Packages for transferring and manipulating data from existing SQL databases, Oracle data sources, flat files, access DBs and excel files using various connections, tasks, Global Variables etc.
• Worked with various tasks of SSIS including ForEach Loop Container, Active X Script Task, File System Task, Script Task and various Data Transformation Tasks.
• Creating ETL design flow documents for the SSIS packages.

Environment : SQL Server 2005, BIDS, T-SQL, ODBC, MS Excel, MS Access, Oracle 9i/10g, Visio.

Confidential - Bridgestone, Muscatine, IA Jul 2008 – Sep 2008
SQL Server Developer

Bandag is a leading tire retreading company associated with Bridgestone. The project is an upgrade of the servers from SQL Server 2000 to SQL Server 2005.

Responsibilities:

• Created Synonyms for all the objects that resided on other servers.
• Designed and implemented stored procedures, views and triggers for automating tasks in TSQL.
• Create database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.
• Was involved in performance of the system.
• Created temporary tables, table variables and indexes.
• Performed ETL operations to support the data loads and transformations.
• Developed and designed SSIS packages for importing the data from ODBC sources, MS Access, MS Excel, flat files etc.
• Implemented MOLAP and ROLAP cubes for data warehouse.
• Performance tuning and testing on stored procedures, indexes, and triggers.

Environment: SQL Server 2005 Enterprise Edition, SQL Server 2000, T-SQL, ODBC, MS Excel, Access, SSIS Packages, SSAS, SSRS, Microsoft Visual SourceSafe, Windows 2000/XP

Health Markets is one of the leading providers of employee benefits, including: health care coverage, group life, accident and disability insurance. This system handles all functionalities such as payment to providers, claim status enquiry and development of claim remittance advice n-tier architecture.

Responsibilities:

• Interact with clients to analyze business needs. Provide software product design and developed technical roadmap for the solution through the project lifecycle and beyond.
• Physical Implementation of database into SQL Server 2005 using T-SQL.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity checks, Database Statistics update and Re-indexing
• Created checks and constraints to maintain data integrity.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Created complex stored procedures and functions to support efficient data storage and manipulation.
• Created numerous SSIS Packages for transferring and manipulating data from heterogeneous DBMS using various connections, workflows and tasks like ActiveX Scripting, Global Variables, different phases of Data Pump Task and more.
• Used BCP command and TSQL commands to bulk copy the data from Text files to SQL Server and vice versa.
• Created reports using SSRS and posted to the web portal.
• Configured various Publishers and Subscribers for Snapshot and Merge replications.
• Planned complete Back-up of Database and Restored the Database from Disaster Recovery.
• Coordinating post-implementation events such as testing.

Environment: SQL Server 2005, SSIS, SSRS, ER-Win, T-SQL, Excel, Access.

Confidential, Pittsburgh, PA July 2007 – March 2008
SQL Server Developer/DBA

Merrill Lynch is one of the largest financial institutions in the world. It keeps money flowing to mortgage lenders in support of homeownership and rental housing. The project is Transactional System Modeling. All the data that was previously stored in access databases has to be migrated to SQL server databases.

Responsibilities:

• Involved in gathering and analysis of user requirements.
• Create functional and technical specifications for projects.
• Responsible for logical and physical design of database.
• Responsible for database design and creating schema objects like tables, views and indexes.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Mentor end users about SQL Queries.
• Scripted queries using complex table joins.
• Create database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.
• Bulk data migration using SSIS from flat files.
• Developed packages utilizing import/export wizard and SSIS Package Designer to transform/load the data.
• Worked with various tasks of SSIS include Transform Data Task, Execute SQL Task, Active Script Task etc.
• Created SSIS packages for Uploading of different formats of files (Excel, Access, dbf) and databases (SQL server, DB2, Oracle, Flat files) into the SQL Server data warehouse using SQL Server Integration Services (SSIS).
• Scheduled the SSIS packages to run at different intervals to load the data.
• Created documentation as required for operational support.
• Performance tuning and testing on stored procedures, indexes, and triggers.
• Created SSAS cubes and dimensions for data mining.
• Performed daily back up of entire database and recovery.
• Created Reports with complex formulas using SSRS to query the database for data warehouse.

Environment: SQL Server 2005 Enterprise Edition, T-SQL, ODBC, MS Excel, Access, Crystal Reports, SSIS Packages, SSAS, SSRS, Visual Basic, Merrill Lynch Integration Framework, Sharepoint, Windows 2000/XP, IIS 5.0

Confidential, Dallas, TX Sep 2006 – Jun 2007
SQL Server Developer/Production Support Engineer

The Verizon Price was designed to improve the way external agents and business account managers, account executives, and sales executives within the east and west Business Partnership Channels (BPCs) generate price quotes. The Competitive Pricing Tool or Pricing Tool initiative required the development of a single, user-friendly application to assist the agents in developing accurate pricing quotes, creating network diagrams, and an automated way to assess the needs of customers in order to make better product recommendations, and create a real-time professional proposal based upon the parameters provided by the customer etc.

Responsibilities:

• Experience in writing, solving and debugging,
• Responsible for optimization & tuning complex Transact SQL queries
• Written large number of stored procedures and triggers.
• Written complex queries for creating Views which are useful for Reporting.
• Utilized BCP for transferring data from flat file to SQL SERVER.
• Creation of all database objects as desired standards and setting permissions and wrote DDL & DML Statements.
• Involved in checking database consistency, data integrity and data redundancy.
• Involved in snapshot replication of the production database

Environment: SQL Server 2000, Windows 2000 Server, Teradata, DTS, Crystal Reports 8.0

Confidential, Oklahoma City, OK Jan 2006 – Aug 2006
SQL Server Developer / DBA

CNA is the 7th largest U.S. Commercial Insurer and the 14th largest U.S. Property & Casualty Insurer. The application is useful for vendors and lawyers for the internal acceptance of the policies. The application receives the input data from online booking policy customers. The data can manually be entered by staff once when the lawyers approve in the presence of customers and edit according to the needs of the policies requested by the customers. Auto Quote Generation, Quote Submissions, Policy Renewals, Reinstatements, Reissues, Coverage Charts, Endorsements, Conditions, Regular Solicitation Processes for its products, sub-products and their corresponding coverage limits are the aspects involved.

Responsibilities:

• Designed and implemented stored procedures, views and triggers for automating tasks in TSQL.
• Worked on improving the performance of the system.
• Involved in the tuning of the existing Database Objects.
• Created permanent tables, temporary tables, table variables and indexes.
• Involved in translating business requirements into technical design specifications.
• Designed and deployed various complex reports using MS Reporting Services.
• Created and generated reports to display data.
• Used Query Profiler to optimize SQL queries.
• Performed ETL operations to support the data loads and transformations.
• Developed and designed DTS packages for importing the data from MS Access and MS Excel.
• Loaded data from flat files and XLS files into SQL Server 2005 using SSIS.
• Implemented MOLAP and ROLAP cubes for data warehouse.
• Developed and executed several optimized queries in SQL.

Environment: SQL Server 2005, SQL Server 2000, Windows 2000 Server, ETL, DTS, SSIS, SQL Profiler, MS SQL Server Reporting Services, MS Excel, Visual Basic.

Confidential, Detroit, MI Jan 2004 – Dec 2005
SQL Developer

Detroit Medical Center continues to meet the health care needs of a growing community, offering the best in medical research and development, advanced technology and optimum clinical services.

Responsibilities:

• Created stored procedures and functions to support complex health management logic.
• Optimized the performance of queries with modification in TSQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes to assimilate client information from multiple tables.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Wrote custom T-SQL stored procedures and triggers to improve performance, reduce latency, preserve referential integrity, and provide additional application functionality.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.

Environment: SQL Server 2000 Enterprise Edition, T-SQL, ODBC, Excel, Access, Windows 2000/XP.