EXECUTIVE SUMMARY

• Willingness to learn & work to teh best of teh capabilities by utilizing all of my noledge skills andExperience
• Had worked for prestigious clients like Confidential, Confidential, FBN ( Confidential ) and currently working for Confidential (Previously UTC) .Possess good noledge on teh functional and technical aspects of Oracle Application and Business Intelligence (both PASS and SAAS). Also Accommodated to Client location and lead teh project and provided decision making in teh implementations.
• Presently working in Snowflake/Matilllion, having 10+ years of experience in diverse Data Warehouse technologies using OBIA/OBIEE, ODI, Informatica, Oracle PL/SQL, FAW and having an overall IT experience of 10+ years. Developed and supported Extraction, Loading and Transformation process (ELT) using Oracle Data Integrator (ODI) to populate teh tables in Enterprise Data Warehouse. Experience on ODI Knowledge Modules like, LKM, IKM, JKM, and CKM.
• Completed M.S (Software Engineering) from B.me.T.S Pilani, pursuing aspiration to work as a Techno Functional role for reputed clients to solve their business problems by leveraging my technical and business noledge.

TECHNICAL SKILLS

Tools: Oracle Business Intelligence EE 12c, Oracle Business Intelligence EE 11g, Oracle Business Intelligence EE 10g (basic), Oracle Data Integrator Oracle Business Intelligence Application, Informatica, Oracle SQL Developer, Toad, Snow flake, Matillion, Fusion Analytics Warehouse

Database: Oracle 11g, Oracle 10g, Oracle 12c

Programming: Oracle SQL, PL/SQL

O/S: Windows 7, UNIX

PROFESSIONAL EXPERIENCE

Confidential

Technical Lead

Responsibilities

• For Project OAK, implementation of HR Analytics for diversified business units to various oracle PLSQL codes.
• Prepared teh data lineage documents.
• Prepare teh templates for teh technical/functional specification and test scenarios.
• Interacting wif teh project stake holders in identifying teh requirements.
• For Core Support, worked on teh enhancements and validations of teh existing HR Analytics ETL Mappings.
• Prepared teh Technical documents and gatheird teh requirements.
• Understand As - Is and provide To-Be business solutions.
• Delivery plan of all teh features.
• For Project ESP, Implemented teh ESP (Employee Scholarship Program) Module.
• Developed orchestration and transformation jobs on Matilllion for Snowflake.
• Prepared technical design, scope and configuration document deliverables.
• Conduct status meetings wif onsite and offshore throughout teh project.
• Analysing teh Technical aspects of teh objects involved Coordinating and delegating work to teh team members
• Make sure teh objects are delivered on-time

Confidential

Associate Consultant

Responsibilities

• Subject Matter Expert (SME) to provide defect analysis in identifying validity of teh defect.
• Understanding teh business requirements and technical specifications of teh client modules.
• Prepare teh templates for teh technical specification and unit cases.
• Interacting wif teh project stake holders in identifying teh requirements and estimation and plan.
• Understand As-Is and provide To-Be business solutions.
• Identify teh process gaps and provide alternatives to teh project team.
• Delivery plan of all teh features.
• Prepare technical design, scope and configuration document deliverables.
• Conduct status meetings wif onsite and offshore throughout teh project.
• Apply fixes and get sign off from end users / teams for production move of code migration, technical components / interfaces
• Analysing teh Technical aspects of teh objects involved Coordinating and delegating work to teh team members
• Make sure teh objects are delivered on-time
• Coordinating all onsite and offshore incident, service request and problem management activities

Confidential

Associate Consultant

Responsibilities

• Subject Matter Expert (SME) to provide defect analysis in identifying validity of teh defect.
• Analysis of proposed solution wif teh existing functionality to highlight any discrepancy/risk and suggesting corrective measures.
• Leading in requirement gathering and scope of existing functionality.
• Resolving teh bugs/ errors faced by teh user during their work/testing.
• Low/High level design preparation
• Involved in providing estimation to client
• Presently working on developing teh Data Model to create Report and also working on Informatica tool to perform ETL for OLTP system to OLAP system
• Presently involved in changing teh business logics involved in teh Informatica WF’s as new project.
• Trying to automate teh process which is being used by teh business regularly.
• Managing teh BI security groups.
• Working on increasing teh performance of teh report.
• Leading and Managing a team of 10 perform from offshore.
• Performance tuning of reports codes.

Confidential

SQL/PL SQL developer

Responsibilities

• Responsible for writing all teh technical queries to create or marinating teh functionality of Oracle Forms through Packages, Procedures and Functions.
• Providing all teh technical help to customer BI team to create different BI Reports
• RPD creation for Oracle Business Intelligence Reporting Tool
• Developing teh ETL mappings through Informatica and Oracle ware house Builder
• Supporting teh production issues
• Analysing teh CR and enhancement request and providing necessary inputs for implementation of same.
• Basic level Performance tuning of teh SQL Queries
• Writing teh Technical Design Document (MD070) and assists teh Functional team to write their Functional design Document (MD050)