SUMMARY:

• About 6+ 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.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, Chicago, IL

Telecom Business Analyst

Responsibilities:

• Gathered and documented business requirements for existing and future business systems.
• Captured requirements for T-mobile billing enhancements and performed source to target data mapping for T-Mobile 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.

Confidential, Silver Spring, MD

Business Analyst

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 Confidential 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.

Confidential, Dallas, TX

Business Analyst

Responsibilities:

• Involved understanding the current business process, defining scope of the project along with position statement
• Responsible for collecting and documenting the business and technical requirements for the Network applications which interface with the OSS/BSS applications.
• Responsible for capturing the requirements for the Integration between Network and OSS/BSS applications.
• Been a part of Architecture and modeling team and have used SOA (Service Oriented Architecture)
• Met with users and stakeholders to understand the problem domain, gathered customer requirements through surveys, interviews (group and one-on-one) along with JAD sessions.
• Applied Unified Modeling Language (UML) methodology to create use case diagrams and sequence diagrams in Rational Rose.
• Upgrade the strategy about how to optimize sale of different products within reasonable cost and how to control the inventory.
• Working with clients to better understand their needs and present solutions using structured SDLC approach.
• Created use-case scenarios and storyboards in MS Word and MS PowerPoint for better visualization of the application.
• Translated the user business requirements into functional requirements for OSS/BSS development.
• Responsible for third party vendor network connectivity to the AMDOCS billing system.
• Designed the UI (web interface) of the application, along with prototyping.
• Take a part to split the quote to cash process into business Functions.
• Strengthen contract and proposal management processes for Customer Teams by proposing process changes, which shortened the quote to cash cycle and improved compliance with revenue recognition polices
• Resolved issues and improvised the process to ensure a stable and accurate solution.
• Performed cost-benefit analysis, generated reports for analyzing various investments and their profitability and also for analyzing various lost opportunities due to time delay in investing.
• Worked with financial services as part of support for the application.
• Validated business rules and all artifacts with users, approval and sign off.
• Working with the architect, developers on business and technical issues, helping in designing of the system; and testers to ensure all requirements are correctly translated.
• Managed requirements and tasks using JIRA
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Served as a resource for analytical services utilizing SQL Server, and TOAD/Oracle.
• Run the SQL queries using TOAD and SQL Navigator.
• Created testing traceability matrix and heavily involved in the testing and QA aspects of the System development life cycle
• Worked with the team on security features: web, encryption, authentication and SSO possibilities.
• Updated and modified progress and resources allocation in MS project for the team.
• Suggested process and product improvements for the application.
• Created test plans, scripts and facilitated user acceptance testing.
• Performed manual front-end testing to check all functionalities of different modules.
• Helped in deployment of portal a venue for the on-line trading application a collaboration bundle solution.
• Identified areas of risks, assessment, monitoring, having security and audit controls in place.
• Ensured that the application met user and management expectations.