We provide IT Staff Augmentation Services!

Developer/ Senior Oracle Pl/sql Developer/technical Lead Resume

Oaks, PA

PROFESSIONAL SUMMARY:

  • Having 14+ years of IT experience in system Analysis, design and development of complex software system primarily in the financial services and banking domain.
  • Experienced in requirement analysis, coding and testing various modules in a software development life cycle.
  • Highly skilled and experienced in Agile Development process for diverse requirements.
  • Excellent team player and proven track record working in various team sizes performing cross - functional roles
  • Expertise in designing, tuning and trouble-shooting advanced technology, large-scale, highly-complex, secured systems employing Oracle PL/SQL technology.
  • Expertise in designing complex interfaces and batch jobs using Oracle PL/SQL.
  • Expertise in designing and developing oracle database applications and business services.
  • 12+ years of experience in Design, Development, and Enhancement and Maintaining applications in Oracle 8i/9i/10g using SQL, PL/SQL in Windows and UNIX environments.
  • Good knowledge of Oracle database technologies, including performance tuning, data modelling, triggers, stored procedures etc.
  • Detailed depth Knowledge in Oracle Architecture, Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
  • Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, and Analytical functions, and Materialized Views, Query Re-Write and Transportable table spaces.
  • Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
  • Worked extensively on Ref Cursor and Collections.
  • Extensive experience in Database query tuning, Performance tuning (Explain Plan and TKPROF utility) of Reports and troubleshooting Oracle Application issues on OLTP and DSS systems.
  • Experienced in Client Server, Web Based and Standalone application.
  • Good knowledge on logical and physical Data Modeling using normalizing Techniques.
  • Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team. Experienced in working Onshore and Offshore model.
  • Knowledge of Core Java and J2EE Technologies like EJB, JDBC, JMS, Servlets etc.
  • Self-Motivated and Proactive to work in any sort of time bound situation.
  • Learning ability to cop-up with the needed skill upgrade demand.
  • Ability to work as individual and with a team.
  • Project Management and Work Breakdown estimation knowledge.
  • Proficient in Financial Services and Investment Banking Business Knowledge including Capital Market, Portfolio Accounting, Client Portfolio Management, Cost Basis Reporting (CBRS) etc.
  • Working experience in Oracle 10G and 9i, PL/SQL, Core Java and EJB
  • Sun Certified in Java JDK1.4.
  • Receive Client appreciation award for developing Health Check Reports which helped in identifying critical production issues. These reports are used to validate production data integrity.
  • Certified Scrum Master.

TECHNICAL SKILLS:

Operating Systems: Solaris, Windows 98/2000/XP, UNIX.

Programming Languages: Oracle (SQL and PL/SQL), Core Java, C, C++.

Web/Application Server: BEA Web logic.

J2EE Technologies: EJB, JDBC, JTA.

Database: Oracle 8i/9i/10g/11g.

Development Tools: Eclipse, Edit Plus, PSPad, SQL Developer.

Version Control: Borland Star team, GIT.

Build Tools: Ant, ivy

Testing Tools: Junit

Other Tools: Log4j, Oracle Aqua Logic Service Bus, Oracle Coherence, IBM MQ, Wily Introscope, BMC Magic, Rally, Source Tree, SOAPUI.

WORK EXPERIENCE:

Confidential

Developer/ Senior Oracle PL/SQL Developer/Technical Lead, Oaks, PA

Responsibilities:

  • Subject Matter expert for day in and day out operations within SWP.
  • Work with Product Manager and business users to create technical solutions to support business processes, including suggesting business process improvements to take advantage of software application development.
  • Create High Level Technical Design and work with other team members to code application components in an agile environment utilizing a test driven development approach.
  • Provide effort estimates, identified potential problems and recommended alternative solutions.
  • Take ownership of applications including upgrade plans to keep to current standards.
  • Mentor team members and help them in resolving Technical and Functional issues.
  • Write PL/SQL Stored Procedures, Functions and Packages.
  • Create database objects like Table Views, Sequence etc.
  • Write Procedure and Functions using Advance PL/SQL concepts like Collections etc.
  • Developed stored procedures and complex packages extensively using PL/SQL
  • Performance tuned DB queries.
  • Prepared and setup of testing environment for QA team in the platform.
  • Developed complex PL/SQL codes to compare and validate data between different databases.
  • Code in Core Java as and when needed.
  • Junit Coding and Testing.
  • Configure Data source, Queue and Managed server on Web logic.
  • Trouble Java/J2EE applications.
  • Performance tuning of database application and database modelling.
  • Provide programming estimates, identified potential problems and recommended alternative solutions.
  • Coordinated configuration of back-end components in support of application development .
  • Mentor the team members.

Environment: Oracle 8i/9i/10g/11g, Oracle PL/SQL, SQL Developer, Windows, Web logic, Apache Tomcat, Eclipse, Core Java, EJB, Web Services, GIT, Rally, Ant, Notepad++, Windows, Unix, SoapUI, PSPad, IBM MQ, Wily Introscope, BMC Magic.

Hire Now