Data Analyst

Lathika Raja

Email:*******.*****@*****.***

Mobile: +1-253-***-****

Summary

•5+ Years of IT experience in Business Intelligence, Data Analysis, Reporting and Testing software applications using Microsoft SQL Server and BI suite.

•Expertise in requirement analysis and design of reporting/analytics solutions.

•Expertise in designing data models of various data warehouse Projects.

•Experience in Financial reporting and data analysis.

•Worked for Microsoft Financial team.

•Strong knowledge in SSAS, DAX and Tabular Model.

•Experienced using DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models.

•Strong Knowledge in dimensional Star Schema and Snowflakes Schema.

•Solid Experience in Power-BI, Power Pivot and Power Query.

•Experienced in enhancing data warehouse with extensive knowledge of Data mapping, Data Modeling, Snowflake, Star Schemas, ETL jobs and OLAP operations.

•Experience in developing SSAS tabular cube.

•Expertise in developing SSAS Cubes, Aggregation, Dimensions, KPIs, Measures, Partitioning Cube, calculated members and deploying and Processing SSAS objects.

• Knowledge in Cosmos, Cloud Azure Portal, Azure Data factories and Azure SQL databases

•In-depth understanding of Data warehousing concepts.

•Expertise building and maintain advanced SQL scripts, indexes, and complex queries for data analysis and data extraction.

Education

Master of Computer science, Periyar University, India.

Bachelor of Computer science, Periyar University, India.

Professional Experience:

Role: Data Analyst Mar 2020- Till date

Employer: ACIT Labs (Client: Microsoft Finance team)

Environment: SQL Server 2014, Excel, SSAS & Power BI

Responsibilities

•Manage reporting/analytics needs for Microsoft’s finance team.

•Gather business requirements, analyze, and design the dashboard layouts.

•Developed/automated reports and Audits using power BI PowerPivot, connections (Directly to Analysis server, SQL server, etc.).

•Build Ad hoc reports based on the requirements from finance team.

•Developed data model in power Query and created several DAX expressions.

•Worked on Row/Column audit for the existing reports.

•Develop Power BI reports & dashboards with SQL Server/Tabular SSAS sources. Designed, developed, tested several reports helping customer make better business decisions.

•Published the reports and dashboards.

•Refresh, update, Upkeep and Rolling Over existing reports on a weekly, monthly, quarterly, and yearly bases.

Employer: Pactera Feb 2017 – Jun 2018

Environment: SQL Server 2014, SSIS, SSAS & Power BI

Responsibilities

•Review business requirements and interact with business users to understand their requirements.

•Analyze the requirements and design the dashboard layout.

•Created measures using Visual Studio on SSAS Tabular source.

•Worked on Power-bi and DAX expressions.

•Worked on the Power BI reports & dashboards with SQL Server/Tabular SSAS sources Designed, developed, tested a dozen of reports helping customer to analyze data better.

•Published the reports and dashboards.

•Developed model in power query and created several DAX expressions.

•Educated the business users on how to use the reports and dashboard.

•Transferred data from various OLTP data sources, such as MS Excel, CSV files, SQL Server 2016 into Data Warehouse.

•Transform complex business logic into database design and maintaining it by using SQL objects like stored procedure and views.

•Create SSIS packages to import data from Access, Excel, XML, OLEDB Source and flat file.

Role: STE Oct 2014 – Jan 2017

Client: SCCM -MS

System Center Configuration Manager is a systems management software product by Microsoft for managing large groups of computers running Windows, Windows Embedded, Mac OS X, Linux or UNIX, as well as various mobile operating systems such as Windows Phone, Symbian, iOS and Android.] Configuration Manager provides remote control, patch management, software distribution, operating system deployment, network access protection and hardware and software inventory.

Role and Responsibilities:

•Testing SCCM 2012 setup wizard and its options on different environment.

•Actively participated in agile project related daily Stand-ups, Callouts and Blockers to maintain a high level of quality for the project.

•Ownership of Content and Endpoint feature testing in SCCM 2012.

•Preparation of complex environment which stimulate the Customer environment for testing the SCCM 2012 set-up.

•Automating tests using Suitep2 and Mindy test Automation Test Framework.

•Modified few modules using C#.net.

•Writing Test cases for Content and Endpoint Feature and Executing manual/automated test cases.

•Performed back end testing with SQL.

•Creating training documents, SCCM help document and wiki page contents for SCCM Setup and Application Management.

•Test Case Management and Bug management

Environment: C#, WTT, Product Studio, Power shell, Windows 7, VS2010 and Sql server 2012

Role: Report Developer Aug 2006 –Jul 2007

Client: Makino India Pvt, Ltd

Makino company has helpdesk support managed through OVSD. OVSD does not provide strong reporting capability around help desk activities. This project is setup to bring the Help Desk support ticket information into a user friendly multi-dimensional reporting tool

Responsibilities

•Project Team member of the Financials ERP implementation project.

•Designed and developed several new financial reports using crystal reports based on the technical specification.

•Developed different types of reports such as Crosstab reports, Standard report and Sub report.

•Modified existing reports to meet the user requirements.

•Developed lot of stored Procedures.

•Perform Report Data validation using SQL Queries in SQL Server Database.

•Perform Unit testing on the newly developed reports and the Modified reports.

•Provided support to System testing and fix any defects identified by the testing team.

Contact this candidate