PROFESSIONAL SUMMARY

• Certified Scrum Master with over 10+ years experienced Business Analyst with expertise in areas related to Healthcare andeCommerce (B2B and B2C), Hybris, Magento, OpenCart, Online Retail, Web Technologies (SOA, Paas, Mobile, SaaS), Content Management Systems, and Risk Management. Delivered successful projects in multi - site locations using Agile, Scrum and Waterfall methodologies.
• Proficient in creatingBusinessRequirement Documents (BRD), Software Requirement Specifications Document (SRS) and UML Diagrams using various tools including MS Visio, and Rational Rose
• Attending Hybris meetings and training to understand the E Commerce management.
• Exceptional Documentation Skills in writing use cases as well as in creating Use Case diagrams, Activity diagrams, State diagrams based on UML Methodology and business process flow diagrams using MS Visio and Enterprise Architect.
• Proficient in design and development of various reports and Dashboard utilizing Tableau Visualizations tools like bar graphs, scatter plots, pie-charts, heat maps, Custom color palettes, geographic visualization and other making use of actions, other local and global filters to identify critical KPI’s and to requirements of the end user.
• Experience in improving reporting performance significantly in tableau using extracts and context filters.
• Experience with Health Insurance Portability and Accountability Act (HIPAA), Medicare
• Experienced in Property & Casualty (P&C) within Personal / Consumer lines.
• Extensive Knowledge of Software Development Life Cycle (SDLC) including requirements gathering, analysis, design, implementation, testing and deployment.
• Expertise with Business Process Modeling Notation (BPMN) specifications and Swim Lane diagrams to better understand business processes.
• Expert in Effort Estimation, Project Planning, Reporting, Business Intelligence and Defect Management in capacity of Business Analyst lead.
• Experience in Conducting Gap Analysis, created Use Cases, work flows, screen shots and PowerPoint presentations for the Web Applications.
• Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables.
• Experience in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling.
• Proficient in preparing Test Plans, designing Test Scenarios and formulating Testing Strategies.
• Excellent team player with ability to think analytically and troubleshoot issues.
• Excellent working knowledge of key business process, with 3 to 4 years practical eCommerce and data management experience

TECHNICAL SKILLS

Technologies: eCommerce, Data warehousing, Enterprise Resource Planning (ERP), Relational Database Management Systems (RDBMS), BI, Microstrategy, Supply chain Management

Business Intelligence: SAGE BI, Tableau v9+

Databases: MS-SQL Server 2005/2003,Tera data, DB2 UDB and MS Access 2000/2003/2007

Insurance KPI Exposure: Net Premium Written (NPW), GAAP P&L, GOE (Gross Operating Expenses) Net Loss Incurred (NLI), Loss Ratio (LR), Expense Ratio, Combined Ratio, Solvency Ratio, RAP (Risk Adjusted Profitability), PTOI (Pre-Tax Operating Income)

Operating Systems: Unix, Windows Server, Windows NT/2000/XP, IBM-AIX, Solaris, Linux

PROFESSIONAL EXPERIENCE

Confidential, Dallas TX

Sr. Business Analyst

Responsibilities:

• Requirements elicitation with Business Partners, Business Architects and End Users, in order to document Functional/ Non-Functional Requirements.
• Used Agilefor software development.15 Sprints (3 weeksprint). CreatedBusiness Rules and capturedBusiness Data Elements in alignment to Functional requirements.
• Facilitatedworking/ discussion/ review sessions with Product Owner, Business Partners, Subject Matter Experts (SME), Test & Design teams in order to create User Stories and Acceptance Criteria.
• Engage in Daily Scrum meetings with SME's, Design/ Test teams.
• Convert and clean the hard scripts into readable tables for creating Executive Level Dashboards using Tableau.
• Develop, load scripts for extracting, transforming and loading data into Tableau.
• Automated all the manual reports using Tableau refresh methods for all dashboards.
• Developing crosstabs, heatmaps, scatterplots. Spatial graphs, pie charts and density charts using high volumes of financial data.
• Dynamically using reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters.
• Utilize integration options using Tableau Desktop, Tableau Server and Tableau Reader to minimize overall end user licensing requirements.
• Prepare various Use Cases for different processes including Use Case Diagrams for individual processes as well as over-all Process Flow/ Business Flow diagrams.
• Designing dashboards with the use of visualization tool -Tableau.
• Was involved in managing the Daily Standup meetings and also ensured that quality standards were enforced as per the build-release schedule.
• Act as a project driver from technical perspective for each project and help the project design data extraction and load process.
• Responsible for using SQL for managing large volume of data. Communicating with customers to analyze historical data and identify KPIs.
• Attend Client calls for Business Review Document validation, review and gather client requirements
• Extract raw data from various databases in SAS to perform various analysis
• Use various data cleansing techniques to ensure data accuracy, validity and completeness.
• Work closely with business units to provide business solutions and to develop ad hoc reports
• Enhance the existing business reports by incorporating new business requirements
• Improving data processing speed by building SQL automations, tweaking SQL Queries for best performance.
• Analyzing the data so as to identify trends and share insights.
• Implementing Tableau mobile dashboards with the help of Tableau mobile application.
• Creating Thematic Heat maps with the help of MapInfo.
• Recognizing areas for automation and Restricting data for particular users with the help of User filters.
• Develop, modify and generate Monthly Operating Report for management review summarizing business activity
• Worked on Commercial lines Property and Casualty Insurance including policy and claim processing.
• Capture Business Volume Metrics(BVM) data including User groups, Business Drivers, Business Activities, and Use Cases & Deployment Data into the BVM Repository.
• Facilitate meetings with Performance Test engineer to enable them to utilize data captured as part of Business Volume Metrics for Various scenarios while executing system performance testing.
• Managed an offshore team consisting of 6 resources with following activities:
• Review Wireframes,Content Component Library (CCL) and User Interface Specifications (UI Specs) to sync all these Documents with Functional Requirement Documents and maintain consistency in the documents.

Environment: MS Suite, Tableau, PL/SQL, MS Visio, Tableau Desktop (9.0, 9.1, 10.0, 10.2, 10.3, 10.4,10.5), Tableau Server, Oracle SQL Server R2, Micro Focus Rumba 8.0, IBM Notes, Snagit 10, BVM Repository, MS LYNC.

Confidential, Detroit, MI

Sr. Business Analyst

Responsibilities:

• Served as an expert in the functional use of hybris, its various cockpits and the B2B and B2C accelerators.
• Involved in enhancement of STP systems for product and regulatory requirements. Using BRDs, prepared Functional Specification Documents (FSD) and prepared Standard Operating Procedures (SOP) docs for Ops Training.
• Wrote BRD, FSD for use cases, and test scenarios, test cases for testing the functional requirement.
• Experienced using hybris Administrative Console (hAC) for initialization and updating system.
• Worked with PC Hybris Implementation eCommerce project; involved in building B2B eCommerce portal to replace a battery of business specific legacy eCommerce tools.
• Acted as a liaison between the business, technical and creative teams by collecting initial design and UX requirements; providing creative team with example promotions, product info and images; facilitating internal, technical and client design reviews; and ensuring that delivered application remains true to the creative design.
• Conducted workshops that helped stakeholders understand the functionality of Hybris and how it can be adopted to meet business objectives.
• Conducted requirements gathering sessions through formal and informal meetings and workshops. Conduct one-on-one or small group interview sessions to gather functional requirements in order to develop requirement documentation.
• Leveraged Product content management, WCMS, HMC and Customer service cockpit for creating new products, new web templates, new customer creation, order cancellation, order approval/rejection and order fulfillment
• Worked on Customer Cockpit, Channel (WCMS Cockpit) Content (Product Cockpit (PCM)), Platform (Administration Cockpit, Report Cockpit, Hybris Management Console), Commerce ( Marketing tool, Jirafe Cockpit ( Reporting))
• Captured and documented requirements for website, ecommerce and integration specifics, information architecture and assisting in the delivery of the solution to meet client’s business requirements and producing functional specification
• Developed user requirements, functional specifications, technical specifications, data models, and process flow diagrams to communicate engagement scope to client and delivery team members.
• Create functional requirements in use cases. Coordinate requirements walk-through and sign-offs, verifying with user representatives/stakeholders that use cases and process models accurately portray specific business needs
• Developed UI wireframes
• Delivered a reference data (RDM) solution to consolidate all apply channel data - implemented as part of the new country code gathering process.
• Understand Hybris data structures, collect product catalog data from client business users, manipulate data for import into Hybris and identify data gaps, and perform product data imports into Hybris ( hMC, hAC, CMS)
• Requirements traceability to manage scope creep
• Provide Hybris demonstrations and training to client business users.
• Support the RFI and RFP process and take responsibility for it at pre-sales stage

Environment: Hybris 5.2, SOLR Oracle, Selenium RC/IDE, Selenium WebDriver, Java, iRise, Swift, iOS, Junit, Eclipse, JRules, Quality Center, Clearcase, TestNG, Microstrategy, Apache, Maven, PL/SQL, UNIX, HTML, CSS Oracle, Windows, IOS APP, eCommerce,WIFI,ANDROID,SOAP, TIBCO.

Confidential, Dallas TX

Financial/Business Analyst

Responsibilities:

• Facilitated and managed meeting sessions with committee of SME’s from various business areas such as Accounts and credit cards and created a Business Requirement Document. Did post analysis of the business requirements of online banking service applications by analyzing the Risks associated and strategies used to assess and mitigate them.
• Create views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions
• Create and designed multiple dashboards as per the customer requirements
• Designed and developed Narrative Use Cases, Use Case Diagrams, Class Diagrams and Sequence Diagrams using MS Visio to define the Business Process.
• Facilitated JRP sessions between technical and regulatory teams for meeting requirements as well as solving problems on a daily basis such as, but not limited to classifying and documenting new change requirements during change management, dealing with multiple product teams, tracking delays and documenting errors.
• Pulled data from different databases and migrated data back and forth using SQL.
• Helped the team with Installation, configuration and upgrading of Tableau tool across the environments.
• Develops and provides documentation, training, and support for business users.
• Maintain standards and best practices for consistent and accurate use of Tableau across the company.
• Responsible for Tableau administration, including user provisioning, server management, license administration, and version upgrades.
• Tableau server and data source administration, including upgrades, monitoring, troubleshooting, performance tuning, user management and change management
• Create and manage Tableau sites, projects and workbooks, groups, data views, data sources and data connections
• Establish Tableau security, back-up and restore process
• Interacted with end-users in gathering feedback and implemented new features and enhancements.
• Conducted walkthroughs for High Level requirements and to discuss certain issues with Business team, Architecture team and the Development team.
• Involved with the QA team to conceptualize, determine and develop test approaches and methods for unit testing, integration and functional testing, load and usability testing according to the application complexity and test requirements.

Environment: Tableau Desktop (9.0, 9.1, 10.0, 10.2), Tableau Server, Oracle SQL Server R2, Windows XP/2000, Oracle, SQL, PL/SQL, MS-Project, MS-Office Suite, MS Visio, JSP, WinRunner, Mercury Test Director.

Confidential, Lagos, NI

Business Analyst

Responsibilities:

• Involved in gathering the requirements that were critical to the business process flow and using those requirements for the Business Requirements Document (BRD)
• Conducted JAD sessions with Subject Matter Experts (SME’s) to obtain domain level information, interviewing and asking detailed questions and carefully recording the requirements in a format that can be reviewed an understood by both business and technical team.
• Maintained a daily meeting with the Business team on task order approval, increased and decrease frequency of the meetings as per the progress of the task.
• In depth knowledge of Medicare Claims processes.
• Followed a structured approach to organize requirements into logical groupings of essential business processes, business rules, and information needs, and insures that critical requirements are not missed.
• Involved in GAP analysis both at the time of requirement gathering and later after development with the Testing team to identify areas and possible scenarios that might have been overlooked.
• Facilitated collection of functional requirements from system users and preparation of functional specification documents that provided appropriate scope of work for technical team to develop prototype and overall system.

Environment: MS Office, Visio, SharePoint, UNIX, SQL, Toad, DB2, CMR, Citrix, Rational Suite, Windows 2000/XP

Confidential, Lagos, Nigeria

Business System Analyst

Responsibilities:

• Gathered/Analyzed user requirements, procedures, and problems to improve the User Interface and provisioning interface for Customer Trails and Demos
• Conducted and analyzed technology processes by requirement performance modeling UML and prepared essential groundwork.
• Evaluated business requirements for Enterprise business applications integration and service activation
• Heavily involved in System Data flow identifications to help Global Services achieve the change management milestones with Bay Networks
• A major part of the responsibility included interacting with the Users and Business relationship managers and facilitating implementation of changes using ERD diagrams created MS Visio on the database in order to ensure approval from process owners.
• Participated in the project requirements and definition of system and processes for the merger issues related to Nortel and Bay Networks.
• Identify customer requirements, develop test schedules, review testing plans and tracks, and document the development and results of these plans.
• Carried out a thorough analysis of the existing system before gathering the business requirements through interviews, surveys and researching the prototypes available.
• Alert project managers to potential risks and issues of importance.
• Involved in design of data migration plans across multi-site and multi-platform. Created test Summaries and test variations based on functional requirements
• Manually executed the test variations for positive and negative scenarios.
• Created UML Diagrams like Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio.
• As a team member took active participation in all training sessions conducted by the Subject matters experts and the technical team members.
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Reviewed status with the Project Manager and the involved System Analysis teams on a weekly basis

Environment: Microstrategy, MS-Office 2000, MS Project 2000, MS Access, Remedy