PROFESSIONAL SUMMARY:

• Over 8+ years of experience in Software Development Life Cycle (SDLC), including Business and Functional Requirement Documentation, Data Modeling, Data Analysis and Mapping, Data warehousing and Business Intelligence Applications.
• Strong knowledge of Business Intelligence, Data Warehousing and Business Architecture
• Proficient in writing SQL queries to perform data driven tests and involved in front - end and back-end testing. Strong knowledge of RDBMS concepts. Developed SQL queries in databases to conduct DB testing.
• Expert in analyzing teh error caused to failure of teh ETL load with to teh log file and report them to teh corresponding team to get it rectified.
• Expertise in creating/developing TEST CASES and developing TEST SCRIPTS.
• Work as a liaison between teh team members and teh manager.
• Strong Business and Functional knowledge and Ability to evaluate ETL/BI specification, verify it with systems and Experienced with Master Data Management (MDM)
• Proficient in creating ETL specification documents, Source to Target Mapping documents, Functional specification documents.
• Create and maintain project milestone documents, meeting minutes, Defect management tracker.
• Proficient in creating Process Flow Diagrams, Use Cases and assist Business Users in UAT.
• Excellent understanding of Relational Database Systems, Normalization and Logical and Physical data modeling.
• Excellent skill in creating/developing TEST CASES and developing TEST SCRIPTS
• Strong experience in Business Intelligence and Reporting tools like Google Studio, and Tableau.
• Knowledge on data modeling tools like VISIO, Lucid Chart which helps in designing logical and physical models.
• Test Data Marts, Data Warehouse/ETL Applications developed in Informatica, Data Stage and Ab Initio using Oracle, DB2, Teradata, Sybase, and SQL Server.
• Test Business Intelligence reports generated by various BI Tools like Cognos, Google Data Studio and Business Objects
• Familiar with Informatica Repository Manager, Designer, Workflow Manager, Workflow Monitor
• Comfortable in working with fixed length, delimited flat files and also worked with large volume of data in teh database/data warehouse.
• Expertise in developing test cases/ test scripts for Inbound and Outbound ETL processes.
• Experience in testing/validating teh Source, Stage and Target (End-to-End).
• Strong knowledge of working with Data Marts (Star Schema and Snowflake Schema)

PROFESSIONAL EXPERIENCE:

Confidential - Glenview, IL

Data Analyst & Visualization

Responsibilities:

• Define business, data and system requirements by studying and analyzing existing system/process, project scope definitions, collaborating with business user team in DOORS
• Collaborating with stakeholders from teh CSS Application Development team to drive teh successful implementation of data mappings and business rules into productions
• Involved in data analysis and provide data consultation for any end user data questions in post implementation period
• Worked closely with business/data SME, data modelers, testing and development team to clarify/understand requirements, resolve data issues/questions
• Performed GAP analysis so as to analyze teh variance between teh system capabilities and business requirements
• Experienced in gathering requirements through formal/informal sessions, JAD sessions with SMEs and business users
• Involved in performing root cause analysis on post-production data issues dat occurred during Data quality checks, data reconciliation issues
• Worked with project team representatives to ensure dat logical and physical data models were developed in line with corporate standards and guidelines
• Involved in defining teh ETL source to target data mapping documents, transformation logic and data definitions
• Extensively used SQL for data validations by querying teh database and involved in back-end testing and worked with data quality issues
• Work closely with teh IT Director to generate reports by writing SQL queries in Excel and Business Objects as per business needs
• Performed data analysis and data profiling using complex SQL on various source systems including Oracle and Teradata
• Involved in data reconciliation between integrated systems
• Written complex SQL queries to ensure teh reports developed in Business Objects are meeting teh business requirements
• Written SQL scripts to test teh mappings and developed Traceability Matrix of Business Requirements mapped to test scripts to ensure any change control in requirements leads to test case update
• Track production issues and report periodically to teh senior business management
• Extracted and analyzed source data from various data sources like flat files,DB2,Oracle
• Worked closely with teh developers during coding and while doing remediation of teh software
• Assisted teh testing teams in developing test plans, test strategies, test cases, defect reports, traceability matrices and test environments

Confidential, River Forest, IL

Business Analyst

Responsibilities:

• Gathered Business Requirements, analyzed data/workflows & performed GAP analysis. Met with client groups to determine User Requirements and Goals, thus converting User Requirements into Business.
• Facilitated collection of Functional Requirements from system users, and prepared Business and Technical Requirement Specification documents.
• Assisted in Data File Definitions and Data mapping activities for teh data gathered during teh process of development and implementation.
• Documented approved change controls to add them into business design.Prepared Logical Process and Data Models dat contained set of diagrams and supporting documents containing teh essential business elements, detailed definitions, and descriptions of teh relationships between teh data elements to analyse and document Business Data Requirements.
• Develop data visualizations and interacting with Business users to understand and analyze their requirements.
• Created dashboards by extracting data from different sources.
• Created dashboard using parameters, sets, groups and calculated fields.
• Involved in creating a dual-axis bar chart with multiple measures and also created bins for different measures.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Implemented data blending in order to merge data from different sources.
• Used and applied actions like filter, highlight and URL to dashboards.

Confidential

Business Process Analyst

Responsibilities:

• Analyzed and reviewed teh current Business Process and conducted meetings, interviews and JAD sessions to collect business requirements and translated them to create System Requirement Specifications.
• Gathered, developed, reviewed, and maintained Business Requirements, functional specifications, use cases.
• Developed a framework of guidelines, process documents and templates for offshore project execution.
• Worked with teh Testing team to form system / acceptance Test Case documents.
• Collaborated with teh team in fine tuning teh data gathering requirements, field identification, and data profiling and validation. Documented all teh above and presented in weekly milestone meetings.
• Prepared project schedule, allocated tasks to teh development team, conducted weekly status meetings, and reporting weekly project status to Team Leader.
• Reviewed and approved project specifications and technical inputs on teh project, analysis and design documents prepared by teh design and development teams.
• Reviewed test plans for unit test, system test and acceptance test.
• Monitored development work and test results and coordinated effectively for timely completion of projects.
• Interpreted Use Case diagram, Sequence diagram and Class diagram.
• Performed functional, smoke, sanity, performance, system testing, integrated testing and load testing.
• Assisted in mapping teh requirements to teh source systems, teh DW and applicable data marts.
• Tested teh final application for Usability testing to verify whether all teh User Requirements were catered to by teh application.
• Designed and implemented basic as well as complex SQL queries for report and data validation
• Developed a Traceability Matrix to keep track of teh Requirements, Use Cases and Test Cases.
• Conducted JAD sessions with teh stakeholders, end users and SME, to determine teh critical business processes and identify key functional requirements for teh new system.
• Identified teh key Stakeholders and teh business users of teh application.
• Facilitated Daily scrum meetings, sprint planning, sprint review, and sprint retrospective.
• Worked with Product owner on artifacts such as Product Backlog, Sprint Backlog, Sprint Burn Down Chart and did business process management.
• Publicized teh team’s progress and successes to make sure they are highly visible to product owner /
• Created a product roadmap for teh various stages and releases throughout teh project lifecycle.
• Created various UML models like Use Case diagrams, Activity Diagrams and process flow Diagrams in MS Visio.
• Created and managed all teh requirement artifacts in Quality Center.
• Conducted timely requirement review sessions with teh Stakeholders and end users to ensure teh product verification.
• Involved in data modeling to design tables for reporting purposes.
• Wrote SQL queries to extract data from various databases.
• Actively conducted and participated in weekly meetings to analyze teh progress and maintain status reports.
• Created test cases reviewed test cases and maintained teh Requirement Traceability Matrix (RTM).
• Performed Functional and UAT testing before teh system went live.

Confidential

Business Analyst, Project Manager

Responsibilities:

• Gathered, identified and analyzed business and functional user requirements, technical specifications and performed sprint level feature breakdown ofbusinessstories and translating into technical stories and software deliverables.
• Facilitated JAD sessions for discussing teh requirements and coordinated during agile processes like Backlog grooming, Sprint planning, Daily scrums, Retrospectives for prioritization, impediment removal and time constraint monitoring.
• Requirement Analysis, Test Plan creation, RTM creation, Test Estimation, Test Strategizing, Resource Planning, Test Data setup, Test scenario and Test case creation and execution for Mobile and web applications.
• Designed, optimized and executed more TEMPthan 100 test plans in ALM to ensure functioning of product as per requirements.
• Accountable for complete Mobile Application and Quality assurance testing including Functional, Sanity, Smoke, E2E, User Acceptance, Integration, Regression, Performance testing to ensure delivered product meets teh business user’s requirements.
• Logged, tracked and retested issues in JIRA and collaborated with development team to perform root cause analysis.
• Enhanced testing performance by introducing exploratory testing, increasing bugs/issues detection by 30%. ed “Spot ” for providing quick resolutions to blocking issues and performing impeccable analysis of business requirements, covering it in RTM and suggesting process improvements.
• Mentored team for new functionality through sessions, demonstrations and appropriate documentation.
• Initiated teh Knowledge Management process which helped retaining teh knowledge and handling teh challenge of resource replacement.
• Initiated teh process of Acceptance criteria review to make sure all team members are in same line with teh Product owner and leading to sign off with teh PO.
• Introduction of testing of Acceptance criteria to adopt teh frequent changes of requirements from teh Product Owner.
• Implementation of Dev-Test Pairs to work on a user-story in a sprint to handle teh gap between understanding teh requirements by teh development and testing team.