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 teh advancement and exceed expectations to excel within teh 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-TEMPeffective production with increased quality.
• Expert in identifying teh requirements and in finding teh system requirements
• Expertise in prepare Integration Test Plan which was used by functional team as well as development team.
• Skilled User Acceptance Tester understands teh 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 teh environment was ready for testing.
• Complete noledge of full software development life cycle (SDLC), co-ordination with teh testing team (Testing Centre of Excellence) and generate complex test scripts to capture teh 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 teh 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 teh business requirements.
• Evaluating existing data systems and integrate new requirements into teh existing system.
• Working with teh development team to create conceptual data models and data flows.
• Developing best practices for data coding to ensure consistency within teh 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 teh 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 teh 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 teh 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 teh 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 teh 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 teh 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 teh Confidential products
• Validate that mappings has been implemented correctly and that data flows properly through teh 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 teh field user
• Gatheird 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 teh status of defects and provided a status report during daily meetings
• Prepared and executed sql test scripts to test and validate teh data in oracle database.
• Worked with creation of test scenarios and sample test of teh real-time calculation.
• Worked on Fitnesse tool, to verify teh calculator’s logic required for teh respective processors.
• Created and executed test cases, logged and assigned defects, and kept track of teh defect status
• Participated in designing performance test scripts using Load Runner.
• Communicated with teh project management team and QA Lead to resolve defects
• Worked with end users to identify problems and reported teh problems to software development.
• Performed detailed GAP analysis involving teh current state and proposed state analysis. Critically evaluate information gatheird 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 teh field user
• Gatheird 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 teh status of defects and provided a status report during daily meetings
• Prepared and executed sql test scripts to test and validate teh data in oracle database.
• Worked with creation of test scenarios and sample test of teh real-time calculation.
• Created and executed test cases, logged and assigned defects, and kept track of teh defect status
• Participated in designing performance test scripts using Load Runner.
• Communicated with teh project management team and QA Lead to resolve defects
• Worked with end users to identify problems and reported teh problems to software development.
• Performed detailed GAP analysis involving teh current state and proposed state analysis. Critically evaluate information gatheird from multiple sources and reconcile conflicts
• Conducted user acceptance testing to ensure that developed systems satisfied teh needs of business clients as specified in teh functional requirements.
• Designed developed and implemented user acceptance testing protocols as teh final phase of applications development
• Participated in weekly bug status meetings to discuss open and closed issues
• Documentation of lessons and breaking down teh requirements for respective modules.
• Provided KT to teh 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 teh operational impacts and opportunities of technology changes.
• Documented process flows and developed requirements for functional improvements and enhancements.
• Point of contact and managed teh offshore team by learning teh technologies on which they were working on, Day to Day interaction with client and team (offshore and onsite) and provide status to teh Business Team.
• Involved in all phases of Project Life Cycle from Requirement gathering, Design, Development, Testing and Rollout to teh field user
• Assisted teh 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 teh 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 teh 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.