SUMMARY

• Business Analyst with 8 years of proven work experience in agile environment leading all Scrum ceremonies. Has been versatile working in different environments using agile.
• Acted as a liaison between technology and teh business.
• Worked in all phases of SDLC with proficiency in Requirement gathering, Analysis, Design, Documentation, Data Analysis, Data Mapping and Data Modeling, Testing, Implementation managing business analyst functions and providing executive level support to principals.
• Superior interpersonal and analytical expertise with a flair for increasing organizational cohesiveness and profitability through talent assessment and employee management.
• Utilize management experience to align financial and business activities with organizational goals, fostering business growth.
• Comprehensive noledge and experience in Software Development Life Cycle (SDLC) with business process models: Waterfall & Agile (Scrum) methodologies
• Good understanding of teh AS - IS and TO-BE business processes (GAP analysis) and experience in converting these requirements into technical specifications for preparing test plans
• Participate in various Agile Ceremonies; identify/define business processes/ User goals/User stories. Managed various stakeholder's groups, gather & manage Business, functional & non-functional requirements.
• Proficient in creating various documents like Business Requirements Document (BRD), Functional Requirement Document (FRD), Functional Specification Document (FSD), Systems Requirements specifications (SRS), Object Oriented Analysis and Design (OOAD).
• Extensive experience in Guidewire configuration and integration experience with claim center, policy center and Billing Center.
• Strong experienced in all insurances such as Property and Casualty Insurance including Auto, Home, and Marine.
• Worked in various healthcare functional areas like Enrollment/Membership, Benefits, Claims, Providers, Eligibility, Encounter, Estimator, Payment solutions, Population Health Management.
• Strong working experience and familiarity of emerging regulatory standards including Basel, Dodd-Frank Act Stress testing, CCAR, KYC and AML.
• Insurance experience includes Personal Property Casualty and Commercial Automobile Product noledge, Reinsurance for Personal Property Casualty, Group and Life Insurance Systems
• Responsible to Track, Document, Capture, Manage and Communicate teh Requirements using Requirement Traceability Matrix (RTM) and established service level requirements which helped in controlling numerous artifacts produced by teh teams across teh deliverables for a project
• Extensive working experience in Sitecore platforms like Web Content Management.
• Expert at interacting with stakeholders, Subject Matter Experts (SMEs) and end-users to understand, analyze, communicate and validate requirements using Joint Application Design (JAD), Joint Application Review (JAR) sessions
• Assisted teams in creating different SSIS and SSAS packages in different Control Flow and Data Flows.
• Experienced in writing User stories with acceptance criteria or User stories with Use case
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, using UML and Business Process Modeling (BPM).
• Verified dat Risk-Weighted Assets (RWAs) were adequately measured against Tier 1 capital to ensure AIG's capital ratios meet regulatory capital requirements.
• Experience developing various state, activity, class and Use Case Diagrams to better understand teh process dataflow
• In depth noledge of Rational Unified Process (RUP) methodology
• Developed various Flowcharts, activities, Use cases, state charts and process flow diagrams to better communicate and visualize teh business flow using Unified Modeling Language (UML) tools
• Proficient in ensuring dat business goals are met throughout teh product lifecycle. Proficient in creating Behavioral and Structural UML diagrams including Activity, Sequence, Data Flow and ER Diagrams.
• Performed rigorous testing with QA team to prevent potential production issues and ensuring dat teh application is functioning as per teh business requirements
• Involved in all phases of Product Lifecycle Management (PLM).
• Involved in GUI testing, Functionality Testing, Regression testing, System Testing, Unit Testing, Integration Testing, Performance Testing, and Stress Testing.
• Monitored UAT and regional teams testing plan to match BRD and lead bug triage sessions.
• TEMPEffectively communicated with testers and management in TRIAGE meetings to decide priority (P1-P3) and severity (S1-S3) of bugs and work items based on end user feedback from User Acceptance Testing (UAT)
• Hands full of experience in MS Office Suite, MS Project for Project Plan, MS Visio, Rational Suite Rational Rose, Rational Requisite Pro, Rational Clear Case and Rational Clear Quest.
• Expert in UAT during solution implementation Phase (manual testing). Also interacted with team of QA to convey business requirements
• Good noledge of Wealth Management Accelerator (WMA), Wealth Management
• Wrote Process approach documents and SIPOC mapping for TL 9000 quality compliance
• Proficient in developing & automating reports, iteratively build & prototype BI dashboards using Tableau to provide insights at scale, solving for analytical needs of business team.
• 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.
• Knowledge of all Commercial Insurance Rules and State Filing Requirements/ISO/NCCI
• Coordinate deployment of IT solutions on Clouds (AWS, Microsoft Azure)
• Has strong noledge on fraud and anti-money laundering applications.
• Design, documentation and review of business documents like business Requirement Document (BRD), Functional Requirement Document (FRD) and System Requirement Specifications (SRS).
• Microsoft Dynamics CRM 2015, CRM 2013, CRM 2011, 4.0 Business Analyst, Technical Analyst, System Administrator, CRM UI Configuration Manager, and CRM Reports, View Workflows, Dialogs, SSRS design expertise.
• Strong experience on various P&C insurance modules including Claim Management, Bill Management, Policy Management, Payments, Claim Offline Tool and Medicare Claim Reporting Tool.
• Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis and ROI Analysis.
• Organized weekly project status meetings and task review meetings documented and disseminated meeting minutes TEMPeffectively
• Utilized a combination of business noledge, technical skills, and strategic analysis to provide solutions and creative insights to critical business problems
• Good Communication skills and capable of working independently and as well as a part of a team.
• Capable of forming and maintaining positive and productive working relationships in internal, external, independent and team environment

TECHNICAL SKILLS

Process Methodologies: RUP-Rational Unified Process, UML- Unified Modeling Language, Waterfall, Agile, Scrum process, Kanban

Project Management: MS Project, Excel Spreadsheets

Languages: C, C++, SQL, Oracle, Java, AML Language

Universal: VISIO

Quality Management: JIRA, Rally, Confluence, Mercury Quality Center, Analysis

SDLC process: Clear Management, Clear Quest, SharePoint

Object- Oriented: Rational Rose

Office Tools: MS Word, Excel, Power Point

Testing: Unit Test, Win Runner, Load Runner, and Manual Testing, UAT-User Acceptance Testing, Selenium

Databases: MS SQL Server, MS Access, Balasamiq. ETL

Business Intelligence Tools: Alteryx 9.x, SSIS, SSAS, Tableau 8.x, 9.x, 10.x, Cognos, TIBCO

Web Languages: HTML, XML

PROFESSIONAL EXPERIENCE

Confidential, Wyomissing, PA

Business System Analyst Risk/ Finance Domain

Responsibilities:

• Thoroughly studied teh capital market structures and account reconciliation systems to has a clear understanding of teh Financial business processes and associated system workflow
• Interacted closely with stakeholders and Subject Matter Experts (SME) for gathering requirements and created Product backlogs
• Collaborated with Scrum Master and Scrum teams in Sprint Planning meeting and Sprint review meetings
• Prioritized Sprint backlogs and managed changes to Product backlogs
• Actively tracked teh ROI for various components of teh project
• Worked with teh ETL development team in brainstorming sessions for understanding and developing teh data transformation logics.
• Extensively used BI for analyzing securities including equity, foreign exchange, bonds; building analysis flow for portfolio rebalancing and monitoring asset class performance
• Communicating key risks metrics as well as analyzing and providing commentary on daily and weekly movements to senior management through regular Meetings and Presentations.
• Extensively involved in teh deployment of Data Warehousing System.
• Worked with SharePoint developers and stakeholders from 9 different teams to document requirement to migrate content from SP 2010 to SP 2013 and get UAT signed off post migration.
• Conducted market research and analysis in Capital Markets consisting of Stock Market and Bond Market
• Actively worked with teh Capital Market and financial trading team to develop Equities, Futures, Forwards, Options, Derivatives online trading facility
• Utilize Microsoft Excel to create spreadsheets dat require sorting, organizing, and manipulation of data in accordance to project specifications (pivot tables, vlookup, and IF nested statements)
• Used Application Management tools for managing requirements and defects, specifically ServiceNow and HP Quality Center.
• Managing Service Now Integration with vendors system for Incident, Problem, Request and Change modules.
• Offered data support and checking using SQL/Query and developed complex spreadsheets using VBA\SQL.
• Worked with requirements analysts and Subject Matter Experts to identify, understand, and document business needs for teh data flow to create market risk and credit risk modules
• Played a lead role in conducting JAD/JAR sessions, got requirement specification documents including Project Objectives, Business Requirements, and Business Rules sign off
• Consulted teh business users and SMEs, helped to create Product Backlogs to prioritize features and subsequently created Sprint Backlogs
• Involved in content management change control and Version Management. Performed regular updates to various static web pages.
• Participate in JAD sessions with cross impacted IT teams to help ensure they has teh information they need to determine their involvement (including PPL hours and commitments) and get teh information needed for teh cross impacted teams to plan their work efforts.
• Participated in JAD sessions with teh reporting team to determine requirements for data dat will besent from AEM to report environment to meet teh business reporting needs.
• Create functional specifications for teh data files dat will be sent from AEM to report environment team, based on teh data models created by teh architectural and reporting environment teams.
• Performed rapid prototyping and screen Mock-up utilizing I Rise
• Used SAS and SQL to retrieve, validate and manipulate data
• Assisted Testing teams to build test plans, approved test cases for functional requirements verification and to check teh functionality of teh application
• Risk management: Market Risk using VaR, Historical Simulation, Variance-Covariance and Monte Carlo Simulation, Option Greeks, Credit Risk using Sensitivity analysis, Break Even analysis, Duration/Complexity Analysis, Scenario Analysis, Stress Testing and Back Testing.
• Review possible check fraud and unauthorized withdrawals. Identify red flags related to teh various fraud types for retail banking or credit card products.
• Focused in Comprehensive Capital Analysis and Review (CCAR) Reporting, Governance, Risk & Compliance (GRC) and Dodd-Frank Regulatory Reporting, including FRY 9C, FRY 14M/Q/A.
• Conduct surveillance of SEF trades across multiple asset classes (rates/FX/credit/equities /commodities)
• Involved in teh migration activities, where some part of SAP EP was migrated to JAVA
• Examines and evaluates teh purpose and content of current business reports to identify opportunities for improvement and automation through macros, VBA, or SQL.
• Responsible for generating quick excel reports using Pivot Tables, and Advanced Formulas (Vlookups, Countifs, Sumifs, Sum product, match, offset, lookup, Hlookup, if conditions) Excel Macros (recorded, modified and executed) to automate some of teh testing and reporting tasks
• Collaborated with QA team to create and implement test plan and test cases for User Acceptance Testing (UAT). Involved with teh whole UAT to ensure teh performance of teh system and application
• Developed User Manuals, presentations and training manuals as per project specifications and timelines
• Provided status update to teh Project Manager of progress made on work products and milestones achieved
• Reviewed by scrum team and BA team to improve their performance.

Environment: Agile, Windows, MS SharePoint, Oracle, Minitab, QI Macros, Power BI, OBIEE, Cognos, Tableau, BABOK, MS Office Suite (Word, Excel, Power Point, Outlook), V-Lookups. Pivot Tables. JIRA, MS Visio, TL 9000 metrics, SQL server 2012, SQL, Mercury Quality center

Confidential, Austin, TX

Business System Analyst Finance Domain

Responsibilities:

• Implemented and integrated RUP solutions with a complete line of traceability for all teh artifacts of web development projects.
• Supported teh implementation, and ongoing improvement for a portfolio of ITOM processes for continuous tracking, reporting, and data quality
• Served as teh 'AFS to Loan IQ' data mapping SME for teh LIQ (Version 7.4) Conversion project.
• Worked closely with LPT team members, onshore and offshore developers, and bu3siness SME's and IV&V testers to ensure dat all Loan IQ API data mapping documents were accurate and up to date.
• Wrote and maintained teh 'Data Lineage Document', a comprehensive, high level data mapping document which captured every donor field being converted to Loan IQ and was used as a reference by teh entire project.
• Created complex Metrics Packet for teh PMO team, Updated databases and amended training documents
• Triaged, remediated, researched, tracked and helped resolve Quality Center defects assigned to teh LPT Loan IQ Conversion team through all teh environments
• Worked on Table Maintenance, Adhoc query modules.
• Experience in creating Created Customer, Deal, Facility, Outstanding and many other transactions in Loan IQ.
• Worked on several LIQ interfaces, writing business, functional and data mapping documentation for several new Loan IQ batch and real time interfaces.
• Build Macros in Excel, using teh record macro feature to automate sorting and filtering of large data sets. Created Pivot Tables making data user friendly for front end users, helping to manage a pipeline
• Merger related tasks included creating and maintaining data and process flow charts, as well as complex data mapping / data transformation spreadsheets.
• Worked with various teams to create 'As-is' and 'To-be' flows for identified critical data elements using MS Visio and PowerPoint.
• Designed various report layouts of different source systems dat are built on teh data marts based on teh user requirements for different line of Business (Investment Management, Investment Services, Wealth management and Regulatory reporting teams).
• Data entered info via use of Calyx Point & DU & LP to prepare for underwriting
• Gatheird functional requirements and wrote BRD's, FRD's (functional requirements specifications) and FSD's (functional system designs) for numerous Loan IQ downstream applications.
• Responsible for SIT (System Integration Testing) test planning, data validation and defect analysis using HP AML Quality Center.
• SME in Handling E-CIF/CRM functionality testing and queries individually or with surround systems such as internet banking, FEAS, IVR, CAPS, RLS.
• Used SQL to query data from teh Security Master Database and gatheird reference data from multiple live data feed sources such as Bloomberg, Thomson Reuters.
• Perform Sprint Demo during Sprint review ceremony and record feedback
• Identification of Performance Scenarios/Interfaces in teh application based on teh NFRs.
• Investigated software bugs and interacted with Dev team to resolve bug issues using MTM
• TEMPEffectively involve in logging bugs, reviewing solved bugs and analyzing test result using MTM
• Development of teh Content Management system and followed up closely with teh development team for successful completion of teh Content Management System
• Closely monitored teh page security access to each group of users
• Sent weekly dashboard reports to management with updates of teh development process of teh Content Management System.
• Performed requirements modeling and developed Analysis Diagrams, Activity Diagrams, Sequence Diagrams, and State Diagrams, Data Models, and Use-Case relationships using RUP tools in Agile Methodology.
• Assisted development teams in Testing for Bug Fixes in teh daily builds and turn around for immediate fixes.
• Gatheird Business Requirements from Product Owners to document requirements for mobile applications updates.
• Developed and expanded agile processes within teh team such as estimation, task breakdown, sprint review, showcasing, and retrospective
• Designed various report layouts of different source systems dat are built on teh data marts based on teh user requirements for different line of Business (Investment Management, Investment Services, Wealth management and Regulatory reporting teams).
• Worked very closely with Developers and resolved any issues they has during development cycles and co-ordinate with Business for any clarifications.
• Create weekly Status reports for Business to track teh progress of teh project and highlight any deviations from teh proposed plan.
• Provided coverage for AML compliance monitoring, CIP, KYC and OFAC. Assisted teh Internal Audit Analyst for various work-streams within CCAR Audit - e.g. Basel III, Treasury/Liquidity, RWAs, Capital Policy/Planning, Risk Identification.
• Involved in teh BRD, FSD and DDR reviews with Business, Developer and Mapper.
• Worked as a liaison among stakeholders to elicit, analyze, communicate, validate and document requirements for changes to business processes, policies on information systems including User Accounts Management (UAM), TDA Web, and Investment Portfolio & KYC Admin tools.
• Worked with Project Manager and Development Leads in creating Project Plans and updating teh daily tasks.
• Assisted Testing Teams in translating Use cases to Test Cases. Also worked closely with Testing Lead in creating and validating Test Plans.
• Tracked all major and minor Bug fixes through completion. Validated production reports and escalated production bugs for immediate fixes.
• Maintained and kept track of stakeholder's request for enhancements and changes using Unified Change Management Tool (UCM) such as Rational Clear Quest and JIRA
• Used Rational Clear Case, Configuration Management Tool to maintain different builds of teh application with description about all changes and versions.
• Created User Manuals and provided User Training for teh changes made to Mobile and Website.

Environment: Windows, MS SharePoint, MS Office Suite (Word, Excel, Tortoise SVN,Power Point, Outlook), RDMS, JIRA, Rational Clear Quest, MS Visio, Java EE7, SQL server 2012, SQL, HTML, UML

Confidential, Rockford, IL

Business Analyst Insurance Domain

Responsibilities:

• Application of Simulation to understand teh current system and identify problematic areas
• Used Simulation to verify teh impart of Variability on teh system and identified different levels of improvement
• Worked closely with teh program manager and Project managers to define teh scope and high-level requirements for teh program
• Worked on teh Claim Center integrations - Acuity(Litigation Management), Contact Manager, External Accounting Systems, ISO, OFAC
• Performed analysis of published Circulars from ISO/NCCI and other regulatory Bureaus for system impact and prepared detailed business and functional requirements.
• Planned activities for teh BA group and provide estimates for BA activities
• Supported development of Project initiation, Project Charter and Project plans
• Worked in developing teh wireframe and mock-ups for teh prototype of teh web-based portal application in MS Visio
• Created Process blueprints for Cost and Time estimates for migrating existing Savvion Business Process Applications to IBM BPM.
• Create mapping documents for ETL implementation; Create mapping documents from data source to Teradata target tables.
• Manipulate advanced Excel spreadsheets and data using intermediate to advance skill levels
• Worked on various User Stories related to Claim Center(Financial Summary, Reserves, Payment Exceptions, FNOL Process, Recovery, Vendor Ratings, Modular Reporting, ISO Claim Search, Internal Drafts, Reallocation, Payment Allocation, Reserve Allocation, Work Matter Summary, Maintain Work Plan, Maintain Activities, Executive Dash board, Special Investigation Unit, Claim Metrics and Cash Flow Management)
• Experience in Guidewire Claim enters, Policy center and Billing enter, claim enter Integrations and Configuration User Stories.
• Excellent skill in creating Unified Modeling Language (UML) standard diagrams including Use Cases, Activity Diagrams, Data flow diagrams and Sequence diagram.
• Involved in preparing and reviewing Test Plan, RTM, Test Cases, Test report and resolving UAT issues. Involve in extensive data analysis on Teradata, and Oracle Systems Querying and Writing in SQL and Toad.
• Gatheird business requirements for Auto Finance stakeholders.
• Scheduled and led requirements gathering through JAD sections for elicitation and documentation
• Document detailed business requires, Business rules, rating requirements, and coverage requirements
• Analyze Insurance forms and document forms requirements
• Compared actual and expected test results, discussed teh defects in defect meeting with development team and then recorded/reported/tracked all Defects to Developers using a web-based tool called Rally (Bug, Issue and Project Tracking tool).
• Conducted JAD sessions and interviewed SMEs, asking detailed functionality aspects of Business Process (BPM) and carefully updating teh information to teh requirements in an easily understandable format.
• Worked closely with architect team to design solution to meet business needs
• Provided testing documents including test plan, test cases and verifications
• Performed GAP analysis and traceability matrix to trace missed requirement and variations in teh actual results(As-is) as against teh expected(To-be) software product states
• Acted as a liaison between Business users and project team (SME's, developers, testers, data team, Architects) to define business requirements and analyze teh functional requirements for Personal Lines P&C Insurance.
• Used Rational Requisite PRO and DOORS in various P&C projects for requirements management and traceability among requirements, uses cases, business rules and test cases.
• Compared actual and expected test results, discussed teh defects in defect meeting with development team and then recorded/reported/tracked all Defects to Developers using a web-based tool called JIRA (Bug, Issue and Project Tracking tool).
• Worked in Property&Causality (P&C)- Commercial lines & Homeowners insurance
• Compiled detailed documentation for technical teams (architect and QA) involved to be clear on teh nature and item being worked on
• Gatheird requirements for a fully electronic auto insurance contract process
• Create wireframes using Axure RP Pro based on collaboration with use cases and Visio flows
• Laid down teh guidelines for a smooth flow of teh different project elements in P&C domain, in different iterations and phases of teh Software Development Life Cycle (SDLC)
• Provided hands-on instruction and guidance on how to prototype various JSON producing RESTful web-services and database systems using PHP, Node.js, and Python Django web frameworks during teh senior project experience.
• Developed UAT and System Integration Testing (SIT) plan, facilitated UAT and SIT testers as well as Triage defects periodization and solutions
• Elicited and drafted requirements for financial system transaction posting for SAP FS-CD (SAP for insurance collection and disbursement).
• Worked with data analysts to identify, design and implement solutions for extraction and integration of data for creating reports, decision making with using SSRS and SSIS
• Assisted in issues resolution and escalation as well as patronization and tracking
• Actively involved in brainstorming and JAD session with teh client in order to identify all teh business requirements for P&C project development.
• Carry out Metadata and data quality control for market risk, credit risk, interest rate risk, counter-party risk, liquidity risk, operational risk, inflation risk, and systematic risk data.
• Used Waterfall methodology of SDLC to manage projects

Environment: Agile Scrum, HTML 5, SAP CD,CSS, Adobe Photoshop, Windows Forms, Web Forms, Doors, IBM BPM, MS Visio, Arena, SQL Server, Win Runner, Rally, Clear Quest, SSRS, SSIS Load Runner, Window 8

Confidential

Business System Analyst

Responsibilities:

• Analyzed balance sheet, P&L, cash flows, job costing and budget variances for multiple entities.
• Interviewed teh **** (state) transportation department stakeholders and SMEs to elicit business rules, understand processes, information, and systems in use.
• Reviewed teh legal background, legislative history, administrative case law, and court decisions dat interpret teh policies and regulations for these government programs
• Involved in development & documentation of Software Requirements Specification (SRS) using TIFIA loan
• Reviewed and evaluated financial models and forecasts, particularly sensitivity analyses of Borrower’s base case models.
• Administered teh entire Automated Test Framework.
• Created teh complete Manual Regression Test and later turned it into Automated Regression Test Package by using Selenium IDE (Rails & Ruby).
• Managed teh review, execution and delivery of amendments, consents and waivers to teh credit agreement and is primarily responsible for obtaining all necessary internal approvals for said documentation changes with minimal senior supervision.
• Established processes for GDPR cookie compliance with OneTrust and internal auditing.
• Participated as department-stakeholder of city-wide Business Intelligence Procurement Committee (hands-on testing over a dozen BI Tools including Tableau, Alteryx, Power BI, Qlik, SiSense, Birst, and Logi Analytics)
• Participated as teh TIFIA representative on teh oversight group, if any, formed to protect teh interests of teh senior lenders during teh life of teh senior loan.
• Worked with teh Bureau lead underwriter for credit negotiations and assigned USDOT financial and engineering staff, write teh Project Monitoring Plan for each credit agreement.
• Added Oracle ECOs to teh process for Prototype BOM, routing, Transfer Prototypes to Prod, Production BOM mass changes.
• Implemented Kanban Planning system
• Reviewed monthly reports from teh construction contractor, teh borrower, teh independent engineer (or lender’s technical representative) and USDOT engineering staff to identify issues of concern dat could prevent project completion within teh approved budget.
• Developed wireframes and mock ups using Adobe Dreamweaver
• Coordinated all disbursements of TIFIA loan proceeds through Oracle to ensure timely and accurate payment for eligible project costs.
• Conducted reviews to ensure compliance with all covenants and prepared notices of default litigation and other adverse events. Develops and updates tracking reports on revenue performance. Reviewed updates to traffic and revenue studies, as appropriate. Identifies and monitors issues dat could prevent timely repayment of teh TIFIA loan.
• Conduct periodic site visits to projects funded by TIFIA loan proceeds to document teh progress of each project and identify risks to project completion or repayment of teh TIFIA loan.
• Reviewed monthly and annual financial status reports from teh collateral agent or borrower. Reviewed quarterly and annual audited financial statements submitted by teh borrower. Advised USDOT management regarding any early warning signs of potential adverse financial conditions dat could prevent timely repayment of teh TIFIA loan.
• Experience in data migration Masterworks via FTP to a Amazon cloud (AWS).
• Monitored compliance with debt service coverage or loan life coverage ratios and rate covenants.
• Coordinate annual review of teh borrower’s loan amortization schedule. Provide copies of loan amortization schedule revisions to teh borrower.
• Extracting, Scrubbing and Transforming data from Main Frame Files, Oracle, SQL Server, DB2, Teradata and then loading into Oracle database using Informatica, SSIS
• Performed ETL processes; scrubbed data; and performed data mapping using MS Excel and MS Access to ensure data quality and workflow processes were following teh new government mandated policies and standards.

Environment: My SQL server,Waterfall, Oracle SQL, PL/SQL, Assura, SSIS, SSAS Kanban, JAVA, Groovy & Rails - Grails, Selenium IDE, Cognos, MS Visio, ETL, Microsoft Excel, Microsoft Word, Tableau

Confidential

Business Analyst Credit card/ E- Commerce Domain

Responsibilities:

• Acted as a liaison between teh project group and teh operations group.
• Helped design scope document and to coordinate with top management for teh approval process.
• Form teh requirements and using technologies such as JavaScript, XML, LDAP, AML language (like XML), and TIBCO configure and provide custom enhancements to teh client
• Interviewed various personnel including broker dealers and traders to understand teh current process and teh future requirements.
• Designed teh prototype of teh Data mart and documented possible outcome from it for end-user.
• Extensively conducted JAD sessions to understand teh business requirements
• Involved in generating various reports using teh SQL Server Reporting Services (SSRS).
• Involved in design, development, implementation and roll-out of Micro Strategy Business Intelligence applications
• Interacted closely with stakeholders and Subject Matter Experts (SME) for gathering requirements and created Product backlogs
• Tracking and reporting budget and cost allocation variances and performing cost/benefit analysis.
• Custom tools upgrade client had created marketing, merchandising production, batch support tools to support their custom web application which needed to be re-architected to work with ATGs ecommerce suite.
• Used CSS, HTML and JavaScript for GUI front end designing and validations.
• Responsible to design, develop and test teh software (Informatica, PL SQL, UNIX shell scripts) to maintain teh data marts (Load data, Analyze using OLAP tools).
• Extensively involved in Business Process Modeling. Created teh AS IS and TO BE business processes
• Worked with third party integration, Google Analytics, Ruby/Watir, data verifications/backend testing, defect management, SQL, API implementation, UNIX shell commands, process modeling.
• Creation of business and functional requirement documents and use cases supporting them with wireframes and other visual documentation as required.
• Documented teh business requirements following teh RUP methodology using rational requisite pro
• Used rational tools for version control and defect management
• Authored teh Business Requirement Document (BRD).
• Experience in all phases of Full Life-Cycle Oracle E-Business Suite Financials implementation i.e. Requirements Definition, GAP Analysis, Process Modeling and Implementation.
• Designed teh screen mockups using Balasamiq.
• Developed Business rules for teh equity trading system based on technical chart analysis and fundamental analysis and trends.
• Used rational Rose to create use cases for different scenarios and cases.
• Analyzed, cleaned and reorganized data by using tools including Excel, Alteryx and Pivot in Tableau
• Developed Business specification diagram to understand teh whole work flow.
• Created UI Specifications and wire frames.
• Lead multi-disciplinary project teams through all phases of teh project life-cycle providing coaching, motivation and inspiration. Projects were executed using Sitecore and .NET.
• Involved in development and testing of POS Point of sale systems and applications for Payment Card Industry (PCI) Compliance initiative.
• Create teh wireframe of Functional work flow using teh Balasamiq tool
• Provided recommendation for use of ATG Commerce for B2B and B2C business.
• Developed activity diagrams in Rational Rose software, to has a diagrammatic view of teh workflow.
• Used Invasion in enhancing teh user experience; worked closely with teh technical and programming team to prepare Screen Mockups, User Interface designs using wireframe prototype for this Ecommerce mobile/web redesign.
• Perform Teradata (Enterprise Data Warehouse) validation and analysis to identify teh accurate data source and to track data quality to detect/correct teh invalid data.
• Collaborated with teh QA team for developing scenarios for validation and testing by using Red Hat Stack.
• Responsible for end user training and P&Ps
• Got involved in teh User acceptance Testing (UAT) and SIT and documented teh test scenarios and outcomes.

Environment: RUP, JavaScript, Oracle, Red Hat Enterprise Linux Server, COBOL, CSS, HTML, Google Analytics, R, R Studio, Alteryx, Tableau XML, LDAP, AML language, Balasamiq, TIBCO, MS SharePoint, MS Office Suite (Word, Excel, Power Point, Outlook), Unit testing