We provide IT Staff Augmentation Services!

Senior Business Systems Analyst Resume

2.00/5 (Submit Your Rating)

Richmond, VA

EXECUTIVE SUMMARY:

  • Over 9+ years of diverse progressive experience in Information Technology, with emphasis on Business Analysis and Software Development.
  • Excellent background in working with Business Management, Business Analysis, Business Processes, Business Process Models, Business Flow Diagrams, Business Requirement Documents and hands - on working experience within the Oracle Database.
  • Extensively involved in analysis & design of Business Models and possess excellent expertise in generating Business Process Models.
  • Expertise in creating Business Flow Diagrams and has hands on experience in Documentation of Business Requirements.
  • Expertise in converting Business Requirements into functional/ technical specification and am well proficient in Problem Solving.
  • Expertise in defining scope of projects based on gathered Business Requirements including Documentation of constraints, assumptions, business impacts, Project risks & scope exclusions.
  • Experience in performing feasibility analysis, risk analysis and Gap analysis.
  • Experience in defect tracking, analysis and documentation using different testing tools.

PROFESSIONAL EXPERTISE

  • Expertise in the field of Systems Integration, and Project Management.
  • Around 9 years experience as a Business Systems Analyst defining, designing and developing new systems requirements for the Software.
  • Around 3+ years experience in Programming (C, C++, Java, J2ee, XML), Algorithm Development, and Research
  • Experience on projects related to Banking solutions, Data Warehousing, Identity Management (Sun IdM)
  • Understanding of Rational Unified Process (RUP)
  • Experience in Business Analysis, Business Modeling, Requirements Gathering, Technical Documentation, Software and Data Validation.
  • Experience in different Enterprise Resource Management (ERP’s) programs like Peoplesoft and Oracle.
  • Ability to track all contractual deliverables and to resolve any deviance.
  • Extensively used PL/SQL to validate the data in the Oracle database and performed SQL tuning.
  • Worked with business & IT communities to translate business needs into functional requirements.
  • Excellent skills in Business Analysis, Systems Analysis, Data Analysis, Requirement Management, and Business Modeling using Rational tools and UML methodology respectively.
  • Conducting requirement gathering sessions, feasibility studies and Impact Analysis, Cost/Benefit analysis and Risk analysis, base lining acceptance criteria.
  • Experience in working with Confidential and various Confidential compliant software like processMax, etc.
  • Experience in using tools such as USE CASE, IBM Rational Rose, MS Visio.
  • Work individually, as well as in team environment, to achieve project quality goals.

TECHNICAL SKILLS:

Languages: Java, J2EE, C, C++, UML

Web Technologies: Hibernate, EJB, HTML, JavaScript, Servlets, JSP, JDBC, JStruts, XML, X12

Web and Application Servers: IBM WebSphere, JBOSS Application server 4.0, Apache Tomcat

Requirements management: IBM RequisitePro; IBM ClearQuest; Mercury (HP) Quality Center

Database Tech/Tools: Oracle10g/9i/8i/7.x,MS-Access, MS SQL Server, SQL, PL/SQL, Toad, SQL Developer, Hyperion BRIO; PERL scripting

Reporting Tools: Hyperion BRIO; Hyperion Oracle Studio; SmartView

Editors: WSAD, WebLogic s Workshop, Eclipse

Operating Systems: Windows 95/98/NT/2000/XP, UNIX

PROFESSIONAL EXPERIENCE:

Business Systems Analyst III

Confidential

Responsibilities:

  • Worked with the business owner on how the current notification system works, and what needs to be added in order to be compliant.
  • Performed GAP analysis on the previous reporting information and the new information.
  • Worked with an audit member to ensure the requirements for the project were on par with expectations.
  • Prepared MS PowerPoint presentations to show project status and report to project manager.
  • Used MS Excel to perform data analysis.
  • Gathered, elicited, and documented detailed system requirements in order to add the required data on the IMPACS screens.
  • Wrote mapping rules for state information and code to allow recognition in the system.
  • Analyzed the IMPACS system by viewing green screens and where information is being stored.
  • Reviewed updated form with additional fields and worked with different project teams which were impacted to ensure smooth implementation and transition.
  • Analyzed test cases and ensured they were on par with the requirements.
  • Reviewed unit test results and test results for final sign-off.
  • Performed post-implementation validation by analyzing production files and verifying data in IMPACS.
  • Worked closely with the business owners to gather initial requirements.
  • Worked on GAP analysis between release schedules.
  • Analyzed various transaction codes used in ATM processing, as well as debit and credit transaction processes with IMPACS.
  • Worked very closely with developers and wrote pseudo code as part of system documentation.
  • Reviewed unit testing sessions with the development team and provided feedback report on errors and mismatch on requirements.
  • Arranged test case and test results review sessions with the project team to sign-off and move to UAT.
  • Prepared use-cases for the system.
  • Reviewed test results status, and UAT results, and provided sign-off for final implementation.
  • Wrote detailed system requirements and VISIO workflow diagrams.
  • As a BSA on IMPACS platform, analyzed current wires process from PayPlus and CIBAR platforms.
  • Performed detailed analysis on file information and mapping information as to how data is loaded from file to IMPACS.
  • Worked with the PIE team to work out details on how the same processes can be replicated.
  • Wrote mapping rules and documented missing information for current processes.
  • Worked closely with developers to analyze code-related issues for data mapping.
  • As a BSA on the IMPACS side, provided level of effort estimation on the requested work and how the TMOBS will impact IMPACS.
  • Worked with the developers and testers to get estimation on the level of coding and testing effort.
  • Prepared PowerPoint presentation to present the business on the identified tasks and impact to the IMPACS platform.

Senior Business Systems Analyst

Confidential

Responsibilities:

  • Worked very closely with developers to gather existing requirements on existing applications with FDA.
  • Worked with the customer and SME’s to gather requirements for the SFCN application and what similarities it has with existing applications in order to re-use existing code.
  • Analyzed workflows and use-cases and compared new requirements with existing application.
  • Prepared matrix to compare existing application use-cases with new use-cases and business-rules and worked closely with developer to come up with a level-of-effort.
  • Analyzed other FDA applications not built by Confidential to determine whether any alternative approach would be more feasible instead of using Confidential code.
  • Prepared an Alternative Analysis document listing points where reusing Confidential code will be cost-effective and less time-consuming.
  • Prepared use-case documents for each use-case and worked with the developer closely to prepare a level-of-effort document.
  • Confidential is Confidential level 3 compliant, hence ensured required documents were prepared in advance to Confidential audits.
  • Used MS suite to create use-case documents and alternative analysis document.
  • Used MS VISIO to create workflows and use-case diagrams.
  • Worked very closely with the project manager and used MS Project to create project plans and project tasks. These were also used to show the customer as an artifact to show progress on the project.

Business Systems Analyst III

Confidential, Richmond VA

Responsibilities:

  • Worked closely with application SME’s and application owners to gather information on the application workflows.
  • Performed Data Analysis on a daily basis using SQL tools and Hyperion Oracle Studio.
  • Applied the workflows into Access Central’s forms - an application could either fall under a generic form, or a fully customized application.
  • Performed manual data reconciliation by analyzing data using tools such as MS Excel, SQL developer, and Hyperion Oracle Studio.
  • Used Hyperion Oracle Studio SmartView to write daily reports for internal customers to review.
  • Worked closely with the ETL team and Access Central Management to provide updates on each application being on-boarded.
  • Performed testing by creating, deleting and modifying user access
  • Used SQL Developer and Hyperion Oracle Studio to perform analysis and generate reports.
  • Used WinSCP to connect to UNIX servers to deliver files.
  • Trained application teams on file delivery
  • Worked very closely with application vendors to ensure they comply with native file requirements.
  • Ensured end-to-end testing for each application was performed as per requirements and test cases.
  • Engaged with offshore testers to document test cases.
  • Worked closely with front-end form developers to document system requirements for custom-forms.
  • Worked closely with info-security team to develop Profiled access.

Confidential technical lead

Responsibilities:

  • Initiated “template approach” to configure every application to reduce effort and time spent for on-boarding each application which also required minimal to no front-end coding to implement. Every application form was data-driven.
  • Prioritized application on-boarding based on application Tiers (A, B, C, D) and SOX. SOX applications were priority and required that the application be ready for reconciliation at the time it was ready for production.
  • Post activity after on-boarding each application and based on the Tier levels, I worked closely with application vendors to provide requirements for “Native” files, which consist of user access information from the native source. This information is used for reconciliation against Access Central’s authorized access to ensure each access is authorized.
  • Was involved in using Confidential applications to grant user access (provisioning of access).
  • Was engaged with firewall and security teams to ensure application connectivity to Confidential ’s domain for Confidential ’s General Ledger application.
  • Used and setup Confidential ’s mainframe access via Attachmate.
  • Used Confidential ’s mainframe commands to grant access to users.
  • Utilized and mastered various Confidential applications to grant user access.
  • Wrote MACRO scripts to run automated scripts in active mainframe sessions for granting access.
  • Trained Confidential provisioning team on various Confidential applications on the workflow and granting user access.
  • Wrote Excel MACRO scripts to assist application teams to generate Native files in the format consumable by ETL.
  • Used SQL developer and Hyperion Oracle Studio to perform data analysis and generate reports.
  • Performed analysis of each application on-boarded to ensure Role values are consistent with the native application.

Confidential technical lead

Responsibilities:

  • Gathered, elicited, and documented detailed System Requirements.
  • Engaged with various application SME's and business owners for JAD sessions, requirements walk through.
  • Performed detailed data-analysis with the business to understand and appropriately document the native file requirements.
  • Performed data validation and testing of files back to back from file deliver, to automated testing to logged data in databases.

Tools: and Technology: MS Suite including Word, Excel, PowerPoint and Visio; SQL developer; Oracle Hyperion Studio; Notepad++; Sun IDM; VB Scripting; Putty for UNIX; MS Command Prompt; Attachmate for Mainframe; WinSCP

Business Analyst

Confidential, Richmond VA

Responsibilities:

  • Gathered and elicited detailed system requirements.
  • Engaged with various SME’s to finalize system and design requirements.
  • Prepared a detailed requirements document, mapping the Business requirements with the System and Design requirements.
  • Used Microsoft Word, Excel, PowerPoint and Visio as documentation tools to prepare and present the requirements document, including data-flow diagrams and source to target mapping documents.
  • Was involved in the entire SDLC of the project.
  • Analyzed requirements and mapping data obtained from DMAS
  • Engaged with the development team to document design details or the Portal.
  • Engaged with the EDI (Electronic Data Interchange) team to develop mapping of XML data sent from the portal to the native EDI X12 format.
  • Engaged with the ECM (Enterprise Content Management) team to send defects for non-availability of documents on the Portal.
  • Engaged with the MMIS team to test the MMIS screens and resolve issues.
  • Engaged with the testing team to help initiate testing documents and test cases.
  • Used RequisitePro to log new requirements.
  • Utilized WebEx to attend remote meetings with development team and customer and also to present requirements to DMAS.
  • Used ClearQuest to log defects and assign defects to the appropriate developer working on that particular issue. Assigned fixed defects to testers and sent back to DMAS.
  • Closely engaged with the technical lead of the project to plan and strategize completion of team tasks.
  • Used SQL developer to verify back-end data stored in Oracle 10g servers, by retrieving SQL-generated result-sets.
  • Wrote a basic HTML “Page at Construction” page to test connection between non-VPN and VPN systems.
  • Wrote SQL scripts to be re-used by team to quicker data retrieval.
  • Used tools such as HTTP watch to analyze where the connection was breaking when pinged to the development server.
  • Used iMacros tool to automate testing of some portal modules for quicker testing.
  • Assigned development team tasks to complete project milestones.
  • Worked closely with project manager and team lead to document new requirements and change requests.
  • Prepared supplements to the detailed system requirements document to elicit new requirements and next phase requirements.
  • Involved heavily with customer and project manager to perform GAP analysis.

Tools: and Technology: MS Suite including Word, Excel, PowerPoint and Visio; SQL developer; HTTP Watch; iMacros; ClearQuest; RequisitePro; Notepad++; WebEx; NetMeeting

Business Systems Analyst

Confidential, Richmond VA

Responsibilities:

  • Engaged as Business Liaison with the Business customers and the Application SME to gather, elicit, and document Business Requirements.
  • Engaged closely with the development team to provide necessary documentation such as approved Business Requirements, Data Requirements, and form behavioral business rules.
  • Worked as a Technical Liaison to work closely with both the web-development team and the ETL (Data Warehousing) team to prepare detailed Data Requirements and Data Flow diagrams.
  • Engaged with Confidential business to gather and elicit requirements for Batch Provisioning, Data requirements, and detailed Business Rules for provisioning access to the web-application.
  • Documented detailed form flow diagrams using MS Visio to capture web-form data element behavior.
  • Worked closely with the customers to provide Form Drop down data elements and form behavior business rules.
  • Wrote SQL scripts to load Configuration data to the backend tables.
  • Worked closely with the business customers to perform testing, data validation by using Hyperion BRIO and SQL Developer. Performed form element behavioral testing.
  • Engaged closely with the testing team during testing phase to manage defects.
  • Prepared necessary change requests to capture changes to the requirements.

Business Systems Analyst

Confidential, Richmond VA

Responsibilities:

  • Gathered and documented Detailed Functional Requirements, Business and System Requirements.
  • Was closely involved with the customer and the project design team to work with design requirements (look and feel of website).
  • Worked closely with the project design team on graphics using Confidential Photoshop.
  • Applied some Java skills in designing and developing RSS portlets, database logging portlets using JDBC connection, AJAX featured organization chart portlet.
  • Was involved in authoring some content for the project using InterWoven. Also designed templates for content such as Manger’s news corner.
  • Used PERL scripting to extract text and re-generate texts based on xml documents received for content management.
  • Was also involved in applying tags to keywords using Endeca search utility.
  • Was involved in writing SQL queries for the organization chart portlet.
  • Used Microsoft VISIO to document the flow of the project including sales calls.
  • Applied Confidential practices (level 3).
  • Was also involved in some QA testing using Mercury Quality Center. Wrote test scripts as well as test cases. Used Load Runner to rewrite scripts.
  • Performed Scalability, Performance and Load Testing using Load Runner 8.1
  • Used MS Project to document all phases of the project
  • Was involved in full SDLC of project.

Tools: /Technology: TIBCO Portal Builder, MS Visio, MS Project, MS Office, UML, Eclipse, Notepad++, Endeca, InterWoven. PERL Scripting

Business Systems Analyst

Confidential

Responsibilities:

  • Responsibilities include gathering Detailed Functional Requirements (DFRs), implementing use-cases (5th level use-cases), user requirements and documenting all the necessary information in generation for the web portal.
  • Experience in working and training with Confidential practices (level 3) and applying it to the current project. Managed projects by the role of being a Quality Control Specialist.
  • Developed Confidential based policies and procedures to control and manage project artifacts housed in various repositories through multiple baselines. Controlled changes through the baselines and ensured traceability of all work products.
  • Involved in the analysis of the functional, technical specifications, data mapping document and conceptual diagrams.
  • Experience in converting Electronic forms from Confidential Designer 5.0 to Confidential LiveCycle Designer 7.1 (Acquired Training at Confidential Head-Quarters)
  • Involved in Working with Earned Value Management (EVMS) and creating necessary documents for Project Managers for every lifecycle of the project.
  • Managed the final phases of the project to ensure timely completion of all remaining deliverables using MS project.
  • Thoroughly involved in every stage of the Software Development Lifecycle (SDLC)

Tools: /Technology: MS Visio, MS Project, UML, PowerPoint, Oracle 9i SQL

J2EE Developer/Analyst

Confidential, Burlington, MA

Responsibilities:

  • Gathered requirements for UI and back-end functionality for forms such as Policy Filter/Summary Page, Create/Edit Policy Page and other Insurance Company forms. Implemented Policy Issue functionality.
  • Used UML to draw use case, class and sequence diagrams.
  • Struts framework was used to implement MVC / Front Controller design pattern, and other design patterns during the development.
  • Created Multiple Results Navigation Framework using Java custom tag libraries (JSTL), JSP, Servlets and JDBC.
  • Created use case diagrams for reusable error handling custom tags and JSP pages.
  • Gathered business requirements and got a better understanding of the business and system processes
  • Prepared project deliverables: Business Workflow analysis, process analysis, user requirement documents (Use Cases & Use case diagrams) and managed the requirements using Rational Requisite Pro.
  • Followed the RUP methodology and was extensively involved in developing the iteration plans.
  • Actively contributed through out the entire RUP process (Inception, Elaboration, Construction and Transition)
  • Involved at preparing and analyzing RFI requests for Information gathering.
  • Used UML methodology to prepare Use Cases from the gathered requirements and created diagrams using MS Visio.
  • Involved in gathering the Data requirements, data analysis and defining the Data Mapping.
  • Effectively implemented the change control processes and also updated the impacted business process documentations.
  • Conducted JAD Sessions with various stakeholders and project team
  • Used MS Project to manage schedules, deadlines, resources and the project tasks.
  • Extensively used SQL and Excel for Data Analysis.
  • Planned & implemented the Testing cycle schedules, timelines, test plan, Test cases & test data sets for system testing.
  • Gained understanding on internal controls as a part of SOX compliance.
  • Involved in defining the templates for reports for SOX compliance.
  • Independently prepared UAT test plans, test conditions, test cases and developed user training manuals.
  • Conducted User Acceptance Tests and maintained all defects in test director.
  • Developed the training schedules, documents and trained the users.

Tools: /Technologies: Rational Requisite pro C++, Java, JDBC, Struts, Servlets, JSP custom tags, EJB, SQL, ClearCase, Oracle 9i

J2EE Developer

Confidential, Charlotte, NC

Responsibilities:

  • Analyzed and documented information requirements and the corresponding impact on business processes
  • Conducted joint requirements planning sessions as a facilitator to gather requirements from the group
  • Documented the user requirements and system changes into detailed functional specifications
  • Documented the objectives, constraints and scope of the system
  • Developed use cases along with the development team
  • Conducted sessions with developers to explain the user requirements and understand the system changes required to facilitate these changes
  • Conducted walk through with testing team to explain them the various changes made to the system tat needed to be tested before implementation
  • Helped the testing team in making up the test strategies and test plans to be used in the testing process
  • Responsible for signing off on the test strategy document which explains the testing methodology being adopted by the testing team

Environment: J2EE, Java, Servlets, JSP, Oracle 8i, HTML, JDBC, PL/SQL, JavaScript, Java Swing, Struts, Hibernate

Confidential

Responsibilities:

  • Involved in the software development life cycle: Gathering requirements, Analysis, Design, Development and Testing.
  • Designed and developed User Interface using JSP.
  • Performed client side validations using Java script.
  • Designed Servlets to connect to the session beans. These would connect to Entity beans residing on Server.
  • Developed Session beans for business logic as well as Entity beans for representing data in the database.
  • Used JDBC drivers for communication between the database and EJB beans.
  • Extensively used Oracle PL/SQL for developing and testing Stored Procedures, packages, functions and triggers.
  • Deployed the jar and war files in the WebSphere server.
  • Conducted various quality tests.
  • Provided end user training and Production System Support.

Environment: Java, JDBC, Servlets, JSP, HTML, JavaScript, WebSphere, Oracle PL/SQL, Rational Rose, Struts (MVC) framework

We'd love your feedback!