SUMMARY

• Over 11+ years of experience as Business Analyst, System Analyst with proven track record of successfully leading teams and delivered projects.
• Excellent business writing skills essential for producing various business documents as Business Requirements Document (BRD), Functional Requirements Document (FRD), Requirements Traceability Matrix(RTM)
• Experienced in eliciting requirements, business process modeling, and technical documentation.
• Extensive experience in documenting the business process rules for coverage’s and Rating/underwriting by reviewing the existing applications.
• Have good expertise in documenting the Business rules for full life cycle of Policy issuing.
• Experience in Application Solution design, flow chart & Use case preparation in different LOB workflow.
• Experience working with PPACA/EDI Administrative Simplification CORE Phase III Operating rule requirements that pertain to EFT and ERA.
• Have experience working with different domains Retail, Banking, Insurance, Healthcare Industries.
• Good experience with version controls such as VSS (Visual Source Safe), ALM Quality Centre (QC).
• Expertise in Waterfall, Iterative and Agile (scrum) methodologies for the product development.
• Good experience in creating Test plan, Test strategy, Test Scenarios, and UAT Execution signoff.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Experience in applying Black box testing techniques.
• Possess strong tasks and time management skills and good communication skills.
• Strong knowledge working in different environments Web based, Middle ware, Mainframe, MS/Oracle databases, Data ware house.
• Expertise working with the Conversion, Migration, Upgrade and Development & maintenance projects.
• Expertise in extended validation of report functionality developed, using BI Cognos, by writing Complex SQLs at the backend.
• Good understanding of Big Data Hadoop and familiar with Hive, HDFS, Sqoop, Pig, Map Reduce concepts.
• Share point Analysis and creating dashboards in Share point.
• Mastered estimation, project planning, budgeting, allocations, test metrics and reporting.
• Hands on testing experience with Unix shell script and VB script.
• Expertise and involved in the In - house tools creation STE, Data Capture, Shovel and setting up Test Environments.

TECHNICAL SKILLS

Tools: Informatica 8.1, Power Center, Report Studio, Share Point, Dfsort, FileAid, Telon, JMeter

Reporting Tools: BI Cognos, SQL Developer

Testing Tools: HP Quality Center/Test Director, QTP, SPUFI

Database Management: Oracle 11g, Sybase, MySQL, ODBC, DB2,MS Access, Rapid

Operating Systems: Window 2003 Server, Windows 2000 Advanced Server, Windows 98, Windows XP, Linux and UNIX(AIX).

Version control: Visual Source safe, WINCVS, PVC, Source gear Vault, Relay, Endeavor, Change Man, Clearcase

Data Modeling Tools: Frame work manger, MS Visio, Apex, ZOS, Share point

Web Programming: HTML, XML, JSP, Java Script, SAS, Python

Programming languages: Cobol, JCL, Pascal, CICS, C/C++, PL/SQL, VB 6.0

Scheduling tool: Mainframes OPC Scheduler, Control M, Autosys

Others: Adobe 6,Ms office, Microsoft Outlook, LotusNotes, Jira

PROFESSIONAL EXPERIENCE

Confidential, Seattle, WA

Quality Engineer

Responsibilities:

• Started out the project in its planning phase using the Agile methodology and facilitated a weekend long meeting with the client and the team to collect business user stories.
• Reviewed business user stories and created several Excel and Word files to document the business process, user stories and algorithm required for Iteration 1.
• Participated in SCRUM meetings and worked closely with the Subject Matter Expert and the Project Manager.
• Used UML to create sequence and use case diagram in Microsoft Visio.
• Tested application integrity after running data Extraction, Transformation and Loading programs with services GG, Strom, RDS.
• Migration of data between different environments using AWS Data Migration service tool.
• Create read replicas and evaluate the lags between master and replicas on different clusters.
• Analyzed and interpreted test data, verifying critical software requirements to support development of requirements for system modification, development of test measures and criteria, test planning, execution and reporting activities.
• Validation of Micro strategy Dashboards and reports.
• Executed test scripts and verified the results. Reported Bugs to developers through the JIRA/Confluence.

Environment: AWS/S3, Aurora, Maria DB, MYSQL, golden gate, oracle, RMS, Strom, Splunk, Pentaho, RDS, Power Center 8.1, Mainframes, workflow manager, workflow monitor, Oracle UNIX, Toad, Micro Strategy, SQS Queue

Confidential, Beaverton, OR

Business System Analyst

Responsibilities:

• Review Business requirements with different stake holders and perform requirement gathering and functional design.
• Work with development team in technical design, testing & requirement understanding.
• Involving in Functional, Integration, System and Regression testing of the application.
• Extensively used SQL scripts and procedures to confirm the data transfer from source to target as per the business rules.
• Ensures data quality of on-going data feeds through the development of monitors to track key data variables.
• Testing application integrity after running data Extraction, Transformation and Loading using SQL Developer.
• Test the Batch/on-line UI application module(s) to verify whether the changes meet the new business requirements.
• Investigating and facilitating resolution of Data warehousing and data integrity issues and perform data quality Analysis
• Participates in the technical implementation of new data source feeds, including developing test plans, from the business perspective.
• Validate the data mapping of the source to Target using Informatics Power centre
• Analyzed and interpreted test data, verifying critical software requirements to support development of requirements for system modification, development of test measures and criteria, test planning, execution and reporting activities.
• Design and set up SharePoint for the Dashboard and Reports
• Supports data management activities associated with testing and analysis of test data to determine satisfaction of test objectives.
• Involved in the triage meetings with business and development team.
• Verify the Performance of the Reports and QM Dashboards.
• Designed Standards, Policies, Procedures and best practices.

Environment: Business Intelligence, Cognos, Informatica Power Center 8.1, Mainframes, Quality Center, Oracle 11g, Sybase, Windows XP, SQL Developer, UNIX, APEX

Confidential, Bloomington, IL

Business System Analyst

Responsibilities:

• Analyzing the requirements and understood the business critical functionalities for restructuring of the Application.
• Develop requirements gathering and master data elements for the DSS and AQP work flow for Rating/Underwriting module.
• Worked actively in the preparation of Business Requirement Documents, Functional Specification Documents and Change Request Documents.
• Co-ordination with Development Team and Business client for proper project implementation.
• Created and managed performance metrics and reporting
• Responsible for gathering Test business rules from the legacy systems
• Perform data quality analysis, standardization and validation.
• Execute and validate the Auto Quote Purchase & claims work flow.
• Supports data management activities associated with testing and analysis of test data to determine satisfaction of test objectives.
• Functional responsibilities included GUI, Functionality, Navigation Testing, System Testing, Integration Testing, Database Testing and Regression testing on the application
• Analyzed and interpreted test data, verifying critical software requirements to support development of requirements for system modification, development of test measures and criteria, test planning, execution and reporting activities

Environment: Mainframes, Quality Center, Oracle, SQL Server, Windows XP, SQL Developer, Necho, AQP, Springs, Clear case

Confidential, Jacksonville, FL

Test Lead

Responsibilities:

• Clearly communicated and documented test results and defect resolutions during all phases of testing.
• Stimulated several production cycles. Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Performed Black-box testing, White-box testing, System Testing, Data Integrity Testing, Sanity, Regression and end-end testing
• Implemented SDLC, QA methodologies and concepts in the Project
• Completely involved in Developing Test Plans and Developed Test Cases/Test Strategy with input from the assigned Business Analysts
• Involved with ETL test data creation for all the ETL mapping rules.
• Worked on profiling the data for understanding the data and mapping document.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Validated Standard Business objects reports against business requirements
• Prepared and executed performance test models on various web activity logs
• Involved in working with Source Gear Vault for Version Management

Environment: Mainframes, Business Intelligence, Toad for Oracle, ORACLE 9i,Informatica, Unix, Bugzilla, Control M, Source Gear Vault, Windows XP.

Confidential, Chattanooga, TN

Business System Analyst

Responsibilities:

• Create and review Functional requirements by interacting with Business partners and different stake holders
• Involved in Data Mining and producing useful reports to the end user
• Provided inputs for creating detailed Test Plan.
• Created and executed test cases for User Interface functionality, Data Warehouse data (Fact tables, Dimensions, References and Lookups) and Reports.
• Test cases were designed to cover System testing and Integration testing scenarios.
• Tested application integrity after running data Extraction, Transformation and Loading programs.
• Performed System testing, regression testing and user Acceptance testing (UAT).
• Created Automation test scripts and performed Regression testing. Created User Defined Functions to enhance the maintainability of regression scripts.
• Executing manual test cases/scripts and documented test results. Reported Bugs through Test director bug-tracking tool.
• Submitted Status Test Evaluation Reports to Test Lead. Constantly updated test deliverables.
• Used Test director to write Test case and attached test scripts to test cases.
• Designed ETL template using Metadata Reporter for easy walk through with customers.
• Studied documentation on Business Requirements, System requirements and application.
• Maintained Test Matrix for latest test results information.
• Interacted with business analysts in resolving the problems in different environments (Unix, NT)

Environment: Data stage 7.5, Business Object Reports, Windows 2000/XP Professional, LINUX, SQL, PL/SQL, ASP.NET,VB.NET Oracle 9i,DB2,Test Director 8.0

Confidential, Hartford, CT

Business Analyst

Responsibilities:

• Reviewed the Business Requirement documents (BRD) with the business analyst and development team to understand the architecture and functionality of the application.
• Create rules-based workflows to dictate the flow of the document through the organization.
• Develop document management functions like version management, search and navigation
• Creating Test plans, Test cases based on requirements of application.
• Participated in various project meetings. Tested the application manually using Internet Explorer and Netscape Navigator.
• Involved in gathering, analyzing, distilling and clearly conveying complex information to business and project team members through JAD sessions
• Involved in analyzing the requests for new, enhanced, and modified systems, against user and business requirements using RUP methodology.
• Produced documents for business requirements (requirements matrix), design requirements, gap analysis, solution recommendations, test cases, test plans and reference guides

Environment: Informatica 7.1, Windows 2000, Win runner, Test Director, HTML, Autosys, JavaScript, Servlets, JDBC, JSP, Web methods, Toad for Oracle, Oracle 8i.