SUMMARY

• Master’s degree in Computer application and Over 10 years of credible experience in Information Technology, with recent 7 years of solid experience in Data Analytics, Enterprise Analytical of business reporting/visualization tools like Power BI, Oracle Business Intelligence (OBIEE Developer), Oracle BI Publisher, Oracle Discoverer, Oracle E Business Suite R12Techno Functional, MS SQL, Oracle Apps, Excel, SQL, Microsoft Azure and SAP BW.
• Experience with Power BI Desktop files, On Premises Data gateway and Excel workbooks with data models that are created using Data Analysis Expressions (DAX) also Experience with building data visualizations and interactive reports and dashboards.
• Very good Knowledge of data extract techniques from various sources like JSON, Oracle, SAP BW, Flat file, SQL Server, XML files and have development experience in SSAS and/or SSIS
• End to end project implementation, support & Post - Implementation Support for OBIA and Up-grading OBIEE11G to OBIEE 12c; Strong experience in providing end-to-end business intelligence solutions (OBIEE/OBIA) by dimensional modeling design, building business models, configuring metadata, Answers, delivers creating reports / Dashboards, security implementation and building OBIEE Analytics Repository, Experience in Oracle BI Application configuration, upgrades. Involved in OBIEE / OBIA performance tuning
• Strong experience with Data Warehouse Development Life Cycle and performed ETL and ELT procedure to load data from different sources into data warehouse using Informatica PowerCenter.
• Worked with clients to identify and document requirements, conducted business and technical studies, design, developed, integrated and implemented information systems business solutions and capability to guide and train less experienced developers and users.
• Implantation OBIA 11.1.1.10.2 , 11.1.1.8.2 , 7.9.6.4 & 7.9.6,3 version &Implemented OBIEE Security in Object level and Data level, SSO Integration with EBS R12
• Experience with Oracle EBS R12 functional in Finance, Purchase& Procure, Order Management, Inventory& Project modules also Experience in Oracle BICS, develop reports, dashboards, data modeling load data in BISC using oracle data sync

TECHNICAL SKILLS

Analysis / Dashboard Tools: Power BI, Power Pivot, Power Query, OBIEE 11g/12c, OBIA 7.6., OBIA 11g,Microsoft BI, Informatica, ODI 11g

Reporting Tools: Oracle BI/BI Publisher, Oracle Discoverer, One Key BI, Crystal Report, Oracle report.

Application: IIS, Web logic Administrator Console, SSRS, SSIS

Cloud: Business Intelligence Cloud Service(BICS), Oracle Analytics Cloud(OAC), Power BI Cloud.

Web Service: Oracle E-Business Suite R12, Primavera EPPM P6

Database: Oracle BICS, IaaS, PaaS, Oracle 10g /11 r2/ 12c, Microsoft SQL Server, MS Access

Database Tool: Toad, SQL Developer

Web Publishing: HTML, Front Page-2000, Adobe Dream Weaver, Adobe Acrobat, XML

Operating System: Microsoft Windows 9x/2000/NT/XP/Vista/ 2003/2008/7. x, 2010, VMware

PROFESSIONAL EXPERIENCE

Confidential

Power BI Specialist

Responsibilities:

• Design and develop Power BI executive dashboard & reports from SAP BW source system and other source system like MS SQL through import and direct query method also perform different DAX calculation.
• Design, develop and maintain SSRS, Excel dashboard, Power BI dashboard/reports perform technical requirements analysis, data modeling/mapping
• Manage Power BI Gateway and refresh data source & Create, manage user privileges and security.
• Supported and maintained existing Application solutions including Integration, Testing, Migration, Deployment upgrading, security, patching, debugging and applying fixes to existing production problems ensuring reliability and that the application functions according to specifications.

Confidential

OBIEE Developer

Responsibilities:

• Developed various kinds of Executive dashboard reports in power BI Desktop and Oracle BI with Designing the Cube model, Designing of Reports, charts, Dashboards, Dimensional hierarchies to view the most granular level of information, Creation of Users and user groups assigning various privileges to view different Dashboards, Unit testing of the reports developed; Prepared User Manuals explaining how to use the reports dashboards, Fixed bugs of the module applications when necessary.
• Supported and solved day-to-day end User problems and Performed Weekly and Month end Reconciliation activities.
• Raised the Change Request for new client requirements, obtaining client approval and getting the same developed from the Technical Team.
• Carried out the testing on the UAT instance and passed on the same User Acceptance Test to the Production.
• Worked with Pre-Sales, Technical and Oracle Product Support (Metalink) team during installation and implementation process.
• Performed administrative tasks in “Weblogic Administrator Console” and “Oracle Enterprise Manager Fusion Middleware Control" console.
• Performed environment migrations between the Development, Quality Assurance, and Production environments

Confidential

Jr. Software Developer

Responsibilities:

• Actively involved in Finance processes: GL month end/quarter end, closing and reconciliation processes, fixed assets, accounts payable, purchasing to pay processes.
• Performed customization activity of Informatica 8.x/9.x, DAC 10/11g and SQL/PLSQL for ETL life cycle development.
• Designed and configured Oracle EBS General Ledger/Account Payable/Account Receivable/Order Management /Procurement/ Projects modules in BI Apps 7.9.4/7.9.5/7.9.6.
• Worked in ETL extraction from Oracle EBS 11.5.10/R12.
• Worked with Oracle Cloud of BICS reports of Financial, procurement and Spend Analysis, Supply chain Management, and projects module with detailed understanding of various business subject areas.
• Prepared MIS based reports of aging outstanding, P & L Statement, Monthly order booking, Prepayment report, GL Ledger with different layouts and view of graphs, pivot tables, charts, and tables etc.
• Organized new subject areas in the repository per business requirements
• Performed unit testing at various levels of the ETL and Debugged the sessions by utilizing the logs of the sessions.
• Developed Informatics Mapping for the different stages of ETL.
• Fixed the invalid mappings and troubleshoot the technical problems of the database and developed technical solutions to business problems in the OBIEE repository.
• Involved in the budgeting procedure used in Oracle Financials General Ledger
• Created metadata in OBIEE Repository with Admin Tool in Physical, Business, Presentation layers, implementing security.
• Designed and implemented BI Publisher, OBI Answers, OBI Dashboards and OBI Delivers, iBots, Agents.
• Prepared and setup plan of OBIEE Application Server configuration, upgrades and tuning SQL.
• Actively worked in Oracle SQL, Oracle 8i/9i/10g/11g, MS SQL Server 2000/2005/2008, Toad
• Experienced in other BI tools like Power BI, MS BI (SSIS, SSAS, SSRS), Experience in oracle BICS, Oracle Discoverer, One Key BI, create report, dashboard, data modeling load data using oracle data sync
• Worked with Business Analysts for requirement gathering, business analysis, and gap analysis as well as project coordination.