SUMMARY

• Having 9+ years of Strong experience in Complete Software Development Life Cycle (SDLC) which includes Business requirements gathering, system analysis & design, development, testing and implementation of Packaged (OBIA) and custom Data warehouse solutions.
• Expertise in implementing Oracle BI Apps796X and OBIA 11.1.1.X versions like Configurations in BIACM, implementing Out of Box prebuilt mappings, Designing ETL (INFORMATICA AND ODI), scheduling jobs using DAC / $Universe, Creating Oracle provided Data Warehouse, OBIEE RPD development, OBIEE reports and Dashboards, Upgrading the versions and implementing security.
• Expertise in complete lifecycle Implementation of Business Intelligence with Star, Snow Flake Schema & Hybrid schemas.
• Closely works with business stake holders in preparation of Functional Design and Technical design documents.
• Very strong experience in preparing the fit - gap analysis by analyzing the customer requirements.
• Implemented various BIAPPS modules as Financials, Procurement & Spend, SCOM, Projects, HR Analytics, Manufacturing and EAM Analytics.
• Strong knowledge on the Metadata repositories of OBIA, ODI, Informatica and DAC to fix any kind of issues or gaps with BIACM, FSM, ODI and Informatica & DAC.
• Expertise in converting the code from SSIS to Informatica, ODI and Snaplogic and vice versa.
• Very strong experience in handling structured and unstructured data in ETL layer using snaplogic, ODI & Informatica and reporting layer using Qlikview, Tableau, OBIEE Repository and Power BI.
• Good working knowledge on Snowflake, Stream sets, AWS and Azure DevOps.
• Expertise in tuning the ETL layers to optimize the run time by providing the hints, tuning the sql’s for long running objects.
• Created data queries and reports using OBIEE, Qlikview, SSRS and Power BI. Created custom queries/reports designed for quality verification and information sharing.
• Implemented VPD at DB level to restrict the unauthorized access to the key metrics like rate, amount etc.
• Implemented materialized views, packages, partitions, procedures, refresh groups to handle the aggregates.
• Involved in monitoring the loads/replication lags and coordinating with system’s team for any performance issues with environment.
• Involved in end-end testing (Unit testing, System testing and Business Users Acceptance testing); have customer face time to hand over reports to enable the users with the know-how on the reports
• Conducted Trainings to Train the Trainer (to train business users on UI) on Architecture, Answers and Reports
• Working experience on Big Data technologies like Hive, Scala and Spark.
• Implemented B2B mappings using Confidential A.I Work bench, Trade Guide, AI Server and Converge 5.2.
• Worked on various EDI standards like ANSI X12, EDIFACT.
• Have working knowledge on AI Converge, which is optional feature that can be installed on top of AI Workbench, primarily to be used for creating mapping specifications, which in turn can be used to create executable AI maps. Worked on 810, 835, 837, 850, 856, 860, 867, 865 documents for ANSI X12 and UN/EDIFACT standards.
• Working knowledge of source code and configuration management solutions (SVN, Git, etc.)

TECHNICAL SKILLS

Oracle Applications: Informatica 9.x, ODI 10g, 11g & 12c, Oracle Business Intelligence (OBIEE) 10g, 11g & 12c,Oracle Business Intelligence Publisher 10g, 11g & 12c, Oracle Business Intelligence Applications (OBIA) 7.9.6.3 (Extension Pack) /4, OBIA 11.1.1.1.7/8/9/10

Developer Tools: BI Publisher Desktop plug-in, INFORMATICA Power Center, ODI 11g/12c, Qlikview, XML/BI Publisher, TOAD 9.5, SQL Developer, SQL*Plus, Putty, Tableau

ETL tools: Snaplogic, Streamsets

Cloud technologies: AWS, Azure Devops, Snowflake

EDI Tools: Confidential AI 5.2

EDI Standards: X12, EDIFACT

ANSI X12 Transactions: 810, 835, 837, 850, 856, 857, 865, 867

Operating Systems: Windows NT/XP/7/10, UNIX, Red hat & Oracle Enterprise Linux (OEL)

Big Data Technologies: Kafka, Hive

Languages: SQL, PL/SQL, C

RDBMS: Oracle 12c, 11.2.0.1, 11.2.0.3/4/10 g/9i

Migration Tools: Winscp, Putty

Scheduling tools: DAC 10g, 11g and Dollar Universe.

PROFESSIONAL EXPERIENCE

Confidential, KY

Technical Lead Developer

Responsibilities:

• Involved in meetings with key system owners to understand current data and systems environment.
• Responsible in analysis, requirements gathering, functional/technical specifications, development, deploying and testing.
• Responsible for the gap analysis on the requirements and correct them with the help of stake holders.
• Responsible for defining & designing the framework to optimize the ETL development effort.
• Designed and developed a framework for snaplogic tool to overcome the limitation of restarting the failed pipelines.
• Performs code / design reviews and leads and mentoring the technical team during design, development and testing.
• Developed various complex ETL mappings using different tools like Snaplogic, ODI 11g, ODI 12c, Informatica 9.x, 10.x for extracting the data from sources like Rest API’s, Oracle, Sql server, my sql etc.
• Customized the Knowledge Modules in ODI for different complex scenarios, like improving the overall run time, dropping & recreating Query indexes before and after the ETL process.
• Created complex Mappings and implemented Slowly Changing Dimensions Type 1, Type2 for data loads.
• Developed complex routines and Sql’s to convert the unstructured, Hierarchical data from rest API’s to enterprise standards.
• Implemented VPD @ DB level to restrict / hide the rates, amounts and other sensitive data to the contractors, associates and vendors.
• Developed management dashboard in Qlikview to look into the present the qTest data metrics to the customer.
• Involved performance tuning activities at DB and API consumption.
• Created Load plans in $ Universe for Scheduling loads.
• Prepared reusable scripts and integrated with OEM suite to automate the process.
• Shares the status report weekly and monthly reports with the stake holders.

Environment: Informatica Power Center 10.x, Snaplogic, ODI 11g, ODI 12c, Oracle 12c, SSMS, My Sql, TOAD, $Universe, UNIX, Putty, Winscp.

Confidential, KY

Technical Lead Developer

Responsibilities:

• Installation and configuration of OBIAI 11.1.1.8.1 and OBIA 11.1.1.10.2 which includes installation of ODI server, Database Server, OBIEE Server, WebLogic server (Installation and Upgrading) in Linux Platform Using Putty, VNC Server and WinSCP tools. Configured the respective clients in Windows Platform.
• Configuration of OBIA in FSM and in BIACM for the modules like Financials, Projects, Procurement & Spend, Supply chain & order management and Services module.
• Involved in analysis, requirements gathering, functional/technical specifications, development, deploying and testing.
• Did a fit gap on the customer requirements and extended/customized the OOTB mappings.
• Analyze the gaps between 7964 version and OBIA 11.1.1.8.1 and make necessary changes to the existing ETL mappings. Migration of mappings from OBIA 11.1.1.8.1 to OBIA 11.1.1.10.2 instance.
• Working on the ELT, KM, user defined function customizations and creation using ODI 11g.
• Scheduling the full & incremental loads for all the modules and fixing the data load issues.
• Tune the ELT queries and apply the hints to the improve the performance of the ETL queries.
• Tune the DB parameters to handle huge data loads also creation and allocation of table spaces.
• Working with SR’s to oracle on the product Bugs and applied the patches to DB, ODI, OBIA and OBIEE etc.
• Handling the activities like Monitoring & updating the Table spaces if needed, tuning the DB parameters to avoid the load failures. Updated the memory allocations, Connection pool for each managed server in WebLogic to avoid GC overhead limit issue during the load.
• Automated the jobs through scheduling using BIACM, which runs as per the client specified schedule.
• Created Load plans using the Load plan generator plug-in Scheduling loads using BIACM.
• Generated documents for Data Validations and Installation and configuration.
• Data Validation has been done for various sources to target mappings. (EBS & Flat files)

Environment: Informatica Power Center 9.x, ODI 11g, BIACM, FSM, OBIA 11g, DAC 10g, OBIEE 11g, Oracle 12c, TOAD, UNIX, Putty, Winscp.

Confidential, KY

Senior Developer

Responsibilities:

• Involved in meetings with key system owners to understand current data and systems environment.
• Responsible in analysis, requirements gathering, functional/technical specifications, development, deploying and testing.
• Responsible for the gap analysis on the requirements and correct them with the help of stake holders.
• Responsible for defining & designing the framework to optimize the ETL development effort.
• Designed and developed a framework for ODI tool to reduce the repetitive tasks.
• Performs code / design reviews and leads and mentoring the technical team during design, development and testing.
• Developed various complex ETL mappings using different tools like ODI 11g for extracting the data from ERP sources.
• Customized the Knowledge Modules in ODI for different complex scenarios, like improving the overall run time, dropping & recreating Query indexes before and after the ETL process.
• Created complex Mappings and implemented Slowly Changing Dimensions Type 1, Type2 for data loads.
• Developed complex routines and Sql’s to convert the Hierarchical data from raw tables and massaged as per the enterprise standards.
• Implemented VPD @ DB level to restrict / hide the rates, amounts and other sensitive data to the contractors, associates and vendors.
• Created FTP mechanism to send the latest extracts to the end users on a daily basis.
• Involved performance tuning activities at DB.
• Created Load plans in ODI and event bases triggering loads.
• Prepared reusable scripts and integrated with OEM suite to automate the process.
• Shares the status report weekly and monthly reports with the stake holders.

Environment: ODI 11g, Oracle 12c, TOAD, Sql developer, UNIX, Putty, Winscp.

Confidential

Senior Developer BIP

Responsibilities:

• Responsible for doing the fit gap analysis and prioritize the reports based on customer needs.
• Responsible for developing the Functional design documents and Technical design docs.
• Responsible for building the new reports and extending the existing reports using Oracle BI Publisher
• Responsible for handling the migration of objects from lower instances to the higher instances.
• Get the development and unit testing done from team, review them.
• Plan for documentation of Technical Design Documents, Unit Testing.
• Plan for SIT scripting and execution for each of 10 reports.
• Deliver code for UAT and support by resolving any defects reported.

Environment: BI Publisher, Oracle 12c, TOAD, Sql developer, UNIX, Winscp.

Confidential

Senior Developer

Responsibilities:

• Installation and configuration of OBIAI 11.1.1.7.1 which includes installation of ODI server, Database Server, OBIEE Server, WebLogic server (Installation and Upgrading) in Linux Platform Using Putty, VNC Server and WinSCP tools. Configured the respective clients in Windows Platform.
• Configuration of OBIA in FSM and in BIACM for the modules like Financials, Projects, Procurement & Spend, Supply chain & order management and Services module.
• Involved in analysis, requirements gathering, functional/technical specifications, development, deploying and testing.
• Did a fit gap on the customer requirements and extended/customized the OOTB mappings.
• Working on the ELT customizations using ODI.
• Scheduling the full & incremental loads for all the modules and fixing the data load issues.
• Working with SR’s to oracle on the product Bugs and applied the patches to DB, ODI, OBIA and OBIEE etc.
• Handling the activities like Monitoring & updating the Table spaces if needed, tuning the DB parameters to avoid the load failures. Updated the memory allocations, Connection pool for each managed server in WebLogic to avoid GC overhead limit issue during the load.
• Automated the jobs through scheduling using BIACM, which runs as per the client specified schedule.
• Created Load plans using the Load plan generator plug-in Scheduling loads using BIACM.
• Generated documents for Data Validations and Installation and configuration.
• Data Validation has been done for various sources to target mappings. (EBS & Flat files)

Environment: ODI 11g, OBIA 11g, BIACM, FSM, OBIEE 11g, Unix, Oracle 11g, Winscp, Putty, Toad

Confidential

Senior Software engineer

Responsibilities:

• Interacted with Business Users to understand the Business requirements and prepared technical documents for implementing the solutions as per Business needs.
• Involved in analysis, requirements gathering, functional/technical specifications, development, deploying and testing.
• Extensively used OBIEE Admin tool to import the required objects (Dimensions and Facts) with integrity constraints into Physical Layer using connection pool.
• Developed multiple Dimensions and Logical and Facts / Measures objects in Business Model Layer, and has successfully created the Presentation catalogs in Presentation Layer.
• Developed and implemented the coding of Informatica Mapping for the different stages of ETL (SDE/SIL/PLP).
• Fixed the invalid mappings and troubleshoot the technical problems of the database.
• Debug the sessions by utilizing the logs of the sessions.
• Involved in developing the Incremental ETL process by Informatica Mappings and Mapplets using various Transformations.
• Used Informatica workflow manager and work flow monitor to schedule and monitor sessions.
• Imported Sources and Targets Databases, Created Mappings and developed Transformations using Informatica Power Center.
• Extensively used Transformations like Source Qualifier, Lookup, Expression, Router, Aggregator, Joiner and Sequence generator.
• Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.
• Adding new tasks, subject areas and execution plans in DAC.
• Conducted meetings with Onsite coordinators, Business Users during testing and deployment stage of the application development lifecycle.

Environment: Informatica 9.x, OBIA 7.9.6.4, DAC 10g, OBIEE 11g, Unix, Oracle 11g, Winscp, Putty, Toad

Confidential

Senior Software engineer

Responsibilities:

• Actively involved with Business team to gather user requirements. Developed proof of concept to check the functional feasibility of the project.
• Designed Low level Technical Design Documents for FACTS and Dimensions in MFG Process, Process Quality and EAM modules.
• Developed mappings for EAM, Process Quality & Process Manufacturing modules and Upgrade mappings ( 11.1.1.7.1 to 11.1.1.8.1 ) in ODI.
• Deploy the builds on a daily basis and connect with the PM teams on the daily release status.
• Performed EBS transactions to understand the business and to provide the error free code.
• Rectified and closed the Bugs which are coming from Prior versions of BI Apps.
• Created test scripts, did data validation and resolved the issues in Mappings.
• Created Load Plans Using Load Plan Generator, and scheduled the EAT Runs for Individual Subject Areas.
• Did a Performance tuning to increase the through put for both mapping level and SQL Queries Optimization as well.

Environment: Informatica 9.x, OBIA 7.9.6.4, OBIA 11g, ODI 11g, DAC 10g, OBIEE 11g, Unix, Oracle 11g, Winscp, Putty, Toad

Confidential

Senior Software engineer

Responsibilities:

• Installation and configuration of Informatica Server, DAC Server and Database Server in Unix Platform Using Putty and WinSCP tools. Configured the respective clients in Windows Platform.
• Extracted data from EBS source systems applied business logic using several transformations and loaded them into Oracle Warehouse database.
• All the jobs are integrated using complex Mappings including Mapplets and Workflows using Informatica power center designer and workflow manager.
• Experienced on Performance tuning to increase the through put for both mapping and session level and SQL Queries Optimization as well.
• Automated the jobs through scheduling using Data Warehouse Administration Console scheduler, which runs as per the client maintaining the data validations.
• Created ‘Tasks’, Assembling ‘Subject Areas’ and Building the ‘Execution Plans’ and Scheduling loads using DAC scheduler tool.
• Generated documents for Data Validations and Installation and configuration.
• Prepared ER Diagram and Architecture Diagrams.
• Data Validation has been done for various sources to target mappings.

Environment: Informatica 9.x, OBIA 7.9.6.3 + Extension pack, DAC 10g, OBIEE 11g, Unix, Oracle 11g, Winscp, Putty, Toad

Confidential

Software Engineer

Responsibilities:

• Analyzed the client requirements and build the specification using AI Converge
• Developed the maps based on the specifications generated through AI Converge
• Follow best practices in the form of coding while developing the map as well as while generating the specification
• Development of map packages included vast variety, such as
• EDI-IDOC, IDOC-EDI, IDOC-IDOC, XSL mapping and Pass thru maps
• Identified and built solutions for complex issues such as generating multiple transactions sets (UNH-UNT pairs) in an outbound map.
• Involved in interaction with Client during Design, Development, Unit testing, and Integration.
• Performing unit testing of the map packages in the local system.
• Performing functional testing in the QAS environment (UNIX).
• Create Unit test cases and integration system test cases and execute the same.
• Create Trading Partner profiles using Trade Guide in QAS environment.

Environment: Integration Project, Confidential AI workbench 5.2, Trade guide, AI converge.