PROFESSIONAL SUMMARY:

• IT Professional
• Worked with 11i and R12 apps, Reports 6i and 11g, BI Publisher
• Capable of building customized SQL queries and PL/SQL programs
• Experienced in developing ETL process
• Migrated/converted reports from MS Access and SQL Server to Oracle
• Experienced in developing document
• Proven results - oriented work ethic

TECHNICAL SKILLS:

Databases: Oracle8i, 9i, 10g, R12, MS Access, SQL Server

Application/Reporting Tools: R12 BI Publisher, SQL Developer, Forms/Reports 6i, TOAD, Discoverer 3.1

Database Management Tools: SQL*Plus, OEM, STATSPACK, Oracle scripts, DBCA, RMAN

Oracle Migration Tools: Import/Export Utility, SQL*Loader, DataLoader

Languages: SQL, PL/SQL, XML, XSLT

Oracle11i AppsOM, AR, AP, WMS

Operating Systems: Windows NT/2000/XP, UNIX, MS-DOS

Others: MS Office Tools 2000, Acrobat Frame Maker

PROFESSIONAL EXPERIENCE:

Confidential, Burbank, CA

Contract - Data Analyst

Responsibilities:

• Supported Consumer Information Management Platform (CIMP and the emerging CIMP 2.0) solutions which is a key resource supporting Confidential ’s Marketing and Sales Analytics, Reporting and Operations organizations
• Worked with Engagement Manager, other Business Analysts/SMEs and KPIT staff to ensure appropriate solutions are delivered
• Utilized SQL and PL/SQL queries to retrieve data for analysis
• Recommended basic data oriented solution alternatives to address business problems
• Worked on the ticketing system with business, third party vendor and KPIT partners to ensure that appropriate data is captured, structured and made available to business users
• Reviewed documentations of existing and future processes
• Documented ETL processes in the file share folder

Confidential, San Dimas, CA

Contract - Database Developer

Responsibilities:

• Re-engineered the debit card tracking database from MS Access to Oracle
• Migrated existing reports from MS Access and SQL Server databases to Oracle
• Converted T-SQL queries from SQL Server to Oracle PL/SQL
• Developed complex database objects such as stored procedures, functions and packages using SQL and PL/SQL
• Worked with business users, programmers, UI team and database administrators during transition from MS Access and SQL Server to Oracle
• Converted MS Access and SQL Server SQL queries to Oracle
• Created PL/SQL programming code using advanced concepts of Records, Collections, Dynamic SQL and ref cursors
• Involved in performance tuning
• Migrated MS Access objects such as queries and macros into Oracle
• Performed data analysis/validation of different databases
• Supported daily report issues
• Worked in a Scrum environment

Confidential, Pasadena, CA

Contract - Oracle Developer

Responsibilities:

• Worked on converting 130+ customized reports from 6i to 11g
• Converted reports are used by a third party apps called EPersonality
• Upgraded SQL queries in the reports for additional business logic
• Added PL/SQL logic in the reports for additional functionality
• Performed SQL tuning on a number of reports to enhance performance
• Troubleshoot report issues and found fixes
• Re-formatted report layout for additional fields and images
• Added report parameters to coincide with application parameters
• Proactive in learning EPersonality features especially from a developers perspective
• Developed forms in EPersonality for reporting application: function (IMFN), parameter (IMPM) and design (IMFD)
• Developed a manual for users on the usage of the reports

Confidential, El Segundo, CA

Oracle Developer

Responsibilities:

• Supported 11i Apps with 9i server and R12 with 11g server
• E-Business Suite Apps include Order Management(OM), Accounts Receivable(AR), Accounts Payable(AP), WMS
• Programming languages and tools: SQL, PL/SQL, Oracle BI/XML Publisher, Oracle Reports 6i and 10g, Discoverer
• Built customized PL/SQL programs for departments such as marketing, web, financial, operations and customer care
• Developed ETL processes for data feeds originating from third-party sources
• Worked with marketing team to write queries to pull lists needed for marketing campaigns from multiple data sources
• Developed customized BI XML publisher documents/reports during implementation of R12
• Utilized APIs to import customer and order information
• Designated as an SME for marketing campaigns
• Supported Datawarehousing team to mine repositories with SQL queries
• Involved in full development life cycle from data modeling to production
• Supported OBIEE team to provide back-end programs
• Developed a customized CRM software for marketing campaigns
• Fulfilled various departmental ad hoc requests using SQL and PL/SQL
• Unix/Linux Shell scripting for FTP protocols and data transfer processes
• Executed Oracle database administration commands such as CREATE, ALTER, DROP, DDL and DML
• Developed data models and performed data analysis, data cleaning, data migration, and data conversion
• Strong Oracle DB and PL/SQL application development skills and excellent knowledge of stored procedures,
• Strong problem solving, interpersonal and communication skills
• Analyzed situations, identify problems, and recommended solutions
• Ability to work independently or as part of a team
• Performed production deployment support, performance tuning and trouble shooting of DB related issues
• Able to learn new technologies and processes quickly
• Experienced with data analysis, data modeling process, modeling and system development life cycle methodologies
• Developed and ensured adherence to standards for program and system documentation
• Excellent written and communication skills

Confidential, Los Angeles, CA

Contract - Oracle PL/SQL Programmer

Responsibilities:

• Built programs to process raw data from different departments and import into various repositories
• UNIX scripting ftp data files into staging folders for processing
• Supported datawarehousing and form teams for SQL queries and PL/SQL
• Created objects for repositories, such as tables, synonyms, views, sequences, db links, jobs, stored procedures, packages, directory, triggers
• Utilized DBMS supplied packages and enhanced codes in existing systems
• Migrated table structures and data into production
• Documented technical processes of programs as dictated by standards

Confidential, Burbank, CA

Oracle Developer

Responsibilities:

• Enhanced existing procedural source codes as dictated by business rules
• Analyzed and used Constellar hub to ETL source data for datawarehousing
• Enhanced existing process of Constellar interfaces as dictated by business rules
• Modified UNIX script files
• Developed and executed AppWorx chains to schedule and run various modules
• Created test data to run and evaluate enhancements and interfaces
• Documented and produced test summary results