SUMMARY:

• Having 10 years of Agile developer experience in Oracle technologies with excellent communication skills and a strong commitment to team environment dynamics with the ability to contribute expertise and follow leadership directives at appropriate times.
• Have worked on applications based on Oracle, Java and .NET technologies and tools Informatica and OBIEE. Actively involved in requirement gathering, technical design and framework, coding and testing, diagnosis and resolution of encountered issues using multiple tools, provide technical solutions, release management, change management and documentation.
• Worked primarily in Banking Domain and currently working for Confidential .
• 10 years of programmer experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of business applications using the Oracle Relational Database Management System (RDBMS).
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Experience with Data flow diagrams, Data dictionary, Database normalization techniques, Entity relation modeling and design techniques.
• Effectively made use of SQL Functions (Single - Row, Aggregate, Analytical), Indexes, Table Partitioning, Collections, Materialized Views, Query Re-Write and Transportable table spaces.
• Created Tables, Views, Constraints, Indexes (B Tree, Bitmap, Function Based and Text Based), Synonyms, Grants, Sequences, DB Links, Types.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Developed materialized views for data replication in distributed environments.
• Experience in Oracle supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE, Dynamic SQL, Records and PL/SQL Tables.
• Loaded Data into Oracle Tables using SQL Loader and worked on import/export utilities.
• Partitioned large Tables using range and list partition technique.
• Worked extensively with Cursors, REF Cursors, External Tables and Collections.
• Expertise in Dynamic SQL, Collections and Exception handling.
• Implemented role based security with different privileges to application and database users.
• Good knowledge of key Oracle performance related features such as Query Optimizer, Cost-Based Optimization, DBMS STATS and Execution Plans.
• Experience with Performance Tuning for Oracle RDBMS using HINTS, Indexes, EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Created Shell Scripts for invoking SQL scripts.
• Created AutoSys jobs for scheduling and monitoring activities.
• Expertise in Client-Server application development using Oracle 12c/11g/10g/9i/8i, PL/SQL Developer, SQL *PLUS, TOAD and SQL*LOADER.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP.
• Good knowledge of Data warehouse and ETL concepts.
• Good understanding of ETL Concepts and worked on tools such as Informatica Power Center and reporting tool OBIEE.
• Experience with Unix and Shell scripting and debug issues with code.
• Involved in unit and integration testing and logging defects. Created test plans and provided scripts for the same.
• Involved in preparing project estimates, timelines and project module execution plans.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
• Good experience with tools like Clear Case for Source code management, automatic deployments with HP DMA tool and other tools like JIRA, Remedy etc.
• Thorough understanding of Change Management tools such as ITSM, Remedy etc, Configuration Management tools (Jenkins, ARM) and Release management principles using tools such as GIT, Bitbucket, Tortoise SVN.
• Ability to thrive in a challenging, extremely fast paced environment and to manage multiple projects & tasks with multiple priorities.
• Ability to work efficiently with internal and external stakeholders and communicate effectively through various means of communication.

TECHNICAL SKILLS:

Databases: Oracle 8i/9i/10g/11g/12c, Greenplum, MS Access, MySQL

Languages: SQL, PL/SQL, Powershell, C, C++, Java, J2EE, UNIX Shell Scripts, Java Script, PHP, Powershell scripting

Tools: SQL *Plus, SQL Developer, TOAD for Oracle, Informatica Power Center, Autosys, Microsoft Visual Studio, Rational Application Developer, OBIEE, SVN, Tortoise SVN, Tortoise GIT, BitBucket, ControlM, Putty, Filezilla, Oracle Coherence, Oracle Goldengate(Replication), Spring Batch, Jenkins, PGAdmin, Quality Center

Operating Systems: Windows, UNIX/LINUX

PROFESSIONAL EXPERIENCE:

Confidential, New York

Quality Analyst

Responsibilities:

• Coordinate with cross functional teams to analyze business requirements and determine technical feasibility of development.
• Collaborate with solution architects, business analysts and peer developers to design database solutions for Oracle based applications.
• Develop functions, procedures, packages, trigger and other DB objects. Worked with indexes, constraints, partitioning techniques, materialized views, Oracle packages such as DBMS JOB for parallel execution, DBMS ERRLOG etc.
• Use optimization techniques such as EXPLAIN PLAN, AUTOTRACE, hints etc.
• Worked on developing Team Management tool framework, used by higher management in the organization.
• Worked with Oracle coherence to develop cache models for database views to improve application performance.
• Was involved in setting up Golden gate replication across AMRS, APAC and EMEA regional database servers, to maintain consistency of data and improve application performance.
• Perform unit testing and integrate components into the existing system. Debug and fix defects found in iterative application builds.
• Monitor and optimize database performance using Oracle tuning techniques.
• Automating and scheduling jobs using DBMS SCHEDULER.
• Work with QA and business teams for system integration and testing, provide relevant test data to ensure quality of solution.
• Troubleshoot production issues including off-hours support.
• Interact with end user and coordinate with internal/external teams for issue resolution.
• Perform source code control using tools such as Visual Studio, BitBucket, GIT etc.
• Perform release management activities and coordinate between multiple teams during deployments.
• Follow agile/scrum methodology of software development, track and record progress of development tasks using JIRA, Confluence etc.
• Working on POC to implement Oracle TimesTen in-memory database.

TOOLS: Oracle 10g/11g/12c,, TOAD for Oracle, SQL*Plus, SQL Developer, Oracle Coherence, Golden Gate replication, Microsoft Visual Studio, Bitbucket, GIT, JIRA, Confluence, Unix Shell Scripts, Powershell scripting

Confidential

Risk Analyst

Responsibilities:

• Collaborate closely and provide services to developers, analysts, and other technology resources with a constant focus on continuous process improvement
• Participate in the application development review process to ensure Production Support team can support new applications and enhanced functionality
• Perform timely escalation of critical issues and proactively identify patterns of recurring issues to improve production
• Participate in periodic production support meetings, scrum calls and other process improvement initiatives
• Thorough understanding of Change Management tools such as ITSM, Remedy etc, Configuration Management tools (Jenkins, ARM) and Release management principles using tools such as Tortoise GIT, Bitbucket, Tortoise SVN.
• Monitor batch production system, scheduling tools, jobs and processes to documented SLA and troubleshoot to resolve issues using various monitoring tools such as Informatica Power center Workflow Monitor, Control-M etc, including on call rotation for weekends.
• Maintaining and/or creating all relevant documentation including but not limited to documents supporting change management process and procedures, job run book, data backup and retention policy, and applicable access controls documentation.
• Schedule and execute batch processes and jobs in lower environments, perform unit and regression testing along with development team.
• Requesting required Functional IDs access and managing overall harmonization of roles and information access levels across production to all lower environments
• Suggest fixes to complex issues by doing a thorough analysis of root cause and impact of the defect
• Manage the process to ensure that all incident tickets are logged and tracked and followed through to resolution.
• Release management - Coordinate with Application Development Team to successfully deploy software releases in both User Acceptance Testing and Production environments
• Deployment of source code to Production and UAT (testing) environments within established SLAs.
• Work with external teams(upstream/downstream sources, infrastructure teams etc) to complete tasks within SLA and resolve issues related to jobs and processes.
• Create change management request and attend calls with CAB teams.
• Ability to thrive in a challenging, extremely fast paced environment and to manage multiple projects & tasks with multiple priorities.
• Communicate issue status to internal and external stakeholders

TOOLS: Oracle 10g/11g, TOAD for Oracle, SQL*Plus, Shell scripts, UNIX, Microsoft Visual Studio, Autosys, Rational Application Developer 8, Quality Center, Tortoise SVN, Tortoise GIT, Bitbucket, Jenkins, Control M, Informatica Power Center, PGAdmin, Filezilla, Putty, Spring Batch

Confidential, New York

Responsibilities:

• Interacted with the client on a daily basis and gathered requirements.
• Designed dynamic implementation frameworks for new requirements and enhancements.
• Communicated and explained requirements to the offshore team.
• Coordinated with the front-end team to provide them with the required backend support and necessary insight into the data.
• Involved in continuous enhancements and fixing issues in production.
• Worked with different technical teams to find solutions and root cause to application related issues.
• Involved in unit and integration testing. Created test plans and provided SQL scripts for the same.
• Provided ad-hoc scripts for data updates to remote databases.
• Provided scripts for creation of DB objects using client provided automation tools and Visual Studio TFS.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Created and modified UNIX shell scripts for the batch jobs used in the application.
• Created indexes on the tables for faster retrieval of data to enhance database performance.
• Performed SQL and PL/SQL tuning using Hints, Indexes and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Used hints to direct the optimizer to choose an optimum query execution plan.
• Extensively used bulk collection in PL/SQL objects for improving the performing.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.
• Experience in understanding complicated performance issues and worked with DBA's to suggest ways to fix the problem.
• Responsible for Analysing and Implementing the Change Requests and worked with different technical teams to have solutions implemented.
• Daily interaction with client and different technical teams to solve issues in data integrity.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Worked on ETL tools Informatica Power Center and worked with team to analyze mappings and transformations.
• Worked on reporting tool OBIEE to analyze mappings and generate reports based on database objects.
• Writing stored procedures to fetch complex data from different remote databases.
• Building complex SQL queries for report generation.
• Creation of scripts for processes involved in reconciliation of data.
• Creation of notification triggers for different processes.
• Performed SQL and PLSQL tuning using Hints and Indexes.
• Participated in code review with the application front-end team.
• Involved in Java based application support.
• Helped isolate dependencies from front end to back end thus helping in solving data integrity issues.
• Involved in unit and integration testing. Creation of test plans and logging defects in HP Quality Center.

TOOLS: Oracle 10g/11g, SQL*Plus, PL/SQL Developer, Informatica Power Center, HP Quality Center

Confidential

Quality Analyst

Responsibilities:

• Component Integration Testing (CIT)
• Functional Regression Testing
• Ad-hoc Testing
• Reading and understanding the BRD and HLD
• Testing the application
• Identifying and reporting the bugs
• Tracking the bugs
• Execution of the developed test cases in SIT environment
• Updating Quality Center with all the test results and defects

TOOLS: PLSQL Developer, Toad for Oracle, OBIEE, HP Quality Center