Informatica Resume
New Jersey, NJ
SUMMARY
I am an Informatica developer with 7.5 years of experience in Informatica 8.x development to Oracle and SQL databases. I have excellent programming and analysis skills as I was responsible for the interviewing and selecting of Informatica consultants. I conducted meetings with users and technical staff to develop data marts. I developed best practices for the data warehouse group. I am looking to continue to make a contribution to a company utilizing his Informatica skills.
TECHNICAL SKILLS
Programming Languages: Java(J2EE), COBOL, dBASE, Oracle PL/SQL, SQL, Informatica, C++, HTML, Perl, VB Script.
Software/Databases: Oracle, Informatica, MS Office, MS Access, IBM\'s Visual Age for Java, Toad, SQL Plus 9, Oracle Discoverer, Crystal Reports, ER Studio, Informatica (SOA), MVS COBOL.
Operating Systems: DOS (client); Windows 3.x, 95, 98, NT; MVS/TSO (IBM Mainframe); Unix (server).
SKILLS/ACTIVITIES
I Present ideas and concepts in a clear and concise manner. I have knowledge and experience in EDP, systems development/design, programming.
EDUCATION
Masters Work in Public Administration
Bachelor of Science.
Associate in Arts.
PROFESSIONAL EXPERIENCE
Confidential, 9/2001–1/2009
Informatica Developer
- Wrote and tested business applications using many software languages: primarily Informatica 8.x and PL/SQL tied to a Oracle and SQL database.
- Analyzed, designed, created and manipulated msAccess and Oracle (9i) tables.
- Programming of DDL/DML in Oracle
- Developed data marts using sources such as: agency\'s HRM data, Department of Civil Service personnel files and the Office of the State Comptrollers payroll and financial files.
- Supports and maintains metadata and application data residing inside EDW Development. Follows established standards Staging Area, and ODS.
- To develop the data marts I conducted meetings with the data mart users and developed prototypes of the data mart as discuss items.
- Involved in data warehouse projects where I was the project leader directing contractors and state staff.
- Developed new enhancement training sessions for staff. These sessions instructed staff in the use of new Informatica enhancements.
- Administered a business application Oracle Discoverer business intelligence product.
- Administered the agency’s Informatica (SOA) product.
- Provided problem resolution for both the Informatica and Discoverer applications.
- Assisted in the development and training related to best practices for the Data Warehouse group.
- Involved in the procurement of contractors for Informatica programming.
- Developed frequent reports to management regarding my activities.
- Researched and developed methods related to information processing metrics.
- Involved with moving data from flat files, including Excel files, to an Oracle Environment.
- Developed documentation, for both business and technical staff, related to my activities.
Technologies Used: Unix, Oracle 9i, Informatica(SOA), PL/SQL, SQL, Oracle Discoverer, VB, ER Studio, Microsoft office, MS Access, MS Visio, MSDOS.
Confidential, 1/1995-9/2001
Senior Computer Programmer Analyst
- Involved in all phases of business application development using IBM COBOL II, Java(J2EE), MS Access and dBASE.
- Involved in planning, analysis, and design in both mainframe and PC environments.
- As well, performed programming, analysis, troubleshooting and research tasks related to the business applications.
- Developed training sessions and documentation related to my tasks.
- Primary responsibility was to developed client based Java classes that read downloaded files and posted pertinent data to IBM DB2 tables.
- Mentored programmers on code where I was familiar and developed frequent reports to management regarding my activities.
Technologies Used: MVS/TSO, COBOL, VB, ERWIN, DB2, Visual Age for Java, DBASE, SQL, Lotus Notes, Microsoft office, MS Access, MS Visio, MSDOS.
Confidential, 9/1993-12/1994
Senior Computer Programmer Analyst
- Provided support, as a part of a "Help Desk" team, for corporation PC and Office Vision users.
- Developed and taught training sessions, designed and coded dBASE IV systems, resolved issues with the dbase programs, configured and purchased PC systems, installed software, and provided support/problem resolution for a corporate wide implementation of Word Perfect.
- Developed frequent reports to management regarding my activities.
Technologies Used: ENABLE, dBASE, GEM, MSDOS, Lotus.
Confidential, 5/1981-9/1993
Senior Administrative Analyst
- Prepared various studies and impacts, lead project teams, based on meetings with staff.
- Developed RFPs for software, developed manuals, researched processing requirements for conversion to EDP, designed forms, prepared data entry instructions, developed plan for mainframe disaster recovery, conducted post implementation audits.
- Developed frequent reports to management regarding my activities.