Shivani V.

CONSULTANT

513 euro
Freelancer
13 ans
London, UNITED KINGDOM

Mon expérience

Voir plus

-January 2018 - Présent

Certified as Oracle Business 12 Financial Management Specialist - Oracle Payables.
Awarded with OCA certificate.
Voir plus

HSBC UKJanuary 2018 - Présent

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
Voir plus

TrimbleSeptember 2014 - September 2017

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.
Voir plus

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 )



PUBLIC



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.
Voir plus

General ElectricDecember 2008 - November 2009

RESPONSABILITIES:



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.
Voir plus

General ElectricDecember 2007 - November 2008

RESPONSABILITIES


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.
Voir plus

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.

Mes compétences

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