SUMMARY

• 9+ years of experience as a Business Analyst with expertise in business process analysis, business requirements, and business analysis in the field of Telecom.
• Deep understanding of enterprise data warehouses.
• Proficient in business process modeling, documentation, and testing using Rational Suite (Rational Rose, RequisitePro, SoDA, ClearQuest, Robot) as well as MS Visio and MS Project in combination with UML 2.0 diagramming techniques.
• 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.
• Results-oriented Joint Application Development (JAD) Facilitator and meetings coordinator with excellent interpersonal skills.
• Excellent working knowledge of TCP/IP and OSI layers model (Layers & respective functions and intra-layer communication).
• Experience in SDLC Methodologies like Agile and Scrum and related terminology such as Daily Scrum, Product Backlog, Release Burndown, Scrum Master, Sprint Planning Meeting, Taskboard, To-do and Work in Process Charts.
• Expertise in using the testing tools such as Mercury Quality Center (QC)/Test Director and Quick Test Pro (QTP).
• Analytical, methodical, and resourceful approach to problem solving, identifying and documenting root causes and corrective actions
• 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 delivering web VOIP solutions on or ahead of schedule and to stated budgets.
• Good understanding of IP networks and Voice over IP (VOIP) as well as Strong experience in Telecom BSS/OSS customization.
• Excellent meetings facilitator with excellent inter-personal and conflict resolving skills.
• Experience in debugging of Ethernet driver with sending and receiving Ethernet frames.

TECHNICAL SKILLS

Network Strategies & Protocols: OSI Seven Layer Model, LAN/WAN, IWAN, TCP/IPv4, TCP/IPv6, SNA, APPN, DLSW, SD LLC, Bisynch, BGP, EIGRP, OSPF, RIP

Web Technologies: HTML, JavaScript, XML, AJAX, SOAP

Testing tools: Win Runner, Load Runner, Quick Test Pro, and PR Tracker

Methodologies: Agile Modeling, Scrum, SDLC model, Waterfall model, Use Cases, JAD

Database Tools: SQL*Plus, SQL*Loader, MySQL, Toad

Middleware: WebSphere MQ 6.0 z/OS, and TIBCO, Oracle Fusion Middleware

Databases: Oracle, MySQL 5.0, IBM DB2 9, MS SQL Server 2008/2012

Languages: UML, MS SQL, PL/SQL

Business Tools: MS Visio, MS Project, MS Access, MS Office Suites

Computer Skills include: PBX, CRM, CTI, ACD, IVR, Windows O/S, MS Office, Visio, HTML, Javascript, CSS, Adobe Suite CS4

PROFESSIONAL EXPERIENCE

Confidential

Telecom Business Analyst

Responsibilities:

• Gathered and documented business requirements for existing and future business systems.
• Captured requirements for Confidential billing enhancements and performed source to target data mapping for Confidential billing ODS.
• Worked on several mainframe based applications running on an AS/400 platform.
• Developed and conducted ad hoc analysis in pursuit of root-cause understanding of various challenges and issues presented to the business related to inventory support.
• Acted as a liaison between business staff and technical staff to articulate needs, issues and concerns.
• Project duties included multiple task project assignments, scheduling and tracking; facilitating meetings with all levels of the business community for requirements gathering, project development, design considerations, impact and risk analysis, and quality control of client acceptance testing.
• Created Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.
• Used the DataStage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse database.
• Supported the Amdocs Customer Management Ordering system, Amdocs Billing.
• Analyzed requirements utilizing various methods. (E.g. sample data from SQL queries, Screen Shots, reports, prototype screens, sourcing information, and other data models.)
• Successfully designed and implemented scalable, highly available database architecture (UDM, Unified Data Model) to support various Path applications
• Expertise in development of High level design, Conceptual design, Logical and Physical design for Database, Data warehousing and many Distributed IT systems
• Performed testing on a data warehouse platform, including data integrity and data validation.
• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Oversaw end-to-end OSS/ BSS solution architecture including: Real-time and off line Billing, Ordering, Provisioning, Porting, Payments, Customer care, Point of sale, Web self care and network real-time access: IN and Diameter protocols.
• Assisted with writing of Test Plan for the Financial Data Mart implementation effort.
• Performed report validation writing sql queries using TOAD on an Oracle database.
• Ensured that project requirements are properly tracked and documented.
• Requirements Gathering/Documentation - Designed and documented detailed business requirements, functional requirements utilizing PMO & Governance approved templates.
• Conducted JAD sessions with the participation of the users and the stakeholders to gather requirements.
• Implemented RUP recommended visual models to draft business requirements by using Use Cases.
• Worked with SQL queries using MS Access for data manipulations.
• Extensively used SQL to query the database and created ad hoc reports and validated data
• Created test scripts and plans for UAT Phase.
• Conducted UAT (User Acceptance Testing) to make sure that all the user requirements are catered by the application.
• Wrote Test Cases in Mercury Quality center that would test various Test scenarios.
• Rational ClearCase was used to manage all the changes and change requests in the projects. Worked with QA team with the aid of ClearQuest for the bug tracking.
• Monitored test scripts developed by QA team to check the integrity of the test plans.
• Dedicated a good portion of time with the QA team in front-end, back-end and Regression testing.
• Worked with VoIP deployment team to ensure the product and features integrate seamlessly with the network design.
• Drafted business Use Cases such that any future changes could be easily managed.

Business Analyst

Confidential

Responsibilities:

• Gathered and documented business requirements for existing and future business systems.
• Captured requirements for TDS billing enhancements and performed source to target data mapping for TDS billing ODS
• Acted as a liaison between business staff and technical staff to articulate needs, issues and concerns.
• Maintenance on a Work Order Management System.
• Delivered business requirements, high level and detailed technical specifications and then lead the development and business teams through design, testing and implementation phases.
• Performed testing on a data warehouse platform, including data integrity and data validation.
• Assisted with writing of Test Plan for the Financial Data Mart implementation effort.
• Performed report validation writing sql queries using TOAD on an Oracle database.
• Created Billing Quality Assurance Sarbanes-Oxley Narrative and Testing Documentation for the Enhanced Traffic Systems Mediation Platform, including fmCI and fWCOM switched traffic plus fmCI Operator Service Traffic.
• Ensured that project requirements are properly tracked and documented.
• BSS/OSS integration architecture of client AAA and service control systems.
• Used MS-Visio for flow-charting, process model and architectural design of the application.
• Used MS-Project for status reporting and planning.
• Proactively monitored and analyzed VoIP systems to maintain a consistently proficient environment: and provide feedback of status to management.
• Provided addressable support to all markets using the AMDOCS billing system.
• Experience in writing extensive SQL Queries on AS/400.
• Implemented RUP recommended visual models to draft business requirements by using Use Cases.
• Worked with SQL queries using MS Access for data manipulations.
• Extensively used SQL to query the database and created ad hoc reports and validated data
• Created test scripts and plans for UAT Phase
• Conducted UAT (User Acceptance Testing) to make sure that all the user requirements are catered by the application.
• Wrote Test Cases in Mercury Quality center that would test various Test scenarios.
• Rational ClearCase was used to manage all the changes and change requests in the projects. Worked with QA team with the aid of ClearQuest for the bug tracking.
• Monitored test scripts developed by QA team to check the integrity of the test plans.
• Analyzed the reasonable range of inventory.