Job Description

From 2 to 3 year(s) of experience
₹ 4,00,000 - 6,00,000 P.A.

Bangalore/Bengaluru

Job Title: MIS Executive

Key Responsibilities We Are looking for Candidates who has Min 2 years experience as MIS Executive/MIS Analyst/Data Analyst

• 
  Expertise in Power BI, Power BI Pro, Power BI Mobile, Advanced Excel
• Experienced in Power BI Components Power Query, Power Pivot, Power view, Power Map
• Developed Power BI model used for financial reporting of P & L and Headcount.
• Automated Power Query refresh using power shell script and windows task scheduler.
• Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
• Created Workspace and content packs for business users to view the developed reports.
• Used various sources to pull data into Power BI such as Sql Server
• Designed and created data extracts, supporting SSRS, POWER BI, R Studio or other visualization tools reporting applications.
• We use this service to access, search and transform data from public or local/internal data sources.
• Visualizations/ custom visualizations, Reports/ ad hoc reporting, Dashboard Creation
• Database creation (DDL, DML, DCL), database tuning, SQL tuning, performance planning.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Created stored procedures and SQL queries to pull data into power pivot model.
• Created Parameterized Report, Dashboard Report, Linked report and Sub Report by Year, Quarter, Month, and Week.
• Worked on complex data loading
• Hands on Tools like SQL, Google Sheets, Excel, VBA, Macros, Power BI Desktop

JOB Location - Bangalore, Koramangala Work days- 5days Salary- Flexible depending on Experience and skill set
Need only immediate joiners Interested candidate can reach out or send their resume at manisha.m@apar.com or call at 8073896955 / 7873745331

Key Skills
Power BIAdvanced ExcelMacrosExcelVBA
Google SheetsData Validationdata analysisConditional FormattingFormulasPower BI DesktopTableauHLOOKUPSQLPower BI MobilePivot TableVLOOKUPpivotLookupPower BI Pro
Skills highlighted with ‘‘ are preferred keyskills
Education UG:Any Graduate

Company Profile

APAR Peopleworld Software Services Pvt. Ltd.
We are Apar Peopleworld www.aparpeopleworld.com Part of Apar technologies . We are headquartered in Singapore and one of Asia Pacific’s leading organizations, providing Staffing solutions, technology consulting, software development and outsourcing services, with operations in 6 countries and development centers in Singapore, Malaysia and India. The Silicon Review has identified us as one of the 10 fastest growing Data Analytics companies.
APAR Industries (http://www.apar.com/products.php ) was started in 1958, in India. Over 60 years later, we have grown into a diversified $1 billion company, and expanded to over 100 countries as a highly trusted manufacturer and supplier of conductors, transmission cables, specialty oils, polymers and lubricants. Apar Technologies is a part of the Apar Group, a billion dollar conglomerate and are managed by Basil Partners, a successful private equity fund. Established in 2006, Apar Technologies is a global information technology consulting company. Headquartered in Singapore, Apar is spread across 8 countries namely, Malaysia, Thailand, Indonesia, India, USA, Australia, MEA. Apar has development centers in Singapore and India (Bengaluru, Noida). Since inception, Apar has grown to a 2,200employee organization worldwide and continues to develop its strengths and capabilities both organic and inorganically.
Company Info


X



Contact Company:APAR Peopleworld Software Services Pvt. Ltd.
Salary: 4,00,000 - 6,00,000 P.A.
Industry: IT Services & Consulting
Functional Area Data Science & Analytics
Role Category Business Intelligence & Analytics
Role: Data Analyst
Employment Type: Full Time, Permanent