SUMMARY

• Seven Plus Years of Professional Experience as Business Analyst with strong knowledge of Telecom industry.
• Extensive experience in analyzing and requirements gathering and writing system functional specifications including use cases.
• Excellent in Developing and evaluating business process Models.
• Proven success as a business analyst through the years, providing a well - balanced understanding of business relationships, business requirements, and technical solutions.
• Reports development using various reporting tools likeTableau, SAS.
• Experienced in requirements gathering and documentation,UAT testing, software implementation, and mentoring of junior business analysts.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile. 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
• Excellent Analytical, methodical, and resourceful approach to problem solving, identifying and documenting root causes and corrective actions to meet short and long term business and system requirements.
• Experience designing and developing SQL statements and queries for Oracle Sybase and SQL Server 2000 database.
• Working knowledge of implementing software development projects using methodologies such as Waterfall, Rational Unified Process, Agile/Scrum.
• Experience in creating design documentation related to system specifications including user interfaces, security and control, performance requirements and data conversion
• Installed and managed VOIPPBX, IVR, and IWR systems.
• Effective in executing multiple tasks and assignments ahead of schedule. Created and maintained effective budgets.
• Involved in creating Dashboards as needed usingTableauDesktop andTableauServer.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Advised management on improvement strategies, Competitive & Profitability Analysis.
• Excellent in Business proposal Risk Assessment. Highly effective management and organizational skills with ability to prioritize.
• Exposure to Client/Server, Web Application developmental tools and Software development and design.

TECHNICAL SKILLS

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

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr. Business System Analyst

Responsibilities:

• Gathered user and business requirements through open-ended discussions, brainstorming sessions and role-playing.
• 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. Developed and implemented policies for post-production issues management.
• Working with clients to better understand their needs and present solutions using structured SDLC approach. Responsible for the implementation of two critical call center vendor applications: Connextions and NICE.
• Functioning also as a Voice Response Unit analyst by supporting the Genesys Call Center application.
• Captured and made executive presentations of the issues and risks inherent in as-is process for review by senior management. It included strategic recommendations for process improvements (re-modeling of Call Center) to enhance Member satisfaction leading to Member retention.
• 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.
• Implemented custom data collection systems. Systems allowed Cingular to move all online and IVR data collection in-house.
• Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
• Scoped, analyzed, designed, tested, implemented a call center IVR/Genesys Voice Platform Voice XML application to handle customer service calls
• Maintained on-going technical assistance and provided help desk support to customer’s mainframe systems software that included problem determination and resolution.
• Responsible for the management of two Application portfolios, both central to client business, involving the maintenance and production support within a mainframe environment.
• Working on generating various dashboards inTableauserver using various sources such as Teradata.
• Perform data validation using SQL queries and run ad-hoc queries to show data to the business users.
• Provided implementation assessment, strategy, and mentoring services for Rational Rose, UML and RUP. Worked with various vendor groups to gauge the effectiveness of their solution
• Suggested web security using encryption and authentication technologies for reporting and complaint filing procedures.
• Building, publishing customized interactive reports and dashboards, report scheduling usingTableauserver.
• 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. Managed workload, schedules and coordinated status review meetings with project managers, business managers and team members.
• Involved in conducting trainings to user on interact, filter, sort and customize views on an existing visualization generated throughTableaudesktop.
• Documented the Use Cases and prepared the Use Case, Activity, Logical, Component and Deployment views using MS Visio and Rational Rose for a clear understanding of the requirements by the development team. Coordinated with testers in using Rational ClearQuest for defect tracking
• Authored progress and completion reports which were then submitted to project management on a weekly basis in MS project. Identified various frequently used modules with in the application as well as the peak user volume for load testing purposes.
• Wrote several SQL scripts for massive data extracts and manage the data conversion and extraction process.
• Coded the ETL and Business Intelligence Batch and On line PL/SQL Packages.
• Establish documentation for Agile methodology for implementation with a very water-fall-centric development team.

Environment: Java, J2EE technology, Windows 2000 Advanced Server, UNIX / Oracle Platform, Mainframe, Business Objects,SQL, MS Visio, RUP, RUM, Agile, Rational Rose 2002, Rational Clear Quest, Rational Clear Case, Rational requisite pro, rational test manager, Rational Robot

Confidential, Bellevue, WA

Business Analyst/Systems Analyst

Responsibilities:

• Coordinated participation and sign-off of various business partners and customers.
• Involved in the analysis of the existing credit card processing system, mapping phase according to functionality and data conversion procedure. Directed/Instructed/Maintained all call Center activities via consolidated reports from technical and managerial staff.
• Continued call Center reporting enhancements with 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. Followed solely RUP methodologies during the course of the project.
• Used the Agile methodology guidelines to carry out every step of the business modeling process.
• Was involved n the creation of new E-Commerce Products (Arrival Notices and Customized Reporting)
• Provide vendor management for OMS. Create, validate and approve estimates provided by vendor.
• Established connectivity to all major buy-side vendor order management systems (OMS).
• Implemented VoIP and IVR technology between corporate offices and converted contact centers.
• 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.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets inTableau.
• Used SoftTest software with pseudo code to ensure test cases covered all branches of project's code impacting the system. (The system is an IBM mainframe based system that contains the master set of customer information used to bill customers.)
• Analyzed business requirements and produced functional specifications for Visual Basic/Oracle and Genesys CTI applications.
• Introduced Agile and RUP methodologies to reflect liquid nature of front-office improving time-to-market
• Created and managed Project Templates, Use Case Project Templates, Requirement Types and Traceability Relationships in Requisite Pro.
• Extensively used data blending, embed functionalities inTableau.
• Planned and defined system requirements to Wire Frame with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies
• Used MS Visio for Process modeling and Business Process flow diagrams. Created business requirement documents and integrated the requirements and underlying platform functionality.
• Developed applications using Business Objects, PL/SQL and Toad
• Interfaced between Business new product builders and System platform builders.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Involved in the testing phase right from the Unit testing to the User Acceptance testing.
• Configured the Data mapping between Oracle and SQL Server 2005.
• Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
• Use Cases and other Process Flow Models were designed using Visio and Rational Rose.

Environment: Rational Rose and Requisite Pro, Omniture, MS Visio, MS Project, UML, RUM, XML, Java, J2EE technology,SQL, Rational Clear Quest, Rational Clear Case, RUP, Agile, Business Objects, Mainframe, Microsoft Excel, Microsoft Word, Microsoft Power Point.

Confidential, Denver, CO

Business Analyst

Responsibilities:

• Followed a structured approach to gathering and formalizing business requirements expressed by managers,process owners and operational users of the information system
• Analyzed business requirements and system architecture/design.
• Identified IS strategy to be followed and related IS strategy to Business strategy and communicated the same through written and oral communication to the top management and Systems Analyst and Designer.
• Worked with MS project, MS Word and MS Excel
• Developed detailed ERDs and DFDs using various modeling tools and developed databases based on the system model following the techniques in SDLC (software development life cycle).
• Involved in Requirement analysis along with the creation of Use Case Scenarios and modeling of the business and application using RUP and UML.
• Captured core business process information, business rules, business entities and other relevant information.
• Introduced Agile and RUP methodologies to reflect liquid nature of front-office improving time-to-market
• Worked extensively in Data Analysis, Data Requirement Analysis and Data Mapping for ETL process.
• Involved in Call handling, Monitoring processes, and CRS work force management processes
• Involved in analyzing, designing and developing Advisor Protal using Windows SharePoint Services (WSS) 3.0 and Microsoft Office SharePoint Server (MOSS) 2007.
• Query the database using SQL Advantage for testing and verification purposes.
• Assisted the project manager in making changes and finalizing the scope of the project
• Analyzed trading partner specifications and created EDI mapping guidelines
• Work closely with developers to review user requirements and understand technical recommendations and constraints, and develop comprehensive and accurate functional specifications; Data Mapping, process flows, and other UML diagrams.
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
• Identified organizational structure, cultural and business constraints affecting options for change and developed business aims.
• Followed Agile (XP) Methodology for the release.
• Assessed risks, costs and potential benefits of alternative business process.
• Developed Functional Specifications and Testing Requirements using Test Director 7.0.to conform to user needs.
• Created business use case, functional (FRS) and technical specifications for trading system.
• Developed Requirements Tractability Matrix (RTM) using MS Project to trace each software requirement to test case.
• Performed manual functionality testing and UAT, maintained Software quality standards and Software quality Matrices
• Tested access control of Siebel call center application by logging using different user ID s and verified views based on responsibilities.
• Interfaced with developers to identify and resolve technical issues and bugs in the software to validate end user requirements.
• Interacted and communicated clearly with development, testing and production teams concerning release management policies and procedures.

Environment: Windows NT Server, Share Point, RUP, UML, ASP.Net, Mercury Win Runner, Test Director,J2EE application server, MS Project,SQL, UML 2000, EXCEL/ VBA

Confidential, Hartford, CT

Business Analyst/QA Analyst

Responsibilities:

• Responsible for gathering user requirements and specifications for designing a mortgage based loan system using and documenting the same.
• Created context and workflow models, information and business rule models, Use Case and Object Models during the analysis using rational tools.
• Conducted Business Requirements, Functional and Technical meetings with Business groups.
• Served as a liaison between mortgage specialists and the project team.
• Extensively involved in maintaining requirements traceability and communicating any changes to these requirements to different business groups and programmers.
• Provide innovative IT, business & e-commerce solutions to perspective and existing clients.
• Was involved n the creation of new E-Commerce Products (Arrival Notices and Customized Reporting)
• Designed changes for Mainframe Systems and Web Based Systems
• Worked on Oracle Manufacturing and Supply Chain Management modules including OM, Shipping and Execution, Pricing, Inventory, and AR.
• Used Query Analyzer, Execution Plan to optimize SQL Queries
• Assisted users after Go-Live and solved issues raised through Issue Management
• Led and conducted JAD sessions for requirements gathering, analysis and design of the system.
• Designed the system, prepared UML and sequence diagrams using Rational Rose.
• Collaborated on creation of documents such as the Vision, business requirements (BR) and business systems design (BSD) documents.
• Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
• Analysis & design using Use Cases, Behavior diagrams (sequence, collaboration), Class Diagrams
• Incorporated Rational Unified Process (RUP) to create Requirement Document Specifications using Visible Analyst.
• 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.
• Responsible for writing detailed descriptions of user needs, program functions, and steps required for developing or modifying software programs using Rational Rose (UML).
• Prepared Functional Specification Documentation (FSD) and communicated these to the stakeholders.
• Actively interacted with different business groups to perform Gap analysis to identify the deficiencies in the system by comparing the actual objectives with the system objectives desired.
• Used MS Visio for Process modeling and Business Process flow diagrams.
• Designed and implemented basic SQL queries for QA Testing and Report / Data Validation.

Environment: Rational Rose and Requisite Pro, MS Visio, MS Project, UML, XML, Rational Clear Quest, Rational Clear Case, SQL, RUP, Microsoft Excel, Microsoft Word, Microsoft Power Point, Mainframe.