SUMMARY

• Over 8 years of experience as a Business Systems Analyst with solid understanding of requirement gathering, process flow, Business process modeling and testing the Deliverables
• Progressive experience working within an Analytics and/or Business Intelligence environment, with deep know - how of both the technical and business aspects of data solutions
• Excellent communication, presentation and persuasion skills
• Thorough problem solving and analytical skills, combined with strong business acumen
• A strong voice for data integrity and reporting quality utilizing best practices and industry standards
• Passion for developing and analyzing large, complex data sets and converting them into the information/insights that drive business decisions at all levels of the organization using Data Visualization tools like Tableau.
• Demonstrated ability to work actively in different phases of Software Development Life Cycle using Rational Unified Process, waterfall and Agile methodologies.
• Strong understanding of the workflows of diversified industries including Insurance, Banking, E-Commerce and Travel & Logistics.
• Experience with conducting ROI & cost benefit analysis to make build or buy decision.
• Thorough knowledge of all steps of procurement process RFI, RFP, RFQ& contract singing
• Highly proficient in working with users and stakeholders to elicit, analyze, communicate and validate requirements using JAD, JAR and Brainstorming sessions
• Expert in performing Gap Analysis by evaluating the key differences between the as-is and to-be system followed by identifying requirements for system re-engineering
• Extensive documentation skills including project deliverables such as Project Charter, Business Requirement Document (BRD) & Functional Specification document (FSD), Change Requests, Statement of Work, Use Case Document and many more.
• Competent in creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity, Class and sequence Diagrams to support the development team and business groups
• Strong experience in conducting User acceptance Testing (UAT) and documentation of test cases. Expertise in designing and developing Test plans and test scripts
• Extensive experience in ROI analysis, Impact Analysis, SWOT, Cost Benefit and Risk Analysis
• Knowledge of Work Breakdown Structure (WBS), Responsibility Accountability Matrix (RAM), Risk Assessment, Gantt Chart & other project management tools
• Experience working with offshore development team and ensuring completion of projects within tight timelines.
• Strong expertise in building Templates, Graphical analysis charts and Statistical reports using MS Excel, MS Word, MS PowerPoint.

TECHNICAL SKILLS

Languages: SQL, HTML, JavaScript, CSS, XML, CFML

Requirements Gathering Tools: Rational Requisite Pro

Modeling & Designing Tools: Rational Rose, MS Visio, Enterprise Architect

SDLC Methods: Agile, RUP, Waterfall

Databases: Oracle 7.3-10g, IBM DB2, Teradata, SQL Server 2005/ 2008

Database Tools: Toad, SQL Developer, Teradata SQL Assistant

Reporting Tools/UI Languages: Tableau 9.0, ColdFusion MX7, 8

ETL Tools: Informatica 8.6

Big Data: Hadoop (Cloudera and Apache Distribution) & Cassandra (Certified 1.1 Dev)

Configuration Management Tools: Visual Source Safe, SVN, MKS, CVS

Operating Systems: MS Windows NT/2000/XP, UNIX

Other Tools: Microsoft Project, MS Office, SharePoint, HTML, CSS, QC

PROFESSIONAL EXPERIENCE

Confidential, Pleasanton, CA

Senior Systems Analyst

Responsibilities:

• Overseeing a team of business analysts to define requirements of the Quote Management System (QMS) - BOR (Broker of record), PCC (Preliminary Coverage Check) and Underwriting
• Creation of Reports using Data Visualization (Tableau)
• Leading initiatives to improve, migrate and implement processes in the current quote management system (SQE) to enable development of a robust and efficient application
• Managing a team to re-engineer the payment process to accept online payments reducing time to quote by 25%
• Handling cross-technical teams to manage system dependencies across applications for seamless integration
• Interacting with multiple business units to access technical feasibilities of requested changes in the overall system architecture
• Creating Process Flow diagrams, Sequence Diagrams, Activity diagrams and Wireframes using MS Visio
• Designing reports for senior management to provide at-a-glance summary of project status and risk
• Responsible for creation of Milestones Plan, Business Requirement Document, Mockups, Process Flow Diagrams, Change Requests, Enhancement Masters, et al.
• Handling presentations to business regarding proposed new features/functionalities/enhancements or change requests.
• Presented detailed project summaries to upper management and conducted implementation analysis to determine areas of program improvement.
• Responsible for managing end-to-end Infrastructure deliverables, to tight program deadlines, for large Strategic program with primary aim of increasing turnover for higher stakeholder returns.
• Monitored quality of the services and taken timely action to increase it by measuring the SLA and KPI results based on customers’ feedback.
• Ensured compliance with governmental and regulatory compliance with regard to managing clients physical and digital records
• Ensures all aspects of record keeping adhere to relevant corporate policy and client policy.
• Created UML based diagrams using Rational Rose and MS-Visio for Use Cases and Activity Diagrams, for better understanding of the layout of the new process
• Initiated JAD sessions for the design and documentation of the system design document (SRS) and made sure that all the requirements were implemented into functionality or a feature within the system by means of traceability matrix (RTM)
• Created wire frames and prototypes for screens.
• Conducted conference test-drives to gain user’s acceptance of the proposed solution.
• Created WBS, negotiated Triple Constraints (Tradeoffs), wrote RFP and evaluated proposals.

Confidential, Santa Clara, CA

Business Analyst & Developer

Responsibilities:

• Identified and analyzed current retail procedures for order management and replenishment.
• Gathered requirements by creating Prototype design and getting approvals in an iterative fashion.
• Performed usability analysis and testing including user interface design throughout the life cycle
• Wrote Use cases to effectively meet the usability standards and also tested the system on the same lines
• Compiled Business Requirements Document (BRD) and Functional Requirement Specification (FRS) documents.
• Created and managed rich web content
• Tested (UAT) the final application for Usability testing to verify whether all the User Requirements were catered to by the application.
• Used HP Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during System, Integration and UAT testing process.
• Articulated the business usability as per the business needs and made sure that all the functional and business requirements were met.
• Utilized Agile SCRUM methodology to develop User Stories, Product Backlog, and Sprint Backlog.
• Developed reporting specifications by identifying business needs, prototyping sample reports and mapping data elements from reports to data models.
• Involved in the story boarding discussions of portal design and usability.
• Created Mock-up’s for better visualization and understanding of the software solution.
• Developed estimates, project plans (Microsoft project), training material.
• Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams.
• Managed workload, schedules and coordinated status review meetings with project managers, business owners and team leads.

Confidential, Omaha, NE

Lead Business Analyst

Responsibilities:

• Responsibilities include analysis, documentation, development, support, testing and deployment of IT solutions across the entire breadth of the division
• Interviewed Subject Matter Experts (SMEs) and developed detailed step by step use cases for functionality and process flow.
• Identify source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
• Worked and coordinated with distributed team in onsite- offshore model
• Used SQL for data integrity testing, captured the SQL statements from the application execution and manually checked the result.
• Involved in meeting with users and gathered requirements to build new applications.
• Led Requirement Gathering Sessions (RGS), Joint Application Development (JAD) sessions.
• Created the logical and physical data models using Erwin data modeling tool.
• Lead the effort to get Business and System requirements base lined for further approval.
• Interviewed the Key Stake Holders, SMEs, and Decision makers to have a successful collection of requirements from all domains.
• Documented Business Requirement Documents (BRD) and Requirement Specification Document (RSD).
• Analyzed business requirements and segregated them into high level and low level Use Cases, Activity and State diagrams using MS Visio, suggested and managed improvements in the process.
• Prepared Screen Mock ups, User Interface designs using wireframes.
• Planned the outline of software development and held meetings with the developers, QA Leads and forwarded information and documents to all involved teams
• Conducted User Acceptance Testing (UAT) for applications with the help of end users and focus groups.
• Lead the planning, analysis, design, implementation, maintenance, and control of the organization’s server-class databases.
• Analyzed and documented project performance metrics, entity relationship diagrams, requirements traceability, and project dependencies for thorough scheduling activities
• Analyzed and consolidated the information needs of the team; supervised data mining, and developed manuals.
• Developed weekly project status reports and all other project management documents to keep the team apprised of goals, conflicts and status