5 Complex Formulas Jobs

Account Activity Review Operations Expert - AVP Position Overview Job Title: Account Activity Review Operations Expert - AVP Location: Bangalore, India Shift timings: UK Shift Role Description The Financial Crime Control Continuous Improvement Centre of Excellence (FCCI CoE) operates within KYC Operations under the Client Aligned Delivery functions. FCCI collaborates with the front office and supports Accountable Client Owners (ACOs) in reviewing Account Activity Review (AAR) and assessing the Expected Nature and Purpose of Relationship (ENPR). The role involves using an automated account activity surveillance platform that monitors irregularities and generates alerts when notable deviations from expected behaviour are detected. Responsibilities include global collaboration with ACOs, analysis of Corporate and Investment Banking (CIB) product transactions, validation of alerts based on established criteria, documentation of plausibility & risk observations regarding flagged activities, and updating ENPR. The role also supports ongoing improvement initiatives to reduce ACO workload by optimizing AAR and ENPR operational controls and effectiveness. What we'll offer you As part of our flexible scheme, here are just some of the benefits that you'll enjoy, Best in class leave policy. Gender neutral parental leaves 100% reimbursement under childcare assistance benefit (gender neutral) Sponsorship for Industry relevant certifications and education Employee Assistance Program for you and your family members Comprehensive Hospitalization Insurance for you and your dependents Accident and Term life Insurance Complementary Health screening for 35 yrs. and above Your key responsibilities Conduct Annual Account Activity Reviews (AAR) and Expected Nature and Purpose of Relationship (ENPR) assessments for Corporate and Global Markets clients while ensuring compliance with regulatory requirements and internal standards. Review dynamic account activity review alerts generated by automated monitoring system, evaluate transactional behaviour against expected client activity, and provide comprehensive, well-reasoned commentary to support the closure of alerts. Proactively facilitate the resolution of AAR and ENPR tasks by coordinating with ACOs, Business Support, and Quality Control teams. Manage shared mailbox inquiries from business and support team, delivering prompt issue resolution or escalation when appropriate. Consistently maintain production trackers and management information (MI), reconcile AAR and ENPR data using Excel, and generate both ad-hoc and regular MI reports for governance forums and business stakeholder distribution. Act as a subject matter expert, provide advisory support to ACO on complex control requirements and offer training and mentorship to junior staff to foster continuous learning and effective knowledge sharing. Prepare, update, and manage process documentation, Key Operating Documents (KODs), procedures, and governance materials including PowerPoint presentations. Establish and nurture strong partnerships with key stakeholders, such as Business, Quality Control, Technology, and Change Teams, to enhance collaboration, streamline processes, and address operational challenges efficiently. Take ownership of operational issues, collaborating with relevant teams to drive timely resolution and ensure closure of action items. Your skills and experience Minimum 10 years of experience in Account Activity Reviews, AML/KYC processes and background in front or middle office support is beneficial. Understanding of corporate and global market products, underlying risks, clients, and industries. Experience in writing risk assessment summaries, disposition and plausibility commentaries or escalation reports to evaluate actual activity against expected behaviour. Documentation and communication skills, including drafting process manuals, KODs, and materials for training or senior forum presentation. Experience managing mailboxes, handling escalations, and ensuring resolutions within expected timelines. Strong communication skills in English, with proficiency in MS Outlook, Word and PowerPoint. Advanced Excel skills (macros, pivot tables, and complex formulas) for data reconciliation and MI reporting (tableau dashboard experience advantageous). Knowledge of change management, requirements analysis, UAT and continuous improvement process. Strong interpersonal skills for effective collaboration with global cross-functional teams, including business, compliance, technology, and operations. Strong organizational, time management and problem-solving skills, and ability to deliver high-quality results under pressure . How we'll support you Training and development to help you excel in your career. Coaching and support from experts in your team. A culture of continuous learning to aid progression. A range of flexible benefits that you can tailor to suit your needs. About us and our teams Please visit our company website for further information: We strive for a in which we are empowered to excel together every day. This includes acting responsibly, thinking commercially, taking initiative and working collaboratively. Together we share and celebrate the successes of our people. Together we are Deutsche Bank Group. We welcome applications from all people and promote a positive, fair and inclusive work environment.

Description Senior Project Specialist (Hyderabad location) Syneos Health is a leading fully integrated biopharmaceutical solutions organization built to accelerate customer success. We translate unique clinical, medical affairs and commercial insights into outcomes to address modern market realities. Our Clinical Development model brings the customer and the patient to the center of everything that we do. We are continuously looking for ways to simplify and streamline our work to not only make Syneos Health easier to work with, but to make us easier to work for. Whether you join us in a Functional Service Provider partnership or a Full-Service environment, you'll collaborate with passionate problem solvers, innovating as a team to help our customers achieve their goals. We are agile and driven to accelerate the delivery of therapies, because we are passionate to change lives. Discover what our 29,000 employees, across 110 countries already know: WORK HERE MATTERS EVERYWHERE Why Syneos Health We are passionate about developing our people, through career development and progression supportive and engaged line management technical and therapeutic area training peer recognition and total rewards program. We are committed to our Total Self culture - where you can authentically be yourself. Our Total Self culture is what unites us globally, and we are dedicated to taking care of our people. We are continuously building the company we all want to work for and our customers want to work with. Why Because when we bring together diversity of thoughts, backgrounds, cultures, and perspectives - we're able to create a place where everyone feels like they belong. Job Responsibilities Minimum3+ yearsof relevantproject specialist experience. Excellent proficiency inAdvanced Microsoft Excel, including Pivot tables,VLOOKUP/XLOOKUP and Complex formulas Leadmonthly finance activitiesand providefinancial analysisto support decision-making. Maintain and enhancefinancial tracking toolsand documentation. Collaborate withinternal teamsandexternal stakeholdersto ensure accurate and timely reporting. Candidate from Hyderabad and Gurgaon preferre d Set-up, maintain and close out project files and study information ((e.g., KPIs, regulatory documents, Trial Master File (TMF), enrollment, Adverse Events (AEs)/Serious Adverse Events (SAEs), protocol deviations, site supplies, Institutional Review Board re-approvals, data queries) on a variety of databases and systems. Maintain and distribute study-specific /financial reports (e.g. vendor/site invoices, investigator payments (grants and pass-through), forecasts, etc). May lead internal and external meetings as directed by the PL Prepares and distributes meeting minutes and action items for both internal and external meetings (sponsor, trusted process, functional, investigator meetings). Follows up with team members on action items to closure. Records the status of Key Performance Indicators (KPIs) in assigned systems, with input and oversight from the assigned PL. Assesses and communicates KPIs for associated job tasks to PL with proposed action plan. Prepares and provides status reports to customers with oversight from assigned PL Ensure all study documents are archived based on the appropriate guidelines and policy. May serve as project representative for internal and external audits. Provide support for quality assurance activities, including preparation for audits and internal review, preparing documentation and follow through to resolution actionable issues. May serve as primary customer contact when PL is out of the office. Seeks input from Project Director for customer support. May mentor and train Project Specialists Get to know Syneos Health Over the past 5 years, we have worked with 94% of all Novel FDA Approved Drugs, 95% of EMA Authorized Products and over 200 Studies across 73,000 Sites and 675,000+ Trial patients. No matter what your role is, you'll take the initiative and challenge the status quo with us in a highly competitive and ever-changing environment. Learn more about Syneos Health. Additional Information Tasks, duties, and responsibilities as listed in this job description are not exhaustive. The Company, at its sole discretion and with no prior notice, may assign other tasks, duties, and job responsibilities. Equivalent experience, skills, and/or education will also be considered so qualifications of incumbents may differ from those listed in the Job Description. The Company, at its sole discretion, will determine what constitutes as equivalent to the qualifications described above. Further, nothing contained herein should be construed to create an employment contract. Occasionally, required skills/experiences for jobs are expressed in brief terms. Any language contained herein is intended to fully comply with all obligations imposed by the legislation of each country in which it operates, including the implementation of the EU Equality Directive, in relation to the recruitment and employment of its employees. The Company is committed to compliance with the Americans with Disabilities Act, including the provision of reasonable accommodations, when appropriate, to assist employees or applicants to perform the essential functions of the job. Summary The Senior Project Specialist is responsible for maintaining and coordinating the logistical aspects of clinical projects, and provides overall support to functional leads to ensure the successful completion of project deliverables The Senior Project Specialists supports the Project Lead (PL) to ensure the contracted services and expectations of assigned projects are carried out by the project teams in accordance with executed contracts and the customers requirements. Operate independently, with minimal day to day oversight, and may co-ordinate the activities of Project Specialists

The ideal candidate should have a strong working knowledge of advanced Excel including pivot tables, VLOOKUP, macros, and complex formulas. Your key responsibilities will include validating salary structures, attendance, overtime, leave data, and statutory deductions. You will also be responsible for ensuring timely compliance for PF, ESI, PT, LWF, TDS, and all applicable labor laws, handling audits, inspections, and liaising with statutory authorities. You will leverage advanced Excel for reconciliations, dashboards, and data analytics. Additionally, you will drive automation, process improvement, and system upgrades to increase efficiency and accuracy, and implement strong internal controls and compliance protocols. The candidate must possess an in-depth understanding of multi-state statutory compliance, proficiency in advanced Excel, strong analytical, problem-solving, and stakeholder management skills. A Bachelor's degree in Commerce/HR/Finance is required, with an MBA being preferred. This is an on-site position with 6 days working, Monday to Saturday. Immediate joiners are preferred. The salary will be within a specified range with additional benefits.,

As a skilled professional, you will be responsible for generating and distributing management reports accurately and in a timely manner. Utilizing your expertise in Advanced Excel, you will leverage pivot tables, look-ups, complex formulas, and graphing techniques to enhance business processes efficiently. Your role will involve comprehending intricate data sets, conducting analysis, and creating insightful reports and dashboards to aid decision-making. You will be tasked with extracting data from designated software systems and ensuring its up-to-date status for reporting purposes. Additionally, you will play a vital role in providing robust reporting and analytical support to the management team, catering to both scheduled and ad hoc reporting requirements. By analyzing business information, you will proactively identify areas for process improvements to boost operational efficiency and effectiveness. The ideal candidate for this position should have a graduation qualification and possess excellent skills in MS Excel, PowerPoint, and Word. This is a full-time job opportunity that offers benefits including health insurance, a yearly bonus, and a day shift schedule. The work location for this role is in-person. Join our team and contribute to the success of our organization through your analytical skills and proficiency in data management and reporting.,

You will be responsible for generating and distributing management reports in an accurate and timely manner. Utilize Advanced Excel capabilities, such as pivot tables, look-ups, complex formulas, and graphing, to streamline business processes. You should have the ability to comprehend complex data, perform analysis, and create reports and dashboards. Extract data from the designated software and ensure it is up to date. Offer robust reporting and analytical information support to the management team. Prepare both periodic and ad hoc reports as needed. Analyze business information to identify opportunities for process improvements that can enhance business efficiency and effectiveness. Requirements include a Graduation degree and proficiency in MS Excel, PowerPoint, and Word. This is a Full-time job opportunity with benefits such as health insurance, yearly bonus, and a day shift schedule. The work location is in person.,