Sr. It Business Analyst Resume
Edison, NJ
SUMMARY:
- Extensive technical lead experience on cross functional project teams working on multiple projects.
- Supports all areas of software development lifecycle using waterfall methodology.
- Effectively communicates complex concepts and ideas to developers and business partners.
- Develops and implements end - to-end testing strategy using Requirements Traceability Matrix.
- Performs predictive modeling to identify system results.
AREAS OF EXPERTISE:
Elicit and Define Technical Requirements | Research and Redefine Business Users and Units Affected | Assess Current or Future Needs | Conduct Surveys or Measuring Tools | Analyses / Reports| Interpret Customer Business Needs | Translated Needs into Technical Requirements | Effective Communication Skills | Implement Processes, Procedures, and Metrics | Ensure Projects Meet Deadline and Within Budget | Collaborative | Schedule and Facilitate Meetings | Followed up and Track | Effective and Efficient Problem Resolution
TECHNICAL SKILLS:
R-Programming | HP Quality Center | SQL | SDLC | Waterfall Methodology | TOAD for Oracle | TOAD Data Point | Microsoft SQL Server Studio | TSQL | Microsoft Windows Server 2003 | Microsoft SQL Server 2005 | COBOL | COBOL II | Assembler | TSO/ISPF | MVS/JCL | VSAM | CICS | Micro focus COBOL | IDCAMS | SYNCSORT | Change man | File-Aid | SAS | SAS Enterprise Guide | Ultra Edit | ADDM | Micro Strategy | | Microsoft Windows XP Pro | Lotus Notes | Microsoft Office Suite: Word | Access | Excel | PowerPoint | Outlook
PROFESSIONAL EXPERIENCE:
Confidential, Edison, NJ
Sr. IT Business Analyst
Responsibilities:
- Worked with business users accessing multiple operating systems (mainframe and midrange) to determine what systems were duplicates due to the merger between Confidential and Medco.
- Reversed engineered COBOL applications, including data flow diagrams, technical requirements and business requirements.
- Created a matrix to identify system dependencies between numerous systems to insure the proper order for the applications to be retired.
- Used ADDM to identify system programs, hardware and where they were located.
- Determined what hardware could be retired and which could be redeployed.
- Developed and wrote requirements to decommission the government contract claims system and the changing of Virtual IP addresses from one data center to another data center.
Confidential
Sr. IT Systems Analyst
Responsibilities:
- Worked with large data warehouse used for storing problem and incident data. Met with business partners and data architect to develop new tables for reporting. Created detailed specifications and data mapping for new reports.
- Created daily automated extracts to downstream systems and eliminated the need for manual querying of the data.
- Developed requirements for new interactive dashboards used to monitor external customer’s servers and software leading to a reduction in staff for the customer.
- Used TOAD and TOAD Data Point to profile data to insure accurate reporting.
Confidential
Sr. IT Business Analyst
Responsibilities:
- Worked remotely with confidential health claims and wellness data statistics for health care incentive programs. Conducted interviews with business units to gather system requirements for customer reporting. Developed functional and technical system specifications based on customer requirements. Created detailed use cases to validate results.
- Provided predictive models for new projects using preliminary requirements and created reusable SAS macros to reduce test query development time by 25% and increased accuracy by 50%.
- Used TOAD for Oracle and SAS Enterprise Guide to create SQL queries to research and validate data in a large data warehouse.
- Led presentations to multiple stakeholders on system requirements, conceptual design and project status.
- Used HP Quality Center to document test script and error reporting.
- Performed complex conceptual analysis and developed innovated solutions.
Confidential, Lyndhurst, NJ
Business Analyst / Quality Assurance (Consultant)
Responsibilities:
- Interfaced with external customers on developing system requirements for new projects as well as providing quality assurance and testing on existing projects to ensure system accuracy and implementation. Created detailed test cases and process flow based on customer’s needs. Developed work estimates based on schedule and budget considerations.
- Created documentation that provided cost savings by constructing a common process and eliminating the need for rework.
- Developed functional and technical system specifications based on customer requirements and current system processing.
- Used TOAD for Oracle to create SQL queries to create and validate test results.
- Developed screens using GUI formats.
- Created Requirements Traceability Matrix to insure all requirements were tested.
- Worked with external and internal customers on developing and executing use cases.
- Created database tables for testing software to ensure compliance with organizational and contractual specifications.
Confidential, NJ
IT Systems Analyst (Consultant)
Responsibilities:
- Maintained large mainframe COBOL system during transition into new server-based system. Researched and resolved daily production errors.
- Designed and implemented requirements for the conversion of new business policies directly into the new system which reduced the expense of maintaining two systems.
- Used SQL queries with a DB2 database to retrieve information for Property and Casualty policies.
- Resolved conversion issues which increased accuracy and reduced customer complaints.
- Created SAS reports to monitor file conversion to new system.
- Created sales report using SAS to identify agents still selling business through the legacy system.
- Monitored daily production errors and researched problems which reduced system down time.
Confidential, Holmdel, NJ
System/Business Analyst
Responsibilities:
- Served as lead developer for the homeowners’ policy issuing system. Provided guidance in rating methodology, renewal processing, and creating insurance documents for customers. Maintained a large mainframe COBOL system that supported a 1.2 million customer base. Led conceptualization and design for the implementation of business requirements. Was responsible for quality, analysis and programming deliverables.
- Designed and implemented an automated process for policy renewal, producing a less labor-intensive process and more accurate policies for yearly renewals.
- Interviewed business owners to gather requirements for system modifications.
- Led project teams to clearly identify user requirements, focusing on bridging the gap between the needs of the business unit and the capabilities of the system.
- Interfaced with internal and external stakeholders on project status providing continuity and a knowledgeable point of contact, as well as assessing impact of new developments on both the project and other impacted systems.
- Used SQL queries with a DB2 database to retrieve and rate Property and Casualty polices
- Created rating structure for policies in a batch environment and a real-time environment utilizing multiple platforms to accommodate both data entry requirements and policy processing requirements. This provided more accurate processing of policies.
- Integrated an outside vendor’s product, a rating software package (ISI Ratabase), into an established system to improve rating capability, provide more flexibility for the rating structure and reduce time to implement new rates.
- Designed a staged approach for transferring 800,000 customer records, containing on average 3,000 - 4,000 data bytes of information, to ensure smooth and timely transition of data resulting from sale of customer base to multiple corporations.
- Managed complex requirements from multiple stakeholders (parent company, purchasing companies, and various state regulators).
- Utilized mainframe rating structure from a PC front-end to provide real-time rate quotes to reduce delay in providing information to customers by agents using MQ Series. Project guaranteed consistency in rating methodology regardless of platform.
- Used SAS to identify and select records with required data for testing.