SUMMARY

• Business Analyst with 7+ years of IT experience in identifying business needs and determining solutions to business problems for complex software projects.
• In depth knowledge and practical experience of using SDLC methodologies like Waterfall, Agile - Scrum.
• Experienced in using techniques for requirement elicitation such as Brainstorming, JAD sessions, Observations, Job shadowing, One on One interviews, Prototyping and Requirements/Document analysis.
• Well versed in project management tools like MS-Project, Team Foundation Server and Liquid Planner for status reporting, scheduling and planning.
• Proficient in creating BRD (Business requirement Document), FRD (Functional Requirement Document), UAT Documents and Use Case Narrative.
• Knowledge and experience in performing Cost-Benefit Analysis, Feasibility Study, Root Cause Analysis and Impact Analysis for planning and execution of business decisions.
• Expertise in creating mockups using Balsamiq.
• Created and maintained Requirements Traceability Matrix (RTM).
• Ability to plan and coordinate all testing phases including developing test plans, conducting User Acceptance Testing (UAT), creating & executing Test Scripts/Test Cases. Also, highly involved in Regression, System Testing and Integration Testing.
• Good knowledge in Data warehousing and RDBMS concepts.
• Well equipped with excellent communication and organizational skills.
• Highly motivated team player possessing strong analytical, inter-personal and decision-making skills.

TECHNICAL SKILLS:

Business Modeling Tools: BPMN, UML, MS Visio

ETL Tools: Informatica 9.5, Jupiter

Utilities: MS Office, MS Visio

Methodologies: SDLC, Agile-SCRUM, Waterfall

Database & Tools: Teradata, Oracle 11g, Confidential RDS, Microsoft Access, Microsoft SQL Server 2010

Testing Tools: LTT- Live Testing, Quality Center, HP ALM

Defect Tracking Tools: Bugzilla 4.0, JIRA 7.1, TFS

Reporting Tools: Tableau, MS Excel, MS Visual Studio

Other: SAS Miner 13.2, AWS, CSC

PROFESSIONAL EXPERIENCE

Sr. Business Analyst

Confidential, O’Fallon

Responsibilities:

• Provided business analysis and technical expertise in projects to migrate database applications from one technology to another.
• Developed web-based Intranet applications for the automation of various banking processes, including critical business applications for retail bank incentive tracking, referral management, time and attendance, personnel requisition, loan processing, and many other bank processes.
• Perform thorough analysis and gather information from thebusinessfor redesign and document existingbusinessprocess using UML diagrams in MS Visio.
• Served as technical Business Lead for a group of Lotus Domino developers. This involved meeting with application owners, identifying requirements and workflow, assisting developers in development strategy, and following up with owners for training and testing.
• Responsible for security, administration, requirements/documentation, and support for over 50 applications.
• Work closely with MDM Informatica Architects to fully understand and "read" ETL processes and process flows for business requirements, understand the business rules that are coded within the ETL load processes.
• Created the Data Mapping Document, for defining data flow between data source and target, along with business rules
• Wrote complex SQL statements providing back-end solutions to production issues, monitoring, and reporting.
• Developed data migration strategies and impact analysis for both Teradata and Oracle database systems.
• Created views in Tableau Desktop (Tree maps, Heat Maps, Scatter plot). And, created context filters, quick filters, table calculations, calculated measures and parameters.
• Mastered the ability to design and deploy rich graphic visualizations with Drill Down and Drop-down menu option and parameterized using Tableau.
• Involved in data profiling and data cleansing to eliminate data redundancy and enhance performance of the database.
• Assisted with integration and acceptance testing, tracking defects(JIRA) and monitoring their resolution.
• Created Requirements Traceability Matrix (RTM) to track requirements and testing activities, as well as maintained forward and backward traceability throughout the testing and development lifecycle.

Business Analyst

Confidential, St. Louis.

Responsibilities:

• Gathered business requirements, performed data analysis, documented functional specifications, reverse-engineered existing data processes and established / enhanced data process workflows.
• Implemented and managed migration process & development fixes; retested fixes; scheduled and tracked progress for all team members of project through completion.
• Conducted JAD session with Business, technology and QA partners to baseline project requirements, priorities and assess optimal solution options.
• Managed the development of the High and Low-level design documentation by offshore development teams.
• Worked with the business users in documenting the current process flows “AS IS” process models using BPMN 2.0 standards and created “To Be” process flows and identified the GAPS by performing the Gap Analysis between the current and the future states.
• Worked with the QA team closely to review the test cases, maintained traceability and participated in defect resolution.
• Involved in implementation of HIPAA EDI Transactions (835,837).
• Recommend changes for system design, methods, procedures, policies and workflows affecting Medicare/Medicaid claims processing in compliance with government compliant processes like HIPAA/ EDI formats.
• Used TFS for tracking requirements issues tracking and bug fixing.
• Created and generated reports thru MS Excel, MS Access and Microsoft Visual Studio using business objects interface.
• Used Teradata SQL Assistant for writing SQL queries to access data.

Business Analyst- TRMS

Confidential

Responsibilities:

• Coordinate JAD sessions with management, SME's, vendors and other stakeholders and actively participate in reviewing and documenting business processes and to produce high-quality deliverables.
• Created AS-IS and TO-BE business process flow diagrams, integrate them to show end-to-end business model.
• Analyze, interpret and document elicited requirements clearly, and get signoff from all the stakeholders before the user stories move into iteration.
• Organize and facilitate SCRUM ceremonies: daily standups, Sprint Planning/Grooming, Sprint Reviews/Demos and Retrospectives.
• Provided insight through analysis of revenue, sales conversion and yielded data to drive greater efficiency and effectiveness of our sales operations.
• Running adhoc reports and SQLs for data imports from different departments to BI platform for data analysis.
• Performingstatisticalanalysis, modeling, and other quantitative techniques to address business questions, assess business issues and/or recommend courses of action to meet business objectives.
• Ensured that data mapping was done correctly for reliability of the forecasts projected.
• Created dashboards for a managerial overview with drill up and drill down capabilities using Tableau.
• Performed rigorous testing with QA team to prevent potential production issues and ensuring that the application is functioning as per the business requirements.
• Worked on various salesforce.com standard objects like Accounts, High Risk Cases, Opportunities, Products, Risk Line Items, Leads and Campaigns.
• Extensively used Salesforce for creating BI reports and dashboards for management business insights and decision guidance.
• Worked on Bugzilla for issue tracking and work flow designing.
• Played a key role in the User Acceptance Testing (UAT), unit testing, implementation of system enhancements and conversions.

Risk Analyst

Confidential

Responsibilities:

• Responsible for a wide range of tasks related to the investigation and elimination of online e-commerce fraud.
• Risk and Fraud Management using quality and statistical tools with objective of minimizing risk on our various platforms across globe.
• Identified bankable business opportunities, generated analyses and insights to assist manager with decision-making through SQL and Excel.
• Led a 10-member team totaled 8000 fraud investigations per day on customer’s orders worth of $1.5 to $2.2 million.
• Managed the planning and execution of work flow scheduling for 10 members across different shifts and achieved 98% service level agreement maintenance against the goal of 92%.
• Performed data analysis and discovered a new fraud pattern called "BUYER-SELLER COLLISION".
• Identify fraud patterns and modus operandi that would have a direct impact on the bottom line bad debt rate for Confidential .com
• Worked with leadership team for creating SOP (Standard Operating Procedure). Improved standards by reaching out to workforce to gather perspective on grey areas of fraud detection to help handle the quotient of integrity of products delivered to customers.
• Create and maintain Operational KPI Dashboards/Scorecards and manage performance of these metrics by conducting discussions and analyzing data.
• Explore new product opportunities throughmarketresearch and analysis of product to sales ratio’s across- Kindle, Digital, and SS portals.