Oracle DRM Developer
Resume:
• Presently working with GENPACT INDIA Ltd. Since Dec 15, 2005 till date, in Data warehousing track.
• As MDM/DRM Consultant, involved in creating hierarchies, properties, validation/verification, import & exports, implementing security & automation of processes.
• Have worked in Data Warehousing track as an ETL Developer for Designing, Developing, Tuning & Testing ETL processes using PL/SQL stored Procedures, Unix Shell scripting, data mapping, aggregations, transformation and validations to provide global business reporting & analysis.
---------------------------------------------
CIS DRM Integration
Client: GE
Role: MDM/DRM Developer
Team Size: 7
Description: Corporate Ledger with the vision to implement a Simplified and Lean Corporate Environment with single COA, implementing a General Ledger environment for all Ledgers, resulting in an optimized closing and reporting process. To facilitate this process a centralized master data management repository is needed. Master data will be dispersed and fed to subscribing systems as required. The project involves all GE’s reporting General Ledger’s integration with DRM. Here DRM will act as the central repository for the entire master data requirement for GE business.
Responsibilities:
1) Involved in developing the W2W master data management solution.
2) Involved in analyzing current FP&A system and process in GE corporate.
3) Involved in identifying what should be the master data and how it can be handled using DRM.
4) Designed solution for centralized repository of Finance Master Data.
5) Designing solution/architecture for the system integration
6) Designing and implementing Work flow solution.
7) Leading the implementation and working with other teams, get sign off and migrate the same to production.
The development involves following high level task:
1) Gathering requirements from the functional user.
2) Designing the solution and architecture of the environment.
3) Creating functional and technical design document for the implementation.
4) Developed Web forms & workflow process for the users to input data and route it to appropriate approval process before it gets added to DRM.
5) Created business rules as per the business logic at workflow level and restricted user to input any wrong data, which minimized use of validation at DRM end and hence improving the tool performance.
6) Full Life cycle project Implementation.
7) Creating properties, Property Category as per the requirement.
8) Creating imports for one time build in DRM. Further, Creating Heir and version
from the import file from stage Area.
9) Creating business rules using validations and verification in MDM/DRM.
10) Creating custom exports as per the requirements by different target systems.
11) Automating the whole end-to-end process by using tool internal ability.
12) Created an automated process to capture delta data (Incremental).
13) Creating standard exports and automating the process of export generation and transferring it to target systems.
14) Implementing security using tool internal ability and external authentication.
15) Creating export to Feed to GL tables (write back capability to GL)
a. Full export
b. Incremental export without creating AS of version.
c. Generation level export.
d. Export to tables.
16) Migrating the signed off segment to production using migration utility.
17) Working with web publishing.
Stage Area Build:
1) Creating tables to populate stage area table with the source data.
2) Creating procedures to generate the output files from the tables created.
3) Integrating GLS into MDM through stage area.
4) Creating FTP modules to ftp the files from stage area to MDM server
5) Developed reusable module for capturing details for Process Failure
6) Developed procedure for Emailing details of the Failed Validations in MDM for
Members from different Segments, using UTL_SMTP
Capital Solution Planning & Budgeting
Client: GE
Role: MDM & DATA Staging PL SQL Developer
Team Size: 13
Description: A project for creating planning cube in Hyperion, to help users to plan their transactions using Hyperion Planning reports. Rollout a standard planning model across all capital solutions Businesses. Replace the existing legacy systems and the Excel based planning templates with Hyperion based process. Incorporate the critical Gaps identified into HFS model and implement the enhanced excel planning model on a Hyperion platform.
Responsibilities:
1) Development & setup of Version, Hierarchies, properties, property query, Automators, import, Blend, exports, system & property categories in Hyperion MDM (Master Data Management) System 9
2) Developed Reusable Component for Metadata Processing in Staging, and developed ETL processes for GL & Sub ledger Planning Feed processing using Unix & PL/SQL Stored Procedures.
3) Documentation of System, design, Unit Test Cases, Implementation Plan, Support Plan for Staging and MDM process.
4) Fine-tuned the code for better performance, as refresh cycle time affects the Planning application users to great extent, as they are able to detect any variances, early in their planning and plan for future accordingly.
5) Created Appworx chains & Modules for MDM & Staging Process.
6) Worked with Hyperion team in reconciliation of the balances and closing out of the variances.
7) Handled Go Live activities like setup of prod environment, Migration of MDM & Oracle database objects.
TLM Reporting & Archiving
Client: GE
Role: ETL - PL SQL Developer
Team Size: 5
Description: A project for providing data for reconciliation to TLM tool. Data is fetched from source GL (General Ledger) into Staging and processed (cleaned & Aggregated). From staging, Business Object pulls data to provide reports available for reconciliation.
It is continuous process running round the clock, data is fetched from the source GL incrementally & updated, without truncating the existing data, to keep the data available for reporting all the time.
Responsibilities:
1) Design, Development & setup of ETL Staging Area.
2) Developed Reusable Component for Error Logging, Sending email communication using Oracle UTL_SMTP Package, Maintaining processes logs.
3) Implemented Triggers & Merge Statements for handling data load incrementally without truncating existing data.
4) Created Jobs & schedules using Oracle DBMS_SCHEDULER Package, to automate the process.
5) Documentation of design, Unit Test Cases, SIT Cases, Implementation Plan, Support Plan for Staging.
6) Developed process for Purging Old Data depending on the period specified.
7) Handled Go Live activities like setup of prod environment, Migration of database objects and setting up UTL_SMTP & DBMS_SCHEDULER Packages.
Capital Solution Integration
Client: GE
Role: DATA Staging PL SQL Developer
Team Size: 10
Description: A project for combining four GE existing businesses (CEF, EEF, FLEET, FX EEF) and making a common staging area for all four businesses. This staging area takes Metadata input files from HMA and Actual data from Materialized Views, do the extraction, transformation/loading, and generates the output files which are then sent and loaded into Essbase and then to Hyper roll.
Responsibilities:
1) Worked in different stages of software development lifecycle, which includes DLD, Coding (Stored Procedures, Shell Scripting), Unit Testing, Implementation and Support.
2) Documentation for Unit Test Cases, Implementation Plan, Support Plan.
3) Migration & Maintenance of database & Appworx Chains in three copies of Database and Unix environment (DEV, QA, Prod).
4) Leading all the Enhancement work that is coming in the project.
5) Fine-tuning & fixing issues in code for performance improvement.
6) Handling operations during Quarter Close & Year End.
7) Automation of validation process for Metadata & GL Data.
GECAS (GE Capital Aviation Services)
Client: GE
Role: DATA Staging PL SQL Developer
Team Size: 10
Description: A project for processing Metadata and General Ledger data in the form of flat files (.hir files) and Materialized views respectively as input from GECAS. Staging covers ETL processes like extraction, transformation/loading, and generates the output files which are then sent and loaded into Essbase and then to Hyper roll.
Responsibilities:
1) Worked in different stages of software development lifecycle, which includes DLD, Coding (Stored Procedures, Shell Scripting), Unit Testing, Implementation and Support.
2) Documentation for Unit Test Cases, Implementation Plan, Support Plan.
3) Migration of database & set up three copies of Database and Unix environment (DEV, QA, Prod).
4) Creation/configuration of Appworx Chains.
Contact this candidate