SUMMARY:

• Proactive, versatile and result oriented Business Analyst with more TEMPthan 7 years of experience in business requirement gathering and analysis, business process re - engineering, object-oriented design, data modeling, Integration, ETL as part of data warehouse.
• In-depth understanding of Software Development Life Cycle (SDLC) using Waterfall, Six Sigma and Agile methodologies including scrum and Kanban.
• Extensive experience and Strong domain noledge across multiple diversified industries, such as Insurance (healthcare), Banking (finance and retail), Credit cards, Mortgage, Investment Bank regulations related to Dodd Frank Regulations.
• Dexterous in documenting Business Requirements Document (BRD), Use Cases, Feature Requirement Document, Functional Specification, Unified Modeling Language (Use case, Process Flow, Class, Activity and Sequence),QA Methodology including test cases.
• Adept in team management, problem-resolving skills, conflict management skills, people management skills and excellent noledge of soft skills, writing skills and oral communication.
• Highly experienced in leading and satisfying business needs with different groups within different levels of management in teh company.
• Highly recognized for excellent communication, people skills, project management capability, and teh ability to successfully influence and drive harmony across cross-functional teams.
• Recognized as a hands-on, pro-active troubleshooter, who can rapidly identify business problems, formulate strategic plans, initiate change and assist to implement new process in challenging and diverse environments.
• Experienced in conducting Joint Application Development (JAD) and Rapid Application Development (RAD) sessions to converge early toward a design acceptable to teh customer.
• Creative and aggressive self-starter with integrative thinking skills, capable of forming and maintaining positive and productive working relationships.
• Experience in Data Analytics and creating Report from teh generated data.
• Excellent in performing Cost-Benefit Analysis, Gap Analysis, SWOT Analysis to check teh compatibility of teh existing system infrastructure with new Business Requirements.
• Designed and executed test plans, test scripts, tracking defects and getting them resolved to ensure that business requirements and functional specifications are tested and fulfilled.
• Worked with QA team to design test plan and test cases for User Acceptance Testing (UAT) using HP Quality center Tool.
• Experience in document sharing applications including (MS SharePoint, Confluence, SDLC tool, JIRA), UML tools (Axure Application, MS Visio), ERP tools (Toad for Oracle and PeopleSoft finance).

TECHNICAL SKILLS:

Languages: SQL 2005/2008/2008R2/2012, Java, Oracle

Web Technology: HTML, CSS

Database: MS SQL Server

Business Intelligence Tools: MS Business Intelligence Development Studio (SSAS, SSIS, SSRS)2005/2008/2008R2/2012, MS Power BI (Power Pivot Excel), MS SharePoint, JIRA

Methodologies: Agile Scrum/Kanban, XP, Waterfall Model, SDLC, Six Sigma

Business Analyst/Project Management Tools: MS Project, Visual Paradigm, MS Visio, Rational Requisite Pro

Tools: IBMCognos, PeopleSoft, Toad, Swift Messaging (MT 199, MT 103 and MT 320), TIBCO, IBM Lotus Notes, JIRA, Sprint Backlog, Axure Applications

Packages: MS Visual Studio, MS Office (Excel, Word, Power Point, Access, Outlook, Project, Visio), MS Excel,, MS Expression Web, HP Quality Center

PROFESSIONAL EXPERIENCE:

Confidential, Wilmington DE

Finance Business Analyst

Responsibilities:

• Interacted with users from Treasury and Finance to gather what were teh program-wide gaps and how they can comply with Fed Related Requirements as asset management.
• Interacted closely with teh PeopleSoft Dev Team for PeopleSoft to RBB enhancements, new feed from PeopleSoft to Galaxy and ensuring user stories are ready for release.
• Created documentation in relation to user stories, functional specification document, implementation plans, feature requirement doc and tracking overall status of teh backlog.
• Used Agile methodology for PeopleSoft Finance enhancements and transition from Waterfall to Agile (Scrum ban) for other updates in relation to teh project.
• Conducted stand-up meetings with teh PeopleSoft Team and conducted other grooming sessions to ascertain teh meeting minutes and communicate it to teh larger group as General Ledger was teh books and records for PeopleSoft Finance (General Ledger).
• Utilized SDLC as teh tool to get approvals and sign off from teh business and teh tech leads as well as used that to track teh overall status for teh various items in relation to technical development using Axiom.
• Work streams included CCAR, Infrastructure and Data in relation to creating Regulatory Data Mart, 5G app for Treasury data in relation to credit cards and deposits in relation to reporting for user experience.
• Utilized PCDS as teh data warehouse for teh regulatory data mart created for Project Octon.

Environment: PeopleSoft Finance, SDLC, MS Office Suite 2010 (Excel, Word, PowerPoint, Access, Outlook, Project, Visio).

Confidential, Buffalo, NY

Business Systems Analyst

Responsibilities:

• Defined various processes for Banking Domain such as Account Opening for Savings Bank, Credit card Services including overdraft protection in relation to capital markets and loan origination and annuity related products.
• Participated actively in BRD inspections to satisfy teh defined standards and methodologies from teh policy Software Development Life Cycle.
• Included building teh reconciliation reports for teh OPS portal for ecommerce platform for system to system reconciliation.
• Developed a wire transfer capability for making payments using SWIFT message format MT 103 using fund transfer.
• Developed a chat message functionality using SWIFT message format MT199 for fund transfer.
• DST vs. Supermarket Data reconciliation to test teh causes for teh break between teh two systems and update teh logic accordingly to generate teh reconciliation reports.
• Utilized ETL based Data warehouse (Extraction, transformation and loading teh data) for staging, data integration and combination of dimensions using Star Schema and ALM.
• Conducted interviews and workshops with Subject matter experts and business user working groups to gather requirements in relation to asset management.
• Creating RTM (Requirements traceability matrix), mapping Requirements to Design Artifacts and UAT Case.
• Incorporated Agile methodology (Scrum) to create BRD, FSDs using MS Visio and MS Word.
• Conducted Business requirement documents review with project team and stake holders to get sign offs; published and communicated them to various other IT and business teams to follow up on project dependencies using cost-benefit analysis.
• Involved in UAT process and coordinated with teh UAT team to get teh feedback to make change requirements document.
• Actively supported teh goals and activities of teh Business Analysis Center of Excellence.

Environment: Rational Rose, Erwin, IBM Clear Case, MS Office Suite 2010 (Excel, Word, PowerPoint, Access, Outlook, FrontPage, Project, Visio), Visual Basic.

Confidential, NYC, NY

Business Systems Analyst

Responsibilities:

• Interacted with teh Business Owners, Subject Matter Experts and other stakeholders of various fields such as Risk Managers and Project Architects to gather client specific business requirements and translate them in a proper manner for teh developers.
• Teh data gatheird from Bloomberg is transformed to universal values (core values) which are tan provided to teh User Interface for teh dashboard application for accounting.
• As part of teh ICC Team utilized teh data from various brokers (publishers) which is integrated through teh usage of TIBCO bus (datawarehouse) that translates teh data from teh source specific values to teh universal (core values).
• Integration model utilized to analyze teh data coming from teh source and going to teh down systems (subscribers).
• Utilized basic SQL queries and Toad as teh Oracle tool to check teh data coming in from teh business and utilizing translations for that data as part of teh ERP mechanism.
• Developed process flows and wireframes for teh application using Axure Application and assigned to prepare teh detailed Work flow diagram based on teh proposed enhancement for teh tag based management systems using cost-benefit analysis.
• Strong understanding of Investment banking, asset backed Credit card receivables, Collateral Management and annuity as part of teh retirement planning.
• Understanding in relation to credit card receivables (Options, Swaps and Futures), commodities (metal and agricultural) as part of teh Commodities Futures Trading App and Portfolio Management.
• Gatheird teh Business requirements and according to teh User Requirements Specification (URS), Functional Requirement Specification (FRS) and BRD.
• Conducted user interviews and JAD sessions to reduce teh Scope Creep and document analysis in requirements elicitation for asset/ wealth management.
• Facilitated weekly meetings with teh review teams to continuously improve teh Quality Assurance (QA) process for teh application development.
• Collaborated with teh QA Group to ensure adequate testing of application both before and after completion, maintained quality procedures, conducted UAT Testing, and ensured that teh documentation is in place.

Environment: Axure Application, Visio, Microsoft Outlook, SharePoint, JIRA Quick Test Pro, RTD2, RUP Methodology, Oracle 8i

Confidential, Wilmington, Delaware

Business Analyst

Responsibilities:

• Used teh Six Sigma methodology for Software Development Life Cycle (SDLC) guidelines to carry out every step of teh business modeling process.
• Followed reforms related to changes in teh Mortgage Laws for teh Capital Markets and annuity related projects
• Organized workshops with Subject Matter Experts (SME) to obtain domain level information.
• Added Functionality to existing Confidential website to allow its customers to prequalify for a mortgage in regards to credit card history utilizing Dodd Frank Wall Street Reform.
• Organized workshops with Subject Matter Experts (SME) to obtain domain level information in regards to credit score, Annual Percentage Rate (APR), variable interest rate and credit limit.
• Lead discussions and JAD Sessions to gather business requirements and discuss possible solutions documenting them Software Requirement Specifications (SRS).
• Elicited demands from teh stakeholders and analyzed them for consistency, flexibility and completeness.
• Gatheird Functional and Data Requirements, analyzed workflows and created Use Cases, Requirement Specifications, Report Specifications, Data Requirements, Data Mappings and Data Flow Diagrams.
• Documented use cases, created use case diagrams that described teh behavior of teh system and modeled them in Rational Rose.
• Identified, organized, and documented teh changing requirements of teh project using Rational Requisite Pro.
• Assisted in creating wireframes for web interface with teh GUI design team.
• Logged defects to Rational Clear Quest and interacted with developers to resolve teh defects tan verify fixes and close bugs
• Dedicated a good portion of time with teh QA team in front-end, back-end and Regression testing.
• Coordinated with teh business partners in conducting teh UAT (User Acceptance) Testing.

Environment: Six Sigma methodology, Rational Suite (Rational Requisite Pro, Rational Clear Quest, Rational Rose), Oracle, MS office suite 2007, SQL Server 2008

Confidential, Berkley Heights, NJ

Business Analyst

Responsibilities:

• Consistently documented functional and business requirements using use cases and Unified Modeling Language.
• Provided End-user support by supplying TEMPeffective product, efficient process and functional solutions to resolve and enhance current user application functionality.
• Enhanced end-user access to a wide variety of data using Data warehouse modeling techniques.
• Assisted teh Executives and teh Department Heads in Disaster Recovery Operation during production process of applications.
• Interacted with prospects, clients and industry representatives for gathering, analyzing, writing and translating business and functional requirements into Functional specification documents.
• Maintained, communicated and tracked requirements using Rational Requisite Pro.
• Created and maintained artifacts by evaluating needs, clarifying requirements, and analyzing use cases and dependencies to recommend a course of action.
• Used MS Visio to create product maps and sequence diagrams using Six Sigma.
• Worked closely with project manager and gave inputs in teh strategic development of detailed project plans, work assignments, target dates in MS Project.
• Functioned as a vital liaison between teh business line, operations and teh technical areas throughout teh project cycle.
• Worked with development project teams with regards to functional specifications, quality assurance scripting, and product rollout.

Environment: Visual Basic, Oracle 10g, SQL Server 2005, HP Quality Center 9.0, XML and HTML, Rational Rose, MS Visio, MS PowerPoint