Oracle 10g & Reporting Specialist

•8 Years of Oracle PL/SQL Development Experience. Very comfortable in writing Packages, Stored Procedures, Functions, Triggers, Built-in Functions, using Oracle Data Dictionary.
•Tuning of Oracle procedures using tools like TKPROF, Explain Plan, Toad Tuning Utility.
•Have worked on Diversified Reporting tools like Oracle Reports and Crystal Reports XI.
•Experience in Universe Designer 11.5 and Web Intelligence Reports
•Worked on Oracle Analytical Functions.
•Loading huge data files using SQL Loader and External Tables.
•Experience with Data Modeling Tool like E-R Win and VISIO.
•Very comfortable in writing shell scripts and using UNIX as an operating system.
•Strong Data warehousing Concepts of Materialized views, File Feeds, ETL Processes etc.
•Experience includes preparation of Migration of Database, Preparing Migration Scripts etc.
•Strong Reporting Skills using Crystal Reports XI and Oracle Reports. Development, Deployment and Maintenance of over 100 reports.
•Done enhancement and Support of applications on SQL Server2000.
•Support and Enhancement of DTS Packages.
•Possesses expertise in Database Design and Development, skilled at progressing from problem statement to well documented designs.
•Strong Knowledge of Oracle Development 9i and 10g and Code tuning.
•Solid Management skills, demonstrated proficiency in leading and mentoring individuals to maximize levels of productivity, while forming cohesive team environments.
•Analytical thinker that consistently resolves ongoing issues or defects, often called upon to consult on problems that have eluded resolution by others.
•Proficient problem-solver who envisions business and technical perspectives to develop workable solutions.
•Motivated achiever who guides organizations in applying technology to business settings, provides added value, and creates project deliverables in a timely manner.