Summary:

• Over 11+ years of IT professional experience in Analysis, Design, Development and Testing of Business/Application software in Client/Server Architectures
• Active involvement in all phases of Software development life cycle (SDLC) such as gathering Business Requirement, System Analysis, Design & Data Modeling, Proof of Concept, Development, Unit Testing, UAT, Deployment, User Training & Support.
• Over 5+ years of experience on OBIEE 10.1.3.x/Siebel Analytics 7.x in working with designing Dashboards, Answers, Administration Tool, Report Bursting, OBIEE iBots, Analytics RPD and BI Publisher Reports. Strong understanding of ETL, OLAP, Star Schema, Data Modeling using Normalization, Business Process Analysis, Dimensional Data Modeling, FACT & Dimensions tables, Physical & Logical Data Modeling , Aggregate persistence wizard. Strong working knowledge in Metadata modeling in all three layers (physical, BMM, presentation). Experience in developing various dynamic and interactive complex reports/dashboards with intuitivedrilldowns, drill-acrossand drillable charts using Answers. Mastery in configuring Security settings in OBIEE Administration Tool to setup Groups, Access Privileges and Query Limits.
• Expertise on the entire lifecycle of EBS Solutions (Oracle Apps 11i (Oracle AP, GL, ALERTS, CRM (Tele Service, Field Service, Contract Management, Depot Repair), Install Base and TCA (Treading Community Architecture. Creating Users, Responsibilities, Request Sets, Request Groups, Profile Options and registering Executables, Concurrent Programs, Form Functions, Reports by using Application Object Library (AOL), Alerts and System Administration modules.
• Expertise in Oracle Fusion Middleware - Oracle Application Integration Architecture (Oracle AIA) supporting SOA, Oracle SOA Suite, Oracle BPEL, Oracle ESB, Business Process Manager, Business rules manager, deploying and debugging.
• Expertise in writing PL/SQL Packages, Procedures, Functions, Triggers, Implementation and Customization of Developer2000 (Forms 9i/6i/4.5 and Reports 9i/6i/2.5), Forms Personalization, Oracle Designer (Database Design), Oracle Discoverer, Uniface Forms & Reports, XML Publisher Report, SQL*Plus, Custom.pll, Oracle Workflow. Oracle Alerts, Creating and maintaining Database Objects like Tables, Views, Indexes, Constraints, Sequence, and Synonyms etc..
• Experience in Oracle Interface and Conversion from Legacy System to Oracle using SQL*Loader, Data Load.
• Experience in Project Planning like Requirement gathering, implementation, Testing (DIT & SIT), Production move process and production support.
• Having strong Project Management experience in the full life cycle (kick-off meetings, Requirements definition, effort estimates, client approvals, Solution design –Statement of Work/Business requirement documents, Configuration and release planning - time scaling for all projects, man hours, testing to ensure quality and timely deliverables, Approving test plans, Coordinating UAT with the client. Taking a sign-off and ensuring project successfully implemented as per the timelines.
• Worked on Pre Sales Activities like Business Process Analysis, project estimations and solution designs (pre-sales & as part of gap analysis in implementations), project execution.
• Providing Documentation for customizations and implementation using AIM methodology.
• Self-motivated, excellent team player with proven leadership skills. Excellent communication and interpersonal skills.

Technical Skills highlight:

• BI Tools: Siebel Analytics 7.8,OBIEE 10.3.1,OBIEE 10.3.4.1,OBIEE 11g,OBIEE

Apps, BI Publisher.

• ERP: Oracle Applications- R11i (AP, GL, ALERTS, CRM (Tele Service, Field

Service, Contract Management, Depot Repair and Install Base), MAKESS 5.0 ON THE NET, EBIZFRAME 6i, Warehouse Management System (Red Prairie), AVALON 9.2.

• RDBMS: Oracle 10g/9i/8i/8.X & 7.X, Teradata, MS SQL Server2000.
• Language & Tools: Oracle Developer 2000(Form 9iDS/9i/6i/4.5 and Reports 9iDS/9i/6i/2.5),

Uniface 2.5 Forms & Reports, Oracle Discoverer 4.1.37, Oracle Designer
2000/6i, SQL* Plus, PL/SQL, PL/SQL Developer 5.0, TOAD 6.0, MQ Series, SQL Navigator, SQL*Loader, Minitab 13.30, AppWorx 5.1,
Autosys, BPEL Designer 0.9.5 & BPEL Process Manager 2.0.10, XML Publisher, E-text Report, Cobol, Turbo C, Turbo C++, Pro*C.

• Quality Application: Reliability Application System, SSR & DFSSR Reporting and D3 Reporting.
• Operation System: UNIX System V, IBM CISC 32/ 64 bit, Sun Solaris 8.0(64-

Bit), Window’s XP, Window’s NT, Window’s 2000 Professional / Server, DOS 6.22. Oracle 11g.

• Hardware Skills: IBM AIX UNIX Machine, Sun Enterprises 250 Server 2 CPU Sun Ultra

Sparc2 Processor, HP 9000, DEC 2100, DEC 2000, Unisys U6K / 520.

• Project Mgmt Tools: Microsoft Project Office, Microsoft Visio and Erwin.

• Conf. Mgmt Tool: Microsoft Visual Source Safe, SVN and PVCS.

Professional Experience

Project#: 1
Client:Confidential,NC- USA Oct.’2008 – Till Date.
Confidential,has been helping those in the academic, medical, cultural and research fields plan for and live in retirement. They do this with a full array of financial products and services to help them live to and through retirement and invest for life\'s other goals along the way. In keeping with their strong nonprofit heritage, offer low fees,* a long-term approach to investing, and a full line of financial products and services provided by consultants who never receive commissions. Instead, they are compensated primarily on how well they serve you, not what they sell you.

Role: Working as a Tech lead, involved in implementation of various OBIEE Projects starting from Project planning to Production Warranty Support, involved in major development like Database Design (Oracle, Teradata & Sql Server), iBot setup, Dashboard, RPD Modeling, Integration with Oracle DB & Data Stage job and XML Publisher Reports in various formats like PDF, HTML, XLS, e-Text etc. Bursting Process, Various Autosys Jobs (jil file) Oracle Stored Procedure, Package and Function.
Responsibilities:
Working with the following responsibilities:

• Installed the OBIEE components on both the windows and LINUX systems.
• Involved in developing the OBIEE process design document.
• Involved in identifying the data sources and the granularity level of data populated in the sources.
• Built metadata in the analytics repository using OBIEE Administration Tool in physical, business and presentation layers.
• Created dimensional hierarchies.
• Developed Time Series measures for comparing the various case types of service requests between the months/quarters/years.
• Created connection pools, imported physical tables and defined joins in the physical layer of the repository.
• Worked on the administration of configuration files.
• Implemented Basic Security and LDAP server Authentication.
• Worked on OBIEE High Availability feature for the clustering of BI server.
• Implemented the data and object level security for the different groups of the organization.
• Implemented MUD environment so that multiple developers can work on single repository.
• Implemented security using Security Manager in OBIEE Admin tool to setup users, Groups and Access privileges.
• Generated Reports and Dashboards by using Report features like Pivot tables, charts and view selector.
• Created dashboards with global prompts, column selectors, navigation links, and automatic drill-down.
• Created session variables to implement the Authorization for different users/groups.
• Worked on OBIEE publisher to publish the reports and dashboards to the users in different formats.
• Worked with OBIEE Delivers for sending real-time, personalized alerts via intelligence agents (iBots) to intelligence dashboards for subscribed users.
• Worked on troubleshooting at the system level including performance, network connectivity, and security.
• Documented the Developed design for intuitive understanding and future reference.
• Worked closely with Users, Developers to resolve ongoing Production issues by reviewing design changes made to production systems and made corresponding changes to Repository.
• Worked on Oracle Stored Package, Procedure, Function & Triggers for integration.
• Jil file Creation for various Autosys Jobs and Autosys Jib setup.

Environment: Oracle BI 11g, Oracle BI (10.1.3.4), Oracle 10g/11g/11i, Oracle BI Publisher, Teradata, Oracle Designer 2000/6i, PL/SQL Developer, Visio, Windows-NT and UNIX, XML Publisher, E-text Report, Visual SourceSafe 6.0, SQL* Plus, TOAD VI, Star Team etc.

Project#: 2
Client: Confidential,Green Bay, WI- USA Mar.’2008 – Oct.’2008.
Confidential,is a leading provider of transportation, logistics and related services. Schneider National serves more than 80 percent of the Fortune 500® companies, offering the broadest portfolio of services in the industry. Schneider National\'s transportation solutions include one-Way, Intermodal, Dedicated, Bulk, Transportation Management, Transloading Services, International Services and Schneider Payment Services. Schneider Logistics, a wholly owned subsidiary of Schneider National, provides supply chain management technology, managed services, engineering services and freight payment. With headquarters in Green Bay, Wis., Schneider National has a 70-year record of accomplishment of providing expert transportation and logistics solutions.

Role: Involved in implementation of Oracle Application Rel.12 Financial (GL, AP), HRMS, TCA and OTM Modules. Major roles were to develop Interface between Legacy system and Oracle in Fusion Middleware technology, Developed various XML Publisher Reports, DVM Created for the various applications those are interacting with Oracle Apps.
Responsibilities:
Working as Sr. Consultant with following responsibilities:

• Requirement gathering and client problem identification matched to Oracle module functionality. GAP /FIT Analysis.
• Creation and reviewing of Functional and Technical design i.e. MD-50. MD-70, BR100/Business Requirement Document.
• Customization of existing workflow and creation of new business events for tasks.
• Developed various reports as of the user specifications using XML Publisher.
• Preparing various BPEL Components for interfacing oracle and legacy system.
• Integration and data transformation through Oracle Data Integrator.
• DVM’s Definitions for Supplier Outbound Elements.
• MQ Series setup between Legacy and Oracle system.
• Preparing pre approval process for different tasks.
• Creating Packages performing the various tasks.
• Oracle Alerts creation on Supplier insert and update.
• Developed Invoice interface between Oracle OTM and Oracle Payable through BPEL Process.
• Wrote PL/SQL Packages, Forms Personalization for Supplier Interface.
• Sending the Real time Creates and Updates of Suppliers in AP to different legacy systems through SOA suite.
• Implemented synchronous AIA ABCS processes in BPEL
• Implemented asynchronous processes in BPEL
• Implemented Dynamic Business Rules
• Implemented fault handling in AIA ABCS BPEL process
• Virtualizing BPEL orchestration end points through oracle ESB
• Invoked JCA adapters in BPEL
• Invoked web services from BPEL
• Made changes in Custom.pll, Setup Value sets, developed Concurrent Programs, Made changes in existing Forms.
• Tax setup in HRMS and daily load from legacy system to Oracle for all the parties.
• Supported the implemented Receivable and Payables modules, which involved daily issues and new customizations and enhancements based on the changing requirements in the system.
• Writing Packages, Stored Procedures & Functions, Form Personalization, Setup Profiles, Form Personalization, Oracle Forms (6i).
• Raising TAR with Oracle Support and Coordinating with Onsite Team and End Users on resolving Functional Setup issues.

Environment: Oracle 10g, Oracle Application EBS Rel.12 Financial – (AR, AP & GL), OTM, HRMS, Oracle Data Integrator, Oracle Workflow, Oracle SOA Suite 10.1.3.1, XML Publisher, MQ Series, Developer/2000 Forms 6i, Reports 6i, Oracle SQL Developer, SQL PLUS, TOAD VI.

Project#: 3
Client: Confidential,USA Sept.’2007 – Feb.’2008.
Confidential,provides transformational medical technologies and services that are shaping a new age of patient care. Expertise in medical imaging and information technologies, medical diagnostics, patient monitoring systems, performance improvement, drug discovery, and biopharmaceutical manufacturing technologies is helping clinicians around the world re-imagine new ways to predict, diagnose, inform and treat disease, so their patients can live their lives to the fullest. GE Healthcare\'s broad range of products and services enable healthcare providers to better diagnose and treat cancer, heart disease, neurological diseases, and other conditions earlier.

Role: GE Optio Retirement project implemented for migration of all Optio reports into XML Publisher reports. The main aim of this project is to migrate all Optio Reports into in XML Publisher Reports and some new reports development. I was involved in Optio Analysis and Column Mapping, Developing XML Publisher Reports for Various Modules, Test Plan creation and Execution, Data extractions, Preparing document sets for some reports, Developing Wrapper procedures to call standalone reports and multiple copy print with duplicate print option.
Responsibilities:

• Working as Team Lead with following responsibilities:
• Understanding the business processes from client.
• Initiation and planning of Development, Debugging and Testing, Quality Assurance, Configuration Management and Documentation of the various phases in a project life cycle.
• Creation and reviewing of Functional and Technical design, MD-63. MD-64, BR100/Business Requirement Document, Test scripts as a result of Integration.
• Preparing Draft version of Performance Technical document (MD70).
• Maintaining Project Plan, Project Tracking Sheet, GE Workflow Process and Daily Activity Sheet.
• Daily Client Interaction, preparing MOM, WSR, Project Development Status Report.
• Preparing Testing documents for each report. Parameters Extraction.
• Developed Wrapper Procedures for Standalone XML reports.
• Developing D2k reports (Reports 6i) for new XML reports.
• Customization in existing reports for developing merging reports.
• Monitoring Mercury Quality Center for TD Status Report and TD Assignments to the developers.
• Maintain visual source safe used for a code backup and daily activities.

Environment: Oracle 8i, Oracle Application EBS Rel.11.5.7 AR, AP, GL, INV, PO, XML Publisher, Developer/2000 (Reports 6i), SQL*PLUS, TOAD VI, VSS, Mercury Quality Center, Microsoft Project Office.

Project#: 4
Client: Confidential,USA Mar.’2007 – Sept.’2007.
Confidential,is one of the world\'s leading suppliers of power generation and Energy delivery technologies in all areas of the energy industry including coal, oil, Natural gas an nuclear energy as well as with renewable resources such as water, wind, solar and alternative fuels. GE works closely with customers to achieve mutual growth and success. They work in tandem with governments and communities to manage complex international relationships and develop critical infrastructures. They also work intimately with suppliers, enabling them to become extended GE factories and platforms for accelerated globalization. Through these powerful partnerships, they create innovative products and technologies that serve the world\'s people.

Role: GE MARS System implemented for integration between the ESGAP and FRMT System and these systems are integrated with third party tool GOET (Global Order Entry Tool) and GMT (Global Management Tool). I was involved on various interfaces like GEPS Extract SR and Tasks to FRMT, GEPS FRMT SRs & Tasks Inbound Interface, GEPS Extract JAS Information to FRMT, GEPS FRMT JAS Inbound Interface, GEPS Task Assign Outbound Interface, GEPS Task Assignment Interface Request Set, GEPS FRMT Task Synchronization Inbound Request Set etc. written to complete these activities. New reports developed like Error log, Task status, Service request status etc. through XML Publisher.
Responsibilities:

• Working as Tech Lead with following responsibilities:
• Understanding the business processes from client.
• Analysis of the specifications provided by the clients.
• Defines functional and non- functional requirement of the system in detail.
• Involved in writing Technical Specification Documents.
• Design Custom Tables Structure for FRMT and ESGAP System.
• Involved in development of new Reports using XML Publisher.
• Form Personalization and Code written on Custom.PLL.
• Written Interface programs for Inbound and outbound Process both side (FRMT and ESGAP System).
• Setups like resources definition, DFF, Territories, Groups. Concurrent Programs etc.
• Designed highly complicated D2K Reports using all-important typical features Of Reports 2.5 like Placeholder & Formula columns, conditional Report Layouts, Group filters etc.
• Writing Packages, Procedures and functions for interface program.
• Responsible for overseeing the Quality procedures related to the project.

Environment: Oracle 9i, Oracle Application EBS Rel.11.5.9 CRM (Install Base, Service Request, Depot Repair), Financial (GL & AP), Oracle Designer6i, SQL Developer, XML Publisher, Developer/2000 (Forms6i, Reports 6i), and SQL*PLUS, PL/SQL Developer 5.0, TOAD VI, Microsoft Visio Professional.

Project#: 5
Client: Confidential,USA Sept.’2005 – Feb.’2007.
Confidential,is listed as the 15th largestorganization in the world on the 2006 Fortune Global 500 list (based on revenues). AXA Life Insurance Company (formerly The Equitable Life Assurance Society of the United States) is a leading financial protection company and a premier provider oflife insurance, annuity, andinvestment products and services.

Role: Confidential,implemented for the communication between the Dell Oracle help desk and a customer help desk for the entire life of a service request and accounting with Financial Module. My Involvement was to implement the various CRM- (Tele Service, Field Service, Contract Management, Depot Repair and Install Base) and Financial – (AR, AP, FA, GL) module.
Responsibilities:
Working as Development Lead with following responsibilities:

• Interaction with Business and Segments, Database designing, MD070, MD050, Process Documents.
• Package written for GL and Invoice Interface.
• Customization of existing workflow and creation of new business events for tasks.
• Concurrent Program and request set.
• Worked on Custom.pll for validation, enabling zoom functionality etc.
• Developing Reports with the help of Discoverer Tool and Trained to the team members.
• Writing Packages, Stored Procedures & Functions, Form Personalization, Setup Profiles, Form Personalization, Oracle Forms (6i).
• Preparing Test Cases for DIT, SIT and UAT.
• CMC and QCO Role Played

Environment: Oracle Application EBS Rel. 11.5.9 Financial – AR, AP, FA, GL, CRM- (Tele Service, Field Service, Contract Management, Depot Repair and Install Base), Oracle Discoverer 4.1.37, D3 Reports Tool, Workflow, Oracle Designer6i, Developer/2000 (Forms 6i), XML Publisher, SQL*PLUS, PL/SQL Developer 5.0, TOAD VI, Workflow Builder, Citirix Environment, Microsoft Visio Professional.

Project#: 6
Client: Confidential,USA Aug.’2004 – Sept.’2005.
Confidential,a global power leader, is a corporation of complementary business units that design, manufacture, distribute and service engines and related technologies, including fuel systems, controls, air handling, filtration, emission solutions and electrical power generation systems. Headquartered in Columbus, Indiana (USA), Cummins serves customers in approximately 190 countries and territories through a network of more than 500 Company-owned and independent distributor locations and approximately 5,200 dealer locations.

Role: Involved in implementation of Oracle Application Rel. (11.5.10.2) Financial Module and involved in development of SSR and DFSSR Quality application System.
Responsibilities:
Working as Team Leader with following responsibilities:

• Leading a team to successfully deliver enhancement requests from the client
• Created Functional Documentation at Client site by understanding their requirement
• Created Data Flow Diagram and Entity Relationship Diagram.
• Database designing for SSR and DFSSR.
• Making the High Level design and documentation
• Deciding on the software architecture and configuration
• Writing Packages, Procedures, Function, AppWorks Scripts and Scripts for Data Loading.
• Involved in setup of Set of Books (Chart of Accounts, Calendar and Currency).
• Setup organizations and set of books in a multi org structure, including carrying out consolidation and translation in primary and reporting set of books before switching to multi org. Imported requisitions using Core Purchasing interface tables.
• Setup of chart of accounts structure, segment, values sets, flex fields and segment qualifiers, cross validation rules, security rules, calendar, currencies, set of books, assigning set of books to a responsibility, setting up standard journals, statistical journals, recurring journals and suspense accounts and mass allocation, defining financial statement generator, creating ad-hoc reports, and open and close accounting periods
• Defined invoice attributes such as payment terms, approve, hold and release and distribution set, special calendar for recurring invoice, payment terms and payable quick codes, entering supplier and site information, payment attributes- payment formats, bank account, payable documents, tax code, rates, groups and withholding tax, open/close of payable accounting periods, and payable transfer to GL
• Raising TAR with Oracle Support and Coordinating with Onsite Team and End Users on resolving Functional Setup issues.
• In GL module, performed Journal import process. In this Process the data is imported into GL interface tables using sql loader.
• Involved in financial conversions, which included data gathering from the client, validation and upload into Oracle.
• Development and customization of various forms, reports.
• Designing and developing database objects like tables, views, stored procedures, triggers, indexes etc.
• Active member of the review group for the entire life cycle of the implementation.

Environment: Oracle Applications EBS (11.5.10.2), Oracle Designer2000/6i, Developer/2000 (Forms 6i, Reports 6i), SQL*PLUS, PL/SQL Developer 5.0, XML Publisher TOAD VI, Autosys, AppWorx 5.1, Minitab 13.30, Remedy Users, Citirix Environment, Visual Source Safe.

Project#: 7
Client: Confidential,India Jan.’2004 –Aug.’ 2004.
Confidential,is India\'s largest Fast Moving Consumer Goods (FMCG) Company. HUL\'s brands are household names across the country and span a host of categories. Products are manufactured over 40 factories across India and the associated operations involve over 2,000 suppliers and associates. Hindustan Unilever Limited\'s distribution network comprises about 4,000 redistribution stockiest, covering 6.3 million retail outlets reaching the entire urban population, and about 250 million rural consumers.

Role: Involved in implementation and customization of Oracle Warehouse Management, Inventory and
Purchasing Module.
Responsibilities:
Working as Team Leader with following responsibilities:

• Database Designing, ERD.
• Functional Specification, Technical Document, Test Cases, Reengineering on code.
• Database pursing, VSS Control.
• Documentation and Client Interaction.
• Forms and Reports designing on Uniface 2.5.
• Creation of HHT files, Master data uploading for new location, Package to support integration of Digital Logistics and ERP.
• Developing complex forms and reports, Packages, Triggers, Procedure and Functions etc.

Environment: Oracle 9i, Developer/2000 (Forms 6i, Reports 6i), and SQL*PLUS, PL/SQL Developer 5.0, TOAD VI, Uniface 2.5 form and Reports, MQ Series, DLx Integrator, Oracle Discoverer.

Project#: 8
Client: Confidential,India Mar.’2002 –Dec.’2003.
Confidential, is the No.1 provider of integrated business, technology and process solutions on a global delivery platform. Wipro is a globalservices providerdelivering technology-driven business solutions that meet the strategic objectives of our clients. Wipro has 55+ ‘Centers of Excellence’ that create solutions around specific needs of industries. Wipro delivers unmatched business value to customers through a combination of process excellence, quality frameworks and service delivery innovation. Wipro is the first global software company to achieve Level 5 SEI-CMM, the world\'s first IT Company to achieve Six Sigma, as well as the world\'s first company to attain Level 5 PCMM.

Role: Involved into development from scratch new ERP and worked on Inventory, Purchasing Module.
Responsibilities:
Working as Module Lead with following responsibilities:

• Preparing Functional Specification, ERD, Proto, DBD.
• Prepared Technical and Functional Design Document.
• Very high level of PL/SQL programming.
• Dynamic LOV, Programmatically Record Group handling.
• Object Orientation using Reference Form.
• Developing Forms 5.0 Library to use as common object.
• Wrote Stored Package & Procedure
• Creating Tables, Views, Sequences, Indexes etc.
• Wrote Database Triggers
• Responsible for development Material Module, DBA activities on Database sever,
• Backup Server and Application Server for Dubai Dry Dock Shipping Corp.
• Preparing WSR, Daily Activity Report, Task Assignment, Quality Management.
• Handling Visual Source Safe Repository to maintain the versions of all documents.
• Client Interactions and Process Documentation.

Environment: Oracle 9i, Developer/2000 (Forms 6i, Reports 6i), Oracle 9i AS Infrastructure, Oracle Designer 2000, SQL*PLUS, PL/SQL Developer 5.0, Visual Source Safe.

Project#: 9
Client: DConfidential,India Jan.’2001 – Mar.’2002.

Confidential,is a global leader in the design, manufacture and marketing of advanced networking, broadband, digital, voice and data communications solutions. D-Link continually meets the global networking and connectivity needs of digital home consumers, small office professionals, small- to medium-sized businesses, and enterprise environments. D-Link\'s core competency is in Ethernet connectivity.

Role: Involved in development and implementation of Ebizframe 6i(ERP) Inventory, Sales, Finance and HRMS Modules.
Responsibilities:
Working as Team Lead with following responsibilities:

• Responsible for system study, preparation of Data Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, Table Structures, Screen Designing, module identifications and preparation of technical write up on the proposed system.
• Identification of codes and classes those are common across all other business specific modules.
• Optimize common codes, Resolve technical lapses, provide Development startup environment.
• Coding, debugging and testing of the various modules implemented,
• Customization of forms and reports as per the requirement of the system.

Environment: Oracle8i, Developer/2000 (Forms4.5, 6i, Reports6i), SQL*Plus, PL/SQL, SQL* Loader,
PL/SQL Developer, TOAD, Oracle Designer 2000/6i.

Project#: 10
Client: Confidential,India Aug.’1999 – Jan.’2001.

Confidential,is a leader in providing turnkey solutions in the field of High Voltage Power Transmission Lines and Substations. With around 30 years of proven experience. Jyoti Structures Ltd. is one among very few companies worldwide, which possess the capabilities to execute total turnkey jobs that involve setting up both transmission lines and substations.

Role: Involved in development and implementation of Ebizframe 6i (ERP) Financial and HRMS Module.
Responsibilities:
Working as Team Member with designing and development team and with following responsibilities:

• Responsible for understanding the present manual system, requirement study.
• Responsible for system specifications, system designs, coding, testing, training the users and implementing the system.
• Designing includes preparation of flow charts, entity relationship diagrams, designing table structures, normalization of tables.
• Data Import from Legacy system to Oracle table by using SQL* Loader.
• Wrote PL/SQL Packages, Procedures, functions and Triggers on various finance Module Tables.
• Customization forms and developed new reports.
• Defined Batch jobs those were running on daily and weekly basis.
• The responsibilities during the implementation were to migrate and convert the data from legacy system to new systems tables as per the new structures, and testing the validity of data.

Environment: Oracle8i, Developer/2000 (Forms4.5, 6i, Reports6i), SQL*Plus, PL/SQL, SQL* Loader, PL/SQL Developer, TOAD, Microsoft Visio.

Education

• Master of Computer Application (M.C.A.)
• Bachelor of Science (Computer)

Employment Details:

• Confidential,USA from Dec.’2009 to Till Date as Sr. Consultant.
• Confidential,USA from Oct.’2008 to Nov.’2009 as Sr. Oracle Apps Consultant.
• Confidential,USA from Feb.’2007 to Oct.’2008 as Sr. Technical Consultant.
• Confidential,from Sept.’2005 to Feb.’2007 as Sr. Soft. Development Engineer.
• Confidential,from Aug.’2004 to Sept.’2005 as Sr. Software Engineer.
• Confidential,from Jan.’2004 to Aug.’2004 as Sr. System Analyst.
• Confidential,from Aug.’1999 to Dec.’2003 as Sr. Software Engineer.