Description
SUMMARY OF QUALIFICATION Around 9 years of IT Experience as Oracle Application Developer for System Analysis, Designing, Testing Development & Support of Oracle 9i, 10g, 11g & 12c, MS SQL 2005/2008 in Production, Staging, Development environments. * Experience in pharmacy, financial, insurance, health and manufacturing domain. * Well versed with Databases - Oracle (OCA Certified), MSSQL Server, MongoDB, PostgreSQL, Netezza and SQLite. * Proficient in Data modeling for Data Warehouse/Data Mart development, Data Analysis for Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/Business Intelligence (BI) applications. * Expert in creating SQL Queries, PL/SQL package, function, stored procedure, triggers, and cursors. * Created database objects like tables, views, sequences, synonyms, indexes using Oracle tools like SQL*Plus, SQL Developer and Toad. * Created interactive reports and UI using Oracle APEX, Oracle Forms and Reports, Tableau, OBIEE, Oracle Postal, BI/BO. * Modified the CGIs to generate dynamic content on web pages and web applications. * Developed application using JDBC, Servlets, SQL injection, CCS, jQuery, JavaScript, Bootstrap. * Created and modified Oracle forms and reports with Oracle Report Builder. * Proficient in advance features of Oracle 11g and 12c for PL/SQL programming like Using Records and Collections, Bulk Bind, Ref. Cursors, Varrays, Nested tables and Dynamic SQL. * Experience in SQL and PL/SQL tuning and query optimization tools like SQL Trace, TKPROF, Explain Plan, DBMS_PROFILER. * Strong knowledge in Oracle utilities like SQL*Loader, Export/Import and Data Pump. * Extensively used package like DBMS_STATS, UTL_FILE, DBMS_SCHEDULER and UTL_MAIL. * Hands on experience with Crontab in UNIX environment for scheduling routine tasks. * Strong knowledge with PL/SQL Wrapper to protect the PL/SQL procedures or packages. * Around 9 years of experience in IT Industry involved in SDLC * Requirements and Object-oriented Analysis. * Strong front end web development experience using: MVC, C#, ASP.Net, and Web Forms. * Excellent PL/SQL skills - building packages and writing procedures for extremely large data sets using advance features of oracle (close to 1 billion records or more). * Experience creating and consuming RESTful APIs, i.e. Web API. * Strong in integrating .Net and Java applications with Oracle and back end databases. * Strong application development experience in .net and Java using JDBC, CCS, HTML5, jQuery, jScript, Bootstrap, ASP.NET, MVC, ADO.NET, AWS, Angular JS, Node JS, Backbone JS, Reporting Tools, SSRS/SSIS, XML. * Knowledge of machine-to-machine communication standards, including web services (XML, SOAP, WSDL, WCF Web services, JSON, and RESTful service architecture and design). * Extensively used Cubes & Rollups for making cross-tabular reports. * Strong knowledge of Star Schema, Snow Flake Schema, Dimension and Fact table. * Expertise in handling errors using Exceptions. * Transferred data using data transfer tools like FTP (File Transfer Protocol) and SFTP (Smart FTP). * Exposure & knowledge of designing logical & physical Data Model in Relational Database Management System (RDBMS) for both OLTP and OLAP system. * Extensive experience with all phases of the Software Development Life Cycle including analysis, Resource Planning, code development, testing, implementing and maintenance. * Have worked in fast-paced AGILE environment & attended daily scrum meeting. * Assisted QA Teams for bug testing, User Acceptance Testing (UAT) & System Integration Testing. * Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies. * Strong interpersonal and communication skills in dealing with customers. * Experience in Facets, Clarity, SOA Arch, CMS and knowledge on JDA driven environment. SKILL & TECH MATRIX Operating System PROFESSIONAL SUMMARY
Accomplishments
Highlights:
Keywords
