We provide IT Staff Augmentation Services!

Production Support Lead And Pl/sql Developer Resume

Nutley, NJ

PROFESSIONAL SUMMARY:

  • Oracle Certified Professional (OCP) and Tuning expert having 16 yr’s experience on medium to large - scale global project in Finance, Telecom, Retail and Insurance 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, Control-M
  • 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
  • Confidential DB2 Database Experience, modified procedure, functions and Modules to meet requirement

TECHNICAL SKILLS:

Databases: Oracle 12c/11g/10g/9i/8i, MS Access, MDM, DRM, Confidential 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, 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, Nutley, NJ

Production Support Lead and PL/SQL Developer

Responsibilities:

  • 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
  • Abstracts the complexity of a system into a manageable model that describes the essence of a system by exposing important details and significant constraints
  • Leading the team of 5 EP resources and have extensive experience of working closely with Clients from various client locations of USA and Liaison between RDC offshore team and onsite team
  • 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

Confidential, NJ

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
  • 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
  • Coordinate between development team and testing teams to ensure quality gates and right method followed

Confidential, NJ

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 Confidential 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 Confidential 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
  • Existing databases reverse engineered into Toad Data Modeler models and displayed as Entity Relationship Diagrams (ERD)
  • Co-ordinate with DBA team for physical implementation
  • 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, NY

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, NJ

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

Confidential, NC

Business Analyst/ Modeler

Responsibilities:

  • Worked on 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.
  • Worked on Hyperion DRM (Data Relationship Management) where reporting structure are maintained, analyzed and validated
  • Hands on experience in the following aspects of Hyperion DRM:
  • Version creation / maintenance
  • Hierarchy creation / maintenance
  • Nodes creation / maintenance
  • Modeling the users
  • Defining properties
  • Defining formulae for properties
  • Creating validations and assigning to the respective hierarchies
  • Updating the property values
  • Working with exports and imports
  • Perform impact analysis, configuration design and development of business flow change requests, addition of new business processes based on client requirements
  • Propose implementation strategies for new business requirements
  • Understand changes to business functionality and developing test plans
  • Write change control plans to implement application changes by creating procedure, functions and packages
  • Coordinate with infrastructure support teams during Staging and Production deployment
  • Maintain the compliant state of the applications by following approved Standard Operation Procedures (SOP)
  • Analyze reported defects and fix system bugs using Shell scripting and TOAD
  • Provide and support to team members in understanding the critical business processes
  • Review and ensure that deliverables are prepared to satisfy the project requirements and ensure that deliverables satisfy the project cost and schedule
  • Maintain the Oracle Database and MDM application server's objects
  • Extended support and guidance to client for publishing submission using TFS and nexus
  • Good understanding of Batch loading processes and tools like Autosys to create .jil file
  • Improve the process without impacting existing applications by tuning
  • Trouble shoots application problems and provides temporary as well as permanent solution to mitigate the risks and take corrective action
  • Work on onsite - offshore model and coordinate among team members

Confidential

Database Lead

Responsibilities:

  • Understand end-to-end Data flow and data integration rules
  • As an Onsite Coordinator, have worked on many FRs and passed to RDC team as per business requirement
  • Designed upgrade/modifications of existing schemas as per Business requirement
  • Had to capture requirements from Business and provide solutions
  • Providing High level Design and getting it signed off with client
  • Had to coordinate requirement walkthrough for offshore development & Testing team
  • Had to review Low level design, code, unit test documents produced by team members
  • Automated COS (Commissions) payroll process and cloning process effectively so client provided accolade for this effort as an individual contributor
  • Used Unix shell script (Solaris) to automate above manual process and schedule it in Crontab
  • Collaborate and leading the deliveries within Onshore-Offshore model
  • Involved in monitoring the performance in production and accordingly proposing upgrades/modifies in existing design like adding/deleting indexes in tables, partitioning tables, replacing traditional extract logic with implementation of materialized views etc.
  • Regularly working on Various Data analysis requests and producing reports
  • Providing various weekly and monthly reports - creating PL/SQL blocks for each report to execute periodically
  • Proficient in using TOAD, Oracle SQL Developer, MS Visio
  • As a Lead PL/SQL developer, involved in all phases of SDLC to ensure requirement
  • Understand the End-to-end Architecture of existing Business and each application and data correlation across systems
  • Identifying relevant Databases and Entities and providing the end-to-end solution
  • Created Fact and Dimension tables to meet the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling
  • Had to review Low level design, code, unit test documents produced by team members
  • Used Visio, Oracle SQL Developer and TOAD Data Modeler
  • Monitored Production Environment and maintaining Application Health throughout 24*7
  • Staging the code before it goes to production deployment

Confidential

Production Support Specialists

Responsibilities:

  • Scheduled and Monitored GRS US and Canada batch schedules having job runs Daily/ Weekly/ Monthly/ Quarterly/ Semi-annually/ Recurring using the Tivoli Maestro, Console Manager
  • Investigated and fixed problems related to batches/services failure
  • To find out the reason of abend, do analysis and further step had taken for resolution including database related issues
  • Modification in database object using TOAD, PL/SQL Developer, Oracle SQL Develop
  • Converted oracle report into SQL* Report
  • Produced corresponding low level design which included design of Entities, attributes, constraints, Primary keys, Foreign Keys, Index etc.
  • Developed various anonymous PL/SQL blocks and procedure, functions to be called in process flow
  • Global Royalty business logic understanding for US and Canada and providing end to end business rule implementation
  • Created UNIX scripts to automatically schedule the job in Maestro job scheduler
  • Set dependency on job by using conman Confidential Tivoli Workload Scheduler production processes
  • Developed various PL/SQL blocks to accommodate changes in existing business logic

Confidential

Database Developer

Responsibilities:

  • Involved in the Creation and modification of Procedure, Function, Trigger, Cursor as per business need
  • Created and maintained connections to all the Source Databases
  • Interacted with system specialists to analyze the requirement changes and implemented the solution
  • Basic User Administration like User creation, Group Creation, granting proper access etc.
  • Continuous drive for improved customer experience
  • Captured requirements from client and communicating same to team
  • Used Toad and Visio to accomplish above assignments

Hire Now