We provide IT Staff Augmentation Services!

Database Developer Resume

Austin, TX

SUMMARY:

  • 7 years of IT experience in Analysis, Design, Development, Support, Administration, and Performance tuning of applications using Oracle, SQL Server, DB2, SQL, PL/SQL, T - SQL, Oracle APEX, Oracle forms and reports.
  • Experience on Data visualization, Database and application development for Government agencies (Oil and gas, Child support), banking, Insurance, and Finance Domain organizations.
  • Experience in data extraction, transformations, conversion and interface, data loading, database modeling and performance tuning.
  • Experience in using Informatica/SSIS/ODI for developing the Data warehouse loads with work experience focused in Data Integration as per client requirement.
  • Experience in developing interface programs to import data from legacy systems and excellent skills in writing PL/SQL Stored Procedures, Functions and Packages using Oracle 12c/11g/10g and IBM DB2 10.5.
  • Design and generation of different Database Objects like Tables, Views, Synonyms, Sequences, Identity columns, and PL/SQL packages, triggers, cursors, and exception handling.
  • Experience in creating Tableau scorecards, Tableau dashboards using Tableau functions like calculated fields, LOD (Level of Detail), Adhoc Calculations, etc.
  • Experience with T-SQL (MS SQL Server 2012/2014) in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, and User Profiles.
  • Experience in Performance Tuning using SQL Trace, Explain Plan, and TkProf facilities & Optimization of SQL statements using various types of Hints, Partitioning and indexes.
  • Experience in using versions of Oracle Application express (APEX) 4.2, and 5.1.
  • Proficient in use of Oracle applications development tools within a client/server environment.
  • Experienced with Backlog Grooming, Sprint planning, Story sizing, Story Prioritizing, Standup meeting, User Story Demos and Retro meetings working on Agile Project implementation.
  • Working knowledge in Database Backups RMAN , and in traditional hot/cold backups.
  • Experience in using Automated Tool like JIRA, GIT code repository, and STASH.

PROFESSIONAL EXPERIENCE:

Confidential - Austin, TX

Database Developer

Responsibilities:

  • Worked with DBA in making enhancements to physical DB schema and coordinated with DBA in creating and managing Tables, indexes, table spaces, synonyms, DB links and privileges.
  • Handled PL/SQL compile-time, run-time errors, debugging of Stored Procedures for business logic modification, and responding to system events through trigger.
  • Created B Tree indexes, Function based indexes, Bit Mapped Indexes on Tables, columns to minimize query time and achieve better performance.
  • Used suitable ODI Knowledge modules to achieve requirements. Extracted data from specific technology, transforming the data, checking it, integrating it, etc. Created Custom Knowledge Modules.
  • Involved in fine tuning the existing packages for better performance and providing on-going support to existing applications and troubleshooting serious errors when occurred.
  • Developed several stored procedures and functions using advanced Oracle concepts such as Bulk Binds, Bulk Collects Ref Cursors to improve performance.
  • Created PL/SQL Stored Procedures, Functions, Packages, and Triggers extensively used Cursors, REF cursors, User-defined object types, Records, forms and reports in PL/SQL programming
  • Developed Oracle Forms & Reports using Forms12c and Reports12c Including Forms based on stored procedures.
  • Analyzed and fixed the data discrepancies between various systems and identified bad data caused due to the data migration from various legacy systems.
  • Created and modified ODI RKM, LKM, JKM, IKM, CKM, and SKM Knowledge Modules.
  • Involved in creating ODI packages, scenarios using interfaces, variables, procedures.
  • Used performance-tuning methods to increase the performance of the oracle database.
  • Created and modified several UNIX Shell Scripts according to the changing needs of the project requirements.

Environment: Oracle 12c, SQL, PL/SQL, Toad for Oracle, Oracle forms and reports 12c, ODI 12c, Jira, GIT, Stash/Bitbucket, Shell Scripting, Windows 2007.

Confidential - Austin, TX

Relational Database/ETL Developer

Responsibilities:

  • Trained & follwing rules and regulations of Sensitive Personal Information (protected health information, SSN Numbers, Date of birth, Government-issued ID numbers, Criminal history record information, Biometric data(e.g., fingerprints), OAG computer passwords, Credit/debit card numbers, and Tax information), PHI, and HIPAA.
  • Met with Business Stakeholders and Analyst to gether business requirements, development, and testing the DB2 database application.
  • Worked closely with Customer service and CI & CL department for efficient delivery of Tableau Reports.
  • Worked with T-SQL to create tables, stored procedures and user defined functions for complex business logic.
  • Used Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
  • Writing SQL & custom SQL/PL code to achieve ETL process of extracting the data from multiple sources, transforming the data based on definitions, and loading the data into target databases.
  • Creating Business metric reports to check the health of the conversion project and presenting metrics to Child support business stakeholders.
  • Wrote Stored Procedures, Functions, stored procedures and SQL Scripts using SQL/PL.
  • Created and maintained databases, tables, views, users, logins, indexes, check constraints, and business rules using T-SQL.
  • Developed restricted user access to Tableau reports according to the users requirements at worksheet level.
  • Creating Indexes, constraints, partitions on database objects (tables, views), and considering the performance of database due to the billions volume of data.
  • Reviewed and modified SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
  • Created tables with identity columns, views, sequences, triggers on tables and views, indexes, primary, unique, and foreign key constraints.
  • Implemented MS SQL Server Management studio (SSMS) to create Complex Stored Procedures using T-SQL to evaluate result for the reports.
  • Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
  • Writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and Functions to implement the business logic and created Clustered and non-Clustered indexes.
  • Executing SQL queries to extract data from DB2 tables for running test scripts.
  • Using IBM DB2 database system to maintain, implement, and improve code/scripts.
  • Used Informatica Developer tool to provide data quality and Metadata management solutions.

Environment: IBM DB2 v10.5 (Kepler), SQL, SQL/PL, T-SQL, LOAD Utility, SQL Server 2014, Teradata, SSMS, Tableau Desktop 9.x, Tableau Server, IBM Relational ClearCase, Clear Quest, Flat files, Informatica Power Center 9.6, Windows 2007.

Confidential - San Francisco, CA

ETL/Database Developer

Responsibilities:

  • Wrote Procedures, Functions, PL/SQL Packages and SQL Scripts using PL/SQL.
  • Formulated SQL queries, functions and processes as per customization requirement for APEX.
  • Developed and maintened modules for an enterprise wide wealth/asset management application written in PL/SQL operating on an Oracle database.
  • Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
  • Designed and developed ETL mappings and workflows using Informatica Power Center
  • Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
  • Worked with developers to repair and enhance current base of PL/SQL packages to fix testing issues.
  • Implemented various Oracle APEX page level and item level validations to perform validations against database.
  • Created Interactive grids with new functionality in Oracle APEX 5.1.
  • Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create mappings in the Informatica Power Center Designer.
  • Created link columns on the interactive reports/grids to redirect users to a different page in the application.
  • Created policies to secure the data from unwanted users.
  • Created static, shared components, and PL/SQL function body returning SQL query types of LOV’s and implemented on to page items and columns.
  • Used excel sheet, flat files, CSV files to generate Tableau Adhoc reports.
  • Generated dashboards in Tableau Server using different data sources including Excel, Oracle and Microsoft SQL Server.
  • Created Master detail form with master as tabular form and detail form as Interactive grid in APEX 5.1.
  • Validated the functions and procedures inside the package using the various fields in Oracle APEX.
  • Created PL/SQL triggers, sequences, and stored procedures using Toad.
  • Published Tableau dashboards on to server, administered user groups and provided production support for tableau users.
  • Deployed reusable transformation objects like sessions and tasks to avoid duplication of metadata, reducing the development time.
  • Developed data model, PL/SQL Queries, SQL Query tuning process, and Schemas.

Environment: Oracle 12c/11g, SQL, PL/SQL, Toad 12, SQL Server 2014, SQL Developer, SQL *Loader, Tableau Desktop 8.x, Tableau Server, Oracle APEX 4.2, Informatica 9.5, Windows, MS- Excel 2013.

Confidential - San Francisco, CA

Lead Data Conversion Developer

Responsibilities:

  • Worked on a data conversion project as a lead PL/SQL developer on critical Balance & Discrepancy (B&D) reports.
  • Involved in implementing business logic with Oracle-stored procedures, functions and triggers using PL/SQL.
  • Created and maintained tables, procedures, functions, and packages, and update, delete, and insert statements and compile them.
  • Written Custom SQL scripts, Stored Procedures, Functions, Triggers, Views, Cursors, Packages and Exceptions
  • Created Business & Development reports for the Business manage to validate the data as well as the project.
  • Tracked defects using JIRA and generated defect summary reports.
  • Created SSIS package to load data from Flat Files, Excel, OLE DB Source to SQL Server 2012 by using Derived Columns, Condition Split, Data Conversion, Ole DB Command, Aggregate, Pivot Transformation, Execute SQL Task and Script Component Task.
  • Extensively worked in Oracle SQL, PL/SQL, SQL*Plus, SQL*Loader, Query performance tuning, Created DDL scripts, Created database objects like Tables, Views Indexes, Synonyms and Sequences.
  • Involved in Importing and exporting the Tables, Users, and Schemas.
  • Responsible for Unit Testing and Integration testing of PL/SQL Packages, Procedures, Functions and Database Triggers.
  • Developed SQL Server Stored Procedures, Tuned SQL Queries( using Indexes and Execution Plan)
  • Used Agile Scrum methodologies, performed standup sessions and used Excel extensively to write user stories, analyzed the Iteration Burn Down charts and reviewed defects.
  • Implemented MS SQL Server Management studio (SSMS) to create Complex Stored Procedures using T-SQL to evaluate result for the reports.
  • Involved in developing the SSIS packages to export data from SQL Server database to flat file source.
  • Responsible for logging defects in Defect Manager, monitoring their status and tracking them to closure using JIRA.
  • Exported/Imported data from other data sources like flat files using Import/Export through SSIS.
  • Worked extensively through Agile development methodology by dividing the application into iterations
  • Experience with custom development of data warehouse, operational data store, and OLTP systems.

Environment: Oracle 11g, MS SQL Server 2012, SQL, PL/SQL, T-SQL, SQL Developer, SQL *Loader, SSMS, SSIS, JIRA, Scrum, Insurance systems, Windows 2007.

Confidential -- Atlanta, GA

Database Developer

Responsibilities:

  • Involved in analysis, Design, Development and unit testing phases of the project.
  • Involved in walk-through sessions with business users during the Analysis and Designing phase, writing PL/SQL Stored Procedures, Functions, Packages to meet the business requirements.
  • Create and maintain tables, materialized views (Summary Tables), procedures, functions, and packages, and update, delete, and insert statements and compile them.
  • Data Load from flat files into Oracle tables using SQL*Loader, and PL/SQL procedures.
  • Coded PL/SQL sub-programs and modified the existing PL/SQL program units.
  • Constant monitoring and performance tuning of the Oracle database, checking the most expensive queries.
  • Incomplete and full database recovery with experience of complex recovery scenarios.
  • Developed several back-end Packages, Procedures, Functions and Triggers to use in multiple Forms and series of other backend programs using PL/SQL.
  • Performed a review and analysis of database deadlocks and database performance tuning.
  • Documented the whole process flow, PL/SQL packages, log files, locations and descriptions, log tables and possible error messages, process codes and descriptions.
  • Involved in designing and implementing capacity planning, backup/recovery, tuning, and monitoring strategies.
  • Worked closely with the Application Development teams to identify and implement continuous improvements and effective problem resolution strategies.

Environment: Oracle 11g, PL/SQL, SQL *Loader, TOAD, SQL Developer, MS-Access, Windows.

Confidential

Software Programmer

Responsibilities:

  • Create and maintain tables, procedures, functions, and packages, and update, delete, and insert statements and compile them.
  • Work with architects, designers, developers to translate data requirements into the physical schema definitions.
  • Data Load from flat files into Oracle tables using SQL*Loader, and PL/SQL procedures.
  • Coded PL/SQL sub-programs and modified the existing PL/SQL program units.
  • Constant monitoring and performance tuning of the Oracle database, checking the most expensive queries.
  • Incomplete and full database recovery with experience of complex recovery scenarios.
  • Developed several back-end Packages, Procedures, Functions and Triggers to use in multiple Forms and series of other backend programs using PL/SQL.
  • Detected and corrected bugs during system integration and user acceptance testing.
  • Documented the whole process flow, PL/SQL packages, log files, locations and descriptions, log tables and possible error messages, process codes and descriptions.
  • Involved in designing and implementing capacity planning, backup/recovery, tuning, and monitoring strategies.
  • Worked closely with the Application Development teams to identify and implement continuous improvements and effective problem resolution strategies.

Environment: Oracle 10g, SQL*Loader, PL/SQL, SQL*Plus, TOAD, SQL Developer, CVS, Windows 2000 Server.

Hire Now