RESPONSIBILITIES As a Technical Developer I am Responsible for Development of packages, Interfaces, Reports using OBIEE Design, develop and testing of all data transformation and migration activities Develop the code and automate the code as per QA process designed for the data transfer from the source to target system Develop and implement unit test cases aligned as per the test plan.
Perform data migration load (for FA/GL/Procurement modules) using ETL processes (PLSQL).
As a Business analyst
I am Involved in requirements gathering, analysis, development, QA and UAT support. Support requirement analysis and documentation of data migration strategy and conversion specification Liaise with source system SME’s/developers to agree on the extract design ,analyse the data sources,data integrity and business rules Assign the development of MC050 Document including setting up the environment to facilitate the Data Migration Activities. Run Create Accounting, post the journals, Reconcile the same in GL Module Responsible for performing FA activities like Mass additions, Mass Retirements, Mass Transfers, Depreciation Run,Asset Adjustments etc, Also responsible for period closure activities. Creation of Manual journals to help reconcile the source system Reconciliation and resolution of any reconciliation issues (Dev, SIT, E2E, DR1, DR2 and Live) Produce reconciliation outputs during E2E Testing, Dress Rehearsals and Cutove
I have worked extensively on Interfaces, Reports, Year End Reports, Data Migration and forms during my entire tenure in Trimble. I have worked for some prestigious Clients like Brighton and Hove,Department of Education and Training (Australia), Enfield, East Sussex, Environment Agency,Southwest One, Voyage Care,National Express, Watford. As a Technical Developer I am
PUBLIC Involved in requirements gathering, analysis, development, QA and UAT support
Created and customized reports using XML Publisher, Discoverer Reports, Oracle Reports 10 g, SAP Crystal Reports and Advanced Reports
Development of packages, Interfaces, Forms, Oracle Reports, Work Flow, Worked for Data Migration Project to validate the Data and moving the data across all instances. Building the solution, including setting up the functional environment as per the requirement.
Development of Functional Specification Document based on the BRD.
Developed Year End Reports using oracle reports 11g tool. I am also responsible for Unit testing and Functional Testing of the solution developed.
Also, worked on implementation of various triggers and worked on emailing functionality within core oracle.
Performed Functional Testing, Regression Testing of the technical components developed.
Customized workflows namely PO approval process , Order/Line flow to send user notifications based on business requirement.
Worked on development of interfaces using XML-DOM package to produce the output in XML tags.
Worked on development of Oracle Parameter forms to invoke reports in 10g environment.
Data loading using external tables.
Worked on Oracle Map Builder to create styles and customized themes.
Worked on geoserver to import the layers, publish the layers, and create the style for wfs, wms, themes.
Balfour Beatty UK Construction CompanyFebruary 2009 - August 2013
As a Developer I was : Responsible development of new applications, reviewing the team`s work, assisting the team.
Worked on development of Format Triggers, Formula Columns, and Summary Columns in Oracle Reports.
Wordked on development of stored procedures, packages functions & triggers using PL/SQL, also have worked on Inbound and Outbound Interfaces.
Involved in unit testing the components that were developed. Effort Estimation, Analysis, coding and testing of the enhancements to be done in various applications. Involved in developing Technical Design Documents, Functional Design Documents, Business Requirement documents.
Extensively worked on XML Reports developement and Option Reports, Business Objects 11g.
I have worked on AR, AP, FA, modules in 11i and R12 where I was involved in development of Interfaces, XML reports, forms, DFFS. Also was involved in the functional testing, functional set up of the project.
Worked with Discovered so users would have the ability to generate ad-hoc reports.
As an HR/Payroll consultant I was responsible for
Performing the Data migration activities of Core HR/Payroll through Open Interfaces (like personal, assignement, job, position, grade, qualifications, phones, SIT`s, initial balance, bank details, element entry, pay proposals etc )
Maintenance of Employee Information through Oracle Apps including Personal Details, Educational Qualifications, Skill Profile, Work Experience and Joining Data.
Setup all organizations, locations, elements, element links, costing, job titles, payrolls, bank details, cost centers, worker`s compensation codes / rates, Global Values, Application Utility Lookups, Security Profiles and reports within the Oracle HRMS module for all applicable localizations, Setup HR related Descriptive Fles Fields, Validation Sets, Special Information Types, Security Profile attachements, users, responsabilities, request sets and menus under the System Administrator responsability.
Participating in detailed Payroll requirement information gathering needed for Reports Customization, setting up Hiring Applicants and Terminating employees.
Development of Inbound, Outbound Interfaces, also enabled certain functionality from front end using DFFS.
Designed and Developed custom application using Oracle Application Express (APEX) Extensively involved in setting up Date tracking modes and termination process. Working on Transferring Timecards to BEE. Schedule and execute the design, implementation and unit test of new development, enhancements, bug fixes and production updates Development and configuration several Fast formulas in Oracle Payroll
Creation Alerts to send emails to employees on new hired, enrolment or termination of benefits, open enrolment, timesheet entry issues and year-end processing notices.
Unit testing, System Testing and in phase of UAT across multiple enviroments.
Interaction with users to resolve any issues during the production, development and enhancement phases in both Technical and Functional aspects.
As an Apps Technical Support Lead I was
Responsible to assess the team activities. Interact with the users to understand the bugs and fix them accordingly.
Keep a Track on the incidents logged using Service Now Tool
Experience includes application system administration activities such as user setup, defining responsabilities, value sets, flex fields, data groups and request groups, registering applications, menus, forms reports, concurrent programs, providing support to apps users for any technical and functional issues.
Maintain SLA`s of the incidents raised, prioritize and resolve them accordingly.
Updating the Functional and technical documents. To send notifications to users by using oracle work flow builder.
Customized Workflows as per the client requirements. Performing the patch analysis and maintain the Impact analysis documents. Support the existing customizations in the system.
As a team member, I was responible for Supporting Application and development of new applications. Created SQL scripts to load the custom data into Development, Test and production Instances using SQL Loader. Created scripts to created custom Tables and Views.
Created and customized reports using XML Publisher in OM, AR, AP and INV.
Developed PL/SQL PAckages, Procedures, Functions for validating the invoices and payment information from the legacy system and imported into Oracle Applications using the Payables Open Interface Import program and populated the base tables, which involved in Releasing Invoices from Hold, Approval of Invoices and creating of New Invoices. Interacting with the end- user and the client`s point of contact to gather requirements and clarifications for the issues assigned.
Involved in Custom.pll and Form personalization. Tuned the reports to improve performance. Developed the report and Forms as per the current requirement by using reports6i and Forms6i. Uploaded all the concurrent program details into another instance by using FNDLOAD commands. Validated test scenarios and test cases to ensure that the delivered unit is valid after incorporating the changes.
Interacting with Functional Team to understand the Business Process. Developed item conversion to load data about the items from legacy system into oracle applications by writing SQL loader scripts and PL/SQL scripts.
Developed Payables open interface import to load the data to the base tables
Involved in optimizing the performance of database objects Designed Technical specs in MD 70 using Standards AIM Developed custom reports such as AP summary report, Invoice Distribution Report. Developed custom Interface Program to load on-hand inventory transactions from external flat files into interface tables. Imported the customers into Oracle Receivables using the Customer Import Program with in Oracle applications. Used SQL Loader to load the data from flat file into staging tables, finally into Customer Interface Tables, and then into Base Tables.
Australian Banking CorporationMay 2008 - November 2008
As an ETL developer I was responsible for
Requirements Analysis. Loaded data from Operation Data Store (ODS) to data warehouse tables by using and executing foreign key validation programs to validatae wherever star schema have been identified, with fact tables and dimension/ lookup tables. Worked extensively with mappings using expressions, aggregators, filters, lookup and procedures to develop and feed data mart.
Analyzed and developed scripts depending on the amount of work done on the daily basis to enchance the performance of Informatica.
Extensively used standard Oracle API`s and Open Interface Tables (OIT`s) used for loading data.
Taking the backup of repository on regular intervals depending on the amount of work done. Giving report on completion of each phases.
Documentation and Testing of each phase.
XML, Workflow Builder, WinSCP, UNIX, Unit testing, Transact-SQL, TOAD, Test Planning, Test Cases, Technical Design, System testing, System administration, Stored Procedure, SQL Developer, SQL, Shell Scripting, SAP, Requirements Analysis, Regression testing, Quality Assurance, Problem Solving, PL/SQL, Oracle PL/SQL, Oracle Jdeveloper, Oracle Forms, Oracle Financials, Oracle Developer 2000, Oracle Applications, Oracle Application Server, Oracle 9i, Oracle 11i, Oracle 11g, Oracle 10g, Oracle, Microsoft SQL Server, Jira, Java, Interpersonal skills, Fusion, Functional testing, Forms, ETL, Debugging, Data Warehousing, Data Migration, Code Review, Business Objects, API, Analysis
Vous avez besoin de ce profil dans un mois?Contactez-nous!
Vous allez être redirigé sur SkillValue
Talent sourcing specialist de la plateforme Pentalog, SkillValue s’appuie sur un pool de +400 000 Experts Tech & Marketing, dont +15 000 freelancers. Évaluations de compétences, missions, offres d’emploi : les consultants SkillValue vous aident à accélérer votre carrière.
Restez informé de l'actualité tech avec la newsletter Pentalog
À propos de Pentalog
Pentalog est une plateforme de services IT qui accompagne les entreprises dans leur production digitale et leur transformation en fournissant des ingénieurs et développeurs de classe mondiale. Ses 16 Delivery Centers et Agences dans le monde comptent plus de 1600 ingénieurs, développeurs, product designers et spécialistes marketing.