SUMMARY

• 7 Years Professional Experience as Systems/Business Analyst in Telecom Environment.
• Extensive experience in analyzing and requirements gathering and writing system functional specifications including use cases.
• Excellent in Developing and evaluating business process Models
• User Experience and User Interface Design for web, iPad and iPhone
• Proficient in developing and executing Test Procedures, Test plans, Test scripts, test result validation, performing functional, usability, stress testing and ensuring that the software meets the system requirements.
• Extensively involved in Market Research, Feasibility Studies, System Analysis and GAP Analysis
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall
• In - depth knowledge in Testing Applications for functionality, industrial strength, environment, and usability with emphasis on end-to-end system testing, user acceptance testing, test plan & test procedural development, tool validation & setup, project customization & administration, and defect management
• Expertise in UML (class diagrams, object diagrams, GAP Analysis, use case diagrams, state diagrams, sequence diagrams, activity diagrams, and collaboration diagrams) as a data analysis methodology for application functionality designs using IBM’s Rational Rose.
• Have worked on Business Analytical Reporting using BI Tools like Business Objects and Cognos 7.0.
• Expertise in using Informatica Power center / Power Mart for data extraction, transformation and loading (ETL) from desperate data sources like oracle, SQL server, flat files, MS Access, JMS and XML files and load the data into different targets.
• Solid understanding of Business Process definition, Risk Analysis and SDLC methodologies.
• Excellent in Developing and evaluating business process Models.
• Proven success as a data analyst through the years, providing a well-balanced understanding of business relationships, business requirements, and technical solutions.
• 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).
• Worked on straightforward DBMS queries, knowledge of HTML and xml
• Full understanding of Unified Modeling Language (UML) and SDLC models like Rational Unified Process (RUP), Waterfall, Prototyping and Agile.
• Professional experience in data analysis, operations management and development, design, documentation and testing.
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, Promodel, MS Excel, MS Access, MS Visio
• Effective in executing multiple tasks and assignments ahead of schedule. Created and maintained effective budgets.
• Developed plan for data feeds and data mappings for integration between various systems, including XML
• 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
• Waterfall
• QA
• WAP
• CVS
• TEAMMATE
• MS Access
• SQL Server
• MySQL
• PL/SQL
• Oracle DBA
• DB2. ATG
• Windows 98/2000/XP basic UNIX
• HTML basic DHTML
• Agile/Scrum basic XML
• MS Office Suite-Excel Macros
• Project
• Visio
• Adobe Photoshop
• Flash
• Rational- Rational Rose
• Rational XDE
• DOORS
• Cobol
• Requisite Pro
• Caliber RM
• Cognos
• Crystal Reports various NIKU products
• .Net
• C
• C++
• Sharepoint
• Docushare
• BASIC
• Intermediate level-Visual Basic

PROFESSIONAL EXPERIENCE

Confidential, Dallas TX

Systems Analyst

Responsibilities:

• Involved in business requirements, HLD,HLS analysis/review meetings
• Interacted with stakeholders to finalize the Business Requirements Document (BRD) in terms of Content, Pricing and Store / WAP Page Structuring.
• Responsible for creating Use Cases, Business Process Modeling and Work Flow Diagrams using MS Visio and MS Excel Performed the requirement analysis and documented the requirements.
• Analyzed system requirements, developed detailed Test plan, Test cases, Test scripts for testing the functionality, GUI and security testing.
• Performed Functional, Regression, System and Integration testing for Middleware Wireless, Wireline and Uverse applications
• Scoped projects and identified opportunities for business system improvement in internal controls.
• Acted as a liaison between the billing department and Marketing in support of gathering and documenting requirements, developing process flows, writing use cases and specifications.
• Conducted business process analysis on customer experiences with input from senior management, managers, supervisors and subject matter experts.
• Conducted JAD and RAD sessions.
• Designing the user experience and user interface for desktop, web, iPad and iPhone trading applications.
• Used Unix boxes, Oracle, XMLs, Junit, WINCVS, XMLSPY, Clear Quest, SOAP,HPQC to perform various tests on mobile applications.
• Suggested changes to the Physical Data Warehouse Model based on the ETL and Referential Integrity gap requirements.
• Transferred data (ETL) to Data ware house Environment using SSIS and SSAS.
• Building the cubes by using SSAS.
• Automated Shell scripts to pull and load data from operational resources into the Data Staging Area and Data Warehouse for business intelligence reporting.
• Worked on Dynamic Data as well as integrations with mobile platforms, including the iPhone, iPod, and iPad.
• Used SQL queries to retrieve and validate the data in the subscriber profile databases using database tools like TOAD, SQL Developer
• As a BI Developer, Created Universes for report generation using Designer module in Business Objects.
• Used integration strategy and delivery model to streamline deployment of mobile applications
• Reported the defects using Clear Quest, HP Quality Center and Jack Track
• Worked closely with development team, business analysts and project managers to resolve the defects found during testing phases
• Regression tested on high level functionality of previous release to ensure new code, configuration has not impacted the code already in the production
• Provided the end-to-end services for the entire project lifecycle
• Performed UAT testing for clients like Apple, Amazon, BestBuy, Ericsson, Echeck etc.
• Proved Red Hat support after the code went into production

Environment: Java, XML, HTML, Web logic, Oracle, HP Quality Center, LDAP, ETL, Business objects,Windows XP,Unix, SOA tool, Jack Track, Clear Quest, Junit, Putty, XMLSPY, SOAP, Win CVS, WinSCP

Confidential, Richardson, TX

Systems/Business Analyst

Responsibilities:

• Gathered business requirements from the users and Subject Matter Experts by conducting interviews and Questionnaires.
• Used a phased approach to identify and verify key business areas.
• Managed the requirements and developed a Traceability matrix using Rational Requisite Pro
• Participated in meetings with Developers, Project Managers and Quality Analysts to discuss business requirements, test planning, resource utilization, and defect tracking.
• Managed the overall SDLC for internal and client driven enterprise software initiatives including the development of business needs and requirements, development maintenance, measurement and support for client interactive marketing programs, websites, desktop, web and mobile applications.
• Developed Business requirement document, Functional Requirement Document, and Use Case Specification Documents
• Developed and maintained the RTM for chance management
• Developed Use cases, process flowcharts and workflow Diagrams Using Microsoft Visio.
• Converted Business Requirements to the Functional Specification.
• Conducted informal Sessions to develop an architectural solution that the application meets the business requirements, resolve open issues, and change requests
• Assured that all Artifacts are in compliance with corporate SDLC Policies and guidelines.
• Conducted JAD Sessions to develop an architectural solution that the application meets the business requirements, resolve open issues, and change requests
• Worked with the quality assurance team so as to test different releases and to develop test plans and test cases.
• Conducted training sessions for the end users and documented a training manual.
• Involved in UAT, test plans, documentation of test reports, etc.

Environment: Apache Web-Server, UNIX, Oracle, PL/SQL, Java, JSP, JavaScript, RUP, Microsoft Visio.

Confidential, Newark, NJ

Business Systems Analyst

Responsibilities:

• Worked with PM to coordinate daily activities between applications development and Product Management. Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.
• Facilitated various JAD sessions with development architects and business leads to develop both high-level and detailed application architecture to meet business needs.
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content. Created wireframes Mockup and storyboards.
• Wrote Test Cases in Mercury Quality center that would test various Test scenarios.
• Extensively uploaded test cases from MS Excel, MS Word to Test Director & Quality Center.
• Performed extensive data modeling to differentiate between the OLTP and Data Warehouse data models. Core responsibility involved complete manually testing of the User Acceptance Test (UAT).
• Verified the remaining Business Objects installation works without any issues.
• Assisted project managers with the development of project schedules. Developed requirements and preliminary design for client applications. Performed analysis and design projects using a systems development methodology. Worked with all levels of client staff in solution definition.
• Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team
• Prepared design documents, ETL specifications and migration documents
• Create and maintain data model/architecture standards, including master data management (MDM).
• Used master data management (MDM) to define reference data
• Administer and supervise the BO environment by monitoring/granting permissions and rights to vast users.
• 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.
• Performed custom data conversions and developed custom software for risk management applications. Performed all data field mappings. Documented existing proposed process flow, analyzed current and target system, conductedGAP analysis.
• Used the different types ofviews inRequisite Pro Attribute matrix, to display requirements of a specified type. Participated in logical & physical designsessions and developed design documents.
• Create additional documentation to communicate planned system functionality and implementation processes to the business and development teams consisting of data flow diagrams.
• Automated Shell scripts to pull and load data from operational resources into the Data Staging Area and Data Warehouse for business intelligence reporting.
• Created & Deployed SSIS (SQL Server Integration Services) Projects, Schemas and Configured Report Server to generate reports through SSRS and knowledge of SSAS in SQL Server 2005.
• Identified, researched, realized, investigated, analyzed, defined and documentedbusiness processesandUse Case Scenarios.
• Captured requirements for Confidential billing enhancements and performed source to target data mapping for Confidential billing ODS. Created test plans, test cases and test scripts for UAT.
• Developed application using Visual Basic. Strong in manual testing, Automated testing in Visual Basic & other protocol of automation tools Experience in testing applications under. Net, Windows.
• Designed and developed allUse CasesandUMLmodels usingRationalandVisio.
• Assisted project team in preparing Functional Specification Document (FSD), developednon-functional requirements, and documentedBusiness Requirements Document (BRD).
• Prepareddetailed design documentsto translate business process effectively for developers and product managers usingMS Visio. Played a key role in the planning, testing, and implementation of system enhancements and conversions. Worked with MS Excel to produce Macros and Pivot tables
• Documented and evaluated test cases/test results/feasibility study of various ETL tools like Data Stage/ Informatica. Participated in entering and tracking systemdefects inRational Clear Quest.

Environment: Rational Requisite Pro, Clear Case, Clear Quest, SQL Server, Agile, MS Project, Business Objects, MS FrontPage, MS Access, Documentum 2.0., Microsoft Excel, Microsoft Word, Visual Basic, Microsoft Power Point, MS Visio.

Confidential, San Ramon, CA

Business/Systems Analyst

Responsibilities:

• Designed 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.
• Generated Surrogate ID’s for the dimensions in the fact table for indexed and faster access of data.
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
• Drew Business Process Flow diagrams by extensively using MS Visio.
• 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.
• Served as a resource for analytical services utilizing SQL Server, and TOAD/Oracle.
• Used Query Analyzer, Execution Plan to optimize SQL Queries
• Enabled Proper selection of the hash table design parameters for faster table look-up.
• Created re-usable components using shared containers for local use or shared use.
• Imported and exported repositories across projects.
• 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.
• Worked extensively with Microsoft Excel (Macros, VLOOKUPS, and Pivot Tables). Proficient Microsoft Word, Power Point, Access and Lotus Notes.
• Tuned Data Stage transformations and jobs to enhance their performance.
• Assist other project teams with data analysis, data mining and data profiling as needed.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Created job schedules to automate the ETL process.
• Enhanced the job properties for performance tuning.

Environment: PL/SQL, Java (J2EE), PMAP, Test Director, Win Runner, RQM, MS Office, MS Visio, MS Project, ISDN protocols, eTom, ITIL, HDLC, RUP, VOIP, UML, CobiT.