Input your fixed/hourly price in this field.
Freelancers
freelancer
Lekha .
0.0/5 (0 Feedback)
Member since March 24, 2021

1

  • $1.00 / hr
  • TX
  • Save

* Over 8+ years of experience in analysis, design, development, testing and deployment of software applications . * Strong work experience in implementing and handling databases in Oracle. * Expertise in Full Life Cycle Development including Planning, Analysis, Design, Implementation and Maintenance. * Good Understanding of Data Warehousing Concepts likes Star schemas and Snowflake Schemas. * Excellent understanding of Entity Relationship Diagrams (ERDs) and the translation of business requirements into them. * Experience with change management tools like the chameleon of Remedy and processes, including source code control, versioning, branching, defect tracking and release management. * Involved in exhaustive optimization of PL/SQL blocks in both development and production environments * Good experience in working with the interface between different systems and a good understanding of relational databases. * Extensively worked on OBIEE Administration Tool, Answers, Dashboards, Job Manager, Catalog Manager and BI Publisher. * Good understanding of DBMS_STATS packages that affect execution plan. * Good knowledge on OAF, Forms, and Reports. * Experience in creation of various Database objects like Tables, Procedures, View, Triggers, Indexes, Packages, and Types. * Good knowledge in writing complex queries to read data from the database and Entity relation model. * Knoweledge of Oracle Web Logic architecture * Worked on development of Packages, Procedure, and Functions. * Worked on improving the performance of Procedures by using Collections, Records and Types * Good at Unix commands for navigation in UNIX operating system and has knowledge of Shell scripts. * Good knowledge and understanding of Oracle API’s. * In-depth knowledge of applications codes registration procedures. * Ability to identify system impact for small and large scale initiatives. * Experience with global implementations of Oracle EBS Applications. * Very good at trouble shoot issues in applications. Solved all kinds of Data, resources, privilege related and access control related issues. * Hands on Oracle Fusion . * Excellent in backtracking issues to find out the actual issue and find a root cause. * Worked extensively on loading data from OLAP to data marts. * Have very good knowledge on ETL tool Data Stage Designer and Director. * Actively participated in code walkthroughs and code reviews. * Experience in working Agile Software Methodology which helps the businesses responds to unpredictability. * The ability to adapt and learn new technologies and proficient in learning them quickly. * Experience in supporting applications through development, testing, integration testing and production cut over phases. * Well versed with scheduling and running SQL jobs, Queuing and running the ETL jobs and have the ability to write the complex joins to validate the data. * Experienced with Offshore/onshore business models for development activities and involved in daily calls. * Strong oral and written communication skills to maintain productive work relationships with management, clients, team members and other groups. SKILL SET: Operating Systems : Windows NT/2000/2003, Solaris 10, HP-UX 10/11, AIX and Linux Database : Oracle 11g/10G/9i, MS Access 2000, MySQL Languages : C, C++, VC++, C#, Java, PL/SQL programming, RDJ 8.3.2 and Axway Accounting Integrator Web Technologies : HTML and JSP Script Languages : JavaScript, Shell scripting and Perl Application Tools : Forms 6i/9i, Reports 6i/9i, Toad, OEM, PL/SQL, APEX reports, Citrix, Reflections for UNIX, Business Objects, Data stage and Informatics 8.6 Others : Object Oriented Designing Methodology, UML and RDBMS Concepts

0

Ongoing projects

0

Completed projects

0

Cancelled projects

3

Ongoing services

0

Completed services

0

Cancelled services

$0.00

Total earnings

* Click the button to send an offer

Send offer