SUMMARY:

• More than Ten years of experience working as a Business/Systems Analyst in the software development industry. Industries served - financial, investment banking, insurance, mortgage, credit card, Internet, retail and food
• Excellent skills in writing Business requirements document (BRD), Use Case Specifications, Functional Specifications (FRD), Systems Design Specification, Workflow and Diagram skills for drawing UML diagrams such as State Transition diagrams, Activity diagrams, Class diagrams and Sequence diagrams, Data Flow Diagrams (DFD's), Requirement Traceability Matrix.
• Possess financial knowledge of Cash Flow Management, Asset Management, Investment Management, Fixed Income Portfolio Management, P&S Fixed Income, Asset Backed Securities (ABS), Mortgage Backed Securities (MBS) and Collateralized Mortgage Obligations (CMO)
• Recognized for excellent communication, people skills, project management capability, and the ability to successfully influence and drive consensus across cross-functional teams.
• Conducted JAR/JAD sessions, developed User interfaces and requirements providing traceability across projects by analysis and review of project elements including testing artifacts, end user support documentation and materials.
• Business/Systems analysis experience with SSAS, SSRS, MS SQL Reporting services, MS Report builder, Siebel CRM, Oracle BI, Answers, Business Objects, Cognos, Oracle Discoverer, Hyperion (Brio), WEBI, J2EE Architecture,.NET, Main frame, Test Director, Requisite Pro and Crystal reports
• Strengths include defining facts, dimensions, cube, subject areas, work flows, use cases & test cases
• Expertise in conducting Joint Application Development (JAD) or Joint Application requirements (JAR) sessions with end-users, Subject Matter Experts (SME’s), Development and QA teams.
• Extensive experience in project management best practices, processes & methodologies including Rational Unified Process (RUP), Water Fall, Iterative and Agile.
• More than 5 years of experience in implementing Agile, Iterative methodologies and requirements Traceability metric using Rational Requisite Pro
• Experience in conducting GAP analysis, ROI analysis, SWOT analysis and Cost benefit analysis
• Seasoned professional with planning, execution, monitoring and resource balancing skills with ability to support multiple projects; demonstrated proficiency in leading and mentoring individuals to maximize levels of productivity.

TECHNICAL SKILLS:

BI Tools: Siebel Analytics/Oracle BI, Answers, Delivers and Repository modeling, Cognos, Hyperion (Brio), Business Objects, WEBI, Xcelcius, Oracle Discoverer, SSAS, SSRS, MS SQL Reporting services and MS Report builder

CRM Applications: Siebel CRM 7.7.2, Siebel CRM 7.8, Siebel CRM 8.0

Business Modeling Tools: Rational Rose, Rational Requisite Pro, MS Project, UML, MS Visio

Languages: C++, C, SQL, Visual Basic, Java

Defect Tracking Tools: Test Director, Rational Clear Quest, Rational Robot, PVCS

Testing Tools: Rational Test: Robot, Mercury Tools: Win Runner, Load Runner

Methodologies: Rational Unified Process (RUP), Waterfall Method, Iterative and Agile

Operating Systems: MS Windows 95/98/NT/2000/XP, Sun Solaris, Linux/Unix, MS DOS

Web Authoring: HTML, Java Script, MS FrontPage, Lotus Notes

Databases: OBIA DB, DB2, MS Access, Sybase, SQL Server, Service Desk, CMDB, Exadata

PROFESSIONAL EXPERIENCE

Confidential, Erlanger, KY

Sr. Business Systems Analyst

Responsibilities:

• Documented User Requirement and Detailed Requirement for SDH hierarchy
• Worked with multiple stakeholders from different plants to understand the organization hierarchy
• Analyzed data from PeopleSoft and provide the hierarchy solution to the business
• Created prototype, wireframe to nail down the detailed requirements
• Defined slowly changing dimensions for the Organizational subject area in OBIEE
• Created multiple KPIs for Group leaders
• Defining and designing subject areas and data sets for OBIEE

Environment: Big data, ASP.NET MVC 4, OBIEE, MS Project, Waterfall, Share point, Risk Management, Data Warehouse, .Net, Visio, Agile and PL/SQL

Confidential, Cincinnati, OH

Sr. Business Systems Analyst

Responsibilities:

• Worked with Mercury project team to define process/work flow for Data Governance and managed this process throughout the project and determined impacts to Requirements Change Control process.
• Documented requirements and Created multiple scorecards for executive management
• Elicited, analyzed and documented complex business/functional requirements
• Assisted in troubleshooting post implementation issues for large/complex projects
• Assisted in project user acceptance test, including reporting and documenting defects, and conducting complex root cause analysis.

Environment: ARIS, Clear Quest, MS Project, Agile, Share point, Data Warehouse, Tibco and PL/SQL, Data Governance

Confidential, Cincinnati, OH

Sr. Business Systems Analyst

Responsibilities:

• Documented BRD and FRD for the multiple LOB such as commercial, business banking and CSC
• Performed data profiling for household relationships using SQL and MS Access
• Analyzed and defined the facts and dimensions for business objects universe
• Documented data requirements and data mapping from Siebel CRM to EDW
• Documented wireframes and dashboards for multiple lines of business
• Performed data testing from Siebel CRM to target database using SQL
• Used SharePoint workflows for BRD and FRD approval process and to manage project documentation

Environment: Siebel Services 8.0 (CRM), Siebel Analytics, OBIEE Applications, ETL, Risk management, Oracle Data Warehouse, Clear Quest, MS Project, Agile, Share point, Business Objects, WEBI and PL/SQL

Confidential, SFS Columbus Ohio

Sr. Business Systems Analyst

Responsibilities:

• Acted as a business expert for the team and wrote functional requirements and testing scripts.
• Performed data analysis using SQL and documentation.
• Verified functional and data integrity of the application.
• Managed changes to scope effectively and impact on overall project plans.
• Lead and participated in peer reviews to ensure excellence.
• Assisted PM and PL in planning, prioritization of onshore/offshore resources
• Managed issues list and meeting minutes to ensure transparency and consistency.
• Provided input to the business on guidelines and processes.
• Created process flow diagrams, and data mapping documents.
• Overseen use of design tools to create mock screens and prototypes.
• Developed process flows (both current and future state). Identified and implemented best practices across the organization.

Environment: Oracle Applications, ETL, Clear Quest, MS Project, Mercury Test Director, Risk management, Share point, SQL, ab initio and Toad

Confidential, Chicago, IL

Sr. Business Systems Analyst

Responsibilities:

• Conducted JAD/JAR sessions with end users, directors and VP’s of category management; Developed Business Requirements Documents (BRD), Functional Requirement Document (FRD) and facilitated internal client and development reviews for formal signoff.
• Delivered Category Management Foundation and target settings tool for Category Managers
• Responsible for project initiation, business requirements, change control, risk/issue management, resource plans, creating test cases, end to end testing, testing CSF’s and communications plans
• Created Use Case specifications, business work flow diagrams and defined facts & dimensions
• Created wire frames and prototype to facilitate and gather UI specs using iterative/agile methodology

Environment: OBIEE Applications, Answers, ETL, Oracle exadata, Clear Quest, MS Project, Mercury Test Director, BO, WEBI, Share point, SQL, Iterative, Neoview, PL/SQL, Discoverer, .NET, Prism and Toad

Confidential, Maynard, MA

PM / Lead Siebel Systems Analyst

Responsibilities:

• Suggested and implemented new requirements based on the business flow and Siebel best practices. Created prototype, wire frames and mock ups for Functional Design Specification
• Designed and created Sales, Marketing and Finance subject areas, dashboards, KPI’s, Scorecards in OBIEE, SSRS, SSAS and WEBI Business Objects
• Defined and implemented Rep Roles and Responsibilities in Siebel CRM 8.0 and upgraded Siebel Analytics 7.5.2 to OBI Apps 7.9.6
• Analyzed and documented Use Cases, Work Flows, BRD & FRD to implement sales transformation, order to cash, order procurement and product conversion projects in Siebel CRM
• Maintained project plan, Facilitated project status meetings and Communicated/documented project status. Plan, direct and coordinate the activities globally working with financial system of North America (NA) Europe (EU) and Asia Pacific (APAC )
• Facilitated and controlled Agile Development sessions of application with Business and Technology to complete and deliver the project on time to meet aggressive time lines
• Lead and Managed project resource allocations, planning and status updates to ensure efficient and responsive operations along with senior management
• Performed QA testing, Document verification scripts, Critical Success Factors, Test Cases, Provide support on Beta and Prod release / Install Calls
• Conducted Joint Application Development (JAD) sessions as a facilitator and moderator to gather requirements. Used Questionnaires, Interviews and JAD requirement gathering techniques to gather crystal clear business requirements

Environment: Siebel Services 7.5.3 and 8.0 (CRM, Order Management, Marketing), Siebel Analytics, OBIEE Applications, Siebel Sales, OBIEE Marketing, ETL, Oracle Data Warehouse, Clear Quest, MS Project, Agile, Mercury Test Director, Share point, SQL, SSAS, SSRS, MS SQL Reporting services and MS Report builder, Waterfall, Hyperion (Brio), .NET and Business Objects, WEBI and PL/SQL

Confidential, Merrimack, NH

Sr. Business Systems Analyst

Responsibilities:

• Created Book of Business solution for Fidelity Private Investments Organization to better manage relationships with high net worth clients and clients with managed accounts
• Analyzed, documented SRA & SDS and created Lead List Loader for Retirement Consultants to provide the ability to load large quantities of leads at once
• Facilitate TEBB (Time Estimation and Budgetary Brief) sessions; review and document project scope, one-time and ongoing project cost, project risk level and resource ramp Weekly Retail Desktop Change Control meeting facilitation
• Conducted JAD, JAR sessions to nail down the Business requirements & Systems specifications
• Integrated Intelligence Dashboards in OBIEE and One View 2.0 with Siebel CRM. Completed data mapping the fields that are used in the BI requests.
• Used Requisite Pro for requirements traceability and use-case management. Provided to BA’s and SA’s in Rational Requisite Pro and Agile methodology implementation
• Developed many Finance Reports / Portfolio management Dashboards with different Analytics Views (Drill-Down / Dynamic, criteria filters, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using Siebel Analytics Web / OBIEE Presentation Services
• Designed Dashboards / Reports that are Dynamic & Interactive with drill-down capabilities for summary & details information, added local & global filters using OBIEE
• Used Test Director for quality testing and maintaining test cases and test scenarios

Environment: Siebel Financial Services 7.5.3(CRM), Siebel Analytics, OBIEE Applications 7.9.1, ETL, Oracle Data Warehouse, Requisite Pro, MS Office, Oracle Apps, Agile, MS Project, Clear Quest, Mercury Test Director, Share point, EDMS, Hyperion (Brio), .NET, Waterfall

Confidential, Richmond, VA

Business Systems Analyst

Responsibilities:

• Responsible for collecting control requirements for a critical document registry.
• Documented process flows, policies and procedures.
• Facilitated description of three sets of end-to-end solutions to meet control requirements, to include industry best practices and tools, and existing COF solutions.
• Created Use Case specifications, business flow diagrams, Activity/state diagram and sequence diagrams for Critical Document Registry.
• Assessed the degree to which Critical Document Registry functionality met control requirements, process and technical efficiency of the solution and risk exposure if another solution were selected
• Prepared Logical Process Models covers "What" business processes are required by the business to accomplish their goals

Environment: MS-Project, Live Link, Gap analysis, SQL, Waterfall, Share point and Documentum Lloyds & Marker, Old Bridge, NJ

Confidential, Minneapolis, MN

Business Systems Analyst

Responsibilities:

• Created BRD and FRD, conducted Joint Application Development (JAD) sessions as a facilitator and moderator to gather requirements
• Facilitated collection of functional requirements from system users and preparation of business requirement documents that provided appropriate scope of work for technical team to develop prototype and overall system.
• Create “As Is” and “To Be” documents to show the current and proposed functionalities of the system. Subsequently broke them down by brainstorming with Developers, Architects and Business users to get the low level ‘To Be’ /proposed environment.

Environment: Waterfall, Lotus Notes, SWOT analysis, Clear Case, Clear Quest, J2EE Architecture

Confidential, San Francisco, CA

Business Analyst

Responsibilities:

• Used the guidelines and artifacts of the Rational Unified Process (RUP) to strategize the implementation of Rational Unified Process efforts in different iterations and phases of the Software Development Lifecycle.
• Created BRD, FRD, Use Case specifications, business flow diagrams, Activity/state diagram and sequence diagram using Rational Rose, so the developers and other stakeholders can understand the business process according to their perspective with possible alternate scenarios.

Environment: Oracle 8i, RUP, UML, Waterfall, Rational Rose, SQL, Win runner, SWOT analysis, Java

Confidential, Pittsburgh, PA

Business Systems Analyst

Responsibilities:

• Gathered requirements by using interviews, requirement workshops and brainstorming sessions to provide reports/dashboards for portfolio managers
• Involved in GUI Testing, Unit Testing, System Testing, Integration Testing, Regression Testing.

Environment: Cognos, Rational Requisite Pro, RUP, UML, PL/SQL, Crystal Reports, Hyperion (Brio)

Confidential, Irvine, CA

Business Analyst

Responsibilities:

• Met with client groups to determine requirements and goals. Utilized Rational Unified Process (RUP) to configure and develop process, standards, and procedures and create a Business requirement Document.
• Responsible for preparing Software Requirement Specification (SRS).
• Created Process Work flows, Functional Specifications documents.
• Provide implementation assessment, strategy, and mentoring services for Rational Rose, UML and RUP.
• Interaction with the developers to report and correct bugs.
• Followed a structured approach to organize requirements into logical groupings of essential business processes, business rules, and information needs, and ensured that critical requirements are not missed.
• Aided management in standardizing web applications by preparing GUI standards and recommending alternatives for in corporation in a phased, iterative manner.

Environment: Java, Java Servlets, EJB, JSP, JDBC, JDK, Oracle 8.1.6, Excel, UML, Java Script, JSDK

Confidential

Business Process Analyst

Responsibilities:

• Involved with analysis of business requirements, URS, FRS and the SRS. Analyzed the functional requirements and did functional break out.
• Took a lead role in the design and development of the application.
• Created use case scenarios and sequence diagrams for each functionality of the module assigned to my team.
• Wrote generic functions as part of reuse (UML) experimentation.
• Involved in Testing and post development support of the application.

Environment: Windows NT/98/95, HTML 4.0, Internet explorer 4.0, VB, Oracle