SUMMARY

• Over 7+ years of proactive IT experience as a Business Analyst with Finance and Banking expertise. In - depth knowledge and extensive experience in capturing/analyzing business, IT & functional requirements,businessprocess analysis, design, development, testing, integration, maintenance and project management.
• Highly experienced in sequential and iterative software development life cycle (SDLC) approaches like waterfall, RUP, Agile Scrum/XP.
• Experienced in various capital market instruments including Equities, Fixed Income Instruments, Mutual Funds, Hedge Funds, FX, Derivatives, Mortgage &Asset backed securities.
• Knowledge and experience with all aspects of the Trading Lifecycle, Net Suite, Front/Middle/Back Office processes and Messaging concepts (SWIFT).
• Well versed with Risk Management (Credit Risk, Market Risk), Sarbanes Oxley (SOX); Portfolio Risk, Liquidity Risk, Obligor Risk Rating, Statement Forecasting, Stress Testing)
• Excellent knowledge of the banking industry - Retail / Private banking, Investment banking and financial services.
• Experienced with procedures of Banking and Regulatory Compliances -Anti-Money Laundering (AML), Basel Accords, Dodd Frank Act, Bank Secrecy Act (BSA), USA PATRIOT Act, OFAC and Customer Identification Program (KYC/CIP).
• Worked extensively for common ERP Modules include modules for product planning, parts and material purchasing, inventory control, product distribution, order taking, finance, accounting, marketing, HR.
• Exceptional understanding of Corporate Finance, Quantitative analysis, P&L, Balance sheet analysis, Accounting, Financial market, Financial modeling, Data forecast and Sensitivity analysis.
• Strong experience in authoring Business and Functional Requirement Documents (BRD, FRD), defining business processes, identifying risks, performing Gap Analysis and Impact analysis.
• Highly proficient in preparing Business and System Use Cases and supporting all the documents with UML Diagrams such as Use Case Diagrams, Class Diagrams, Activity Diagrams, Data Flow Diagrams, Sequence Diagrams, Process Flows (Business and System) using UML modeling tools such as MS Visio and Rational Suite.
• Worked as primary tester on ERP application designed for external clients
• Strong Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/data mart, Data mapping/modeling, Hyperion, Business Intelligence (BI) tools and OLTP/OLAP systems.
• Well versed in SQL queries.
• Use of Microsoft tools suite.
• Benchmarked, analyzed overall site usage, Site traffic analysis by Google analytic, Analyze conversion rates, Analyze page views, bounce and exit rate.
• Expert in installation, configuration and setup of ERP application and 3rd party products.
• Experienced in data modeling, creating star/snowflake schemas and fact/dimension tables in addition to designing E-R models, both logical and physical, using Erwin Data Modeler.
• Proficient in designing, reviewing and documenting System Test Plans, Defining Test Procedures and Creating Test Cases on the basis of product release features, client’s requirements and related technical documents.
• Strong analytical, problem-solving and communication skills with particular emphasis on clear, detailed Business requirements and Functional specifications.
• Preparation of annual budget projection using excels. Finance lead for implementation of ManMan ERP system
• Creative and innovative thinker, team player, result-oriented, excellent communication skills, fast learner with strong research capabilities.

TECHNICAL SKILLS

Programming Languages: C, C++, HTML, XML, SQL.

Data Base: MS Access, Oracle (SQL Series), DB2

Reporting Tools (BI Tools): Crystal Reports 8.0, OBIEE, Hyperion Reports, Cognos reports, Business Objects

Operating Systems: MS-DOS, Windows95/98/NT/2000/XP, Apple McIntosh, Linux

Software: MS Office Suite (Word, Excel, Access, PowerPoint & Outlook), MS Visio, Rational Rose, Rational Requisite Pro, Adobe Acrobat, MS Office FrontPage, Lotus Notes

Performance Testing Tools: Virtual User Generator, Load Runner

Processes/Technologies: Rational Unified Process (RUP), Waterfall, UML & Microsoft Office SharePoint 2007

Methodology: SDLC, JAD, Waterfall, Iterative, RUP, Agile Scrum, Agile Kanban, Agile SAFe

Data warehousing Concepts: Data Mart, OLAP, OLTP, Global, Independent and Interconnected Data Warehouses,Slice/Dice, Drill Up/Drill Down

PROFESSIONAL EXPERIENCE

Confidential - Gwinnett County, GA

Sr. Business Analyst

Responsibilities:

• Monitored, analyzed and reported performance of website using site analytics tools such as Google Analytics and Omniture, mainly focused on key business metrics that drive the business including traffic drivers, site sales, conversion, site experience, site functionality, etc.
• Collaborated with members of the Ecommerce team as well as Merchandising, Creative, and Brand Marketing teams to provide analytic support to measure performance of efforts. Assisted end-users in identifying key performance indicators for their areas and proactively share knowledge and learnings.
• Maintained daily and weekly dashboards. Support the creation and on-going maintenance of daily, and weekly KPIs.
• Assisted in gathering and analyzing consumer feedback to inform product, website, or functional enhancements.
• Work with business sponsors and stakeholders to understand business requirements and develop technical specifications for projects.
• Identifies data sources, constructs data decomposition diagrams, provides data flow diagrams and documents the process.
• Oversee, coordinate, and participate in organizational, operational, and procedural analyses to determine information input, and desired output for potential and/or up dated computerization for a large number of users in support of a multi departmental or country wide applications.
• Reviewed and analyzed variety of forms, documents (RT or Approach Framework) reports, data output, and record-keeping requirement to identify any questions or requirements POS team has. Contribute in weekly staff and Analyst/Dev Meetings.
• Used Google Analytics to analyze website usage, page views, traffic and exit to find out popular products and the reason why potential customers abandon shopping carts.
• Simplified check out process by simplifying customer registry process. And Improved payment gateways by using Authorize.net and Paypal Pro.
• Conducted email marketing based on customer preference.
• Involved in creating and prioritizing the Sprint Backlogs in Rally Scrum Sprint Planning Sessions, conducting Sprint Retrospectives and Reviews, sharing metrics to identify and implement improvements.
• Manage daily Scrum/Kanban for various development efforts
• Created Alternate Milestone schedule for the each assigned project that to the particular release.
• Wrote Approach Documents ( a.k.a BRDs) that details business requirements for the approved RT, walkthrough of the and obtain sign off from business.
• Scheduled and host weekly internal project meetings beginning onset of analysis to implementation
• Worked with developer leads and managers, System Testers & UAT; to review requirements of the project, status of testing and any issue needing discussion.
• Synchronized POS and cross team delivery schedules to ensure needed resources are available.

Environment: Rally Agile Project Management Tool, Google Analytics, Omniture, Omnichanel, Authorize.Net, Paypal Pro, SQL Server, QTP, Kanban, Quality Center, VBA, MS Visio, MS Office, MS Access, Gap Analysis, UML, ATG, CRM.

Confidential, Boca Raton, FL

Sr. Business Analyst

Responsibilities:

• Assist with the development of data management systems, including computer programs to monitor programmatic data quality in MS Access, and MS Excel (omin channel, inventory management, manage data ware house).
• Worked with the Merchandising and Marketing departments to monitor online marketing programs, identify opportunities for optimizing campaigns and proactively alerting the team when programs deviate from expected results.
• Updated and maintenance of departmental SOP's, FAQ's, Guides, etc. related to Omni-channel initiatives.
• Coordinated project working with cross-functional partners to create and maintain standardized Omni-channel reporting. Such reporting would include operational metric reporting, daily dashboards, ad hoc operational troubleshooting, as well as strategic reporting.
• Expert at generating reports through Google Analytics and Universal Analytics
• Identified underperforming areas of the site and opportunities to improve site performance.
• Aggregated and analyzed reports, as well as data from multiple sources, to support and enhancing Omni-channel initiatives. Prepared data and information for projects, team meetings, PowerPoint presentations and ad hoc requests.
• Developed Store and Corporate Communications and Training initiatives in support of Omni-channel strategy.
• Analyzing and documenting project plans, detailed implementation requirements, system designs and other project deliverable in the form of client deliverable.
• Communicating expectations to stakeholders and team, gaining acceptance.
• Created project plan to identify when each task will be performed, and any dependencies, capable of multiple large projects by gathering business requirements, working with vendors and technical resources on the designs that meet those requirements.
• Gathered business requirements through analysis to determine project deliverable; reporting projects, and produced BRD based on high and low level requirements.
• Managed and analyzed the e-learning platform database and the requirements.
• Effectively manage project scope by ensuring any changes are documented and approved both internally and externally with project change request forms.
• Obtain client sign-off on the Project Completion Form.
• Perform invoicing and project closure functions.
• Maintaining a regular and predictable work schedule, designing process flow and developing clear understanding of business operations.
• Performance analysis and capacity planning and Agile

Environment: Rally, HTML, SQL, Kanban, JavaScript, MySQL, QTP, VBA, HPQC, ATG, CRM, Google analytic.

Confidential, Princeton, NJ

Business Analyst

Responsibilities:

• Identified project stakeholders and their roles.
• Understood the BSA/AML trade surveillance compliance requirements by interacting with compliance department and SME experts in the laws/act of compliances.
• Drafted project charter, which included project goals, business case, opportunity statement, and high level timeline and team assignments for the projects.
• Identified resource requirements i.e., business analysts, software developers, testers, etc.
• Recognized major deliverables and collected business requirements for the project.
• Authored Requirement documents - BRD and FRD. le Functional/Technical member to fully take over Net Suite’s on-board consultants to create a win-win by leveraging functional and technical leadership abilities to solidify both Net Suite’s and OSF's requests.
• Mentored the transformation of all the information needed to convert from the current software "chai" used into the ERP new system making sure the solutions recommended are commercial yet very competitive.
• Utilize Hyperion to retrieve and review reservation systems data stored in DB2 tables in iSeries (AS/400).
• Tested application programs in support of new applications, interfaces between applications, and conversion applications for new software implementations and upgrades in relation to the ERP modules.
• Established guidelines and parameters for the system based on currency and foreign transaction regulations like Bank Secrecy Act (BSA), USA PATRIOT act, OFAC, SDN etc.
• Cross trained and supported related groups and areas of AML like Transaction (MIL) Filtration; Analytical Views & Reporting (SAR, CTR).
• Work in a variety of systems including: SCRUM/Agile, JIRA, Confluence, PeopleSoft, Visio, Google Analytics, Oracle-Hyperion, SharePoint, and Sales force, Service Now, MicroSoft CRM
• Devised a work breakdown structure by decomposing the project deliverables and User Stories.
• Elicited Business/system requirements and needs as a part of an Agile Scrum team.
• Identified major activities as per the Agile Scrum methodology.
• Assisted the Scrum Master in maintaining User Stories, creating and prioritizing the (Product, Release, Sprint) Backlog in Rally, coordinated Sprint Planning Sessions, conducting Sprint Reviews and Retrospectives and Acceptance Criteria.
• Developed project schedule by incorporating resource availability and milestones for reporting.
• Performed a Web traffic analysis using various digital tools like Google Analytics

Environment: Agile Scrum, Actimize/Mantas AML, SAP R/3, Oracle e-Business Suite, Sage MAS 500, Agresso Business World, Epicor Enterprise, Ramco e.Applications LexisNexis, Hyperion, ERP, Factiva, World-Check, SQL, JIRA, ERwin, iRise, HP Quality Center, Net Suite, Subversion (SVN),MS SharePoint, MS Office (Excel, Word, PowerPoint), MS Visio, UML.

Confidential, Salt Lake City, UT

Business Analyst

Responsibilities:

• Gathered high level requirements and developed scope of the project for the implementation of Microsoft Office Share Point 2007.
• Conducted weekly meetings for deciding the Policies and Procedures to be followed while constructing new sites.
• Gathered requirements for the integration of POS system with the supply chain system
• Performed the requirement analysis, impact analysis and documented the requirements using Rational Requisite Pro.
• Designed and developed Activity Diagrams, and Sequence Diagrams utilizing MS Visio.
• Documented the server farm requirements and requirements related to security within Share Point and using Windows Active Directory.
• Followed a systematic approach to eliciting, organizing, and documenting requirements of the system.
• Responsible for creating Business Requirement Specifications, to capture functionalities at all E-Commerce touch points.
• Reviewed the Joint Requirement Documents (JRD) with the cross functional team to analyze the High Level Requirements.
• Created Physical Inventory process for retail stores, consisted of data integration and inventory processes with third party vendor
• Assisted with the BRD for the POS implementation project
• Captured and documented system level (SSS) and software level (SRS) requirements in DOORS supporting the SOW and system design for the SCL3S Airborne Communcations program.
• Interacted with client and the Technical Team for requirement gathering and translation of Business Requirement to Technical specifications.
• Conducted interviews, meetings and JAD sessions during the process of Requirement Gathering.
• Planned and documented procedures for data processing and prepared data flow diagrams for the application.
• Create technical design documentation for the data models, data flow control process, metadata management.
• Worked on exporting data using Teradata.
• Wrote detailed specifications for various reports generated using Cognos
• Developing the application on J2EE platform with Oracle 8i database programming. Combined the latest e-commerce technologies -enterprise business XML (ebXML), SOAP
• Analyzed the data collected and process maps to determine the root causes and identify opportunities.
• Planned and defined system requirements to Wire Frame with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies
• Created business requirement documents and integrated the requirements and underlying platform functionality.
• Analyzed and translated business requirements into system specifications utilizing UML and RUP methodology
• Analyzed trading partner specifications and created EDI mapping guidelines
• Documented the Traceability Matrix for tracing the Test Cases and requirements related to them.
• Developed Data Conversion Strategy for converting data from the existing site to the new site.

Environment: Windows XP/2000, Oracle, PL/SQL, SharePoint, Unix, Doors, MS-Project, MS-Office Suite, MS Visio, Rational Requisite Pro, Clear Case, Clear Quest, MS Access

Confidential, Phoenix, AZ

Business Analyst

Responsibilities:

• Extensively involved in every phase of the RUP process starting from Inception to Transition
• Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Co-authored business requirements document, functional requirement document with project teams. Extracted, discussed, and refined business requirements from business users and team members.
• Responsible for business system analysis of customizing the BPS Risk Management product with involvement through the whole SDLC
• Collaborated with Basel II team on credit risk analysis and issue resolution.
• Developed BRD documents for Securitized Inventory (CMO, ABS, MBS, and ABCP). BRD targeted new Basel II Compliance requirements.
• Worked on Risk analysis, Securities (Stocks and corporate bonds) and their valuation, Portfolio Management (risks and returns) and analysis, Asset Allocations Bond pricing, Financial Derivatives, Cash flows, financing structure, Capital Management, Stock Valuation, Amortization, etc
• Designed and integrated a business system requirements defiantion and management tool using MS SharePoint
• Worked on Documentum for Version Controlling, to maintain up to date changes in the Documents.
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.
• Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules

Environment: Microsoft Office Suite, Microsoft Visio, Documentum, Windows NT/XP, Oracle, SQL, SQL Server, Sybase, EVPN, RUP,VBScript, Dreamweaver, Sharepoit, Hyperion, Adobe Photoshop, Caliber RM MIS-IP, C#. NET, ASP.NET, UNIX, Business Objects, Test Director, Load Runner.