We provide IT Staff Augmentation Services!

Lead Pl/sql Developer Resume

Lyndhurst, NJ

SUMMARY

  • Oracle Certified Professional (OCP) and Tuning expert having 16 yr’s experience on medium to large - scale global project in Finance, Telecom, Retail, Insurance and Entertainment domain
  • Core work experience in programming on Oracle SQL, PL/SQL, Unix Shell Scripting, Data modeling, Analysis, Scheduling, Monitoring, Batch Processing, Release & Deployment management
  • Proficient in analyzing and translating business requirements to functional or technical requirements into solution blueprint
  • Proficient to use Toad Data Modeler database design tool to visually create, maintain and document new or existing database system’s ER Diagram for Data Warehouse/ Data mart
  • To identify project requirements and develop/deliver high-quality solutions to clients in response to varying business needs under Agile methodology in Agile environment
  • Proficient in entire SDLC from Business Requirement, FRs, SRs, POC, ADD, Development to implementation with emphasis on programming in Oracle SQL, PL/SQL for schema, table and other DB objects creations like Package, Procedure, Functions, Trigger, Cursor etc.
  • Expertise in using Oracle 9i/10g/11g/12c Enterprise edition
  • Extensive experience in Oracle PL/SQL and Unix Shell Scripting
  • Proficient in related tools like Toad, PL/SQL Developer, SQL Developer, Toad Data Modeler
  • Proficient in query optimization and troubleshooting
  • Experienced in basic BO server administration on Windows/Unix platform e.g. user management, access management, release management etc.
  • Implementing ETL codes and process flows with various PL/SQL blocks and shell scripts to trigger ETL automatically and scheduling through Crontab, Autosys
  • Ability to work independently as well as work with teams having varying backgrounds on complex issues and have strong verbal and written communication skills
  • Measuring various SLA (Service Level Agreement) metrics for Environment and Configuration team and taking corrective action plan during LAM (Look Ahead Meetings)
  • Extensive experience with analysis, design, development, customizations, Build, Deployment and implementation of software applications using agile methodologies
  • Effective in meeting with BU, stakeholders and subject matter experts for eliciting requirement and translating those needs into concise functional and non-functional requirements
  • Maintain a sense of pride in a job well done; detail-oriented, professional, and self-directed
  • Thirst for knowledge and how to apply learning to address current company projects requirement
  • Problem-solving skills and the ability to think out of the box
  • Coordinate between development team and testing teams to ensure quality gates and right method followed by project team
  • Data Analysis for OnLine Transaction Processing (OLTP) and Data Warehousing (OLAP) applications
  • Sound understanding of the Data modeling concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables
  • Expert on Data Modeling - Conceptual, Logical, and Physical Data Models
  • Experience in Extracting, Transforming and Loading ( ETL) data from spreadsheets, database tables and other sources using Informatica
  • IBM DB2 Database Experience, modified procedure, functions and Modules to meet requirement

TECHNICAL SKILLS

Databases: Oracle 12c/11g/10g/9i/8i, MS Access, MDM, DRM, IBM DB2 10.5

Programming Languages: SQL, PL/SQL, UNIX Shell Scripting, C and Cobol

Development Tools: TOAD, PL/SQL Developer, SQL Developer, Oracle Enterprise Manager, SQL*Plus,, PuTTY, WinSCP, AFT-SWM

Data Modeling Tools: Toad Data Modeler, Software Engineering and Architecture (SE&A), Rational Software Architect (RSA) 9.0, Rational Portfolio Manager (RPM) 6, Rational Team Concert (RTC) 6, Informatica 7.1, MS Visio

Oracle Utilities: SQL*LOADER, UTL FILE, Data Pump (Export/Import)

Operating Systems: Windows 2003/XP/7/10, HP UNIX, Linux, Sun Solaris

Version Control & Migration Software: Visual Source Safe, SVN, Jira, HP Service Desk, Quality Centre, CM Synergy, Change Synergy, SM7, iTrack, Gitlab

Production Job Scheduler: Control-M, Crontab, Autosys, Net Term/Tivoli Maestro/CONMAN/COMPOSER7.0

PROFESSIONAL EXPERIENCE

Confidential, Lyndhurst, NJ

Lead PL/SQL Developer

Responsibilities:

  • Maintain PFS, RLS, CMS, EMEA and APAC instances and debug the RCA for Pre-Pack B & R PO/ ASN, physical inventory related issue and provide the functional or technical resolution
  • Debug & maintain Class, Vendor, Style, Color, Size and location related issue of each inventory
  • Develop robust SQL statements and optimize them for maximum performance by analyzing the execution plan and changing them as needed
  • Develop new DB objects like stored procedures, functions, packages, indexes, views, sequence, triggers, cursors and modify existing SQL or objects
  • Understand end-to-end Data flow and data integration rules
  • Maintaining the integrity rule of Business processes by changing the database objects
  • Challenges the BA on defined BRD and writing trampled functional/technical requirement
  • Understand the data and reverse engineer with business stakeholder
  • Existing databases reverse engineered into Toad Data Modeler models and displayed as Entity Relationship Diagrams (ERD)
  • Fix the issue related to daily cyclic job, nightly batch job and monthly batch job failure
  • Abstracts the complexity of a system into a manageable model that describes the essence of a system by exposing important details and significant constraints
  • Coordinate between development team and testing teams to ensure quality gates and right method followed
  • Managing the team of 5 resources and have extensive experience of working closely with Clients from various client locations of USA, EU, APAC

Confidential

Lead PL/SQL Developer

Responsibilities:

  • Participate in all phases of the Software Development Process including design, development, testing, deployment and maintenance
  • Develop new DB2 objects like stored procedures, functions, views, sequence, triggers, cursors and modify existing SQL or objects
  • Develop DB2 stored procedures, functions and SQL statements which will be used by client's Planning Systems applications
  • Design and develop conceptual, logical and physical data models for Manual Order and eCom replenishment for both Oracle and DB2 Database
  • Used Toad Data Modeler to create logical, physical and universal Entity Relationship Diagrams (ERD) - models for Oracle and DB2 Databases
  • Existing databases reverse engineered into Toad Data Modeler models and displayed as Entity Relationship Diagrams (ERD)
  • Have designed upgrade/modifications of existing schemas as per business requirements and applied the appropriate constraint to maintain the data integrity
  • Responsible for establishing data modeling best practices for advanced analytics, multivariate analyses, business intelligence, data management, and forecast analytics
  • Create database tables, indexes, views, triggers and other objects in development environment
  • Develop robust SQL statements and optimize them for maximum performance by analyzing the execution plan and changing them as needed
  • Collaborate with other DB2 developers and DBAs to promote changes from development environment to QA and UAT environments
  • Work closely with .NET developers to ensure a smooth integration of front-end and back-end parts of applications and setup test data

Confidential, PA

Programmer Analyst

Responsibilities:

  • Understand end-to-end Data flow and data integration rules, standardize and cleansed data
  • Design and develop conceptual, logical and physical data models for data marts
  • POC for Trillium job stream used for cleanse, parse, geocode, generate window key
  • Redesign of Pre-merge which handles exact match and merge process which handles fuzzy duplicates by creating Fact and Dimension tables for AIME data mart
  • Code changes to fix split household issue and introduce mapping table to keep track of changes
  • Through analysis of many complex packages and modified to improve the performance
  • Design solutions to complex problem with an emphasis on efficiency, quality, and simplicity
  • Ability to lead a diverse team with different skill level and background challenged with complex task
  • Created oracle objects like Tables with appropriate constraints, Views, Indexes, Sequences etc
  • Peta-byte scale datamart tuning through AIME for campaign management / merge management
  • Additional DBA responsibilities like debugging performance bottleneck and tuning the sequel by using latest analytical function
  • Developed various anonymous PL/SQL blocks and named PL/SQL blocks like procedure, function, trigger, cursor and packages as per need basis and tuned the underlined sql
  • Used Toad Data Modeler to create logical, physical and universal Entity Relationship Diagrams (ERD) - models
  • Have designed upgrade/modifications of existing schemas as per business requirements
  • Used SE&A for architecting new schema from scratch and reverse engineering to connect to DB
  • Responsible for establishing data modeling best practices

Hire Now