Oracle EBS R12 Techno- Functional- SCM and Manufacturing

Job Description: 

We are looking for an experienced SQL Developer to become a valued member of our dynamic team. In the role of SQL Developer, you will be tasked with creating top-notch database solutions, fine-tuning SQL databases, and providing support for our applications and systems. Your proficiency in SQL database design, development, and optimization will be instrumental in delivering efficient and dependable solutions to fulfil our business requirements.

Responsibilities:

 ● Create high-quality database solutions that align with the organization's requirements and standards.

● Design, manage, and fine-tune SQL databases, queries, and procedures to achieve optimal performance and scalability.

● Collaborate on the development of DBT pipelines to facilitate data transformation and modelling within our data warehouse.

● Evaluate and interpret ongoing business report requirements, gaining a clear understanding of the data necessary for insightful reporting.

● Conduct research to gather the essential data for constructing relevant and valuable reporting materials for stakeholders.

● Analyse existing SQL queries to identify areas for performance enhancements, implementing optimizations for greater efficiency.

● Propose new queries to extract meaningful insights from the data and enhance reporting capabilities.

● Develop procedures and scripts to ensure smooth data migration between systems, safeguarding data integrity.

● Deliver timely management reports on a scheduled basis to support decision-making processes.

● Investigate exceptions related to asset movements to maintain accurate and dependable data records.

Duties and Responsibilities: 

● A minimum of 3 years of hands-on experience in SQL development and administration, showcasing a strong proficiency in database management.

● A solid grasp of SQL database design, development, and optimization techniques.

● A Bachelor's degree in Computer Science, Information Technology, or a related field.

● An excellent understanding of DBT (Data Build Tool) and its practical application in data transformation and modelling.

● Proficiency in either Python or JavaScript, as these are commonly utilized for data-related tasks.

● Familiarity with NoSQL databases and their practical application in specific scenarios.

● Demonstrated commitment and pride in your work, with a focus on contributing to the company's overall success.

● Strong problem-solving skills and the ability to collaborate effectively within a team environment.

● Excellent interpersonal and communication skills that facilitate productive collaboration with colleagues and stakeholders.

● Familiarity with Agile development methodologies and tools that promote efficient project management and teamwork.

REQUIREMENTS

Core skills:

● Technical Experience (Must have) - working knowledge of any visualization tool

(Metabase,Tableau, QlikSense, Looker, Superset, Power BI etc), strong SQL & Python,

Excel/Gsheet

● Product Knowledge (Must have)- Knowledge of Google Analytics/ BigQuery or

Mixpanel, must have worked on A/B testing & events writing.Must be familiar with

product (app,website) data and have good product sense

● Analytical Thinking: Outstanding analytical and problem-solving skills. ability to break

the problem statement during execution.

Core Experience:

● Overall experience of 2-5 years in the analytics domain

● He/she should have hands-on experience in the analytics domain around making Data

Story Dashboards, doing RCA & analyzing data.

● Understand and hands-on experience of the Product i.e funnels, A/B experiment etc.

● Ability to define the right metric for a specific product feature or experiment & do the

impact analysis.

● Ability to explain complex data insights to a wider audience & tell us the next steps &

recommendations

● Experience in analyzing, exploring, and mining large data sets to support reporting and

ad-hoc analysis

● Strong attention to detail and accuracy of output.

Looking for a passionate Production Support Lead and team player who wants to learn, contribute and bring fun & energy to the team. We are a friendly startup where we provide opportunities to explore and learn a lot of things(new technology/tools etc.,) in building quality products using best-in-class technology.

Responsibilities :

·  Customer Relationship Management

·   Incident Management. Manage ticket queue and resolve it in timely manner.

·   Analyzing the incidents and either responding to the end user with a solution or escalating it to the other IT teams.

·  Troubleshoot minor and major system problems in a timely manner and escalate to L3 support when necessary.

·  SLA Management

·  Develop and maintain accurate technical and user documentation.

·  Working with QA to ensure the quality and timing of new release deployments.

Skills/Experience :

·  Strong analytical and problem-solving skills and interest in learning new things will be the key.

·  Excellent interpersonal skills handling internal and external customers

·  About 3 years of professional experience in providing product support in leading BFSI sector organisations

·  Experience in any DB (SQL/noSQL)

·  Testing Exposure will be an added advantage

• Collaborate with different teams to implement standards.
• Lead performance improvement projects.
• Work closely and influence global teams for process improvements.
• Execute project milestones promptly & effectively communicate progress to stakeholders.

Technical skills:

• Strong SQL skills (RDBMS / SnowFlake).
• Able to program in multiple languages (SAS, JavaScript).
• Functional knowledge on Supply chain & Logistics.

Soft skills:

• Ability to translate business requirements into data solutions.
• Above average initiative.
• Adaptability to changing priorities.
• Strong customer focus and ability to work effectively with a wide variety of people.
• Has the ability to work independently as well as in a team.
• Eager to learn & improve, continuously hones their skills.
• Strong solution-oriented analytic skills and shows creativity in their problem-solving.
• Has great attention to detail without losing sight of the big picture.
• Has great communication skills – Is able to represent the architect team, address their needs & requirements in meetings with process partners (inside & outside of the greater team).
• Must be willing to work in different shifts to have enough overlap with global team.

Introduction

http://www.synapsica.com/">Synapsica is a https://yourstory.com/2021/06/funding-alert-synapsica-healthcare-ivycap-ventures-endiya-partners/">series-A funded HealthTech startup founded by alumni from IIT Kharagpur, AIIMS New Delhi, and IIM Ahmedabad. We believe healthcare needs to be transparent and objective while being affordable. Every patient has the right to know exactly what is happening in their bodies and they don't have to rely on cryptic 2 liners given to them as a diagnosis. 

Towards this aim, we are building an artificial intelligence enabled cloud based platform to analyse medical images and create v2.0 of advanced radiology reporting.  We are backed by IvyCap, Endia Partners, YCombinator and other investors from India, US, and Japan. We are proud to have GE and The Spinal Kinetics as our partners. Here’s a small sample of what we’re building: https://www.youtube.com/watch?v=FR6a94Tqqls">https://www.youtube.com/watch?v=FR6a94Tqqls

Your Roles and Responsibilities

The senior product manager will own end-to-end delivery of Synapisca’s AI based radiology products including defining scope, creating wireframes, creating execution plan, product launch, feedback incorporation and iterations. In this role you would not only get to flex your skills but also learn to thrive in a fast-paced start-up environment with a high degree of autonomy. This cross-functional leadership position requires you to work closely with the Engineering, Design, Category Management and Marketing teams to bring new products to life.

Being comfortable in the chaos of a fast-paced environment, dealing with ambiguity, a penchant for innovation, an innate ability to get into details and drive execution excellence is essential to success in this profile.The candidate must be creative, ask questions, and be comfortable challenging the status quo. The position is based in our Bangalore office.

Primary Responsibilities

• Building and executing new initiatives and roadmaps for retention and increasing customer lifetime value.
• Understand the healthcare market, customers and build business cases for new product opportunities.
• Listen to the users on a regular basis and figure out the opportunities to solve their problems.
• Manage product lifecycle from ideation to launch and beyond which would include liaising with multiple stake-holders.
• Work closely with partners and clients from 4 continents to localize the product builds as per their need and ensure adoption of the new features.
• Use data, creativity, and experimentation to constantly improve the product experience
• Plan product reviews with engineering teams and reviews with leadership. 
• Work on product roadmap, backlog, and deliverables. 
• Create and socialize artifacts that clearly communicate requirements including BRDs, user flows, and prototypes.  
• Formulate hypotheses and quickly validate with prototypes, user feedback, and experimentation.  
• Work with customers, support, and engineering teams to handle and resolve any critical customer issues that arise.

Requirements

• 5+ years in software product management with a consistent record of timely and quality delivery of software products
• Experience in one or more of the following is a plus: SaaS, HealthTech, Enterprise products etc.
• High bias for action with demonstrable history of identifying and resolving cross-project interdependencies
• Ability to juggle several initiatives and shift priorities as needed
• Exceptional communication skills (verbal and written communication) with a knack for storytelling
• Data Driven with proficiency on data querying and analysis.
• Experience with tools like SQL, Excel, Tableau, Qlikview etc. is preferred
• Have prior experience in the development team and understand how modern development frameworks function.
• Passionate about translating customer needs to usable design and process flows for growth levers and optimization.
• Have Good understanding of funnels, agile & sprints, and wireframes.
• Have the attitude to be comfortable with ambiguity and have the skill to transform broad ideas into action plans and display Empathy towards users and also your colleagues.
• Understand how the application functions and the technicalities around it.
• Have familiarity with tools like Google data studio, Firebase, Google Analytics, Product Analytics tools, Sketch and Figma.
• Love analytics and very frequent experimentation

The role provides L2 and L3 support and IS services to F&PA community using the Cognos Controller Applications

1. Problem determination / troubleshooting and root cause analysis skills for our IBM Cognos Controller Cloud and On-Premises offerings 
2. Create or enhance knowledge assets for our Knowledge Base (how-to guides, technical notes or similar).
3. Contribute to key operational metrics: for example: NPS, initial response times, backlog management, Time to Resolution

Technical expertise:

1. Previous experience with IBM Cognos Controller, Planning Analytics, or equivalent financial consolidation software (e.g. Anaplan, Tagetek, OneStream, Vena Financial Close Management, Oracle Financial Consolidation, ) 
2. Web tier technologies 
3. Network administration 
4. Web applications 
5. Databases (SQL Server Oracle, DB2) 
6. Strong troubleshooting communication skills 
7. Demonstrated organization and time management skills 
8. Demonstrated verbal and written communication skills 
9. Must be self-motivated and disciplined 
10. Ability to recognize and prioritize critical tasks independently

1. Strong in IBM Cognos Controller 10x expertise 2. Strong SQL knowledge (Oracle, MS SQL Server) 3. Good in Data-warehousing concepts with cognos schema  4. Preferred Knowledge on Cognos finance products - Planning/TM1 5. Excellent communication skills  

cognos Controller 10.4.2 -On premise experience - this is the keyword for the search for Cognos Controller.

• Check the Cmg's and take the requirements from functional consultants and users.
• As per business logic (MD50) do change existing reports and develop the new reports.
• Developing new packages, procedures, functions and updating existing packages and procedures, functions.
• Developing the workflows.
• Developing the API's as per business logic's for data updates.
• Developing the data extraction automation programs (.sql files developments) for data extractions.
• Prepare the test cases and migration documents for migrating objects.

• Bachelor's Degree in IT/ Computers/ Science or Master's in Computer required.
• 2 - 5 years of relevant experience on Oracle Apps Technical.
• Candidates must have hands on experience on Oracle RDF/XML/Pl-SQL Reports, D2k Forms, Workflow, OAF, And functional knowledge on O2C & P2P.

• The role will be part time (15-20 hours per week) with scheduled weekend availability.
• LINC Fellows will be “actively engaged” when a unit (subject) is assigned. A unit will range from 7 to 14 weeks at a time.
• LINC Fellows are required to provide 2-3 hrs each afternoon (between noon to 5pm) every day when they are supporting students.
• Candidate will have flexibility to work from location of his/her convenience.

• Interacting with high-quality global university faculty
• Working with a diverse range of international students
• Developing deeper subject understanding
• Gaining richer academic exposure
• Improving interpersonal and cross-cultural skills

• PG/Doctoral degree with distinction or first-class from a top university in India
• 5-10 years of corporate experience and/or teaching experience in the fields like Marketing, Finance, Operations, Organization/HR, Data Analytics, Project Management, Strategy and Ethics at a leading university or college (note: at least 1 year formal teaching experience at a university of college is a MUST).
• Empathetic, ambitious, warm and outgoing personality willing to work closely with people from diverse culture
• Proficient in English language
• Must possess a working laptop and have access to high-speed (>2 MBPS) stable internet connection
• Ability to quickly learn and use technology platforms for interacting with student including host university’s Learning Management System and LINC's technology platform (training on these platforms will be provided)