PL/SQL developer. Resume

SUMMARY:

3+ years of experience in IT Industry, Currently working as Software Engineer(Technical Analyst) in Oracle.
Expertise in OBIEE (Repository and Report building).
Designed and Tested Reports in the Dashboards for Sony Music & Lloyds TSB Analytics Team (Client).
Good knowledge of Oracle PL/SQL .
Knowledge in ETL Design using Informatica.
Good exposure to Oracle data warehousing concepts.
Strong problem solving and effective communication skills.

TECHNICAL SKILLS:

Business Intelligence: OBIEE 10g, 11g.

ETL Tool: Informatica Power Centre 8.6

Programming Languages: SQL, PL/SQL.

RDBMS: Oracle 9i/10g/11g

Web Technologies: HTML.

Operating Systems: Windows

Tools: and utilities: PLSQL developer.

Platforms: Knowledge of Linux (Red Hat),Windows XP,WIN 7, Windows Server 2008.

Scripting: Perl environment(Version:5.1.0),Perl CGI, Shell scripting.

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

Effectively interacted with the end users for requirement gathering and defined requirement specifications document by access and retrieval of financial and personnel data from one single source.
Identified & Created Facts, Dimensions, and Hierarchies of the business model.
Designed and Tested Reports in the Dashboards.
Configured Interactive Dashboard with drill - down capabilities using global and local Filters.
Developed different kinds of reports (pivots, charts, tabular) using global and local Filters.
Responsible for understanding the issue happening at the user end and to provide proactive support for that.
Replicating the same environment that is with client at our end to reproduce the bug and help to resolve the same.

Platform/Technologies Used: Business Intelligence Tool: OBIEE 11g

PL/SQL developer.

Confidential

Responsibilities:

Effectively interacted with the end users for requirement gathering and defined requirement specifications document.
Worked on end to end implementation of BI.
Architecture of OBIEE.
Hands on Experience in Creating Repository building (RPD), BI Publisher and answers.
Experience of working and configuring dashboard/answers, scheduler, iBots (Delivers).
Involved in Generation of the Yearly/Monthly Sales reports (Artist/Country) according to the business requirement.
'Dashboards' were generated to provide insight into the Analytical data.
Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
Troubleshoot performance issues in OBIEE environment
Knowledge of ETL using Informatica to facilitate Extraction Transformation and data Load from OLTP systems to OLAP systems.
Experienced in Data Modeling using Dimensional Data Modeling, Star Schema modeling, Fact and Dimensions tables.
Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to OBIEE Repository.
Responsible for Processing of the data for different Providers in staging, test and production databases using Perl scripts.
Handling Load Failures using Stream Works.
Maintenance of the Data, Tables, Indexes, Sequences using the needed Triggers which were created at the start of the RDB Design.
Also created user Interface using PERL CGI which is helpful in monitoring all the activities for the support team helping in analyzing the entire flow on a daily basis.
Worked on complex queries to perform DML operations (Insertion and updating the tables as per requirements).

Platform/Technologies Used:Business Intelligence Tool: OBIEE 10g Database Layer: Oracle 10g

PL/SQL developer.

Confidential

Responsibilities:

Worked on Requirement Analysis, Design, Development and Testing of Table/View DDLs, stored procedures and triggers
Worked on OBIEE to create new and modify existing reports.
Was responsible for the dealing with the problems, bug fixing and troubleshooting during Integration testing

Technologies Used: Database Layer: Oracle 10g

PL/SQL developer.

Confidential

Responsibilities:

Worked in Client-Server Based Environment. The client/server environment we used is to get access to large amounts of data.
Worked on Windows Server 2008 R2 (used as a workstation/ Dedicated server).
Knowledge of Code protection as a solution to provide agile and cost efficient network protection against link failures.
Knowledge of Concurrent version system(CVS) (Version control system) installed on the system to manage changes of documents, programs, images and other information that is stored in form of computer files.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship