Database Support/qa Engineer Resume
Atlanta, GA
SUMMARY:
- Ten years of extensive professional IT programming experience as an Oracle PL/SQL Developer, Data Analysis, Design, Coding, Reporting, Database modeling, ETL Data Modeling, Development, Maintenance, Testing and Documentation and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS) and Technical Management.
- The creation and maintenance of scripts (SQLPlus/KSH) used in database change management, MySQL to Oracle migrations, and initial schema setup.
- Expert in creating Business reports, parameterized reports and in designing report layout using oracle reports.
- Excellent technical and analytical skills with clear understanding the SDLC process, closely worked with database architect .Creation and maintenance of database schema diagrams
- Involved in various projects related toData Modeling, System/Data Analysis, Design and Development.
- Experience on installing oracle, creating database, creating directory, users, roles, grants, table spaces, partitioning in oracle.
- Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
- Experience in transforming complex business requirements from customer into database objects like Stored Procedures, Functions, Packages and Triggers to support Agile development.
- Experience in managing Oracle supplied packages, DBMS SQL (Dynamic SQL), Records and PL/SQL Tables, DBMS JOB and UTL FILE.
- Worked extensively on Ref Cursor, External Tables and Collections
- Experience in using SQL loader, script, toad, oracle export import utilizes.
- Gather, analyze, summarize database information and prepare recommendations towards SOX initiative within organization.
- Experience in troubleshooting database issues, finding data inconsistency issues.
- Experience in performance tuning, for Oracle RDBMS using Explain Plan and HINTS.
- Strong performance tuning knowledge in SQL by using explain plan, row source operations to identify bottlenecks in queries and remediate them.
- Oracle database scripting and executing KSH scripts on the Linux.
- Ability to lead a team when required, while still performing database development duties.
- Ability to work independently and drive tasks to completion.
- Experience in Interfacing with customers to capture requirements and transform them into system design and implementation.
TECHNICAL SKILLS:
Databases: Oracle 8i, 9i, 10g, 11g
Programming Languages: SQL, PL/SQL, Shell Script, C++,Java, HTML
Operating Systems: Windows, Unix, Linux, MAC OS
Application Software: MS Office (Word, Excel, PowerPoint),Access,D2K,Oracle Forms 9i,Oracle Reports, Visual basic, Visual Sourcesafe
Database Development Tools: Toad, SQL*Loader, SQL*Plus, SQL Developer, Putty,Enterprise Manager, Query Analyzer, SQL Profiler, PL/SQL developer, explain plan, awr repository
Scripting Languages: KSH scripts
Reporting Tools: Crystal reports, Oracle reports
Data Modeling Tools: Erwin and Oracle Designer
PROFESSIONAL EXPERIENCE:
Confidential, Atlanta, GA
Database Support/QA Engineer
Responsibilities:
- Provided database support for Change management and release management.
- Understand the customer BRD (business requirement document) and translating it to appropriate database configuration specific to Products
- Provided support for QA environment
- Pre - production support - env preparation
- Resolve Production defects
- Maintenance and development of business flows,scripts, code
- Work with Dev teams for Development Code and design review for supporting agile development.
- Interface with customer to capture business requirements.
- Maintenance of development environment. Syncing with production.Creating/Configuration scripts for dynamic control scripts to keep environment in sync.
- Installing oracle, creating database.
- Managing privileges for users for implementing SOX compliance (role based access)
- Implementing database column level/table space level encryption for SPI fields in database tables as part of SOX compliance for data security.
- Performance Tuning of queries and database issues.
Confidential
SQL Developer
Responsibilities:
- Customizing scripts to in corporate changes related to business logic based on clients requirements.
- Creating client specific metadata definitions for core product configuration in Cedar Rapid Letter, Rapid Content, Sunrise and Frontier applications, Deciding client specific features that are required to be promoted to Cedar Frontier application.
- Developing Template/Revision of templates related to Cedar Rapid Letters interface in order to personalize and send ad hoc documents as requested by customer.
- Developing database configuration scripts for dynamic control the content in specified regions of print, electronic and portal-based communications in Cedar products.
- Developed aConceptual modelusing Erwin based on requirements analysis
- Developed PL/SQL packages using collections varrays, objects, Stored Procedures, User Defined Functions and Database Triggers, bulk operations, data loading, error handling and logging.
- Created database objects including tables, clusters, Indexes, views, sequences, packages triggers and procedures to troubleshoot any database problems.
- Unix/Linux operating systems experience
- Maintenance of development environment, directory, users, roles, grants, table spaces, partitioning in oracle.
- Involved in handling the changes in compiling scripts according to the database changes
- Automated data fetch using UNIX shell script.
- Work with the database modeling manager to identify the requisites of a project
Environment: Oracle, Pl/SQL, SQL, Toad,UNIX shell script,Oracle Designer
Confidential
PL/SQL Developer
Responsibilities:
- Logic implementation to convert existing product to handle international clients.
- Creating client specific metadata definitions for core product configuration in Cedar applications
- Deciding client specific features that are required to be promoted to Cedar Frontier application Product Enhancements
- Involved in PL/SQL code review and modification for the development of new requirements.
- Created materialized views required for the application.
- Designed/developed/Modified tables, views, materialized view, stored procedures, packages and functions.
- Worked with bulk data, handling millions of rows.
- Coded PL-SQL packages and procedures to perform data loading, error handling and logging. Tied the procedures into an existing ETL process.
- I worked on CEDAR EIPP solution for integrating multiple layers of billing hierarchy, allowing users to pay at both the aggregate level and the statement level.
Environment: Oracle, Pl/SQL, Linux, SQL, Toad, HTML, XML.
Confidential
SQL Developer
Responsibilities:
- Implementation and working end to end understand the customer BRD (business requirement document) and translating it to appropriate database configuration specific to Cedar applications.
- Creating client specific metadata definitions for core product configuration in Cedar applications.
- Developed database comparison Provisioning tool for Cedar Frontier application.
- Identify opportunities to design and Develop Utilities and Tools to promote efficiency in product
- Deployment and improve productivity in day to day working for developers
- Coded PL-SQL packages and procedures to perform data loading, error handling and logging. Tied the procedures into an existing ETL process.
- Developed PL/SQL packages and functions for various customizations using oracle objects such as varrays, objects, Stored Procedures, User Defined Functions and Database Triggers, bulk operations, parameterized cursors
- Installing oracle, creating database, directory, users, roles, grants, tablespaces, partitioning in oracle.
- Utilized SQL*Loader to load flat files into database tables.
- Created data mapping files for the data coming from different web services.
- Involved in handling the changes in compiling scripts according to the database changes.
Environment: Oracle 11g, Pl/SQL, Linux, SQL Developer,XML,SQL* LOADER.
Confidential
QA Engineer
Responsibilities:
- Understand the customer BRD (business requirement document) and translating it to appropriate
- Database configuration specific to Cedar applications.
- Involved in handling the changes in compiling scripts according to the database changes
- Implementing specific metadata customizing for core product configuration, working with QA/Dev to check the customization.
- Developed complex reports as per client request as a part of production support
- Performed SQL tuning using Explain Plan, Hints and indexes
- Responsible for performing code reviews.
- Worked on XML tags and creating scripts to implement xml tag files in production environment.
- Created SQL*Loader scripts to load data into temporary staging tables
- Used pipelined functions for faster data accessibility.
- Used advanced Bulk techniques to improve performance.
- Performed functional testing for the procedures and packages.
- Created and manipulated stored procedures, functions, packages and triggers using TOAD.
- Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.
Environment: Oracle 11g, Pl/SQL, Linux, SQL Developer,XML,SQL* LOADER.
Confidential
Data Modeler/Data Analyst
Responsibilities:
- Participating as a database team member and release control process for Cedar Frontier and Cedar Sunrise, Rapid Letter and Rapid Content Product application.
- Involved during User Acceptance Testing of the application.
- Data Modeler / Data Analyst
- Involved during User Acceptance Testing of the application.
- Involved in handling the changes in compiling scripts according to the database changes
- Worked closely with quality assurance and development teams to clarify and understand the functionality to resolve issues and provide feedback in terms of the test matrices and to nail down the bugs.
- Developed reports using complex queries as per client request as a part of production support
- Assisting in day-to-day System Administration activities like CRON scheduling jobs
Environment: Oracle 11g, Pl/SQL, Linux, SQL Developer,XML,SQL* LOADER., TOAD
Confidential
Senior Oracle PL/SQL Developer
Responsibilities:
- Maintaining all the information of CA career profile from student registration to Registration as member, working in a firm or industry.
- Collecting information related to students registered from primary level and promoted to next level, re-registration, online registration, online fee collection, online exam, online study, hosting of results online.
- Keeping track of Members registered, fee collection, relationship with firm or industry, validating if a member is authorized for trainees, practice and auditing etc
- Information related to Firms registered as partner, proprietor, capturing complex Mergers and demergers of firms
- Involved in identifying and implementing logical design from business perspective of complex set of relations for “Firm module” which represented information capture of partners, firms, interns under the firms, firms merger-demerger, networking of firms, branches of firms
- Worked as part of team in defining functions, procedure, GUI for data capture and access
- Defining database constraints, relationships, table structure level design and integration of above module
- Involved in Writing PL/SQL Stored Procedures, Functions and Database Triggers.
- Designed business logic using advance PL/SQL features such as collections, analytical function and objects, used cursors in PL/SQL stored procedures to process the matching the Agreements.
- Troubleshooting issues related to data, change of requirements, correction of logic, sanitizing data
- Experience in using grouping, summaries, select expert features for the reports based on the end user requirement in oracle reports.
- Developed PL/SQL Packages for loading the image Files to store for different Database Systems.
- Experience in working with application forms 9i.
- Developed PL/SQL code for Exporting the reports to different format like excel, pdf, csv, text files.
- Experience in modifying existing reports and creating Report Templates.
- Worked on a process for extraction of data from various subsystem and transformation of data in order minimize the reports generation time using PL/SQL functions and procedures
- Help tune the reports using PL/SQL arrays and bulk processing
Environment: Oracle 9i, Pl/SQL, PL/SQL Developer, XML, SQL* LOADER.
Confidential
PL/SQL Developer
Responsibilities:
- Capturing online application forms information, various levels of approvals involved.
- Analysis of the firms for appointment of auditors of Government Companies/Deemed Government Companies.
- Calculating the business/financial position of the applicant firms and analysis aims at
- Identifying and analyzing all relevant costs and benefits.
- The remuneration payable to the Auditors fixed by the Company.
- Ranking the applied firms based on business, revenue generation, employees, goodwill etc last year’s business
- Involved in the Database Design gathering sessions for developing the Application.
- Involved in the Data modeling, Physical and Logical Design of Database
- Involved in designing of the system that included an extensive interaction with the end user.
- Developed PL/SQL Stored Procedures, User Defined Functions and Database Triggers, varrays, objects.
- Optimized the performance of queries by creating index where ever applicable
- Implemented parameterized cursors and function overloading in the PL/SQL Stored Procedures and packages
- Involved in the testing process like Unit, Database and Performance testing the existing systems and creating reports in SSRS.
- Created process to automate mail generation and printing letters reports from bulk operations
Environment: Oracle 9i, Access, Oracle Reports, VB, SQL, PL/SQL.
Confidential
SQL, PL/SQL Developer
Responsibilities:
- Write and review good quality SQL, PL/SQL in order to change/fix data in a Production environments.Create Daily SQL scripts to address production data problems.
- Developed the databases for the individual departments, and the central database, which contains information about all the departments.
- Created Database Objects like Tables, PL/SQL Stored Procedures, Views, Joins, Triggers, objects and PL/SQL Functions.
- Actively involved in writing Forms 9i Programming for implementing Dynamic queries and Functions for different tasks.
- Support SQL Reports from Production data.
- Developed different types of Tabular Reports, Matrix Reports, Chart and Graphs, Reports that aggregate data, Reports containing parameters and group, Reports containing Totals and Subtotals.
- Worked with team to import/export and transform the data between the linked servers.
- Validate data during transferring, and archived data files for different DBMS.
Environment: Oracle 9i, Oracle Forms 6i, 9i, Oracle Reports, VB, ASP, UNIX Shell Scripts, SQL, PL/SQL.
Confidential
SQL, PL/SQL Developer
Responsibilities:
- Legal disputes library was a module which captured the information of all the legal cases, hearing details, decisions, legal proceeding, and details of lawyers/law houses involved.
- Complete case study, comments, contacts, people involved.
- Maintaining vouchers, billing payment details
- Normalized the database into small tables by applying rules of Normalization, defined Check Constraint and applied Business Rules.
- Implemented partitioning on large tables and optimized the SQL statements to take advantage of partition approach.
- Designed Functional Specification and prototype to get end user approvals for system implementation.
- Experience in using grouping, summaries, select expert features for the reports based on the end user requirement in oracle reports.
- Experience in Unit testing of PLSQL functions and procedure and Reports.
- Interface with management for generating various reports
- Troubleshoot, Fixed, and implemented bug fixes and enhancements in PL/SQL code
Environment: Oracle 9i, Oracle Forms, Oracle Reports, VB, ASP, UNIX Shell Scripts, SQL, PL/SQL.