Business Analyst
Resume:
Ron Russom Information Processing Specialist
Home
Mechanicville, NY 12118
**********@***.***
SUMMARY
I am an information processing specialist with 30 years of experience. I have excellent programming, writing, verbal and analysis skills. I conducted meetings with users and technical staff to develop data marts. I developed documentation, system flows, schedules and best practices for the OMH data warehouse group. I am looking to continue to make a contribution to an organization utilizing my skills and experience in information processing.
TECHNICAL SKILLS
Programming Languages: Java(J2EE), COBOL, dBASE, Oracle PL/SQL, ANSI Standard SQL, Informatica, C++, HTML, Perl, VB Script.
Software/Databases: Oracle 9i, Informatica, MS Office, MS Access, IBM's Visual Age for Java, Toad, Oracle SQL Plus 9, Oracle Discoverer, Crystal Reports, ER Studio(Embarcadero), 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, data warehousing, programming, business analysis.
EDUCATION The College at Albany - Albany, NY. - Masters Work in Public Administration (58 credits). The College at Oneonta - Oneonta, NY.- Bachelor of Science. Adirondack Community College - Glens Falls, NY. - Associate in Arts. PROFESSIONAL EXPERIENCE
NYISO 2/2010 – 2/2010
Contract Programmer
- Business Analysis, Data Architecting and Programming Activities
• Developed a MS Access program that tracked media up to the point of destruction.
CDPHP 4/2009 – 4/2009
Contract Programmer
- Programming Activity
• Developed PL/SQL and Informatica objects for claims processing.
New York State Office of Mental Health 9/2001–1/2009 Retired
Information Processing Specialist 4
- Programming Activities
• Wrote and tested business applications using many software languages: primarily Informatica 8.x and PL/SQL using tables on Oracle databases.
• Provided problem resolution for both the Informatica and Discoverer applications.
• Involved with moving data from flat files, including Excel files, to an Oracle Environment.
- Business Analysis Activities
• Researched manual and automated systems, developed recommendations and prepared documentation. The recommendations identified unnecessary steps.
• Worked with financial staff in the use of Oracle based tables with the Oracle Discoverer product and MS Access. This added value added steps to the staff’s operations.
• Worked with data warehouse staff to incorporate best practices from Informatica and the NYS OFT.
• Worked with analysts, using work sessions, to translating business requirements into technical user specifications, including data, process and interface specifications.
• Developed the methods and procedures for data warehouse staff,
• Developed implementation plans and schedules for Informatica enhancements,
• Developed reports based on issues related to the data warehouse.
• Worked with finance staff to document their business rules, data needs and requirements in order to create data warehouse systems. In order to develop this documentation I used a combination of group facilitation and JAD techniques.
• 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.
• Assisted in the development and training related to best practices for the Data Warehouse group.
• Developed documentation, for both business and technical staff, related to my activities.
• Assessed and documented existing business processes and identifying where
• Involved in the procurement of contractors for Informatica programming.
• Developed frequent reports to management regarding my activities.
- Data Warehouse Activities
• Researched and developed methods related to information processing metrics.
- Data Warehouse Activities
• To develop the data marts I conducted meetings with the data mart users and developed prototypes of the data mart as discussion items.
• Involved in data warehouse projects where I was the project leader directing contractors and state staff. Developed Star Schemas for: Payroll, Concerts, EIS, Pharmacy, Finance.
- Data Architecting Activities
• Developed data marts using sources such as: agency's HRM data, Department of Civil Service personnel files, OMH’s Concerts Tables, and the Office of the State Comptrollers payroll and financial files. This included developing indexes, primary and foreign keys, and constraints. As well, I developed PL/SQL Procedures.
• Using both Embarcadero and Informatica, I supported and maintained metadata and application data residing inside EDW Development.
• Analyzed, designed, created and manipulated msAccess and Oracle (9i) tables.
Technologies Used: Unix, Oracle 9i, Informatica(SOA), PL/SQL, SQL, Oracle Discoverer, VB, ER Studio(Embarcadero), Microsoft office, MS Access, MS Visio, MSDOS.
New York State Higher Education Services Corporation 10/1993-9/2001
Senior Computer Programmer Analyst
- Programming Activities
• Involved in all phases of business application development using IBM COBOL II, Java(J2EE), MS Access and dBASE.
• As well, performed programming, analysis, troubleshooting and research tasks related to the business applications.
• Developed client based Java classes, using IBM,s Object Oriented Analysis, 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.
- Business Analysis Activities
• Involved in planning, analysis, and design in both mainframe and PC environments.
• Developed training sessions and documentation related to my tasks.
• Provided support, as a part of a "Help Desk" team, for corporation PC and Office Vision users.
• Worked with corporation staff to include the use of the ENABLE and dBASE software packages in their daily operations.
• Worked with analysts to translating business requirements into technical user specifications, including data, process and interface specifications.
• Assessed and documented existing business processes and identifying where improvements can be made or where new processes can be installed.
• Researched manual and automated systems, developed recommendations and prepared documentation. The recommendations identified where new processes or technology could be employed.
• 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.
- Data Architecting Activities
• Developed relational tables for a JCL/Proc inventory system.
• Developed various MS Access systems.
Technologies Used: ENABLE, dBASE, GEM, MSDOS, Lotus, MVS/TSO, COBOL, VB, ERWIN, DB2, Visual Age for Java, DBASE, SQL, Lotus Notes, Microsoft office, MS Access, MS Visio, MSDOS.
New York State Higher Education Services Corporation 5/1981-9/1993
Senior Administrative Analyst
- Business Analysis Activities
• Prepared various studies and impacts, lead project teams, based on meetings with staff.
• Reviewed COBOL listings and developed requirements documents based on the code.
• I researched manual and automated systems, developed recommendations and prepared documentation. The recommendations identified where new processes or technology could be employed.
• Worked with Student Loan staff to document their business rules, data needs and requirements in order to document manual and automated information systems. To do this analysis I used Bull/Honeywell’s Systems Analysis Design Methodology.
• Mentored fellow Administrative Analysts in the development of system documentation.
• Developed RFPs, using work sessions with staff, 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.
Contact this candidate