OBJECTIVE

Oracle Certified OCA and IT support professional with an outstanding record of accomplishments for providing technology solutions that meet demanding time restraints and exceed expectations. Expertly develop scalable solutions that dramatically improve efficiency, productivity, and profitability with a demonstrated ability to define and map project scope, specifications, project time line, resources and budget requirements from point of planning through production in both traditional and virtual business environments.

SUMMARY

• Extensive experience with analysis, design, development, customizations and implementation of software applications.
• 12 years of IT industry experience encompassing a wide range of skill set, roles and industry verticals.
• Worked as a Oracle PL/SQL Lead at Citibank and Royal Bank Scotland.
• Complete understanding of Oracle advance features.
• Full SDLC Software Development Life Cycle experience Business Analysis, data requirements gathering, Database design.
• Extensive team leadership skills, project management, strong written and inter-personal skills, organizational skills, work ethic and drive and continually striving for process improvements make me a valuable addition to any project team.
• Strong record for delivering high quality, robust and easily supportable solutions that on time and on budget.
• Extensive talent for troubleshooting and providing root cause analysis as well as thinking outside the box for solutions.
• Experience of Data modeling both transactional -OLTP/ and dimensional -OLAP .
• Actively Involved in data profiling ,cleansing and data analysis.
• Experience in handling multiple roles Software Requirements Analyst, Software Architect, Software Developer and Application DBA.
• Actively involved to interact with off-shore team like provide prototype, knowledge transfer, testing and on-time delivery.
• Good communication skills, customer interaction skills, interpersonal skills, self-motivated, quick learner, team player.
• Well versed in Normalization/De normalization techniques for optimum performance in relational and dimensional database environments.
• Proficient in System Analysis, ER/Dimensional Data Modeling, Database design and implementing RDBMS specific features.
• Well versed with Data Migration, Data Conversions, Data Extraction/ Transformation/Loading ETL using PL SQL Scripts.
• Involved in conducting Technical Interviews in the areas of Banking and Oracle development.
• Experience with the Software Development Life Cycle SDLC Process - performing detailed analysis, collecting requirements, documenting requirements, coding and unit testing, integration and system testing.
• Extensive experience in Performance Tuning using various techniques like Explain Plan, analyzing objects, query rewriting, memory management, object dead lock handling, generating statistics. Indexes, Hints, Partitioning, Data Analysis, Optimization, Tuning queries, collections, Cursors, SQL Loader and Normalization techniques to overcome the performance issues in production environment..
• Excellent analytical and problem solving skills and can work independently.
• Strong communication and interpersonal skills, with demonstrated team dynamics.
• Used dynamic SQL and Collections also used BULK COLLECT to load the bulk data and used PL/SQL RECORDS.
• Worked in debugging and Tuning the PL/SQL code, Explain plan, tuning queries, optimization for the Oracle database.
• Proficient in Oracle Forms and Reports.
• Experienced in SAP HANA.
• 24/7 production application support, debugging and solution delivery.
• Implemented table partitioning, Bulk Collect, FORALL to improve performance and data management. Bitmap indexes were used on low cardinality columns as they result in reduced response time for queries and substantial reduction of storage space.
• Experience in Using SQL Loader, Forms Data Loader Utilities and also in Using UTL FILE

SKILLS/TOOLS

PROFESSIONAL EXPERIENCE

Confidential

SQL Developer

• An Oracle Based system used by LPL Commission Group and Registration System. ComReg contains the commission, registration and some cpmpliance releated apps.It is the transaction processing system and repository for all commissions and Registration data associated with LPL advisprs. It also produces a variety of financial management,sales, and compliance reports..

Confidential

SQL Developer

• Work closely with the business analysts and project management team to design and architect highly scalable systems to meet the business requirements. Coach and mentor Database Developers recommend and establish standards, guidelines, and procedures for the design and maintenance of database applications, evaluate and recommend new technologies and tools, and provide technical leadership on development projects.
• Facilitate the analysis and ensure common understanding of operational and analytical business data requirements.
• Create the physical data model with a data modeling tool like Erwin. Generate and execute DDL to create databases, tables, and views.
• Identify and create primary indexes, partitioned primary indexes, and secondary indexes, join indexes, and all other needed indexes. Assist with the cleansing and maintenance of the databases.
• Participate in data model review board discussions.
• Participate in and support design reviews and code walkthroughs to ensure delivery.

Confidential

SQL Developer

Role and Responsibility

• PL/SQL development packages, procedures, Scripts, functions and triggers .
• Understand the existing SAS code, Microsoft Access, convert it into Oracle.
• Gather requirements and write specification and functional design documents for software development.

Confidential

Role and Responsibility

• PL/SQL development packages, procedures, Scripts, functions and triggers .
• Oracle Forms/Reports Development.
• Perform business gathering requirements from business users, stakeholders, and Subject Matter Experts SME's
• Responsible for requirements and design phases.
• Developed a layer to close the gap between DRI and Rainbow.
• Gather requirements and write specification and functional design documents for software development.
• Coordinate and communicate tasks with developers and off-shore Team .
• Deliver new and complex high quality solutions to clients in response to varying business requirements.
• Ensure that development is performed as per requirements.
• Responsible for managing scope, planning, tracking, change control, aspects of the project.
• Responsible for effective communication with the customer and to provide project status to the customer.
• Utilize in-depth knowledge of functional and Technical experience in Oracle PL/SQL, Unix Shell Scripting, Data Stage ETL , Oracle SQL Loader and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customer.
• Establish Quality Procedures and continuously monitor and audit to ensure the deliverable meets quality goals.

Confidential

Role and Responsibility

• Involved in requirements and design phases.
• Oracle Forms/Reports Development.
• Gather requirements and write specification and functional design documents for software development.
• Coordinate and communicate tasks with developers and off-shore Team.
• Deliver new and complex high quality solutions to clients in response to varying business requirements.
• Ensure that development is performed as per requirements.
• Responsible for managing scope, planning, tracking, change control, aspects of the project.
• Responsible for effective communication with the customer and to provide project status to the customer.
• Utilize in-depth knowledge of functional and Technical experience in Oracle PL/SQL, Unix Shell Scripting and Data Stage ETL , Oracle SQL Loader and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customer.
• Establish Quality Procedures and continuously monitor and audit to ensure the deliverable meets quality goals.
• Assist Oracle developers in troubleshooting existing production code.
• Perform team member code reviews to ensure standards and Best Practices are being adhered to.
• Perform code modification to Oracle stored procedures, functions when necessary to assist team.
• Production Support.