SUMMARY

• Highly motivated and result oriented with 8+ years of industry experience as Business Systems Analyst with 6 years of experience in Telecom industry.
• In - depth domain knowledge Business Domain includes Telecom OSS/BSS - OSS/BSS Solutions.
• Experience with Network Design & implementation of Enterprise Networks using Cisco routers, Catalyst Switches and Load Balancers etc.
• 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.
• Solid experience with SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity
• Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
• Working experience of firewalls like Cisco PIX, Cisco ASA Appliance and Checkpoint.
• Excellent working knowledge of TCP/IP protocol suite and OSI layers
• Experience in business consulting for Mobile Commerce, Customer Relationship Management (CRM), Enterprise Resource Planning (ERP) and Enterprise Content Management (ECM) solutions.
• Performed UAT and exposure to User Certification Testing (UCT) and Operational Readiness Testing (ORT)
• 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
• Excellent knowledge of the out-of-the-box capabilities of Siebel Call Center, Siebel Help Desk, Siebel Service Request Management, Siebel Order Management, Siebel Event Management, Siebel Contracts Management & Siebel Campaign.
• Architected the end-end OSS solution components (Service Assurance, Service Fulfillment)
• 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
• 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.

TECHNICAL SKILLS

• OOAD (OOA/OOD)
• RUP
• UML
• OSS
• OSS/BSS
• SDLC
• Agile
• Waterfall
• QA
• WAP
• CVS
• TEAMMATE
• MS Access
• SQL Server
• MySQL
• PL/SQL
• SOA
• Oracle DBA
• DB2. ATG
• Windows 98/2000/XP basic UNIX
• HTML basic DHTML basic XML
• MS Office Suite-Excel Macros
• Project
• Visio
• Adobe Photoshop
• Flash
• Rational- Rational Rose
• Rational XDE
• DOORS
• Cobol
• RequisitePro
• CaliberRM
• Omniture
• Crystal Reports various NIKU products
• C
• C++
• Sharepoint
• Docushare
• BASIC
• Intermediate level-Visual Basic

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr. Systems Analyst

Responsibilities:

• Interacted with the SME’s and Stakeholders to get a better understanding of client business processes and gather business requirements
• As an analyst, working with the Process and Functional Requirements to select the necessary IT/OSS/BSS components (CRM) and the service provider's required preparation for adapting the existing components, while supporting the target processes.
• Followed AGILE methodology
• Worked with the team to provide Pre-integrated solution to automate and improve a coherent domain of OSS process.
• Designing, planning, configuring and implementing of Cisco Enterprise Composite Network models
• Analyzed the current requirement process, identify problems, and made recommendations to improve the process.
• Performed Business process modelling using VISIO
• Involved in testing the conversion of the application into web application using XML web services. Worked on Genesys CTI & IVR/Voice Portal, Genesys SDK, CCPulse, Config Manager, Genesys/Brio Reporting. Siebel CRM
• Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions.
• Developed IVR application for delivery notification of customers shipping information via out going phone calls, including carrier name, tracking info also allowing an escape to customer service use a follow the sun timing program as to deliver the info at an appropriate time.
• Responsible for obtain a high-level design of the service provider's IT/OSS/BSS applications, the impact of the tool chain supporting the main end-to-end operation processes has to be assessed based on the assurance, fulfilment
• Implemented custom data collection systems. Systems allowed Cingular to move all online and IVR data collection in-house.
• Installed and configured of Cisco Routers (800, 1600,1700, 1800, 2500,2800, 3600, 3800,7200,7600 series routers)
• Developed SIVR Functional Specification Documents (FSD) including Visio call Flow Diagrams to visually depict the requirements gathered Customer Experience Flow, and Data Mapping according to Business Operations Requirements Documents.
• Worked with business and system modeling tools such as Data Flow Diagrams (DFD), Process Models, Entity Relationship (ER) Diagrams, and Use Cases
• Functional Analyst on Campaign Assignment & Management, Fulfillment, Literature Requests, eMail Response, eService, Service Request Management, Lead Management, Households, Departments & Labs.
• Performed extensive requirement analysis including data analysis and gap analysis.
• Installed and configured the Cisco IP Phones.
• Installing and designing, supporting and managing a Cisco wireless LWAPP environment, supporting both 802.11a (5GHz) and 802.11b/g (2.4GHz) environments
• Installing and Designing, supporting Cisco 1242 access points
• Experience Knowledge of Cisco WiSM wireless controllers, WCS wireless management system, and 2700 Location Appliance
• Gathered requirements to build an interface that loads employee demographic and Peoplesoft specific data directly from the HR system. Employee data appears in the Workforce Timekeeper application within 20 minutes.
• Considered Unified Dimensional Model (UDM) using views, and Unified Modeling Language (UML) and object-oriented design.
• Participated in SAP blueprint and design weekly status meetings with IT teams to review project deliverables.
• Directed/Instructed/Maintained all call Center activities via consolidated reports from technical and managerial staff.
• Participated in TRB (Technical Review Board) meetings to get reviewed and signed off the requirement documents
• Involved in a report writing tool called Brio to generate reports in PDF format
• Assisted the PM with time allocation using MS project
• Created Wireframes and Mockups
• Managed changes using rational clear case, and maintained traceability in MS Excel
• Participated in discussion on regression testing, release and non-release testing, and positive and negative testing
• Prepared Presentations in MS Powerpoint
• Conducted UAT and Regression testing and performance testing, Software quality standards and Software quality Matrices
• Created User manuals and trained the end users

Environment: Microsoft Office Suite, iRise Studio, Siebel Call Centre, OSS, Siebel Campaign Version 7.8 (client), AGILE, Unix, Documentum, Java, Windows NT/XP, Oracle, SQL, SQL Server, Sybase, VBScript, C#. DOORS, C++, NET, ASP.NET, Business Objects, TestDirector, LoadRunner

Confidential, Rochester, NY

Business Systems Analyst

Responsibilities:

• Responsible for collecting and documenting the business and technical requirements for the Network applications which interface with the 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.
• Responsible for capturing the requirements for the Integration between Network and OSS/BSS applications.
• Monitor, improve, and support all aspects of Network connectivity using Tellabs, Cisco works
• Installation and Configuration of 2 CISCO 7206 Routers that connects entire 25 DNC’s to SNC Installation,
• Gathered requirements to upgrade the Time and Attendance system from a client server to a web-based application with three methods of time entry; Time Clocks, Web and Teletime IVR.
• Service Assurance, Fault Management, Performance Management, NMS, OSS
• Utilized eMbedded Visual C++ and Windows CE to design and implement Street Level Routing and print functions under various configurations of the Mobile Application.
• Implementation of various System Integration projects in Network Management (NMS) and Operations Support Systems (OSS) space.
• Increased the performance of our mobile application by creating a new Java ordering submission process, creating new daemons to move files faster, and updating the database structure
• Wrote Business Cases for the Stakeholders to understand the functioning of the new Underwriting System.
• Designed flexible project foundation enabling rapid implementation of e-commerce website capabilities
• Developed the test plan, test conditions and test cases to be used in testing based on business requirements, technical specifications and/or product knowledge.
• Created Data Dictionary and ER diagrams for data mapping purposes.
• Planned and documented procedures for data processing and prepared data flow diagrams for the application
• Identified gaps and performed gap analysis with respect to CMS requirements
• Developed and maintained procedural manuals for the Customer Service Department. Wrote Customer Service processes and procedures for several IPCo systems including CIS, Outage Management, IVR, and Metering.
• Monitoring and technical support of the company’s wide area computer network which provided real-time transaction processing of prepaid billing and mobile commerce for wireless carriers and content providers.
• Conducted Functional Testing and User Acceptance Testing (UAT).
• Working with clients to better understand their needs and present solutions using structured SDLC approach.
• Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using the UML methodologies.
• Authored Functional Design Documents FRDs for CRM, OSS, Collections.
• Review requirements and understand technical recommendations and constraints, and develop comprehensive and accurate functional specifications; Data Mapping, and process flows.
• Ensure all the necessary documents are delivered to meet the RQM requirements for quality gate
• Responsible for assisting clients in resolving various network and systems management problems using ITIL.
• Created and managed project templates, use case templates, requirement types and tractability matrix in Requisite Pro.
• Study various OSS/BSS processes to understand activity.
• Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
• Migrated Data from MS Excel to SQL Server Reporting Service Using DTS and SQL loader utilities.
• Experience in creating design documentation related to system specifications including user interfaces, security and control, performance requirements and data conversion.
• Use Cases and other Process Flow Models were designed using Visio and Rational Rose
• 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
• Analyzed the test results from QA teams using Performance Studio Analysis to create various scenarios.
• Developed strategies with Quality Assurance group to implement Test Cases in Test manager for User Acceptance Testing.

Environment: ITIL, COBIT,, HTML, OSS, DHTML, Java, Oracle, Siebel Call Centre, UAT, RUP, Express One, IT UP, PRISM, UML, SQL, PL/SQL, MS-Office, MS Project, MS Visio.

Confidential, Emeryville, CA

Business Analyst / PM

Responsibilities:

• Created Interface test cases, report test cases, expected results validation, defect tracking using clear quest, version control using Clear Case VOB.
• Documented the Process Flows for B2C and B2B in the High Level Requirements Document.
• Assisted in helping the management in developing ecommerce Integrated Marketing Platform (IMP) portal to increase the marketing return on investment (MROI) and increase conversion rates.
• Presented discovery documents to the IT activities for acceptance into the integrated and point releases via Statement of Business Requirements documents using MS Word, MS Excel, Telelogic DOORS, and Visio tools.
• Designed and developed Project document templates based on SDLC methodology
• Designed and developed workflow templates and lifecycles for process involving creating content to publishing product information on web.
• Used SQL queries for organizing and abstracting data from MS access data bases, created reports, forms on Ms Access.
• Specialized in integrating information systems and ecommerce/ebusiness initiatives for various organizations
• Established traceability matrix using Rational Requisite Pro to trace completeness of requirements in different SDLC stages.
• Generated Use Case diagrams, Sequence diagrams, Domain Object Model, and Visio to depict process flow and PowerPoint presentations
• Prepared Business Context Diagram, Use Case diagrams and corresponding Activity Diagrams using Rational Rose to depict the workflows to be incorporated into the development of Business Process Management (BPM) tool.
• Captured Data flow diagrams and formatting of the data flowing modeling through interfaces.
• Accumulated system requirements from various departments like accounting, IS (Information Systems) through surveys and interviews.
• Prepared Business Object / Business Process Models that included modeling of all the activities of business from conceptual to procedural level.
• Assigned tasks among development team monitored and tracked progress of project following Agile methodology.
• Led and conducted JAD sessions for requirements gathering, analysis and design of the system.
• Successfully conducted JAD sessions, which helped synchronize the different stakeholders on their objectives and helped the developers to have a clear-cut picture of the project
• Establish documentation for Agile methodology for implementation with a very water-fall-centric development team.
• Provided expertise in strategic planning, business process modeling, business process analysis, object-oriented analysis & design, use case modeling, use case analysis, component-based development, and quality assurance.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML and Business Process Modeling (BPM)
• Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio.
• Responsible for meetings with users and stakeholders to identify problems, resolve issues and improve the process to ensure a stable and accurate solution.
• Created context and workflow models, information and business rule models, Use Case and Object Models during the analysis using Rational tools.
• Conducted interviews, meetings and JAD sessions during the process of Requirement Gathering
• Created exceptions report which were then submitted to project lead and stakeholders on a regular basis.
• Facilitated user acceptance testing and test strategies with Information Systems Group.
• Performed manual front-end testing to check all functionalities of different modules.
• Suggested measures and recommendations to improve the current application performance with the aid of SCR’s (Small Change Requests)
• Developed strategies with Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT (User Acceptance Testing
• Created and managed project templates, use case project templates, requirement types and traceability relationships in RequisitePro and managed the concurrence of the parties involved with respect to the evaluation criterion

Environment: JSP, Oracle, Java, J2EE, HTML, XML,DOORS, Weblogic, SDLC, Clear Case, Clear Quest, XSL Agile, Rational Rose, JAD, MS Visio, UML, MS Project, SQL, MS Access, MS Excel and MS Word

Confidential, Bothell, WA

Business Analyst

Responsibilities:

• Involved in development phase meetings for Business Analysis and Requirements Gathering.
• 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
• Involved in performing version control and defect tracking activities using Rational ClearCase and Rational ClearQuest.
• Develop change management procedures for implementing requirement changes and/or enhancements and consistently tracked the requirements status throughout the project life cycle.
• Increased the productivity of our customers by creating an efficient UI for the mobile application
• 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.
• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Wrote Test Cases in MS Excel for user registration, access to training material, and activity log-in, reviewed the test cases and finalized
• UAT testing performed along with call center managers to make sure that application meets their requirements.
• Managed and organized requirement coverage, Test Case Management and Defect Management using Mercury Quality Center.
• Involved in the complete SDLC system providing SOW to the client notifying the client about the work to be done in detail, specifying both hardware and software involved (Scope of Work).
• Established traceability matrix using Rational Requisite Pro to trace completeness of requirements in different SDLC stages.
• Maintained on-going technical assistance and provided help desk support to customer’s mainframe systems software that included problem determination and resolution.
• 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.
• Created advanced Excel reporting models via the use of VLOOKUP statements and Pivot tables
• 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), Business Objects, IBM DB2/UDB Universal Database Oracle 8/9i, MS SQL Server 7.0, MS Visio, MS Excel, MS Access, HTML, XML, UNIX, Windows NT, Sybase.

Confidential, Plano, TX

Business Systems Analyst

Responsibilities:

• Establishing communications channels with all stakeholders to define the project scope, release schedule management and project deliverable.
• Gathering and Managing NCS automation tool requirements from multiple external vendors AT&T, Microsoft IPTV and Cisco as well as internal stakeholders such as Networking Engineering, Architecture and Deployment Groups.
• Coordinating and Interfacing with Confidential ’s Networking Engineering and Architecture Group for feasibility, usage and Planning for NCS Automation tool.
• Brainstorming sessions for defining NCS Architecture and flexible Interfaces points for internal and external usage.
• Product presentations and demonstration of Automation Tool to internal Users and external Customers.
• Leadership and Mentoring to NCS team as well as other related Confidential groups.
• Managing Project execution and Implementation of all NCS interface points using C#.NET, ASP.NET, SQL Server.
• Maximizing productivity of development staff, improved customer satisfaction, and achieved faster project turnaround.
• Accomplished by developing reusable components promoting code reuse, template code systems and enhancing the NCS Tool performance.
• Handling Change Management and new features/enhancements during regular release cycles.
• Single point of contact to provide regular Production Support and prioritizing implementation of change requests.
• Involved in testing the conversion of the application into web application using XML web services.
• Establish Test/Development to Production Export/Import EDI Transport from AS/400 to UNIX and assist in transition from legacy system(s).
• Prepared Functional Specification Documentation (FSD) and communicated these to the stakeholders.
• Experience in writing extensive SQL Queries on AS/400.
• Worked on several mainframe based applications running on an AS/400 platform.
• Implemented Enterprise Architecture Repository and associated reports and process support using IBM/ Telelogic System Architect.
• Assisted in the development, design and implementation of new relational or multi-dimensional databases, including the analysis of user needs.
• Extensive experience using SQL for report generation and support using SAS modules
• Upon successful IBM/ Telelogic System Architect software implementation created role based training and user guide to cover information organization, artifact management rules, and product customizations.
• 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
• 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.

Environment: Microsoft Office Suite, Microsoft Visio, Unix, Documentum, Windows NT/XP, Oracle, SQL, SQL Server, Sybase, VBScript, C#. DOORS, C++, NET, ASP.NET, Business Objects, TestDirector, LoadRunner

Confidential - Columbia MD

Business Systems Analyst

Responsibilities:

• Facilitated process movement to standards and procedures that involved implementation of MASC codec for IVR systems.
• Familiarized with Computer Telephony Integration
• Cisco IOS and Cisco CatOS configuration and backups, Uploading and download IOS and Cisco CatOS using XModem, TFTP and FTP protocols
• Installed and configured Cisco 3640, 2601,805 routers at Districts.
• Installed and configured Cisco 3750, 3550, 2800XL Catalyst switches at Districts.
• 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.
• Established traceability matrix using Rational Requisite Pro to trace completeness of requirements in different SDLC stages.
• 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.
• 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.
• 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.
• Used Iterative Software Process for the development of the Reports.
• Interacted and conducted meetings with the Marketing Team to discuss pricing initiatives.
• Created a Traceability Matrix to maintain the Traceability of the requirements.
• Used MS Project Gantt charts create the different modules of the project.
• 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.

Environment: Windows XP, MS Office, MS Project, SQL, Visio, AGILE, DNS, ViaVoice, PSM, MATLAB, Adobe Audition, ACT, .NET