Sr. Business Analyst Resume
Denver, CO
SUMMARY
- Over 8 years of Telecom industry experience as Sr. Business Analyst
- A self starter with leadership qualities, interpersonal and communication skills
- In - depth domain knowledge of Telecom, Networking and Automobile Industry.
- Network provisioning used in the telecom industry, refers to the provisioning of the customer's services to the network elements. It requires the existence of networking equipment and depends on network planning and design.
- Proficient user of CRAN, 3g, 4g LTE technologies.
- 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).
- 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.
- Hosted OSS/BSS Network Inventory Management System is a comprehensive, integrated network operations framework across different networks, technologies and services provided by CSPs to their customers.
- Provides in depth knowledge of IoT networks for SCADA solutions
- 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.
- 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.
- Academic Experience in conducting SWOT analysis, Gap analysis, Risk analysis, Net present value (NPV) analysis, Return on investment (ROI) analysis.
- 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
- Creative and Aggressive person capable of forming and maintaining positive and productive team environments and with integrative thinking skills.
PROFESSIONAL EXPERIENCE
Confidential, Denver, CO
Sr. Business Analyst
Responsibilities:
- Conducted detailed and comprehensive business analysis by working with the client IT staff, supervisors, and end-users, in order to identify system and operational requirements and improvements.
- Gathered requirements for all the different phases of the project. Conduct individual and group sessions with sponsors and users to gather business requirements.
- Develop strategic partnerships with the business unit to develop a solid knowledge base of the business line, including the business plan, products and processes.
- Document the business requirements and help the business to signoff the business requirements.
- Created Use-Case diagrams and State diagrams using MS Visio
- Work with OSS SMEs, BSS SMEs, and Solution Architects to maintain the integrity of the vision of the business client throughout the SDLC
- Develop business and functional use cases, project plans and manage the project scope.
- Assisting with Qwest business communication API’s (SOAP/REST) & APN builds, and assistance with UWS, VIP and IoT ThingSpace platforms
- Delivered presentations on Project Status and Current Open Issues Report to Users, Stakeholders and other involved groups
- Provide strategic support in development of detailed project plans, work assignments, target dates etc.
- Conducted gap analysis to identify the compatibility between the legacy system and the new business requirements.
- Conducted weekly meetings with the development and testing team to relay any changed requirements and updates on the development and testing.
- Play a key role in the planning, testing, and implementing system enhancements and conversions
- Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD (Object oriented Design) using UML and Visio.
- Conduct workflow, process diagram and GAP analysis to derive requirements for existing systems enhancements
- Act as a resource in understanding how IS systems carry out business functions and assists in ensuring the timely and effective implementation
- Worked closely with project manager in handling the whole project.
Environment: HTML, DHTML, Oracle, VB, J2EE RUP, MS Visio, MS Project, Quality center
Confidential, Richardson, 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.
- 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.
- 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.
- Provided technical and business knowledge to clients.
- Analyzed data using Excel VBA scripts and Macros
- 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.
Environment: ITIL, CobiT, HTML, DHTML, Oracle, RUP, PMAP, Express One, IT UP, PRISM, Performance Measurement & tuning, UML, SQL, MS-Office, MS Project, MS Visio.
Confidential, Dallas, TX
Systems Analyst
Responsibilities:
- 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.
- Involved in creating, modifying and completing the change requests for various applications using the CR tool.
- Responsible to conduct Peer Reviews for all the Interface Agreements and the swBRD’s.
- Worked with interface detail template (IDT) to update the information contained in the IA.
- Developed the test plan, test conditions and test cases to be used in testing based on business requirements, technical specifications and/or product knowledge.
- Iot solution for remotely monitoring wireless devices on a massive scale
- Developing Test Plan with a Test Strategy for the System testing. Instrumental in creating design and frame work for automation.
- Analyzed the business and functional requirements of the application and also helped in developing detailed test plan and test cases.
- Analyzed data and created class diagrams and ER diagrams for designing databases.
- Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
- Worked with metadata-driven model of physical, logical and service inventory network entities, for easier planning, builds, rollouts, operations and maintenance of multi-technology or vendor or device deployment.
- Followed the UML based methods using Rational Software Modeler/MS Visio to create: Use Cases, Activity Diagrams / State Chart Diagrams, Sequence Diagrams, contextual diagram and Collaboration Diagrams.
- Manage Scope and change throughout the SDLC process of the product.
- Working with clients to better understand their needs and present solutions using structured SDLC approach.
- Defined the test criteria, project schedules and base lined the Test Plan with the help of project meetings and walkthroughs.
- Using detailed knowledge of application features and functions assess scope and impact of business needs throughout analysis and completion of all enhancement specifications
- Performed a gap analysis between the current TWG control framework and COBIT.
- Responsible to design the Software Business Requirement (swBRD), Interface Agreement (IA), System and Feature Design (SFD), High Level Design Document (HLD) and Detail Design (DD).
- Responsible for assisting clients in resolving various network and systems management problems using ITIL.
- Assisted in development of training materials for new technology and process improvements
- Experience in creating design documentation related to system specifications including user interfaces, security and control, performance requirements and data conversion.
- Developing strategic partnerships with the business unit to develop a solid knowledge base of the business line, including the business plan, products, process and revenue streams
Environment: ITIL, CobiT, HTML, DHTML, Oracle, RUP, Express One, IT UP, PRISM, UML, SQL, MS-Office, MS Project, MS Visio.
Confidential, King of Prussia, PA
Systems Analyst
Responsibilities:
- Involved in development phase meetings for Business Analysis and Requirements Gathering.
- Reverse Engineered the existing ODS in to Erwin.
- Responsible for GUI design, Workflow analysis, Prototyping and Business development
- Conducted meetings for the Data Modeling and Analysis.
- Enforced naming standards.
- 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
- 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.
- Tuned the batch programs and online transactions to alleviate performance problems.
- Worked on exporting data using Teradata.
- Developed & executed several Optimized queries in SQL on this data.
- Tested Performance & Accuracy related queries under SQL Server.
- Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
- Analyzed the given source Dimensions and target Fact table structures to develop Surrogate Key tables referencing required dimensions.
- Created Hash tables referencing the Surrogate Key tables for quicker and more efficient lookup to Dimensions.
- Developed various jobs using ODBC, Hashed file, Aggregator, Sequential file, Transformer stages.
- Evaluated, analyzed, and made recommendations for global IT management processes using CobiT maturity models.
- Using Shared Containers and creating reusable components for local and shared use in the ETL process.
- Imported and exported Repositories across DataStage projects.
- Analyzed data with discrepancies through Error files and Log files further data processing and cleansing.
- Trouble-shooted jobs using DataStage Debugger.
- Worked on performance tuning and enhancement of DataStage job transformations.
- Summed key performance indicators using Aggregator stages as an aid to Decision Support Systems.
- Used DataStage Director run time engine to schedule and execute developed jobs and job sequences, and use Log events to monitor job progress and performance.
- Participated in weekly status meetings, and conducting internal and external reviews as well as formal walkthroughs among various teams, and documenting the proceedings.
Environment: Ascential DataStage 6.0(Manager, Director),MS Office, MS Project, Visio, Office, Business Objects, Oracle, MS SQL Server, CobiT, HTML, XML, UNIX, Windows NT, Sybase.