SUMMARY:

• 8 years of experience as a Business Analyst with IT knowledge and have complete knowledge on all phases of the Software Development Life Cycle (SDLC) gained in a variety of domains, including Bankin g .
• Hands on experience in analysing and documenting Business Requirements Documents (BRD), Functional Requirements Documents (FRD), Use Cases and Requirements Traceability Matrix.
• Business Leadership in broad range of management assignments including Sales, eCommerce, Marketing, Revenue Management, Operational Support, Vendor Selection (including offshore), Vendor Management and Systems Management to deliver and service Consumer, Business and Wholesale Products.
• Experience working on Waterfall, RUP and Agile software development methodologies.
• Excellent analytical skills in understanding the business process (AS - IS and TO-BE), understanding the functional requirements and translating them to system requirement specifications.
• Experienced in conducting Joint Application Development (JAD) and Rapid Application Development (RAD) sessions. Conducted Requirement Gathering Sessions and interviewed Subject Matter Experts, gathered detailed functionality aspects of business process and updated the information to the requirements in an easily comprehensible format
• Strong experience in all phases of software development lifecycle (SDLC) using waterfall, Agile/Scrum, RUP.
• Extensive experience in creating business process flow diagrams, UML (Unified Modelling Language) tools to create Activity, Sequence, Use Case, Class, and Collaboration diagrams
• Extensive experience in HP Quality Center, Jira and Bugzilla, Microsoft test Center.
• Participated in project activities like Task Kick-off, Project Monitoring, and Project Closure etc.
• Have knowledge of Version Control, Configuration Management and Change Control procedures.
• Well experienced in working on MS Word, MS PowerPoint, MS Excel, MS Visio and MS Project
• In depth knowledge in Agile, Scrum, Waterfall, Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes
• Competent in Creating Unified Modelling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
• Proficient in Technical and Business Writing, Business Process Flow, Business Process Modelling, Business Analysis and testing various methodologies.
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.
• Facilitated Change Management across entire process from Project conceptualization to Testing through Project Delivery, Software Development and Implementation Management in diverse Business and Technical Environments.
• Experience in Credit Analysis, Credit rating calculations and redesigning the application
• Experience in the ETL (Extract, Transform and Load) of data into a data warehouse
• Experience using MSBI for data extraction, data transformation / analysis and reporting to stakeholders at different levels in the organization
• Creative and enthusiastic self-starter with integrative thinking skills, capable of forming and maintaining positive and productive working relationships in internal, external, independent, and team environments.
• Business Blueprint (RICEFW), Realization, Go-Live, Production Support, End-User Documentation and Training.

TECHNICAL SKILLS:

Microsoft Office Suite applications:: Word, Excel, PowerPoint, and Outlook, SharePoint

Software/Tools: SQL Server, Toad Data Point, Facets, Confluence, Jira, Sharepoint2007, MS Visio.

Programming and Scripting: C, C#.NET, ASP.NET, Core Java, HTML5, CSS5 XML, jQuery, JavaScript, VB Script

Defect Tracking Tools: JIRA, HP QC-ALM, Rational Clear Quest

Database and Tools: MySQL server, Oracle, SharePoint, MS Office Suite- Excel, PowerPoint, Word, Outlook, LoadRunner, Test Director

Project Methodologies: Waterfall, Agile(SCRUM), RUP, UML

PROFESSIONAL EXPERIENCE:

Confidential, Pennington, NJ

Agile Business Analyst/Capital Markets Analyst

Roles and Responsibilities:

• Effectively elicited requirements from stake holders and facilitated communication between Business and the Technical team.
• Create and manage internal and external communication initiatives across business lines and clients
• Responsible for multiple back office analytical functions across the derivatives trading desk.
• Identify and assess new and existing risk and elevate any concerns to Capital Markets Senior Management to mitigate bank exposure or potential loss.
• Lead various process improvement projects within Capital Markets and ensure timely and accurate results of all project deliverables.
• Created and maintained project tasks in Jira, providing daily status reports to project and senior level management.
• Successfully implemented Jira as the project and task management tool of choice for IT, Marketing and other business units.
• Created and implemented a process for Incident and Change management utilizing Jira and Jira Service Desk.
• Co-managed all aspects of ecommerce within our company, ensuring all projects were done on time to maximize sales revenue.
• Involved in the customization of the Salesforce app using Lightning resources.
• Used the data files provided to load data from the legacy system to the new salesforce instance.
• Worked on Agile and Scrum Methodology for Salesforce lightning implementation.
• Collected detailed requirements for ecommerce systems including our B2C websites, eBay store, YouTube channel and mobile properties.
• Trained users on new and existing functionality within the CRM tool.
• Build Salesforce reports and dashboards, customizing them as per user requirements.
• Performing Salesforce administration related to new users’ setup and role update.
• Assist in entering and updating Issues (Epics, Stories, and Tasks) into JIRA Agile application.
• Generate and analyze custom reports and dashboard for management and various business unit personnel to provide detail information on key performance indicators.
• Use advanced Excel functions to generate pivot tables reports to analyze data.
• Provide support for various CRM tools including Salesforce and Funds CRM.
• Reconciled trade level information to advisors within the CRM system.
• Supported and maintained the JPM Funds Management CRM (customer relationship management) system.
• Documented and wireframe system integrations between customer-facing ecommerce properties, 3rd party systems and back-end ERP systems.
• Proactively partnered with other key areas within ecommerce and merchandising to develop a solid understanding of the analytical, creative and technical aspects of business.
• Mocked, validated and documented Web API (Swagger).
• Created the Restful API specification for the Thing space platform in Swagger (Open API).
• Used Swagger for Rest web services testing.
• Modified existing applications to a suite of microservices and all microservices to facilitate deployment using Junit frameworks for unit testing.
• Experienced first-hand the best/worst practices for integrating microservices into an existing system architecture.
• Designed and developed customer, messaging, appointment, product microservices complete with discovery registration code.
• Draft daily hedge strategy reports detailing market analysis, adjusted portfolio coverage and executed trades during the day to brief the Director of Capital Markets and COO/CAO of the organization.
• Liaising daily with Front Office partners to ensure middle office projections correspond with trader estimates while substantiating any discrepancies that may rise.
• Design, Integrate and implement controls to prevent operating exposures and increase business improvements in Capital Markets area.
• Involved in UI requirements and creating Wireframes to help developers build the application
• Assisted in analysing the various data feeds from different sources upstream and downstream eCommerce / PM for Marketing initiatives including email campaigns and online content for product promotions.
• Stood-up Sprint.com/Manage website to establish Customer real-time self-help, e-Care, e-Chat and FAQs. Utilized Benchmark studies within the Telecom Industry to create a Best Practice/World Class website.
• Managed administration of the database of scripted responses and algorithms to automate both online answers to key word search as well as e-Care and e-Chat responses. Drove process to gain stakeholder agreement on scripted responses and legal approvals.
• Developing training materials for Scrum Masters to use in facilitating Agile ceremonies.
• Presenting training materials and mentoring Agile teams on Scrum best practices.
• Leading change in team culture for grooming, planning, and estimating, keeping processes aligned with Agile best practices.
• Identifying and remove impediments and blockers for team to work as efficiently as possible through constant communication with product owners and operations team.
• Reviewing and documenting systems, products, and processes to better implement Agile best practices.
• Organized and facilitated Agile and Scrum meetings, which included Sprint Planning, Daily Scrums or Stand-ups, Sprint Check-In, Sprint Review & Retrospective.
• Participated in Android app development- a WebMD kind of app that suggests OTC and home remedies for general illnesses.
• Conducted requirements gathering, visiting apps already available and studying where they are lacking.
• Documentation of the requirements, writing unit test scripts and test plan.
• Writing jUnit test cases in Android studio.
• Conducting system integration testing once the app was integrated and ready for use and logging defects in the system to be rectified by the developer.
• Developed UML diagrams like Use Cases Diagram, Activity Diagram and Process Flow Diagram using MS VISIO.
• Designed Data flow diagram, managed as is process v/s to be process requirements using Blueprint Requirements Centre.
• Used OBIEE for delivering enterprise reports, scorecards, dashboards, ad-hoc analysis, and OLAP analysis.
• Includes rich visualization, interactive dashboards, a vast range of animated charting options, OLAP-style interactions and innovative search, and actionable collaboration capabilities to increase user adoption.
• Used PeopleSoft for Human capital management, Labour rules and management, talent management etc. Simplified administration through automated time capture and absence management features of PeopleSoft.
• Created test cases to test the liability, comprehensive, collision coverages.
• Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SQL Server Reporting Services (SSRS).
• Responsible for developing prototype designs, demonstrating them to project stake holders and gathering their feedback to improve and progress.
• Documented and analysed SQL queries against various databases and generate reports as per company requirements and exporting to Excel for presentation to upper management.
• Created adhoc reports on Tableau to determine campaign spend based on impressions, ad type, publisher type, and device type.
• Played a key role in the planning, testing, and implementation of the new enhancements and conversions.

Environment: Agile, MS - Office Suite 2013, Advanced Excel Modelling, Microsoft Project, JIRA, MS-Visio, Axure Pro, Java, SQL and XML, Data Governance, Tableau, Blueprint- Requirement Centre tool, SharePoint, OBIEE, Peoplesoft, HPQC(ALM)

Confidential, Pennington, NJ

Agile Business Analyst/Capital Markets Analyst

Roles & Responsibilities:

• Involved in development phase meetings for Business Analysis and Requirements Gathering.
• Conducted meetings for the Data Modelling and Analysis. Enforced naming standards.
• Involved in jobs and analysing scope of application, defining relationship within & between groups of data, Star Schema etc.
• Provide business intelligence analysis to decision-makers using an interactive OLAP tool.
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models.
• Designed and developed Project document templates based on SDLC methodology.
• Helped with data modelling and defining the conceptual and logical model of the data warehouse.
• Tuned the batch programs and online transactions to alleviate performance problems.
• Developed & executed several Optimized queries in SQL on this data.
• Tested Performance & Accuracy related queries under SQL Server.
• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Designed and developed, Use Cases, Activity Diagrams, Sequence Diagrams, Visio and Business Process Modelling.
• Conducted user interviews, gathered requirements, analysed the requirements by using Rational Rose, Visio and Requisite pro - RUP.
• 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.
• Analysed the given source Dimensions and target Fact table structures to develop Surrogate Key tables referencing required dimensions.
• Created Hash tables referencing the Surrogate Key tables for quicker and more efficient lookup to Dimensions.
• Using Shared Containers and creating reusable components for local and shared use in the ETL process.
• Use Cases and other Process Flow Models were designed using Visio and Rational Rose.
• Imported and exported Repositories across DataStage projects.
• Used UML notations for Object Oriented Design and Documentation.
• Wrote Test plan and Test cases for the Integration testing and system testing.

Environment: RUP, UML, SDLC, UAT, Use Case, Rational Test Manager, Data Stage, Rational Requisite Pro, Rational Clear Case, Clear Quest, Rational Rose, Visio, IBM DB2/UDB Universal Database Oracle 8/9i, MS SQL Server 7.0, HTML, XML, UNIX, Windows NT.

Confidential, Boston, MA

Business Analyst

Roles and Responsibilities:

• Interacted with Subject Matter Experts (SME's) and stakeholders to get a better understanding of client business processes and gather business requirements.
• Interacted with client groups to determine user requirements, Business rules and goals. Utilized Rational Unified Process (RUP) to configure and develop process, standards, and procedures and create a Business Requirement Document (BRD).
• Analysed business requirements and segregated them into high level and low-level use cases, activity diagrams, and sequence diagrams using Rational Rose according to UML methodology.
• Followed Agile Iterative development approach and was involved with all iterations of the development life cycle and risk management.
• Prepared Business Process Models and business rules that included modelling of all activities of business from conceptual to procedural level.
• Managed and Maintained G SUITE Enterprise Email Hybrid
• Systems administration, testing, implementation, and support for corporate collaboration platforms (Google Apps/G Suite, video conferencing, and Open Text Enterprise Content Management).
• Understood and articulated business requirements and rules from user interviews and then converted requirements into technical specifications.
• Extensively worked with Project Manager to determine the current best practices for requirement gathering.
• Set up Demand deposit accounts automatically to adjust with interest rates when rate changes occur in money market accounts like mortgage accounts, bond accounts.
• Involved in querying Salesforce tables using SOQL & SOSL queries using Force.com Explorer.
• Track adoption of Google Apps/G Suite and develop action plans to increase adoption in an effort to transition from Microsoft products.
• Analyze barriers to adoption of G Suite applications and provide feedback to the Google engineering team.
• Customized page layouts for Opportunity, Contacts and Accounts depending upon user roles and groups.
• Performed Bulk Data Migration from Traditional Applications to Salesforce using Import Wizard, Excel Connector, Dataloader.io, Workbench, Apex Data Loader utility and ETL tools.
• Analyzed the strategies of Risk management, Mortgage, Fixed Income and Derivatives in the investment division and conducted Portfolio Performance measurement: return, calculation and attribution.
• Used Rational Clear Case as Version Control System for any changes to documents related to project like Use Case documents, Activity Diagrams, Sequence Diagrams etc.
• Medical Billing and Collection Systems: generation of daily billing activity based on patient records and establishment of collection protocols.
• Worked extensively on the Membership & Medical Billing and Claims to support the PMBS project.
• Conducts detailed product training of G Suite solutions for internal staff, business partners, and customers.
• Used and coached using G Suite apps to technical and business teams. Used Excel and Visio for reporting and process mapping to senior leadership during multiple assignments.
• Created and participated in JAD sessions to analyze and prioritize competing business needs.
• Involved in reporting the schedule and the plan of the project using Business Intelligence.
• Managed business requirements in Rational Requisite Pro while making them available to all team members.
• Organized meetings with various branch managers and complex directors to understand the existing Cheque processing through branch.
• Examined, analyzed and modeled test plans, test scripts, test procedures and use case scenarios based on RUP methodology.
• Designed the business requirement collection approach based on the project scope and SDLC methodology.
• Defined program and project goals, objectives, products, services, constraints, assumptions, risks and facilitated processes by working with the project team, sponsor, and stakeholders to baseline the scope of the work and enable development of the plan.
• Responsible for extensive level of project documentation.

Environment: Agile, MS Project, MS Visio, UML, Requisite Pro, Rational Rose, Clear Quest, SQL, MS Office Suite (Word, Excel, Access, Power Point, Outlook), PL/SQL, Oracle, Windows XP.

Confidential

Business Analyst

Roles and Responsibilities:

• Worked on L3 tickets assigned in HP QC and Rally in conventional and agile mode.
• Accepting tickets, reproducing the issue in production environment, reproducing in earlier production environments to find when issue started happening, debugging to find out the root cause and the team that caused the issue, documenting the analysis and sending it to the client.
• Worked on all admin/configuration related changes and stories that would enable the move from the legacy system to the new Salesforce app.
• Created data templates that can be used to load data from the current system to the new Salesforce instance.
• Interacted with client to understand requirements and analyse feasibility.
• Identified the existing functionalities in the application related to the changes being asked by the client.
• Documented the High level and low-level design documents from the BRD provided by the client.
• Enhanced the Java/J2EE banking application to cater to the changing banking rules
• Used Java script to implement client end validations.
• Worked on JSPs to create front end user interfaces
• Suppressed service calls that improved the performance of the application.
• Worked with banking associates to understand the requirements from them, identify the potential changes to be made in the application, write unit test cases, code, test, provide support for the changes and prepare hand over take over documents.

Environment: Java/J2EE, JPA, Oracle SQL Developer, Eclipse, Putty, File transfer tools like FileZilla and WinSCP, Eclipse, Tomcat, SVN, Fiddler, Clear case, SharePoint, Visual Studio Debugger, jUnit testing, Microsoft office.