Oracle Technil Manager / Project Coordinator Resume
CA
SUMMARY:
- Overall 17 years of industry experience across different domains (Retail, Pharmaceutical, Product & Customer) and applications
- Around 10 years of experience in Master Data Management, Design/Development of Enterprise Application Integration Systems and Service Oriented Applications.
- Extensive experience in Requirement Analysis, Client Interfacing & Co - ordination and Technical Solution
- In-depth Knowledge and Understanding of the TIBCO Product Suite.
- Detailed understanding of Messaging Concepts, Service Oriented Architecture (SOA), Object Oriented Concepts and Client/Server Concepts.
- TIBCO MDM Integration experience with multiple heterogeneous systems - SAP ECC, SAP BI, Legacy JDE systems, Oracle Enterprise Data warehouse, Informatica, TIBCO Business Works, TIBCO Smart Mapper
- Proficient in TIBCO MDM upgrades and re-hosting to Cloud platform
- Solid knowledge on AWS Cloud Computing
- Strong analytical and problem solving skills with excellent written and verbal communication skills
TECHNICAL SKILLS:
TIBCO Products: TIBCO MDM 9.x, TIBCO MDM 8.x, TIBCO BusinessWorks 5.x, TIBCO Administrator 5.x, TIBCO Enterprise Message Service, TIBCO Business Events 4.x, TIBCO Spotfire, TIBCO MFT
Web/App Servers: Tomcat, Jboss, Oracle Application Server, Weblogic Server
Databases: ORACLE RDBMS, MS SQL SERVER, MS ACCESS, POSTGRESQL
Technologies: Amazon Web Services Cloud Computing, TOAD, JAVA, CSS, HTML, ANT scripting, SQL, Web-Services, XML Technologies - XSLT, XPATH, JavaScript,JQuery
Operating Systems: Windows, Solaris, Linux
PROFESSIONAL EXPERIENCE:
Confidential, CA
Responsibilities:
- TIBCO MDM, Active spaces and TIBCO Patterns installation and configuration for 17 million customer records deduplication
- Designed and developed the initial and real time customer data deduplication inbound processes
- Designed and developed the initial and real time customer data deduplication outbound processes
- Designed and developed web services calls for real time inbound events using MDM Plugin for BW6
- Defined governance structure and processes to make updates to the customer data dictionary
- Documentation and knowledge transfer to the client
- Performance tuning of the application to match the SLA
Technologies: TIBCO MDM, TIBCO BW6, Java, XML, TIBCO EMS, Oracle 12g R2, TIBCO Patterns, TIBCO Clarity
Confidential, TX
Responsibilities:
- TIBCO MDM installation, configurations and upgrades
- Designed the Migration Strategy for full data set including versioning and history
- Designed the Cloud Re hosting Strategy
- Analyze and refactor on premise vs cloud specific configurations and functionalities
- Knowledge transfer to the client on followed strategies
Technologies: TIBCO MDM, TIBCO BW, Java, XML, TIBCO EMS, Oracle 11g R2
Confidential, PA
Responsibilities:
- TIBCO MDM installation and configurations and upgrade
- Designed the MDM solution and implemented
- Designed and developed complex MDM custom UIs to integrate with external applications
- Designed and developed SOAP & REST MDM web services calls
- Knowledge transfer to the client to take over the project
- Complex workflows to handle the different approval layers requiring manual and bulk approvals
Technologies: TIBCO MDM, TIBCO BW, BW Plugin for MDM, Java, XML, TIBCO EMS, Oracle 11g R2
Confidential, GA
Responsibilities:
- TIBCO MDM installation and configurations
- Design TIBCO MDM high level data publication strategy
- Designed and developed MDM integration interface
- Designed and developed MDM Product data model
- Workflow customizations to support ABB product introduction process
- Custom java code to generate Parts dynamically during Product introduction
- Designed and developed POC on customer data with match and merge functionalities
Technologies: TIBCO MDM, TIBCO BW, Java, XML, TIBCO EMS, SQL Server 2010
Confidential, GA
Responsibilities:
- TIBCO BW integration with Confidential MAIN system
- Designed and developed the BW integration interface
- CLE implementation for efficient exception handling
- TIBCO Applications deployment and unit testing
- Delivered TIBCO recommendations on volume testing and performance tuning
Technologies: TIBCO BW, TIBCO BW copybook Plugin, XML, TIBCO EMS
Confidential, VA
Responsibilities:
- TIBCO BW integration using SOAP over HTTP and XML over HTTP
- Designed and developed eight K2MP integration interfaces
- CLE implementation for efficient exception handling
- Perform TIBCO Applications deployment using deployment framework
- Perform QA activities and support defect resolution
Technologies: TIBCO BW, Java, XML, TIBCO EMS, cheetahMail, Oracle 10g
Confidential, GA
Responsibilities:
- HCM module development for real time integration of “hire to retire events” from PeopleSoft to Global and regional ERP HCM systems
- TIBCO BW integration using PeopleSoft and SAP R3 adapters
- Designed and developed UI to support reprocessing of real time events from PeopleSoft to SAP HCM on demand basis
- CLE implementation for efficient exception handling
- PGE and GPG encryption and decryption usage for data sensitive interfaces
- MFT configuration to integrate with external partners eg. GSX
- Perform QA activities and support defect resolution
Technologies: TIBCO BW, Java, XML, TIBCO EMS, Oracle 10g, MFT, PeopleSoft Application, SAP HCM, Smart Mapper
Confidential, MD
Responsibilities:
- Analyzed the existing CLE implementation options
- Upgraded form CLE 2007 to CLE 2012
- Implemented 2012 CLE implementation with TIBCO best practices and standards
- CLE customization to cater Confidential specific requirements
- Designed and develop a custom BW project to extract key values from the transaction data captured in CLE
Technologies: TIBCO BW, Java, XML, TIBCO EMS, Oracle 10g
Confidential, VA
Responsibilities:
- Translate business requirements into technical specifications for offshore team
- Facilitate and Coordinate technical communication between offshore and onsite team for timely deliverables
- Code review on BW Wrapper services and suggest best practices for performance and tuning
- Perform QA activities and support defect resolution
- Deployment of MDM UI and BW components into QA environment
- Design and develop BW process to generate Excel report from MDM data
Technologies: TIBCO CIM, TIBCO BW, Java, XML, TIBCO EMS, JBOSS, Oracle 10g, Edit Plus, JQuery, TIBCO MDM Studio
Confidential, TX
Responsibilities:
- Translate business requirements into technical specifications
- Design and develop Item master data, Organization Hierarchy data model definitions and cross s
- Design and develop complex catalog validation rules
- Design and develop complex workflows
- Customize workflows for data transformation and ESB publication
- Support custom UI to MD integration web service calls using TIBCO BW
- Design and develop BW process to load initial person data into MDM
- Design and develop the initial data load process from legacy systems into MDM
Technologies: TIBCO CIM, TIBCO BW, Java, XML, TIBCO EMS, JBOSS, Oracle 10g, Edit Plus, JQuery, TIBCO MDM Studio
Confidential, GA
Responsibilities:
- Translate business requirements into technical specifications
- Design and develop BW to consume and persist the data from the queue to SQL database
- Design and develop BE translation rule to compute the metrics and then display the updated metrics data in the charts based on application, device or associate
- Unit tested and deployed the BW and BE projects into Confidential DEV environment
- Demonstrated the POC project to Confidential executive team
Technologies: TIBCO BW, TIBCO BE, TIBCO EMS, SQL Server Database
Confidential, OH
Responsibilities:
- Participate in business requirements meeting with business users and transform into technical specifications
- Develop design guidelines standards; support in the development of testing strategy
- Design the TIBCO CIM repository model using TIBCO Business Studio
- Design GDSN choreography for supporting demand side (retailer) 1SYNC messages
- Design MDM workflows for new item introduction, item modification and item discontinue process from 1 sync
- Design the initial data load process from GDSN and legacy MDM systems
- Design CIM administration processes and MDM reporting requirements
- Define TIBCO CIM environment usage strategy to support parallel release activities
- Define the software configuration management, deployment and release notes documentations
Technologies: TIBCO CIM, Java, XML, TIBCO EMS, Web sphere MQ, Oracle 10g, Edit Plus
Confidential, NJ
Responsibilities:
- Participate in business requirements meeting with business users and transform into technical specifications
- Install and configure new CIM development servers to support concurrent releases and projects
- Design and develop Installation Qualifier/Operations Qualifier and Software configuration management plan
- Design and implement master/ data solution using CIM
- Customize CIM core features including business domains template, business process rules, workflows, rule bases, delegation profiles and CIM application roles
- Redefine/customize the workflows as per the business requirement
- Develop complex rulebase for data validation to cleanse and validate the data
- Develop custom java function to achieve complex validation requirements
- Configure FileWatcher to automate the data loads and data publish options
- Designed/Developed TIBOC BW processes, PL/SQL procedures and triggers to automate CIM processes and to resolve known TIBCO CIM issues
- Tuned the application to improve the load performance
- Instrumental in turning the Pilot program (COMET R1.0) into a fully designed service
- Performed the pilot CIM upgrade project (6.1.3 to 7.0 & 6.1.3 to 8.0.1)
Technologies: TIBCO CIM, TIBCO BW, Java, XML, TIBCO EMS, JBOSS, Oracle 10g, Edit Plus, Trillium
Confidential
Oracle Technical Manager / Project Coordinator
Responsibilities:
- Performed business analysis and designed data model for data warehousing and Informatica ETL process
- Designed and developed web application using Oracle forms and Reports / Oracle Designer
- Performed upgrades of Oracle databases and Oracle Forms and Reports applications
- Performed database tuning and designed and implemented performance improvement changes to nightly ETL processes
- Designed and developed the "ORMIT" product architecture officially certified by Oracle as "Oracle Certified Forms and Reports migration tool" for Imex Systems
- Demonstrated the ORMIT features in Oracle seminars and User Groups
Technologies: Oracle 8i/9i, TOAD, Oracle Forms and Reports, C++, PL/SQL, Forms & Reports API, Oracle Application Server, Informatica, HTML, VB, MS Access, SQL Loader