SUMMARY:

• 8+ years of Business/Systems Analysis experience with the ability to work independently and manage business expectations with a delivery - focused approach to work; ability to build and maintain strong working relationships with senior and junior business sponsors, as well technical specialists.
• A self starter with leadership qualities, interpersonal and communication skills, In-depth domain knowledge of Telecom Billing Industry.
• Proficient in all cycles of test life cycle from test planning to defect tracking and managing defect lifecycle.
• Extensive experience in coordinating testing effort, responsible for test deliverables, status reporting to management, issue escalations.
• Extensive experience in Functional testing, Integration testing, Regression testing, GUI testing, Back-end testing, Browser Compatibility testing, (Unified Functional Testing) HP UFT, Ad-hoc testing, Black Box Testing, White Box Testing, System Testing, Build Verification Testing, End to End (E2E testing), User Acceptance Testing.
• Have considerable expertise in Metadata Management, Data Analysis, Data Profiling & Quality, Data Governance and Master Data management (MDM).
• Extensive experience in Test data management (TDM).
• Excellent knowledge of industry standard methodologies like Software Development Life Cycle (SDLC), Project Life Cycle, Rational Unified Process (RUP) and Capability Maturity Models (CMM).
• Legacy Provider Platform BSS/OSS (Wired/Wireless billing and customer care solutions).
• Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
• Experienced in testing the applications behavior on mobile devices and validation of the functionality on IVR systems.
• Performed UAT and exposure to User Testing (UCT) and Operational Readiness Testing (ORT)
• Well-versed in project management tool (MS Project) for status reporting, planning and resource allocation.
• Working knowledge of implementing software development projects using methodologies such as Waterfall, Rational Unified Process, Agile/Scrum.
• Proficient in developing and executing Test Plans, SQL and PL/SQL queries, performing functional, usability testing and ensuring that the software meets the system requirements
• Extensive experience working with vendor e-commerce tools like Microsoft commerce as well as helping construct and integrate in-house ecommerce applications.
• Extensive experience using SCRUM and Agile methodologies.
• Expert level 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) and Cognos.
• Proficient in developing Use Case Model, Analysis Model, Design Model, Implementation Model, Use Case Diagrams, Behavior Diagrams (Sequence diagrams, Collaboration diagrams, State chart diagrams, Activity diagrams), Class Diagrams based on UML using Rational Rose
• Oversaw requirements gathering and installation of Tandberg Video Teleconferencing (VTC)
• Extensive experience with process modeling using UML, flow charts, task diagrams, Sequence Diagrams, Activity Diagrams and Use Cases.
• Experience in writing queries/scripts for data analysis and QA report testing.
• Excellent communication and presentation skills. Experience working with business users as well as senior management.
• In Depth understanding of the AS-IS and TO-BE business processes and experience in converting these requirements into technical specifications for preparing test plans.
• Ability to work cross-functionally and with all levels of the organization

TECHNICAL SKILLS:

Languages: C,C++, Java, SQL

Scripting Languages: Perl, JavaScript, VBScript

Markup Languages: HTML, XML

Methodologies: RUP, Agile, Scrum, UML, CMM, EXPRESS ONE, PRISM, IT UP

IDE/OOAD: Rational Rose, Rational Clear Case, Rational Requisite Pro

Reporting: MS Visio, MS Project Test Director, WinRunner, LoadRunner

Database: Oracle, Oracle DBA, Microsoft Access, Teradata, MS SQL server

Operating Systems: Windows 98, XP, 7, 8, Win server, Linux, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, Farmington, MO

Sr. Business 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.
• Solid understanding of Master Data Management (MDM), Product and Identity data.
• Involved in Project Management for project Billing conversion Wire line commission extracts from Data Warehouse to Optics.
• Migrating Project of different Applications, for OS migration/High Availability/Disaster Recovery implementations.
• Extensive experience in modeling the AS IS and TO BE ecommerce solutions
• Conducted workflow, JAD, Process diagram and GAP Analysis to derive requirements for existing system enhancement.
• Performed OS Migration from Windows 7 to Windows 10.
• Designed Data Flow Diagrams (DFD’s), Entity Relationship Diagrams (ERD’s), and web page mock ups using modeling tools.
• Assist in Re-Engineering the legacy telecom BSS/OSS system which been used by Blulogix (team of architectures and telecom industry experts).
• 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.
• Performed GAP Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Worked with Sprint Wireless on the integration/transition of wireless OSS/BSS and wireless network to Sprint wholesale services.
• Used Balance Scorecard approach for developing program strategy in order to manage the grants program and development of metrics for monitoring success of program. Used Microstrategy dashboards for data analysis and custom reports.
• 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.
• Involved in Logical & Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, Stored Procedures in Sybase Database Servers.
• Delivered video teleconferencing (VTC) and established data connections for multiple national and international.
• Mapped various disparate data files using VBA procedures and functions to output key data elements.
• Create and maintain data model/architecture standards, including master data management (MDM).
• Wrote detailed specifications for various reports generated using Cognos.
• Validation (run test scripts and validate reports generated) for mock, integration and test re-run.
• Elicit requirements using interviews, document analysis, workshops, surveys, site visits, business process descriptions, use cases, scenarios, business analysis, and task workflow analysis.
• Followed Agile Methodology for the release. Used Data Driven Testing methodology to test the application with multiple sets of data.
• Integration of ITIL Processes with other Operational functions.
• Utilized ITIL methodologies to assist accounts in SLA management including incident /change management.
• Provide ad-hoc reporting and analysis from data sources including PeopleSoft (SET) and Teradata.
• Configured the Data mapping between Oracle and SQL Server 2013.
• Develop requirements specifications according to standard templates, using natural language
• Collaborate with engineering to establish the technical vision and analyze tradeoffs between usability and performance needs
• The aim of the project was to enhance the functionalities of various existing applications linked to ecommerce.
• 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: Windows 8/10, ETL, SQL, Oracle 11i/12c, PL/SQL, Cognos, BO, Rational Req pro, XML, HTML, HP QC, QTP, Clear Quest, UAT, Agile, Teredata, MS Excel, VBA, MS Project, RUP, UML.

Confidential, Centennial, CO

Sr. Business / Systems Analyst

Responsibilities:

• 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.
• Followed the guidelines of AGILE methodology.
• Responsible for setting up centralized Test Data Management Service TDM and Test Case Management Standards and Guidelines within the Carrier Global Testing Services.
• Risk Analyst for TDM Network Migration to IP Network.
• Lead Automation Test Engineer for TDM Network Migration to IP Network.
• 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.
• Migrated Windows Server 2008 from test environment to the production environment.
• As part of CRM Activities, gathered client data, managed, tracked and analyzed this data to improve customer relationships and targeted marketing campaigns and pricing along with Marketing Team.
• Worked on exporting data using Teradata.
• Performed regression and user acceptance testing during various stages of the development.
• 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.
• 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.
• Wrote SQL statements to extract data from the Tables.
• Plan, review and executed DevOps and software testing in Agile approach & aggressive project schedules providing input on project schedule risks, testing risks and dependencies.
• Analyzed trends and design phases in the industry and applied the knowledge gained to creating comparisons, and tradeoff summaries.
• 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.
• Led the development of a program to train users on a custom web application and a Cognos ad-hoc reporting environment.
• Used Iterative Software Process for the development of the Reports.
• Using UNIX console commands to check database has been connected the other functionalities.
• 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.
• Managed various Excel documents required for data processing using high level complex VBA scripts.

Environment: Windows 7/8, MS Office Suite, VBA, Sharepoint, DevOps, Unix, Java/J2EE, ETL, Cognos, Agile/Scrum, PL/SQL, SQL, VB script, Req Pro, Java script, HP QC, QTP, JIRA, HTML, XML, WSDL, XSD, SQL server, Oracle 10g/11i, RUP.

Confidential, Dallas, TX

Sr. QA / Business Analyst

Responsibilities:

• Tested same rule instance, in a Data Stage flow for computational purposes and in the DPI portal for display purposes
• Involved in Project Management for project Billing conversion Wire line commission extracts from Data Warehouse to Optics.
• Executed billing utilizing ICOMs and UNIX.
• Develop and delivery ITIL compliant CMDB, Service Catalog, Ordering and Billing capabilities.
• Stored stake holder conversations as part of CRM Activities in detail using ACT 5.0.
• Worked on the integration/transition of wireless OSS/BSS and wireless network to BT wholesale services.
• Designed Data Flow Diagrams (DFD’s), Entity Relationship Diagrams (ERD’s), and web page mock ups using modeling tools.
• Telecom OSS/BSS provisioning with multiple interfaces for SOA application.
• Request Access Privileges (Request access to Shared Drive, SQL and VSS).
• Data analysis on ICOMS different version ran testing script. Validated and centralized ICOMS data.
• 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).
• 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.
• Involved in Logical & Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, Stored Procedures in Sybase Database Servers.
• 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.
• Elicit requirements using interviews, document analysis, workshops, surveys, site visits, business process descriptions, use cases, scenarios, business analysis, and task workflow analysis.
• Provide ad-hoc reporting and analysis from data sources including PeopleSoft (SET) and Teradata.
• Configured the Data mapping between Oracle and SQL Server.
• Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
• Develop requirements specifications according to standard templates, using natural language
• Collaborate with engineering to establish the technical vision and analyze tradeoffs between usability and performance needs
• The aim of the project was to enhance the functionalities of various existing applications linked to ecommerce.
• Create business rules in Trillium to find the incorrect data and compare with source allowed values
• 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: ETL, Cognos, Java (J2EE), HTML, XML, Rational Req. pro, clear case, Rational Rose, Clear Quest, UAT, Win Runner, Agile, Teredata, MS Office, MS Visio, MS Project, RUP, UML.

Confidential, Madison WI

Business Analyst

Responsibilities:

• Involved in development phase meetings for Business Analysis and Requirements Gathering.
• Reverse Engineered the existing ODS in to Erwin.
• Conducted meetings for the Data Modeling and Analysis.
• Test Mobile application on various Mobile devices like navigation, UI, self provisioning/campaigns.
• Created the logical models and generated the physical models in the databases using Erwin.
• Involved in jobs and analyzing scope of application, defining relationship within & between groups of data, Star Schema etc
• Increased the productivity of our customers by creating an efficient UI for the mobile application.
• Query analysis and data analysis are done for performance on the OBI Reports using toad for faster response.
• Worked on developing mobile applications using Adobe AIR, the Corona SDK, and PhoneGap.
• Used the guidelines and artifacts of the Rational Unified Process (RUP) to strategize the Implementation of RUP effort in different iterations and phases of the Software Development Life Cycle.
• Worked on JQuery implementation
• Tuned the batch programs and online transactions to alleviate performance problems.
• Developed & executed several Optimized queries in SQL on this data.
• Assured that all Artifacts are in compliance with corporate AGILE Policies and guidelines.
• Extensive experience in modeling the AS IS and TO BE ecommerce solutions
• Tested Performance & Accuracy related queries under SQL Server.
• Develop and delivery ITIL compliant CMDB, Service Catalog, Ordering and Billing capabilities.
• Introduced Agile and RUP methodologies to reflect liquid nature of front-office improving time-to-market.
• Worked on requirements management processes and tools including IBM Rational Requisite Pro and Telelogic DOORS.
• Performed Datacall with GPS application testing with SMS, MMS and Voice call interrupts
• Created Hash tables referencing the Surrogate Key tables for quicker and more efficient lookup to Dimensions.
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Utilized Agile/ SCRUM and PMI methodologies to monitor, steer and develop project objectives.
• Maintained on-going technical assistance and provided help desk support to customer’s mainframe systems software that included problem determination and resolution.
• Developed various jobs using ODBC, Hashed file, Aggregator, Sequential file, Transformer stages.
• Developed test scenarios for Interactive Voice Response (IVR) integration and Avaya CTI screen-pop modules.
• The aim of the project was to enhance the functionalities of various existing applications linked to ecommerce.
• Create prototype SQL Server 2005 Analysis Services (SSAS) cubes using the Unified Dimensional Model (UDM).
• Using Shared Containers and creating reusable components for local and shared use in the ETL process.
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walkthroughs among various teams, and documenting the proceedings.

Environment: DataStage, Business Objects, Jquery, IBM DB2/UDB Universal Database Oracle 8/9i, Agile, MS SQL Rational Suite (Requisite Pro, Rose, Clear Quest), MS Visio, MS Excel, MS Access, DOORS, HTML, XML, UNIX, Windows NT.

Confidential, Warrenton, VA

Business Systems Analyst

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.
• Evaluated, analyzed, and made recommendations for global IT management processes using CobiT maturity models.
• Created test cases and test plans for User Acceptance Testing.
• Proactively identified, analyzed and communicated project issues and risks.
• Prepared status reports for upper management regarding focusing on the status of project on different modules.
• Duties included maintenance of existing and development of new Unix Korn and C shell scripts for sales/marketing EDI data extraction and uploading to Excel spreadsheets and MS Project files.
• Used UML/RUP approaches to deliver the use cases, conceptual and detail designs, architectural flow, test plans, and business requirement.
• 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.
• Helped AMC in developing an enterprise data warehouse/business intelligence road map though JAD sessions, and Six Sigma's QFD process.
• Acted as a resource in understanding how IS systems carry out business functions and assists in ensuring the timely and effective implementation.
• Updating, transferring and sharing Files using FTP between Windows and UNIX machines.
• Developed timelines for project delivery, and managed projects and resources to successful completion.
• Established the business analysis methodology using Rational Unified Process technique
• Trained End-users and customer service agents on the CRM (Customer Relationship Management) application
• Assisted in building the business analysis process model using Rational Rose.
• Worked extensively with RUP methodology and Rational Suite Analyst Studio using Rational Rose, and Rational Requisite Pro
• Used Six Sigma Methodologies in solving the errors and issues while the development of the project.

Environment: Windows, Crystal Reports, MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio), J2EE, Oracle, SQL Server, Unix, RUP, UML.

Confidential, Las Vegas, NV

Business Analyst

Responsibilities:

• Analyzed clients systems and business processes.
• Addressed all aspects of credit card business.
• COBOL is used as a front-end application and DB2 as a back end.
• Established a Business Analysis methodology around the Rational Unified Process.
• Researched the various steps in the lifecycle and then constructed the system in a way that the high-risk customers would be easily identified and monitored.
• Streamlined clerical work processes and mapped then into the new system.
• Developed project plans and managed project scope.
• Involved in gathering and preparing the requirements documents for replacing the existing commercial lines of businesses from legacy to web-based system
• Made changes to legacy Systems as required.
• Assisted in building a Business Analysis Process Model using Rational Rose and Visio.
• Used Castor to create objects from XML documents. Involved in Logical & Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, Stored Procedures in Sybase Database Servers.
• 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.
• Establish documentation for Agile methodology for implementation with a very water-fall-centric development team.
• Prepared High Level Logical Data Models and BRD’s (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements
• Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping.
• Designed workflows and allocated permissions within MS SharePoint.
• Performed extensive Requirement analysis and developed use cases and workflows.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and OOD
• Played a key role in the planning, User Accepted Testing, and Implementation of system enhancements and conversions.
• Prepared for GAP Analysis; identified and documented improved areas to meet capital requirement regulations for Basel II Compliance.
• Provided key input in working with users in defining project and system requirements.
• Designed and Developed ETL (Extract, Transformation & Load) strategy to populate the Data Warehouse from the various source systems feeds.
• Developed strategic partnerships with the business units to develop a solid knowledge base of the business line; including the business plan, products, and process and revenue streams.
• Documented and delivered Functional Specification Document to the project team.
• Conducted JAD sessions for communicating with Stakeholders and Project directors.
• Developed business requirement specification documents as well as high-level project plan.
• Assist the PM in setting realistic project expectations and in evaluating the impact of changes on the organization and plans accordingly and conducted project related presentations.
• Conducted benchmarking activities to identify best practices.

Environment: Mainframes, COBOL, JCL, Db2, Oracle, Rose, MS Word, MS Excel, MS Visio, MS Project, MS SharePoint, Load Runner, Win Runner.