SUMMARY

• Expertise in writing simple and complex SQL Queries, PL/SQL package, function, stored procedure, triggers, cursors and performance tuning.
• Proficient in advance features of Oracle 11g for PL/SQL programming like Using Records and Collections, Bulk Bind, Ref. Cursors and Dynamic SQL.
• Created database objects like tables, views, sequences, synonyms, indexes using Oracle tools like PL/SQL Developer and Toad.
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan, Query performance, Explain Plans, Indexes and HINTS.
• Enforced data integrity using integrity constraint and database triggers.
• Good knowledge of Star Schema, Snow Flake Schema, Dimension and Fact table.
• Exposure & knowledge of designing logical & physical Data Model in Relational Database Management System (RDBMS).
• Experience in working high - transacted OLTP and OLAP systems.
• Designed and implemented forms and reports using Oracle Forms and Reports 6i/10g.
• Good experience in manual ETL and designing and developing of mappings, transformations, sessions and workflows using ETL Informatica Power Center.
• Developed workflow manager and workflow monitor to create, schedule and monitor the loading processes.
• Extensive experience with all phases of the Software Development Life Cycle including analysis, Resource Planning, code development, testing, implementing and maintenance.
• Documentation of projects for Functional Requirement Spec (FRS), Use case Spec, ER-Diagram, unit testing.
• Assisted QA Teams for bug testing, User Acceptance Testing (UAT) & System Integration Testing.
• Significant experience working with clients, technical teams for executing concurrent multi-technology projects.
• Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies.
• Strong interpersonal and communication skills in dealing with clients.
• Interacted with the business users, collected the requirements, analyze the requirements, design and recommend solutions.
• Strong problem solving & technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction and low operation costs.

TECHNICAL SKILLS

Database: Oracle 11g/10g

Languages: SQL,PL/SQL, Oracle Forms and Reports 10g/6i, UNIX shell script

ETL Tool: OBIEE 12C,Informatica 9.5.1

Operating System: Windows, UNIX

Third Party Tools: PL/SQL Developer, TOAD,JIRA

Development Process: Agile, Waterfall

Configuration Tools: GIT, CVS, VSS

Functional Areas: Telecommunications, Taxation,Insurance,Travel, Treasury.

Project Management: MS Project, Excel

Knowledge only: Python

PROFESSIONAL EXPERIENCE

Confidential, Denver

Sr. Data Engineer

Responsibilities:

• Complete requirements analysis, capture and document the customer s business and technical requirements using JIRA.
• Analyze and develop reports and dashboards using OBIEE 12C .
• Design and implementation of the metadata and/or reporting components of the solution (building and/or modifying OBIEE 12C Repositories) including testing and deployment of the components using GIT.
• Create queries, PL/SQL packages and procedures to support data analysis and ad hoc information requests using TOAD.
• Design and create reporting models for the BI solution in a relational database management system (Oracle 11g) and create UNIX shell scripts.
• Troubleshoot performance issues of a BI environment and evaluate existing logic for tuning possibilities.
• Provide technical support for production reports including troubleshooting.

Confidential

Sr. Software Analyst

Responsibilities:

• Client interfacing and Escalation handling.
• Optimized lot of SQL statements and PL/SQL blocks by analyzing the explain plans of SQL statement and created and modified triggers, SQL queries, stored procedures for performance improvement.
• Developed various backend application programs, such as Views, Functions, Triggers, Procedures and Packages using SQL and PL/SQL language for the top management for decision making.
• Implemented all modules logic by using Triggers and Integrity Constraints.
• Good understanding of database objects and ability to triage issues.
• Involved in PL/SQL code review and modification for the development of new requirements.
• Created materialized views required for the application.
• Performance tuning in the database with, explain plan, query rewrite and hints.
• Design and Development of new requirements and enhancement in D2K forms and reports.
• Client Interaction for new enhancements, Updating JIRA, deployment of code with DBA, Unit testing and resolution with client and support, prepare documents for release.
• Creating new CRs by understanding clients’ requirements and suggesting pro-actively, designing and estimating the same.
• Delivering and implementing the project as per scheduled deadlines; extending post-implementation and maintenance support to the technical support team and client.
• Providing Inputs to the Logical and Physical Data Modeling.
• Delegating the task to the team members and providing functional and technical knowledge.
• Resolving the issues on priority basis.

Confidential

Sr. PL/SQL Developer

Responsibilities:

• Client interaction for requirement gathering, system analysis and finalization of technical/functional
• Design analysis and Document Scoping
• Development and testing the enhancements.
• Development of reports through PL/SQL procedures, materialized views etc.
• Enhancing Performance of the application by implementing various logics and techniques like performance tuning of reports in PL/SQL.
• Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team
• Used TOAD, PL/SQL developer tools for faster application design and developments
• Developed database objects including tables, Indexes, views, materialized views, sequences, packages, triggers and procedures to troubleshoot any database problems
• Created Materialized Views for performance reasons.
• Understanding new requirements of users and adding new features to the system

Confidential

Software Developer

Responsibilities:

• Designed, developed and customized forms by using Oracle Forms 9i and Reports 9i.
• Developed views to facilitate easy interface implementation and enforce security on critical customer information.
• Design forms and reports in D2K.
• Written Stored Procedures using PL/SQL and functions and packages.
• Created programming code using advanced concepts of Records, Collections, and Dynamic SQL.
• Developed Database Triggers for audit and validation purpose.
• Writing validation packages using PL/SQL package.
• Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance.
• Designed and developed reports on ETL tool informatica using different mapping and filter/expressions.
• In-depth understanding of all the mapping operators in ETL- Informatica i.e. join, filter, expression, router, update strategy, transaction control, normalizer, aggregator, look up etc.