SUMMARY:

• About 7 years of experience as a Business Analyst in Banking, Healthcare, Insurance, Travel and Mortgage with strong understanding of Business Process Flows, Case Tools, and Business Analysis with strong knowledge in front - end architecture within Infrastructure and Application management to transform and accelerate business initiatives.
• Experience in P&C (property and casualty) insurance including Guidewire software applications.
• Experience in e-commerce environment overseeing the design, development, and implementation of software and hardware solutions and systems/products.
• Good experience as Business & Technical Analyst in the implementation and integration strategies utilizing quantitative & qualitative analytical skills. ETL/BI development experience using Data Stage, PL/SQL/Tableau.
• Good experience in QA methodology and validations to ensure industry standards.
• Strong experience in ETL methodology as used for testing and supporting data extraction and transformations.
• Strong experience in manual testing and basic automation (QTP, Selenium testing, SOAP UI, JIRA) tools.
• Experience working with PowerSchools TIENET (SESIS) application for managing the student records.
• Knowledgeable in multiple industries such as financial services, POS, Payment Service, insurance, global asset management, financial trust, asset tracking, business-to-business transactions (B2B), healthcare, order management, online sales and customer services.
• Working experience in BI tools like Tableau.
• Responsibilities included project assessment, planning, sizing, timeline and issue management, analysis and creation of business process flows, test case creation, execution and creation of functional & system requirements, analysis and validation.
• Experience with EDI solutions and Practice Management systems like commonly used EDI concepts, best practices, and procedures within the health care industry
• Strong knowledge in Content Management System (CMS) and Adobe Experience Manager (AEM).
• Possess excellent communication and interpersonal skills to co-ordinate with clients and offshore teams.
• Well-rounded background in working with Agile/Scrum and Waterfall software development methodologies.
• Comprehensive knowledge and experience in Software Development Life Cycle (SDLC) with business process models: Waterfall, Scrum methodologies.
• Experience working in a Scaled Agile Framework (SAFe) environment.
• Experience in managing app development projects using Jira and other tracking tools.
• Strong knowledge in Automated Clearing House (ACH), Bank Clearing System, Electronic Funds Transfer (EFT). General understanding of Accounting process including general ledger and account reconciliation.
• Extensive experience in conducting JAD sessions - participated in varied roles ranging from facilitator, preparing visual aids, setting goals and objectives, providing read-ahead materials to participants, etc.
• Proficient in the implementation of production change management techniques and service delivery disciplines
• Written Use cases and have produced Use Case Models, creating Behavioral diagrams (use case diagram, Activity diagrams and Sequence diagrams) based on UML Methodology & Business process flow diagrams.
• Extensive experience in documentation of business requirements and system functional specifications, including BRD, FRD, RFP and FSD
• Utilized a combination of business knowledge, technical skills, and strategic analysis to provide solutions and creative insights to critical business problems.
• Experienced in creating Work Breakdown Structures (WBS), Project Schedules and Project Timelines.
• Experience in Data Mapping, Data Warehousing, Data Cleansing & Data Migration Effective in multitasking and effective management of assignments according to work schedules with strong project management orientation.
• Capable of forming and maintaining positive and productive working relationships in internal, external, independent and team environment.

TECHNICAL SKILLS:

Operating Systems: Programming Languages

Web Services: Windows 2003/XP/Vista/7, AIX 5.3/4.3, Sun Solaris 8/2.x, C, C++, Java, SOAP, REST

Project Mgt Tools: MS Visio, Rational Clear Quest, MS Project

Marketing/BPM/CMS/ETL/BI: DataStage, Oracle Warehouse Builder, SQL*Loader, Business Objects, MicroStrategy, SSRS, Salesforce, IBM BPM, RPA (UI Path), SharePoint

Bug Tracking/Testing: Quality Center, JIRA, MS Visual Studio, Rational Quality Manager, QTP, HP ALM, HPQC

Business Modeling: MS Visio, IBM FileNet, Rational Requisite Pro, Concept Draw Pro

Project Methodologies: Software Development Life Cycle (SDLC), Agile (Scrum, XP, SAFe), Waterfall

Databases/Web server: Oracle 10g/9i, MySQL, MS-Access, Tomcat

GUI Tools: Toad 10.0, WinCVS 2.0, Control-M 6.2, CA Unicenter

PROFESSIONAL EXPERIENCE:

Confidential

AppDev Business Analyst

• Working for SESIS (Special Education Student Information System) team using TIENET Application for managing the Special Education Student Records.
• Communicating effectively with potential users, stakeholders, IT staff, and decision makers to identify needs and evaluate potential business solutions with project management
• Evaluating information gathered from multiple sources, reconcile conflicts, decompose high-level information into details, abstract up from low-level information to a general understanding, and distinguish user requests from the underlying true needs.
• Creating and Updating the tables using SQL server
• View, Edit, Insert, Add and Delete Rows in the database by using SQL queries
• Compiling the code and comparing the Source and Target Databases
• Tested the data and data integrity among various sources and targets.
• Good understanding of stored procedures developed using PL/SQL and SQL queries tuning for better performance. Performed end-to-end testing manually.
• Extensively using SQL queries for validating the data stored in different database tables.
• Preparing the Business Requirements Document, mapping and design documents
• Generating the test cases using HPQC application
• Managing the requirements and tests using HPQC(quality management store )
• Working with the T5 (Turning) process and PRE-K by validating the data after deploying into the production in SESIS Front End.
• Serving as the conduit between the customer community (internal and external customers) and the software development team through which requirements flow
• Collaborating with developers and SME’s to establish the technical vision and analyze tradeoffs between usability and performance needs.
• Presenting project requirements and solution options to various stakeholders and decision makers.
• Working with users and stakeholders to define concepts, processes, and requirements and under direction of project managers.

Environment: PowerSchool’s TIENET, SESIS Frontend, SQL, DataStage, SSRS, SSIS, Data Mapping, Data Modeling, JIRA, TFS, Agile, Waterfall, Microsoft Suite, SDLC, HP ALM, HPQC

Confidential, Cherry Hill, NJ

Business Analyst (BA)

• Responsible for Requirement gathering, creating Business Process Flows (As-Is and To-Be), Business Process Modeling and Business Analysis with Document and Records Management for Segment Partnership and other Business Technology Projects.
• Designed Work flows and BPM Business Process Management for streamlining approval processes for Campaign Requests and review automation using IBM BPM as part of controls.
• Involved in the BPM projects in driving customer experience initiatives, for overhauling customer service processes and seek to deliver more compelling experiences that in corporate analytics and real-time guidance.
• Involved with Mortgage LOB in the Underwriting team to re-design the business process using IBM BPM.
• Used to streamline operations through visualization & optimization, Improved Regulatory Compliance, Apply process, Fraud Management, Customer Care & Insight.
• Involved in preparing training materials for the business users and involved in training them regarding the business process modelling.
• Performed GIS modeling duties
• Used GIS technology for improving the business processes and enhancing the delivery of services
• Participated in the development and enhancement of GIS technology in order to meet its mapping and end user service objectives
• Involved in building the mobile application of Freedom starting from collecting the requirements, testing and preparing the user guide.
• Participated in PEGA Workshop while planned to migrate from Savvion BPM to PEGA BPM. requirements and successful implementation of ETL, Reporting, Java, CCD/WorkFlow, File Transfer features.
• Responsible for aligning with P&C strategic initiatives that entails substantial work with MIS Reporting, business performance analytics, sales tracking, and ETLs.
• Defined and managed e-commerce reporting requirements.
• Served as the liaison between business units, application development teams and infrastructure teams
• Facilitating the requirement sessions within the SAFe Framework.
• Collaborating closely with both the development team and QA within the SAFe framework.
• Aiding in maintaining the backlog on SAFe initiatives.
• Configured Content Management System (CMS) with templates, workflow and security.
• Worked with developers for creating customized solutions including integrating third-party tools.
• Performed interface analysis, including proper mapping of how the technology infrastructure and systems share data to achieve business goals
• Managed critical relationships with consultants and vendors, internal end users, and business customers/management.
• Collaborated with business owners and stakeholders to lead store, marketing and eCommerce requirements gathering and analysis
• Help guided for the design and implementation of the solution by applying the functional knowledge of eCommerce applications.
• Engaged with the eCommerce team for optimizing website, channel performance and customer segmentation
• Assisted in Management Annuity Sales illustrations, which included development of requirements for User Interface and Output, creation of test cases and tested to ensure quality of product.
• Performed analytics in order to assist with pricing, servicing, and origination strategies.
• Prepared and presented Business Requirement Document (BRD), System Requirement Specification (SRS), Functional Requirement Document (FRD) and Request for Proposal (RFP) document involved in sign-off process.
• Worked on Tableau by importing data from GIS systems and analyzed the targeted customer geographic area for giving credit card offers.
• Performed Gap analysis by identifying existing technologies, documenting the enhancements to meet the end state requirements.
• Tested the internal processes with a view for finding opportunities, improving the derivative processes and making them more efficient and cost effective
• Performed as a Business Process SME (Subject Matter Expert) and resource for key processes and systems.
• Involved in creating detailed test plans and testing strategies and ensure these are executed extensively, which includes executing SQL queries to retrieve data and test
• Logged and resolved defects using MS Visual Studio and provided support for User Acceptance Testing with UAT cases and resolving any issues with the users and performed UAT and participated in writing test plans.
• Interacted with supply chain operations for identifying gaps and improvement opportunities in the Supply Chain Planning process
• Performed as both BA and QA for RPA (Robotic Process Automation) projects in collecting requirements, testing (QA), UAT and involved in deployment helps business users to automate their processes which used to be done manually.
• Knowledge about SOAP service while working with RPA projects.
• Created advance network-based API solutions using REST/JSON and XML/SOAP solutions.
• Involved in the upgrade of Robots and setting up new RPA machines by working with AWS team for spin up.
• Scheduled the business processes from UI path Orchestrator and monitor the processes every day if all the scheduled jobs are running smoothly.

Environment: MS Office Suite, MS-Visio, MS Project, SharePoint, IBM BPM, SCM, OMS, UI Path Studio (RPA), UI Path Orchestrator, MS Visual Studio, IBM Data Stage, PL/SQL, Quality Center, Blueworks Live, Rational Rose.

Confidential, Dallas, TX (Internship)

Business System Analyst

Responsibilities:

• Conducted walkthroughs with the different department heads to have a deeper understanding of the requirements
• Analyzed and documented the business requirements and generated reports for the Manager
• Wrote the software development plan and held meetings with the developers and forwarded information and documents to them
• Developed flow diagrams for Business process of the company using Microsoft Visio
• Use Case Modeling using Rational Rose for preparing Functional Requirements documents
• Follow up with the end users and developers for user satisfaction and change management if necessary
• Functioned as the primary liaison between the business, operations, and technical groups throughout the project cycle
• Collaborated with technical decision makers for communicating regarding the complex eCommerce constraints and opportunities.
• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance testing (UAT).

Environment: Java/J2EE/JSP, Struts, HTML, TOMCAT, Rational Rose, Agile iterations, UML, Rational Clear Case, MS Office, and Oracle, Salesforce.

Confidential

Business System Analyst

Responsibilities:

• Analyzed requirements, participated in Design Discussions and prepared Design documents
• Developed data mapping and transformation scripts to put data in the required format and context.
• Performed technical data analysis, provide referential integrity checks and deliver other project tasks, as assigned, on time and communicates accordingly.
• Participate in daily stand-up meetings to facilitate the understanding, clarification, and implementation of requirements in an Agile development environment
• Developed user stories and tasks while participating on Agile teams
• Identified future infrastructure needs and documented business cases and requirements
• Participate in system enhancements, modifications and upgrades
• Experience in working regarding insurance functions, including Claims, Premium Audit, and Loss Control
• Supported CPM applications
• Design and development of the application Enhancements - Worked on Class Structure Design, activities, decision rules, UI rules, SQL Connectors, HTTP Services and Connectors, SOAP Services and Connectors, MQ Listeners
• Trouble-shoots and identifies root cause systems errors and recommends preliminary solutions to more senior analysts
• Acted as primary IT liaison to P&C Insurance business users.
• Developed systems requirements and acceptance criteria for system implementation, corrections and enhancements, and conducted testing as appropriate to valid functionality. Also served as system SME providing end-user support.
• Assists in the development of user system documentation. Perform initial investigation, evaluation and documentation of system design findings
• Addressed the requirements and handled core data related to Provider Directories
• Monitored Agents, Listeners and Log files
• Developed dimensional data models using Erwin as per the specified business requirements.
• Migrated data from Oracle 8i, SQL Server, DB2 and other flat file data sources using DataStage6.0
• Had experience in configuration of the processing system which helps in automation of the manual process.
• Develop parameter driven ETL process to map source systems to target data warehouse with DataStage complete source system profiling.
• Designed lookup strategies using Hash file stage for data extraction from the source systems.
• Used the DataStage Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into data warehouse database.
• Worked on programs for scheduling data loading and transformations using DataStage from ready to load flat files to Oracle using SQL*Loader and PL/SQL.
• Developed Shell scripts to automate file manipulation and data loading procedures.
• Developed Auditing strategies for self-documentation of the ETL process.
• Knowledge in setting up the communications for EDI transmissions using FTP, SFTP and real time API setups
• Generated complex reports using MicroStrategy for Drill down, Slice and Dice type of reports and deployment for end-users and documented the entire project.

Environment: PRPC v6.3 SP1, Oracle 11g, CPM, SQL, DataStage 7.1, AIX 4.3, Quality Stage, MicroStrategy 7.5, Brio, SQL, Korn Shell

Software Engineer

Confidential

Responsibilities:

• Conducted functionality, usability, interface, compatibility and security testing of the web application developer
• Defined the test scenarios (testing the bounds, validations) for the web application, identified and reported bugs to the development team
• Additionally, performed bug fixes for the application, as part of the development team
• Developed and maintained checklists to ensure development was aligned with client’s specifications and requirements

Environment: MS-Access, MySQL, Windows 2000, Dreamweaver