PROFESSIONAL SUMMARY:

• Highly motivated and result oriented with overall 5+ years of industry experience as Business/Systems Analyst in the domain of Telecom Industry.
• A self - starter with leadership qualities, interpersonal and communication skills
• 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).
• Working knowledge of implementing software development projects using methodologies such as Waterfall, Rational Unified Process, and Agile
• 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.
• Implemented SOA architecture with web services using SOAP, WSDL, UDDI and XML.
• Experience in Project management in Oracle EBS including OBIEE, Agile Methodology, XP (Extreme Programming), and Six Sigma
• Business Module Practices involved Telecom Provisioning Billing, CRM/OMOF, and Familiar with AMDOCS, CSG-ICOM
• Proficient in MS Office Excel/ Confidential Sheets (pivot tables, VLOOKUP’s, hlookups, macro), Access, PowerPoint, Visio.
• Experience in OSS and BSS solutions as Business Systems analyst, requirements analyst and Confidential modeler of large-scale, complex, real time and non-real time software and hardware systems.
• Expertise on Testing REST API using Robot Framework and SOAP UI
• Solid Knowledge of GSM, CDMA, WCDMA, UMTS, TDMA, EVDO, LTE wireless technology.
• Excellent experience in decomposing Business, Functional and Technical requirements writing Test Plans, defining Test Cases, developing, executing and maintaining Test Scripts, API’s, REST
• Usage of Trackers/Bug Reporters in Quality Center, JIRA, Rally, PTS (Product Tracking System) and knowledge of Test Director, PVCS Tracker, ClearCase, and ClearQuest.
• Created Use Cases, Test Plan and Test Cases and conducted end-to-end SIT/UAT testing on New Product, New Technology and Data migration for several releases.
• Competent in conducting Joint Requirement Planning (JRP) sessions, Joint Application Development (JAD) sessions with a committee of Subject Matter Experts (SME's) senior management and IT groups.
• Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modelling Language (UML) in an SOA environment.
• Good understanding of IP networks and Voice Over IP (VOIP) as well. Strong experience in Telecom BSS/OSS customization.
• Experience with Adobe Experience Manager (AEM) including images and Videos (Digital Asset Management- DAM).
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Gathered requirements and modeled the data warehouse and the underlying transactional database.
• Experience in conducting Joint Application Development (JAD) sessions for requirements gathering, analysis, design and Rapid Application Development (RAD) sessions to converge early toward a design acceptable to the customer and feasible for the developers and to limit a project's exposure to the forces of change.
• Extensive experience with process modeling using UML, flow charts, task diagrams, Sequence Diagrams, Activity Diagrams and Use Cases.

PROFESSIONAL EXPERIENCE

Business System Analyst

Confidential -Stamford, CT

Responsibilities:

• Performed UAT and FAT in system testing, preproduction and preproduction-mirror testing environments.
• Verified the Data completeness, Data Migrations, Data transformations and Data Quality
• 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.
• Participated in UAT and worked with Mercury Quality Center for bug and defect tracking.
• Performed web service validation using Soap UI & automating the test suite.
• Assists contact center business in driving technology strategy utilizing best in class solutions
• Experience in writing Business Requirements Documents BRD, System Requirement Document SRD, Use Case Specifications, Functional Specifications, and Technical Specifications across the Deliverables of a project.
• Developed an understanding of the call types, contact center goals, agent types & expectations, and call center reporting needs.
• Extensively used Microsoft Excel for data analytics Pivot Tables, VLOOKUP, Sorting, Filtering etc.
• Ability to analyze to convert Business requirements for IVR Applications to Test Scenarios
• Analyzed and documented IVR business rules for call routing and developed logical diagrams of the existing CTI routing scripts.
• Setup and configured Authoring and Publishing environments, replication agents, AEM dispatcher to cache the landing pages' html and serve as the static pages from Apache.
• Projects completed implement the usage-based billing for the servers based on the compute, storage and CPU usage and development of cloud enabled offerings. Support integration with BRM billing system and mediation tools. Hubs are built on straight-forward RESTful APIs with JSON payloads regardless of the endpoints.
• 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.
• Involved in Designing the ETL process to Extract translates and load data from OLTP Oracle database system to Teradata data warehouse.
• Used Agile/Scrum Methodology in JIRA Atlassian, Strive for continued excellence for Defect Life Cycle with Development team.
• Created Excel middleware to transfer data from MS Access repository to Excel financials and graphs utilizing pivot tables for each financial category and fiscal year, pivot table detail formulas, and range formulas that can be manipulated to change financial views from month-to-month.
• Manipulated and maintained various addressable interfaces and all related software applications for CSG
• Implemented Web Services (SOAP UI, UDDI and WSDL) to integrate different applications.
• Helped with Data Mapping between the data mart and the Source Systems.
• Validated multiple web services used by the client, both REST and SOAP.
• Worked on custom software applications that integrated the IVR, Advanced Speech Recognition, Directed Dialogue, Call Center solutions, Genesis and Avaya CTI, Web, and foreign host connectivity and transactions
• Experience in Understanding VUI Voice User Interface documents and Call flows to extract the IVR testing scenarios.
• Worked on status reports, issue/risk identification, and test management & followed Agile/scrum Methodology.
• Responsible for collecting and documenting the business and technical requirements for the Network applications which interface with the OSS/BSS applications.
• Extracted data from various sources like Oracle, XML, flat files and SQL Server.
• Provides operations and support services in delivery for contact center implementations services
• Extensively used Test Director to review and update the status of entire testing process.
• Involved in training with the business users on AEM content authoring, Digital Asset Management and workflows.
• Queried database using the SQL for data validations
• Facilitate discussions, requirement and defect resolutions between the business and development teams
• Schedules and conducts requirement sessions with subject matter experts

Business System Analyst

Confidential -Norwalk, CT

Responsibilities:

• Researched on business requirements, documented system workflow procedures, planned the project flow using SDLC methodology.
• Reviewed and approved system change requests and developed detailed provisions for implementation.
• Facilitated team meetings to coordinate activities for project schedules with the management, Marketing & Sales Managers, clients, SME's and technical managers conducting JAD sessions.
• Had planned deadlines assigning the responsibilities, monitored and summarized project progress on weekly basis.
• Responsible for third party vendor network connectivity to the AMDOCS billing system.
• I had done extensive end to end testing on various SOAP and REST web services using SOAPUI Pro tool.
• Evaluated, analyzed, and made recommendations for global IT management processes using Cobi maturity models.
• Responsible for capturing the requirements for the Integration between Network and OSS/BSS applications.
• Prepared status reports for upper management regarding focusing on the status of project on different modules.
• Used UML/RUP approaches to deliver the use cases, conceptual and detail designs, architectural flow, test plans, and business requirement.
• Created test data (metadata, XML, Json) following the schema and performed SQL and NOSQL (Mark Logic) queries for data verification and integrity.
• Identified and documented business rules and created detailed Use Cases on different scenarios.
• Developed the test plan, test conditions and test cases to be used in testing based on business requirements, technical specifications and/or product knowledge.
• Acted as a resource in understanding how IS systems carry out business functions and assists in ensuring the timely and effective implementation.
• Worked closely with Product marketing team - AEM developers.
• Performed web and mobile platform testing for retail and credit card applications by validating the front end and database back end using SQL queries.
• Adept at Microsoft Excel data analytics Pivot Tables, VLOOKUP etc.
• Developed timelines for project delivery, and managed projects and resources to successful completion.
• Established the business analysis methodology using Rational Unified Process technique
• Produced Graphs, Pivot Tables, and Excel Reports, culminating in a PowerPoint presentation comprised of 25 slides, for executive reporting of key performance indicators of procurement and compliance metrics
• 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.
• Trained End-users and customer service agents on the CRM (Customer Relationship Management) application
• Worked extensively with RUP methodology and Rational Suite Analyst Studio using Rational Rose, and Rational Requisite Pro
• Logged defects using JIRA, containing a high degree of detail on the recreation of the problems and providing supporting documents such as error logs and screen shots.
• Worked with Development and Quality Assurance teams on Release, Sprint, UAT Planning and conduct Sprint Reviews, Retrospectives, and Daily Scrums
• Validated both SOAP and REST web services using SOAPUI Pro tool.
• Used Six Sigma Methodologies in solving the errors and issues while the development of the project.

Business Analyst

Confidential -Denver, CO

Responsibilities:

• Communicated with product management as well as internal/external customers to understand requirements and business needs.
• Developed Vision Document and use case documents.
• Conducted requirement gathering sessions effectively elicited and helped stakeholders negotiate and prioritize requirements.
• Worked with all phases of the SDLC using technologies including Oracle, Erwin, Data Warehousing, Web sphere and Congo’s.
• Translated the user business requirements into functional requirements for OSS/BSS development.
• 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.
• Wrote clear, concise, and unambiguous business requirements, functional and non-functional requirements, and UAT test cases using business use cases, sequence diagrams, Activity Diagrams, and other UML techniques.
• Worked with IT management and users to resolve trouble tickets and clarify system requirements.
• Worked with developers to developed wireframes for the templates and components for content management software
• Conducted meetings to gather requirements and defined scope for new functions and modifications to existing ones.
• Acted as liaison for a chain of suppliers, and performed some Financial and Accounting Analyses involving Excel Spreadsheets and Pivot Tables.
• Performed SQL backend testing to validate the data integrity in the Oracle database tables.
• Gather all requirements for each release to include COMPOSITE, TIBCO.
• Interviewed SME’s (Subject Matter Experts), asked detailed questions and carefully recorded the requirements in a format that could be reviewed and understood by both business people and technical people.
• Administered JIRA for the rest of the team, requesting new users, creating projects and sub-projects, and components.
• Utilized rapid prototyping tools and techniques to facilitate the development of graphical user interfaces and applications.
• Monitored client expectations through client involvement and communication throughout the lifecycle of the project.
• Involved in designing and documenting REST/HTTP, SOAP APIs, including JSON data formats and API versioning strategy.
• Supported the Amdocs Customer Management Ordering system, Amdocs Billing.
• Resolved conflicts between testers and development teams.
• Facilitated JAD sessions to embrace a problem's dimensions, possible causes, requirements, to propose alternative solutions and to reach a decision.
• Executed SQL queries to retrieve data.
• Experienced in writing test plans, defining test cases, developing and test scripts.
• Frequently updated defect status as per the current status of the testing project in the Clear Quest.
• Conducted User Acceptance Testing (UAT).
• Participated in Monthly Meetings, Review meetings, Business Requirements meetings.

Business Analyst

Confidential - Perry, MI

Responsibilities:

• Involved in designing Data Stage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Involved in Managing Data modeling project from Logical design and implementation of Sybase Database
• Expertise in development of High-level design, Conceptual design, Logical and Physical design for Database, Data warehousing and many Distributed IT systems
• Identified source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
• Expanded model of multidimensional data mart practiced UDM Universal Data Models generic data models.
• Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using the UML methodologies.
• Utilized SQL queries for data validation and report generation; worked with XML, Json, SOAP UI, SOAP REST, JIRA, Camunda Modular, and SQLyog.
• Working on Lifecycle, Create and follow up on JIRA tickets for the change requests received from various business partners. Test them in prestage and test env to validate and bring them to closure.
• Involved in development of telecommunications teaching material for the Confidential staff, this included: telecommunications concepts, architectures, and protocols, and the systems that are required to implement both OSS and BSS solutions.
• Captured requirements for TDS billing enhancements and performed source to target data mapping for TDS billing ODS
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
• Created RUP activity diagrams and sequence diagrams to analyze the requirements and recommend solutions.
• Created hash tables used for referential integrity and/or otherwise while transforming the data representing valid information.
• Enabled Proper selection of the hash table design parameters for faster table look-up.
• Created Error Files and Log Tables containing data with discrepancies to analyze and re-process the data.
• Used Aggregator stages to sum the key performance indicators used in decision support systems.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.