Data Migration Specialist Resume
AtlantA
SUMMARY
- 11 years of IT experience in analysis, design, development, customization and implementation of business using Oracle 11g/10g/9i/ 8x, PL/SQL, Forms 10g/6i/ 4.5, Reports 10g/6i/2.5, SQL*Loader
- Expertise in Business Process and Requirement Analysis, Impact Analysis, Conference Room Pilots, Design, Development, Testing, Cut Over and Post Production Support.
- Worked in Diversified environments in various sectors such as Service, Manufacturing, Energy, High Tech Services, Software, Oil, and Government Agencies.
- Have around 7 years experience in Production Support.
- Have 2 years of Financial industry experience
- 10 Years of Experience in PL/SQL Programming
- 3 years of UNIX shell script experience.
- Ability to communicate effectively at all levels in the Organization.
- Strong techno expertise includes but not limited to Discoverer reports, workflow, xml publisher reports and forms design, development and implementation
- Well versed in conversions, interfacing, and Reports
- Experienced in analyzing the information requirements, data mapping, and developing user - friendly open interface programs .
- Proficient in usage of Developer/2000 for both development and customization of several forms and reports as per client specifications with a good experience in back end programming
TECHNICAL SKILLS
OPERATING SYSTEM: MS DOS, Windows NT/ 95, Unix, HP-UX, SunOS, Sun Solaris 2.x, IBM AIX 5.1
Oracle Applications: R12/ 11i/ 11.x/ 10.x SC (GL, AP, AR, OE, INV, AOL, PO, OM, HR, QP, FSG, CE, Sys Admin, BPEL)
LANG/TECH: SQL, PL/SQL, SQL*Plus, Unix Shell Script, Java, XML, Workflow
DATABASES: Oracle 10G/9.x/8.x/ 7.x
SERVERS: WebMethods
TOOLS: MS Projects, EXCEL, VISIO, Kintana, PVCS, Clear Case, HPQC, Developer 2000, Forms,Discoverer, SQL*Loader, Oracle Warehouse Builder, TOAD,PL/SQL Developer, XML Publisher.
PROFESSIONAL EXPERIENCE
Confidential, Atlanta
Data Migration Specialist
Responsibilities:
- Used EDQ for cleansing and migrating external legacy data to Staging tables
- Used ETL process to migrate the data.
- Designed, Analyzed and Developed new programs for data migration using pl/sql .
- Developed Supplier, sites and contacts migration to oracle system using pl/sql program.
Environment: EDQ, Oracle12G,pl/sql,sql,Reports10g,Forms10g,Toad,UNIX, Share point, JIRA, XML Publisher.
Confidential, Atlanta
Oracle Consultant
Responsibilities:
- Designed, Analyzed and Developed new programs using pl/sql.
- Used Advanced PL SQL concepts in developing Packages, procedures and Triggers
- Performance Tuning of sql and pl/sql programs.
- Used EDQ for migrating external legacy data to Staging tables.
- Developed XML Publisher reports
- Created Unix Shell Scripts during migration process.
- Production Support for the existing system for P1 and P2 issues.
- Involved in migrating the data for the customer accounts, Assets and Payables modules
- Involved in Requirements gathering discussion and prepared technical design document.
- Involved in release support.
- Created migration plan for all the Upgrade activities and created issue log.
Environment: Oracle12C,pl/sql,sql,Reports10g,Forms10g,Toad, Share point, JIRA, XML Publisher
Confidential, Dallas
Oracle Consultant
Responsibilities:
- Developed pl/sql packages, database triggers.
- Used advanced pl/sql extensively in all the conversion, interface programs.
- Designed and developed Item and OHQ Conversion.
- Wrote UNIX shell scripts for moving of bank files from the client server..
- Designed and developed Customer and AR Invoice Conversion. Used API’s and Interface tables to convert.
- Designed and developed GL Interfaces from Sub ledgers.
- Designed and developed Work Order WIP interface.
- Developed XML Publisher reports.
Environment: Oracle12G,pl/sql,sql,Reports10g,Forms10g,Toad,pl/sql developer, Share point, JIRA, XML Publisher.