Senior Technology Lead Resume
Pleasanton, CA
SUMMARY:
- I am highly skilled Senior Technology Lead with 12+ years of experience in Information Technology industry. Has strong knowledge of Oracle e - Business Suite modules, multiple platforms, applications and tools. I have Bachelor’s Degree in Engineering. Additionally I have 1.5 years of experience in IT enabled services.
- I am highly proficient in the following technologies:
- I have experience in all the phases of SDLC: requirements gathering, system appreciation, technical and functional documentation, designing, coding, production deployment, post production support, minor and major enhancements.
- Worked on Oracle E-Business suite modules Accounts Payables, Accounts Receivables, General Ledger, Purchasing, Inventory, iExpense, i Procurement and Order Management.
- Technical and Functional expertise in Customization, Implementation and Support ofOracleApps Order to Cash (OTC) and Procure to Pay (P2P) life cycles..
- Good experience in development of Interfaces, conversions, validates and load data from legacy and feeder systems toOracleapplications.
- Extensive experience in working with PLSQL, Stored Procedures, Functions, API's, Packages, Triggers and Application tuning.
- Good experience in RICEW (Reports, Interfaces, Conversions, Extensions and Workflow) components, XML Publisher.
- Expertise in Client-Server application development using PL/SQL, SQL*PLUS, TOAD and SQL*LOADER
- Strong experience in development/maintenance/testing/conversion and migration projects in ORACLEdatabase (PL/SQL) using UNIX/LINUX/Windows environment.
- Extensive experience in data conversion/migrations, inbound/outbound interfaces, report development and customization within severalmodulesofOracleApplications.
- Worked onOracleDiscoverer (Desktop, Administrator, Plus, Viewer), which includes report developments, discoverer administration, configuring discoverer and End User Layer (EUL).
- Worked inOracleAPEX which is a web-based reporting tool where users can select the fields and filter them based on the data available in data base.
- Worked on implementation, upgrade, legacy data conversion, and support enhancement projects.
- Experience in ETL Datastage tool. DevelopingETLjobs inDatastagev8.1, v9.1. Used various stages on Data stage 9.1/8.7 Parallel jobs; like Sequential File, Transformer, Dataset stage, Aggregator, Merger, File set, Range lookup, Joiner, Copy, Modify, filter, funnel, Oracle Connector Job Sequence, peak stage, lookup stage, Joiner stage, Remove etc
- Experience in supporting the production system and handling day-to-day issues.
- Good experience in all phases of SDLC, exposure to CMM process, Testing, Quality Control and Change Management procedures.
- Strong communication skills and excellent problem solving skills.
- Excellent Analytical ability and attention to detail. Customer focused and solutions driven.
- Team player and Team Leader. Good planning and organizing skills, multi-tasking.
- Experience of working at offshore and onsite US and UK client locations. Worked extensively on on-site offshore model and good expertise to guide, coordinate and assist team members to provide deliverables.
- I have worked on various project management tools and processes.
- Integrated project management tool, Weekly status reporting, Milestone reporting and Metrics reporting.
- Resource planning, issues and risk management. Effort tracking, Reviews. CMMi check processes.
- Configuration management, release management process and tools.
- I have experience in Incident management, Problem management, Minor and Major enhancements. Quality planning, Risk Planning, Disaster recovery and business continuity processes.
TECHNICAL SKILLS:
ERP Environment: Oracle Applications E-Business Suites (11i, R12)
RDBMS: Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g, MSSQL
Application Modules: Oracle Applications Modules - Financials, Accounts Payable, Purchasing, General Ledger, Accounts Receivables, Sales Contracts, Service Contracts, Install Base, Meter Readings, Logistics Inventory Management, Order Management, Oracle Application Express, Oracle Forms and Reports, Oracle Multi Org Architecture Oracle Discoverer reports, Oracle SIEBEL CRM, Legacy Data conversion, Work flow Builder, RICE components, Oracle Discoverer report.
Operating Systems: Windows, Sun Solaris, IBM AIX HP UNIX, Red Hat LINUX, Macintosh.
Other Skills: UNIX shell scripting, ETL Tool IBM Data stage TX, EAI tool IBM Data stage Integration Broker, Data Conversion Oracle APEX Tool, SQL*Loader, TOAD, SQL Tuning, MQ Series, VI editor, Visual Source Safe, Money Transfer System (Banking payment management system), Anti Money Laundering Systems. NDM, FTP and SFTP protocols. CAWA Scheduler.
WORK EXPERIENCE:
Confidential, Pleasanton, CA
Senior Technology Lead
Responsibilities:
- Working as Oracle EBS technical consultant. Provide production support to Oracle EBS R12. Working on Incident management, problem management, minor enhancements, work orders with focus on Oracle Applications - Financial modules, Account Payable, Account Receivables, General Ledger, Purchasing, iExpense, iSupplier.
- Oracle Forms and Reports, Oracle Discoverer reports. RICE Components Reports, Interfaces, Conversions and Extensions components. Oracle PL/SQL.
- Developed PLSQL components, procedures, functions, packages, Oracle database objects. API’s Customization.
- Reports and application tuning. Discoverer report creation / modifications.
- Unix shell scripting, CAWA job scheduling.
- Created SFTP script, unix public key exchange to enable file transfers between multiple systems.
- Coded a PLSQL package for GL data to be interfaced from Oracle EBS to ESSBASE system.
- Customized PO workflow to enable the vacation rule and iExpense workflow to ensure compliance for SOX audit. End to end testing of Purchase Order and iExpense workflow testing.
- Modified the custom Payment program for a critical duplicate payment sent to Bank issue.
- Client facing role, customer interaction. High impact communication. Handling high severity issues. Worked with business users to get the functional inputs and worked on the technical enhancements.
- Providing support, financial data reports to internal business partners from Account Payables and Procurement departments.
- Financial data processing for month end, quarter end and year end processing. AP period closure support each month for all the Ledgers.
- Oracle System Admin activity for Concurrent program registration, Value set creation, Managing user, Request set creation, Responsibility creation for user and Set up profile options
- Oracle Utilities: Used the following utility while working in UNIX environment. FND LOAD - To migrate objects from one instance to other. TKPROF - For performance tuning to convert the .trc file into .prf readable file for performance tuning. SQLLDR-SQL loader utility to load data from control file (.ctl file) into staging table for interface or conversion.
- Handling a team of 17+ members ( 5 members Onsite + 12 Offshore ) . Mentoring and guiding the team, providing technical assistance.
- Onsite - offshore co-ordinations, task delegation, handling IM, PM tickets distributions.
- Estimation for Minor Enhancements and tracking effort. Ensuring pre-defined total number of ME hours is billed to the client.
- Created various knowledge documents for team to handle critical support issues.
- Using project management tools, metrics reporting, milestone reporting, effort tracking, weekly status reporting, reviews.
Environment: Oracle EBS R12.1.3 modules AP, PO, iExpense, GL, Toad, SQL Developer, Unix, Discoverer, Reports Builder, Workflow Builder, XML Publisher.
Confidential
Technology Lead
Responsibilities:
- Worked as Oracle EBS technical consultant. Project was data migration from legacy systems to Oracle EBS 11i and Oracle SIEBEL.
- Worked as a conversion lead at onsite (location UK) for the Oracle Applications modules Accounts Receivables, Sales Contracts, Service Contracts, Install Base, Meter Readings, and Billing. Oracle Application Express for various report generation. Oracle PL/SQL, Apex reports.
- Successfully completed data conversion for following countries data into Oracle EBS, Germany, Netherlands, Poland, Hungary and South Africa.
- Handled a team of 2 (onsite) + 6 (offshore) members. Mentoring and guiding the team, providing technical assistance.
- Complete knowledge of conversion process, legacy data extraction, data analysis, data cleansing, validation, conversion, reconciliation, exception analysis, documentation, and post production support.
- Oracle Siebel data conversion Datastage job designing, coding, testing and deployment in production.
- Report creation and data review process.
- Client interaction, meetings, status updates to all stake holders and business sign off meetings. Worked on configuration management, change management.
- Also worked on Oracle SIEBEL CRM, ETL tool data stage for an enhancement project. Data migration from SIEBEL 6.0 MSSQL to Oracle SIEBEL. Worked on SIEBEL modules Accounts, prospects, customers, opportunities, employee, price lists. Worked on PLSQL, EIM tables, base table import programs.
Environment: Oracle EBS R11i modules Install Base, Contracts, Meter Readings, Oracle SIEBEL CRM, Oracle APEX tool, Toad, SQL Developer, Unix, Discoverer, Reports Builder, Workflow Builder, IBM Datastage v9.1, v8.1., MS SQL database.
Confidential
Programmer Analyst
Responsibilities:
- Worked as Oracle EBS technical consultant. Project was to rollout Retail IT Transformation solutions to all 102 client Stores & Repair Centers across Australia.
- Worked as an implementation lead for the Oracle Applications Logistics Inventory Management, Order Management, Returns Processing RMA, Oracle Forms and Reports, RICE Components Reports, Interfaces, Conversions and Extensions components. Oracle PL/SQL.
- Handled a team of 6 members. Mentoring and guiding the team, providing technical assistance.
- Designing, PLSQL coding, package creation, testing, deployment process,
Environment: Oracle EBS R11i Order Management, Inventory modules, Toad, SQL Developer, Unix, Forms Builder, Reports Builder Forms 6i, Reports 6i, Workflow Builder.
Confidential, Chicago IL
Software Engineer / Programmer Analyst
Responsibilities:
- Worked as Programmer analyst. Project was to provide application support for business critical financial systems for the bank. System appreciation, documentation, code study to successfully transition details from incumbent vendors.
- Worked as primary application support onsite (location US) for a critical Wire Transfer system. Experience in banking payment management system (Money Transfer Systems).
- Worked on EAI tools IBM WTX web-sphere transformation extender, IBM Ascential Datastage, Oracle PLSQL programming, UNIX shell scripting, data warehousing, MQ series.
- Worked on enhancements projects related to anti-money laundering implementation, BASEL II accord. Experience on FED, SWIFT, wires transaction processing.
- Knowledge of disaster recovery and business continuity processes.
Environment: Third part tool Money Transfer System, Toad, SQL Developer, Unix, IBM datastage message broker.
Confidential
Software Engineer
Responsibilities:
- Worked as software engineer. Project was to provide support and enhancements to the Data Warehouse system, Service History Analytical Reporting Platform-Enhanced Data Gathering Exercise
- Worked on Oracle PLSQL programming, UNIX shell scripting, data warehousing tools.
- Designing, coding, documentation, unit testing, integration testing.
Environment: Toad, SQL Developer, Unix, Dataware housing tools
Confidential
Confidential
Responsibilities:
- Worked as technical support service representative for various clients including leading brand for Printers and office automation products.
- Provided technical assistance for a leading Linux based Hotel Management systems used in various hotels and motels in US and Canada.
- Task was to provide technical assistances to the end users on calls.
Confidential
Responsibilities:
- Worked as technical support service representative for various clients including leading
- Task was to provide technical assistances to the end users on calls.