PROFESSIONAL SUMMARY:

• I have eighteen years of IT experience in varied capacities in all phases of SDLC including architecture and design in Oracle EBS, Oracle data warehousing, and Businesses Objects BI platforms. I have strong skills in - database design, data warehouse architecture, ETL processes, and development using Business Objects XI tools. I have extensive experience in SQL and PL/SQL coding, Shell scripting, Oracle performance tuning
• Business Objects reporting and in working with huge volume of data. I have worked in Confidential, Confidential, Government healthcare/Education industries and worked with Confidential, Confidential, Confidential - Confidential, Confidential, Confidential, Confidential - Confidential, and Confidential . I have worked as team lead, mentor and handled clients directly at various levels.

TECHNICAL SKILLS:

ERP Packages: Oracle EBS R12./11i, Oracle Federal Financials 10.7 (Financial Services Accounting Hub FAH,GL, Confidential, AR, PO, FA, XML Publisher (BI Publisher ), SysAdmin)

Databases: Oracle 10g/9i

Programming Languages: SQL, PL/SQL, Unix Korn Shell

Business Intelligence Tools: Business Objects XI R2/6.5 (DESKI,WEBI, CMC admin,Universe Designer, Import Wizard, LDAP security )Oracle Discoverer 3.i, Crystal Reports 10/XI

Development tools: Oracle Forms6i, Oracle Reports6i, Oracle DesignerOEM,SQL*Plus, TOAD, SQL Navigator, SQL*LoaderOracle Export/Import

Operating System: Sun Solaris (SPARC)5.9, HP-Tru64 5.1b, Windows NT

ETL Tools: Informatica Power Center Designer 7.3x,ODI

PROFESSIONAL EXPERIENCE:

Confidential

Sr IT Consultant

Responsibilities:

• Worked as a member of Data integration team on FEC's initiative to move legacy mainframe system to 3-tier architecture on Oracle database. Worked on data conversion, data integrity checks against business rules and data scrubbing . Loaded the converted data to Oracle database, and created reports to report on. Did the performance tuning of PL/SQL codes used for reporting. Converted many informatica mappings to PL/SQL code, ported an order management system to Oracle from legacy system . Currently working on an application that will help FEC to manage the prior notices generation and communication.

Environment: Oracle 11g R2,, SQL, PL/SQL, Visual Source Safe, informatica power center, Business Objects XI R2.

Confidential

Lead Application Development Analyst

Responsibilities:

• I led a team of developers in delivering complex custom XML publisher reports. I was responsible for tasks ranging from requirements gathering, up to delivery of reports to users in UAT. I served as SME for reports related business and technical issues. I was also involved in interfaces functional and technical design, deeply involved in performance tuning of interfaces and Reports. I am well versed with Oracle’s XLA (sub ledger accounting )module, XLA’s event based model, related standard APIs.I also did design and code reviews of other developers work.

Environment: Oracle R12 EBS, Oracle 11g, XML,XML publisher a.k.a BI publisher, SQL, PL/SQL,UCM, PVCS

Confidential

Application Architect

Responsibilities:

• Confidential servicing system with three-tier architecture and latest technology in order to help Confidential respond to changing market conditions faster, make quicker business decisions, save time and resources. SIR is a ‘class A’ financial reporting system that interfaces with 16+ systems, processing 2 TB data every day, with 100+ reports running on nightly basis.
• As a member of application architecture team, my achievements are:
• Reviewed many high level and detail level designs, reviewed of PL/SQL codes for coding standards and performance issues, created PL/SQL coding guidelines and Oracle best practices documents, lead a team from requirements to delivery of a complex Metadata management process, designed reporting architecture with database facts and dimensions tables, led a team in full life cycle of Business Objects Reports design and development effort, designed BO universes and developed very complex WEBI reports/crystal reports, and delivered solid BO security design.

Environment: Oracle 10g on Sun SPARC E25K, Business Objects XI R2 on Wintel, SQL, PL/SQL, AbInitio,Java,JSP

Confidential

Sr.IT specialist

Responsibilities:

• As an ETL specialist my primary responsibilities were processing multi-million records in flat files using Oracle tools and custom ETL codes using PL/SQL, Develop universes and business objects WEBI reports, setup security for users in Business Objects. As a senior member I served as mentor for junior oracle developers and lead the Data Integration team .
• I also served as DBA responsible for 24x7 operations and scalability of the project, my major accomplishments include: designed and created databases, created 6 BO universes, developed 40+ reports . I created a standby instance for the production database in a separate Unix server, installed Oracle 10g and upgraded existing Oracle 9i databases to Oracle 10g, created a test instance to test Oracle 10g upgrade process, managed storage, created user accounts, monitored performance, did logical backups, automated the whole ETL processes, optimized the codes - reduced the running time for many processes from days to hours.

Environment: Oracle 10g/9i, Business Objects XI/6.5, SQL, PL/SQL, MS Visio, Sun SPARC OS5.9, Dec Alpha Tru64 5.1b

Confidential

Oracle Apps Developer/SysAdmin

Responsibilities:

• AR receipts data into Oracle's Confidential and AR modules, built beneficiaries and providers interfaces (HIPAA 271, 274), did technical design reviews and code walk throughs, did CRP demos to the client's staffs, participated in peer reviews, unit tested and tuned interface and conversion programs. I built interfaces and conversions using custom APIs as well as standard APIs like TCA (Trading Community Architecture) APIs. I also worked as Sysadmin for multiple instances in Application Solution Delivery team. In my role as SysAdmin, I managed concurrent requests and setups, set user roles & responsibilities, managed TPR (Test Problem Report) build process request, monitored performance of instances and tuned concurrent programs for performance. I coordinated with ASPs, DBA team, developers, Testers and BR100 team to get the bugs fixed, promoted to test instances and tested the fixes.

Environment: Oracle e-business suite 11i (AR, Confidential, GL, PO, SysAdmin), Oracle 9i, SQL, PL/SQL Oracle Forms6i, Oracle Reports6i, Rationale Tools Suite (Requisite Pro, ClearCase, ClearQuest, Test Manager), IBM AIX

Confidential

Oracle Apps Developer

Responsibilities:

• Confidential: I designed and built conversion programs to convert - budget data, vendor data, purchase orders from legacy systems ; designed and built interface to transfer detailed General Ledger (GL) transactions from the legacy system, built a validation report and shell script to e-mail the report the client staffs; wrote programs to convert sub-ledger journals to GL journals; developed a customized 1099 report and developed customized forms, reports, packages to generate data file per IRS's specifications.
• I unit tested conversion and interface programs, participated in CRP (Conference Room Pilot) demos, and trained the client staffs. I was part of the production support team and responsible for cut-over activities. I also tuned - the GL conversion programs that took 6 days to complete to run within 3 hours.

Environment: Oracle Federal Financials 10.7 (AR, Confidential, GL, PO, FA), Oracle 9i, SQL, PL/SQL, Oracle Forms4.5, Oracle Reports2.5, TOAD, SQL Navigator

Confidential

-Data Warehouse Developer

Responsibilities:

• I designed and created database objects, wrote SQL*loader scripts to extract and load data from call traffic systems. I designed, built, and tested ETL processes using PL/SQL packages and procedures and Unix shell scripts. I did complex aggregations on huge volume of data and loaded data to data mart reporting tables; I tuned PL/SQL, SQL codes to process millions of records (~300 million), wrote shell scripts, created migration documents and supported migration of code to production. Interacted with business users to understand the report requirements and created reports. Additionally I served as a Junior DBA handling - logical backups, user creations, data migration between database instances.

Environment: Oracle8i, Oracle Discoverer 3i, SQL, PL/SQL, Sun Solaris

Confidential

Database Analyst

Responsibilities:

• Columbia was an e-commerce project developed to sell Confidential ’s products on-line. I created new database objects, as per new business requirements added enhancements to the existing schema objects and PL/SQL codes, loaded data from flat files to the database using SQL*loader, moved data from one system to another using Oracle export/import utility, supported production DBAs in migration work..

Environment: Oracle8i, SQL, PL/SQL, ErWin

Confidential

Responsibilities:

• I Worked on varied capacities from junior developer to system analyst in all phases of SDLC building custom applications like Warranty claim processing system for a Suzuki Motors subsidiary ; HRMS and Loan modules for RCTC - a financial institution ; Purchasing and Inventory and BoM(Bills of materials) for Salora - a leading Electronics consumer company. I designed data models, wrote PL/SQL packages, procedures, created forms and reports, migrated objects from Oracle 6/ Forms 3.0 to Oracle 7x and Developer 2000 platforms.

Education: B.S in Electronics and Communications Engineering