Objective

• To obtain a responsible and a challenging role that will enable me to learn new technologies and skills while utilizing my previous experiences for the advancement and exceed expectations to excel within the organization.

SUMMARY

• A customer oriented, multitask professional with excellent analytical and logical skills possesses rich experience of 5+ years as a Business Analyst / QA Tester / Data Modeler with a strong understanding of Business Analysis, System Analysis, Business Process Management and Data Vault Modeling.
• Extensive experience in retail, banking, and automobile industry.
• Committed to improving business productivity and efficiency. Specialize in applying technical expertise to develop insightful solutions applicable to current business practices involving everything from project initiation to design, development, testing and implementation
• Experience in data mining, analytics, KPI dashboards and scorecards.
• Experience working on Data - Vault Methodology and creating Raw Data Vault, Business Data Vault and Data Mart models.
• Hands on experience with end to end data modelling skills, source to target mapping techniques, data flow diagrams using ER Studio, Lucid Chart and Visio Diagram.
• Proficient in writing SQL queries for data analysis and validation.
• Experience on using various Snowflake cloud database components.
• Expertise in achieving cost-effective production with increased quality.
• Expert in identifying the requirements and in finding the system requirements
• Expertise in prepare Integration Test Plan which was used by functional team as well as development team.
• Skilled User Acceptance Tester understands the need to meet all functionality requirements for business client end-users of new applications
• Developed and executed test cases (both manual and automated) based on business requirements.
• Executed automated test scripts for Functional, Regression, Integration testing, User Acceptance Testing.
• Implemented Automation testing for desktop applications and handling SharePoint and Quality Assurance for different Projects involving MicroStrategy and reporting tools.
• Used pre-execution checklists to verify that the environment was ready for testing.
• Complete knowledge of full software development life cycle (SDLC), co-ordination with the testing team (Testing Centre of Excellence) and generate complex test scripts to capture the defects.
• A highly motivated, energetic, professional, hardworking, and result oriented team player/lead with excellent analytical, problem solving, communication, and interpersonal skills.
• Ability to make people understand and convince them and to produce the best result in pressure situations and ability to work in team as well as individual.

TECHNICAL SKILLS

Data Modeling Tools: ER Studio and Lucid Chart

DB Tools: Snowflake, Toad for Oracle, DBeaver for Progress, SQL Developer

Databases: Snowflake, Progress, Oracle, Sybase, DB2, SQL Server

ETL Tools: Informatica PowerCenter 10.2

Microsoft: Datalake, SharePoint, MS Word, MS Excel, Visio, MS Project, PowerPoint

Version Control Tools: HP ALM Quality Center, JIRA, Subversion, Azure Dev ops

Testing Tools: Win Runner, Quick Test Professional, Testcomplete testing tool

Systems: UNIX, Windows 9X/NT/2000/XP/2K3

Languages: C, C++, VB, .Net

PROFESSIONAL EXPERIENCE

Confidential, Ogden, UT

Data Modeler Analyst

Responsibilities:

• Analyzing and translating business needs into long-term solution data models.
• Created Raw data vault models to map source system to Landing tables.
• Created Business data vault models to transform raw data into business vault data based on the business requirements.
• Evaluating existing data systems and integrate new requirements into the existing system.
• Working with the development team to create conceptual data models and data flows.
• Developing best practices for data coding to ensure consistency within the system.
• Reviewing modifications of existing systems for cross-compatibility.
• Implementing data strategies and developing physical data models.
• Updating and optimizing local and metadata models.
• Evaluating implemented data systems for variances, discrepancies, and efficiency.
• Troubleshooting and optimizing data systems.
• Develops and approves strategies for continuous improvement in data management.
• Perform analysis and provide solutions.
• Assists with coordination of database changes within context of overall configuration management process.
• Identifying, recommending, and implementing emerging Modeling and IT trends, developments, tools, and improvements/solutions.
• Manage multiple assignments simultaneously, while working independently, and with other engineers and SMEs.
• Create, manage, and modify logical and physical data models using Data Vault.
• Collaborates with cross-functional team in support of business case development and identifying modeling method(s) to provide business solutions.
• Assist service developers in adding new data concepts to their services.
• Establish standards around flexibility of the data model to ensure deviations are within established guard rails.
• Performs data analyzes and design, and creates and maintains large, complex logical and physical data models, and metadata repositories using ER Studio and Lucid Chart.
• Assist service developers in finding relevant content in the existing reference models.
• Assist with defining data model development methodologies, principles, standards, and governance considering People and Process optimization aspects.
• Worked with Multiple source systems which includes MDM, SAP, JDE, QAD, Movex and Outsystems.
• Work with the DW/ETL development team to implement data strategies, build data flows and develop data models.
• Work with development, application, and other data architects to provide an overall solution approach.
• Provides technical assistance and mentoring to staff for developing conceptual and logical database designs and the physical database.

Confidential, Layton, UT

Software QA Lead

Responsibilities:

• Involved in all phases of Project Life Cycle from Requirement gathering, Design, Development, Testing and Rollout to the field user
• Reviewing requirements, specifications, and technical design documents to provide timely and meaningful feedback
• Creating detailed, comprehensive, and well-structured test plans and test cases
• Estimating, prioritizing, planning, leading, and coordinating testing activities
• Design, develop and execute automation scripts.
• Implemented Automation testing for desktop applications.
• Identify, record, document thoroughly and track bugs
• Perform thorough regression testing when bugs are resolved
• Develop and apply testing processes for new and existing Confidential products
• Liaise with internal teams (e.g. developers) to identify system requirements
• Monitor debugging process results
• Investigate the causes of non-conforming software and train users to implement solutions
• Track quality assurance metrics, like defect densities and open defect counts
• Stay up-to-date with new testing tools and test strategies
• Help define data element mappings from partner data sources within the Confidential products
• Validate that mappings have been implemented correctly and that data flows properly through the Confidential products
• Troubleshoot product in cases where data mappings are incorrect.

Confidential, Murray, UT

Configuration Analyst

Responsibilities:

• Involved in all phases of Project Life Cycle from Requirement gathering, Design, Development, Testing and Rollout to the field user
• Gathered requirements and prepared business requirement documents and developed requirements for functional improvements and enhancements.
• Defines application problem by conferring with clients; evaluating procedures and processes
• Wrote test scripts and test cases in HP Quality Center to meet assigned requirements.
• Participated in performance testing and completed test cases in HP Quality Center
• Tracked the status of defects and provided a status report during daily meetings
• Prepared and executed sql test scripts to test and validate the data in oracle database.
• Worked with creation of test scenarios and sample test of the real-time calculation.
• Worked on Fitnesse tool, to verify the calculator’s logic required for the respective processors.
• Created and executed test cases, logged and assigned defects, and kept track of the defect status
• Participated in designing performance test scripts using Load Runner.
• Communicated with the project management team and QA Lead to resolve defects
• Worked with end users to identify problems and reported the problems to software development.
• Performed detailed GAP analysis involving the current state and proposed state analysis. Critically evaluate information gathered from multiple sources and reconcile conflicts

Confidential, Nashville, TN / Layton, UT

Business/Test Analyst

Responsibilities:

• Involved in all phases of Project Life Cycle from Requirement gathering, Design, Development, Testing and Rollout to the field user
• Gathered requirements and prepared business requirement documents and developed requirements for functional improvements and enhancements.
• Defines application problem by conferring with clients; evaluating procedures and processes
• Wrote test scripts and test cases in HP Quality Center to meet assigned requirements.
• Participated in performance testing and completed test cases in HP Quality Center
• Tracked the status of defects and provided a status report during daily meetings
• Prepared and executed sql test scripts to test and validate the data in oracle database.
• Worked with creation of test scenarios and sample test of the real-time calculation.
• Created and executed test cases, logged and assigned defects, and kept track of the defect status
• Participated in designing performance test scripts using Load Runner.
• Communicated with the project management team and QA Lead to resolve defects
• Worked with end users to identify problems and reported the problems to software development.
• Performed detailed GAP analysis involving the current state and proposed state analysis. Critically evaluate information gathered from multiple sources and reconcile conflicts
• Conducted user acceptance testing to ensure that developed systems satisfied the needs of business clients as specified in the functional requirements.
• Designed developed and implemented user acceptance testing protocols as the final phase of applications development
• Participated in weekly bug status meetings to discuss open and closed issues
• Documentation of lessons and breaking down the requirements for respective modules.
• Provided KT to the new team members and mentored them in their individual tasks.

Confidential

Business Analyst and QA Tester

Responsibilities:

• Led cross-functional teams to analyze and understand the operational impacts and opportunities of technology changes.
• Documented process flows and developed requirements for functional improvements and enhancements.
• Point of contact and managed the offshore team by learning the technologies on which they were working on, Day to Day interaction with client and team (offshore and onsite) and provide status to the Business Team.
• Involved in all phases of Project Life Cycle from Requirement gathering, Design, Development, Testing and Rollout to the field user
• Assisted the Project Manager to develop both high-level and detailed application architecture to meet user requests and business needs
• Wrote, updated test plans and test cases and executed test cases
• Performed unit testing, functionality testing, system testing andUAT testing
• Maintaineddefectsand prepared defect reports
• Worked with end users to identify problems and reported the problems to software development
• Extensively used SQL to check Sybase database
• Participated in weekly bug status meetings to discuss open and closed issues

Confidential

Electrical Circuit Designer

Responsibilities:

• Worked as Intern at Confidential, with the Research and Development team
• Built a project with Ground fault detections for my Final year Project.
• Completed a Research on Harmonic Distortions at Airport Installations.