SUMMARY:

• 6+ years of Industry experience as a Business Analyst with solid understanding of Business Requirements Gathering, Evaluating Data Sources, Translating Requirements into Specifications, and Application Design.
• Proficient in Technical and Business Writing, Business Process Flow, Business Process Modeling, Business Analysis and testing various methodologies.
• Expertise in Project Management i.e. Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting and Drafting Remedy Procedures.
• Full technical understanding and know - how on Hyperion System 9/11 EPM Suite of products
• Extensive experience in Hyperion Planning, web forms, business rules, Hyperion Financial Reports, Analyzer/Web analysis.
• Developed business requirements for customers using Hyperion Planning.
• Professional IT experience in OLAP, Business Analysis, Requirements, Development, Testing and Database Administration of Data Warehousing and Client/Server projects using industry accepted methodologies and procedures
• Financial domain expertise with extensive Credit/Debit Card application experience.
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.
• Worked with Rational Suite of tools to create requirements documents (Requisite Pro), visual data models (Rose), manage and track defects (Clear Quest).
• In depth knowledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D).
• Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
• Extremely proficient in using Agile and XP methodologies performed roles of Scrum Master following sprint sessions and used Rally software extensively to write User Stories, assign tasks to individual team members.
• Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
• Proven experience in driving various life cycle stages of an ITIL project from Service Transition, Service Operation to Continual Service Improvement using ITSM and Lean Six Sigma best practices
• Extensive experience in conducting Market Research, Feasibility Studies, Data Analyses, Data Mapping Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management.
• Facilitated Change Management across entire process from Project conceptualization to Testing through Project Delivery, Software Development and Implementation Management in diverse Business and Technical Environments.
• Responsible to Track, Document, Capture, Manage and Communicate the Requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artifacts produced by the teams across the deliverables for a project
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

TECHNICAL SKILLS:

Programming Languages: C, C++, C#, VC++, VB, VB.NET, C#.NET, ASP.NET, Java, SQL, PLSQL

Operating Systems: UNIX, Windows 95/98/NT/2000/XP, Linux.

Databases: MS-Access, MySQL, SQL Server, Oracle, Teradata, DB2, Sybase

Application Servers: IBM Websphere, ATG Dynamo, BEA WebLogic.

Automation Tools: MS Visio, Rational Rose, Rational ClearCase, Rational RequisitePro

Utility Tools: MS Office Suite, MS Project, TOAD, Adobe Photoshop

Reporting Tools: Crystal Reports, SQL Server Reports (SSRS )

Data warehousing Tools: Informatica, Business Objects, Cognos, Erwin

Financial Reporting: Hyperion Analyzer. Hyperion shared services, Excel

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

Sr. Business Analyst

Responsibilities:

• Established a RUP (Rational Unified Process) centric business analysis methodology.
• Collaborated in building a business analysis process model using Rational Rose, RequisitePro, and Visio.
• Provided key initiatives in working with users in defining project and system requirements.
• Provided inputs in the strategic development of detailed project plans, work assignments, target dates etc.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
• Performed requirement analysis, went through all the use cases and issue logs.
• Developed strategic partnerships with the business unit to prepare a solid knowledge base of the business line, including the business plan, products, and process’ and revenue streams aimed towards problem solving.
• Defined and setup the application security in Hyperion Planning, Hyperion Essbase, and Essbase Integration Services.
• Designed and developed all reports using Hyperion Reports.
• Provided technical guidance and support to end-users by developing the documentation required.
• Performed UNIT testing and USER ACCEPTANCE TESTING (UAT) the final step before Rolling out of the Application.
• Worked with Hyperion Support on a number of issue resolutions.
• Worked on several mainframe based applications running on an AS/400 platform
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
• Prepared for GAP Analysis; identified and documented improved areas to meet capital requirement regulations for Basel II Compliance.
• Involved in data migration design so that the data can be exchanged from other systems in standard ACORD XMLife standards.
• Worked on data modeling and produced data mapping and data definition documentation
• Integration of ITIL Processes with other Operational functions
• Development and maintenance of Process Flow Diagrams
• Management for initiation of ITIL Processes
• Partnered with the technical areas in the research and resolution of system and process problems especially related to Power Builder platform.
• Played a key role in the planning, testing, and implementation of system enhancements and conversions
• Performed analysis on enterprise data/report integration & provided functional specification to development team to build Enterprise Reporting Systems.
• Guided development team in the Oracle 9i based database.
• Assisted in presenting reports and analysis to help guide the management.
• Organized cross training of team members and users to become more responsive.
• Assisted in development of training materials for new technology and process improvements

Environment: Windows , MS Office(MS Word, MS Excel, MS PowerPoint, MS Visio), .NET, Oracle, Crystal reports, IBM Mainframes, RUP, UML, SQL, SWOT analysis, GAP Analysis, Hyperion Essbase, Hyperion Planning, Hyperion Shared Service

Confidential, VA

Business Analyst

Responsibilities:

• Defined a complete set of metrics report requirements including a framework that will meet the needs of regional and national business leaders
• Provided analytical data to enable management to make informed decisions to drive continuous revenue cycle improvements by realizing gains in operational efficiency, cost savings and member experience
• Created drill down from the high level summary metrics to the supporting detail in the current report format
• Identified performance indicators that provide reliable daily trend information as a primary input towards the monthly executive dashboard report
• Drafted the existing and known requested list of metrics to the Revenue Cycle process context map
• Analyzed and drafted a functional and technical features list for each vendors, thus identifying the best to send out a RFP
• Defined and setup the application security in Hyperion Planning and Hyperion Essbase.
• Worked with Hyperion Reports team to create Hyperion reports on Essbase Applications.
• Created a prototype presentation in Visio for the SCAL region, thus showing a pictorial representation on the various drill downs from the report to the metrics to the database.
• Identified and drafted the calculations used for various regions, using their source SQL’s for standardization purpose.
• Created Metrics for the National Dashboard by utilizing data from EPIC and Clarity data sources.
• Involved in interactions with Subject Matter Expert, Project Manager, Developers, and the end-users in more than one JAD sessions. MS Project proved useful in coordinating activities with project manager and various other teams
• Modelled the information and then came up with the requirements prioritization. Eliminated false requirements by screening out multiple versions of user input. Final prioritization was based on both, product and process requirements.
• Provided clear and concise documentation regarding requirements management plans, functional requirements, supplemental requirements
• Performed GAP analysis for the modules in production, conducted feasibility study and performed impact analysis for proposed enhancements.
• Coordinated JAD session with system analysts, development team, project manager for application development and Pre-validation specifications

Environment: Windows, PL/SQL, MS-Project, Epic, MS-Office Suite, MS Visio, Rational Requisite Pro, UML, Clear Case, Clear Quest, MS Visual Source Safe, Hyperion Essbase, Hyperion Planning

Confidential, MA

Business Analyst

Responsibilities:

• Involved in the analysis of the existing credit card processing system, mapping phase according to functionality and data conversion procedure.
• 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.
• Utilized the 80-20 rule to prioritize and in corporate the critical features. Used Time-Boxing techniques to finish within set time frames.
• Accumulated system requirements from various departments through surveys and interviews.
• Involved in prioritizing the defects and writing business requirements to resolve them.
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Collaborated with Basel II team on credit risk analysis and issue resolution.
• Communicated the implementation of the new calculation framework of Risk Weight Asset.
• 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 Project.
• Assisted in the development, design and implementation of new relational or multi-dimensional databases, including the analysis of user needs.
• Created and managed project templates, Use Case project templates, requirement types and traceability relationships in Requisite Pro.
• Developed Systems Specifications document to define the impact of the new requirements on the existing system.
• Involved in Performance Measurement to develop measurable indicators that can be systematically tracked to assess progress made in achieving predetermined goals.
• Developed and managed creation of product documentation to communicate features, benefits, positioning and impacts to different audiences and ensured that documentation deliverables from various groups are produced as needed.
• Responsible for gathering requirements from users in operations group and performing data mapping for the application, confirm and vacillating the requirement at time of BA testing
• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Created job schedules to automate the ETL process.
• Involved in performance measurement of ongoing data collection to determine if a program is implementing activities and achieving objectives.
• Involved in reviewing test plans and test cases and ensuring test cases reflect user needs. Also responsible for conducting user training and user acceptance testing to ensure and verify system is designed according to user needs.
• Conducted review sessions on regular basis with QA and development teams for preparing status, delivery report and client reporting.
• Suggested measures and recommendations to improve the current application performance.

Environment: Rational Enterprise Suite (Rose, RequisitePro, ClearCase, ClearQuest), Casewise modeller, IBM Websphere, XML, Java, Unix, C++, J2EE, JSP, Oracle, DB2, Sybase, SQL Server Reports

Confidential, Dallas, TX

Business Analyst

Responsibilities:

• Reviewed and analyzed the business environment and identified process improvements.
• Interacted with Business Users to conduct thorough Requirements Analysis.
• Involved in interactions with the Subject Matter Expert, Project Manager, Developers, and the End-Users.
• Coordinated activities with project manager and various other teams using MS Project.
• Interacted with other Business Analysts for designing and implementation of Use Cases and Test Plans.
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
• Assisted in on-going process improvement efforts to ensure Test Planning, Execution, and Reporting is effective, efficient, standardized, coordinated, and integrated.
• Assisted the Senior Business Analyst in writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS).
• Developed Test Plans and Test Cases according to Business Requirements.
• Provided clear and concise documentation regarding requirements management plans, Functional Requirements, supplemental Requirements, Test Plans and Test Cases.
• Acted as User Acceptance Testing coordinator and monitored business testing and interfaced with the development team regarding defect status and fixes on a daily basis.
• Involved in generation and execution of SQL queries.

Environment: Microsoft Office Suite, MS Visio, Java, C, Windows, JavaScript, UNIX, HTML, Oracle, SQL,