SUMMARY:

• Around Seven years of professional experience as a Business Analyst in Telecom Industry.
• Experienced utilizing and implementing of OSS conversion and migration.
• Extensive experience in analyzing and requirements gathering and writing system functional specifications including use cases.
• Good skills in team building with a primary focus on diversity, leadership and knowledge.
• Reviewed product and network issues for analysis of system capabilities and product quality control problems to ensure continuous improvement and customer satisfaction
• Good knowledge in Business Support System (BSS) and Operational Support System (OSS).
• Corporate objective is to obtain new mid - market business subscribers for video, Ethernet and advanced voice solutions.
• Excellent in Developing and evaluating business process Models.
• Provided system-wide and product-specific architectural direction, guidance, education, and resolutions for the Carrier Ethernet.
• Proven success as a System Analyst through the years, providing a well-balanced understanding of business relationships, business requirements, and technical solutions.
• Strong experience in RUP Business Modeling process.
• Used a combination of Agile, Waterfall methodologies for the various projects.
• Expertise in UML (class diagrams, object diagrams, GAP Analysis, use case diagrams, state diagrams, sequence diagrams, activity diagrams, and collaboration diagrams) as a business analysis methodology for application functionality designs using IBM’s Rational Rose.
• Solid understanding of Business Process definition, Risk Analysis and SDLC methodologies.
• Excellent in Developing and evaluating Business Process Models.
• Design and review of various documents including the Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents.
• Expertise in broad range of technologies, including business process tools such as MS Excel, MS Access, MS Visio, technical assessment tools, MicroStrategy Data Warehouse Data Modeling and Design.
• Professional experience in business analysis, operations management and development, design, documentation and testing.
• Exposure to Client/Server, Web Application developmental tools and Software development and design.

TECHNICAL SKILLS:

• OOAD (OOA/OOD)
• RUP
• UML
• SDLC
• Waterfall
• Agile
• MS Access
• SQL Server
• MySQL
• PL/SQL
• Oracle DBA
• DB2. Windows 98/2000/XP basic UNIX
• HTML basic DHTML basic XML
• MS Office Suite
• BSS application
• Project
• Visio
• Adobe Photoshop
• Flash
• Rational- Rational Rose
• Rational XDE
• DOORS
• Cobol
• RequisitePro
• CaliberRM
• Crystal Reports
• C
• C++
• Docushare
• Visual Basic
• JAD.

WORK EXPERIENCE:

Confidential, Atlanta, GA

Sr. Business Analyst

Responsibilities:

• Review and analyzed Business Requirement Documentation (BRD) for the project.
• Worked on the managing the tactical relationship with the telecom billing vendor.
• Worked on updating information in billing system.
• Conducted FSD walkthroughs with business, development and testing teams.
• Worked on conducting JAD sessions to resolve critical issues
• Worked on requirement gathering throughout the planning and implementation of the project.
• 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.
• Thorough knowledge of Waterfall and Agile methodology .
• Created and modified database BSS equipment to office specifications
• Used the DataStage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse database.
• Created job schedules to automate the ETL process.
• Provided system-wide and product-specific architectural direction, guidance, education, and resolutions for the Carrier Ethernet.
• Gathered and documented business requirements for existing and future business systems.
• Created detailed roadmap with the Business Intelligence (BI) platform including a new Enterprise Data Warehouse.
• 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.
• Requirements Gathering/Documentation - Designed and documented detailed business requirements, functional requirements utilizing PMO & Governance approved templates.
• Conducted JOINT APPLICATIONS DEVELOPMENT (JAD) sessions with the participation of the users and the stakeholders to gather requirements.
• Responsible for requirement gathering from the client, writing the URS, FSD's and TSD's in accordance with the Rational Unified Process.
• Wrote Test Cases in Mercury Quality center that would test various Test scenarios.
• Interacted closely with external carriers, internal Telecom operations, Procurement and Finance to address service and billing issues and improve operational procedures and controls
• Tracked and resolved billing disputes/discrepancies with various carriers; present escalation issues, status reports and findings to manager on a weekly basis.
• Conducted UAT sessions with the business and technical teams to ensure the application was aligned perfectly to the user specifications.
• Excellent conceptual and technical skills to create Business Requirements Document, Functional Specifications Document, Process flow Diagram, and Detailed Design Document.
• Interpreted and compared invoiced services against quoted contract rates and corresponding telecom inventory accounts and circuits
• Performed project and non-project related tasks and activities to support the department's goals and objectives.
• Lead project teams and managed all activities in the project life-cycle (initiation planning, executing/controlling, and closing) for efforts that were across many lines of business, medium to high risk, complex in scope, and had substantial impact to the relevant business.
• Expertise on requirements gathering, business systems planning, procedural development & implementation, validation, problem solving, business contingency planning, change management and UAT Testing.
• Analyzed monthly telecommunication costs for all locations, to ensure consistency and accuracy in allocation of telecommunication costs
• Maintained documentation, monitors and resolves telecommunication billing inquiries, disputes, and connection issues related to billing
• Established process improvements to facilitate the effective and efficient use of third party invoice processing system for management of the telecommunication billing function.
• In-depth knowledge in conducting GAP analysis mapping "AS-IS" with "TO-BE" systems, determining deficiencies in existing systems and converting these requirements into technical specifications for preparing test plans.
• Validated accounting structure (business units, general ledger accounts, operating units) are accurate and reflects the current state of accounting structure
• Proactively handled all internal customer requests or inquiries courteously, accurately and expediently
• Made certain invoices are consistently paid monthly and validates status of past due balances carried forward on any invoice.
• Coordination of Avaya system application releases including scheduling, testing, and verification
• Devises or modifies procedures to solve problems considering resources, time and form of desired results
• Acts as subject-matter expert on telephony processes of assigned areas
• Responsible for configuring CMS modules and updating employees and related data
• Analyze and defines business telephony needs to develop innovative solutions to phone-related problems
• Gather system requirements related to Avaya Telephony systems and developing recommended approach for resolution within Avaya CMS

Sr. Business Analyst

Responsibilities:

• Working on creating the reports on billing system .
• Working on NetCracker’s products which focus on Business Support Systems (BSS) and Operations Support Systems (OSS) migration.
• Working on creating Defect Reports to Management team and signing off the FSD's from Test Phase.
• Entered the project mid-way and restructured the organizational requirements by initiating one-on-one meetings with each project team lead to properly follow the waterfall methodology the project plan required.
• Working on handling OSS Conversion Activities using SQL, PL SQL, and Unix Scripts.
• Updated Communication’s order management/financial system and customer service database.
• Managed changes and disconnects for Metro Ethernet customer networks included but not limited to WAN IP Hot Cuts and BGP Activations/Changes.
• Designed optical transport networks for long haul and Metro Ethernet applications utilizing C/DWDM and 100G technologies.
• Provided exceptional customer service to retail customers.
• Customize and extend the Oracle E-Business Suite using flexfields, oracle 8i PL/SQL and SQL*Plus scripts, Oracle Forms, Oracle Reports.
• Working in Requirements elicitation techniques such as conducting user interviews and JAD sessions.
• Hand on experience with testing, troubleshooting, and repairing the power.
• Responsible for the co-ordination with product owner for the control unit, ethernet box and all vital components of the HMDS.
• Responsible for the installation of wall mount Ethernet.
• Working on the tracked and solved outstanding issues related to the business intelligence (BI) platform.
• Working on OSS conversion for Netcracker database to analyze location, equipment inventory and circuits for data analysis.
• Currently working on the Business analysis and requirement gathering
• Successful Network Implementation, Installation, and support for the Ethernet migration.
• Working on the OSS migration on analyze, evaluate, select, and implement a new fully integrated business and operational support system.
• Developed Automation test scripts for the Billing system terminator proxy using the QTP automation framework.
• Working on business intelligence (BI) solutions by dimensional modeling design, building business models, configuring metadata, creating reports and using dashboards.
• Worked in mainframe environment and used SQL to query various reporting databases.
• Working on Requirement gathering and functional testing for all applications created internally.
• Supported User-Acceptance phases by performing data validations and metrics calculation across every layer including source systems, Staging, Mart and Microstrategy layer.
• Developed estimates, project plans (Microsoft project), training material, BI reports using Microstrategy
• Followed solely RUP methodologies during the course of the project.
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Create and maintained the RAD (Requirements Analysis Document) and FSD (Functional Specifications Document).
• Create and implement Business Intelligence (BI) strategy.
• Working on for retail, it should be fast, efficient and have an outstanding customer service
• Involved in gathering customer requirements from business user teams spread over Sales, Marketing and Customer service.
• Experienced in analyzing and documenting business requirements and system functional specifications including Use Cases
• Supported LAN Technologies: TCP/IP, Ethernet switching, VLAN concepts, Routing concepts, Web filtering concepts
• Analyzed the sources and targets, transforming the data, mapping the data and populating the data into targets by using Informatica Designer, Workflow Manager and Workflow Monitor.
• Performed the requirement analysis, impact analysis and documented Business Requirements Document (BRD) and Functional Specification Document (FSD) using Microsoft Visio and Microsoft suits.
• Prioritized deliverables, identified gaps, tracked defects, defined system requirements, created artifacts for testing and development.
• Involved in GAP analysis in the identification of business rules, business and system process flows, requirements and assumptions
• Improved documentation and records by maintaining ongoing spreadsheet with all disconnects, collaborating with finance, providing cost savings information upon notification of removal from billing invoice, validating and reporting to upper management.

Confidential, Chicago, IL

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.
• Working with clients to better understand their needs and present solutions using structured SDLC approach.
• Configuring and troubleshooting through our IP and Ethernet equipment. Worked with field technicians, ONSP's and end users to troubleshoot said services to deliver quality products.
• Terminate lines into either RJ11(phone), RJ45(ethernet), box punch downs, or 66 blocks in homes or business IT rooms to provide service.
• 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.
• Used Microstrategy dashboards for data analysis and custom reports.
• Bring outsourced Oracle E-Business Suite support in-house, improve business processes.
• Modified existing software to correct errors, upgrade interfaces, and improve performance for graphic displays and network systems.
• Involved in Logical & Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, and Stored Procedures in Sybase Database Servers.
• Designed and Administered Teradata Scripts, Tables, Indices and Database Objects
• Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.
• Created and managed project templates, use case templates, requirement types and tractability matrix in Requisite Pro.
• Authored progress and completion reports which were then submitted to project management on a weekly basis in MS project.
• Provided trouble tracking, coordination, notification, escalation and documentation to resolve events/issues, efficiently minimizing customer impact.
• Developed comparative statements, reports to examine the existing functionalities and present to the stakeholders Managed and administered the entire telecommunications infrastructure and its associated software, including PBXs, call management systems, voice mail, interactive voice response, call recording, and video conferencing systems.
• Customized IVR (interactive voice response) and ACD (automatic call distribution) to meet the organization call routing requirements.
• Documented detailed Business Requirements Documents (BRD) and Functional Requirement Documents (FRD) using Rational Requisite Pro.
• Provided functional and technical support, troubleshooting and diagnosing hardware and software problems, including desktop, laptop, LAN/WAN, and remote systems.
• Provided trouble tracking, coordination, notification, escalation and documentation to resolve events/issues, efficiently minimizing customer impact.
• Arranging Line ranges & SIM allocation for activations. Provisioning in Switch & validations at Switch end.
• Experience in provisioning system and resolving issues to get the data thru for all account activations.
• Supported subscriber provisioning from the billing system to other integrated systems and network elements.
• Supported to areas of subscriber service transactions, including processing of activations, account changes, deactivations, SIM swaps etc.
• Skilled in understanding business requirements and relate them to the application Systems and tools.
• Assisted with test case design, planning and test execution meetings and provided input, and Suggestions.