System Analyst Resume
Wilmington, DE
SUMMARY:
- Info Technology Professional with over 11 years of experience in analysis, design, coding, testing, debugging, and implementation of Mainframe, DB2 and most recently
- Unix based systems including SAS, SQL, and Oracle technologies. Recognized as a results - driven system analyst with innovative solutions to customer needs and proven problem solving abilities. Strong background in communicating both verbally and in writing with business users and all levels of management. Won an Accenture Core Value .
TECHNICAL SKILLS:
Mainframe: COBOL II, CICS, VSAM, TSO, ISPF, JCL, FILEAID, ASSEMBLER, INTERTESTXPEDITER, SAS, ENDEVOR, DB2, SYNCSORT, FTP, IDMS12.0, DataWarehousing
PC: Oracle 8.0, 9.0, Microsoft Office Suite (Word, Excel,), Microsoft Access,Microsoft Outlook, Windows XP, UNIX, Micro Focus COBOL (MainframeExpress), Micro Focus Revolve, RemedyConcepts: Handling, Data Validation, Random and Sequential File Updating, Sorting,Peregrine, Visio, Data Modeling, Object-Oriented Analysis and Design, UML,Multi- Level Control Break Processing, Called/Calling Structures, Lotus Notes,DB2 Stored Procedures
Operating Systems: Windows 95, 98, 2000, XP, CICS, UNIX, IBM 370 Architecture, IBM 3090Mainframe, IBM PC, MS DOS, OS390, ZOS
Web Tools: Visual Studio .Net, HTML, ASP.NET, ADO.NET, Crystal Reports, WebServices, VB 5.0, VB6.0
PROFESSIONAL EXPERIENCE:
Confidential, Wilmington, DE
System ANALYST
Responsibilities:
- Worked on developing programs and reports for Fund Accounting Financial systems. Developed new logic and concepts to satisfy new business requirements and was instrumental from detail, analysis and design. Worked with the business to communicate all issues and report back to the PM in a timely fashion. Learned all about the Fund Accounting system process, which consists of VSAM files where all the data resides and is extracted. Participated in all phases of testing for this development project. Was involved in developing various other projects simultaneously.
Confidential
System ANALYST
Responsibilities:
- Part of a major software application upgrade for Vanguard Fund Accounting Invest One releases. Propriety software used by Vanguard owned Compass applications. Using COBOL, CICS, DB2, Assembler, VSAM and CICS applications.
- Worked on developing, analyzing, testing and implementation thru all phases of application delivery.
- Worked with Endevor and Peregrine problem tracking tool to package all copybooks, source code, ASM and MAP members as well as all PROCS and JCL thru UNT, SAT, and CAT testing with eventually production destination.
Confidential
System Analyst
Responsibilities:
- Part of a major outsourcing initiative for Bristol Myers Squibb pharmaceutical IT application group.
- Developed from scratch a detailed plan to recognize what business knowledge was required to in order to sit with knowledge owners to learn key aspects of the BMS business.
- Was assigned to 10 key business applications including BMS pricing and reimbursement, batch processing, accounts receivable, sales budgeting and forecasting, incentive compensation for all PHARM sales reps and maintaining and supporting the BMS company car fleet.
- Rollout was done in 3 phases - knowledge transfer, job shadow and safety net. Phases were also broken out in skill levels, java, and mainframe and web technologies. I was the only one on the team that was part of 2 skill phases which gave me more exposure to different skill sets as well as more in-depth knowledge of the clients business.
- Maintained a problem tracking document tool called remedy which monitored all incoming help desk tickets including customer assistant, break fixes, required modifications and elective enhancements. Service level agreements must be met due to strict guidelines in order to avoid fines as part of the contract between BMS and Accenture.
- Was global team lead responsible gathering design specs, delegating and monitoring client requests. Did peer reviews for all support and development work before finished product went to the client. Was client facing liaison between us and off shore teams and was involved in all development decision.
- Participated in manual month end processes which include complex DB2 queries which required producing critical documents that the clients used to make decision to run and improve there overall functionality. Scheduled and monitored critical batch processing job flows for data that flowed from the data warehouse to file transfer protocol at the client server level.
- I am career counselor who coaches and mentors individuals in helping them achieve their goals. Also involved in certain diversity activities.
- Was promoted after 3 months at last level and have been recognized by the client and senior level people for high level work and service.
- Have developed job aids for the off shore team, especially in areas where they lacked the expertise or areas where the processes are difficult and complicated.
- Improved team effectiveness by systematically building others' skills.
Applications Programmer
Confidential, Plymouth Meeting, PA
Responsibilities:
- Developed new applications using COBOL, Cobol II, OS/JCL, and SAS within specific guidelines.
- Monitored and maintained existing mainframe application systems.
- Supported the Corporate Schedule on a 24 by 7 basis using my problem solving skills.
- Part of team responsible in large scale data investigations and back data history corrections.
- Provided application knowledge to numerous user groups assisting them to resolve production cost issues that delivered products on schedule and under budget.
- Lead Tester and developer for new release of SAS 8.2 as well as part of testing team resolving major issues for new releases of Syncsort, FileAid and Strobe thus avoiding potential revenue loss.
- Earned recognition and received quality for role as lead tester for an IDMS Team Project to reduce CPU time.
- Achieved 2 Level Promotions within a 4-year span.
Applications Programmer
Confidential, Philadelphia, PA
Responsibilities:
- Partnered with business clients to develop new ideas to meet their business needs.
- Developed documentation and wrote Specifications for user groups to enhance their existing applications providing better services to student and financial systems.
Confidential
Responsibilities:
- Successfully completed intensive program involving Visual Basic, PL/SQL and Oracle in a Client / Server environment.
- Developed a Full Life Cycle System for the client / server application in an N-Tiered architecture.
- Planned, analyzed, designed, developed and implemented a fully functional banking system utilizing an Oracle Database.
- Executed a database solution through relational database management techniques including: data modeling using Entity Relationship Diagram, designing table structures, implementing integrity constraints, building stored procedures, sequences, triggers, cursors, and packages.
- Implemented SQL by using DDL, DML, DCL commands in a relational database system.
- Created Active X components, controls and documents.
- Created and tested connections utilizing ADO, ASP, ODBC, and OLE DB.
