Applications Analyst

Agreeya Solutions Sunnyvale , CA 94085

Posted 4 days ago

Job Description:

  • Seeking analysts to be a technical resource in supporting our HCM data migration from legacy application and integrations definition for ERP/HCM implementation.

  • In addition, this role will provide primary IT technical support with various database (Oracle and SQL Server) and interface tools (scripting and reporting).

  • This position is required to participate in a hardcharging project environment, quickly analyzing and understanding legacy systems and help identify the best solutions in a timely manner utilizing database, programming and application analysis skills.

Required Skills/Experience:

  • Working knowledge of Oracle, Microsoft SQL Server, and Microsoft Access

  • Ability to learn and understand application data table structure to create database schemas and ability to conditionally extract data directly from data base to create complex database views with Strong SQL programming

  • Experience with Microsoft SQL Server and Oracle database backup/restore processes and Microsoft SQL Server SSIS

  • Define, manage and/or perform the design, testing, implementation and documentation of IT systems per agreed timelines, business requirements and organization standards in collaboration with internal business units

  • Experience developing interfaces and integration between different system

  • Extract & transform for data integration

  • Work as a crossfunctional team member, critically evaluate and manage user requests to ensure accurate prioritization and optimal resolutions

  • Lead communication with internal staff, business users, and technology service providers to bridge the requirement gaps and technical needs

  • 2+ years' experience in IT Applications

  • 2+ years' report development in Oracle BI Publisher, Crystal reports or SSRS

  • 4year degree or Master's degree related to Computer Science and Business Analyst

General Skills & Abilities:

  • Communications skills to define and document requirements

  • Excellent documentation skills

  • Willingness to document processes and procedures, enabler of turnover to production

Desired Skills/Experience:

  • Working experience of creating Oracle Packages/functions and Microsoft SQL Server stored procedures

  • Experience supporting application functions like Payroll, Time Reporting, Absences, Benefits, Position Budgeting and Core HR

  • Working experience of developing reports in Oracle Fusion including Oracle BI Publisher and OTBI

  • Working experience of Oracle Fast Formula, HCM extract

  • Experience with ASP.net programming

  • Experience working on interface development between finance/HR system (eP/NextGen) and Questica budget system

  • Experience with a publicsector agency

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
PLM Business Analyst
New!

Amick Brown, LLC

Posted Today

VIEW JOBS 1/29/2023 12:00:00 AM 2023-04-29T00:00 <span><span><span sans-serif""="">Amick Brown is seeking an experienced <b>Business Systems Analyst</b><b>3</b> for our direct client.</span></span></span><br><span><span><span sans-serif""=""><b>Location:</b><span>Sunnyvale</span>, CA</span></span></span><br><span><span><span sans-serif""=""><b>Duration:</b> 12 Months</span></span></span><br><i>Estimated pay range: $88 - $</i>110<i> an hour per client contract and candidate skills, experience and work location.</i><br><span><span><span sans-serif""=""><b>Description</b></span></span></span><ul><li style="padding: 0; margin: 0;"><span><span><span sans-serif""="">Enterprise Business Systems (EBS) – Product Lifecyle Management (PLM) team is seeking a Business Analyst who will drive PLM and its integrations business capabilities, process and system requirements with key Engineering, Business stakeholders and IT.</span></span></span></li></ul><span><span><span sans-serif""=""><b>Primary Function of Position </b></span></span></span><ul><li style="margin-left:8px"><span><span><span sans-serif""="">Work with Key Design and Manufacturing Engineering, Supply Chain, Regulatory stakeholders, users to determine operational objectives by studying business capabilities.</span></span></span></li><li style="margin-left:8px"><span><span><span sans-serif""="">Evaluate PLM and its integrations capabilities, systems feature, current process, identify pain points and draft logical data models as necessary.</span></span></span></li><li style="margin-left:8px"><span><span><span sans-serif""="">Coordinate quarterly business capability demands, requests and prioritization process.</span></span></span></li><li style="margin-left:8px"><span><span><span sans-serif""="">Identify optimization opportunities, write to-be process and system requirements. </span></span></span></li><li style="margin-left:8px"><span><span><span sans-serif""="">Review with Product Manager, key stakeholders and make required updates for streamlining and finalizing system requirements.</span></span></span></li><li style="margin-left:8px"><span><span><span sans-serif""="">Partner with IT on communicating requirements and Business test case scenarios, collaborate, resolve business side issues identified at various stages of systems development as applicable to launch the business requirements.</span></span></span></li><li style="margin-left:8px"><span><span><span sans-serif""="">Research and identify scope for improvement areas on PLM demands prioritization.</span></span></span></li><li style="margin-left:8px"><span><span><span sans-serif""="">Collaborate on identification and automating Business PLM Regression Test Scripts.</span></span></span></li></ul><span><span><span sans-serif""=""><b>Required Skills</b></span></span></span><ul><li style="margin-left:8px"><span><span><span sans-serif""="">Experience in implementing PLM system(s) and its integrations in past 5-7 years at a moderate to high PLM usage Medical Device or Pharma or Life Sciences or Hi-Tech manufacturing companies is highly preferred.</span></span></span></li><li style="margin-left:8px"><span><span><span sans-serif""="">Experience in designing business processes and creating requirements to build applications that supports PLM complex capabilities and requirements.</span></span></span></li><li style="margin-left:8px"><span><span><span sans-serif""="">Ability to identify, review and create Business test scenarios for User Acceptance Testing (UAT).</span></span></span></li><li style="margin-left:8px"><span><span><span sans-serif""="">Familiarity of Automated Testing process and tools, Robotic Process Automation (RPA).</span></span></span></li><li style="margin-left:8px"><span><span><span sans-serif""="">Minimum Bachelor's degree in Business or Technology related fields required or equivalent work experience.</span></span></span></li><li style="margin-left:8px"><span><span><span sans-serif""="">Minimum 10 years of Product Lifecyle Management domain experience working as a PLM Business Analyst and have worked in platforms like Oracle Agile/ Cloud, PTC Windchill, Siemens Team Center. Experience with Agile and Windchill is highly preferred.</span></span></span></li><li style="margin-left:8px"><span><span><span sans-serif""="">Experience working in Medical Device or Pharma or Life Sciences manufacturing domain is strongly preferred.</span></span></span></li><li style="margin-left:8px"><span><span><span sans-serif""="">Ability to operate and lead through ambiguity in a fast-paced Regulated environment.</span></span></span></li><li style="margin-left:8px"><span><span><span sans-serif""="">Proven ability and Energy to work with cross-functional teams and communicate with colleagues in both business and technical roles as required.</span></span></span></li><li style="margin-left:8px"><span><span><span sans-serif""="">Capability to work in Teams and or as individual contributor with minimal oversight.</span></span></span></li><li style="margin-left:8px"><span><span><span sans-serif""="">Excellent written and verbal communication skills with a proven ability to listen, understand and present information in a clear and concise manner to various technical, business stakeholders.</span></span></span></li></ul><span><span><span sans-serif""="">Amick Brown is an Information Technology consulting company specializing in ERP, Data Analytics, Information Security, Application Development, Networking, and Cloud Computing. The company was founded in 2010 and is headquartered in San Ramon, California.</span></span></span><br><span><span><span sans-serif""="">Regular full-time employees are eligible for the following Amick Brown provided benefits:</span></span></span><ul><li style="margin-left:8px"><span><span><span sans-serif""="">Vision</span></span></span></li><li style="margin-left:8px"><span><span><span sans-serif""="">Dental</span></span></span></li><li style="margin-left:8px"><span><span><span sans-serif""="">401k Health</span></span></span></li><li style="margin-left:8px"><span><span><span sans-serif""="">with company match</span></span></span></li><li style="margin-left:8px"><span><span><span sans-serif""="">Paid time off</span></span></span></li><li style="margin-left:8px"><span><span><span sans-serif""="">Sick Leave</span></span></span></li><li style="margin-left:8px"><span><span><span sans-serif""="">long-Term Disability</span></span></span></li><li style="margin-left:8px"><span><span><span sans-serif""="">Life Insurance</span></span></span></li><li style="margin-left:8px"><span><span><span sans-serif""="">Wellness & Discount Programs</span></span></span></li></ul> Amick Brown, LLC Sunnyvale CA

Applications Analyst

Agreeya Solutions