VB Script
VB.6
VB Advanced Excel
Bangalore/Chennai/Hyderabad
Experience creating PowerPoint slide decks and along with that experience in automating the PowerPoint slide creation using excel VBA Formats extracted data based on expected report output with batching capability and multiple data formatting requirements Consolidate and combine extracted data from multiple resources using automated tools excel, VBA macro, SQL database, and/or from different system/tools/Database in one single database using SQL queries to standardize data structure
Professional Attributes :
Gathers and analyse report requirements from stakeholders Identify the processing tool Excel / SQL and provide a robust solution which can be easily leveraged or extended to other domains Building complex VBA scripts to automate Excel spreadsheet processes
About ON Time Solutions
Similar jobs
Power BI Developer
Senior visualization engineer with 5 years’ experience in Power BI to develop and deliver solutions that enable delivery of information to audiences in support of key business processes. In addition, Hands-on experience on Azure data services like ADF and databricks is a must.
Ensure code and design quality through execution of test plans and assist in development of standards & guidelines working closely with internal and external design, business, and technical counterparts.
Candidates should have worked in agile development environments.
Desired Competencies:
- Should have minimum of 3 years project experience using Power BI on Azure stack.
- Should have good understanding and working knowledge of Data Warehouse and Data Modelling.
- Good hands-on experience of Power BI
- Hands-on experience T-SQL/ DAX/ MDX/ SSIS
- Data Warehousing on SQL Server (preferably 2016)
- Experience in Azure Data Services – ADF, DataBricks & PySpark
- Manage own workload with minimum supervision.
- Take responsibility of projects or issues assigned to them
- Be personable, flexible and a team player
- Good written and verbal communications
- Have a strong personality who will be able to operate directly with users
- Consolidating daily reporting from different advertiser dashboards
- Monitoring discrepancy between advertiser and publisher numbers
- Maintaining month-end consolidated reports for Publishers and Advertisers
- Perform ad trafficking, ensuring accurate implementation of creative assets, tracking codes, and targeting specifications.
- Monitor campaign performance, analyze data, and provide actionable insights to improve campaign effectiveness and optimize ROI.
- Collaborate with cross-functional teams to ensure campaigns are executed according to client objectives and deadlines.
- Stay up-to-date with industry trends, ad tech developments, and best practices to enhance campaign strategies.
About Company:Long-term accommodation booking platform for students (think booking.com for studenthousing). It helps 80M students worldwide, find and book full-time accommodations near their universities, without the hassle of negotiation, nonstandardized and cumbersome paperwork, and broken payment process. We are the leading student housing platform globally, with Million student housing units listed in
countries and across cities.
Responsibilities
Take a lead role in end-to-end finance management
Manage a team of to take care of
Accounting
Global entity setups and Compliances
Taxes
Financial data management system
Investor relations
Get the Consolidated books closures monthly level
Take a lead role in new country expansions
Understand the budget requirements from the department heads and plan cash flow
Analyze revenue, expenses, cash flows, and balance sheets.
Present potential scenarios and outcomes to management team
Maintain investor relations and reporting
Requirements
CA with minimum 5- 7 years of experience
Knowledge of end to end of Accounts
Direct Tax/Indirect Tax Compliances
MIS, Analytics, Excel Skills
Good Communication skills
Team leader (Min 5-6 member team)
Experienced in corporate finance and investor relations
Regards
Sana
Job Requirement – Sr. SQL _PBI Developer
- Minimum 6+ years of expertise in SQL Database Development including SQL queries, data structures, stored procedures, index etc.
- Excellent written and verbal communication
- Advanced knowledge and experience in T-SQL coding: query writing, stored procedures, triggers and user-defined functions.
- Advanced knowledge and experience in development and maintenance of SSIS and SSAS (Tabular and Multidimensional)
- Advanced knowledge and experience in creating dashboards and reports using PowerBI
- Advanced knowledge and experience in DAX
- Experience in creating and publishing reports using SSRS
- Experience in writing MDX queries
- Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
- Optimize and manage SQL server databases
- Independently analyse, solve, and correct issues in real time, providing problem resolution end-to-end.
- Refine and automate regular processes, track issues, and document changes
- Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
- Flexible, team player, “get-it-done” personality
- Ability to organize and plan work independently
- Ability to work in a rapidly changing environment
- Ability to multi-task and context-switch effectively between different activities and teams
Optional Skills (Good to have):
- Microsoft certification in Azure data engineering
- Opportunity to work in a fast-paced environment aimed at creating a very high impact
- Exposure to different business functions in a fintech organization, helping each function to become successful with your work
- Opportunity to work with a diverse team of smart and hardworking professionals from various backgrounds
- Amazing work culture with endless opportunities for personal and professional growth Independence to put your thoughts/ideas into the executable business projects
- Ability to directly implement solutions and see them in action; critical partner for all decision-making in the organization
- Interact with people from various backgrounds
- A mix of Statisticians, Consultants, Business and Programmers
- Flat organization structure with open and direct culture
- Merit-based fast-growth environment - Market-leading compensation and benefit
Responsibilities
- As a Fraud Investigator, you'll lead multiple complex fraud investigations simultaneously in your area of responsibility and you'll write clear and concise reports for investigation findings and report outcomes to Avail finance's management. In addition, you are going to make this a success by conducting audit activities (prepare, execute, report) and customer screening in line with our Internal Audit procedures and Due Diligence Program.
- Identify risk trends in your area and translate them into learning and solutions, sharing best practices and facilitating the risk owner and business manager to make decisions.
- Actively anticipate trends and requirements and provide support for Avail finance's global anti-fraud procedures and standards for fraud identification and management of investigations to be the benchmark.
- Act as a representative Interact and engage with senior stakeholders in the Area.
- Participate in, provide input, and lead initiatives for the FICS Knowledge Practice.
- Able to translate Area and Global risk trends into proactive actions.
- Document findings and conclusions in line with the prescribed tools and methods.
- Responsible for the entire documentation and reporting of fraud/audit/customer screening in line with Signify Internal Audit procedures and systems
- Conduct customer screenings as part of the Due Diligence Program.
- Conduct compliance audit activities and contribute to fraud prevention within Avail Finance. - Work experience in NBFCs / Fraud Analytics in Banks / Fintech / Lending organizations in India would be a big plus
About You :
- You put the Customer First by identifying risk trends in your area of expertise and translate these into learnings and solutions.
- You are Greater Together by collaborating across teams to build on our strengths and diversity and work towards our shared goal.
- You are a Game Changer by innovating. Together we set ourselves apart and continue to lead in the market.
- You have a Passion for Results by working smarter and faster to deliver excellence
- 5 to 8 years of hands on experience in automating MS Office applications like Excel, Word, PPT and Outlook using VBA
- 5 plus years of experience in the design, development, and implementation of programming code
- Experience in database development
- VBA - Should have good experience in developing efficient logic/algorithms using VBA
- Solid understanding of SDLC concepts
- Solid experience in MS Excel (2003, 2007, 2010, 2013,2016)
- Must be good at all excel features and excel formulas
- Well versed with complete MS Office package (Excel, Word, Outlook, PPT)
- Work both independently and as part of a team
- Experience in requirements gathering, effort estimate, designing and implementation and creating mock-up screens
- Experience in databases like MS SQL Server (2005 to 2012,2014), MySQL and MS Access
- Must have strong database concepts and DB designing skills
- SQL - must be good at writing efficient, fine-tuned queries using joins and aggregates
- Experience in writing Stored procedures, Triggers and T-SQL
- Nice to have programming knowledge in C#
- VBA, SQL
- Strong analytical and problem-solving skills
- Excellent interpersonal and communication skills
- Should be able to take complete ownership of the project from requirements gathering to delivery and maintenance
- Should be able to work independently
- Must be Proactive and Self-motivated
- Must have the ability to prioritize the work, execute tasks and meet the deadline without fail
- Effective time management skills
- Customer Focus, Willing to learn and self- teach any new technology
- Strong business and collaboration skills, and responsive to service needs and operational demands.
environments
Create and modify database schema, T-SQL scripts, stored procedures and other database
objects and SSIS packages in order to meet customer requirements.
Must have strong working knowledge of MS SQL Management Studio
Set up, maintenance and support jobs in SQL Agent
Required Skills:
MS SQL Server 2012/2016 and T-SQL in OLAP and OLTP
Operating Systems: Windows Server 2008/2012/2016
Database: MS SQL Server 2016/2019
Senior Manager – LeadSquared Apps Marketplace
LeadSquared is one of the top cloud-based sales execution SaaS platforms. The platform is used by over 40,000 users across 25 countries to grow their businesses. The business is growing well across multiple geographies in financial services, healthcare, education and other consumer services.
Apps Marketplace
To serve multiple industries and geographies, it is critical to have a strong integration and product extension strategy to meet specific customer needs. That is where our apps marketplace comes in, which currently has about 30 apps solving various micro-integration or functionality extension needs. With the kind of growth we are seeing, we need to build many more apps, and more importantly bring in partners who can seamlessly build and integrate their apps in our marketplace.
The Role
We are looking for an energetic and passionate individual to lead our Apps Marketplace effort:
- Build a team and drive the effort of building and maintaining strategic apps (ones which need to be inhouse) such as cloud telephony integration, SMS, email integration and Google/Facebook ads.
- Work with our platform group to ensure the apps marketplace framework is partner ready, and it is easy to add new apps
- Educate and collaborate with potential dev partners so they can contribute to LeadSquared apps marketplace
Key Requirements
The ideal candidate would have experience of designing, building, testing and releasing several cloud-based business applications, end-to-end. Experience of leading small teams, strong sense of ownership, working collaboratively with different teams and expertise in setting up strong engineering process are critical. Other requirements include:
- 6+ full-stack experience in building cloud-based web applications using any of .NET/Java/Python/PHP/Node.js. Some experience in C# and ASP.NET important
- Solid understanding of architecture, design, development, test and release of web applications, REST APIs and application integrations
- Experience in working on AWS with good understanding of various managed services
- Proven experience of project planning, estimation and execution
- Strong knowledge of build and release process