Data Analyst\Business Intelligence Developer

M: 0404352389, E: lanka.sindhu1@gmail.com, A: Unit 3,3 Dundee Street,Reservior,Melbourne

Sindhusha Kilaru

Highly analytical and process-oriented data analyst with in-depth knowledge of database,

Business Intelligent relate fields for Visualizations, so far I mostly worked on Microsoft

technologies. Looking to work with an esteemed organization that gives me an opportunity to

utilize my existing analytical skills and help make better business decisions.

Education

My major in Bachelors in Computer Sciences. Relevant and Marks: Database Management

Systems(A+),Design and Analysis(A+),Project Management(A+),Database and

Datawarehouse(A+),passed with an aggregate of 70%.

TECHNICAL EXPERTISE

BUSINESS INTELLIGENCE:

• Reporting tools SSRS, Power BI and Tableau

• SQL Server Integration Servises(SSIS)

• ETL (Extract, Transform, Load) using ETL tools (SSIS)

• Data Warehouse(star Schema)

• SQL Server Analysis Services(SSAS)

• Excel,PowerPivot,PowerQuery

• DAX(Functions)

DATABASES:

• Microsoft SQL Server(2016),

• SQL Queries, Store procedure, Function,Views

PROFESIONAL EXPERIECE

MVP STUDIO(Melbourne):BI DEVELOPER APRIL 2019-present

I am working as a BI Developer for Creating Datawarehouse and integration into Power BI.The

product I am currently working on

• Gathering, analyzing and understanding of Business requirements for a cloud based

property management project which manages owners portfolio and investment returns.

• Design and implement the data warehouse schemas(star Schema) using datasets from

Excel, the ETL processes and, as necessary Reports using (SSRS,Power BI).

• Importing/exporting data between different sources like SQL/Excel using SSIS utility.

• Integration of various data sources and performing Data standardisation and ETL process.

• Development of Customer reports & Dashboards using SSRS and Power BI.

• Implementing various DAX functions and Power Query features.

Pluto (India):DATA ANALYST Jan 2014-Jan 2016

• Present the top online retailers websites data to management team on weekly basis.

• Excellent experience in creating complex queries Stored Procedures, Functions and Join

Functions.

• Good knowledge of all MS Office suite, daily using Pivot Table and V Lookup.

• standardize raw data using Excel into a clean entry format.

• Designed SSIS packages to extract data from different sources like SQL server 2016, MS

Excel, Flat Files, transform and then load into Dimension and Fact tables in Data

Warehouse using SSIS.

• Genetrate the reports using SSRS.

INTERESTS

I am deeply interested in Music,Travelling,Reading

REFEREES

• Happily available on your request.