Manohar_oracle Resume

MANOHAR

Contact #: 703-***-**** *******.***@*****.***

PROFILE SUMMARY

 Over Seven Years of Experience in SDLC including architecture, analysis, design, development, testing, implementation & maintenance of application software in Oracle, SQL, PL/SQL and Unix

 Expert level experience with Oracle 11g, 10g, 9.x, 8.x, Sybase, Oracle Forms and Reports.

 Extensive experience writing Oracle SQL & PL/SQL, Database Stored procedures, Functions, Packages, Triggers, SQL Loader scripts, Shell-Scripts.

 Extraction and loading of data using various Oracle import and export utilities like Datapump, impdp, expdp, etc…

 Experienced with various database development tools - TOAD, PLSQL Developer, SQLplus, etc…

 Experienced in Conceptual Logical & Physical Database Modeling using Erwin, Visio.

 Experience with performance tuning of SQL, PL/SQL using SQL Trace, Explain Plan, TkProf, Indexing and Hints.

 Experienced with DBA activities like creating users, granting and revoking privileges on database objects and taking backups.

 Experienced with Data migration and Data Conversion using custom made SQL scripts, data junction, SQL Loader, etc…

 Experienced with UNIX shell programming in various UNIX environments like Sun Solaris, Unix and AIX.

 Experience in developing ETL mappings and scripts using Informatica Power Center 7.1/6.2/5.1

 Experience in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.

 Experienced in using version control systems like using CVS, PVCS and VSS.

 Experienced working with clients on-site and with offshore teams while analyzing software requirements and developing solutions

 Worked as a part of team in 24x7 production environment and provided on-call and day-to-day support.

 Strong Domain knowledge of Supply chain plan, Telecom, Pharmaceutical and Banking Industries

 Possess good communication and quality center skills and quick learning ability.

CERTIFICATIONS

• Brainbench – Oracle PL/SQL Certification

• Brainbench – Oracle RDBMS Certification

TECHNICAL SKILLS (TECHNOLOGIES UTILIZED AND INTERFACED WITH)

Database Modeling Tools Erwin, Designer 2000, Microsoft Visio 2003

Databases Oracle 10g/9i/8i , Sybase, SQL Server 2000 / 2005

Reporting Tools Oracle Forms and Reports 6i/9i, Crystal reports 9/10

DB Dev. Tools TOAD, PLSQL Developer, Oracle Enterprise Manager, SQL*Plus

ETL Tools SQL*Loader

Languages SQL, PL/SQL, Java,

XML Technologies XML, XSL/XSLT

Version Control Tools CVS, PVCS, VSS

Operating Systems Sun Solaris 8.0 / 9.0, AIX, Windows

.

PROJECT SUMMARY:

DAIMLER TRUCKS OF NORTH AMERICA - MI FEB 2008 – OCT 2009

Client Electronic Data Systems (EDS) – A HP company

Project Daimler is one of the leading company in the US. The main goal of the project is to migrate the Daimler’s financial transactions data related to Account receivables, Accounts Payable, General Ledger, Inventory, Goods Receipts ,Purchase orders which exists in ERP system(DIBS) to SAP legacy system(CBFC) so that all the financial activities are handled in CBFC after the implentation. The financial transactions are split into different interfaces. The main goal is to transmit all the interfaces from DIBS to CBFC system through the batch jobs (Unix shell scripts), PRO*C programs, Database objects and forms through middleware PI.

Role Sr. Oracle/Forms Developer

Responsibilities  Involved in gathering the requirements and system specifications from users.

 Created the Functional specifications and Use Cases.

 Prepared the Technical specifications for all interfaces.

 Developed PL/SQL Packages, Procedures, Functions, Triggers, Views ,Indexes ,Sequences and Synonyms.

 Used PL/SQL TABLE, VARRAY, RECORDS and OBJECT TYPES.

 Developed Control files to load data from Flat files to database tables.

 Loaded data into tables using SQL Loader utility.

 Executed procedures to run the error checking routines and validated the data.

 Refreshed Materialized views after the data is successfully processed into the production schema.

 Resolved the issues with the files by loading the data into STAGE TABLES and monitoring the data.

 Created a new forms and Modified the existing forms and Pro*C programs according to the business logic.

 Developed procedures, functions for different forms.

 Used different joins, sub-query, and nested query in SQL query, for reports.

 Created a new UNIX shell script for each interface to put a message into MQ series for different EDI interfaces to be transmitted to CBFC.

 Modified the batch jobs to transmit the data to CBFC using scheduling software.

 Adept Knowledge in using the tool Oracle Applications Express (Oracle APEX) 3.0 for building interactive web Applications.

 Generated the text files using the UTL FILE functions and SPOOL COMMANDS.

 Involved in FTP and SFTP the generated text files to Remote Server.

 Prepared the Unit test cases

 Involved in Unit testing, Integration, functional and System testing.

 Involved in UAT with business users.

 Interacted with end user for problems faced and providing necessary technical support by fixing the bugs.

 Developed and executed testing life cycle manually and using the automated test tools like Quality Center.

 Involved in Code reviews.

 Responsible for moving the source code to Production.

 Responsible for maintaining the source code in SCCS (Source Code

Control System) in Telnet.

 Involved in DBA activities like creating a USER, providing roles, privileges, Grants, Revokes and Locking the User accounts.

 Guided existing ERP support team in resolving R12 issues

 Guided team in writing the efficient code for different interfaces.

 Coordinate with different teams while doing production support

 Worked as a part of a team and provided 24 X 7 support and on-call when required.

Environment Oracle 11g/10g,PL/SQL Developer, TOAD 9.5 ,SQLPLUS, SQL*LOADER, Oracle Designer, Forms Builder ,Reports builder, Unix AIX 5.1, Unix shell scripts, Oracle Apex 3.0,Telnet, Control Panel (forms tool) , File Zilla, Click Scheduling software, CS Diff ,Microsoft Visio 2003

BURLINGTON COAT FACTORY – NJ - FROM APR 2007 – JAN 2008

Client BURLINGTON COAT FACTORY

Project The main goal of the project is to create EDI ASN rules for Burling Coat Factory.

Role Sr. Oracle Developer

Responsibilities  Involved in gathering the requirements, system specification from users.

 Involved in database analysis, design using ERWIN.

 Designed the Dimensional Model of the Data Warehouse Confirmation of source data layouts and needs.

 Developed PL/SQL Packages, Procedures and Triggers to integrate with other applications.

 Involved in performance tuning of queries using EXPLAIN PLAN and TK PROF

 Involved in unit testing and integration testing and preparing user test plans.

 Used Korn Shell scripts to automate Oracle import/export.

 Reduced processing times of SQL queries.

 Imported the production data to dev/work environment using TOAD.

 Creating, executing, and maintaining test rules/ cases and driving defects to conclusion.

 Coded, tested and optimized complex stored procedures with Transact-SQL.

 Experience in Preparation of Test Plan, Test Cases & Test Data based on System Requirements Specification (SRS).

 Experience in preparing Test Plans, identifying new test scenarios and Test Execution, debugging, reporting and fault tracking.

 Designed and developed Informatica Mappings to load data from Source systems to ODS and then to Data Mart.

 Developed Mappings, Defined Workflows &Tasks, Monitored Sessions, Export & Import Mappings and Workflows and Backup, Recovery.

 Converted manual jobs to fully automated processes using Autosys.

 Design and development of resource materials and resource data bases.

 Guide Teammates for writing effective queries in applications.

 Worked as a part of a team and provided 24 X 7 support when required.

Environment Oracle 11g/10g, TOAD, Erwin, Forms 9i,Reports 9i, Informatica Power enter 6.2,UNIX Shell Scripts, Autosys, PL/SQL ,ETL tool, Perl, Developer suite 10g,Work flow 2.x,and Sun Solaris

GE - IDSP SYSTEM - FROM JAN 2006 – MAR 2007

Client GE, PA

Project GE Equipment Services iDSP System: Forecasting & Planning system is a web based portal which uses iDSP tool and allows various field offices to provide market information about the assets they need, so the business can proactively position and prepare our current rental assets to most profitably and meet our customer’s expectations. This project has 3 modules.

Demand Manager: The Demand Forecasting solution will enable the business users in forecasting business process defined in the to-be planning process

Forecast netting: Forecast Netting engine imports forecasts and actual orders and exports the netted forecasts and the planning rates for the netted forecasts.

Supply chain planer: The supply-chain planning model will enable business users (from the asset management group) to optimize the Fleet and to Improve Operational Performance, customer service and asset utilization.

Role Sr. Oracle Developer

Responsibilities

 Involved in gathering the requirements and system specification from the users.

 Responsible for Analyzing requirements, designing, maintaining and updating data models using ERWIN.

 Involved in Developing and handling PL/SQL Packages, Procedures and Triggers.

 Design and development of user interface using Forms 9i in Developer 2000.

 involved in unit testing and Regression testing.

 Involved in handling the bulk production data.

 Involved in importing the production data to work environment through TOAD.

 Involved in handling changes of compiling scripts according to database changes.

 Developed an integrated and aggregated supply chain data and process model using Oracle Designer 2000.

 Created Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.

 Fixed invalid Mapping's, tested Stored Procedures and Functions, Unit Testing of Informatica Sessions, Workflows.

 Used Oracle Portal/APEX and JavaScript to develop Community Manager, an internal web portal for GE.

 Assisted customers in troubleshooting issues with their applications in Autosys.

 Coordinate with different teams while doing production support and critical problem resolution.

 Worked as a part of a team and provided 24 x 7 support when required.

Environment Oracle 9i / 10g, UNIX Shell Scripts, ETL tool, JAVA, Reports 9i,Work flow 2.x, Informatica Power center, Autosys , Toad and PL/SQL Developer, Oracle Apex 3.0, Excite, PVCS, and Sun Solaris

HARRIS BANK, CHICAGO, IL - FROM MAR 2005 – DEC 2005

Client Harris Bank, Chicago, IL

Project Harris Bank is one of the USA's leading financial companies. The enterprise data integration project is to extract, transform, and load 85 percent of the data, originating from external systems in the data warehouse and integrating data between the legacy call center and collaborative CRM systems.

Role Pro*C /Oracle, UNIX Developer

Responsibilities  Involved in Understanding the Business Knowledge.

 Designed and Customized data models for Data warehouse supporting data from multiple sources with Erwin.

 Used Use cases for documenting the functional specifications.

 Designing the interface for the external applications to communicate with the reports repository.

 Writing PL/SQL procedures to integrate other applications

 Creating Data models using ERWIN

 Involved in writing the Oracle scripts and automate

 Design and development of user interface using Forms 9i

 Developed Reports using Reports 9i

 Involved in development of purging programs to clear the history data in database

 Involved in preparing the Unit Test plans.

 Worked as a part of a team and provided 7 x 24 support when required

Environment Oracle 8i / 9i, PL/SQL, UNIX Shell Scripts , ETL TOOL(Sql Loader), Forms 9i,Reports 9i,Informatica, Perl, and Sun Solaris

COM - FROM DEC 2004 – FEB 2005

Client Regency Pharmaceuticals, Atlanta, GA

Project This system speeds up order processing, streamlining functions such as customer quotations, pricing, order processing, acknowledgement handling, shipping and invoicing. It provides effective accounts management, rapid customer order processing and timely customer order delivery, which in turn help to improve customer service. The main modules of the application are Account Management, Customer Order Processing , and Shipping & Distributions.

Role Oracle/Forms Developer

Responsibilities

 Involved in complete software development life cycle.

 Gathered the business requirements by interacting with users.

 Developed Stored Procedures using Oracle PL/SQL packages, procedures, functions

 Upgrade Sybase SQL Server in sun solaries.

 Involved in Oracle Business Process Design.

 Involved in System test planning and execution.

 Identify Business rules that are to be incorporated into the system.

 Used Korn Shell scripts to automate Oracle import/export.

 Programmed Order Entry GUI application with FORMS 4.5.

 Developed over 21 commercial application reports using REPORTS 2.5 and FORMS 4.5 for Order Entry application.

 Applied optimization methodologies in Entity Relationship Diagram (ERD) to normalize a Relational Database.

 Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica Designer.

 Tuned SQL by using Explain Plan, TkProf, Indexing and Hints. Changed existing logic within the packages for optimum Performance.

 Involved in unit testing and integration of application.

Environment Oracle 9i, 10g (SQL, PLSQL), Forms 4.5 , Reports 4.5, TOAD, Discoverer

INTELLECT CARDS - FROM NOV 2003 – NOV 2004

Client Polaris Software Lab Ltd

Project Intellect Cards – Fraud Early Warning System of Credit Cards: This module of the Credit Cards Product help the bank to detect and protect fraudulent activities against both merchant and card holders. There are a set of parameters set in this module and the cards and merchant activities are validated against these maintained parameters and decisions and actions will be taken accordingly.

Role Pro*C /Oracle, UNIX Developer

Responsibilities

 Conducting requirement analysis, solution design and development.

 Creation of E-R diagram and Data Flow diagrams.

 Create functional & technical specifications for Data entry Screens and Reports.

 Pro*C and PL/SQL Programming.

 Data Migration.

 Generate Reports using Pro*C PDF utility

 Conducting User Training.

 Unit and Integrity Testing.

 Prepared Uses case.

 Coordination with In-house Support team for critical problem resolution.

 Worked as a part of a team and provided 7 x 24 support when required

Environment Oracle 8i / 9i, PL/SQL, Sybase, Forms 4.5 , UNIX Shell Scripts, Pro*C and Sun Solaris

INTELLECT CARDS – BILLING AND CUSTOMER Care From Dec 2002 – Nov 2003

Client Polaris Software Lab Ltd

Project (1) Intellect Cards – Card Booking: This module of the Credit Cards Product help the bank to process the incoming applications for fresh cards. The system validates the users input, perform the credit scoring of the customer and if all the criteria’s are satisfied then the card is generated. The system has an interface with an external system to generate the PIN and TPIN numbers

(2) Intellect Cards – Customer Services: This module of the Credit Cards Product help the bank address all the customer queries in the call center. This module also handles the closure, renewal and reissue of cards. This module has the facility of increasing the credit limit of the card. There will be a screen available in this module where all the financial activities of the card are displayed.

(3) Intellect Cards – Billing and Customer Payments: This module of the Credit Cards Product help the bank to process all customer statements. The module contains programs that run EOD and EOM. The billing engine will calculate all the interest accrued by the customer and knock off all the payments and calculates the minimum payment due and the total amount due for the customers and generates the statements. The customer payments module tracks all the payments received from the customer.

Role Pro*C /Oracle, UNIX Developer

Responsibilities

 Involved in getting the User Requirements, Data Modeling & Development of the system.

 Creation of E-R diagram and Data Flow diagrams.

 Involved in designing the Primary & Foreign Key for the objects in the schema.

 Creating functional & technical specifications for the Data entry Screens and the Reports.

 Involved in writing programs using Pro*C and PL/SQL

 Conduct training for HR & Payroll users to enhance their skills.

 Creation of Data entry screens and reports.

 Migration of data

 Documentation for the system

Environment Oracle 8i / 9i, PL/SQL, UNIX Shell Scripts, Pro*C and Sun Solaris

ORBI CREDIT CARDS - FROM SEPT 2001 – NOV 2002

Client Coastal Tech Solutions (P) Ltd

Project Credit Cards Project – Orbi Tech Solutions (P) Ltd.: This project deals with various modules of the Citibank India, Credit Cards. The functional specifications will be provided by the business analyst’s team of Orbi Tech solutions.

Role Oracle Developer

Responsibilities

 Involved in getting the User Requirements, Data Modeling & Development of the system.

 Creation of E-R diagram and Data Flow diagrams

 Involved in designing the Primary & Foreign Key for the objects in the schema.

 Involved in developing code for banking projects using Pro*C and Oracle as backend.

 Creation of Data entry screens and reports.

 Has actively participated in unit testing and system integrated testing.

 Documentation for the system

Environment Oracle 8i / 9i, PL/SQL, UNIX Shell Scripts, Pro*C and Intel Solaris

Contact this candidate