SUMMARY:

• Energetic, reliable & technically astute professional with over 6+ years of experience as a Business Analyst with solid expertise in Business Analysis, Finance banking Processes, Ecommerce environment, Strategic planning, across projects. Possess knowledge on project management tools, approaches, methodologies and processes that help implement the Change Management, Content Management, Configuration Management, Requirement Analysis, Business Analysis, Project Management, System Modeling and System Planning while structured customized solutions to meet customer’s specific needs.
• 6+ years of Industry experience as a Business Analyst with solid understanding of Business Requirements Gathering, Evaluating Data Sources, Translating Requirements into Specifications, and Application Design.
• Strong BRD, FRD, and technical specifications writing. Strong knowledge of financial market products and processes.
• Experience in SDLC methodology and practices in project management and application development (Agile, Waterfall and RUP).
• Experience in B2B, B2C and Ecommerce portals web application developments.
• Strong experience of the mortgage loan process especially developing related webpages.
• Experience in utilizing SAS Procedures, Macros, and other SAS applications for data extraction, data cleansing, data loading and reporting.
• Expert in working with the Tableau, Business Intelligence Development Studio (BIDS), Executing Queries and Running Stored Procedures.
• Expertise in data mapping, data profiling, business process mapping and data mining.
• Expertise in Project Management i.e. Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting and Drafting Remedy Procedures.
• Strong knowledge of Agile PLM, scrum processes and experience in redesign of productdevelopment process as per the business requirement.
• Visualization experience in Python and R language in the field of Data Science.
• Experience in the data analysis, DB creation, applying database constraints and make ready to load onto database.
• 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.
• Extensive experience in modeling the AS IS and TO BE Ecommerce Solutions.
• Organized Joint Application developments (JAD), Joint Application Requirements sessions (JAR), Interviews and Requirement Elicitation sessions.
• Expertise in PLM (Product Life Cycle Management), MDM (Master Data Management).
• Worked with Rational Suite of tools to create requirements documents (Requisite Pro), visual data models (Rose), manage and track defects (Clear Quest).
• Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
• Involved in Test Planning, Test Preparation, Test Execution, Issue Resolution and Report Generation to assure that all aspects of a Project are in Compliance with the Business Requirements.
• Strong experience in conducting GAP Analysis, User Acceptance Testing (UAT), Cost Benefit Analysis and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

TECHNICAL SKILLS:

Business Modeling Tools: Business Objects, Rational Rose, MS Visio, UML,ATG commerce, MS Excel

Defect Tracking Tools: JIRA, Quality Center (Test Director), Rational ClearQuest, Rational ClearCase

Testing Tools: WinRunner, Quick Test Professional (QTP), Rational TestManager

Methodologies: Agile, Rational Unified Process (RUP), Waterfall Method, Rapid Application Development (RAD), Application Development Life Cycle (ADLC)

Microsoft Tools: MS Excel, MS Visio, MS PowerPoint, MS Project, MS Word

Data warehousing Tools: Tableau, Informatica, ETL Load Process, Teradata SQL Assistant

CRM: In house built CRM Application

Databases: Teradata, Oracle, DB2, MS Access, Databricks (PostgreSQL), MS SQL Server

Languages: SQL, HTML5, CSS3, JavaScript, Java

Requirements Management Tools: MS Team Foundation Server (MS TFS), MS SharePoint, Rational RequisitePro, JIRA

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Lead Business Analyst / Scrum Master

Responsibilities:

• Gathered requirements for both CCORD and CDD applications.
• Done some Project management related work like planning, executing, monitoring, controlling and even closing the project.
• Played a Scrum Master role and followed all the best practices of agile.
• Managing daily Stand - ups, Sprint Backlogs, Sprint Planning Meetings and conducting Retrospectives.
• Responsible in presenting Demos, creating Story Board, and writing User stories.
• Worked extensively on JIRA by writing User Stories, assigning them and creating backlogs.
• Created DRD (Data Requirements Document), MRD (Metrics Requirement Document).
• Creating detailed documentation on Team’s Confluence pages.
• Worked as a liaison between Business Users and Technical team.
• Supported the project throughout all phases of SDLC.
• Worked to create Data Mapping Documents and worked with business users to write transformation logics through SQL.
• Worked with Business owners and Stake Holders to get most of the requirements.

Environment: JIRA, SQL developer, MS Excel, Oracle database.

Confidential, Chicago, IL

Business Systems Analyst / Systems Integrator

Responsibilities:

• Worked on gathering requirements and documentation for Know your Customer (KYC) project.
• Worked as a liaison between Business Users and Technical team in analysis & design.
• Responsible in writing detailed use cases, gathering and documenting BRD and FRD requirements.
• Maintained Requirement Traceability Matrix, Systems Design Document (SDD) and reengineering business process and designing.
• Documented Business Process flows, created "As-Is Business Models" by meeting with SMEs and stakeholders.
• Supported the project throughout all phases of SDLC.
• Worked to create Data Mapping Documents and worked with business users to write transformation logics through SQL.
• Transfer business questions into fact-based analysis that delivers clear insights and actionable recommendations.
• Worked as a Scrum Master by managing daily Stand-ups, Sprint Backlogs, Sprint Planning Meetings, Retrospectives, Demos, Story Board, and writing User stories.
• Implemented Agile/Scrum as a project management methodology.
• Worked very closely with Product owner as a bridge between internal teams and external partners.
• Data mapping from Source to target data is one of the key things I have done in requirement gathering.

Environment: SQL, MS Excel, JIRA, Project Management, Teradata, PostgreSQL, Data Mapping/Profiling, S3 database, MS Visio, Tableau.

Confidential, Austin, TX

Technical Business Analyst / Data Analyst

Responsibilities:

• Design, develop, implement, execute, and monitor Sanction Screening rules and reports and other types of decision analytics to detect fraud and revenue collection risks.
• Track and report Sanction screening KPIs and risk behaviour to develop strategies for improving Sanction Screening operations.
• Developed SAS code to identify potential fraud through data analysis of over 30 million users.
• Support and lead projects that lead to optimal balance between loss reduction, customer experience, revenue enablement, cost of losses and meeting AML compliance policies.
• Responsible for conducting GAP Analysis based on the requirements.
• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools.
• Work on assignments that may be unstructured and exploratory in nature and expertised in a high level theoretic as well as practical in specialized technical fields.
• Responsible for leveraging data mining, analytics, and business intelligence to solve business/operational problems.
• Worked on the SQL and optimization of the Business Objects reports.
• Used Data Script in SSIS to run programs, packages and handle errors in files for analyzing and presenting data through user interfaces such as SharePoint and advanced Excel.
• Participated with senior leaders to establish strategic plans and objectives for development of future analytic technologies and solutions.
• Responsible for formulating data-driven revenue protection/payment risk strategy through business intelligence and analytics.
• Lead the development of data and analytic capabilities to drive business results and achieve strategic priorities.
• Identified opportunities and product/process enhancements using sales, trends, customer behaviors and risk analysis.
• Communicating analytical results, findings and solutions clearly and concisely to all levels of leadership.
• Assist in developing and testing of new reports and rules to support Global Billing Sanction Screening with adhoc analysis.
• Meeting with directors to go through productivity and KPIs.

Environment: SQL, Teradata Database, Teradata SQL Assistant, SAS, Data Mining, R programming language, CSI WatchDog, Agent Desktop, MS Excel, JIRA, Reporting, Data Analysis, GAP Analysis, Business Objects and Project Management.

Confidential, Austin, TX

Business Analyst

Responsibilities:

• Facilitated Joint Requirement Planning (JRP) sessions with SME’s in understanding the Requirements pertaining to Loan Origination to Loan Processing.
• Involved in the analysis of the existing credit card processing system, mapping phase according to functionality and data conversion procedure.
• Extracted the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents (BRD) using Rational RequisitePro.
• Performed GAP analysis to meet the requirements.
• Mainatined requirements in JIRA for tracking and testing purposes.
• Used Agile/ SCRUM and PMI methodologies to monitor, steer and develop project objectives.
• Created and managed Project Templates, Use Case Project Templates, Requirement Types and Traceability Relationships in RequisitePro.
• Translated business requirements to data mining requirements by using different data analysis tools such as Tableau.
• Coordinated with DBA and Business objects designer group in solving various technical issues.
• Lead the configuration of the client's business process workflow repository utilizing various process modeling tools based upon my recommendations.
• Involved in creating automated Test Scripts representing various Transactions, Documenting the Load Testing Process and Methodology. Created meaningful reports for analysis and integrated the Performance Testing in the SDLC.
• Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
• Used SQL to extract and collect data to generate reports using BI tools such as Tableau. Involved in understanding the reporting requirements and providing Tableau reporting solutions.
• Performed various data analysis and data profiling using SQL.
• Creating, developing global Business and User policies for various BI tools such as Tableau, Microstartegy and Qlikview. Also, built complex formulas in Tableau for various business calculations.
• Various versions of the documents are generated during the project were maintained and managed using Rational ClearCase and performed defect tracking using Rational Clear Quest.
• Created manual Test Cases in HP ALM for various user stories based on Release and Sprint Plan.

Environment: MS Visio, MS Access, MS Excel, UML, JIRA, HP ALM, Tableau, Rational Rose, Requisite Pro, Clear Case, Rational Clear Quest, GAP Analysis, Business Objects.

Confidential, Round Rock, TX

IT Business Analyst

Responsibilities:

• Gather business requirements for all business processes by coordinated Joint Requirement Planning (JRP) sessions & group meetings with system owners and development team, to define system requirements, system interaction specifications and brainstorm solution design during analysis phase.
• Worked on JIRA to create Bug report.
• Created views in Tableau Desktop that were published to team for reviewing data analysis and customization using filters and other actions. Used Tableau to develop in-depth Dashboard Drill Down and Links to interrelated performance metrics .
• Gathered and converted data over to Tableau using T-SQL/SAS/Excel data over to tableau reports and Dashboards.
• End-to-end product upgrade experience in project planning, requirements gathering, GAP analysis, code development, function/user acceptance testing and production rollout.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Data Stage, Data Warehousing, WebSphere and Cognos.
• Management of source code repositories, builds and deploys using Microsoft’s Team Foundation Server.
• Document process workflows textually as well as in UML diagrams according to RUP, for the stakeholder review.
• Active participation in Systems testing, Integration testing and Stress testing. Coordinated QA efforts with QA team.
• Designed various documents including the Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), UML diagrams and Systems Design Specification (SDS).
• Designed and maintained SQL scripts and optimize SQL queries.
• Effectively involved in various stages of the development starting from the project planning till production and maintenance using Agile Methodology.
• Used Team Foundation Server (TFS) for Version Control and Source code repository.

Environment: MS Office, ETL, Oracle, Crystal reports, Tableau,RUP, UML, JIRA, SQL, Teradata, Agile, ClearQuest and GAP Analysis.

Confidential

BusinessSystems Analyst

Responsibilities:

• Analyzedclients systems and business processes.
• Addressed all aspects of credit card business.
• Wrote and maintained Business Requirements Documents BRDs and Functional Requirements Documents FRDs defining new systems operations for the Online Banking project using Rational Requisite Pro.
• Managed mortgage loan process and analyzed progression of the loan process.
• Discussed with SMEs across different businesses units to gain solid knowledge of the existing system.
• Streamlined clerical work processes and mapped then into the new system.
• Developed project plans and managed project scope.
• Used JIRA for Defect tracking.
• Gathered requirements from JAD/JAR sections with developers and business clients.
• Designed and developed Project document templates based on SDLC methodology.
• Performed extensive Requirement analysis and developed use cases and workflows.
• Designed and developed Activity Diagrams, Sequence Diagrams, and OOD.Also developed Use Cases and UML models using Microsoft Visio.
• Conducted JAD sessions for communicating with Stakeholders and Project directors.

Environment: Microsoft Office SharePoint, MS Office, Rational Clear Quest, Rational Clear Case, Rational Requisite Pro, Rational Rose, Agile, UML, JIRA, Business Objects, BRD, Microsoft Excel, Microsoft Word, Microsoft Power Point, Visio.