SUMMARY

• Having 7+ years of experience in the field of Information Technology as a Business Analyst.
• Extensive experience in eliciting, analyzing, managing and documenting business, functional and non - functional requirements, communicating effectively with upper management, developers and QA engineers.
• Business Analysis experience includes conducting JAD sessions, requirements gathering, documentation (Project Charter, BRD, and FSD), diagramming data (ERD & DFD) and process mapping, compiling detailed project plans, and developing test plans and test case scenarios.
• In depth knowledge of RUP, Agile, SCRUM, waterfall Software Development Life Cycle (SDLC) processes and possess thorough understanding of various phases likeRequirements, Analysis/Design, Development and Testing.
• Having expertise in creating/upgrading thePOSsystems for retail market.
• Expertise in web service and internet technologies including WS/XML: XML,XSD, XSLT, XPath, SOAP, WSDL -WS-I Standards
• Extensive experience working with vendor e-commerce tools likeMicrosoftcommerce as well as helping construct and integrate in-house ecommerce applicationss
• Experienced in Dodd Frank implementation and with AML systems such as Actimize,Mantas, and SAS
• Experience in analyzing data using Pig Latin,HQL, HBase and custom Map Reduce programs in Java.
• Experienced in Analysis, Design, Development and Testing of the SFDCapplication according to the Business requirement.
• Have working knowledge on enterprise tools such as SAP,SFDC(SalesForce.com), Oracle ERP,TAP (Transaction Automation Platform)
• Experience in Migration of Data from Excel, Flat file, Oracle toMSSQLServer by usingMSSQLServer DTS and SSIS.
• Have Knowledge inBizTalkServer (Able to create Schemas, Maps, Orchestration with Pipeline)
• Experienced in leading social media research assignments for FMCG andpharmaclients
• Defined Standard Operating Procedures (SOP) forwarehouselogistics, providedWMSapplication support to end users, testingmanagement, and trained staff on new processes.
• Strong experience with health insurance administration systems includingActuarial, policy application, eligibility, enrollment, underwriting, claims, billing, and payments.
• Experience in analyse the data using advance excel tool likepivotdash boards lookups
• Excellent knowledge of lean manufacturing, Six-Sigma,SPCanalysis, Continuous improvement, process modeling, VSM, Auditing.
• Well versed with IBM Rational Requisite Pro for requirements management
• Skilled at performing Gap analysis, Risk analysis, along with good knowledge of process workflow tools and techniques
• Expertise in underlying MisysLoanIQdata model and components
• Effectively delivered functional requirements likeGUI, screen and interface designs.
• In depth knowledge of UMLin visualizing and documenting the artifacts using Use Case diagrams, Class diagrams, Sequence diagrams and Activity diagrams
• Experience using iRise for creating basic User interfaces with fields, menus and buttons to prototype data capturing abilities.
• Collaborated withBusiness& IT stakeholders such as Product Owners, Underwriting Managements, Consumer and Agency Services,ActuarialServices, Report Developers & IT Quality Assurance to continuously deliver projects on time and on budget.
• Familiar with MS Project to manage schedules, deadlines, resources, collaborate with different teams, and analyze project information.
• Knowledge of SQL querying to ensure accuracy of data storage and data flow in the backend systems.
• Maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files and loaded into Oracle.
• Defined the test criteria, project schedules and base lined the Test Plan with the help of project meetings and walkthroughs.
• Familiar with HP Quality Center to design and develop test plans and test scripts
• Familiar with White-Box and Black Box testing techniques such as Load Testing, Regression Testing, Unit Testing, Functional Testing, Integration, System Testing and Performance Testing.
• Experience in conducting User Acceptance Testing (UAT).

TECHNICAL SKILLS

Modeling Tools: UML Modeling using Rational Rose, MS Visio, MS Project,IBM Rational Requisite Pro, IBM Rational Clear Quest, IBM Rational DOORS.

SDLC Methodologies: Waterfall, Agile-Scrum, Waterfall-Scrum, Waterfall-RUP, CMSforms

Requirement Management: MS Office, Advanced Excel, HP ALM V 11.5, TOAD

Project Management Tools: MS Project, Microsoft SharePoint Server, JIRA

Testing Tools: HP QC v10.0, HP ALM V11.5, Load Runner

ETL Tools: Informatica 9x

Reporting tools: Tableau Desktop, Cognos, MS Word

Languages: HTML, XML, XSD, SQL, MSSQL, VB, C,Apex, Javascript

PROFESSIONAL EXPERIENCE

Confidential, Pennington, NJ

Sr. Business Systems Analyst

Responsibilities:

• Used MS Project to maintain the project schedule and track its status.
• Implemented newWMSfunctions and designed new screens, which improved data exchange across clients, and reduced Help Desk tickets by 60% within 1 year.
• Created and developed Business Requirements Document (BRD) and Functional Specifications Document (FSD) using IBM Rational Requisite Pro.
• Designing DDL, an independent service to collate data from various source systems like Siebel CRM, AMDOCS and huge Call Detail Record Files.
• Participates with the Operations Manger to create a reporting platform for a worldwidepharmaleader. Duties include requirements gathering (bothbusinessand technical), liaison to IT developers, report creation and design, project management, QA and technological innovation.
• To Develop automation scripts for regression testing ofWMSapplication using Client's standard framework.
• The application Authorizes transactions from multiple endpoints like tellers, ATMs, point of sale (POS),
• TransformedTableauinto a managed service offering for consumption across Corporate Treasury and Corporate Investments.
• Explore, Analysis, Development, Testing and support activities ofWMSapplication in running state scrum team every sprint.
• Proficiency in programming languages and database such a Java, Java script, HTML,J2EE.
• Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets usingTableau.
• Responsible for Supply chainManhattanLogistics application testing.
• Responsible for fleet maintenance on all equipment assets, inventory tracking,warehouse management.
• Determining and conductingRPAenablers during pre-automation stage.
• Enhanced effectiveness of daily operations by providingWMSsupport.
• Createbusinessrequirements documents that developers can use in the creation of anAEM website.
• Working on visually appealing Dashboard using Data Blending, Joins,Pivot& Trend Lines
• Executed and prepared weekly and monthly reports for trend analysis (Pareto Chart,PivotTable, Pie Chart, Bar Graph, Sparkline etc.) in Excel.
• Responsible in conducting DRB calls withManhattanteam to analyse the defects raised during testing phase
• Used APTTUS for quoting oncloudplatform
• Have been exposed toRPAin Automation anywhere enterprise client tool.
• Worked as a team lead/businessanalystfor the project from theSFDCteam
• Worked asBusinessAnalystP& C AutoActuarialWorkbench, Rating system (personal lines, commercial)
• Creating and maintaining project migration schedule with project documentation requirements
• Performed Data Analysis using procedures and functions in PL/SQL
• Worked on Load Dash-Board analysis automation that has impacted in leveraging Excel withVBA
• Requirement gathering and analyzing differentbusinesssystems like Permac,SAP, Oracle, and Navision
• Created Use Case diagrams, Class diagrams, Sequence diagrams and Activity diagrams using UML in MS Visio.
• Individually handled the migration for many Departments including Housing, DAS,ODOT, OHIX
• Conducted Joint Application Design (JAD) sessions for communicating with all project sponsors and stakeholders.
• Prepared weekly Review and Status Reports, which included Test Case Standings, Metrics, QA Issues and Defects.
• CreatedSQLtables with referential integrity, constraints and developed queries usingSQL,SQL*PLUS and PL/SQL.
• Execute test scripts usingLoanIQfront end and examine test results, compare to expected results.
• Aggregating and organizing information from multiple data sources (SAP,SFDC, OM, ERP-AP,PDB) to aid in analysis
• Expertise inLoanIQtable maintenance
• Building new reports or integration projects betweenLoanIQand other systems.
• Updating the "Loss Cost" tables for analyzing the risks (specifically anActuarialfunction)
• Proficient with Excel VB, writing Macros and data analysis usingPivotTab
• Understanding of the Sidekick, to build pages, and templates./AEMmobile
• Extensive experience with using SQL to perform data extraction, migration and integration
• Experienced in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous Systems using DTS and SSIS ofMSSQLServer
• Wrote Use Case descriptions including pre-conditions, assumptions, normal flows, alternative flows, post-conditions, notes and issues.
• Creating Orchestrations, Schemas, Maps, Pipelines inBizTalkServer 2006.
• Followed the UML based methods usingMicrosoftVisio to create: Use Cases Diagrams, Activity Diagrams, State Chart Diagrams, Sequence Diagrams and Collaboration Diagrams.
• CLOSR interacts with different systems like Expere for document generation, PCI for High Cost test, RealEC for appraisal, Zippy for underwriting, Filenet to store documents, Payment Tech for collection of fee and payments andEMITSfor storing HMDA information
• Develop annualGISbudget according to implementation strategy and company policies.
• SupportGISbusinesstesting and interface as per Quality Assurance procedures.
• Involve in the preparation and monitoring CompanyGISAction Plans, and update the status in the project server.
• Communicated the project status to clients bi-weekly, highlighted changes made in requirements and gathered new requirements.
• Maintained pharmacy inventory by checking pharmaceutical stock to determine inventory level anticipating needed medications and removing outdated drugs.
• Creating project artifacts for integrated releases including daily reports and defect reports. Tracking of project metrics and generation of Milestone reports andSPCreports
• Used SQL to retrieve and update requirements during project execution.
• Designed and developed test plans and test scripts using HP Quality Center.
• Conducted User Acceptance Testing (UAT) with users and project team members.
• Experienced with Agile methodology and all phases of software development life cycle (SDLC).
• Used Informatica PowerCenter9x for extraction, loading and transformation (ETL) of data in the data warehouse.
• Well versed with the Salesforce.comAPEXdata loader and Import Wizard
• Conducted business process modeling and analysis; identified assessed and articulated gaps /operational risks associated

Environment: Agile, IBM Rational Requisite Pro, Salesforce (SFDC), HP Quality Center, IBM Websphere, TableauDesktop 8.2 and 8.3, MSSQLServer 2010/2012, MicrosoftOffice Suite, LINUX, UNIX, DOS, BizTalkServer 2006, DB2, Apex, ManhattanWMS, MS Project, MS Visio, Windows XP, Informatica PowerCenter9x and Netezza.

Confidential, Temple, TX

Sr. Business Analyst

Responsibilities:

• Documented the existing business process and system support.
• Gathered requirements from manager of claims processing operations to prepare the reports required for performance analysis of claims verifier.
• Worked on the Point of Sales (POS) application in order to perform the fund management and inventory management for each and every store.
• Recorded retention stored in Knowledge Link. AdHocreporting, Admin for MS Project, Excel dbase and pivot tables, Clarity and MS Project Server Admin duties
• Worked in Cross Functional team environment, served as a liaison between SME's, ProjectManager, and stakeholders to ensure accuracy in the SFDCimplementation and other businessrequirement
• Lead extensive Brain storming sessions with SME’s, application development team, and other stakeholders to understand high-level business requirements and define functional requirements.
• Maintained adhocreport requests for the clients as per requirements
• Used IBM Datacap to convert paper claims to 837 EDI formats that acted as an input to FACETS claims processing module.
• Effectively used data blending, filters, actions and Hierarchies feature intableau.
• Worked with multiple pharmaceutical and FMCG giants to analyse their brands and analyse the categories they work in to better position and market their products
• Providing actionable insights for a wide variety ofpharmabrands - both OTC and Rx in various geographies
• Prepare CRD,BRD, RTM with the requirements given by the client.
• Identified and created all necessaryBusinessUse Cases from requirements, created UML Diagrams including Use Cases Diagrams, Activity Diagrams and Sequence Diagrams usingMicrosoftVisio.
• Collected, analyzed and presentedSPCdata for review
• Maintaining websites inAEMwith maintaining content, social media marketing and paid campaigns.
• DeterminedSPChardware and software requirements to optimize data collection and interpretation by both operators and engineers.
• ImplementedCMS(Content Management System) in automating various aspects of Web and Publication Content Creation, Document Management and Delivery.
• Integration Testing of Appian Application & Web application withCMS(Claims Management System).
• Collaborated with FACETS Application Implementation team to deliver the requirement phase of the software development lifecycle.
• Works on Oracle Right nowcloudservices and focusing on Oracle Servicecloud( Customer Portal) which includesbusinessBenefits, customer journey and its benefits.
• Worked asBusinessAnalystP& C AutoActuarialWorkbench, Rating system (personal lines, commercial)
• Provide material & assistance and training toGISusers.
• Advise measures to ensure integrity and consistency ofGISdata.
• Experienced with objects, Form Validation,Approval Process,Email Alert, Security and Sharing,ApexClasses using Custom Controllers, Triggers and Visual force pages
• Performed periodic Data analysis, and Gap analysisto understand the business requirements.
• Maintaining the full site inAEMfor changing content and getting the data from Analytics.
• Prepared detail business requirements to facilitate accuracy in data verification and to reduce the time for claims processing.
• Responsible for data conversion fromSQLServer to Oracle.
• Worked with technical leads to track down the system efficiency and better production support for Lines of Business query resolution.
• Developed Use-Cases, Use Case diagrams, and Activity Diagrams.
• Used HIPPA EDI 5010 format (837P, 837I, 837D) in claims processing which is setup to work in batch mode.
• Verified HIPAA-related EDI data in the repository using FACETS. Ensured that system generates error report of claims that did not pass validation.
• Resolved communication issues between the software development, business, and user interface development teams.
• Assisted in preparing test plans, test cases, and conducted user acceptance testing (UAT).
• Coordinated and prioritized outstanding defects and enhancement/system requests based on business requirements, allowing sufficient time frame to ensure accuracy and to meet deadlines.

Environment: UML, IBM Datacap, FACETS, Windows XP, Microsoft Office, Microsoft Visio, Scrum, MS SharePoint

Confidential, Urbana, IL

Sr. Business Analyst

Responsibilities:

• Used agile methodology for software development.
• Played an active and lead role in gathering, analyzing, and writing business requirements
• Participated in weekly meetings with the management team and walkthroughs.
• Prepared FSD based onBRDand gathered requirement
• Provided direction for testing Methodology for the data migrated to TRUST system from Legacy system
• Extensively used Oracle SoftwareMantasfor identifying and preventing any suspicious activities from multiple channels.
• Worked closely with Configuration and Theater teams to identify any risks and changes happening inSFDCand accordingly preparing a backup plan for the same
• Acted as a team with multiple pharmaceutical companies to verify stability of medications.
• Used DOORS for gathering Business Requirements, generated workflow process and necessary documents for the project by interacting with mortgage processing specialists, stakeholders, and valuable customers.
• Analyzed and documented the pros and cons of the project using SWOT analysis.
• Used Rational Rose to develop diagrams that include entity-relationships, use case diagrams, context diagrams, to provide the development team a view of the requirements for design phase.
• Prepared Business Requirement Document and then converted business requirements into Functional Specifications Document.
• WorkedMicrosoftDynamicsCRM which offers mobile CRM apps and platforms that allow organization to manage customer relationships on your mobile devices
• Analyze the requirement from CRD,BRDand FDD by interacting with the developers and client SME
• In the process of ETL tool used SQL queries to extract the data and have writtenVBAcode to run the macros which transform the data and used excel to load the data
• Responsible in teaching classes for Excel and Advanced Excel includingVBA
• Participated in various meetings and discussed Enhancement and Modification Request issues with analysts, clients and developers.
• Prepared monthly status reports for Enhancement Requests to the project team that was used in efficient tracking and monitoring of open issues of the project
• Discussed the Test Cases and Test Plans with Software Testers and automated testcases using Load Runner.
• Implemented Cost Benefit Analysis technique for deciding whether to make a change.

Environment: Agile, Rational Rose, Mantas, DOORS,UNIX,Windows2000,HPLoad Runner and Oracle 11i.

Confidential

Business Analyst

Responsibilities:

• Involved throughout theSystem Development Life Cycle (SDLC) - SCRUM including sprint planning meetings, review meetings and backlog refinement meetings.
• Prepared business requirements documents by conducting client group interviews, focused groups, workshops and online surveys
• Managed roles offshores and served as a liaison between development team and business team.
• Facilitated JAD sessions and conducted peer review meetings periodically to keep track of projects milestones on webex meetings and conference calls.
• Prepared and maintained the Requirement Traceability Matrix (RTM) to record the business and functional requirements.
• Hands-on experience in developing the web applications using Java, Struts Framework, Java script, CSS andHTML
• Expert in creating user stories from requirement gatherings while following various elicitation techniques
• Prepared detailed requirements as USER STORIES and USE CASES to provide details of each business and functional requirement, development and implementation plan of these requirements, timelines, owners, etc.
• Prepared use case diagrams and description documentation based on the analysis, and obtained approvals from the clients
• Prepared activity diagrams on MS Visio to better understand the flow of activities along with the timelines of each actor
• Prepared change request form to provide details of the changes requests, and obtained approvals from the appropriate stakeholders
• Worked on issue tracking and project planning withJIRA
• Performed SWOT and GAP Analysis to discover new functionality requirements, prioritized them on the basis of actual business needs
• Participated in various architectural development sessions to provide technical teams with a better understanding of the requirements
• Assisted architects in structuring and enterprising data models and system design
• Conducted workshops to understand requirements for Data Warehouse design. Conducted client side validation to study ETL (Extract Transform and Load) operations on database
• Assisted my Data modelers in analyzing the data from the two sources, data modelling and then generating scripts to create necessary tables and corresponding records
• Assisted QA team by reviewing test plan and test cases and clarifying requirements to ensure complete coverage of requirements
• Provided training to the users, and involved in facilitating UAT sessions to gain user confidence and approval
• CoordinatedUATandregression testingof the application services.

Environment: SCRUM Methodology, MS Office, MS Access, MS Visio, MS SQL Server,GAP Analysis, UML, Functional Testing, Regression Testing, JIRA, Informatica, MS Project