We provide IT Staff Augmentation Services!

Senior Database Developer Resume

Phoenix, AZ

EXPERIENCE SUMMARY:

  • 9+ years of work experience in the field of Data Warehousing, Master Data Management & Application Support.
  • Strong exposure to master data analysis, design, implementation and support of DW & BI applications
  • Experienced in all project phases using Waterfall and Agile Methodologies
  • Proven track record in databases like Oracle (11g/10g/9i/ 8.x), Teradata, SQL Server, PL/SQL programming, SQL loader, TOAD, Performance Tuning, Building Complex Queries, Indexes, Hints, Partitioning.
  • Written complex ETL Code (Extract, Transform and Load) leveraging Oracle PL/SQL Code blocks.
  • Expertise in SQL, PL/SQL, Table Partitions, Database links, Packages, Stored Procedures, Synonyms, Sequences, Functions, Triggers, Cursors, Ref Cursors and Views for processing data, enforcing referential integrity and in implementing business rules.
  • Experience on PL/SQL Object Types, Dynamic SQL, Collections and Materialized Views.
  • Involved building PL/SQL ETL (Extraction Transformation and Loading) routines in data warehousing applications.
  • Experienced in Performance Tuning SQL and PL/SQL code for better performance with large volume of data using SQLTRACE, EXPLAIN PLAN & TKPROF with the help of Hints, Partitioning, Bulking techniques and Indexes.
  • Extremely involved in Teradata Performance tuning activities with SQL scripts, Macros building for complex logics with BTEQ scripts, Teradata Data Mover and FLOAD, MLOAD Loader Utilities.
  • Experience in SQL*Loader, Import/Export Utilities and Migrating Data to Oracle database.
  • Good Knowledge with scripting languages like JAVASCRIPT, HTML and XML.
  • Written UNIX Script for automated batch monitoring and file transmission needs
  • As DRM Consultant, involved in creating hierarchies , properties, validation/verification, import & exports , implementing security & automation of processes.
  • Analyze various source systems to understand data, for cleansing and validation.
  • Proven ability to deliver highly comprehensive Master Data Management designs to consolidate data across a wide range of business entities.
  • Extensive experience in tableau reporting
  • Experience in creating different Tableau visualizations like Bars charts, Lines charts and Pie charts, Maps, Scatter plots, Gantt charts, Bubble charts, Histograms, Bullet charts, Heat maps and Highlight tables, Waterfall charts, Donut charts, Bar in Bar charts etc.
  • Data blending, data preparation using SQL for Tableau consumption, publishing data sources to Tableau server
  • Responsible for documentation, and end - user training
  • Proven expertise of dealing with people across diverse teams comprising of various skill sets.
  • Design ETL process involving data quality, testing and information delivery and access to the data warehouse.
  • Worked in various levels of SDLC (System Development Life Cycle) which involves Analysis, Design, Development, Testing, Implementation and Support with extensive exposure in Database, RDMS and Documentation of business applications using Oracle technologies.
  • Analyzing & gathering table statistics for Query Optimization.
  • Easily adaptable to the new concepts and applications.
  • Excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels. Able to interact effectively with other members of the Business Engineering, Quality Assurance and other teams involved.

TECHNICAL SKILLS:

BI/Analytics: Tableau

Programming Languag: SQL, T- SQL, PL/ SQL, UNIX, shell scripting

Databases: Oracle, SQL Server, Oracle Hyperion DRM, Teradata

Utilities: Toad, SQL Developer

ERP: SAP

WORK EXPERIENCE:

Confidential, Phoenix, AZ

Senior Database developer

Responsibilities:

  • Coordinate and manage database activities to support application development projects
  • Working with business users and understand the data gaps in Claims processing
  • Automate claims submission process for Medicaid
  • Ensure all the claims are processed for cheque run days
  • Automating the data quality reports
  • Provide high level support to customers on a daily basis
  • Respond to database related queries and issues in timely fashion
  • Batch monitoring the inbound and outbound files using sentinel
  • Worked on the performance tuning for existing Pl/sql procedure, functions and other objects for quick processing of business data updates. ‘
  • Assist in database enhancements and modifications as per customer requests
  • Leveraged autosys for job scheduling
  • Prepare database project status reports to project manager

Confidential, Saint Louis, MO

Database Developer/Data Analyst

Responsibilities:

  • Work with business users to understand the problem statement and convert the same into a requirement documents that can be understood by different stake holders
  • Design and Develop Teradata and Oracle PL/SQL stored procedures and Materialized views
  • Created queries to pull data combining several source tables and provide the required details to business team
  • Data Analysis and data mapping between various source and target systems
  • Responsible for gathering and understanding different business and functional requirements with correlation to user perspective.
  • Conducted peer design and code reviews and extensive documentation of standards, best practices.
  • Leveraged autosys for batch scheduling of jobs
  • Extensive experience in Reports development using spotfire
  • Code review; deployment; performance improvement by rewriting existing views/Stored procedures.
  • OnSite and Offshore co-ordination.

Confidential, Fairfield, CT

Oracle Hyperion DRM Consultant/Data Analyst

Responsibilities:

  • Analyze the functional specifications provided by the business analysts and create technical specifications documents.
  • Worked on versions, hierarchies, exports, properties, validations and actions scripts
  • Created exports and automating the process of export generation and transferring it to target systems.
  • Worked on Implementing business rules
  • DRM integration with external inbound and outbound systems.
  • Data profiling to understand current state of data quality.
  • Designing solution and maintenance of central repository for all the Master data
  • Design and developed interface views to load data to planning/Essbase/HFM apps via EPM
  • Created and optimized source-to-target mappings.
  • Design and develop Oracle PL/SQL stored Procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules.
  • Driving Data Governance & Quality requirements leveraging skills Oracle SQL and PL/SQL Skill set
  • Leveraged automic(uc4) for automating jobs to move data from Enterprise standard DRM to business DRM
  • Implement best practices to maintain optimal performance.

Confidential, Lakeville, MA

PL/SQL Developer

Responsibilities:

  • Work with Business Analysts to understand the business requirements, perform detailed analysis, and provide optimum feasible design solutions.
  • Design and Develop Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts, triggers, cursors, SQL scripts to facilitate the functionality for various modules.
  • Responsible for requirements gathering from Clients and implement the back-end changes in existing project and in designing the database.
  • Analyze the functional specifications provided by the business analysts and create technical specifications documents.
  • Testing and reviewing the newly developed, enhanced, rectified and modified programs and reports for various quality standards and moving them to production.
  • Developed Views, Materialized Views and functions as per the business requirement
  • Prepared SQL Queries to validate the data in both source and target databases.
  • Implement best practices to maintain optimal performance.
  • Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability
  • Re-engineer some of the current processes to streamline the data acquisition and integration process
  • Involved in Performance tuning of the complex SQL queries.
  • Developed complex SQL Queries using various joins and developed various Dynamic SQL’s throughout the project.
  • Analyzed and computed statistics to improve response time for queries.
  • Developed Cron jobs & schedulers using UNIX Shell Scripts.
  • Conducted peer design and code reviews and extensive documentation of standards, best practices.
  • Reconciled requirement to Oracle business views and performed gap analysis on reporting needs.
  • Prepared the High-Level Test script document as a part of the manual testing.
  • Test Case/data Preparation, execution and verification of the test results.
  • Involved in Release Management, Configuration Management and Production Fixes

Environment: - Oracle 11g, Sql Navigator, Windows 2012.

Confidential, Battle Creek, MI

Sr. Oracle PL/SQL Developer

Responsibilities:

  • Involved in planning, control and implementation of the DBMS using SDLC.
  • Worked with systems and business analysts to design requirement specifications.
  • Developed capacity plan for the database, estimated the table sizes.
  • Creation of database objects like Tables, Indexes and Views.
  • Implemented data integrity validation checks through constraints and triggers.
  • Responsible for creation of new user ids and setting up privileges and policies for Protection of data
  • Developed packages for implementing business logic through procedures and functions.
  • Developed UNIX shell scripts to automate routine tasks.
  • Responsible for the dealing with the problems, DB bug fixing and troubleshooting
  • Worked on Erwin Data Modeler for mapping both user-defined and default data types.
  • Performance monitoring and tuning of SQL code.
  • Implemented Data Warehousing-Star Schema Design.
  • Responsible for SQL tuning using explain plans and SQL trace facilities.
  • Involved in Performance Tuning using ADDM (Automatic DB Diagnostic Monitor) which makes the diagnostic data readily available.
  • Use various SQL Profiler templates for tracking execution time.

Environment: Oracle 9i/10g, PL/SQL, SQL, UNIX, Korn Shell Scripting, TOAD 9.5, UML, SQL Server

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • I am responsible for the analysis of the requirement as specified/provided by the clients and create technical specification documents
  • Analyze all the change requests requested by Business, understand the priority from clients and plan resource allocations accordingly. Submit the documents with the possible changes for next release.
  • Represent the Changes in CAB meetings (Change Approval Board) and explain changes and how it impact business, possible back out plans (Change failure)
  • Design and Develop stored procedures, Functions, Packages, SQL scripts, triggers as per requirement
  • Create DB-Links to interact with other (source or different environments) Oracle Databases.
  • Written Java Programs (JDBC connections) to extract data from other databases (non-Oracle)
  • Written standard logging template that can be used across application with Oracle, for error handling or maintaining scheduling logs for the Oracle Schedulers.
  • Peer review the code to make sure they are intact with the existing code standards.
  • Created Partitioned tables for easy maintenance.
  • Created several Materialized View to make sure they report execution is completed with SLA
  • Testing and reviewing the newly developed and enhanced Modules/reports for various quality standards and moving them to production.
  • Involved in Incident Management, Problem Management and Change Management

Environment: Oracle ,BO XI R2 (Designer, WebI, InfoView, Import Wizard), Java (JDBC), SOLARIS, TOAD

Confidential

Oracle PL/SQL Developer Hyderabad,India

Technology: Oracle , Java, JSP, AIX, TOAD

Responsibilities:

  • Involved in Project life cycle, from analysis to production implementation, with emphasis on testing plans, execution, analysis, and results.
  • Worked with business analysts, Global Plus and Extreme (third party application which print these statements) team to understand the business requirements and file formats
  • Participated in Data Model discussions to accommodate the extracts from Global Plus and business Flows.
  • Preparing the High level and Detailed design documents
  • Written loader procedures in PL/SQL to extract the data from source and load it to the designated tables
  • User interface setup for maintain the recipients
  • Testing of the process manual and Automated via control M.
  • Deploying the code to production using SERENA
  • Developed several Shell scripts to access incoming files.

Hire Now