Over 7 years of experience in Database Management, Data of Business Applications using the Oracle, Access and SQL Server Relational Database Management System. Oracle PL/SQL Developer Certified Associate with excellent knowledge and hands-on experience of Oracle environment, including Stored Procedures, Triggers, Functions, Views and Packages. Experience in development of Procedures, Functions, Packages, ETL processes and Database Triggers. Excellent understanding of the software development lifecycle (SDLC), which includes Build & Release Management analysis, design, development, testing and implementation of software applications. Oracle expertise includes good understanding of in-depth database architecture, evaluation of application products, database design, development and administration, SQL Performance analysis using Explain Plan. Experience in installation, programming, configuration, and administration of MS SQL Server and oracle databases. Experience with analyzing business and data requirements for reducing data redundancy. Experience with developing and designing methods and procedures for collecting, organizing, interpreting, and classifying information for input into computer and retrieval from computer, utilizing knowledge of symbolic language, optical or pattern recognition, database construction, and retrieval methods. Supported the business with data analysis and report development in Business Objects Business Intelligence (BI), Crystal Reports, PL/SQL, MS Access, MS Excel, MS PowerPoint, MS Outlook, Pivot Tables, charts, graphs. Data flow analysis using use cases, dataflow diagrams, state diagrams, sequence diagrams, activity diagrams and class diagrams. Experience with Microsoft office tools, Visio and troubleshooting PCs. Experience with creating figures, bore logs and maps using AutoCAD and CorelDraw. Works well in teams or independently; functions well in fast paced, high-pressured environments and effectively sets priorities to meet deadlines in a technically challenging environment. Experience in Documentation that involves functional specification, user Manual and technical review.
Database Specialist III01/2011
to 06/2014 Daniel B. Stephens & Associates, Inc
Design and develop processes to perform complex ETL processes Designing and Implementation of database using SQL Server 2005/2008/2012, MS Access, and Oracle 9i, Oracle 11g on a Windows XP Platform.
Creating PL/SQL packages to perform validations on the imported data from legacy system before loading into interface tables.
Imported data of different types into databases, developed customized queries using SQL to manipulate data and to ensure quality assurance.
Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements in Oracle data warehousing.
Importing and merging large databases, performing searches using hierarchical queries, developing modules and macros to manipulate data within databases, developing custom utilities and interfaces to enhance functionality, and facilitating database management.
Tuning SQL queries and performed refinement of the database design leading to significant improvement in system response time and efficiency.
Providing support to SQL reporting for preparing reports of all counters like Disk Space, CPU and Memory utilization.
Monitoring and managing database backup, log, and restoring and recovering data as required.
Creating and maintaining online link for the databases using MySQL and PHP.
Creating forms like Data Entry, Quality Assurance using .Net.
Experience in database installation, configuration, development, security implementation, back-up and recovery (Oracle import / export utility, SQL* Loader) and performance tuning by using SQL Trace Hands on experience on writing SQL queries, PL/SQL procedures, Functions, Triggers in Oracle server and database testing.
Successfully loaded large volume of log data into SQL Server database, and did data analysis, generated varieties reports using Crystal Report XI-2008.
Implementing a data cleansing and auditing system using ETL(SSIS) to load data from excel file, programming using cursor and stored T-SQL procedures in SQL Server 2008-2005 database.
Designing High Availability and High Performance SQL servers with Mirroring, Clustered failover, Replication, and Log Shipping to solve business issues.
Hand on experiences with DTS, Integration Services and other ETL tools.
Managing SQL servers for OLTP applications and data warehouse for reporting.
Database Specialist II03/2006
to 01/2011 Daniel B. Stephens & Associates, Inc
Responsibilities includes but not limited to leading requirements discussions, planning, documentation, testing, review with users, preparing for deployment and training.
Manipulating, cleansing & processing data using Excel, Access and SQL Server.
Responsible for loading, extracting and validation of client data and Wrote T-SQL scripts to manipulate data for data loads and extracts.
Data entry, data auditing, creating data reports & monitoring all data for accuracy.
Created PL, SQL queries and scripts to update and create tables, extract data for uploading, reporting, analysis and data consistency checks.
Exported data to Excel and Access for reporting, summarizing, created bar graphs and charts in Excel, and integrating data from different systems into an Access DB.
Monitored and Tuned Applications, SQL statements and databases by using snapshot monitoring, event monitoring, and other monitoring utilities.
Worked closely on projects of moving from Access 1997 to SQL Server 2005, that involved developing and implementing a new Warehouse and Reporting system, Using SQL Server 2005, SSIS packages, SSRS, and Crystal reports.
Made customizations to the database Structure by creating database objects like tables, Triggers, Views including the audit tables.
Developed various Complex Reports in preformatted and unformatted papers using Reports 6i, and Access 97/2003/2007.
Used MS Visio and Rational Rose to represent system under development in a graphical form by defining use case diagrams, activity and workflow diagrams.
Built MS Access database with ODBC connection to the data warehouse.
to 03/2006 Target Corporation – NM
Involved in understanding the business processes and defining the requirements.
Development of Banking & Finance modules, Direct procurement modules E-Sales - Quotation Negotiations Receipt of PO Invoice E-Procurement - PR RFQ Negotiation PO Invoice.
Student Intern/Software Programmer12/2002
to 04/2004 Indian Oil Corporation Limited – Baroda,
Worked with PHP, Linux and My SQL Server to develop the Chemical Management Project.
Designed the application to meet the users' requirements document.
Designed document research area that allows user to customize search by selecting search criteria of interest.
Installed, tested and supported operating system software and hardware.