Database Resume
Summary of Experience:
5+ years experience in the Information Technology field as a Database Developer.
Dedicated, hard working individual with the intercommunication skills.
Works well in both team environments and individual assignments.
- Around 5+ years of experience in clear understanding of Database design concepts and designing and implementing databases with Microsoft SQL Server 2005/2008/2008R2.
- Proficient in Microsoft SQL Server 2005/2008/2008r2 with T-SQL programming, creating Stored Procedures, Triggers, Views, Indexes, Joins, User Defined Functions and Cursors.
- Experienced in Backup and Restores, Performance Monitor, Batch Transactions, Locks, Constraints,BCP,Security,SQL Server Agent, SQL Profiler, Job Scheduling, Replication,clustering, Performance tuning, Normalization /De-normalization concepts, database design methodology and Data Modeling.
- Worked on tasks like data loading, data unloading. Strong skills in writing complex data manipulation queries with T-SQL.
- Experience in using SQL Server Integration Services (SSIS).
- Created SQL Server Reports using SQL Server Reporting Services (SSRS).
- Good working knowledge of SQL Server OLAP and Analysis Services (SSAS).
- Programming and development in Client/Server Applications using SQL Server.
- Proficient with MS Office skills with an emphasis on MS Excel,MS Access knowledge.
Technical Skills:
- Languages: C#,VB.NET, Java.
- WebTechnologies: HTML, DHTML,XML,JavaScript,ASP.NET
- Databases:MS SQL Server 2005/2008/2008r2, MySQL,MS Access ,Oracle.
- ETL Tools: DTS,SSIS, SSRS ,SSAS
- OS Platforms: Windows Server 2003/2008, Windows XP Professional, Windows NT/XP,
- Unix and MS Dos
- Applications: SQL SERVER Management Studio, SQL SERVER Business Intelligent Development Studio.
Master of Computer Applications (MCA)
Employment:
Working as a Database Developer with Confidential.
Professional Experience:Client: Confidential, NJ Sep’2009 –jul’2012
Involved in the project of creating Customer Credit Information system in which a whole new database system (20 GBs) was created for recording the information of credit card holders: finding revenue information, payment schedules, delinquency rate etc and generating reports on periodic basis. The project was also involved in migrating distributed data from different departments to the new centralizedSQL Server Database.
Responsibilities:
- Experience in SQL Server 2005/2008 with Management Studio development environment.
- Actively participated in gathering Business Requirements and System Specification from users.
- Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle).
- Creating and running SSIS Packages for Import and Export of Heterogeneous Data.
- Worked on SSIS Packages, changes Structure of tables and created new Columns during transformation using SSIS packages.
- Creating (SSIS) packages to gather data from various sources.
- Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.
- Using SQL Server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
- Making a Report as per requirement using MS Reporting Services 2008(SSRS).
- Experience in SQL Server Analysis Services (SSAS) for data mining to identify rules and patterns in the data.
- Worked with SQL Server Analysis Services (SSAS) that delivers online analytical processing (OLAP) and data mining functionality for business intelligence application.
- Developed stored procedures and triggers to facilitate consistent data entry into the database.
- Developed stored procedures to retrieve customer information from as required to evaluate eligibility for loan requests, account status etc.
- Wrote store procedures to generate account statements for different types of accounts.
- Monitoring performance and optimizing SQL queries for maximum efficiency.
- Job Monitoring and Scheduling.
- Fine tuning of database objects and server to ensure efficient data retrieval.
- Develop documentation that sufficiently describes technical deliverable as required for internal controls so that the maintenance responsibility can be passed on to production support team.
Environment: MS SQL Server 2005/2008 , SSIS,SSAS,SSRS ,SQL Server Management Studio,
SQL Server Businesss Intelligence Studio,Windows Server 2008.
Client: Confidential, NJ. Jul’08 – Aug’09
Post trade services are managing and maintaining all the data related to the trades after they are initiated in the market. Whether a trade was settled, cancelled, postponed or never finished, all the information is collected through Legacy systems and then reconciled in the night before the next trading day starts. Based upon this data, various reports are generated. We developed the Production support website to monitor the nightly recon and production issues. The development, maintenance and enhancement of this website are done by the onsite team. I was one of the team members for Merrill Lynch Development team. GMI GEF&S, Merrill Lynch Project consisting of development, maintenance and enhancement of the Existing Project
Responsibilities:
- Actively Involved in a Database Design, Coding and Testing.
- Actively involved in creation of required database, modified tables, triggers, and procedures to clean and validate the data to meet the specifications.
- Created views and indexed views as required by front end developer for easier implementation on web pages.
- Created stored procedures and functions to support efficient data storage and manipulation.
- Involved in metadata modeling, creating a project, creating and publishing the package.
- Converted the DTS Packages into SSIS using Migration Wizards.
- Used complex queries to pull data from excel as well as other databases to the table that has been designed schema.
- Optimized the performance of various stored procedures by redesigning T-SQL queries and changing connection and server level settings.
- Actively Involved in Testing and Debugging the Stored Procedures and T-SQL.
- Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
- Extracted the data from SQL Server 2000 to the SQL Server 2005 using SSIS as ETL tool.
- Developed a Tabular Reports using SSRS Report Designer.
- Implemented the Package configuration using XML files.
- Involved in metadata modeling, creating a project, creating and publishing the package.
- Used custom queries in certain reports.
- Involved in query tuning for increasing the query performance.
- Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
- Designed and implemented critical system recovery plan through different stages of backup and replication.
- Transformations of data such as adding derived column, sorting of data, merging of data has been done while pulling data from SQL Server 2000 to the SQL Server 2005.
- Created various Stored Procedures to validate the data from Source and update the records and insert them into a newly created table.
- Build test scenarios and test cases (negative / positive) to validate expected outcome
- Migrated tables to the Data Warehouse using DTS for reporting purpose.
Environment: SSIS,SSAS,SSRS,SQLServer Businesss Intelligence Studio,DTS, Windows XP,IIS,
SQL Server 2005 .
Confidential May ’07 – Jun’08
Client: Confidential, Lake Forest, IL
Confidential works with healthcare industry in providing services like medical waste and sharps disposal management, product recalls and retrievals, healthcare on-site waste stream management, and pharmaceutical waste disposal. Steriworks is a Windows forms application that can be used by internal staff to track the medical waste and recycling process, send emails, and print reports that can be used by the field staff or for analysis by internal teams.
Responsibilities:
- Involved in designing of Conceptual Logical Model and Physical Model.
- Developed Database Triggers to enforce Data integrity andadditional Referential Integrity.
- Created SQL reports, data extraction and data loading scripts for different databases and schemas.
- Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports.
- Wrote Transact SQL utilities to generate table insert and update statements.
- Involved in performance tuning and monitoring of T-SQLblocks.
- Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
- Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
- Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
- Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
Environment: SQL Server 2005,T-SQL, MS Analysis Services, .Net, CVS, Windows NT/2000/XP
Confidential. May’06 - Apr’07
This consisted of the monthly releases for the data warehouse environment for the CapitalOne auto finance. This project involves the new changes to the Capital One Auto Finance Database structure and also the enhancements to the existing database architecture.
Environment: MS SQL Server 2000, Windows 2003.
Responsibilities:
- Migrating SQL Server 2000 DTS Packages to SSIS Packagesfor uploading various formats of files and data to MS SQL Server 2005.
- Data warehouse (GDW) using SQL Server Integration Services (SSIS).
- Used SQL Server to develop SSIS and ETL (Extract, Transform, and Load), for import/export jobs to transfer data from one database to another within SQL Server.
- Developed SQL scripts, Stored Procedures and Views.
- Created Reports using SQL Server Reporting Services (SSRS) as per the requirements.
- Performed the Unit testing.
- Provide necessary inputs to QA to perform testing. Resolved issues raised by QA Team from Quality Center.
- Coordinated with the implementation team to deploy the code into the production environment.