Sr. Business/systems Analyst Resume
Sandy Hook, CT
SUMMARY
- Business/Systems Analyst with 7+ years of experience in business process analysis/modeling, business requirements gathering, database design and development of Web Based, and Client/Server applications at Telecom and Finance domains.
- In - depth knowledge of creating use case, activity, logical, component and deployment views with rational tools to extract business process flows and workflows thereby helping development and quality assurance teams in understanding the requirements.
- Functional experience with concentration on Use Case modeling using UML, Business Process Modeling, Data Modeling, Change Management, Order Management, Technical Training, Software Development.
- Working knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
- Extensive experience working with SQL query language.
- In depth knowledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D).
- Good experience in B2B, B2C and Ecommerce portals web application developments and CRM.
- Strongly scalable dynamic BSS and OSS solutions into Telecom and Networking areas.
- Experience in developing, Customizing Interfaces and Data Conversion programs using SQR, Application Engine and Component Interfaces for HR, Benefits, and Payroll modules.
- Experience in Web Services Testing using SOA, SOAP, Soap UI, XML, XSD, X PATH, and WSDL etc., and expertise in Open Source tools like AppPerfectWebTest and Alfresco Content Management Tool using Flash & Flex Application and AMDOCS Billing Systems.
- Good levels of understanding TMF SID/MTOSI standards.
- Excellent knowledge of Enterprise Portfolio Management systems like Clarity, PlanView and MS Project Server.
- Working experience with Genesys Framework & Foundation,GenesysRouting & Reporting.
- Thorough working knowledge of SharePoint and MOSS (2007), (TFS) Team Foundation Systems.
- Experience in Designing, Creating and maintaining the Universes, Business object reports, WEBI reports and Domains (Security, Universe, Document) in Business Objects.
- Results-oriented Joint Application Development (JAD) Facilitator and meetings coordinator with excellent interpersonal skills.
- Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements
- Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, MS Access, MS Visio, technical assessment tools, Data Warehousing concepts and web design and development.
- Experience in Change Management Process (Identify, Analyze, Evaluate, Plan, Implement, Review and Close).
TECHNICAL SKILLS
Programming Languages: C, C++, C#, VC++, VB, VB.NET, C#.NET, ASP.NET, Java, SQL
Development Methodologies: RUP, AGILE, Waterfall, Scrum, ESDM, STV
Databases: MS-Access, MySQL, SQL Server, Oracle, Teradata, DB2, Sybase
Application Servers: IBM Websphere, ATG Dynamo, BEA WebLogic.
Internet: HTML, XML, VBScript, ASP, JavaScript, JSP, J2EE.
Automation Tool: MS Visio, Rational Rose, Rational ClearCase, Rational RequisitePro, Documentum
Bug Tracking Tools: Mercury TestDirector, Rational ClearQuest
Utility Tools: MS Office Suite, MS Project, TOAD, TSO, Adobe Photoshop
Reporting Tools: Crystal Reports, SQL Server Reports (SSRS)
Data warehousing Tools: Informatica, Business Objects, Cognos, Erwin
Testing Tools: Quick Test Pro (QTP), TestDirector, WinRunner, LoadRunner
Specialties: BusinessProcess Integration, Integrated Competency Centre,ArisModelling.
PROFESSIONAL EXPERIENCE
Confidential, Sandy Hook, CT
Sr. Business/Systems 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
- Developed database tables for rating, rate plan catalogue, applying rate plans to customers, enabling rate plans to vendors and involved in prepaid and postpaid billing, front-end web portals, customer service database setup
- Utilized SDLC Methodology to configure and develop process, standards and procedures
- 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.
- Designing the Process flow diagrams inARISusing BPM (BusinessProcess Modeling) notations for Confidential Project at L0 - L3 level.
- Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) in an SOA environment.
- Involved in Project Management for project Billing conversion Wire line commission extracts from Data Warehouse to Optics.
- Developed E-Business Suite programs for databases supporting supply chain management, order management, inventory, warehouse management system, purchasing, and iProcurement.
- Worked with tools such as Amdocs CRM/Clarify, MS Project, IBM FileNet P8, UML and MS Visio.
- Designed Data Flow Diagrams (DFD’s), Entity Relationship Diagrams (ERD’s), and web page mock ups using modeling tools.
- Responsible for capturing the requirements for the Integration between Network and OSS/BSS applications.
- Worked on several resolutions pertaining to order to cash business process flow.
- Request Access Privileges (Request access to Shared Drive, SQL and VSS).
- Interacted with Billers (Amdocs) to get the XML feed as per our data requirement and perform the Visual validations of the XML files.
- Successfully implemented and deliveredcomplicated Genesyscontact centre solutions with Siebel Integration, with complex IVR call flow and third-party integration, delivered on time on budget.
- Worked with the User Experience and Design teams to effectively apply IVR/call routing User Interface standards / protocol to address business, user, and functional requirements.
- Performed GAP Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
- Review requirements for completeness (Make sure all the required data for staging purpose is available).
- 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.
- Established basic project lifecycles, milestones, and standardized processes for PlanView program management system.
- Provide ad-hoc reporting and analysis from data sources including PeopleSoft (SET) and Teradata.
- Responsible for Porting Wire-line and Wireless of Confidential numbers.
- Configured the Data mapping between Oracle and SQL Server.
- Develop requirements specifications according to standard templates, using natural language
- Wrote Functions for testing customer and billing data with database and validating the conditions.
- 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: SQL, Java (J2EE), Test Director, Rational Req pro, BPM ToolARIS, clear case, Rational Rose, QTP, Clear Quest,UAT, Win Runner, Agile, Teredata, MS Office, MS Visio, DSL, MS Project, RUP, VOIP, UML.
Confidential, Littleton, CO
Functional Analyst
Responsibilities:
- Tasked to design, document and develop business process to automate and standardize Work Order Management process.
- Extensively involved in maintaining requirements traceability and communicating any changes to these requirements to different business groups and programmers.
- Led and conducted JAD sessions for requirements gathering, analysis and design of the system.
- Created context and workflow models, information and business rule models, Use Case and Object Models during the analysis using Rational tools.
- Designing the Process flow diagrams inARIS
- Prepared UAT Materials, including the UAT Process, UAT Test document which would include step-by step process for UAT as well as all the tests that would cover all requirements.
- Prepared and maintain Business Rules Spreadsheets (BRS) identifying Rules, Triggers and corresponding data fields from Legacy to target CRM application.
- Partner withbusinessleadership to clarifybusinessgoals as they pertain tobusinessintelligence (BI) applications for prepaid cards, fraud alert monitoring and customer
- Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
- Held weekly meetings with developers and QA/testers to ensure project deadlines were being met.
- Involved in writing Test Cases, procedures, reports and approval of software release.
- Created test cases and scenarios for Unit, Regression, Integration as well as Back-end, GUI and Black box testing.
- Created Functional, Technical Requirements, Proof of Concept (FSD, POC) to accommodate Postpaid and Prepaid line Activations to be implemented in Amdocs Billing and Enterprise Product Catalog.
- Interacted with the users and logged any defects, enhancements from the UAT.
- Designed the system, prepared UML and sequence diagrams using Rational Rose.
- Documented data flow diagrams; Developed business requirements for data provisioning
- Responsible for writing detailed descriptions of user needs, program functions, and steps required for developing or modifying software programs using Rational Rose (UML).
- Involved in Logical & Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, Stored Procedures in Sybase Database Servers.
- Project was to provide voice/multimedia over IP solutions. IP Management Systems were responsible for interacting with Soft-Switch to provide monitoring, provisioning, Billing of the network elements.
- Wrote SQL statements to extract data from the Tables.
- Been a part of Architecture and modeling team and have used SOA (Service Oriented Architecture)
- Prepared Functional Specification Documentation (FSD) and communicated these to the stakeholders.
- Actively interacted with different business groups to perform Gap analysis to identify the deficiencies in the system by comparing the actual objectives with the system objectives desired.
- Conducted Business Requirements, Functional and Technical meetings with Business groups.
- Developedand Documented timelines for Project Delivery, and managed Projects and Resources to successful completion.
- Used MS Visio for Process modelling and Business Process flow diagrams.
- Extensively involved in regression testing during various phases of the application.
Environment: Java/J2EE, Rational Rose, Rational Req Pro, RUP, WinRunner, LoadRunner, HTML, SQL Server. PL/SQL, MS Office, MS Excel, MS Project, MS Visio
Confidential, Radnor, PA
Business Analyst
Responsibilities:
- Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
- Conducted extensive requirement analysis using Rational requisite pro
- Performed business using Casewise modeller
- Thoroughly studied the requirements for the process re-engineering
- Captured requirements for BizTalk messaging server
- Worked in Product Management Team, global prepaid division and B2B payment solution division. Implementedbusinessprocess to support new products like Confidential Prepaid card, Bluebird and new features to products like PASS card, vPayment payment solution, Confidential Travel cards.
- Advanced ad-hoc and standard report development, including data analysis through the use of Oracle Discover, Business Objects, TOAD, Excel, Access, SPSS, SQL, and Oracle Reports.
- Utilized various tools such as Visio, Rational Requirements Composer, Requirements Pro, HP Quality Center,ARISBusinessArchitect, SharePoint 2010 and Enterprise Architect.
- Supervise and manage projects throughout SDLC to ensure that project management methodology
- Developed QA Test Plan from technical specifications and requirements for this project which deals mainly with three areas i.e. presentation tool, integrated genesis selling tool and catalog API.
- Involved in working with Genesys platform which performs this intelligent routing using criteria such as agent skills, caller priority, and DTMF entered by the caller.
- Developed comprehensive product documentation for operations support system (OSS) products, including release notes, administration guide, user guide, setup guide, and developer guide.
- Continued call Center reporting enhancements with Genesys CTI integration from CCE to Microsoft Dynamics CRM for screen pop and to insert calling/called party information into customer record.
- Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
- Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
- Developed UML Use Cases using Rational Rose and developed a detailed project plan with emphasis on deliverables.
- Developed SOAP based xml message interaction infrastructure, for order management.
- Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation
- Designed flexible project foundation enabling rapid implementation of e-commerce website capabilities
- Created Activity Diagrams, Sequence Diagrams and ER Diagrams.
- Maintenance on a Work Order Management System. Established connectivity to all major buy-side vendor order management systems (OMS).
- Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements.
- Conducted Joint Application Development (JAD) sessions with IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them
- Worked on Documentum for Version Controlling, to maintain up to date changes in the Documents.
- Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.
- Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules.
Environment: Windows NT/XP, Oracle, SQL, Business Objects, TestDirector, LoadRunner Rational Rose and Requisite Pro, MS Visio, MS Project, UML, XML, Rational Clear Quest, Rational Clear Case, RUP.
Confidential, Mt. Laurel, NJ
Business Analyst
Responsibilities:
- Created context and workflow models, information and business rule models, Use Case and Object Models during the analysis using Rational tools.
- Conducted Business Requirements, Functional and Technical meetings with Business groups.
- Directed/Instructed/Maintained all call Center activities via consolidated reports from technical and managerial staff.
- Extensively involved in maintaining requirements traceability and communicating any changes to these requirements to different business groups and programmers.
- Provide innovative IT, business & e-commerce solutions to perspective and existing clients.
- Was involved n the creation of new E-Commerce Products (Arrival Notices and Customized Reporting)
- Functioning also as a Voice Response Unit analyst by supporting the Genesys Call Center application.
- Worked on Oracle Manufacturing and Supply Chain Management modules including OM, Shipping and Execution, Pricing, Inventory, and AR.
- Coordinated with Developers and DBAs to complete task within the deadlines.
- Assisted users after Go-Live and solved issues raised through Issue Management
- Designed the system, prepared UML and sequence diagrams using Rational Rose.
- Collaborated on creation of documents such as the Vision, business requirements (BR) and business systems design (BSD) documents.
- Incorporated Rational Unified Process (RUP) to create Requirement Document Specifications using Visible Analyst.
- Performed an analysis of the Order to Cash, Work Order Management work flows. Worked with the users to analyze and streamline the processes. Significant cost savings were recognized.
- Been a part of Architecture and modeling team and have used SOA (Service Oriented Architecture).
- Responsible for writing detailed descriptions of user needs, program functions, and steps required for developing or modifying software programs using Rational Rose (UML).
- Prepared Functional Specification Documentation (FSD) and communicated these to the stakeholders.
- Actively interacted with different business groups to perform Gap analysis to identify the deficiencies in the system by comparing the actual objectives with the system objectives desired.
- Used MS Visio for Process modeling and Business Process flow diagrams.
- Extensively involved in regression testing during various phases of the application.
Environment: Rational Rose and Requisite Pro, MS Visio, MS Project, UML, XML, Rational Clear Quest, Rational Clear Case, RUP, Microsoft Excel, Microsoft Word, Microsoft Power Point.
Confidential, Virginia Beach, VA
Business Analyst
Responsibilities:
- Facilitated process movement to standards and procedures that involved implementation of MASC codec for IVR systems.
- Familiarized with Computer Telephony Integration
- 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.
- Designed developed first consolidated Call Center application for Student registration on the Catonsville campus using Nortel ACD/Interaila voice recording.
- Worked extensively with MS Office applications including MS Project, Power point, and MS excel
- Maintained effective vendor relationship using specific tools such as ACT, to maintain customer conversations and action items.
- Analyzed trends and design phases in the industry and applied the knowledge gained to creating comparisons, and tradeoff summaries.
- Captured requirements for Confidential billing enhancements and performed source to target data mapping for Confidential billing ODS.
- Involved in creating automated Test Scripts representing various Transactions, Documenting the Load Testing Process and Methodology. Created meaningful reports for analysis and integrated the Performance Testing in the SDLC.
- Held several JAD and JAR sessions to facilitate interaction with Business Users.
- Prepared Functional Specification Documentation (FSD) and communicated these to the stakeholders.
- Modeled the detail design of the system using Use case diagrams.
- Provided Business Requirement Documentation (BRD) for the customers after thorough market and technology research and by analyzing current market trends.
- Conducted GAP Analysis between the legacy reports and the New Built report to in corporate all the necessary information in the new report.
- Used Iterative Software Process for the development of the Reports.
- Interacted and conducted meetings with the Marketing Team to discuss pricing initiatives.
- Involved Requirement management.
- Created a Traceability Matrix to maintain the Traceability of the requirements.
- Used MS Project Gantt charts create the different modules of the project.
- Worked on exporting data using Teradata.
- Used iRise Application Simulator to create web 2.0 effects to make web pages more interactive.
- Performed regression and user acceptance testing during various stages of the development.
- Involved in analysis of Test Plans and Test cases, detecting bugs in the system, preparing the Defect reports using Test Director and interacted with developers for Debugging.
Environment: MS Office, VBA, Macros, Unix, LoadRunner, Java/J2EE, Test Director, Scrum, PL/SQL, SQL, VB script, Req Pro, Java script, HTML, XML, WSDL, XSD, iRise, SQL server, Oracle and RUP.