We provide IT Staff Augmentation Services!

Sr Sql Server Developer / Pl/sql Developer Resume

SUMMARY

  • 10 years of experience in IT industry with emphasis on Analysis, Design, Development, Implementation of projects using Oracle (SQL, TSQL, PL/SQL)
  • Solid experience in translating business requirements into creation of Database Objects
  • Strong Exposure in writing Simple and Complex SQLs, PL/SQL Functions and Procedures, Packages and creation of Oracle Objects - Tables, Materialized views, Triggers, Cursors, Synonyms, User Defined Data Types, Nested Tables, Collections and developing Reports and Forms
  • Interacted with the business users, collected and analyzed the requirements, designed and recommend solutions
  • Strong knowledge in development of components related to SSRS, Oracle Reports
  • Strong knowledge in developing PL/SQL packages for concurrent process programs and Actuate Reports
  • Good knowledge in developing custom screens in OAF pages for users with user friendly actions
  • Extensive experience in working on Payroll, Time and Labor, Payroll, Core HR modules in HRMS
  • Experience with different phases of SDLC and worked in agile environment
  • Possess strong organizational skills and ability to timely complete necessary documentation and reports

TECHNICAL SKILLS

Languages: C, SQL, JavaScript, XML, UNIX shell scripts

Development Tools: SSMS, SSIS, Toad, SQL* Plus, Forms Builder, JDeveloper, SQL*Loader

Reporting Tools: SSRS, Oracle Reports 6i/10g,XML/ BI Publisher Reports

ERP: Oracle Applications Release 12(12.1.3), Release 11i(11.5.10.2)

Databases: SQL Server, Oracle 11g

PROFESSIONAL EXPERIENCE

Confidential

Sr SQL Server Developer / PL/SQL Developer

Responsibilities:

  • Designed Tables, Constraints, Views, and Indexes etc. in coordination with the application development team
  • Migrated DTS packages to SSIS and loaded data from flat files and external databases obtained from various facilities every day.
  • Tune and improved SQL Query performance using SQL Profiler
  • Used TFS to store SQL stored proc, queries and SQL Compare before check-in to TFS
  • Created Linked Servers, maintained Autosys jobs to import data from internal databases
  • Setup 24*7 alerts for high data availability
  • Participate in prod issue triaging, bug fixing and release. Involved in Sprint planning, story sizing.
  • Lead in architecting and modeling complex models and data integrations

Environment: SQL Server 2016, SSRS, SSIS, Azure, T-SQL, Window Server 2016, Site 24*7, HiNet

Confidential

SQL Server Developer / PL/SQL Developer

Responsibilities:

  • Created tables, stored proc, indexes and triggers following Nordstrom standards and conventions
  • Cleaned and imported data from internal database using SSIS packages
  • Developed and maintained Nordstrom Warehouse Management supply chain system to proactively monitor service levels, inventory optimization.
  • Created monthly and quarterly reports using SSRS
  • Created partitioned tables and partitioned indexes to improve the performance of the application.
  • Handled client interaction in requirement gathering and process automation for major components like Store level, department level amount paid for the employees, SIT requirements for Quarterly and Annual Pacesetters
  • Created database backups and setup alerts
  • Involved in code review and modification for the development of new requirements

Environment: SQL Server 2016, SSRS, SSIS, T-SQL, Windows Server 2012

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Designed Tables, Constraints, Views, and Indexes etc. in coordination with the application development team
  • Developed healthcare supply chain applications to efficiently serve providers, hospitals and patients.
  • Supported supply chain modules within Oracle applications and streamlined supply chain workflows.
  • Involved in PL/SQL code review and modification for the development of new requirements
  • Created partitioned tables and partitioned indexes to improve the performance of the applications
  • Created new Procedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functions as part of Project/Application requirements
  • Developed components related to Oracle Reports, XML Publisher, Outbound/Inbound Interfaces, PL/SQL, System Extracts
  • Load data from flat files into Oracle tables using SQL Loader and stored proc
  • Used Liquibase builds to execute PL/SQL scripts on databases
  • Created ETL packages to load patient info from external sources.
  • Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
  • Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
  • Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
  • Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
  • Improved the performance of the application by rewriting the SQL queries.
  • Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.
  • Used AWS data migration services to move inhouse Oracle database to RDS
  • Provided user training and production support.

Environment: Oracle 11g, PL/SQL, Liquibase, Reports, AWS, UNIX Shell Scripting

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Development of System Extract Reports, Integrators for Core HR, Payroll Modules in Oracle E-Business Suite.
  • Worked on various backend procedures and Functions using PL/SQL
  • Worked on Report layout design, Data models which used Placeholder, Summary, Formula Columns preparation of user manual and development of the program using Forms 10g
  • Performed on various Oracle databases Architect presentation layers like Oracle forms
  • Designed allows JavaScript to be embedded into a form, allowing programmatic changes to the form layout as well as communication with various data sources (ORACLEFORMS AND REPORTS, OLEDB)
  • Developed UNIX shell scripts to perform a nightly refresh of the test system from Production databases.
  • Coordinate with the front end design team to provide them with the necessary stored package and procedures and necessary insight into the data.
  • Involved in all phases of the SDLC for Designing & giving recommended approach to satisfy the requirements.
  • Designing Tables , Constraints , Views , and Indexes etc. in coordination with the application development team
  • Used TOAD, PL/SQL developer tools for faster application design and developments
  • Attend weekly status meetings and Global Meetings with Client to explain the current status of all open issue and pro-actively suggest any processes which can be improved.
  • Resolving the issues on priority basis.
  • Responsible for Analyzing and Implementing the Change Requests.
  • Involved in handling the changes in compiling scripts according to the database changes.

Environment: Oracle 11g, PL/SQL, TOAD, UNIX shell scripting

Hire Now