For the given job description <<General Summary
The Sr Business Systems Database Software Engineer will be a key player in designing, implementing, and optimizing our data architecture to support our production, accounting, business intelligence, and financial reporting functions. This position will collaborate closely with cross-functional teams, including production, finance, technology and operations, to ensure seamless data integration and provide actionable insights for strategic decision-making.
Job Functions
Design, administer and maintain a robust and scalable data warehouse for our Solver-based Corporate Performance Management (CPM) system within the Microsoft Azure cloud environment.Utilize domain knowledge of production tracking tools such as ShotGrid and Ftrack to streamline data collection and analysis processes, feeding into the data warehouse.Manage Azure based SQL databases, ensure data integrity, performance and security for both the data warehouse and other relevant databases.Develop and optimize Python APIs to facilitate efficient and secure data access and retrieval from the data warehouse.Collaborate with Accounting and Finance departments to gather, transform and integrate financial data into the data warehouse architecture for accurate financial and operational reporting.Build comprehensive and insightful financial and operational reports, leveraging the data warehouse.Create and implement well-organized data collection processes and thoughtful schema taxonomies to ensure data accuracy, consistency and ease of reporting.Take a hands-on approach in a green space to build new financial and operational reporting processes and operations that span various departments and workflows.Provide ongoing support and troubleshooting for data-related issues, ensuring data quality and availability for reporting purposes.
Qualifications
5+ years of professional experience in Computer Science, Information Technology, Finance or a related field as a Database Architect, Database Engineer or similar role.Proficiency in Microsoft Azure services and architecture, with experience in designing and implementing cloud-based data warehousing solutions, required.Strong working knowledge of SQL databases, data modeling, and performance optimization techniques.Proven experience developing Python APIs for data retrieval and integration.Demonstrated ability to collaborate effectively with cross-functional teams, including production, finance, technology and operations departments.Expertise in working with production tracking tools such as ShotGrid and Ftrack.Advanced skills in Microsoft Excel for building financial and operational reports.Excellent problem-solving skills and the ability to navigate complex business and financial requirements.Strong communication skills, both written and verbal, with the ability to convey technical concepts to non-technical stakeholders.Self-motivated, detail-oriented and adaptable to changing business needs.A passion for continuous learning and a proactive attitude towards exploring advanced topics and emerging technologies.
Physical Demands and Work Environment
The physical demands and work environment characteristics described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Physical demands: While performing the duties of this job, the employee is required to walk; stand; sit; use hands to operate standard office equipment; reach with hands and arms; balance; stoop; talk or hear both in person and by telephone. The employee must lift andor move up to 15 pounds. Vision abilities include close vision, distance vision, and the ability to adjust focus.Work environment: While performing the duties of this job, the employee works under typical office conditions and is exposed to variable indoor temperatures. The noise level is usually quiet or moderate.
Location
On-site in Hillsboro, OR  and also eligible for hybrid work  Remote Eligible.
Salary
Salary Is Commensurate With Skills And Experience.
Disclaimer
The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not intended to be construed as an exhaustive list of all responsibilities, duties and skills required of personnel so classified.
Please review our EMPLOYMENT DISCLAIMER and MATERIALS SUBMISSION AGREEMENT.>> the resume: <<ProfileSkilled, motivated and result-driven Quality Assurance professional with 6+ years of experience in the field of Manual and Automation software testing. 3 years of vast experience in developing  Keyword Driven framework/Hybrid Framework in Selenium using Java. Extensive experience in software development methodologies like SDLC , STLC in both Agile and Waterfall models. Proven expertise in working on different types of test deliverables - Test Plan ,Test Cases, Testing Strategy, Test scripts, Test data, Test Traceability matrix, Test reports, Test summary reports, Install/Config guides, Defect Reports, Release notes for Web based commerce applications , CMS applications and Banking applications. Successfully lead the team and completed set of software testing projects developed in Java and .Net Technologies. Proven experience in using Test management and Defect tracking system such as Jira, Bugzilla, Test Link , Test Rail, QC. Vast experience in performing Boundary Values Analysis, Equivalent Classes partitioning, Smoke (Sanity), Functional, Integration, System, Regression, Ad-hoc (Exploratory), Cross-Browser, User Interface and User Acceptance tests, Web based testing, Security testing and Performance testing. Proficient in multiplatform (Windows and Mac OS) and cross browser testing (IE, Firefox, Chrome, Safari, Opera) as well as Mobile testing on different devices (Android, iOS, Windows Phone). Very Good Experience in leading the QA team, mentoring and guiding the team. Very well acquainted with Defect management, Defect reporting, Defect Triaging, Detailed analysis of the reported issue(RCA), follow-up and resolve outstanding defects/issues. Possess extensive experience in analysing the Business Requirement Documents, Functional Specifications and Technical Specifications. Possess knowledge of web technologies like HTML, CSS, JavaScript, VB Script, XML, Java, C and C++. Proficient in writing PL/SQL programs.
Core QualificationsDefect Tracking Tools and Test Management Tool  : JIRA, Bugzilla, Test Rail, Test Link ,HP ALM/QCAutomation Testing Tool : Selenium IDE, Selenium Web Driver ,Selenium GridApplications : MS-Word, MS-Excel, MS-Power point, MS-SharePoint ,MS Office, MS OutlookConfiguration Management tool : SVN, JenkinsCode Management tool : Git MySQL, NoSQLProgramming Languages : C, C++, Java, UNIX, JavaScript, VBScript, XML, HTMLOperating Systems : Windows XP/Vista/7 , Mac OS X and LINUX.Mobile Platforms : Windows Phone, iOS, Android OS Tridion, Firebug, Chrome Developer Tool, Browser Cam, CSSPerformance Testing Tools  : Apache Bench, HttperfTest Methodologies  : Test Plan, Test Strategy, Test case, Requirement Traceability Matrix, Production Test Management Checklist, Best Practices, Test execution Report, Defect Report, Defect Triage, RCA Report, Daily/Weekly QA Status Report.Tests 2Tesst 3Tests 4
EducationPune University,Expected in––B.Tech:Computer Science and Engineering-GPA:Computer Science and Engineering,Expected in––ISTQB Certification:-GPA:In house training on Selenium framework development using JAVA
Professional ExperienceAdp-Senior Software QA TesterFairport,,INDIA11/2012-11/2015Project name: DIESEL-USA, DIESEL CANADA, Digital Store Solution, TD-Accounts Componentization Served as a critical member of software testing team as a Senior QA Tester on development projects for E-Commerce projects and banking projects.Supervised three junior software QA Testers in developing and implementing quality-assurance and quality-control methodologies to ensure compliance with QA standards and customer specifications.Analysed & studied various Project Artifacts such as Business Requirements, System Requirements and Use Cases to develop and execute Manual Test cases for testing application on supported browser combinations, Mobile and Tablet.As a Senior QA Tester participated in Test estimation and created Test Strategy for Diesel USA Project, Diesel Canada Project.Designed Build Acceptance Test, Regression Test, Functional Test Script, UAT and Adhoc Test Scenarios.Created RTM (Requirement Traceability Matrix) to match requirement specifications.Reviewed Test cases and Conducted Peer reviews meetings with the team.Provided Detailed Walkthrough of Test Plans and Test Cases to Project team.Participated in Design Reviews and Software Development Life Cycle (SDLC) process from application requirement and specification gathering stage through final release till Go-Live.Involved in planning and execution of the Regression and IST testing for various releases.Created, modified and executed various types of Manual Test Cases for Functional, Integration, and Regression Testing within limited timeframe & releases.Logged and tracked defects to closure using JIRA and follow up with Business and Developers to discuss about the issues.Worked with different modules of JIRA such as Requirements, Test Plan, Test Lab, Defects and Dashboard module.Provided support for End-to-End Testing as and when required.Supported the team with quick production patches, hot fixes, monthly releases and new feature releases.Signing off the final build before it is pushed to production.Attended daily calls with onshore, to keep the group updated on any issues/client dependencies/third party dependencies and followed up till closure.Worked with the Project Manager to identify resources, scope and limitations of testing.Prepared and published Test Summary Report at the end of the day with results of readiness of system deployment to production/test environment.Preparing weekly Testing Progress report and presenting to onsite and offsite team.Identify Applications risks, issues and set priorities, contributing in triaging of defects for upcoming Internal and Client demo.Resolved queries by coordinating with different teams like Development and Environment teams.Identified Sanity Test Cases and Business Processes for automation and designing of automation test plan.Worked on manual test cases using Element locators, Web Driver methods, Java programming features, and TestNG Annotations for automating sanity scripts.Experience in POM framework development using selenium web driver.Executed multiple manual test cases using compatibility and accessibility tool.Niantic-Senior QA EngineerSan Francisco,,INDIA02/2012-03/2012Project name: Shaadi.com Payments The Company has developed world's largest matrimonial website that provides a superior match making experience to customers while zealously protecting their privacy and security.As a senior member of software testing I was involved in understanding the complex business flow, gathering the unsaid requirements, documenting it ,getting it reviewed, and designing online payment manual test cases for functional testing phase.Was also involved in writing selenium script for sanity phase using TestNG.Tested the application on mobile and tablet as well.Worked in an Agile environment and participated in all phases of a project -Functional specification understanding, Document vision, Business need, Use case, Test Case and any other document relevant to project.Created Test Strategy and Test cases and data for testing based on requirements.Prepared Project Test Plan to outline scope, objectives and approach of software testing efforts.Executed regression scripts using TestNG.Conducted walkthroughs and meetings with project team, end users/application owners to understand the application/SRS document.Attended TRD (Technical Requirement Document) review to meet specification for PRD.Attended PRD (Project Requirements Document) review to determine business requirements both functional and non-functional.Performed software requirements traceability analysis to trace software requirements to (and from) system requirements and to risk analysis results.Utilized JIRA to execute and track test cases and manage defects from inception to resolution Participated in continuous quality improvement of established testing processes and standards.Assisted in defect reporting in an effort to communicate to the appropriate personnel of the various stages of defects.Supported the design, development, testing and implementation of new business and support applications.Conduent Incorporated-QA TesterCheyenne,,INDIA12/2010-11/2011Project name: Mass Shipments Update Framework, Integrated Management of Orders and Shipments Responsibilities: This Framework was developed keeping in mind the Integrated Logistics Solution to ensure accurate orders of product and improved deliveries, total visibility into inventory allowing link with every process in the supply chain.I was the sole member responsible for understanding end-to-end business need, discussion the specification with onsite team, designing test scenarios based on use cases and business requirements, communicate and co-ordinate with development team on issues/defects as per test executions, logging the defects, analysing the test results and prepare the test report and demoing the changes to Client.Contributions: Planning and estimating product development using Agile estimation technique following Agile methodology.Identified Test scenarios based on User stories, Requirements and scripting Test cases.Tracking changes in requirements and mapping them with the Test scenarios by creating RTM.Logging defects in JIRA.Running Smoke test on Development and Test environment after every deployment.Executing Functional and non functional testing.Tracking Burn down and SP chart on daily basis in JIRA.Submitting defects reports and Test execution reports on a daily and weekly basis.Managing sprints conducting daily stand-ups, attending planning , review, defect triage, scrum of scrum and daily/weekly QA calls.Algorithm Computers-Software Test EngineerCity,,INDIA02/2008-11/2010It was a Web development for online banking.Integrated Learning Management system was a complete end-to-end e-learning solution, including Resume Tracker System, Discussion forum, collaboration tools, and Training Management System.I prepared and executed the test cases as per the functional specifications, performed Functional testing, Integration Testing and Regression Testing and Reporting of bugs using Bug tracking tool.Contributions: Worked on multiple projects as a QA Tester during my tenure.Created test cases and data for regression and integration testing based on requirements.Worked in an iterative development environment and participate in all phases of a project - Document vision, business needs, use cases, test cases, and any other documentation that is relevant to the project.Analysed complete business requirements to understand the business logic of the application.Participated in Regression testing after each build.Created defects to keep track of issues related to code bug.Tested data in database by writing SQL Queries.Performed the tasks of interpreting testing results and developing continuous improvement process.
SkillsGo-Live, Agile, Apache, approach, Automation, banking, Business Processes, C, C++, com, Configuration Management, continuous improvement, CSS, Client, Databases, database, designing, documentation, E-Commerce, estimating, XML, features, Functional, HP, HTML, IDE, inventory, Java, Java programming, JavaScript, LINUX, Logging, logic, Logistics, Mac OS, Managing, meetings, MS-Excel, MS Office, MS Outlook, Power point, SharePoint, Windows, Windows XP, MS-Word, MySQL, NoSQL, Operating Systems, OS, Developer, personnel, presenting, processes, product development, Programming, Progress, quality improvement, QA, quality-control, quality-assurance, quick, reporting, Requirement, risk analysis, scrum, SDLC, scripting, scripts, Script, Software Development, software testing I, software testing, specification, SQL, stories, Strategy, supply chain, Phone, Triage, UNIX, VBScript, vision, Vista, Web Development, website>>. The result is, Potential Fit

Fit assessment: Potential Fit