Silvia Stern
* ****** ******* *****, ******* **********@*******.*** 973-***-****
SUMMARY More than 10 years experience as a Programmer Analyst/ System Tester, with focus on designing, preparing detailed specifications, programming and testing, documenting and implementing applications, as well as providing production support (i.e. full Software Development Life Cycle).
Demonstrated record of successful project design and implementation in the financial services industry.
Strong knowledge of methodology, tools, standards and procedures.
Proficient in Preparing and Implementing of Test Procedures, Test Plans, Test Cases and Test Scripts for full life cycle Testing Methodology.
Experience with Software Quality Assurance in testing Wed-based and Client/Server applications.
Good knowledge in understanding BRDs (Business Requirements Document), FRDs (Functional Requirements Document), TDDs (Technical Design Document), SRS (Software Requirement Specifications) and Use Cases.
Involved extensively in Functional/Integration testing, Regression testing, Black Box testing, White Box testing, System testing, GUI testing and User Acceptance testing, Mercury Quality Center, Automated Testing Tools (QTP, LoadRunner)
Effective presentation skills.
Excellent organizational, oral and written communication skills, analytical and programming skills in high speed, quality conscious and multitasked environment.
Excellent technical/ analytical skills and strong programming and design skills.
TECHNICAL SKILLS
Software: COBOL II, COBOL, DB2, CICS, JCL for OS/MVS ESA Release 4, VSAM, File-Aid, TSO/ISPF, Intertest, SPUFI, Platinum, NDM, IBM Utilities, Syncsort, Endevor experience, Xgen, MicroFocus Workbench, EASYTRIEVE, C, Assembler, Pascal;
Other databases & tools: Crystal Reports, Business Objects, MS SQL Server 2000;
Suite Applications: MS-Office (Word, Excel, PowerPoint, Access);
Hardware: IBM 390 and other large scale IBM mainframe utilizing MVS/ESA;
PROFESSIONAL EXPERIENCE
02/2008 to Consultant, BMW, Woodcliff Lake, NJ
04/2009
· Worked on a full life cycle development project -the International Finance Template Project (IFT) - the purpose of which is to have the National Sales Companies worldwide run a standardized financial application;
· Modified the process of payment of Sales allowances as well as Service Loaner subsidy payments;
· Created automatic batch processes for establishing accruals for Cash and Owner Loyalty as well as Service Loaner Incentives;
· Created a batch driver process to handle the triggering of data elements required by the IFT system.
· Developed new programs for AG Invoice, ATA, Delivery, Wholesale and Inventory Adjustments trigger processes;
· Worked on Parameter Access Project which handles how the trigger process functions will access the parameter tables defined in the IFT project; Coded working storage and procedure division copy books that define variables and internal tables of parameters in the driver program, load parameter tables into working storage internal tables of the driver program, as well as search internal tables to find a match and store the values found in the internal tables;
· Promoted all new and modified components to UAT and closely worked with system testers to validate all conditions;
· Responsabilities included: Analyzing the Business Requirements, Creating System proposals, Design, Coding and Unit Testing;
· Environment: COBOL II, CICS, DB2, VSAM, OS/JCL;
06/2005 to Consultant, Verizon Wireless, Orangeburg, NY
12/2007
· Worked on full life cycle development projects for Vision and I2K groups
· Modified and added new functionality to the existing programs based on new business specifications;
· Responsabilities included: Designing, coding and system testing utilizing MQ series, data flow analysis, development of test plans and documentation, procedures, troubleshooting, production turnover and support;
· Environment: COBOL II, CICS, DB2, VSAM, OS/JCL;
· Created test scripts to test business-case scenarios using in-house developed templates; Developed test plans based on system requirements analysis;
08/2004 to Consultant, Merrill Lynch
04/2005
· Performed programming and testing for financial applications of Merrill Lynch Co. in the Margin Debit Compensation System;
· Performed maintenance and enhancements, created / executed test plans to ensure that results adhere to the requirements and functional specifications;
· Generated financial reports by extracting data based on certain criteria from a DB2 database;
11/1999 to Programmer Analyst, Merrill Lynch – Jersey City, NJ
06/2004
· Provided production support by answering SWAT calls (24/7 availability), resolving all system outages assigned, completing ad hoc requests and answering inquiries from external areas;
· Supported the Reorganization system;
This system receives corporate action security data from external vendors, processes domestic and foreign securities, sends notifications to retail and institutional branch offices, financial consultants and directly to the clients and accepts client elections on voluntary events. It also handles the payment process.
· Facilitated reconciliation performed by users: Developed reports listing key fields from corresponding record files generated from reorganization system and from an outside source;
· Developed design specifications based on gathered user requirements;
· Developed functional specifications based on the business requirements for the different subsystems, as well as created detailed test plans;
· Modified and tested batch and on-line programs based on clients’ requirements;
· Analyzed programs’ abends and corrected production batch and on-line programs as required, insuring the non-recurrence of such problems;
· Developed new batch and on-line programs in order to enhance and ensure that processes were more flexible;
· Evaluated and modified existing programs in order to ensure easier maintenance.
05/1996 to Consultant, Andersen Consulting – Murray Hill, NJ
09/1999
· Designed, developed and maintained a large Integrated Tax Administration System (TAS) for local, state and federal revenue Agencies;
· Developed conceptual and detailed designs of complex program modules from general specifications;
· Developed complex programs based on design specifications using Cobol, JCL and DB2;
· Debugged/ Maintained On-line programs in a CICS environment;
· Conducted Unit testing, System testing and debugging; solved user reported problems;
· Designed and implemented a Y2K project in a client-server environment:
- System solution for year 2000 compliance for our revenue clients: Tennessee state, Maryland state and Detroit city;
· Provided programming assistance to others in a team environment;
· Developed various reports for revenue accounting using Cobol and Easytrieve.
Training Company sponsored courses:
- Business Intelligence Tools;
- COBOL Training;
- C Language;
- Client/Server;
- PowerPoint- Creating Basic Presentations;
- Business Process Excellence Principles.
EDUCATION
2005 Business Intelligence Fundamentals – New Age Training, NY
- Certificate of Graduation
- Data Warehouse, ETL, OLAP, Data Modeling (ER/ Studio)
- Crystal Reports
1996 Diploma in Computer Programming - The Chubb Institute, Parsippany, NJ
- Selected to participate in the Chubb Honors Program
1980 BS Mechanical Engineering