Candidates About

 

Nidhi Tomar

Summary

Ø  12 years of experience in Information Technology with extensive experience in full Software Development Life Cycle implementations (Full SDLC).

Ø  Over 8 years of experience in gathering business requirements/ functional requirements, documenting them and converting them into robust system designs.

Ø  Experienced in working with the business users and programmers, and forming a strong business solutions partnership.

Ø  9 years of experience in in-depth data analysis, system analysis, module & system design, development, customizations and conversions.

Ø  Experienced in translating business requirements into technical requirements and then converting those into clear and precise technical specifications that developers can use to develop the software objects.

Ø  Expert at Oracle RDBMS based Client Server technology and in the design, development, implementation, customization and support of business & commercial applications using Oracle Applications 11i (11.5.9 and 11.5.10) and 12i.

Ø  Over 7 years of experience as a Techno-Functional Consultant in the domain of Order Management (OM), iProcurement, Accounts Payable (AP), Accounts Receivable (AR), Purchase Order (PO), General Ledger (GL), Bill of Material (BOM), Inventory (INV) and Application Object Library (AOL).

Ø  Over 5 years of experience in front end report development using Oracle Reports (6i), Oracle Forms, XML Publisher, Discoverer Plus and Discoverer Administration.

Ø  Experienced in quality management procedures such as iQMS and Six Sigma.

Ø  Experienced in Oracle Sun Identity Management tool Waveset.

Ø  Experienced in preparing release plans for large projects involving complex dependencies.

Ø  Developed Interface Programs (Item Interface, Item Super-Session, Item Categories, Item Sub-Inventory, AP, AR, PO/ POC, Customer Interfaces) to import data from feeder systems into Oracle using SQL*Loader, PL/SQL,T-SQL and external tables.

Ø  Expert in System Administration of Oracle Applications, including managing Concurrent Manager, Concurrent Program Registration, Menus, and Functions.

Ø  About 6 years of leadership experience with the ability to manage offshore teams, prioritize tasks, estimate resource load and proactively manage customer expectations.

Ø  Functional experience includes Manufacturing, eCommerce.

Ø  Experienced in parallel project execution.

Ø  Experienced in creating Technical and User Documentation such as MD70s and MD120s.

Ø  Experienced in preparing source-to-target mapping specifications and technical design documents relating to ETL processes.

Ø  Expert in database development (SQL, PL/SQL,T-SQL, tables, views, indexes, packages, stored procedures, functions and triggers).

Ø  Expert in the use of database SQL client tools such as Toad, SQL Navigator and PL/SQL Developer.

Ø  Extensive experience in team development and training.

Ø  Excellent customer interfacing skills.

Ø  Worked with large Oracle Implementers such as General Electric, Ingersoll Rand, Sun Microsystems and Oracle.

 

Certifications and awards achieved are –

 

Ø  Six Sigma Green Belt Certified.

Ø  Certificate of Customer Appreciation from General Electric Corporate Information Systems (GECIS).

Ø  Certificate of Customer Appreciation from Ingersoll Rand.

Ø  Americas Recognition award for Outstanding Customer Support from Computer Sciences Corporation.

 

Technical Skills

 

Operating Systems: Windows 2000/ XP, Sun Solaris, UNIX, Linux

Languages: C, C++, PL/SQL, T-SQL, Unix Shell Scripting, LIMS Basic, ASP, Java Script, XML, HTML, ABAP.

Databases: Oracle 10g/9i/8i, SQL Server

Tools: Oracle Reports (6i), Oracle Forms, XML Publisher, Discoverer Plus, Appworx, Concurrent Manager, VSS, CVS, Kintana, SQL Loader, Toad, SQL*Plus, SQL Navigator, PL/SQL Developer, SQL Server Management Studio, Oracle Sun IDM Waveset.

Project Management Tools: Integrated Project Management System (iPMS).

Oracle Applications 11i (11.5.9 and 11.5.10), 12i: Order Management (OM), iProcurement, Accounts Payable (AP), Accounts Receivable (AR), Purchase Order (PO), General Ledger (GL), Bill of Material (BOM), Inventory (INV), Application Object Library (AOL), System Administration.

Office Packages: Outlook, Excel, Word, PowerPoint, MS Access, SharePoint, Sun Open Office.

 

Professional Experience

 

Aldera , San Diego, CA

Project: Portal Development Team

Data Analyst

Aug 15 – Current

 

The Data Analyst is responsible for supporting the business partners, external customers and internal customers. This includes data support activities such as researching data issues using SQL queries, creating SQL scripts for fixing data issues, using Redgate, MS SQL Server Management Studio, Excel and other tools, including some Oracle tools for managing data and procedures.

 

Responsibilities:

Ø  Data file management activities such as extraction, transformation and transmission of electronic records from related and non-related operating systems, as well as the intake, analysis, quality control, and loading of these data files from clients and business partners.

Ø  Production support of nightly data integration jobs for our hosted clients by reviewing load reports and rerunning jobs that failed.

Ø  Update JIRA, our incident management reporting system.

Ø  Research data issues that may be causing failures in the system.

Ø  Perform modifications to extract and/or load code and supporting job scripts.

Ø  Programming of data interfaces and application procedures, etc., for business problems, customizations and enhancements.

Ø  Assist in developing specifications and data mappings. Working closely with the Software Engineering team to find the best solution to the problem.

 

Environment: Windows XP, UNIX, Linux, Perl Scripting, PL/SQL, TOAD, SQL Server, T-SQL, CVS, ETL, SSIS, SSRS, VSS.

 

 

 

 

Sony Electronics Inc. , San Diego, CA

Project Name: Post-Sales Support & Promotions

Sr. Oracle Developer / Data Analyst

Sept 12 – May 13

 

Implement the Net Promoter Score (NPS) program to measure the customer experience with products and services.

 

Responsibilities:

 

Ø  Analyzed customer feedback to identify opportunities to improve customer experience and loyalty.

Ø  Define and implement process and system requirements for efficient data analysis.

Ø  Benchmark activities and analysis findings against service standards and industry best practices

Ø  Help the data analyst team to manipulate data by writing SQL scripts.

Ø  Involved in high level technical design of the NPS dashboard that handles various data feeds of survey data.

Ø  Developed interface to migrate various data feeds to the main SQL Server so that the data can be used for various data analysis.

Ø  Developed and deployed new triggers, views, procedures and T-SQL scripts.

Ø  Created and deployed SSIS packages to automate various data feeds.

Ø  Developed new reports, triggers, views, procedures and PL/SQL packages.

Ø  Develop technical and user documentation such as MD70s and MD120s.

Ø  Tested and fixed bugs in existing reports and procedures.

Ø  Participated in unit and integration testing with business users.

Ø  Involved in performance tuning of many custom programs

Ø  Development of PL/SQL programs and Reports.

Ø  Provide ongoing systems support and problem resolution to end-users.

Ø  Version control maintenance for project source codes

 

Environment: Windows XP, Sun Solaris, UNIX, Linux, Unix Shell Scripting, PL/SQL, SQL*LOADER, TOAD, SQL Server, T-SQL.

 

Optum Rx – Prescriptions Solutions (United Health Group), San Diego, CA

Project Name: Open Refill Transfer File (ORTF Transfer In)

Sr. Oracle Developer / Techno-Functional Consultant

Feb 12 – June 12

 

Optum Rx is the world's largest provider of integrated health services. Prescription Solutions by Optum Rx specializes in the delivery, clinical management and affordability of prescription medications and consumer health products.

 

Responsibilities:

 

Ø  Involved in high level technical design of pharmacy system that handles millions of prescribers, prescriptions, coverages and patients.

Ø  Developed interface to migrate all the prescribers, patients, prescriptions and coverage information to the oracle base tables.

Ø  Developed custom API’s to migrate all the prescriptions and coverage information to custom tables.

Ø  Developed new reports, triggers, views, procedures and PL/SQL packages.

Ø  Develop technical and user documentation such as MD70s and MD120s.

Ø  Extensively worked on Trading Community Architecture (TCA) data model to create the party, party sites, locations, contacts for prescribers and patients.

Ø  Customized prescriptions re-order form according to the requirement.

Ø  Tested and Fixed bugs in existing Forms & Reports

Ø  Participated in Unit and integration testing with business users.

Ø  Involved in performance tuning of many custom programs

Ø  Perform development work in Oracle Applications in the OM, INV, TCA modules and in PL/SQL, Oracle 9i and SQL Loader.

Ø  Development of PL/SQL programs, Forms and Reports.

Ø  Provide ongoing systems support and problem resolution to end-users.

Ø  Registered custom reports and menus for corresponding modules.

Ø  Version control maintenance for project source codes

 

Environment: Windows XP, Sun Solaris, UNIX, Linux, Unix Shell Scripting, Oracle Applications EBS 12i (OM, INV, TCA) Forms 6i/10g, Reports 6i/10g, PL/SQL, SQL*LOADER, TOAD, XML Publisher.

 

Sun Microsystems, Santa Clara, CA

Project Name: Integrated Business Information Solutions (IBIS)

Sr. Oracle Developer / Techno-Functional Consultant

Nov 07 – Jan 11

 

Sun Microsystems moved from its current Oracle ERP implementation to Oracle 11i in an effort to consolidate its various vertical processes and streamline business processes using the Integrated Business Information Solution (IBIS) suite. This project provided all application development and support services to Sun’s business application portfolios such as finance, manufacturing, messaging, enterprise resource planning (ERP), customer relationship management, data warehousing, etc in the U.S., Europe and Asia Pacific.

 

Responsibilities:

 

Ø  Provide leadership to a team of 6 onsite and offshore resources.

Ø  Trouble shooting and fixing the bugs and defects in existing code.

Ø  Perform Oracle Application configurations and setups.

Ø  Develop new Reports, PL/SQL codes and testing.

Ø  Upgrade Reports, PL/SQL procedures and Conversions.

Ø  Develop new reports, triggers, views, procedures and PL/SQL packages.

Ø  Developed and tested software using Waterfall methodology.

Ø  System Administration involving managing Roles and Responsibilities, Concurrent Managers, Concurrent Program Registration, Menus, Functions, Value Sets, Profile Options, Proxy User set up, Business Events and Security Features.

Ø  Identifying issues/bugs in standard objects and recommending custom code for overcoming those issues and proposing bug fixes to Oracle support through Metalink.

Ø  Setting value sets, profile options, responsibilities for business requirements.

Ø  Develop technical and user documentation such as MD70s and MD120s.

Ø  Gather requirements by interacting with the business users and by analyzing existing business processes.

Ø  Provide on-demand, weekly and monthly metrics and status reports to the client.

Ø  Liaise between technical personnel, management and the business community to communicate solutions, issues and status.

Ø  Prepare release plans for intrusive production and beta releases.

Ø  Develop interface and conversion technical specifications for General Ledger (GL) historical transaction data, Accounts Payable (AP) open invoices and closing balances.

Ø  Schedule Appworx and Concurrent Manager jobs and promote them from development to beta and production environments.

Ø  Maintain a Master Batch Schedule (MBS).

Ø  Manage job schedules for downtimes and outages.

Ø  Provide on-call support during critical system-processing periods (i.e., month-end, year-end closing, and any Oracle related severity one issues).

Ø  Provide ongoing systems support and problem resolution to end-users.

Ø  Enforce data integrity, SOX compliance and quality standards.

 

Environment: Windows XP, Sun Solaris, UNIX, Linux, Unix Shell Scripting, Oracle 10g/9i, PL/SQL, Appworx, Toad, PL/SQL Developer, SQL Navigator, SQL Server, CVS, Kintana, SQL Loader, SQL*Plus, Order Management (OM), Accounts Payable (AP), Application Object Library (AOL), FINHELP , System Administration, Oracle Sun IDM (Waveset), Sun Open Office, Outlook, Excel, Word, PowerPoint, MS Access, SharePoint.

 

Ingersoll Rand, Davidson, NC

Project Name: Industrial Solutions

Sr. Oracle Developer / Analyst Programmer

Jun 06 to Oct 07

 

Ingersoll Rand’s Industrial Solutions has locations spread out across the globe, each of which is involved in marketing, sales, distribution, service, contract management, invoicing, etc of various manufactured items. Business transformation, complete global process redesign, optimization, usage of common business practices and central data management were implemented using Oracle Applications, Siebel and Tavant. Custom interfaces were designed to export data to Decision Support Systems (DSS) to meet Business Intelligence needs.

 

Responsibilities:

 

Ø  Provide leadership to a team of 6 onsite and offshore resources.

Ø  Gather requirements by interacting with the business users and by analyzing existing business processes.

Ø  Develop new reports, triggers, views, procedures and PL/SQL packages.

Ø  Develop interface and conversion technical specifications for General Ledger (GL) historical transaction data, Accounts Payable (AP) open invoices and closing balances.

Ø  Develop technical and user documentation such as MD70s and MD120s.

Ø  Prepare source-to-target mapping specifications, technical design documents relating to ETL processes for data warehousing.

Ø  Participate in database design and evaluation.

Ø  Cleanse the source system data and assure quality at the staging level.

Ø  Convert data from the legacy system into Oracle via Open Interface tables.

Ø  Carry out Gap Analysis between business requirements and application standard functionalities and bridge them with RICEW components (R-Reports, I-Interfaces, C-Conversions, E-Extensions and W-Workflows).

Ø  Coordinate both with ender users and programmers, and form a strong business solutions partnership.

Ø  Establish work breakdown structures, milestones and deliverables for the team.

Ø  Provide on-demand and weekly status reports to the client.

Ø  Document technical requirements pertaining to iProcuement, Order Management (OM), Accounts Payable (AP), Accounts Receivable (AR), Purchase Order (PO), General Ledger (GL), Bill of Material (BOM), Inventory (INV) and Application Object Library (AOL).

Ø  Prepare technical specifications for Reports, Interfaces, Conversions and Extensions (RICE).

Ø  Develop new Reports, PL/SQL codes and testing.

Ø  Upgrade Reports, PL/SQL procedures and Conversions.

Ø  Define key accounting flex field structure and chart of accounts with Multi Org and Multi Currency setup. Define currency conversions, currency translations, currency re-evaluations and set the profile options for OM.

Ø  Define security rules and cross validation rules according to business requirements.

Ø  Enable and define descriptive flex fields in Application Object Library (AOL).

Ø  Define financial and payable options, suppliers, banks, payment formats, payment programs, and payment terms. Set the profile options.

Ø  Define descriptive flex fields for additional information on vendor details and invoice transactions.

Ø  Manage application security by creating custom responsibilities set with specific menus, functions, report groups and profile options.

Ø  Prepare sample data and test cases for RICEW components.

Ø  Prepare test scripts to test various scenarios in OM, AP, AR, PO, GL, BOM, INV and AOL modules.

Ø  Manage and support user acceptance testing (UAT).

Ø  Train end-users and resolve issues found during UAT.

Ø  Provide technical support to other teams, troubleshoot and maintain the system.

Ø  Provide on-call support during critical system-processing periods (i.e., month-end, year-end closing, and any Oracle related severity one issues).

Ø  Provide ongoing systems support and problem resolution to end-users.

Ø  Diagnose and fix problems with Oracle Application configurations and setups.

 

Environment: Windows 2000, UNIX, Linux, Unix Shell Scripting, Oracle 9i, PL/SQL, Appworx, VSS, Kintana, SQL Loader, Toad, PL/SQL Developer, SQL Navigator,SQL Server, SQL*Plus, Integrated Project Management System (iPMS), Oracle Reports (6i), Oracle Forms, XML Publisher, Discoverer Plus, iProcurement, Order Management (OM), Accounts Payable (AP), Accounts Receivable (AR), Purchase Order (PO), General Ledger (GL), Bill of Material (BOM), Inventory (INV), Application Object Library (AOL), System Administration, Outlook, Excel, Word, PowerPoint, MS Access.

 

General Electric, Corporate, Mumbai, India

Project Name: SSS Oracle Purchasing GE CIS

Module Leader/ Analyst Programmer

Feb 05 to May 06

 

General Electric’s Shared Sourcing Services (SSS) environment consisted of a single, global purchasing instance for direct and indirect procurement. Over 180 operating units use this system across the globe. The system was implemented using Oracle Purchase Order (PO), Accounts Payable (AP), General Ledger (GL), iProcurement and other self-service web applications. All of GE’s businesses use this installation to procure expense items. Custom interfaces were designed to export data such as employee, purchases, accounts receipts, invoices and payments.

 

Responsibilities:

 

Ø  Module leader for a team of 5 developers.

Ø  Create high-level process models (activity hierarchy diagrams, data flow diagrams and system interface diagrams) to represent business processes.

Ø  Gather requirements by interacting with the business users, business analysts and by analyzing business processes.

Ø  Translate business requirements into technical requirements and then convert those into clear and precise technical specifications that developers would use to develop the software objects.

Ø  Estimate effort.

Ø  Establish work breakdown structures, milestones and deliverables for the team.

Ø  Perform in-depth data analysis and resolve data issues.

Ø  Create test cases.

Ø  Perform development work in Oracle Applications in the Purchase Order (PO), Accounts Payable (AP), General Ledger (GL), Application Object Library (AOL) and iProcurement modules and in PL/SQL, Oracle 9i/8i, SQL Loader.

Ø  Design and develop custom interfaces to extract