SUMMARY

• 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 (Waterfall, Agile 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), which includes SSIS, SSAS and SSRS. Experienced in SQL Server Reporting Service (SSRS), Executing Queries and Running Stored Procedures
• Expertise in data mapping, 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 AgilePLM, scrum processes and experience in redesign of productdevelopment process as per thebusinessrequirement.
• 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 inPLM (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.
• Gathered requirements for Wholesale Credit risk, operational risk and Quantitative risk management.
• 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, Enterprise Architect (EA),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: Rational Unified Process (RUP), Waterfall Method, Agile, Rapid Application Development (RAD), Application Development Life Cycle (ADLC)

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

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

CRM: Siebel CRM and In house built CRM Application

Databases: Teradata, Oracle, DB2, MS Access, Sybase, 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 - 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 tosupport 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, SPA Tools, 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 inTableauDesktop that were published to team for reviewing data analysisand 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

Business Systems Analyst

Responsibilities:

• Analyzed clients 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.