SUMMARY

• Over 8+ years of experience in roles such as Business Analyst/Technical Writer/Data Analyst/Business Systems Analyst with solid understanding of Business Requirement gathering, Business Process flow, Business Process Modeling and Business Analysis.
• Developed excel models to derive the amortization schedule for Whole loan products, Residential Mortgage, especially Loan Origination and Mortgage Backed Securities.
• Good working experience of Insurance, Sales, Banking and Payment processes
• User Stories, Acceptance Criteria, Scrum Meeting, Product Backlog, Backlog Grooming, Sprint Planning, Retrospective
• Experience with Agile tools like JIRA, Rally and TFS
• Knowledge of PMBOK (Project Management Body of Knowledge) and PMI (Project Management Institute)
• Experience with Currency Transaction, Payment and EMV Reporting Systems
• Extensive programming experience in developing Enterprise applications using SQL server Database 2010 and 2008 Web Services, PHP, UML, HTML, Java Script and XML
• Demonstrated Project management skills to ensure on - time and cost effective project completion.
• Extensive experience in conducting Gap Analysis, SWOT analysis, Cost - Benefit, TCO, ROI, and Businesses Processes Re-engineering.
• Extensive experience in and technologies like Tableau, Jira, Normalization/DE normalization, Data Models, Stored Procedures, Web services, Dashboards and Reporting.
• Strong Database/Data warehouse, data transformation, data modeling knowledge with strong SQL and analytical skills.
• Expertise in developingSQL scripts using variousjoins, procedures, and functionsin SQL Server.
• Adept at gathering requirements by organizing Joint Application developments (JAD) and Joint Requirement Planning sessions (JRP), Brain Storming Sessions, Interviews, workshops and Requirement Elicitation sessions, sessions with end-user/clients/stake holders and the development group.
• Experience working with RDBMS technologies like Oracle, SQL Server, DB2 and with BigData systems like HDFS, HIVE, PIG, HBASE and MapReduce.
• Strong understanding of Software Development Life-cycle (SDLC): Analysis, Design, Development, Testing and Implementation and the methodologies including Agile and Waterfall methods
• Excellent problem solving, analytical, interpersonal, and communication skills and a quick learner with the ability to work independently or in a group with minimal supervision.
• Excellent documentation skills including writing Business Requirements Documents (BRD) and Functional Requirement Document (FRD), as well as designing business models, Entity-Relation Diagrams, and process flows based on UML methodology.
• Very good knowledge on testing techniques like black box, white box, UAT and report testing using SQL.
• Good knowledge in Analysis of Bug Severity, Bug tracking system and Bug Reporting.
• Strong business acumen, strategic thinking, communication, interpersonal & presentation skills, adapt at creating, editing, and coordinating extensive communication networks
• Experience in developing Test Plan, Test Strategy, Test Cases and Traceability Matrix as per the business process requirements to match the functionality requirements and UML diagrams.
• Experience in facilitating and conducting UAT as well as training users on new system functionality

TECHNICAL SKILLS

Languages or Concepts: C, C++, SQL, Java, HBASE, HDFS, HIVE, PIG, SQL, Oracle, Map reduce, AWS, XML, AS/400 (I-Series): RPGLE, RPG, Free format, CL Mainframe: DB2, COBOL, JCL & VSAM

Operating Systems: Win 95/98/NT/2000, XP, UNIX, Mac

Internet Technologies: HTML, XML, Java script, CMS

Databases: MS SQL Server, MS Access, Oracle apps, DB2, teradata

Tools: MS office, MS Project, Visio, Rational Rose, Freelance, Word processor, Tableau - Dashboard, Jira, Clarity, ERP, VBA, SharePoint, Jive & Outlook

Reporting Tools: Tableau

Management Strategies and concepts: Project Integration and Risk Management Plan, Kanban, Agile - Scrum Project Plan, Project Leadership and Communication Plan, Lean Agile, Applied Project Management Plan, SDLC, Concept and Tools of Quality Management Test Director and Win Runner, ISO Concepts, Six Sigma Techniques

Web Technologies: Wordpress, Google Analytics, Google Docs, Google AdWords

PROFESSIONAL EXPERIENCE

Confidential, MOUNTAIN VIEW, CA

Technical Writer/Business Analyst

Responsibilities:

• Involved in the SDLC phase of requirement analysis, design, data warehousing, business intelligence, loading method, database modeling and migration of the current state CPS architecture to the new Agrium Insight architecture.
• Worked on residential loans, deposits, mortgage values and financial planning and data analysis
• Designed Technical, Functional and Business requirements artifacts. UI, business rules, task and activity coordination, technical integrations
• Order to Cash (O2C), Source to Pay (S2P), Forecast to Stock (F2S), Demand Planning (DP), and Supply Network Planning (SNP), and Record to Report (R2R) Responsible for updating & maintaining reference architecture models & artifacts, in corporate emerging cross-industry trends.
• Implementing, solutioning, and architecting core ERP, Trade, Financial, Planning, EDI, Tax, B2B, and B2C applications and data integration -- have extensive experience working with large application vendors like SAP, Oracle, Microsoft, and SaaS providers like NetSuite, WorkDay, Salesforce, and ServiceNow
• Basic knowledge on BPM tools such as next process, logicgate etc.
• Translate high-level business requirement to technical and functional documents.
• Created various web page layouts using HTML and CSS.
• Plan, Design, Review and Test website content - Google Analytics, Hostgator, Cpanel, E-commerce, Finance EMV and PayPal
• Designed, developed and updated User Interface Web Forms using CSS, Dreamweaver and JavaScript.
• Responsible for developing, editing, publishing and managing content on the external Web pages and internal layouts.
• Used Cascading Style Sheet (CSS) in web pages to separate presentation from structure.
• Defined text alignment, size, borders and many other typographic characteristics.
• Performed client-side validations using JavaScript.
• Successfully used Agile/Scrum Methodology for gathering requirements and documenting User Stories
• Developed UML Use-Cases and Use-Case diagrams after accessing the status and scope of the project and understanding the business processes using IBM Rational Rose.
• Assisted the Stake Holders and the product owner in the Sprint planning sessions to determine the scope, objectives, architectural vision of that respective iteration and with budget and resource planning.
• Worked with the design team during the conceptual design phase and conducted GAP analysis to derive requirements from existing systems for the proposed future stateenhancements and determine the risks.
• Created and owned the Requirements Traceability matrix which included all phases of SDLC.

Environment: HTML, XML, Java script, CMS, Wordpress, Google Analytics, Google Docs, Google AdWords, MS SQL Server, MS Access, MS office, MS Project, Visio, Rational Rose, Tableau - Dashboard, Jira, Hive, Clarity, ERP, VBA, SharePoint, Jive & Outlook

Confidential, Irving, TX

Business Analyst

Responsibilities:

• Performed requirements gathering from the business users of the system while adhering to SDLC (Software Development Life Cycle) industry best practices.
• Developed excel models to derive the amortization schedule for Whole loan products and Mortgage Backed Securities. I2C (Invoice to Cash) and P2R (Procure to Report)
• Facilitate meeting both onsite and offshore
• Interacted with Software development team and Business users as a liaison in helping developers to understand the business requirements thereby ensuring the proposed applications comply with the business specifications.
• Analyzed information and requirements and documented them, reviewed the Business Requirement document and detailed the Systems Requirement document.
• Met with different business users to determine user requirements and goals
• Designed different document templates to gather Business Requirements, Change Requests and UAT.
• Prepared project plan and defined milestones.
• The system fully supported fixed rate, ARM, GPM, GEM, interest only, deferred payment, home equity, reverse mortgage, second mortgage loan programs, etc.
• Discussed different functional requirements and defined high-level design and Use Cases with project team.
• Developed process flow diagrams (flow charts) using MS Visio in an effort to identify and analyze process flows in the BOFA Safe Deposit Box system.
• Lead Validation/Verification, SIT (System Integration Testing), and Mock conversion on the system to ensure data accuracy and BOFA Bank’s business needs.
• Wrote User Acceptance Test Plan based on business users requirements and reviewed Test Plan templates.
• Delivered and maintained extensive documentation for future extendibility of the system.
• Analyzed the system to be implemented for production to ensure that it handles complete and accurate data and performs default method of calculations for various mortgage products like Mortgage Backed Securities, Asset Backed Securities, and Megas & Tranches.
• Conducted presentations to make users understand about processes and functionality. .
• Used MS Excel and MS Word to create a field-to-field data map that was used as a main specification document for the conversion program.
• Used JIRA for creating issues brought up by business users and for defect resolution management.
• Developed traceability matrix for maintaining/updating system requirements using MS Excel.
• Prioritized outstanding defects and system problems, ensuring accuracy and deadlines were met. Identified and participated in resolution of business system issues.

Environment: AS/400 (I-Series): RPGLE, RPG, Free format, CL Mainframe: DB2, COBOL, JCL, VSAM, SharePoint, MS Office Suite, Win 95/98/NT/2000, JIRA

Confidential

Sr. Business Analyst

Responsibilities:

• Played an instrumental role in defining the initial common terminology to be used throughout the product lifecycle.
• Documented and reported the progress to the management on an ongoing basis.
• Defined roles and responsibilities of participants in the business process.
• Recommend system/process solution approaches to minimize risk and workflow impacts while capitalize strategic goals.
• Implement best practices for Agile Project Management (Sprint Planning, Sprint Review, Sprint Retrospective, Grant chart, Burn down Chart, WBS, Network Diagram, Requirement Traceability Matrix),
• Tracked, Detected and Reported bugs using JIRA as the defect tracking tool
• Led and conducted JAD sessions for requirements gathering, analysis and design of the system.
• Created context and workflow models, information and business rule models, Use Case and Object Models during the analysis using rational tools.
• Facilitated walkthroughs with business SME’s from loan origination, processing, underwriting and closing domains.
• 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.
• Facilitated user stories and Story Point discussions to analyze the level of effort on scope specifications for multiple iterations.
• Implemented Traceability Matrix andUser Requirement Specification Document(URS)toverify the functionality.
• Communicated the status of testing and defects regularly to the business analyst and developers
• Analyzed the client data and gathered requirements by conducting interviews with the clients.
• Acted as a liaison between the business users, stakeholders and the team to perform requirements, quality and risk analysis.
• Performed GAP analysis, conducted walkthroughs and set up internal/external status meetings and postmortem meetings.
• Designed and developed project document templates based on SDLC methodology.
• Assisted QA in Regression Test, System Test and UAT in creating complex SQL scripts for data validation.
• Facilitated Change Control Board and Governance Board meetings and acted as a liaison between parties impacted by the change requests.

Environment: Oracle RDBMS 10g/11g, SQL Server 2012, HBASE, HDFS, HIVE, PIG, SQL, AS/400 (I-Series): RPGLE, RPG, Free format, CL, Oracle, Map reduce, JIRA, AWS, Core Java, Citrix, Visio 2003, MS Project and Tableau.

Confidential

Business Analyst

Responsibilities:

• Prepared the Business Requirement Document (BRD) and system requirement document (SRD) for the enhancement of the existing services.
• Serve as Communication Bridge between non-technical users and technical solution developers.
• Actively participated in review sessions for functional specifications and Use cases.
• Act as a liaison between business and IT team.
• Used JIRA for creating issues brought up by business users and for defect resolution management.
• Built the system for DQ using advanced concepts of ILE. Develop Documents HLFTD, FTA.
• Analyzed the Functional Specs, requirements and prepared the Impact analysis of the existing WQ.
• Generated Test Analysis Report and graphs.
• Developed Reports and Graphs to present the Stress Test results to the management.
• Helped QA create complex SQL scripts to validate data and worked with Developers to create stored procedures.
• Gathered business requirements through teleconference meetings with offshore teams.
• Performed task estimations and documentation of procedures.
• Conducted JAD sessions with business units and stakeholders to define project scope, to identify the business flows and determine whether any current or proposed systems are impacted by the new development efforts.
• Analyzed the root cause for batch job failures and online application failures and take the appropriate action to avoid the batch delays.
• Assisted in drafting scope document to facilitate communication gap and meet aggressive time lines.
• Tracked and assisted in determining needed resources for Cost Benefits Analysis with project manager and product owner
• Successfully used Agile/Scrum Methodology for gathering requirements, documenting User Stories, and develop process, standards and procedures.
• Worked in tandem with the testing team during System and integration testing.
• Provided test input during the business analysis, system test, functional and UAT lifecycle.
• Identified project risks and issues and communicated them to project team to avoid any delays.

Environment: AS/400 (I-Series): RPGLE, RPG, Free format, CL Mainframe: DB2, COBOL, JCL, VSAM, SharePoint, MS Office Suite, Win 95/98/NT/2000, JIRA, MS Excel, MS Word.

Confidential

Business Analyst

Responsibilities:

• Coordinated regular business requirement meetings with business users.
• Performed requirements analysis and delivered final requirement documents.
• Functioned as the liaison between business community and project team.
• Worked with PM to decide on project approach as well as project plan.
• Developed front-end functional specification documents based on reporting requirements.
• Worked with technical architect to deliver the functional design specification documents.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams and OOD using UML.
• Developed test scenarios and implemented test plan, providing key input in working with users in defining project and system requirements.

Environment: MS Visio, UML, Oracle, SQL, MS Office and Windows 2000.