PROFILE SUMMARY
• A competent professional with 10+ years of IT experience (About 10 years in Oracle PLSQL / MS T-SQL and 5+ years in Non-Oracle Experience) in all phases of Software Development Lifecycle (SDLC) including Requirement gathering, Analysis, Design, Development, Testing, Deployment, Delivery and Support.
• Having 4+ years of development/Implementation experience in Business Intelligence and keen to build a distinguished and successful career in the BI domain.
• Expertly managing medium to large size projects in fields of Solution Design, Project/Team Management, Production Support and Software Development.
• Holds the merit of acquiring over 3 years of Non-IT Experience in manufacturing industry.
• Possess sound knowledge of Oracle SQL/PLSQL (11g/12c), SQL and PL/SQL Performance Tuning. Also have good knowledge of Microsoft SQL Server DB 2014/2017 and T-SQL.
• Good knowledge of ETL (Extract, Transform, Load) process and data modeling. Have experience working on Microsoft SQL Server Integration Services (SSIS) and got knowledge about Informatica PowerCenter.
• Experience in Oracle Server Side Programming (PL/SQL Packages, Stored Procedures, Functions, Cursors, Triggers, Views, Materialize Views, Temporary Tables, Collections etc.), Oracle BI (development and migrations).
• Proficient in identifying/debugging performance issues, SQL and PL/SQL performance tuning (using SQL Trace, TKPROF and Explain plan, DBMS_PROFILER etc.)
• Possess 8+ years of Development Experience and about 3 years of Production Support Experience
• Holds the merit of working with esteemed clients like Cummins Inc., Finolex group.
• Distinguished abilities in suggesting and developing technology-based solutions for enhancing functional efficiency of the organization, achieving business excellence and ensuring delivery of technical service
• Facilitated technical, solution development and project execution/support to various projects throughout the firm; Developed solution designs to support core business processes.
• Gained experience in Project Delivery activities (using Waterfall methodology) including Estimation, Functional and Technical design (DUR, HLD and LLD), Test Plan Preparations, Development and Unit Testing
• Competently developed and fostered team of motivated personnel capable of supporting assigned projects through to successful completion.