Systems Analyst Resume
Eagle, PA
SUMMARY:
- Highly motivated and result oriented with almost seven years of industry experience as Business/Systems Analyst
- A self starter with leadership qualities, interpersonal and communication skills, In - depth domain knowledge of Telecom Industry.
- Strong organizational, communication, leadership, planning and vendor management skills.
- Excellent knowledge of industry standard methodologies like Software Development Life Cycle (SDLC), Project Life Cycle, Rational Unified Process (RUP) and Capability Maturity Models (CMM).
- Expertise in ecommerce environment.
- Extensive experience working with vendor e-commerce tools like Microsoft commerce as well as helping construct and integrate in-house ecommerce applications.
- Excellent Analytical skills to understand the business process and Functionality, Requirements and to translate them to system requirement specifications. Developing functional specifications for business process refinement and automation, data modeling, system architecture, conducting feasibility studies, scope.
- Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
- Performed UAT and exposure to User Certification Testing (UCT) and Operational Readiness Testing (ORT)
- Well-versed in project management tool (MS Project) for status reporting, planning and resource allocation.
- Extensive experience in modeling the AS IS and TO BE ecommerce solutions
- Working knowledge of implementing software development projects using methodologies such as Waterfall, Rational Unified Process, Agile/Scrum.
- Experience with IVR applications, Call Routing, QA testing, and Call Center Environments.
- Worked on Video Teleconferencing (VTC). Designed and supported custom IVR and Web solutions for multiple Fortune 500 Companies.
- Proficient in developing and executing Test Plans, SQL and PL/SQL queries, performing functional, usability testing and ensuring that the software meets the system requirements
- Extensive experience working with vendor e-commerce tools like Microsoft commerce as well as helping construct and integrate in-house ecommerce applications.
- Extensive experience using SCRUM and Agile methodologies.
- Proficient in developing Use Case Model, Analysis Model, Design Model, Implementation Model, Use Case Diagrams, Behavior Diagrams (Sequence diagrams, Collaboration diagrams, State chart diagrams, Activity diagrams), Class Diagrams based on UML using Rational Rose
- Oversaw requirements gathering and installation of Tandberg Video Teleconferencing (VTC)
- Extensive experience with process modeling using UML, flow charts, task diagrams, Sequence Diagrams, Activity Diagrams and Use Cases.
- Excellent communication and presentation skills. Experience working with business users as well as senior management.
- In Depth understanding of the AS-IS and TO-BE business processes and experience in converting these requirements into technical specifications for preparing test plans.
- Ability to work cross-functionally and with all levels of the organization
- Creative and Aggressive person capable of forming and maintaining positive and productive team environments and with integrative thinking skills.
TECHNICAL SKILLS:
Languages: C,C++, C#, Java, SQL
Scripting Languages: Perl, JavaScript, VBScript
Markup Languages: HTML, XML
Methodologies: RUP, Agile, Waterfall, UML, CMM, EXPRESS ONE, PRISM, IT UP
IDE/OOAD: Rational Rose, Rational Clear Case, Rational Requisite Pro
Reporting: MS Visio, MS Project Test Director, WinRunner, LoadRunner
Database: Oracle, Oracle DBA, Microsoft Access, Teradata, MS SQL server
Operating Systems: Windows95, 98, XP, 7, Linux, UNIX
PROFESSIONAL EXPERIENCE:
Confidential, Eagle, PA
Systems Analyst
Responsibilities:
- Gather requirements by conducting meetings and brainstorming sessions with senior management of the Research Group and SMEs and document them.
- Gathered requirements to customize ATG provided solutions, services, and ongoing guidance to power a more relevant and personal e - commerce
- Usage of ATG platform including repositories and RQL to build an e-commerce site.
- Prepared user training manual for merchandising team on managing commerce assets through ATG BCC (Business Control Centre).
- Documented the Process Flows for B2C and B2B in the High Level Requirements Document.
- Custom tools upgrade client had created marketing, merchandising product tools to support their custom web application which needed to be re-architected to work with ATGs eCommerce suite
- Developed the Project Scope and Vision document in assistance with the Project Manager.
- Also performed the as-is and to-be Assessment to understand the underlying gap in the business process.
- Developed Functional and Regression Testing scenarios based on XML and XSD schema validations.
- Extensively used MS Visio to develop the solution concept, business timeline and wireframes.
- Conducted JAD sessions, initiated scope and discovery meetings.
- Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
- Participated in the testing of B2B and B2C websites, including creating test plan and test cases, executing test cases(including regression and ad-hoc testing), and defect management
- Writing XML test files to run against XSD schema, testing C# application, backwards compatibility testing.
- Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Data Flow Diagrams, Component Based Diagrams, and Collateral Diagrams and creation of technical design (UI screen) using Microsoft Visio.
- Facilitated joint application development (JAD) sessions, one on one interview and meetings with business users and subject matter experts (SMEs).
- Involved in making Use Case Diagrams, Activity Diagrams, and using analysis and design models tools like MS Visio, Rational Rose through RUP, Agile and Waterfall Model
- Responsible for creating Business Requirement Specifications, to capture functionalities Confidential all E-Commerce touch points.
- Worked extensively with Business and IT in understanding and documenting system requirements pertaining to the Credit Card Authorization Project in the E-Commerce department.
- Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
- Utilized Agile/ SCRUM and PMI methodologies to monitor, steer and develop project objectives.
- Introduced Agile and RUP methodologies to reflect liquid nature of front-office improving time-to-market
- Extensively use Microsoft Project or similar tools such as Open Workbench to document project plans.
- Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
- Performed extensive requirement analysis including Data analysis and Gap analysis.
- Analysed business requirements and segregated them into high level and low level Use Cases, activity diagrams using Rational Rose according to UML methodology thus defining the Data Process Models.
- Successfully conducted JAD sessions, which helped synchronize the different stakeholders on their objectives and helped the developers to have a clear-cut picture of the project..
- Created UML models and visual artifacts like DFD, Flowchart, and Process Flow diagrams.
Confidential, Overland park, KS
Sr. Business/Systems Analyst/ DW Analyst
Responsibilities:
- Proactively communicate and collaborate with external and internal customers to analyze information needs and deliver a full product spec including but not limited to: Functional Requirements, Technical Specifications, Application design, Use Cases, Sequence Diagrams; GUI, Screen and Interface designs and prototypes; Documentation Specifications
- Tested same rule instance, in a Data Stage flow for computational purposes and in the DPI portal for display purposes
- Facilitated process movement to standards and procedures that involved implementation of MASC codec for IVR systems.
- Developed IVR application for delivery notification of customers shipping information via out going phone calls, including carrier name, tracking info also allowing an escape to customer service use a follow the sun timing program as to deliver the info Confidential an appropriate time.
- Implemented custom data collection systems. Systems allowed Cingular to move all online and IVR data collection in-house.
- Designed multi-dimensional cost table to calculate expense and environmental savings for video teleconferencing (VTC) meetings; saving calculations occurred in real-time, delivering results in less than 1 second.
- Involved in Project Management for project Billing conversion Wire line commission extracts from Data Warehouse to Optics.
- Developed XML Schemas and DOM parser for all the XML documents used for data transfer and also developed XSLT code for them.
- Extensive experience in modeling the AS IS and TO BE ecommerce solutions
- Conducted workflow, JAD, Process diagram and GAP Analysis to derive requirements for existing system enhancement.
- Leveraged Genesys as a SaaS solution provider to enable a reduced cost and higher efficiency virtual meeting.
- Stored stake holder conversations as part of CRM Activities in detail using ACT 5.0.
- Designed Data Flow Diagrams (DFD’s), Entity Relationship Diagrams (ERD’s), and web page mock ups using modeling tools.
- The process involved in gathering information from the stake holders about their existing IVR based system, and then implementing the compression speech technology to enhance storage and quality of speech.
- Used XML to look up for the specific attributes and parameters needed for testing the web application in the QAT environment.
- Performed GAP Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
- Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
- Involved in Logical & Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, Stored Procedures in Sybase Database Servers.
- Delivered video teleconferencing (VTC) training and established data connections for multiple national and international.
- Validation (run test scripts and validate reports generated) for mock, integration and test re-run.
- Configured internet connections on remote user machines with dial up, cable, DSL, and wireless routers to support users on VPN.
- Performed Fuctional Testing, Regression Testing, Fax Testing, IVR Testing and other testing as required.
- Implemented VoIP and IVR technology between corporate officess and converted contact centers.
- Elicit requirements using interviews, document analysis, workshops, surveys, site visits, business process descriptions, use cases, scenarios, business analysis, and task workflow analysis.
- Followed Agile (XP) Methodology for the release.
- Provide ad-hoc reporting and analysis from data sources including PeopleSoft (SET) and Teradata.
- Responsible for Porting Wire-line and Wireless of Sprint/Nextel numbers.
- Configured the Data mapping between Oracle and SQL Server.
- Develop requirements specifications according to standard templates, using natural language
- Collaborate with engineering to establish the technical vision and analyze tradeoffs between usability and performance needs
- The aim of the project was to enhance the functionalities of various existing applications linked to ecommerce.
- Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance testing (UAT) using Quality Center.
- Documented the daily Testing Progress and shared the stats during daily tailgate meetings with Tech Leads
- Communicated changes to requirements promptly and precisely to all personnel involved.
- Experienced in web based information system.
Environment: PL/SQL, Java (J2EE), Test Director, Rational Req. pro, clear case, Rational Rose, QTP, Clear Quest,UAT, Win Runner, Agile, PERL, Teredata, MS Office, MS Visio, DSL, MS Project, RUP, VOIP, UML.
Confidential, Duluth, GA
Systems Analyst
Responsibilities:
- Worked with Financial Analysts to evaluate benchmarks that included a vast array of global indices as well as customized benchmarks.
- Hands on experience incomplete IT operations of the airline industry such as RTSM,Tech Ops. Conducted interviews with airport and airlines personnel and modeled Use Case Diagrams to document viability of project
- Actively participated in gathering requirements from various SMEs, Financial Analysts, Risk Analysts and Portfolio Management via JAD/JAR sessions.
- Worked closely with the QA system integration team to develop post implementation system scripts in the TPF environment
- Collaborated with other team members to write detailed Business Requirements Document. Developed Functional Requirements Specifications and System Requirement Specification from the business requirements.
- Rewriting of Ticketing and pricing system using TPF, TPFC, TPFDF
- Designed Use Cases, Use Case Diagrams, Use Case Scenarios, Workflow and Data Flow Diagrams. Business Process Flow Diagrams, Activity and Sequence Diagrams using Microsoft Visio.
- Involved in various brainstorming sessions to investigate, identify, analyze and solidify business rules.
- Reviewed with architect and technical team various technical design documents as well as input and output parameters for various web services.
- Participate in Development Solution in regards to Interwoven Team site related design and implementation concepts
- Created and maintained a Traceability Matrix using Rational Requisite Pro.
- Involved in analysis for wide range of Six Sigma and Web-based initiatives, including user requirements.
- Generated wireframes and prototype for the GUI.
- Worked with the QA team to develop test plan, test cases and test conditions for integration and functional testing. Traceability Matrix was used to ensure complete end-to-end testing.
- Wrote and executed test scripts for GUI testing using Win Runner.
- Coordinated UAT. Reported all bugs and defects to the development team.
- Performed data analysis and ran various SQL queries to critically evaluated test results.
- Participated in end-user training and generating descriptive user manual.
- Assisted production support team in identifying failure points and performing root cause analysis.
Confidential, Dallas, TX
Business System Analyst
Responsibilities:
- Followed a structured approach to gathering and formalizing business requirements expressed by managers, process owners and operational users of the information system
- Analyzed business requirements and system architecture/design.
- Identified IS strategy to be followed and related IS strategy to Business strategy and communicated the same through written and oral communication to the top management and Systems Analyst and Designer.
- Worked with MS project, MS Word and MS Excel
- Developed detailed ERDs and DFDs using various modeling tools and developed databases based on the system model following the techniques in SDLC (software development life cycle).
- Involved in Requirement analysis along with the creation of Use Case Scenarios and modeling of the business and application using RUP and UML.
- Captured core business process information, business rules, business entities and other relevant information
- Reviewed and streamlined existing CRM processes, information, and data requirements to ensure accurate adoption metrics reporting.
- I worked in developing CRM applications and Apex Interactive reports and Forms for Annual Summary Reports and CRM reports.
- Advanced call routing and case management for each required customer need
- Worked extensively in Data Analysis, Data Requirement Analysis and Data Mapping for ETL process
- Involved in Call handling, Call Routing, Monitoring processes, and CRS work force management processes
- Assisted the project manager in making changes and finalizing the scope of the project
- Analyzed trading partner specifications and created EDI mapping guidelines
- Work closely with developers to review user requirements and understand technical recommendations and constraints, and develop comprehensive and accurate functional specifications; Data Mapping, process flows, and other UML diagrams.
- Identified organizational structure, cultural and business constraints affecting options for change and developed business aims.
- Helped in deployment of portal a venue for the on-line trading application a collaboration bundle solution.
- Manually tested IVR prompts, recorded messages, call routing, and call prioritization components. Conducted Functional/SIT (System Integration Test) to ensure that the Avaya CTI is integrated with the IVR and all the user entered data is being carried to the user interface screens leveraging Selenium Test Automation framework implemented using Ruby language . Used QualityCenter to maintain all test cases, test results and defects.
- Assessed risks, costs and potential benefits of alternative business process.
- Developed Functional Specifications and Testing Requirements using Test Director 7.0.to conform to user needs.
- Developed test scenarios for Interactive Voice Response (IVR) integration and Avaya CTI screen-pop modules
- Created business use case, functional (FRS) and technical specifications for trading system.
- Interfaced with developers to identify and resolve technical issues and bugs in the software to validate end-user requirements.
- Interacted and communicated clearly with development, testing and production teams concerning release management policies and procedures.
Confidential, Seattle, Washington
Business Analyst
Responsibilities:
- Involved in Inception Phase and prepared vision statement and initial data models that contain Business Requirement Documents and supporting documents that contain the essential business elements and detailed definitions.
- Helped the client decide on the best vendor solution
- Working with clients to better understand their needs and present solutions using structured SDLC approach.
- Worked with the clients banking partners to finalize the certification
- Gathered requirements for the integration of the payment terminals
- Extensively used MS Project for project management
- Documented the user requirements Analyzed and prioritized them and converted them as system requirements that must be included while developing the software
- Developed & executed several Optimized queries in SQL on this data.
- Learned about eCommerce and different types of payment methods for conducting the same.
- Worked with various vendor groups to gauge the effectiveness of their solution
- Analyzed data and created class diagrams and ER diagrams for designing databases.
- Suggested web security using encryption and authentication technologies for reporting and complaint filing procedures
- Used Query Analyzer, Execution Plan to optimize SQL Queries
- Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using the UML methodologies.
- Created Activity Diagrams, Sequence Diagrams and ER Diagrams.
- Created Mock-up forms in MS word for better visualization and understanding of the software solution.
- Tracked change requests and monitored workload and schedule.
- Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.
- Scheduled meetings with developers, System Analysts and testers to collaborate resource allocation and project completion.
- Created and managed project templates, use case templates, requirement types and tractability matrix in Requisite Pro.
- Managed workload, schedules and coordinated status review meetings with project managers, business managers and team members.
- Authored progress and completion reports which were then submitted to project management on a weekly basis in MS project.
- Identified various frequently used modules with in the application as well as the peak user volume for load testing purposes.
- Analyzed the test results from QA teams using Performance Studio Analysis to create various scenarios.
- Developed strategies with Quality Assurance group to implement Test Cases in Test manager for User Acceptance Testing.
- Collaborated with Quality Assurance Analyst in Automated and Manual Black box testing.
- Helped in creating end user manuals and procedure manuals.
