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
Confidential
Lead PL/SQL Developer
Responsibilities:
- Responsible for data analysis/reconciling gap for missing data elements between CDB and RDR
- Modified DB objects like procedure and table to make it fit as per Legal Entity Allocation process
- Designing new tables and appropriate constraints on Oracle 11g database
- Maintaining and Creating new DB objects like tables, procedure, function, trigger, cursor and packages as per need basis using PL/SQL
- Modified CDB Expense Code table and all areas where expense code data is displayed or entered (e.g., Statement Templates screens, Chargeback screens, Reports), as well as any internal CDB batch processes/updates
- Modified/migrated entire Confidential code from old legacy system to new e-ledger Central DB
- Analyzes source data files to layout to develop data conversion requirements
- Ensures all required data elements are being received after conversion
- Develop DB report as per client requirement and help to integrate them with UI
- Regularly working on Various Data analysis requests and producing reports
- Automated the Batch loading reports using tools like Autosys to create .jil file
- Prepares initial Data Conversion File request and schedule for receiving data files using Autosys
- Improve the process without impacting existing applications by tuning
- Partners with data conversion/platform configuration team to identify specific scenarios in order to ensure quality
- Participates in internal testing and review of data/configuration
- Defines data edits that should be run to validate accuracy of data received
- Have to coordinate with UI team to understand the PL/SQL requirements and develop objects
Confidential
Lead PL/SQL Developer
Responsibilities:
- Understand Business Requirement and prepare FRs, SRs, POC, ADD (HLD & LLD), Development to implementation with emphasis on programming in Oracle SQL, PL/SQL and Unix Shell Scripting
- Used to create schema, table and other DB objects like Package, Procedure, Functions, Trigger, Cursor etc. based on its suitability and requirement
- Have to understand End-to-end Data flow and data integration rules to implement logic
- Daily activities include, PL/SQL anonymous blocks & Objects creation, integrating them with shell script, Generating Reports using SQL queries
- Have to build the Package to implement business logic, the entire transformation and load is happening through PL/SQL packages as per inbound feed receives
- Have to coordinate with Java team to understand the PL/SQL requirements
- Writing various packages for each activity of DML (Insert/Update/Delete/Search etc), to be performed from Front-end
- Write code to maintain Data integration and dependency rules in above cases e.g.: If user delete some information from a main table, corresponding all depended table entries should be deleted through program
- Understand various search criteria available on the front end and coming up with very highly tuned SQL queries and performance improvement
- Creating highly tuned, complicated SQL queries for various reporting requirements which runs daily, weekly, monthly, Quarterly, semi-annually and annually
- Coordinate between development team and testing teams to ensure quality gates and right method followed
- Reviewing Low level design, code, unit test documents produced by team members
- Responsible for identifying the need for different data setup required for the testing phase and set up the same by working closely with DBA team
- In addition to these, creating various batch Jobs to automate report generation and transferring flat files (Reports) to various other locations through FTP/ SFTP /SCP etc.
- Scheduling above mentioned jobs in Unix crontab Scheduler and monitoring periodically
- Responsible for continuous Build and continuous install in all production and non-production environments like IT/ST/JST/STM/PM/DEV/UAT/LSP
- Build & Install on all environments and fixes any issue if arises on daily and weekly basis as per management direction
- Builds and deploys Web Applications in a clustered and load balanced N-Tier infrastructure
- Manage Release Schedule & Related Processes/Approval to ensure project team adhere