SUMMARY

• More than 8 years of information technology management experience with focus as Project Manager for 4 years in diverse industries, including Financial, Healthcare and high - tech environments.
• Business Systems Analyst with more than 8 years of experience in Banking/Mortgage/Credit Services, Health Care Industries
• Extensive experience in the field of Business Analysis, Business Modelling, Document Processing, Business Intelligence, Process Re-engineering, Streamlining and Decision Support Systems to manage.
• Maximized productivity by setting clear expectations and proactively communicating project status, issues and risks to internal stakeholders and top management.
• Drafted and distributed project objectives and tasks to the solutions team and coordinated projects using effective SDLC methodologies.
• Expert in information systems technology, project planning, strategic planning, systems analysis and troubleshooting, quality control, forecasting, scheduling and planning, and tracking of results.
• Very sound knowledge of Trading, Insurance, Investments, Capital/Financial market including Bond market, Fixed income, Corporate bond, Government bond, Municipal bond, Bond valuation, High-yield debt, Stock market, Stock, Preferred stock, Common stock, Stock exchange, Foreign exchange market, Hybrid security, Options, Futures, Forwards, Swaps, OTC market, Real estate market.
• 7 years of Reporting experience and Business Objects XI 4.0/3.1/R2/6.5 with experience in CMC, Infoview, Desktop Intelligence, Import Wizard, Designer, Reporter, Web Intelligence
• Experienced in the features of Business Objects XI R2, Crystal reports XI R2/2008, Crystal Xcelsius 2008/4.5.
• Good in development of Data warehouse/Data Marts, Data Modeling, designing the STAR and SNOWFLAKE schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling.
• Have experience working with databases like Oracle, DB2, Teradata, SQL Server and MS-Access.
• Complete Software Development Life Cycle (SDLC) experience including the Agile Unified Process (AUP), Rational Unified Process’s (RUP) Iterative SDLC requirements.
• Extensive experience in Methodologies, Process Engineering, and Management Tools: Rational Unified Process (RUP), Unified Modelling Language (UML), Object Oriented Analysis and Design Principles/Patterns (OOAD)
• Extensive experience in writing Business Requirement Document(BRD), Functional Requirement Document (FRD), Rational Rose Enterprise Edition, MS Visio, MS Office Tools.
• Requirement Analysis and Use Case Development, UML modelling using Rational Rose
• Experience in Leading Team of Business Analysts, Leading Client meetings and Co-ordinating team efforts. Maintained a close and strong working relationship with teammates and the management.
• Well understanding in SQL Server for creating ad hoc queries/using multiple commands / reports using joins & aggregate functions, stored procedures, Triggers.
• Conducted Requirement-Gathering Sessions (RGS’s), Feasibility Studies and Impact Analysis, Cost/Benefit Analysis, Risk Analysis and Base-Lining Acceptance criteria.
• In Depth understanding of the AS-IS and TO-BE business processes, Gap Analysis and experience in converting requirements in to test plans.
• Conducted Joint Application Development (JAD) sessions and interviewed Subject Matter Experts (SMEs), study in detail the functionality aspects of business process and carefully updating the information to the requirements in an easily understandable format.
• Developed effective working relationships with client team to understand and support requirements, develop strategic plans to implement of solutions, and effectively manage client expectations.
• Experience in building Universes, retrieving data using Universes, Personal data files (MS Access, Excel) and creating complex ad-hoc Reports using the Business Objects Web Intelligence (WebI) modules.
• Team Player with Exceptional Organizational, Communication, Interpersonal and Leadership skills with results-oriented attitude.
• Adept in problem solving skills and learning new technologies.

TECHNICAL SKILLS

Operating Systems: Windows NT/ 2000/ XP/ Vista, UNIX, Sun Solaris

Programming Languages: SQL, PL / SQL, HTML, DHTML

Business Skills: MS Office Suites, MS Project, MS Visio, Business Definition Requirements, Business Process Analysis, Gap Analysis, Use Case Modelling & Analysis, UML, Use Cases.

Business Modelling Tools: Rational Rose, MS Office, MS Visio, MS Access, Microsoft Project, Visio, Requisite Pro, Sharepoint.

Databases: SQL Server 2005/2008, Oracle9i/10g/11g, DB2, Teradata, V12/13, Toad, MS Access 2000/XP/2007

Testing Tools: Rational Test Manager, Win Runner

Application Servers: Apache 1.3.27, IIS 5.0 and Tomcat 4.0.6

Reporting Tools: Business Objects XIR2/3.1/4.0,6.5/6.0/5.x,Crystal Reports 2008/XI/10/9, Crystal Xcelsius 2008/4.5, Central Management Console (CMC), Central Configuration Manager (CCM), Import Wizard, Performance Management, Designer, Desktop Intelligence, Web intelligence, Crystal Xcelsius 2008, Tableau

PROFESSIONAL EXPERIENCE

Confidential, TX

Senior Business Analyst

Responsibilities:

• Worked on several Enhancements, Defects, Problem Records and Requirement tasks related to releases from .
• Worked on Expense, CLM and Integration projects with Fannie Mae pertaining to the latest 4 releases.
• Worked with FNM Business stakeholders in Expense, CLM and integration teams, Business Analysts, DBA’s and PMO’s to gather Business and Functional requirements(BRD, FRD) to implement business logic for successful implementation of customized Confidential Workstation.
• Coordinated JAD session with system analysts, development team, project manager for application development and Pre-validation of specifications.
• Conducted several Discovery sessions, JAD sessions and Business SME sessions to acquire knowledge on various workflows of FNM (Redemption, Confirmation, Pre-listing, Valuation, Marketing, Repairs, Environmental, Elimination, Field services, MI claims, Legal, Expense, Collection and CLM Integration ) to understand the requirement and to develop a quality product.
• Closely interacted with designers and software developers to understand application functionality and navigational flow and keep them updated for FNM users.
• Worked in cross-functional teams to define, document and update business requirements, conduct requirement sessions, provide weekly status report and project plans.
• Performed GAP analysis for the modules in production, conducted feasibility study and performed impact analysis for proposed enhancements.
• Experience in working with QA Teams in defining the Test Plans and Test Cases.
• Formed a bridge between the Project Manager and different teams and coordinated work plan between project manager and client using a Project integrity and software development tool called PTC Integrity.
• Coordinated between all IT departments to gather the status and updates for the releases.
• Tracked all the release related work and created release notes for each release.
• Worked with Confidential workstation users of FNM and QA team to research on the issues, Change Records and Defects associated with the releases and formulated requirement tickets and strategies to debug issues.
• Effectively communicated with both Technical and Non-Technical users and prepared project documentation.

Environment: MS Office 2010 Suite, MS Visio, PTC Integrity, Windows XP.

Confidential, Denver, CO

PMO/ Senior Business Systems Analyst / Reporting Analyst

Responsibilities:

• Confidential used Meridium application to gauge and analyze their Power and utilities. Crystal reports was previously used to analyze the performance of Electric (Generation: Fossil, Nuclear, Hydro, Combined Cycle) and Delivery (Electric Transmission and Distribution, Substations, Gas and Water) which have been strategically converted into Business Objects Web Intelligence Reports.
• Responsible to ensure the operational efficacy and excellence of an organization through evaluation of the impact return and cost presented by work process improvement opportunities.
• Managed the Reporting team while doing Reports on various Confidential Business workflows.
• Developed the business case and Managed cost budget to allocate overall cost estimate to individual tasks.
• Produced project status reports, managed the team and resolved day-to-day issues with emphasis on SDLC.
• Overlooked the developed of business functional requirement documents with the cooperation of the Business Units
• Understood the customer’s business requirements and business process management and then translated them to particular software requirements.
• Accurately and efficiently created and executed test plans.
• Evaluated, analysed, and mapped business processes working with the Business Units to determine possible solutions to increase efficiencies and productivity
• Generated innovative solutions by approaching problems with curiosity and open mindedness, using existing information to its fullest potential.
• Experience and competence with database management and queries.
• Developed Business Requirement documents, and Functional Requirement Documents.
• Coordinated work plan between project manager and client using Microsoft Project.
• Worked with the Project Manager to ensure assigned milestones are delivered on time, within budget, and it meets or exceeds expectations
• Heavy interaction with the project team, developers and Test team to deliver the Project deliverables as scoped and on time.
• Assisted on other projects as needed, performed other related duties and special projects as required.
• Gathered report requirements and developed data mapping documents.
• Developed Business logic diagrams as needed to assist in translating requirements.
• Worked in Business, Functional, Technical Requirements Gathering, Designing, Documenting, Developing, Testing and Deploying the Universe, Database Developments, Reports and Dashboards.
• Strategized the dashboards and reports in such a way that it resolved their current issues and presented the data in a revamped and logical way.
• Eliminated problems related to selectivity using complex inbuilt formulas and filters. Also used various presentation techniques in BO reporting to better represent their Performance data with higher visibility and granularity.
• Documenting development of Complex crystal reports using complicated formulae were analyzed and replicated into Business Objects Web intelligence reports.
• Created dynamic web intelligence reports using functions, filters, sections & breaks, combined Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and formula.

Environment: WinRunner, LoadRunner, Microsoft Project 2010, UNIX, MS Access, IIS, MS SQL server, Rational Clearquest, HPQC, Rational Software Modeller, Rational Rose, Mercury Quality centre, RUP, UML, power builder, Business Objects BI4.0/ XI 3.1, Designer, Dashboard Manager, Performance Manager XI R2/R3, Xcelsius 2008, Live Office R2/R3, Crystal Reports R2, Oracle 9i/10g, SQL, QAAWS (Query as Web Service, Infoburst, Teradata V12/13, MS-Excel, Live Office, Windows XP.

Confidential, Plano, TX

PMO/ Business Systems Analyst / Mortgage Mitigation Analyst

Responsibilities:

• Developed strategic plan documents and project management policies.
• Conducted polls and questionnaires to highlight the disadvantages of already existing manual system of operation.
• Higher visibility project dealing with the Pay-down curves of a newly acquired ING Financials home loan mortgage accounts.
• Raw excel data was tabularized in Teradata and complex SQL queries and PL/SQL procedures and cursors to retrieve the required information for SME’s to analyse information.
• The daily BO 3.x Webi Reports and Dashboards created were scheduled and circulated to the senior directors and VPs of Home Loan Mortgage department to monitor the flow of the Pay-down curves of the acquired accounts. This report helped them forecast the future of delinquent and non-delinquent accounts of Confidential .
• Involved in creating and modelling the AS IS diagrams and TO BE system and accomplished the GAP Analysis.
• Worked with Requirement Analyst analysing the user requirements and functional requirements.
• Articulated Business Requirements from user interviews and then converted those requirements into technical specifications.
• Used Rational Rose for data modelling.
• Conducted Joint Application Development (JAD) sessions to develop an architectural solution that the application meets the business requirements, resolve open issues and change requests.
• Completed time estimates for all technical items, assigned work, monitored developers progress and produced timely status reports for upper management.
• Involved in Testing and SME presentations to preview the delivered product in Testing environment to access User acceptability and make any additional changes as needed to meet specific user requirements.

Environment: MS Office 2010 Suite, MS Visio, UML, Rational Clearquest, Crystal Reports, Rational Software Modeller, Rational Rose, Adobe Acrobat, PL-SQL, Oracle 9i, SAP Business Objects XI 3.1 / 4.0, Crystal Reports 2008, Crystal XCelsius 2008, Oracle 11g, Teradata V12/13, MS-Excel, Live Office, Windows XP.

Confidential, Richmond, VA

PMO/SME/ Reporting Analyst

Responsibilities:

• Guided a team of eight in the development of reports and enhancements on Customer Interface Control Systems (CICS).
• Results: Reduced inefficiencies and the time by 15 percent in the CICS System.
• Met with the client groups along with the Business Analysts to determine the User Requirements and the goal of the project.
• Utilized Rational Unified Process (RUP) to configure and develop process, standards, and procedures and create a Business Requirement Document (BRD).
• Analyzed Business Requirements and segregated them into high level and low level Use Cases, Activity and Sequence using Rational Rose according to UML methodology
• Involved in finding and documenting requirements where the new data capture solution would be compatible with existing Customer Interface Control Systems (CICS).
• Involved in Gap Analysis of existing SDLC process, implementing RUP
• Worked with the Requirements Management Team (RMT) to elicit the business and system requirements and importing them into Rational Requisite Pro.
• Conducted highly interactive JAD sessions with project’s stakeholders, QA analysts, and project management team, identifying and resolving issues.
• Created a Scope Diagram for the project that would depict the basic system architecture
• Gathered all the business and technical requirements and created a FRD with critical items verified by the SME’s.
• CreatedDataFlow Diagrams, Use Cases and Business Process Flowcharts on which the actual system architecture would be based.
• Assisted the development team in the source to target mapping for ETL Design using Informatica tools.
• Carried out meetings with SME's to create the process requirements, process improvements and to proper explain the development team the flow of futuredatamodules.
• Worked closely with the Business Intelligence (BI) team to define standards for report.
• Facilitated User Acceptance Testing (UAT) with the stakeholders and the business users, and the errors discovered were fixed via regression testing.
• Involved in creating the master Test Plan and the Test Cases as well as coordinated the testing.
• Worked closely with the QA team during the automatedtestingusing the HP Quality Centre.
• Involved in Back-EndTestingusingPL-SQLQueries on MicrosoftSQL.
• Involved in the overall SDLC including inception, elaboration, construction and deployment
• Provided clear and concise documentation regarding requirements management plans, functional requirements, and supplemental requirements.

Environment: Windows XP, WinRunner, LoadRunner, Microsoft Project 2007, UNIX, MS Access, IIS, MS SQL server, Crystal Reports, Mercury Quality centre, RUP, UML, power builder, SAP FI/CO, SAP HR.

Confidential, McLean VA

Business Systems Analyst

Responsibilities:

• Developed Design Prototype of new information processing application. Met with client groups to determine the User Requirements and goals.
• Utilized RUP to configure and develop process, standards and procedures.
• Involved in all four phases of the requirements development including Elicitation, Analysis, Specification and Validation.
• Developed Business Requirement documents, and Functional Requirement Documents.
• Developed Use Case, Data Flow and Activity Diagrams.
• Created Systems Requirement Specification by combining the functional and non-functional requirements.
• Worked as an interface between the users and the different teams involved in the application development for the better understanding of the business and IT processes.
• Managed detailed project plans that includes; Resources Planning, Tasks Planning, Budgeting, and Performed Gap Analysis for the modules in production, conducted Feasibility Study and performed Impact Analysis for proposed enhancements.
• Worked extensively with SME’s including heads in areas of Fixed Income Derivates, Options, Swaps, Futures and risk managers in understanding, extracting, refining and documenting the User and Business Requirement Specifications in the BRDs.
• Formed a bridge between the Project Manager and different teams with effective presentations.
• Coordinated work plan between project manager and client using Microsoft Project.
• Coordinated between all IT departments to gather the status and updates for the releases.
• Tracked all the release related work and created release notes for each release.
• Performed Feasibility, Adaptability and Risk Analysis to identify business critical and high risk areas of the application.
• Sound knowledge about Front-Office Terms: Client Management, Research, Pricing and Price Distribution, Order Management, Trade Execution
• 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.
• Involved in analyzing various business scenarios and pitfalls in the process that could occur because of network/system/user undoing; this being a data intensive project.
• Involved in back-endtestingusingT-SQLQueries on MicrosoftSQL
• Involved in facilitating the UAT, creating UAT test plans
• Prepared Business Process Models that includes modelling of the activities of business from conceptual to procedural level.

Environment: Windows XP/2000, MS-SQL Server 2005, MS Office Suite, Visual Studio, MS-Project, HTML, XML, Rational Request Pro, Test Director, RUP

Confidential, AZ

Business Analyst/ Data Analyst

Responsibilities:

• Assembled and analysed User Requirements, developed Test Plan, specified System Interfaces and documented operational requirements.
• Initiated the requirements Feasibility Process to determine the viability technically, operationally, and economically
• Created Use-Cases and Business Use-Case Model after accessing/understanding the status and scope of the project
• Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using different methodologies.
• Created Use Case Diagrams, Activity Diagrams, and Sequence Diagrams in MS Visio.
• Participated Joint Application Development (JAD) sessions to develop an architectural solution that the application meets the business requirements, resolve open issues and change requests.
• Facilitated collection of Functional Requirements from system users and preparation of Business Requirement Document (BRD).
• Analysed existing Business Document Templates, Operational Procedures and methods and recommended changes for improvement with an emphasis on automation and efficiency.
• Extensively involved in User Acceptance Testing (UAT).
• Recognized scope limitations and raised potential scope issues, while designing best systems approach.
• Analysed Business Requirements and Detail Design of the software and used Requisite Pro for the requirement management.
• Effectively communicated with both Technical and Non-Technical users and prepared project documentation.

Environment: Rational Requisite Pro, Rational Rose, RUP,UML, Oracle 9i, SQL, PL/SQL, MS Office, MS Visio, MS Outlook, MS Project, MS Access, Windows XP, Crystal Reports.

Confidential, Indianapolis, IN

Business Objects Developer/Admin

Responsibilities:

• Worked with HR directors, Business Analysts, DBA’s and end-users to gather universe design and reporting requirements to implement business logic for successful implementation of report systems.
• Created complex reports using multiple data providers for processing insurance claims for customers.
• Created universes, universe objects, classes, applied filters, pre-defined and complex conditions.
• Worked extensively on modules CMC, Designer, Web Intelligence, Auditor, Publisher and Info view.
• Working on the SQL tuning and optimization of the Business Objects reports.
• Created reports using Business Objects functionalities like Slice and Dice, Drill Down, Drill Through, Cross Tab, Alerter and Formulae etc
• Created Dashboards using Dashboard Manager and Dashboard universes with metrics.
• Implemented object level security in universe to in corporate security for sensitive information.
• Implemented various levels of user profile rules, such as Folder level, scheduling reports or view only access.
• Used Infoview or WebI to create, analyze and publish reports to various groups or users.
• Designed Data model for Data Warehouse using snowflake schema, star schema.
• Generated reports with 2D, 3D and pie charts for business query results.
• Extensively used extended syntax’s and complex formulas.
• Formatted Reports as per the User requirements using extensively the functionalities in Business Objects, which allows the users to analyze the data.
• Used T-SQL Aggregating, group by, Indexes, stored procedures.
• Responsible to support the issues with reports on the Business Objects Enterprise environments (Development, UAT, Test and Production).
• Used ETL tool Informatica when needed for loading data into another Database DB2.
• Involved in writing detail level documentation for reports, migration of reports as well as universes to production.

Environment: DB2 UDB, Business Objects XI R2, Crystal Reports XI R2, Xcelsius 4.5, SQL, UNIX, Web Intelligence, Toad, Informatica 7.0, and UNIX Shell Scripting.

Confidential

Business Objects Developer

Responsibilities:

• Interacted with functional / end users to gather requirements of core reporting system to understand exceptional feature users expecting with reporting system and to implement business logic.
• Analyze the reporting requirements with the business users and come up with the technical specifications for the BO Reports
• Worked on Business Objects DeskI and WebI Reports of BO XI Environment.
• Worked on User Management, Server Management and Content Management.
• Migrated the Users, Groups, Universes, Personal Folders, Connections, Reports (DeskI & WebI),
• Creating the reports using Business Objects functionalities like Multiple Data Providers, Prompts, Slice and Dice, Drill Down, Cross Tab and Master Detail.
• Added users, user groups and managed the access privileges of the user community using the CMC module of Business Objects.
• Linked multiple universes and reports using stored procedures, visual basic procedures, flat files and excel files.
• Responsible in publishing and scheduling business intelligence documents to large number of end users.
• Implemented row level restrictions according to different business group requirements.
• Involved in migrating and deploying -- universes and reports across multiple domains.
• Creating, maintaining and modifying the universes using Business Objects designer
• Creating reports using Crystal Reports XI when needed.
• Aided in the multi-dimensional analysis using slice & dice, drill (up, down, through and across) by setting up different hierarchies and defining the scope of analysis.
• Implemented Data modeling using ERWIN tool when necessary
• Created jobs to Extract, Transform and Load data into data warehouse using Datastage7.0
• Responsible in maintaining Development, Test and Production repositories and providing round the clock support during the production stage.
• Involved in scheduling the documents for monthly, weekly and daily.

Environment: Business Objects XI, Infoview, PL/SQL, Oracle 10g/9i, ERWIN 4.0, Crystal reports XI, Data Stage 7.0, UNIX.