Data Warehousing Resume
New Jersey, NJ
Career summary
A proactive, energetic programmer/analyst and consultant with exceptional creative abilities, project management experience, and analytical skills with an extensive experience as a project leader and software lifecycle development experience in iSeries / IBM AS400 UDB DB2.
Strong background in business applications and managing end user/client expectations. Good problem solver who is not afraid to take responsibility for her decisions.
Technical Skills:
Languages: COBOL 400; COBOL ILE; SQL (Structured Query Language); SQL Stored Procedures; Embedded SQL; CLP (Control Language Programming)
Software / applications: MS Project; VISIO; Turnover (Change management); iSeries Navigator; HAWKEYE / PATHFINDER; IFS (Integrated File System); AFP (Advanced Function Printing); SDA; DDS; DDM (Distributed Data Management) PDM; MS Query; Client / Server access to iSeries via ODBC and FTP; Excel; Power Point
Hardware / Operating systems: IBM iSeries, IBM AS400, IBM SYS38, IBM SYS 36; OS400; Windows NT, 2000, XP
PROFESSIONAL EXPERIENCE
Confidential,June 2007 – October 2009
Have worked on analysis, design, development implementation and support of Enterprise Data Warehousing applications including Data Stage and ETL; utilizing COBOL ILE with embedded SQL, DB2 USB;
Analyzed, designed developed and implemented Weston Woods, Scholastic Reading Counts & Tom Snyder Production historical Invoice Information Loadings into EDW.
Developed Implemented and Maintained Virtual Bonus Point Bank Analysis Data Mart
- Managed and implemented computer projects for Customer Service, Credit Acceptance, Finances and Marketing users in this large catalog sales company. Reported to IT Senior VP. Dealt directly with the various Directors and Supervisors throughout the areas of her responsibility determining requirements and ensuring the functionality of the developed systems. Prepared specifications for technical staff, and managed all aspects of the development cycle.
- Led designed developed tested and implemented Reward and Dividend Banking system utilizing COBOL 400, DB2 UDB, referential integrity, triggers, SQL stored procedures, MS Query and iSeries ILE. Implementation of this system resulted in 600K yearly savings for the company by reducing manual processing, increasing efficiencies and customer’s satisfaction.
- Oversaw seamless conversion from two AS400 to an iSeries with Logical Partitions
- Responsibilities also included:
- Participating in conceptual design, logical design and driving the physical design for different projects
- Developed Project Plans. Prepared specifications for technical staff and managed all aspects of the development cycle
- Conducted user’s acceptance and integration testing, helped users to adept to new functionality and took responsibility for installation of the newly developed applications.
- Created seamless interfaces to a numerous third party software packages.
- Mentored programmers of different levels
Confidential,1987 - 1995. Senior Programmer/Analyst and Consultant.
- Performed as consultant and system analyst for this consulting firm: Clientele and experience included:
- Non-Ferrous Int’l Corp., a subsidiary of Mitsubishi Int’l Corp: In this capacity, reported to CFO, and supervised the conversion and re-engineering of all systems from batch S36 to AS/400 using DBMS, COBOL 400, CLP, DDS. Designed and implemented several trading and accounting systems, including EDI.
- J&W Seligman: Developed securities transaction processing system for J&W Seligman. This was a client-server based system that provided management and operating reports of trading activity for over 20 mutual funds and a large institutional customer base
- Towne-Oller/IRI: Designed a relational database of product sales data for this market research firm, as well as several marketing and statistical systems; converted systems to dual AS/400 processors.
EDUCATION
Degree Accounting.
Certificate in Data Processing.
Courses: Visual Basic, SQL, Successful Project Management, Data Warehousing.
Numerous classes with IBM and other software vendors.