SUMMARY

• Confidential has 8 + years of experience in the analysis of financial data including Portfolio, Brokerage Policies, and Investments as well as Business Intelligence (BI), Data Warehousing in ETL, Cognos, and Informatica.
• He has well versed in Waterfall and Agile/Scrum, has extensive BA deliverables with BRD, FRD, Wireframe, Use Cases, RTM, and Artifacts coupled with Cost Benefit Analysis and Requirements Traceability Matrix (RTM), Critical Path, Technical Documentation and Task Review Meetings.

TECHNICAL SKILLS

Cognos: ITIL

Business Objects: BI/DW

Business Object: UAT

SalesForce: Oracle R12

RUP: SharePoint

MS Visio: ETL

RAD/JAD: Microstrategy

URS/FRS: PEGA

Teradata: UML

OLTP: Agile/Scrum

JBOSS/Drools: SQL Server

Waterfall: Guidewire

ASP.NET 2.0 iRise: BMC Remedy ITSM

Informatica: PL/SQL

PROFESSIONAL EXPERIENCE

Confidential

Business System Analyst

Responsibilities:

• Analyzed the source and target systems for loading data in Enterprise Data Warehouse (EDW)
• Responsible for developing software requirement specifications, data flow diagrams and Entity Relationship Diagrams based on user requirements.
• Write technical documents in compliance to the company's established Data Warehouse standards and guidelines.
• Data Analytics like data scrubbing, data cleansing, and data merging done at staging.
• Responsible for writing and testing business solutions using Procedures, Functions and Packages in TOAD.
• Designed and developed Procedure, Functions, Packages and PL/SQL coding and extracted data from OLTP and used SQL statement for extracting the relevant data.
• Performed forecasting and Cost Benefit Analysis for reducing IT costs.
• Created test cases and performed regression testing
• BI Microstrategy reporting and facilitating Key Performance Indicators (KPI) to ensure compliance to all best business practices in industry.
• Involved in development of Business and Technical Requirements in preparation of design and functional specifications for Business needs.
• SharePoint 2010 for retrieving the artifacts and concurrent programs by Oracle Apps (R12)
• Developed BI/DW mapping for the requirement which is based on the syndicated data.
• Created Service Desk Tickets and Change Request by using Remedy tool (i.e. BMC).

Confidential

Business Analyst/Project Coordinator

Responsibilities:

• Extracted the data from OLTP to Data Warehouse using Informatica
• Developed ETL mappings, data mining, data analysis, and Workflows in Informatica
• Worked with Teradata GSC in resolving RDMBS related incidents
• Involved in data migration from 10g to 11g, data mapping, data cleansing, data conversion and data auditing using OWB
• Analyzed user requirements, attended stakeholders meetings to document changes and implemented procedures to test changes using the Rational Clear Quest
• Provide support to all Cognos issues and prepare reports for all warehouse functions
• Provide documents on the Bank’s brokerage policies,401k, assets mgt, Cost - Benefit analysis and ROI.
• Worked on OTC derivatives like Repos, FX swaps and Equity, Capital Market and bug tracking by Jira
• Worked on invoices details web 2.0 for the POS payment systems/billing
• Conducted JAD sessions to develop architectural solution that the application meets the business requirements, resolve open issues, and change requirements
• Involved in development of Business and Technical Requirements in preparation of Design and Functional Specifications for Business Needs and Change Request Processes
• Defined the change management approval procedures to control the scope of the order management requirements. Actively engaged various partners from the client team to monitor and control the risk associated with changing scope
• Provided training and Created sample BPM component Timer events for the Wealth Management
• Analyzed PL/SQL packages that were used by the testing team to validate the data in the back-end Oracle database

Confidential

Sr. Business Analyst/Project Coordinator

Responsibilities:

• Analyze the functional requirements of Siebel CRM and the architecture
• Worked with Head of Divisions and other related parties to develop optimal solutions using Agile model
• Review and edit requirements, specifications, business process reengineering, business processes and recommendations related to proposed solution
• Created BRD, User stories, wireframe, FRD, and PRD after creating Marketing Requirements
• EDI 810/880 invoices, release management, invoice reports using Business Object XiR2
• Change Request and Production Support activities using BMC Remedy ITSM
• Change Management and improved business process by using Business Process Model (BPM)
• Drafted RTM and worked closely with SME to produce artifacts, and deliverables
• Work with OBIEE team on schema updates, design considerations, and reporting/analytical requirements
• Making the progress visible to entire team and Stakeholders by preparing Sprint burn down chart and help the product owner during Sprint planning and remove all the impediments
• Implemented Oracle e-business suite R12 to ensure company is competitive to global market.
• Prepare progress reports against milestones, status, resource requirements, issues, risks and dependencies on a weekly basis
• Prepared quality control reports for the change request, release notes and integrate the information on Dashboard
• Conducted gap analysis ("What is" and "What should be ") and UAT
• Wrote SQL command statements for retrieving the related data
• Performed KPI, PLM, Risk Analysis and Root Cause analysis to prevent recurrence
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.

Confidential

Business Systems Analyst

Responsibilities:

• Involved in analysis and requirements gathering of challenging topics related to the ACWT website like building and implementing a Customer catalog, Shopping cart, Shopping list, Web accounts, Medical billing by FACETS, EDI Transactions and Order validation
• Wrote BI/Enterprise Data warehouse (EDW) mapping rules for health insurance, vendor management, stewardship and FACETS claims
• Data Analytics and data is loaded from Persistent Staging Area to Operational Data Store (ODS)
• Used ERwin tool for data modeling, data mining and tested the existing scripts
• Prior to SME sessions was involved in reviewing of Electronic Medical Record (EMR), existing legacy system capabilities and current customer pain points
• Individual and JAD SME sessions involved brainstorming existing detailed requirements, gather new requirements and business rules
• Conducted JAD session comprised of walking through simulated website requirements developed in iRise
• Training session through Saba LMS for the Web Services and business components to implement patient registration, diagnostic result and message displaying.
• Post SME and JAD sessions involved documenting meeting minutes, prepare Use Cases, build process flow charts and develop wireframes representing prototype websites
• Review the detailed requirements, use cases, wireframes and submit for approval to Confidential Business SME
• Extensive usage of MS Visio for developing wireframes and process flow charts
• Built Traceability matrix report to achieve mapping of business rules to functional requirements
• Followed Agile methodology to reach project deadlines on a weekly basis

Confidential

Business Analyst

Responsibilities:

• Followed Rational Unified Process (RUP) methodology for creating artifacts
• Facilitated (JAD) Joint Application Development sessions to identify business rules and requirements and then documented them using CMS in a format that can be reviewed and understood by both business people and technical people
• Researched on Best Industry Practices and explained the Business Users of the benefits and costs associated in implementing the OTC derivatives for the trade management
• Participated in writing user stories, design walk-through with Subject Matter Experts (SME’s) to baseline the business architecture
• Extracting and loading the data using Informatica tool and developing ETL mappings for the Data Warehouse
• Supported for data mapping and data conversion by using DML and DDL statements
• Used the Oracle tool TOAD to create database objects like Tables, Constraints and to run scripts and queries
• Checked the ad-hocing in the database and performed ad-hoc reporting
• Adhering to PCI DSS standards and validation requirements for the Organization
• Used AD Bulk Users tool for importing and modifying large number of Active Directory users.
• Used MS Visio to carry out business modeling and created use cases, use case diagrams, and activity diagrams
• Supported for interactive and dynamic web pages using Java Script, VB, XML and HTML
• Converted business requirements using Requisite PRO into System Requirement Specifications.
• Involved in requirement scoping, Product Breakdown Structure (PBS)and analyzing high priority requirements for implementation and various f reports on Dashboard
• Supported the QA manager in creating various testing scenarios for integration and system testing for JAVA applications
• Used Waterfall Model and coordinated in most of the SDLC phases

Confidential

Business Analyst

Responsibilities:

• Used MS Visio to carry out business modeling and created use cases, use case diagrams, and activity diagrams
• Performs quality assurance reviews of SDLC documentation used within the Solution Manager Configuration and development
• Understanding of SAP-BI architecture and functionality /Cognos reporting implications.
• Writing functional design documentation and working with technical design team to solution
• Reviewed the commercial lines such as EPLI/DRO/FLI/ELI
• Interacted with client to create User Stories to handle the rapidly changing requirements.
• Responsible for organizing ‘Daily Scrums’ to discuss issues and get updates.
• Created Use cases, Use Case Diagrams, Activity Diagrams, Business Flow Diagrams and Business flow diagram using Rational Rose and Rational Requisite Pro.
• Created Need Analysis Documents of the requirements gathered through JAD and JRP individual elicitation sessions using MS Word.
• Created Data Structure and Data Model Diagrams associating myself with Data modeler.
• Defined requirements at the beginning of each sprint using Scrum development to create the sprint backlog.
• Created User Requirement Specifications (URS) and Functional Requirement Specifications (FRS) documents.
• Experienced in operating most of the applications and GOSU scripts (.gsp) within the Guidewire
• Managed process prioritization of Claim Processing System to evaluate, identify and define problems and issues that users are trying to solve.
• Designed solutions to eliminate bottlenecks in the claims processing, by developing a web base application system.
• Actively participated in, group and individual based, problem solving and decision making throughout the different phases of Agile. Authored progress and completion reports, which were then submitted to project management on a weekly basis using Cognos.

Confidential

Business Analyst

Responsibilities:

• Developed business process models in RUP to document existing and future business processes
• Performed extensive requirement analysis including data analysis and gap analysis
• Designed and developed project document template based on SDLC methodology
• Developed business requirement specification documents using Content Management Systems(CMS), technical specification document as well as high-level project plan
• Assisted in migrating documents from E room to Microsoft Share Point
• Comprehensively work with requirement gathering for Enterprise reporting system using Requisite Pro and supported the offshore team for this international project.
• Implemented requirements to the project using Agile (Scrum Methodology)
• Scrum by creating sprints and focusing on iterative planning and tracking processes.
• Utilized a variety of reporting tools such as SQL and ACCESS for querying underlying database tables and resolve data issues
• Track sales and customer activity using Salesforce CRM.
• Created central repository of documents using content management.
• Proficiency in creating UML diagrams including use case, activity and class diagram using Rational Rose and MS-Visio
• Developed Sequence Diagrams, State diagrams and Activity Diagrams
• Gathered user requirements and improve the process efficiency using Business Process Model (BPM)
• Designed and implemented basic SQL queries for QA testing and report/data validation
• Wrote test cases, test scenarios and track the bugs using Mercury Quality Center
• Coordinated Enterprise Architect and System Analyst for the Proof Of Concepts (POC)
• Capturing business requirements using Requisite PRO into system requirement specifications
• Analyzed research on operational procedures and methods and recommend changes for improvement with and emphasis on automation and efficiency
• Conducted benchmarking activities to identify best practices
• Used Rational Clear Case and Clear Quest as Configuration Management and Change Control tools

Confidential

Programmer Analyst

Responsibilities:

• Accumulated system requirements from various departments through surveys and interviews.
• Conducted JAD sessions with management, users and other stakeholders for open and pending issues.
• Defined and analyzed data integration, data mining, data mapping requirements using Oracle data model tools.
• Responsible for writing and testing Business solutions using Procedures, Functions and Packages in PL/SQL
• Incorporated Rational Unified Process (RUP) to create Business Requirement Document (BRD) Specifications using MS Visio and MS Word.
• 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 Visio.
• Created exceptions report which were then submitted to project lead and stakeholders on a regular basis.
• Performed manual front-end testing to check all functionalities of different modules.
• Suggested measures and recommendations to improve the current application performance.