SUMMARY

• 7+ years of IT experience in the Analysis, Design, Development, DW ( Data - warehouse), Testing, and Implementation of business application systems for, Financial, Insurance Sectors and as Salesforce Business Analyst and ERP Consultant in Salesforce.com.
• Extensive experience as a Business System Analyst for Business Analysis with hands-on project management skills in User Requirement Gathering and Transforming Business Requirements into Software Requirement Specification (SRS) using MS Office Suite, Rational Rose Suite and proficient in Project Management responsible for the Software Development Plan.
• Extensive knowledge of Salesforce.com implementation cycle in Sales, Marketing, Service and support modules.
• Voluminous Experience in Agile, Rational Unified Processing (RUP), Unified Modeling Language (UML), Capability Maturity Model (CMM) and Use Case Specification Documents (USD).
• Possess comprehensive understanding of CRM business processes like Campaign Management, Lead Management, Account Management, Case Management, Quote, Forecasting, and Call Center.
• Sound Proficiency in analyzing and Creating Use Cases, Use Case Diagrams, Activity diagrams, Class diagrams, Data Flow Diagrams, Business Flow Diagrams and Sequence diagrams using MS Visio and Rational Rose.
• Organized many Joint Application developments (JAD) and Joint Requirement Planning sessions (JRP), Interviews, workshops and requirement Elicitation sessions, Rapid Application Development (RAD) sessions with end-user/clients/stakeholders and the development group.
• Comprehensive Knowledge in reviewing Test Procedures, extensively worked with the QA Team in executing the Test Plans for UAT, providing Test Data, creating Test Cases, analyzing bugs, interacting with team members in fixing errors and also assisted in Post - Production support. Worked on Black box, White box Testing and also worked with stakeholders to obtain deliverable sign-offs.
• Deep understanding of Database management system, Data warehousing concepts, Business Intelligence technologies and Data mining.
• Strong business perception, strategic thinking, communication, interpersonal and presentation skills, adept at creating, editing, and coordinating extensive communication networks.
• Expert in using software Automated testing tools like Quick Test Professional ( Win Runner) and Load Runner

TECHNICAL SKILLS

Operating System: Windows7/XP/NT, UNIX, Linux

Modeling Tools: MS Visio, Rational Suite (Rose, RequisitePro, Clear Case, ClearQuest)

Utility Tools: MS Office Suite, MS Project, TOAD 8.0, Adobe Photoshop, MDM, Agile, Data Warehouse(DW), Business Objects (BO), ETL Informatica

PLMDBMS/RDBMS: Oracle 8i/9i/10g/11g, MYSQL, MS SQL Server, MS Access, Siebel, Netezza

Language: Visual Basic, AS 400, XML SQL, PL/SQL

Packages: MS Office Suite, Dream weaver, Adobe Photoshop

Testing Tools: Win Runner, Load Runner, Test Director, Quick Test Pro

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Data Warehouse Analyst

Responsibilities:

• Conducted interviews, meetings and JAD sessions during the process of Requirement Gathering.
• Worked with business analysts for requirement gathering, business analysis, and translated the business requirements into Data Requirements to build the Enterprise data warehouse Dimension (EDW) and FACT tables.
• Good Knowledge on Star vs Snowflake Schema and OLAP Vs OLTP system.
• Worked on Informatica ETL Data Integration tool to migrate the data, to create mapping from source to ODS (Operational Data Source) and then to Target of Netezza Appliance.
• Moved the mappings, sessions, workflows from one environment to other
• Planned and documented procedures for data processing and prepared data flow diagrams for the application.
• Modify and develop new ETL transformations, summary tables, data staging areas based upon redesign activities with Informatica ETL tool.
• Experience with complex SQL queries for data profiling for Data ETL Integration tool.
• Analyzed and translated business requirements into system specifications utilizing UML and Visio Diagrams.
• Conducted weekly meetings for deciding the Policies and Procedures to be followed while constructing new sites.
• Involved in capturing functional and non-functional requirements, prepared vision document, workflows, use cases, data and financial modeling. Reviewed of the system architecture, design and system test plans.
• Responsible for analyzing the existing system and understanding the associated business.
• Prepared the Project Charter document and got sign-offs from the team.
• Established a business Analysis methodology around the RUP (Rational Unified Process). Helped develop use cases, project plans and manage scope.
• Responsible for analyzing the format of data that comes from the Health Professionals, association and determined a standard format to interface it with any external system using XML.
• Prepared XML Schemas and DTDs for integrating data of acquired banks.
• Created mapping elements between data models and identified the data relationships.
• Defined various data elements creating a data dictionary containing names of the tables, purpose of the tables, and the contents of the tables.
• Responsible for educating the technical documentation team about the processes and the user interaction with the system.
• Responsible for assisting the testing team to develop the test plans and test cases for the system.
• Also worked on Business Intelligence Reporting Tools - BO Business Objects and WEBI

Environment: Rational Rose, Rational Requisite Pro, UML, RUP, MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio), Visual Basic, Win Runner, Test Director, Java, J2EE, Oracle 9i, SQL, Netezza,BI Tools BO, WEBI

Confidential, Des Moines, IA

Business Analyst

Responsibilities:

• Facilitated collection of functional requirements from system users and preparation of business requirement documents (BRD) using Rational Requisite Pro that provided appropriate scope of work for technical team to develop prototype and overall system.
• Played a pivotal role in JAD sessions helping to develop detailed solutions and documented the Functional (FRS) and System specification requirements (SSR).
• Developed a web-to-lead functionality to vertrue.com site which directs leads to Salesforce CRM.
• Created various Reports and Report folders to assist managers to better utilize Salesforce as a sales tool and configured various Reports for different user profiles based on the needs of the organization.
• Worked as an Interface between the end users and the different teams involved in the application development for the better understanding of the business and IT processes.
• Involved in Design and development of Workflows rules, triggers, validation rules and other customizations with Salesforce
• Followed a structured approach to organize requirements into logical groupings of essential Functional Requirements, Non Functional Requirements, Interface Requirements and Report Requirements and insures that critical requirements are not missed
• Conducted GAP analysis to regulate the gaps in the requirements and conveyed to various modules of the project.
• Prepared Business Process Models (BPM) that includes modeling of all the activities of the business from the conceptual to procedural level.
• Prepared Workflow diagrams to analyze AS IS and TO BE scenarios, designed new process flows using MS Visio and documented the business process and various business scenarios.
• Performed quality audits of the requirements and distributed to all stakeholders. Conducted user interviews and JAD Sessions as a part of the requirements elicitation.
• Documented Test Plans that contains test scripts, test cases, test data and expected results for the Integration, Functional, Performance, and User Acceptance Testing (UAT).

Environment: MS Office Suite (Word, Excel, Access, PowerPoint, and Outlook), MS-Project, Share Point, Visio, Requisite Pro, SQL, Netezza, Remedy

Confidential, Cincinnati, OH

Business Analyst/Data Warehouse Analyst

Responsibilities:

• Facilitated the gathering of functional& non-functional requirements from system users and prepared business requirement documents that provided appropriate scope of work for technical team to develop and test prototype and overall system.
• Worked on Data-warehouse to conduct data requirements so as to provide guidance to Informatica developers to load the data in Target tables in Data-warehouse environment and to product BI ( Business Intelligence reporting)
• Conducted analysis on OLAP facts and Dimension tables.
• Performed business analysis, which included orchestrating JAD sessions, arranging meeting with stakeholders to gather requirements, and writing use cases and test cases/scripts.
• Conducting the JAD sessions.
• Conducting meeting with Japan user, German user, European user and Indian user for the gathering of requirement.
• Analyzing the Gathered functional requirement to write the BRD and FRD.
• Writing the defect log and conducting the audit for all the phase of SDLC life cycle.
• Writing the audit documents such as SER audit template, Technical audit template, verification log etc.
• Making the high-level work flow diagram.
• Making the process map using the MS Visio 2010..
• Helping the Project manager in making Project Plans.
• Assigning the task in MS project to various projects.
• Coordinating with QA, .Net Developer, UI team and Business owner for the fulfillment of the requirement.
• Coordinating with UI regarding the prototype, wireframe, and Markup for GACA requirement gathering and implementation.
• Identifying the user need by following the user centered design approach in secondary project called blade logic, which was lite project and had some experience in analyzing the User Centered Design.

Environment: MS Office Suite 2010 (Word, Excel, Access, PowerPoint, and Outlook) Web logic,MS-Project, Visio 2010, MS Share point 2003.

Confidential, Clevelend, OH

Business Analyst

Responsibilities:

• Prepared and presented the requirements for proposed system of claim management, system enhancement and functions to senior management by closely working with stakeholders
• Gathered business requirements of policy administration (by working with underwriters), enrollment, claims, billing and shipping through interviews, meetings, JAD sessions and observations and performed business analysis for the requirements of the project.
• Assisted project managers by providing and facilitating estimated efforts for the project work and in calculating the cost of the project and budgeting and timekeeping
• Performed Business Process mapping (BPM) for new requirements and identified the gap (Gap Analysis) between the existing & proposed business process (using AS-IS and To-Be) to redefine the process (BPI) and SOPs.
• Performed statistical analysis to generate listings and graphs that aid in the identity management, business forecasting and decision making for the changes requested and cost behind all changes for the work in flight for Rogers/FIDO/Telstra clients
• Produced detailed requirements documentation and provided estimates to stakeholders by using various Asurion internal tools like HLE, ROM, PSEC report, etc. for multiple client projects
• Participated in sessions with management, SME, vendors, users and other stakeholders for open / pending issues and follow up for clarification of Rogers/FIDO/ATT requirements
• Generated Requirement Traceability Matrix (RTM) for Business requirements of Telstra/Rogers/FIDO/ATT/Verizon client projects and user stories and functional specifications. Worked with backlog team to add, prioritize and manage work in Agile vision
• Designed the functional and technical specs document and communicated requirements to design, development and QA teams using UML diagrams.
• Clearly and concisely coordinated and communicated business requirements to impacted product teams, documented, gathered data and project milestone data to stakeholders
• Performed impact assessment and identify the impacts, facilitated tradeoffs and communicated impacts to POR (Plan of Record) team and business stakeholders, delivery team and product owners by closely working with project team to integrate change management activities into the overall plan
• Developed strategies with Quality Assurance group to implement Test Cases in HPQC and worked with business for UAT (User Acceptance Testing) validation
• Closely worked with Client BAs, Product teams (On shore and offshore), Delivery team, Solution Architects, Project Managers, Stakeholders for successful project completion

Environment: Informatica ETL, QC, Rational Requisite Pro, Visio

Confidential, Boston MA

Business Analyst/QA Analyst

Responsibilities:

• Worked with the business community to define business requirements and analyze the possible technical solutions.
• Requirement gathering, Business Process flow, Business Process Modeling and Business Analysis
• Worked with the Business community, Tech Lead and 3rd party vendors in gathering their requirements and data transaction information related to OLTP, OLAP and ASP.
• Co-authored business requirements document with project teams. Extract, discuss, and refine business requirements from business users and team members.
• Worked with the QA team in testing the upgraded system for data retrieval, using complex SQL queries.
• Performed extensive requirement analysis including data analysis and gap analysis.
• Implemented QA testing and report/data validation with basic SQL queries.
• Facilitated and managed meeting sessions with committee of SME from various business areas including Mortgage Servicing, Loan Monitoring and Asset Management.
• Extensively involved with the trading activities of Credit Derivatives, Interest Rate Derivatives, FX Derivatives, Equity Derivatives and Commodity Derivatives; and Futures including Commodity Futures Contracts and Financial Futures
• Used the Quick Test Professional to perform Automation testing.
• Performed the Black Box Testing—Functional Testing, Load Testing, User Acceptance Testing, Stress Testing of the web applications.
• Extensively involved in creation and review of documentation at all stages of the project.
• Artifacts reviewed include Project Plan, Test Plan, Test Case Reports, Integration Testing Reports, etc.
• Generated automatic test scripts to test the relevant web services by using the QTP tool.
• Parameterized the script for Load Runner for Emulating thousands of users.
• Performed Performance Testing using the Load Runner.
• Helped with Data Mapping between the data mart and the Source Systems.
• Extensive work experience with Portfolio Managers, Experienced Traders, and Compliance Manager to configure the rule-based scenarios for capturing market and credit risk, general multi-factor sensitivity analyses, and PnL.
• Developed and implemented processes and tools for requirements gathering, analysis, planning, tracking and delivery using Rational Rose requisite pro - RUP
• Designed and developed Use Cases and UML models using Microsoft Visio.
• Prepared and analyzed AS IS and TO BE in the existing architecture and performed Gap Analysis. Created workflow scenarios, designed new process flows and documented the Business Process and various Business Scenarios and activities of the Business from the conceptual to procedural level.
• To organize meeting and send agenda of the meeting, draft minutes to keep all invitees of the meeting on a same page.

Environment: MS Project, MS Office Suite, RUP, UML, Rational Rose, Requisite Pro, Clear Case, Rational Clear Quest, MS office suite, MS Visio 2003, SharePoint, Mercury Load Runner, Mercury Test director

Confidential

Junior Business Analyst

Responsibilities:

• Assisted team in preparing project plan, time lines, scope document, stakeholders and resource identification.
• Responsible for meeting with Business Process Owners and SME (Subject Matter Experts) and gathered requirements for creating the system using prototypes and document analysis.
• Developed questionnaires and interviewed application users.
• Articulated Business Requirements from user interviews then converted to Use Cases &technical specifications (SRS).
• Interacted with the customer and program team to evaluate and prioritize the stated user requirements and analyzed complex issues and provided comparative analysis of alternatives leading to a solution recommendation, action plan.
• Created and maintained Requirements Traceability Matrix (RTM) and involved in system analysis and design.
• Conducted Joint Application Development (JAD) sessions with the development team to develop and understand the business requirements and created work flow diagrams using Visio.
• Wrote and executed SQL queries and converted to Excel for data analysis effort for ad-hoc reporting.
• Identified resources and allocated tasks to maximize resource utilization.
• Performed business process analysis and implemented business process re-engineering techniques.
• Involved in providing technical expertise to define defect remediation process for QA team and provided detailed estimates for the change control process.
• Responsible for the completion of projects within specified time and budget dealing with financials, project work flow, change management and dealing with vendor relationships.
• Collaborated with the QA team to develop the test (plans/scenarios/cases/data) to be used in testing based on different business requirements.
• Assessed the following factors: aesthetics, layout, consistency, and user effort in determining user interface designs
• Involved in conducting UAT to make sure that all the user requirements are catered by the application.
• After successful development and testing of the product, participated in product release and deployment to end-user.

Environment: Microsoft Office Suite, MS Visio2003, MS Project2003, MS Excel2003, Java, JSP, Windows XP, Solaris10, Requisite Pro2003, Clear Quest2003, PVCS, Toad8.6