Business Analyst Resume

KRISHNA TEJA GUDAPATI

Phone # 917-***-****, e-mail ID: *******@*****.***

Summary of Credentials

• Over Seven years of experience as a Business/Data/Systems Analyst with project management skills in the software development industry. Experience with expertise in Process re-engineering of Client/Server and Web based applications.

• Complete understanding of BA methodology and Software Development Life Cycle utilizing Rational Unified Process (RUP).

• Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML).

• Strong knowledge of UML Modeling, including Use Cases, Sequence, State and Activity diagrams, Data mapping, participated in architectural design and class design

• Experienced, detail-oriented Quality Assurance Professional providing in-depth technical experience with a proven track record of results.

• Extensive knowledge and Hands on experience in activities related to SFDC, Sale Force setup, Configuration, Customization, Administration, Data Migration, Integration and deployment of applications to Force.com platform for large user groups.

• Good experience in activities related to Define and Manage Objects, Creating page layouts, Developing field validations, formulas and work flow rules using Sales Force.com web site and Eclipse IDE for Sales Force.

• Well versed in Migration and Integration of CRM applications for large enterprise customers.

• Good knowledge in administration and usage of Mercury Test Director/Quality Center, Mercury Dashboard and Integration of Mercury and non-Mercury products with Quality Center.

• Integration of Rational Tools with Mercury Quality Center, Version Control Mechanism on Mercury Quality Center using VSS or Clear Case.

• Provide implementation assessment, strategy, and mentoring services for Rational Requisite Pro, Rational Rose, Rational Clear Case, Microsoft Visio and Project.

• Experience in conducting GAP analysis, ROI analysis, TCO analysis, SWOT analysis and Cost benefit analysis

• Reviewing Service level Agreement (SLA) and Change Management

• Specialized in Requirements Tractability Matrix (RTM), test plans, test procedural development and review, tool validation and setup, project customization and administration, defect management, configuration management, version control and business documentation.

• Extensive experience in conducting Joint Application Development (JAD) sessions with end-users, Subject Matter Experts (SME’s), Development and QA teams.

Technical Highlights

Methodologies RUP, UML, Agile (XP/ Scrum), Waterfall, Spiral, RAD

Defect Tracking Tools Rational Clear Quest, Test Director, Mercury Quality Center, QTP, Service Desk, PVCS

Process Modeling Tools Rational Rose, Microsoft Visio

Project Management Microsoft Project, Microsoft Office

Version Control Systems Rational Clear Case, VSS

Web Technologies FrontPage, Dream weaver, Photoshop, Rapid SQL

Languages C, C++, SQL, AQT, Visual Basic, Microsoft.NET, VB. Net, J2EE, Cold Fusion, Toad, Oracle

SalesForce.com Apex, Visual force, S-Controls, SOQL, SOSL, Triggers, Force.com IDE

Operating Systems Windows xp/9x/2000/NT servers, Unix, AIX, Solaris

Databases/Query Tools/Web SQL server, HTML, XML, MS Access, Excel, Toad, Teradata SQL Assistant, Business Objects, Visual sciences, ClickStream, Web Trends, Informatica, MicroStrategy Reporting Suite & Web-reporting services, Cognos Visualizer and Cognos ReportNet

Professional Experience

AT&T Corp. December 2006 – Current

St. Louis, MO Business Analysis/Mgmt

AT&T U-Verse represents IP-based services integrating Digital Video, High Speed Internet and voice over IP services. Our team focuses on the monitoring, analysis and ad-hoc reporting for Self-Service and Customer Care areas of Lightspeed. We are responsible for the applications used by online customers and call center agents to place orders, do account management, perform billing functions, and report trouble for the Lightspeed suite of services.

Responsibilities:

• Responsible for updating the executive dashboard to track LS order/sales and the performance of AMSS and CRM.

• Understand logical diagrams, data models and tables in OMS, CRM production systems and Enterprise Data Warehouse (EDW).

• Created complex Ad-hoc reports, Dashboard Reports, KPI’s, Business views containing charts showing U-Verse sales, products, posted installs, in-service customers, disconnects, revenue by regions, market areas & divisional managers using Toad, ERwin data modeler, Business Objects, Visual Studio, SSRS, VBA, SalesForce.com Dashboards, Reports and SQL.

• Generate stored procedures, macros and triggers to improve processing time.

• Generate daily/weekly/monthly dashboards and reports from various BI sources for readouts and reporting to the Business and IT Leadership.

• Create and Update data definitions to reflect the correct data and definitions in the Metadata and communicate with the Metadata management team to verify the data.

• Update the business rules, business logic and data definition rules to reflect the current data passed to the downstream systems/applications

• Perform detail analysis on Business requirements, Data requirements, System requirements and conduct gap analysis to meet the business needs.

• Conduct JAD sessions with DBA’s, Data Analysts, Technical architects and developers to gather technical and non technical information.

• Worked on various salesforce.com standard objects like Accounts, Contacts, Leads, Campaigns, Reports and Dashboards.

• Involved in the requirement gathering, documenting, Sandbox testing, User Acceptance Testing of Apex code, AJAX, JavaScript VisualForce components, SOQL, SOSL statements and other advanced Salesforce customizations.

• Created the Business and Functional Requirements and conducted walkthrough’s with the developers.

• Implemented the requirements on Salesforce.com platform and Force.com IDE Plug-in using Eclipse.

• Developed Custom Objects, Custom Reports and configured the Analytic Snapshots to dump the data on regular basis for the sales performance and lead generation statistics.

• Involved in Data Migration from Oracle database using Informatica On Demand.

• Documented Triggers and S-Controls and created rules based Automated workflows.

• Involved in Salesforce API & Application Integration with other application

• Developed and configured various Reports and Report Folders based on the business needs.

• Thorough understanding of Salesforce, SOQL, Security framework, Dashboards and Reporting module.

• Document the interface design, data mapping and data conversion rules.

• Defined and Created the end-to-end testing scenarios, test conditions, test cases, test scope.

• Provided the test data, expected results and documented the business requirements, scenarios and use cases.

• Coordinated and actively participated in all phases of software testing, (UAT, Integration, System, Regression). Solid input for ensuring proper execution of all test procedures and automated test scripts in disaster recovery environments.

• Conduct demonstrations and walkthrough’s with the Marketing and Business leads to get approvals for the end-to-end test cases, case scenarios, test plans to be conducted for the User Acceptance Testing.

• Worked one on one with QA Management to define and develop the testing templates into a format that could be better used by the testers and raised quality levels.

• Analyzed requirements, created comprehensive test cases, wrote automated regression scripts and managed failed test cases and defects. Kept Quality Assurance on track to meet scheduled deadlines.

• Execute test cases, perform traceability analysis and reporting Manual testing defects through Quality Center.

• Defect Reporting and tracking through bug reporting tool Mercury Quality Center 9. 0

• Ensure that all the test cases are updated in the Quality Center along with Master test plan.

• Extensively used 'Mercury Quality Center' for creating tests, logging defects, reviewing, analyzing and comparing defects.

• Created the flow charts and data mapping tables indicating the input files, output datasets and capacity planning for the data flow to the downstream applications.

• Co-ordinate with downstream technical teams to determine technical requirements, data requirements, database structures, validate data and resolve/document any data issues

• Perform data analysis and Data mapping from source(s) system to target system(s)

• Build and maintain new queries from existing queries in Business Objects, Teradata SQL Assistant, Oracle SQL developer and MS Access to support the ongoing changes in production and EDW.

• Worked as a liaison between the business users and the Amdocs (Third party vendor) team in making customizations according to the business needs.

• Use MS Visio to draw business process flow diagrams

• Analyze Business Requirements, Use Cases, Activity Diagrams

Environment:

MS Project, Office, Visio, Access, Excel, PL/SQL, Oracle SQL Developer, Business Objects, Vantive, Toad, Visual Sciences, VBA, Clear Case, Teradata SQL Assistant, QTP, Quality Center, Oracle9i/10g, J2EE, J2EE, XML, JSP, Loadrunner, Test Director, Manual testing, VSS, SaleForce.com platform, JavaScript, Apex, VisualForce, Apex Explorer, SOQL, SOSL, Triggers, Apex Data Loader, Informatica On Demand, SQL Server Services (SSRS, SSIS, SSAS), Visual Studio, Reports, Workflow and Approvals.

A G Edwards & Sons March 2006 – November 2006

St. Louis, MO IT Business Analyst

Branch Supervision and Oversight concerns monitoring and producing alerts for the home office team to check for any sort of Money Laundering processes carried out by financial consultants or occurring at the branch offices. The AML package models produce alerts depending on the type and location of the branch.

Responsibilities:

• Responsible for gathering and creating the business specifications and Functional specifications for each model

• Interacted with the end users to identify and gather business requirements and transform them into technical requirements

• Create and Analyze business requirements, technical requirements, functional specifications to meet the end user needs.

• Interacted with Actimize (Third party vendor) who provide the AML models

• Utilized Rational Unified Process (RUP) to create Process Flow, System Flow, Use Case Diagrams and Interaction Diagrams using Microsoft Visio and Rational Rose.

• Conducted walkthroughs of the Actimize documents and involved in the preparation of the Road map, License Agreement for AML models and Project plan

• Worked to bridge the gap between end users, IT and Actimize.

• Worked to bridge the gaps between the versions 2.7 and 3.1 of the AML package

• Conducted JAD sessions with the Business users, Technical architects, Data management team and the UAT team

• Performed Gap Analysis, Coordinated with IT team in designing and creating tables, data mapping for database using XML.

• Worked as a liaison between the business users and the Actimize team in making customizations according to the business needs

• Worked on resolving issues during testing and production

• Integrated Requisite Pro with Clear Quest and Rose to provide all teams visibility and maintain tractability among requirements, use cases and change requests.

• Identified and prepared Use Cases, Activity Diagrams / State Chart Diagrams using Rational Rose according to UML methodology thus defining the Data Process Models

• Helped in the preparation of data mapping documentation migrating data from BETA to BULL and from BULL to CENTRAL DATA.

• Maintained and managed different versions of Documents

Environment:

Rational Rose, Advanced Query Tool, Microsoft Visio, Microsoft Project, Microsoft office, Cognos, Rational Clear Quest, Rational test manager, Rational Requisite Pro, Oracle, XML, ACCESS, VB.NET.

Credit Union ONE September 2005 - March 2006

Detroit, MI Business Analyst

This application is used to create an automated process flow for requesting and approving exceptions to corporate technology standards which helps to assist employees who are connected to the internal network. A browser-based front-end, SQL based back-end with SMTP alerts and history reporting.

Responsibilities:

• Responsible for defining the scope and implementing business rules of the project, gathering business requirements, and documenting them textually.

• Responsible for writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS).

• Worked to BRIDGE the gaps between IT and Business Client.

• Conducted JAD sessions with different technical teams and other stakeholders.

• Analyzed Business Requirements and segregated them into high level and low level Use Cases, Activity Diagrams / State Chart Diagrams using Rational Rose according to UML methodology thus defining the Data Process Models.

• Utilized Rational Unified Process (RUP) to create Process Flow, System Flow, Use Case Diagrams and Interaction Diagrams using Microsoft Visio and Rational Rose.

• Worked with the technical team to prepare FRS documents for design interfaces, data conversions and data mappings

• Conduct Business Process Testing in Mercury Quality Center and QTP.

• Integration of Rational Tools with Mercury Quality Center, Version Control Mechanism on Mercury Quality Center using VSS or Clear Case and Carried out defect tracking using Clear Quest

• Create and Execute test cases and reporting Manual testing defects through Quality Center.

• Edited and contributed to Help for a Change Request Management module

• Conducted the FRS and URS reviews and walkthroughs with designers, developers.

• Involved in maintaining and managing different versions of Documents.

• Used Test Case distribution and development reports to track the progress of test case planning, implementation and execution results.

• Created Use cases, activity report, logical components and deployment views to extract business process flows and workflows involved in the project.

Environment:

HTML, Rational Rose, Rapid SQL, Microsoft Visio, Microsoft Project, Microsoft office, Rational Clear Quest, J2EE, XML, Microsoft Office, ACCESS, Load runner, Test Director, Quality center, VSS, Clear case, Cold fusion, Visual .NET Studio with Microsoft .NET framework, ASP .NET, SQL server 2000, SOA,XML, Shell scripting, MQ-Series, Web Logic.

Alliance Capital May 2004 – August 2005

New York Business Analyst

Pacesetter is a data warehouse for Alliance Capital that brings in and integrates data with market. It acts as the data hub for all the systems within Alliance Capital and makes it available for investment managers for analysis and portfolio management and client reporting.

Responsibilities:

• Worked with the business users, and the tech Leads to define business requirements by JAD sessions, Captured, analyzed and documented the possible technical solutions.

• Business specifications for Changes to Pacesetter Data Base Application and Reports

• Co-author business requirements document (BRD) with project teams. Extracted, discussed, and refined business requirements from business users and team members.

• Data mapping from source(s) system to target system(s)

• Prepared design and implementation data migration document using EIM technology to extract data from legacy database to Oracle 8.1.7

• Experienced in problem solving and bug tracking reports using Bug Tracking tools like Test Director, Quality Centre and Clear Quest.

• Responsible for activities including the development and execution of software and data conversion test plans, scripts, and scenarios; regression testing; evaluation of test results and software performance; monitoring of any data conversion efforts for data quality; identification of technical, functional, and data conversion defects; and user acceptance testing.

• Execute Manual and Automated test scripts of Client/Server, Web applications

• Used Rational Unified Process (RUP) methodology to perform Case modeling, Use Cases, Activity Diagrams, and Sequence Diagrams

• Responsible for coordinating the change management process including estimating change requests, analyzing business and technical impact

• Collaborated with the QA team to develop the test plan, test conditions and test cases to be used in testing based on business requirements.

Environment:

Microsoft Project, Rational Rose, Microsoft Visio, Visual Basic, Middleware, XML, OXML, Data Junction 7, SQL Server, Erwin 4.0, Sun Solaris server, Win-NT, TOAD, Microsoft Office, Access, PVCS.

Schering-Plough October 2003 – May 2004

Kenilworth, New jersey Business Analyst

This project involves in Global Pharmaco Vigilance Systems under the Report Validation umbrella to produce ad-hoc drug safety reports for Post-Marketing clinical research.

Responsibilities:

• Interacted with the end users to identify and gather business requirements and transform them into technical requirements

• Received Requests from Medical & Safety Services to process clinical trial Serious Adverse Experience (SAE) reports for, Clinical Trial Managers and Medical Monitors

• Performed Requirement Analysis to develop Use Cases, activity diagrams and hence documented conceptual design of application following RUP methodology.

• Created the flow charts and data mapping tables indicating the input files and the output datasets

• Documented by Report and Drug category of all requests into Test Scripts, Developer Logs, Memos and Output Templates

• Successfully mapped data from Access to Oracle AERS in order to generate Safety and Signaling reports

• Interacted with OQRs (Operational Quality Reviewers) and other team members to co-ordinate and timely produce reports required, based on priority.

• Achieved clinical documents and scan images into Archive database pertained to each request completed

• Interact with the Medical Department regarding clarification of medical issues related to SAE reports, including identification and MEDRA coding of AE terms

Environment:

Rational Requisite Pro, Rational Rose, Case Trakker Enterprise, Microsoft Visio, Rational Test Manager, SQL Server, HTML, PVCS Version Manager, Microsoft Project, Microsoft Office, Access

Wachovia Bank October 2002 – September 2003

Charlotte, NC Business Analyst

Wachovia is a diversified financial services company that is rapidly growing and merging with several small banks. The project was to make a “Consolidated Client Information File – CCIF”. The customer information from these disparate databases is consolidated into one Centralized database.

Responsibilities:

• Captured, analyzed, finalized and documented the Business Requirements for the application requirements with business heads through proper communication channels.

• Interacted closely with SMEs (Subject Matter Experts), stakeholders, designers and software developers to understand the full functionality of the application and navigational flow while keeping them closely updated about Business User’s sentiments.

• Performed Gap Analysis, Coordinated with IT team in designing and creating tables, data mapping for database using XML.

• Utilized Rational Unified Process (RUP) to configure and develop process, standards, and procedures and create a Business requirement Document.

• Developed detailed ERDs and DFDs using various modeling tools and developed databases based on the system model following the techniques in SDLC.

• Conducted walkthroughs of the Business Requirement Document with the business users and the IT project managers.

Environment:

SQL Server, Microsoft Project, HTML, Rational Rose, Microsoft Visio, Rational Test Manager, XML, IBM AIX, Win- NT, Oracle Forms & reports

HDFC Ltd March 2002 - September 2002 Andhra Pradesh, India System Analyst

It is a private sector bank in India engaged in retail banking, wholesale banking and transactional banking. I was involved in post merger operations of HDFC Bank with Times Bank.

Responsibilities:

• Analyzed business needs for the new cash management application.

• Worked closely with clearing operations, corporate banking as well as external business partners to come up with requirements for the new systems.

• Interviewed several users in groups and personally to design a prototype for new web based application.

• Analyzed existing functionality systems for both the banks and revised them as the needed.

• Established a business analysis methodology around the Rational Unified Process (RUP).

• Assisted in building a business analysis process model using MS Visio.

• Designed and developed use cases, activity diagrams, sequence diagrams, and OOD using UML.

• Developed a metrics for profitability analysis of customer accounts based on transactional cost based on which special promotional offers were extended to foster banking relationship.

• Coordinated focus group meetings with customers to obtain feedback for new product and services.

Environment:

Rational Test Suite, MS-Visio, MS-Project, SQL Server, HTML

Education

Master of Science in Engineering

The University of Texas Pan-American, Edinburg, Texas

References

References provided on demand

Contact this candidate