Business Analyst; Technical Analyst, Stream Lead, Developer

Since late 1990ies working as developer, consultant, system engineer, technical, business analyst in technical as well as in business departments for international companies in Austria, Germany, UK, USA, Swiss for industry, banking, telecommunication companies.
Focus is on turning business needs into mostly Oracle database solutions and its adjacent tasks and challenges for satisfying customers, users, stakeholders.


Oracle experience:

• 10+ years of experience with expertise as Oracle PL/SQL Developer in areas of application software development and maintenance in Oracle environment
• Good understanding of Business Functionality in Pharma, Banking industry, Telecommunications
• Created Packages, Procedures, Functions, Triggers, Cursors using PL/SQL in UNIX and Windows environment
• Created Schema, Users, Tables, Constraints, Indexes, Triggers, Privileges, Roles, Cursors, Ref Cursors, User Profiles, anonymous blocks, directories, sequences, and synonyms.
• Granted resources, privileges and roles to users
• Tuned SQL queries using EXPLAIN PLAN, Hints and SQL*Plus Auto trace report for query optimization
• Used Oracle built-in packages
• Performance Tuning of Oracle Applications 
• Wrote Shell Scripts for scheduling jobs in Unix/Windows, migrating data into tables.
• Experience on Data migration activities and business data validations.
• Good experience in trouble shoots the issues (Apache, PL/SQL, Batch scripts,VBA).
• Application development with all stages of System Development Life Cycle (SDLC): design, analysis, coding, and testing
• Offshore consulting experience