Oracle pl/sql Developer
Resume:
Sr. PL/SQL and MongoDB Developer
Lalitya
PH: 510-***-****
Email: ********@****************.***
PROFESSIONAL SUMMARY:
Around 9+ Years of extensive Experience in Oracle PL/SQL, MongoDB development and Maintenance, designing and developing Back End Packages, Triggers, views, materialized view, Procedure, Functions, Cursors, collections, plsql objects,DBMS scheduler jobs along other technologies like with MongoDB, Infomatica, Core Java, XML Schema, JSON, UNIX, Golden gate, Tidal Job, HTML and Agile Methodology.
Expertise in Development, Integration, Installation, Implementation, Maintenance, Testing, and Debugging of various application in Oracle PL/SQL.
Good knowledge of RDMS concepts
Experience in migration project from Oracle to MongoDB
Expertise in writing complex Mongo queries
Experience and SME in Ordering ebusiness tool
Experiences with knowledge of Golden gate technology to set up golden gate between multiple data bases
Experiences with knowledge of Oracle XML DB to set up xml notifications
Experienced in providing IT delivery services
Expertise in various cross functional analysis and its impact to business
Expertise in gathering and analyzing the requirements of users and translating them into technical definitions and designs
High customer interaction on a day to day basis
Experience in handling Remedy Management System used for tracking incidents and problems tickets
Closely involved in various fiscal period closure planning and system readiness
Experience in supporting SOX controls and various internal and external audits
Hands on expertise on Informatica power center, Business Objects XI
Involved in various release management activities from creation of scripts to deployment cycle
Experience in debug and implement performance improvements
Experienced working in Agile and Waterfall environments.
Expert using Rally Scrum Agile Software development methodologies
TECHNICAL SKILLS:
Technologies:
SQL, Oracle PL/SQL, MongoDB, Informatica, Core Java, HTML, Business Objects Reporting, UNIX, XML, JSON, Golden gate .
Databases:
ORACLE 9i,Oracle 10g,Oracle 11i, Oracle 12c, MongoDB 3.5
Development Tools:
TOAD, PLSQL Developer, Robomongo, MongoChef, Mongo Compass Testing Tool, FireBug Debugging, Eclipse IDE, SVN version control, Notepad++, EditPlus, AppDB, Kintana, Quatily Management, Rally.
EDUCATIONAL DETAILS:
Bachelor in Instrumentation Engineering (BE)
Diploma in Instrumentation Engineering
PROFESSIONAL SUMMARY:
Tata Consultancy Services
Client: Cisco, San Jose CA Sep 2013 - Present
Project: Cisco Commerce Workspace Capture / Manage Order
Role: Sr. PL/SQL Developer
Description:
Cisco Systems, San Jose, California USA has enlisted TCSL as a solution provider for various Sales-IT applications under the Cisco Commerce Workspace (CCW) platform. One such application is Capture Order/ Manage Order, an application used primarily by CISCO to sell its products to its Partners and Distributors and track its order status till shipment and order closer.
Responsibilities:
Designing and developing MongoDB system for Order
Understanding business requirements functionally for the new developments
Creating technical documentations depending on the function requirements
Analyzing the new requirements and providing the Effort estimation for the development
Developing the code as per the function requirements
Ensuring timely code drop
Working with quality analysts for fixing bugs in the system
Working with golden gate team to set up golden gate for particular requirements
Working with BEMs team for getting the notifications set up done
Worked on a POC and implementations on notifications XML generation
Coordinating with cross functional teams for development impacts
Release managements
Environment Oracle PLSQL, MongoDB, Scheduler Jobs, Oracle 11g, Toad 6.5., SSH client, HP Kintana 10, PVCS,CVS, Unix, XML DB,UNIX, Golden Gate, Robomongo, Mongo chef,Tidal Job.
Tata Consultancy Services
Client: Cisco, San Jose CA Apr 2012 - Sep 2013
Project: Performance Metrics Central 2.0
Role: IT Enhancement Engineer / Subject Matter Expert (SME)
Description:
PMC 2.0 (Performance Metrics Central) provides partners with Performance Metrics and Operational indicators which indicate the performance of a partner in selling and managing Cisco services as well as discount and rebate information to encourage partners to achieve best in class support performance and monitor performance requirements.
Responsibilities:
Deliver IT Services and product support for performance metrics central tool
Worked on enhancements related to the new requirements and bug fixes
Worked on optimization of queries related to performance tuning.
Worked on data & system issues pertaining to data quality, availability and upstream refresh jobs
Weekly metrics files generation before publication to end user and validation of data
Investigation on metrics anomalies and correction
Setup of new program and performance metrics
Support data setup for business rule creations
Business communication on data, metrics and system availability
Validation of data and functional clarification to end user community
System enhancement for case reduction and long term solutions
Interaction with business operations on a regular basis
Worked with performance team to improve the system performance and system stability
Worked on $U jobs to set correct dependencies and set correct scheduling
Worked on adhoc reports required by business users to validate the system reports, and planning
Runtime job monitoring and fixing job related issues by working with DBA and performance team
System Validation after infra CR’s
JVM restarts and logs verification in case of application fluctuation
Environment: SQL, Unix, SSH script, Teradata (hands on), Informatica Power Center 9.1, Oracle 11g, Toad 6.5. SAP Business Objects XI R3, SSH client, Dollar Universe, HP Kintana 10, PVCS
Tata Consultancy Services
Client: Cisco, San Jose CA Apr 2011 - Apr 2012
Project: Partner Program Platform
Role: IT Module lead
Description:
Partner Program Platform group of tools provides an integrated platform for cisco to manage end to end various profitability and reward programs including rebate process management. Below were the modules of this Program Platform which was Supported and enhanced.
Partner Program Enrollment (PPE)
Partner Program Administration (PPA)
Partner Rebate Engine (PRE)
Partner Program Intelligence (PPI)
Partner Program Intelligence BO (PPI BO)
Responsibilities:
Deliver IT Services and operational support for cisco partner program platform group of tools
Support production system to handle reported issues and responsible for routine maintenance
Worked on data & system issues pertaining to data refresh and upstream issues
Troubleshoot various partner related issues pertaining to their enrollments in different programs, rebate and cisco revenue impacting issues
Handle new program on-boarding request and feasibility analysis
Migration of various third party programs in Partner program enrollment tool
Analysis on new requirement and writing business rules to support that
Worked on creating base lines reports to support business data validations
Running program payment runs and support partner payment queries
Validation of program rebate calculation and tie outs
Communications to business operations and impacted downstream in case of any anomaly in the system
Worked closely with Program managers & finance stakeholders to correctly identify their requirements and ensure that all their requirements are met on time
Ensuring release readiness and post production issues handling
Support S-Ox and PWC audits
Developed help docs for PPE L2 support for frequently asked business cases
System Validation after infra CR’s
JVM restarts and logs verification in case of application fluctuation
Environment: SQL, PLSQL, Business Object, Informatica, Oracle 10g, Toad 6.5. MS Office, Unix, SAP Business Objects, SSH client, Dollar Universe, HP Kintana 10, PVCS
Tata Consultancy Services, India
Client: Cisco, Mumbai India Mar 2010 - Apr 2011
Project: Partner Program Platform
Role: IT Module lead
Description:
Partner Program Platform group of tools provides an integrated platform for cisco to manage end to end various profitability and reward programs including rebate process management. Below were the modules of this Program Platform which was Supported and enhanced.
Partner Program Enrollment (PPE)
Partner Program Administration (PPA)
Partner Rebate Engine (PRE)
Partner Program Intelligence (PPI)
Partner Program Intelligence BO (PPI BO)
Responsibilities:
Deliver IT Services and operational support for cisco partner program platform group of tools
Support production system to handle reported issues and responsible for routine maintenance
Worked on data & system issues pertaining to data refresh and upstream issues
Troubleshoot various partner related issues pertaining to their enrollments in different programs, rebate and cisco revenue impacting issues
Handle new program on-boarding request and feasibility analysis
Migration of various third party programs in Partner program enrollment tool
Analysis on new requirement and writing business rules to support that
Worked on creating base lines reports to support business data validations
Running program payment runs and support partner payment queries
Validation of program rebate calculation and tie outs
Communications to business operations and impacted downstream in case of any anomaly in the system
Worked closely with Program managers & finance stakeholders to correctly identify their requirements and ensure that all their requirements are met on time
Ensuring release readiness and post production issues handling
Support S-Ox and PWC audits
Developed help docs for PPE L2 support for frequently asked business cases
System Validation after infra CR’s
JVM restarts and logs verification in case of application fluctuation
Environment: SQL, PLSQL, Business Object, Informatica, Oracle 10g, Toad 6.5. MS Office, Unix, SAP Business Objects, SSH client, Dollar Universe, HP Kintana 10, PVCS
Tata Consultancy Services, India
Client: Cisco, Mumbai India Nov 2008 - Mar 2010
Project: Partner Database Tools & Partner Go to Market View
Role: IT Support Engineer
Description:
PDB applications represent how Cisco gets its products to the end users via channel partner. Channels Organization creates demand for its products through providing Cisco Resellers and Certified Partners with various tools which help them effectively communicate with Cisco, and manage their individual company association with Cisco. PGTMV is the integration of CR and PDB data in PGTMV view created at CR side.
Responsibilities:
Conducted meetings with management and user community to understand their requirements and convert Business requirements into technical specifications.
Gathering requirements from users and developed functionalities as per the business requirements.
Involved in creating new reports for business users and cross functional team
Working with Partner relationship team for process optimization and case reduction
Developed help docs for L2 support for frequently asked business cases
Worked with cross functional team to understand the discrepancies in PDB and CR data base and worked on planning and fixing those discrepancies
Worked on Data quality between PDB and CR
Worked on day to day issues related to Partner registration, attributes and contact management
Worked on PDB hierarchy changes
System Validation after infra CR’s
JVM restarts and logs verification in case of application fluctuation
Environment: SQL, PLSQL, Business Object, TIBCO, Oracle 10g, Toad 6.5. MS Office, Unix, SAP Business Objects, SSH client, Dollar Universe, HP Kintana 10, PVCS
Tata Consultancy Services, India
Client: Cisco, Mumbai India Jan 2008 - Nov 2008
Project: Channels and Distributions - Financial Analyst Activity (FA)
Role: IT Support Engineer
Description: FA activity is the activity where the POS, INVENTORY and CLAIMS batches for the sale carried out by the partners through the world with Cisco are posted in system so that they are processed and flown to different down streams like WIPS DCA
Responsibilities:
Post the batches in oracle form application
Generate daily report of the daily posting by refreshing the BO universe
Sending the reports to different theaters admins and in case of any anomaly working with support engineers of WIPS DCA and fixing the issue
Coordinating with stake holders and WIPS DCA business team in case of report time lines or any P1/ P2 in the upstream system
Environment: SQL, Business Object
Tata Consultancy Services, India
Client: No Client Sep 2007 - Jan 2008
Project: Initial learning program (TCS training)
Role: Trainee
Description:
Initial Learning Program is TCS training program for new campus recruits to enhance their skills in required technologies as per project requirements.
Responsibilities:
Learning new technologies
Hands on new technologies learn
Pass the midterm and end term exams and exceed 70% passing marks.
Learn TCS specific standards and code of conducts
Project delivery at the end term
Project Snapshot: Shipping Management System
Thesis: The main objective of this project was to find the shortest path for shipping company to go from one destination to another This project was developed in JAVA,ORACL PL/SQL and UNIX.
It did the below task
Inputs to find the shortest path between destinations were provided by JAVA interface and ORACLE DB was used to store the destination data set.
Report of the shortest path and its summary generated in UNIX.
Environment Oracle, SQL, PLSQL, JAVA, UNIX
CERTIFICATION:
Mongo DB Certification M101J – M101J: MongoDB for Java Developers
HYPERLINK: https://university.mongodb.com/course_completion/95d54e046cc2409e839b68df8e9de966
Mongo DB Certification M102 – M102: MongoDB for DBAs
HYPERLINK: https://university.mongodb.com/course_completion/fdfdfcbe426247cb81c086896c7811ec
Lynda.com - Learning Java
HYPERLINK: https://www.lynda.com/home/CertificateOfCompletion/PrintCertificate.aspx?lpk57=9B5F87E2B9F64C3BB7C4E6BA361F9F644
Contact this candidate