SUMMARY

• About 8 years of experience as a Business/Data Analyst with solid understanding of Business Requirement Gathering, Business Process Flow, Business Process Modeling.
• Strong knowledge of Software Development Life Cycle (SDLC), Rational Unified Process (RUP) methodology, Agile Methodology and Project Life Cycle.
• Strong subject matter expertise in Fixed Income, Derivatives, Equities, Bond Pricing, Mortgage Backed Securities (MBS), Annuity.
• Strong knowledge in Automated Clearing House (ACH), Bank Clearing System, Electronic Funds Transfer (EFT). General understanding of Accounting process including general ledger and account reconciliation.
• Extensive exposure on Front to Back processing of financesthrough Financial Service Providers(FSP) tools like:miRevenue, Finacle &FlexCube.
• Extensive experience with various Service Oriented Architectures (SOAs) spanning across various web services using SOAP, REST and WSDL across various applications using SoapUI, XMLSpy.
• Extensive experience in conducting JAD sessions - participated in varied roles ranging from facilitator, preparing visual aids, setting goals and objectives, providing read-ahead materials to participants, etc.
• Written Use cases and have produced Use Case Models, creating Behavioral diagrams (use case diagram, Activity diagrams and Sequence diagrams) based on UML Methodology & Business process flow diagrams.
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, Promodel, MS Excel, MS Access, MS Visio, technical assessment tools, Data Warehousing concepts and web design and development.
• Proficient in the use of tools like Telelogic DOORS, Rational Rose, Requisite Pro, Rational ClearCase, Telelogic System Architect and MS Visio.
• Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) in an SOA environment.
• Extensive experience in documentation of business requirements and system functional specifications, including BRD, FRD, and FSD
• Utilized a combination of business knowledge, technical skills, and strategic analysis to provide solutions and creative insights to critical business problems.
• Effective in multitasking and effective management of assignments according to work schedules with strong project management orientation.
• Capable of forming and maintaining positive and productive working relationships in internal, external, independent and team environment.

TECHNICAL SKILLS

Business Modeling Tools: Rational Rose, Rational Enterprise Suite, MS Visio, Telelogic System Architect

Reqmts. Management Tools: Rational Requisite Pro, Telelogic, DOORS

Change Management Tools: Rational ClearCase, Rational ClearQuest

Project Management Tool: MS Project

Analysis / Modeling tools: UML, JAD, RUP, RAD

Testing Tools: Load runner, Test Director, Mercury Quality Centre, QTP

Operating Systems: MS Windows 7/NT/98/95/2000, UNIX

Programming/Languages: SQL, OOP, UML, JAVA

Database: Oracle 9i/10g/11i, SQL Server 2008/R2, MS Access

Utility: MS Office Suite Word, Project, Excel, Visio, PowerPoint, Adobe Acrobat Suite

PROFESSIONAL EXPERIENCE

Confidential, Providence, RI

Sr. Business Analyst

Responsibilities:

• Participated in project management, design, requirements definition, specification, budgeting, control, and restructuring of organizations
• Prepare Use Case Models based on Business Requirement documentation gathered through interaction with users. Studied existing business application and processes, collected end user requirements and suggested the improvised Business Process Model.
• Utilized corporation developed Agile SDLC methodology. Assigned tasks among development team monitored and tracked progress of project following agile methodology.
• Facilitated Joint Requirement Planning (JRP) sessions with SME’s in understanding the Requirements pertaining to Loan Origination to Loan Processing.
• Gap Analysis of client requirements generated Workflow Process, flow charts and relevant artifacts
• Defined and documented the Vision and Scope of the project. Conducted one on one interviews with high level management team and participated in the JAD session with the SME’s.
• Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
• Gathered and evaluate business requirements for the management and processing of capital market transactions, identify business gaps, and assist clients find the best technology solutions to maximize their productivity and minimize the operational risks.
• Lead Business Intelligence reports development efforts by working closely with Microstrategy, Teradata, and ETL teams.
• Led the development of a training program to train users on a custom web application and a Cognos ad-hoc reporting environment.
• Extensive testing experience with various Service Oriented Architectures (SOAs) spanning across various web services using SOAP, REST and WSDL across various applications using SoapUI, XMLSpy.
• Involved in Business Process Management (BPM) activities like Process Design, Process Monitoring and Process Execution. Worked as a liaison between the business and technical side to convey the business needs to the system architects.
• Developed EXCEL sheets for portfolio Risk and return Analysis, as a basis for complex trading packages designed by programmers. Loading staging tables on Teradata and further loading target tables on SQL server via DTS transformation Package.
• Designed Use Cases using UML and managed the entire Functional requirements life cycle using RUP.
• Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions
• Conducting Requirement Analysis, Use Case Design, Designing Test Plans and developed database schemas based on the logical models. Conducted the final user-acceptance testing (UAT) and usability testing
• Involved in review and Gap Analysis of Functional Requirement documents and the creation of technical documents and related test case documents
• Worked on the Microsoft SQL query to extract the data required for data validation.
• Provided the management with Test metrics, Reports, and Schedules as necessary using MS Project and participated in the design walkthroughs and meetings
• Reviewed Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results with the actual report against the Data mart (Oracle)

Environment: Agile, Windows Vista, Microsoft Project, MS Access, Business Objects, Cognos, MS Visio, SQL, MS Excel, Oracle, MS Visio, MS PowerPoint.

Confidential, Milwaukee, WI

Sr. Business/Data Analyst

Responsibilities:

• Responsible for defining the scope and implementing business rules of the project, gathering business requirements and documentation.
• Wrote Test cases for Enterprise Data Warehousing (EDW) Tables and Data Mart Staging Tables.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Involved in Data Modeling of both Logical Design and Physical design of data warehouse and data marts in Star Schema and Snow Flake Schema methodology.
• Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) in an SOA environment.
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application. Worked closely with the architect, database administrator and technical team during Data Mapping and Data Integration.
• Engaged in different phases of SDLC of the project executing RUP methodology of iterative software development from Inception to Transition phase.
• Involved in Analysis and Design by preparing Use Cases and the Design Documents (DSDs), Data base Change Requests (DBCRs) and Design Change Statements (DCS) as and when required.
• Converted use cases, reports, web pages, and interface/exhibit documents to align with client requirements; modifiedDSDdocuments based on changing client specifications.
• Conducted Gap Analysis, and Gathered User Requirements by Interviews, user meeting, JAD session, and Requirement Elicitation Sessions. Applied RUP methodology with its various workflows, artifacts and activities to manage life cycle from Inception to Transition phase.
• Understanding the specifications for Data Warehouse ETL Processes and interacting with the data analysts and the end users for informational requirements. Coordinated defects routing in the team and created Excel macros to generate daily defects report status from Quality center across multiple teams.
• Performed source data profiling to verify that data meets the business requirements.
• Proposed solutions to reporting needs and develop prototypes using SQL and Business Objects that address these needs. Interviewing Subject Matter experts and carefully recording the requirements in a format that can be reviewed and understood by both business and technical people.
• Set up definitions and process for test phases including product test, integration test, and system test. Work to fully implement test phase entry and exit quality criteria, standard test reporting metrics and standard test artifacts.

Environment: Java/J2EE, Rational Suite (Rose, Requisite Pro), Windows XP/NT, ASP.Net, Oracle, SOA, MS SQL Server, JSP, XML, MS Office Suite, MS Visio, Agile, WinRunner, Test Director, Load Runner.

Confidential, Baltimore, MD

Data Analyst

Responsibilities:

• Gathered the business requirements by conducting a series of meetings with business users.
• Involved in business process modeling using UML through Rational Rose.
• Created logical data model from the conceptual model and it’s conversion into the physical database design.
• Extensively used Star Schema methodologies in building and designing the logical data model into Dimensional Models.
• Developed UNIX Shell Scripts to load the data and implemented cron jobs to execute scripts automatically.
• Designed data models with GE- ERC standards up to 3rd NF (OLTP/ODS) and de normalized (OLAP) data marts with Star & Snow flake schemas.
• Worked extensively with Risk Management, Mortgage Loan Servicing, and Commercial and Residential mortgage, CMBS, MBS.
• Assisted the IT team to develop service oriented architecture (SOA), and data warehouse system to utilize data mining for data analysis. Updated the impacted MS Access tables.
• Been a part of Architecture and modeling team and have used SOA (Service Oriented Architecture).
• Used Sybase Power Designer tool for relational database and dimensional data warehouse designs.
• Responsible for creating mapping documents required for the ETL team.
• Create and maintain the mapping of correspondence field, data, and paragraph values toDSD repository for easy traceability and reference to support the dev team.
• Created SQL, PL/SQL, SQL Loader control files, functions, procedures, and UNIX Shell scripts.
• Created entity-relationship diagrams, functional decomposition diagrams and data flow diagrams.
• Used Sybase Power Designer for creating tables using Forward Engineering.
• Used Star Schema and Snow flake Schema for data marts / Data Warehouse.
• Created documentation and test cases, worked with users for new module enhancements and testing.
• Created job schedules to automate the ETL process
• Normalized the database up to 3NF to put them into the star schema of the data warehouse.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data
• Worked with business analyst to design weekly reports using Cognos Report Net.
• Worked on building load rules and transformation logic for Extraction, Transformation and Loading (ETL) of the data into the data warehouse.
• Understood existing data model and documented the performance of the system.
• Validated the model with response to questionnaire from analysts.

Environment: Windows NT, Sybase Power Designer, Oracle, ETL, SOA, Rational Rose, Unix shell Scripting, Cognos Report net, Agile/Waterfall.

Confidential, NJ

Business Analyst

Responsibilities:

• Performed GAP Analysis to analyze the difference between the current systems and the FIPA system. Worked with internal users to help define system requirements.
• Performed Fixed Income Analysis to analyze interest rate risks and credit risks to determine the expected results.
• Created the Mortgage Induction Manual that is now a walking encyclopedia for any new comer in the project including the IT members of the clients
• Design high level process flow to achieve CEOs vision high level process flow for the entire mortgage project.
• 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.
• Conducted Equity Research to determine returns using techniques like DCF, Financial Statement analysis & P/E ratios. Compared Asset returns against benchmarks like S&P 500 and Russell 2000.
• Analyzed and prioritized user and business requirements as system requirements that must be included while developing the software.
• Responsible for scheduling meetings with users and stakeholders to identify problems, resolve issues and improve the process to ensure a stable and accurate solution.
• Directly involved in discussions with financial engineers as well as traders on the Fixed Income Trading Desk to conceptualize their needs.
• Liaised with developers and users to clarify specifications as necessary.
• Involved in Service Oriented Architecture (SOA) of the claims processing system.
• Involved in developing test case objectives to ensure accurate depiction and computation of risk of the securities, reported errors to the appropriate team.
• Worked collaboratively with the User Experience Analysts, and System Analysts to help document custom and system modifications.
• Developed Traceability Matrix for maintaining/updating current and new system requirements using MS Excel.
• Used problem and change management software to document work requests for release activities.
• Coordinated with teams within the organization to collect release requirements.
• Produced and managed documentation on release activities to support problem resolution and post-release analysis.

Environment: Windows XP, MS Word, MS Excel, JAVA, Oracle, SQL, SOA, UNIX, UML, Rational ClearQuest, Agile, Scrum.

Confidential, Akron, OH

Business Analyst

Responsibilities:

• 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.
• Got in depth understanding of the processes of the mortgage industry related to plans, rates, fees and underwriting systems.
• The system fully supported fixed rate, ARM, GPM, GEM, interest only, deferred payment, home equity, reverse mortgage, second mortgage loan programs, etc.
• UsedESBService layer that hosts the services and GUI call those services to interact with the backend database.
• Designed and developed UML Use Cases, Activity Diagrams, Sequence Diagrams, using UML
• Created use cases and use case diagrams using Rational Rose.
• Gathered product requirements in order to describe the business needs in terms of the main deliverables or products that are created.
• Talked to the end users to create the process requirements and to properly explain the flow of future data modules to the design and development team.
• Modeled 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, test plans and test cases.

Environment: Windows XP, UNIX, JAVA, Rational Requisite Pro, Agile, Scrum, UML, Rational Rose.