SUMMARY

• Business analyst with 8+ years of diverse experience in Business Analysis, Data Analysis, project management, business requirements, process mapping, Data profiling, Capital Marketing, Retail, Meta Data Management and strong understanding of SDLC
• Excellent business writing skills essential for producing various business documents such as Business Requirements Document (BRD), Functional Requirements Document (FRD), Business Process Documents, Training manuals
• Implement Dynamics CRM based solutions for various departments of Microsoft (Marketing, HR etc.)
• Solid understanding of Business Process definition, Risk Analysis and SDLC methodologies.
• Comprehensive knowledge of software development methodologies such as Waterfall, E - Commerce, RAD, RUP and AGILE SCRUM.
• Experience in understanding Stored Procedures, Stored Functions, Database Triggers, and Packages using PL/SQL.
• Designed custom rules for identifying violations and ensuring compliance with U.S. Federal Business Standards
• Performed Data Changes, Data Quality Reporting and Data Analysis in Open Pages, GRC Platform from IBM. The Open Pages GRC Platform handled the Governances Risk and Compliances Platform.
• Good Data Warehousing concepts including Meta data and Data Marts.
• Expertise in identifying, developing and managing business and non-functional requirements
• Participated in preparation of root cause analysis (RCA) documents
• In depth understanding of Application Life Cycle Management (ALM)
• Conducted Joint Application Development (JAD), interviewed Subject Matter Experts (SMEs), Stakeholders for deriving detailed functionality aspects of business process and carefully updated the requirements information in an easily understandable format
• Creating workflows using formal notation such as the Business Process Modelling Notation (BPMN).
• Proficient in Salesforce.com, Force.com platform Development, Salesforce Integration, Veeva CRM.
• Facilitated on-going Steady State business processes for deployed CRM solutions and conduct regular status.
• Learn the system, deliver and mentor client's team members and partners the Pega systems Smart BPM & PEGA Scrum Methodology
• Meetings with key business partners from each business unit / region. Managed total business solutions to support business process optimization programs.
• Created and updated reports within Dynamics CRM based on end-user requests
• Excellent knowledge of Excel (Pivot tables, macros, VLOOKUP)
• Expertise Knowledge of Pricing and selling, working on various domains and products.
• Well versed in performing Change Management by using Impact Analysis
• Extensively worked with the On-site and Off-shore Quality Assurance Groups by assisting the QA team for developing Test Plans, Test Cases, and Test Scripts etc., conducted User Acceptance Testing (UAT) and Post production validation (PPV)
• Extensive experience in analyzing and creating Use Cases, user stories, Use Case Diagrams, Data Flow Diagrams, Business Flow Diagrams
• Highly effective management and organizational skills with ability to prioritize.
• Excellent analytical and communication skills with capability to handle new technologies and situations, dedicated to meet deadlines, provide necessary deliverable and resolve issues creatively and efficiently
• Experience in integrity and validation of Reporting tools and data.. Assist with the building of reports for financial analysis, trending and results analysis related to revenue and expenses using Oracle OBIEE,

TECHNICAL SKILLS

Requirement Management Tools: Rational Rose, DOORS, Power Designer, IBM Rational Requisite Pro, E-Comm, plain view, Oracle OBIEE, Share point, Micro strategy, Business Objects, Gliffy, HL7

Change Ma1nagement Tools: Rational Clear Quest, Rational Clear Case, Silk Central Test Manager, MS Project 2010, Quality Centre, Compliance Calibrator, ST03N, Open Pages- IBM

Databases: MS Access 97/2000/2003, SQL Server, Oracle

MS Office Suite(365)Word, Excel, Access, PowerPoint, Project, Outlook,:

Testing Tools Knowledge: Quality Center, Test Director 8.0, Load Runner, Win Runner, Veeva, Test Directory

Operating Systems: MSDOS, Windows 95/98/NT/2000/XP, UNIX, MAC

PROFESSIONAL EXPERIENCE

Business Analyst/Data analyst

Confidential, Reston, VA

Responsibilities:

• Prepare and maintain a project plan as well as provide status/progress report as needed.
• Designing and creating prototype dashboard and laison with the Developers to create and design the dashboard as per the client requirements
• Involved in data warehouse design.
• Mortgage industry professional with loan-processing experience and a comprehensive knowledge of conventional and government loan program.
• Experience with various ETL, data warehousing tools and concepts.
• Worked on analysis of BPM (Pega) implementation for WebServcies.
• Worked on full cycle Data Warehouse, including requirements gathering, design, implementation, and maintenance.
• Viata Cloud helps pharmaceutical companies get the most out of their Veeva CRM systems.
• Support Client Project Mangers throughout the lifecycle of the project delievry including support for requirements elicitation,documentation and implimentation,stakeholder coordination and communications,policy and regulatory development
• Recommend improvements to methologies in order to more effectively deliver requirements and support the business and IT teams
• Brain storming with client on the Business Requirement Document (BRD), and convert BRDs into FRDs
• Act as a liason between business representative and IT, providing insight to each team of the other’s needs and expectations
• Broad technology background and comprehensive exposure to various capital markets research and electronic trading platforms such as BondDesk, Valubond, TradeWeb and Bloomberg and Mortgage loan.
• Created and updated reports within Dynamics CRM based on end-user requests
• Worked with internal architects in the development of current and target state data architectures
• Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines.
• Used data analysis techniques to validate business rules and identify low quality missing data in the existing Amgen enterprise data warehouse (EDW)
• Worked with Data Architect and Functional Subject Matter Expert(s) (SME) to design, develop and document Business Objects Universes.• Worked with SMEs and the Testing team to assist in resolving BO/data related issues and trouble tickets.
• Designed and implemented simple workflows using PEGA PRPC V 5.4
• Extensively involved in user acceptance testing, performance management and
• Extensively worked with the On-site and Off-shore Quality Assurance Groups by assisting the QA team for developing Test Plans, Test Cases, and Test Scripts etc., conducted User Acceptance Testing (UAT) and Post production validation (PPV).
• Prepared Use Cases, Software Requirement Specifications (SRS), Software Design
• Co-ordinate with the PMO, the software development team and the testing team to enable seamless working across work groups and ensure on time delivery of project objectives.
• Create various Data Mapping Repository documents as part of Metadata services (EMR).
• Interacted with Development and QA Team to ensure overall quality and scalability f the software.
• Interacted extensively with business through JAD sessions and one on one interview Sessions to write use cases, drawing UML diagrams and designing graphical user Interface prototype. Using Gliffy constructed online diagrams and flow charts for SWOT analysis & Wire frames.
• Extensively involved in user acceptance testing, performance management and Docum nting user manual.
• Assets & Liability and Liquidity reporting by Preparing and reviewing daily Stress Testing reports on Forex, Fixed Income and Equity Portfolio
• Ensure integrity and validation of Financial reporting and data, and assisting in building of reports related to revenue/expenses using ;Oracle OBIEE
• Ensure compliance of internal processes and controls as well as continuous improvement of those processes
• Design workflows, data diagrams and other industry standard documents to represent client’s business processes.
• Tested Business Objects reports and validated values as per user requirements.
• Worked with Data Architect and Functional Subject Matter Expert(s) (SME) to design, develop and document Business Objects Universes.• Worked with SMEs and the Testing team to assist in resolving BO/data related issues and trouble tickets.
• Managed and coordinated the QA team to create the test approach and determine test needs, test environment, test data, resources and limitations.
• Provide 24 x 7 problem management support to the development team.
• Create various Data Mapping Repository documents as part of Metadata services (EMR).
• Provided Extensive data cleansing and analysis, using pivot tables, formulas (v-lookup and others), data validation, conditional formatting, and graph and chart manipulation.
• Provide inputs to development team in performing extraction, transformation and load for data marts and data warehouses.
• Used HL7 guidelines and dictionary for defining business rules associated with pre-defined workflows according to business requirements.
• Provide support in developing and maintaining ETL processes that extract data from multiple SOR's residing on various technology platforms then transport the data to various delivery points such as data marts or data warehouses.
• Competent in creating workflows, BPM, process improvements and facilitating process engagements
• Performed manual and automated tested related to the graphical user interface, functionality testing, and testing related to data sources.
• Helped to develop test strategies, test cases, test plans, defect reports, Traceability Matrices and test environments and managed the testing process, bug reporting and analysis of test results.
• Tracked the progress of system testing, and provided a daily status report to the Test Manager.
• Used Test Director to house all test documentation and report/track all issues and defects

Environment: Oracle, SQL, Oracle OBIEE, Veeva, E-Comm, Microsoft Dynamics CRM, Mortgage, Capital Marketing, Clear Quest, IBM-BPM, PEGA PRPC V 5.4, HP Quality Center, MS Office 365, SharePoint, Test Director, Gliffy. BRD, FRD.

Business / Data Analyst

Confidential Chicago, IL

Responsibilities:

• Analyzed existing Business units, Business process, System / Application and their Interfaces through open-ended discussions, brainstorming sessions and prototyping. Prioritized them and converted them as system requirements that must be included while developing the software.
• Co-ordinated with documenting processes used agile methodology to write the Business Requirements documents and designed Functional specifications.
• Lead the team on the SAP GRC 10 upgrade.
• Prepared BRD and FSD for the Solution team
• Worked in migrating customized rules from SAFE to GRC compliance Calibrator.
• Served as a liaison between the internal/external business community and the IT organization in order to provide technical solutions to meet user needs.
• Participated in design review meetings and translated the requirements to the developers and guided the team when issues related to business requirements arose.
• Worked with Associates and understood the business rules, systems and integrated them into the requirements document and assisted in generation of test cases and test data.
• Delivered consistent daily results as the fixed income capital markets office manager reporting directly to SVP and VPs of trading desk.
• Created workflows, data diagrams and other industry standard documents to represent client’s business processes.
• Conducted JAD sessions between the business users, Developers, testers & Subject Matter Experts to resolve bottlenecks.
• Used HL7 guidelines and dictionary for defining business rules associated with pre-defined workflows according to business requirements.
• Used ST03N/ GRC report for deletion of unused transactions.
• Played important role into creation of CRUD (Create, Read, Update and Delete) Metric to make analysis and better understand data flows between different systems
• Conducted Risk Analysis to identify the risks associated with developing the patches, and formulated a Mitigation Plan to eliminate or reduce risks of high severity and any major effects.
• Played an active role in performing of Gap Analysis and its documentation.
• Interacted with client to present future functionality of the application and gathered information from them to understand their need and send this information to test manager.
• Worked closely with the application development team, design team and testing team to resolve technical issues and interacted with them to ensure overall quality of the software.
• Responsible for creating & maintaining Requirement Traceability Matrix in order to track the development and QA process.
• Designed custom rules for identifying violations and ensuring compliance with U.S. Federal Business Standards.
• Redesign and customize rules to correct false positives in new business development.
• Lead cross-functional collaboration in designing client-specific global rule set
• Interacted closely with QA to finalize the Test strategies and maintained quality assurance using HP Quality Center.
• Provided production support preproduction and post production issue management and defect tracking.
• Performed data validation by creating ad hoc reports for Business Managers.Involved in documenting the changes to the universe and reports functionality.
• Tested Business Objects reports and validated values as per user requirements.
• Developed test cases to run the test for Business Objects and Informatics migrations

Environment: UNIX, Epic System, SQL Advantage, MS Visio, Capital Marketing, BRD, FRD, MS Word, Clear Case, Clear Quest, HP Quality Center, Office 365, ST03N, UAT

Business Analyst

Confidential, Chicago, IL

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. Used the RUP methodology for software development.
• Performed Fixed Income Analysis to analyze interest rate risks and credit risks to determine the expected results.
• Hands on experience with Actimize, worked on anti-money laundering tool Actimize along with risk and compliance
• Worked in migrating customized rules from SAFE to GRC compliance Calibrator.
• Developed UML Use Cases and Use Case diagrams after assessing the status and scope of the project and understanding the business processes
• 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.
• Worked collaboratively with the Users, SMEs, to help document business process and necessary system modifications
• Developed system Use Cases using UML, helped developers and other stakeholders to understand the existing and the new business process
• 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.
• Experience in pricing and selling on stocks, bonds, securities, mortgages
• Queried the databases, wrote test validation scripts and performed the System testing.
• Worked with the developers during coding and while doing the remediation of the software.
• Worked with the users to do the User Acceptance Testing (UAT).
• Document all data mapping and transformation processes in the Functional Design documents based on the business requirements.

Environment: Windows XP, MS Word, Actimize, MS Excel, Anti money laundering, risk and compliance, Financial Accounting, JAVA,HL7 Use cases, Oracle, SQL, UNIX, UML, RUP, Rational Clear Quest, Office 365,Compliance Calibrator, mortgage, BRD, FRD.

Business Analyst

Confidential, St. Louis, MO

Responsibilities:

• Obtained a detailed knowledge of business process involved in the project environment.
• Gathered requirements from Business Partners.
• Established Business Analysis methodology using Agile Extreme Programming to create Architecture and Interaction models.
• Interacted with numerous internal groups and formed productive and positive working relationships with staff with varying technical and business backgrounds and skill levels across the organization.
• Used business process modeling techniques for reengineering.
• Conducted Gap Analysis to show the current and proposed functionalities of the system.
• Generated reports using business objects.
• Upgraded Compliance Calibrator 4.0 upgrade to 5.2.
• Performed Data Changes, Data Quality Reporting and Data Analysis in Open Pages, GRC Platform from IBM. The Open Pages GRC Platform handled the Governances Risk and Compliances Platform
• Extensively involved in JAD sessions to converge early towards a design acceptable to the customer and feasible for the developers.
• Involved in the back office operations using data from Bloomberg.
• Generated advanced reports related company’s performance that would help the business users in managing their portfolio.
• Helped the business users in portfolio management by giving additional information such as; beta value, target price and performance charts for the last five years.
• Created artifacts and defined milestones and iterations plan for inception and elaboration phases.
• Assisted in testing the application whether all the user requirements were catered to by the application.
• Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Informatica Power Center 7.1
• Involved in preparing a simple and detailed User manual for the application for intended users.
• Expertise knowledge of pricing and selling of stocks, bonds, securities, investment assets
• Developed database triggers, procedures and functions to monitor the business functionality and needs.

Environment: Windows, SQL, Microsoft Office tools, Business Objects, Rational Requisite Pro, Rational Clear Case, UML,office 365,Compliance Calibrator, Open pages

Business Analyst

Confidential, Westlake, TX

Responsibilities:

• Served as a liaison between the business team, project team by assisting the business team in identifying, understanding, and documenting their business needs. Collected and documented business processes as well as business rules.
• Created UML Diagrams like Sequence Diagrams, Activity Diagrams and Process flow diagrams to elaborate the new processes using Rational Rose.
• Gathered business requirements through interviews, surveys, prototyping and observations of account managers and UI (User Interface) of the existing Broker Portal system.
• Built and maintained market financial analysis models
• Conducted controlled brainstorming sessions with project focus groups.
• Analyzed and prioritized user and business requirements that were included while developing the software.
• Planned and defined system requirements to Use Cases and Test Plans.
• Conducted JAD sessions with management, SME (Subject Matter Expertise), vendors, users and other stakeholders to develop specifications.
• Created and managed project templates, use case project templates, requirement types and traceability relationships in Requisite Pro.
• Authored progress and completion reports, which were submitted to project manager on a weekly basis.
• Wrote Test Cases and developed strategies with Quality Assurance group to implement them
• Expertise knowledge of pricing and selling of stocks, bonds, securities, investment assets.
• Worked as Production Support Lead for the Business Objects Reporting environment.
• Knowledge in Dimensional Data Modeling with good understanding of Star & Snowflake schemas, fact & dimensional tables
• Expert at optimizing, debugging and testing SQL Queries and stored procedures written in Oracle & SQL Server

Environment: Rational Clear Case, Rational Clear Quest, Rational Rose, MS-Office Suite (Word, PowerPoint, Access, Excel, Outlook), MS Visio, SQL Server.

Business Analyst

Confidential

Responsibilities:

• Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Conducted interviews and JAD sessions with SME’s for gathering requirements and Collected, analyzed, designed and document requirements from clients and stakeholders.
• Prepared BRD and FSD for the Solution team.
• Used MS Project for scheduling project related tasks.
• Performed extensive requirement analysis including Data analysis and Gap analysis.
• Helped in identifying the best practices for upgrading the legacy system.
• Documented and delivered Functional Specification Document to the project team.
• Identified internal and external system requirements, design and configuration set-up
• Translated the business needs into system requirements, communicating with the business on a broader scale and with an in-depth view too.
• Mapped different data sources so as to integrate the information required as an input for Basel II compliances.
• Analysed user problems, including automated and manual business processes and identified, researched, investigated, defined and documented business processes.
• Created shell scripts for running multiple jobs.
• Wrote Test cases, Test plans and conducted UAT.
• Maintaining and keeping track of stakeholder’s requests for enhancements and changes using Unified Change Management tool (UCM) such as Rational Clear Quest.

Environment: MS office, MS Visio, ASP.Net, Java/J2EE, XML, HTML, Windows XP Professional, Rational Rose, UML, SQL, SQL Server, XML, XSD, SOA.

Business analyst

Confidential

Responsibilities:

• Brain storming with client on the Business Requirement Document (BRD), and convert BRDs into FRDs
• Followed Agile methodology
• Facilitated (JAD) Joint Application Development sessions to identify business rules and requirements and then documented them 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 same
• Participated in design walk-through with Subject Matter Experts (SME’s) to baseline the business architecture
• Used MS Visio to carry out business modeling and created use cases, use case diagrams, and activity diagrams
• Providing review to Test Cases and Test Files generated by QA team.
• Interacted constantly with the Business Users and Project Manager to keep them current with the latest updates
• Converted business requirements into System Requirement Specifications.
• Involved in requirement scoping and analyzing high priority requirements for implementation
• Supported the QA manager in creating various testing scenarios for integration and system testing
• Supported the QA team while conducting Unit and Functional Testing
• Assisted the Business Users at the time of Application testing and User Acceptance Testing

Environment: Windows, MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio), mortgage, J2EE