We provide IT Staff Augmentation Services!

Sr. Business Systems Analyst/quality Assurance Analyst Resume

SUMMARY

  • Over 12 years of professional IT experience. 10+ years as a Business Systems Analyst in Finance, Insurance, Banking, HealthCare and Retail industries.
  • Highly involved in whole Software Development Life Cycle (SDLC), business process analysis, design, implementation, testing, integration and maintenance.
  • Experienced in project management with a strong understanding of the sequential and interactive software development approaches like Waterfall, and Agile Scrum.
  • Experience in requirement gathering and documenting software requirement specifications.
  • Experience in developing technical specifications from high - level requirements.
  • Experience in developing systems from scratch using different technologies and methodologies.
  • Experience in Android application development, Android Framework Services and APIs.
  • Experience in developing XML schema for sending and receiving request from third party system.
  • Experience in business process re-engineering.
  • Experiences in creating sequence diagrams or collaboration diagrams for the scenarios of each use case.
  • Interfaced closely with client system groups to capture business requirements and see them through implementation.
  • Experience in leading projects from analysis to production deployment phase.
  • Experience Test Cases, Test Scripts, and Test Plans and UAT testing.
  • Experience working with the Software Development Life Cycle RUP, METHOD 1, AGILE, WATERFALL.
  • Experience in Use Cases, Use Case Specifications, and UML.
  • Experience in developing Java, J2EE, HTML, CSS.
  • Proven Project Management and Project Coordination skills
  • Excellent verbal, written, and interpersonal communication skills.
  • Experience with data migrations, and data mapping.
  • Good working experience with Banking, Insurance, Mortgage, e-Commerce and trading applications.
  • Experience in Credit Strategy, Credit Rules, Credit Decision Engine such TransUnion and Experian.
  • Experience in Web Based, Non-Web Based, and B to B systems.

TECHNICAL SKILLS

Operating Systems: Windows 95/98/NT/2000/XP/10, Unix, DOS

Software Methodologies: Agile (SCRUM), Waterfall Model, Rational Unified Process (RUP), METHOD1

Databases: MS Access, Sybase, Oracle (SQL), SQL Server, Oracle 10g, DB2, MySQL

Software: MS Project, MS Word, MS Excel, PowerPoint, MS Visio, MS SharePoint, Rational Rose, Together 6.0. Matlab 7.0, PolyAnalyst 4.6, CART, SPSS, Crystal Reports, Oracle, Sybase, SQL Server, MySQL, Apache Tomcat, NetBeans 7.2, Eclipse, Visual Studio, MongoDB(NoSQL).

Languages: Java, Java Scripts, JSP, Java Servlets, Java Hibernate, Java Swing, JDBC, Jquery, Node JS, Angular JS, Spring MVC, HTML, XML, CSS, PHP, SQL, ASP, UML, VB Scripts, C++, C#, Pascal, COBOL, Assembly Language, Android, Python.

Testing Tools: PVCS Tracker, SmartSheet, JIRA, HP Quality Center

PROFESSIONAL EXPERIENCE

Confidential

Sr. Business Systems Analyst/Quality Assurance Analyst

Responsibilities:

  • Gathered requirements for small, medium and large size projects.
  • Documented Software Requirement Specifications and technical specifications.
  • Designed and developed various artifacts such wireframes, mock-up, activity diagram, decision diagrams, etc.
  • Developed and executed test cases and test scripts, performed regression testings as required.
  • Worked on Web Based Loan Origination System and Mobile Loan Origination Systems.
  • System consists of Installment Loan Agreement, DocuSign Documents.
  • Worked on Automatic email functionality, all documents send out automatic via email by system.
  • Gathered and developed database security requirements such as Access Control, User Authentication - 2FA, Encryption of credit bureau file 256, Database masking etc.
  • Designed developed and tested XML schema for sending and receiving request from third party system.
  • Updated and added and tested data elements in the installment loan agreement as business needed.
  • Documented release notes during each deployment.
  • Added, configure and tested new functionality in the backend administrator.
  • Added and tested various loan products in Loan Origination System.
  • Worked on Transunion and Experian Decision Engine.
  • Performed massive amount of UAT and Regression testing after each UAT and Production deployment.
  • Gathered requirements, documented BRD, developed and execute test cases for Mobile Application such as Android and IOS.
  • Scheduled and facilitated meetings with Project Managers, IT Developers, Directors, and High Level Executives.

Environment: Web Based Loan Origination System, Mobile Loan Origination System, DocuSign, MainFrame, SmartSheet, .NET. Android and IOS mobile applications, MS Sharepoint, JIRA.

Confidential

Business Systems Analyst

Responsibilities:

  • Gathered requirements for re-design of forms and developed various artifacts like mock up, form specifications.
  • Created various artifacts for eSignature, eForm project based on business requirements.
  • Documented technical specifications of eSign Forms.
  • Designed and Developed Forms using GMC, Document Generation Software.
  • Worked with Developer, QA and participated in UAT testing.
  • Reported and documented issue and bug in HP Quality Centre.
  • Analyzed defect and technical issues and resolved technical issue with developers in Java based system with Bank End Database of SQL Server.
  • Performed data analysis using Excel formulas like V-LookUp, Match and Index, Indirect, SUMProduct, Count, etc.
  • Analyzed existing business processes based on process category, sub-category, Topic, Subject and Forms.
  • Performed data mapping in various forms in order to determine similar forms fields and to minimize forms use by the bank.
  • Designed and developed MS Access database tables and created relationship with the existing tables.
  • Designed and developed MS Access forms and linked to different tables in order to load and update data.
  • Facilitated and participated meetings with Project Managers, Business Process Manager and team members of the project

Environment: SQL, Java, eForms, Operational Procedures, Customer Connect (Java Based System), XML, GMC, SharePoint, FileNet, HP Quality Center, MS Access, MS Excel, MS Word, JIRA.

Confidential, Santa Ana, CA

Business Systems Analyst

Responsibilities:

  • Participated in data migration project, mapping data from existing system to a new system.
  • Analyzed store procedure and mapped store procedure table columns to new systems.
  • Produced data dictionary for mapped data between systems.
  • Analyzed existing database and against new database and mapped data between two systems.
  • Mapped data based on business user interface to database table.
  • Attended meetings with PM and other group of people in the project.
  • Presented work to managers and other members of the project.
  • Worked with technical and data architect in order to map data.

Environment: Oracle, SQL Server, TOAD, MS Outlook, MS Excel and share point.

Confidential

Android developer/ Systems Analyst

Responsibilities:

  • Participated in complete Software Development Life Cycle (SDLC) for proper analysis, development, testing, deployment and enhancement of the code.
  • Played a key role in writing application logic using Eclipse IDE and Android SDK.
  • Designed complex User Interface screens using views and widgets.
  • Used Android Native Development Kit (NDK) in developing the bill payment feature.
  • Used fragments to build small re-usable pieces that are easier to manage and allow for a more fluid visual design and also can adapt to tablet and phone resolutions.
  • Created a local database using SQLite to store and retrieve the data.
  • Implemented the functionality of getting the download progress, aborting the download.
  • Debugging the code using DDMS, Logcat.
  • Used shared preferences to store and retrieve persistent key value pairs across user sessions.
  • Implemented JavaScript for validation.
  • Responsible for developing the Profile across several Products and several Android versions.
  • Used Activities which implement Broadcast Receivers to listen to several Broadcasts from other applications and the system.
  • Designed User Interface using HTML5 and CSS.
  • Integrated Google Map’s using Google Android location-based API.
  • Implemented XML service to parse historic and location based data.
  • Designed and developing the XML layout with Android Map View to display the locations on the map.
  • Created a pop-up notification for alerting users.
  • Involved in debugging and porting the application on various mobiles.

Environment: Android Version 2.3.3-4.2, Android SDK, NDK, Java, JavaScript, J2EE, Google Maps API, Eclipse IDE, windows 7, HTML5, XML 3.3.

Confidential

Business Analyst

Responsibilities:

  • Functioned as the primary liaison between the Stakeholders, Technical and QA team throughout SDLC by conducting brainstorming and JAD sessions to identify and clarify requirements.
  • Closely coordinated with cross functional team acceptable solution, and created Business Requirements Document, and Functional Design Document.
  • Worked with Data modeler to create Data Mapping, and Data Dictionary (metadata) for different Line of Business- Suspicious Activity Management, Income and Asset Estimate, and Customer Wealth Management.
  • Involved with cross- functional teams as per Data Governance process to document file sizes, file type, file processing schedules and time file coming from different source for regular tracking purpose.
  • Coordinated with the Analytics business team to establish a business process to ensure that all the reference data changed are adequately documented before remediation.
  • Performed Data Profiling to examine the data sourced from various Frond End Applications, and data validation by running SQL Queries using Teradata based on existing Business Rules.
  • Involved in Data Quality Assessment by analyzing reference data with client's standards discover inconsistencies, low quality missing data and other anomalies, and documented modified Business Rules in order to plan data cleansing, and data enrichment strategies.
  • Worked with QA team to design test plan and review Test Cases/ test scripts and documented all issues identified during the testing phase and ensured that all incidents were discovered, tracked, and resolved.
  • Facilitated User Acceptance Testing (UAT) using HP Quality center with the stakeholders and the business users, and the errors discovered were fixed and then verified via regression testing.

Environment: SQL Server, DB2, Oracle, HP Quality Center, Mainframe, MS Visio. MS Office, Excel, VISIO.

Confidential, Minneapolis, MN

Java Developer/ Systems Analyst

Responsibilities:

  • Involved in designing the application. Prepared UML Sequence Diagrams, Class Diagrams, and Activity Diagrams to incorporate in the technical design document.
  • Interacting with the team for project related activities/ doubts which included Technical leads and architects.
  • Developed Interactive GUI Screens using HTML, JSPs and performed Data validation using JavaScript.
  • Designed and developed database in Sybase database server.
  • Implemented Controller, Business delegate, Data Transfer Object, Data Access Object patterns and Struts Framework.
  • Involved in feasibility Analysis and Development of the enhancements.
  • Involved in estimates of the code changes for the enhancements.
  • Involved in detailed level design, High level design and also Unit testing for enhancements.
  • Worked with a development team of 4 members and worked as a J2EE Developer.
  • Trouble shooting production issues and solving customer’s trouble tickets.

Environment: J2EE, Java, Eclipse, Hibernate, Sybase, JSP, JavaScript, AngularJS, CSS, XML, VISIO, JIRA.

Confidential

Business Analyst

Responsibilities:

  • Functioned as the primary liaison between the Stakeholders, Technical and QA team throughout SDLC by conducting brainstorming and JAD sessions to identify and clarify requirements.
  • Closely coordinated with cross functional team acceptable solution, and created Business Requirements Document, and Functional Design Document.
  • Worked with Data modeler to create Data Mapping, and Data Dictionary (metadata) for different Line of Business- Suspicious Activity Management, Income and Asset Estimate, and Customer Wealth Management.
  • Involved with cross- functional teams as per Data Governance process to document file sizes, file type, file processing schedules and time file coming from different source for regular tracking purpose.
  • Coordinated with the Analytics business team to establish a business process to ensure that all the reference data changed are adequately documented before remediation.
  • Performed Data Profiling to examine the data sourced from various Frond End Applications, and data validation by running SQL Queries using Teradata based on existing Business Rules.
  • Involved in Data Quality Assessment by analyzing reference data with client's standards discover inconsistencies, low quality missing data and other anomalies, and documented modified Business Rules in order to plan data cleansing, and data enrichment strategies.
  • Worked with QA team to design test plan and review Test Cases/ test scripts and documented all issues identified during the testing phase and ensured that all incidents were discovered, tracked, and resolved.
  • Facilitated User Acceptance Testing (UAT) using HP Quality center with the stakeholders and the business users, and the errors discovered were fixed and then verified via regression testing.

Environment: SQL Server, DB2, Oracle, HP Quality Center, Mainframe, MS Visio. MS Office, Excel, VISIO, Filogix.

Confidential, Calgary, AB

Business Systems Analyst

Responsibilities:

  • Participated in root cause analysis of Business production issues for Confidential application “TYES”.
  • Gathered and analyzed business requirements prior to perform root cause analysis of “TYES”.
  • Coded, Tested new fixes and requirements in development environment.
  • Worked with developers and business subject matter experts to analyze issues.
  • Estimated time and resources need to implement and test an issue.
  • Created test plans for issues after performing analysis.
  • Created, updated database table and entity based on systems requirements.
  • Created Relational database in Sybase database and performed CRUD operations in Sybase.
  • Updated PVCS tracker by status of issue assignment e.g. Implement, Test, QA, and Deployment to production.
  • Worked on Data Alert created daily by TYES application.

Environment: Java, COBOL, PVCS Tracker, UNIX, Shell Script, Multi-Edit, Rapid SQL, SYBASE, and Humming Bird, Crystal Reports, Visual Basic, MS Word, ITIL.

Confidential

Business Analyst

Responsibilities:

  • Analyzed, designed in developing a new web based insurance company’s system.
  • Web based e-Commerce system where consumers can receive quote, buy Auto and Habitation insurance.
  • Web based e-Commerce system where Consumer can compare quote with different insurance company.
  • Consumer can pay online or request for mail payment, consumers can get different version of quotes.
  • Worked on high level, detailed requirements, and ACRID (Assumption, Constraint, Risk, Issues, Dependencies)
  • Analyzed, designed and developed data mapping, business rules, data elements, GUI behavior.
  • Implemented business processes, business activities, use cases, use case specifications.
  • Took part on various workshops with business SME, IT, Business PM.
  • Worked as a Quality Assurance to ensure requirements quality meet client’s expectation.
  • Took part on JAD session with the clients, PM, and BA group.
  • Worked on WBM, WBM used to sketch the process processes, UML for use case diagrams.
  • Sequence and Activity diagrams were used to further elaborate the use cases.
  • Worked in GUI design on Auto, and Home owner insurance.
  • Developed business work around procedure.
  • Analyzed system’s context diagram and system’s interaction with all internal and external systems.

Environment: Use Cases, Business Processes, Business Activities, RUP (Sequence, Activity Diagrams), UML, MS VISIO, Websphere Business Modeler, MS Word.

Confidential, Minneapolis, MN

Business Systems Analyst

Responsibilities:

  • Analyzed, designed and developed Web Portal, e-Commerce system, Health insurance, Life Insurance, Mutual Funds, AMEX Corporate Security Applications, Financial Advisors errors and omissions systems, and Corporate Reporting Tool.
  • Took part on brand new product development and product’s technical specifications.
  • Facilitated workshops with presents of SME, IT Architects, Dept. Director, and Business side PMs and IT sides PM.
  • Identified System Gaps, did gap analysis, calculated risks and took part in Sign - off procedure.
  • Added new products, reports as a part of business process re-engineering.
  • Worked with the business team in order to gather business requirements.
  • Analyzed business requirements and translated to functional requirements.
  • Gathered and developed database security requirements such as Access Control, User Authentication - 2FA, Encryption of credit bureau file 156, Database masking etc.
  • Documented Business Systems Requirements.
  • Completed program specifications.
  • Developed use case diagrams and use case specifications.
  • Develped data flow diagrams for new systems and new requirements.
  • Performed and coordinated the analysis and design of business systems
  • Developed and maintained a thorough understanding of the assigned customer group’s needs from a business and technical perspective.
  • Worked closely with clients and with other system groups to capture business requirements and see them through implementation.
  • Developed and executed system testing.
  • Created test plan, test scripts.
  • Acted as a liaison between the business user groups and the technical systems groups.
  • Works on DB2, UNIX, Mainframe, COBOL, Lotus Notes, Shell Scripts, JAVA, UML, Sybase, Visual SourceSafe, Visual Studio, and SQL Advantage.
  • Designed and developed database in Sybase database server.
  • Enhanced existing systems, created new reports in the existing applications.
  • Analyzed program database tables, added or deleted attributes in database table according to business needs
  • Created work orders
  • Created BSAR (Business Systems Analysis Report).
  • Created BSDR (Business Systems Analysis Design Report).
  • Created DOSM (Distributed Operation Support Manual).
  • Worked with offshore and onsite development teams.
  • Gathered requirements and built reporting systems for the company.
  • Completed data analysis for reporting and ensured data integrity.
  • UAT on development, test, and production server.
  • Participated in data migration project; exposed to data mapping techniques.
  • Created GUI for existing and brand new systems.
  • Worked on Web Based, Non - Web Based, and B to B systems.

Environment: METHOD 1, RUP (Use Cases, Activity Diagrams, Sequence Diagrams, Workflow Diagrams), MS VISIO, MS Project, Java, COBOL, DB2, Mainframe, UNIX, Shell Script, Crystal Reports, SYBASE, HP Quality Center, Lotus Notes, Visual Basic, MS Access, MS Word.

Hire Now