Anushiya G
BI report developer
Guadalajara,jalisco
Summary
Having overall 8 years’ experience in IT and 6 years of experience in Microsoft Technologies with Power BI, Report Builder,IBM Cognos, Snowflake, SQL Server, SSAS, Azure Analysis Services and have knowledge in Data Warehousing (DW). Professional Summary Have good experience in Power BI Desktop creating effective reports and dashboards to analyze thebusiness. Experience in Extract, Modelling, transformation, and loading using query editor and the relationship ofthe tables. Created different types of reports drill through, cross report, parameterized report, and interactivedashboards. Experience in working with creating conditional formatting, filters, calculated columns, measures. Worked on Data Modelling with DAX using various functions like Logical, Aggregate functionsand Time intelligence & Date functions to create business calculations based on requirements. Expertise in implementing Row-Level-Security (RLS) to provide more security on data in bothstatic and dynamic ways using DAX function. Created bookmarks to enable toggling between buttons and implemented sync slicers. Have good knowledge in Power Query editor to apply different type oftransformations. Experience indifferent type of Power BI webconcepts like Gateways,Schedule refresh, Q&A,Insights in Datasets. Experience in different types of Power BI visualizations charts like Bar, Line, Tree map, KPI,Gauge, slicers using Power BI desktop. Experience of viewing dashboards in Power BI Mobile version. Worked on Azure Analysis Services (AAS), Connecting the AAS and creating the dashboard in PowerBI. Implemented relationships and created hierarchies, measures, and calculated columns inPower BI. Worked in building Relational Model Physical Layer, Business Layer, Packages using Framework Manager and Report building using Cognos 10.x, 11.x (Report Studio, Analysis studio, Business Insight & Advanced & Query Studio). Developed solutions for Management dashboards, BI Analytics, and documented technology roadmapsthrough collaboration with the data management. Experience in Cognos in terms of scheduling, deployment, security and maintaining the regularbackups.
Overview
9
9
years of professional experience
Work History
Power BI Developer
TVS Supply Chain Solutions
- Responsible for gathering business requirements, doing analysis and documents
- Importing the data from data sources and preparing the data(Query
- Editor) as per user requirement
- Building the relationships between the various data sets in power pivot
- Publishing reports to Power BI and providing the access to required users
- Used Power BI Gateways to keep the dashboards and reports up to date
- Created different filters like visual level filters and page level filters and report level filters as per reporting needs
- Responsible for create Workspaces and share insights to specific business customers/partners
- Designed diverse types of reports like drill down, drill through
- Bookmarks and Sync Slicer
- Created reports using time intelligence calculations and functions
- Written advance DAX to calculate YTD, HYTD, QTD, MTD, WTD and also different measures to show values based on slicer selections
- Implemented role-based security as part of user level security in
- Power BI
- Regularly involving in calls with business users and discussing about status and new requirements of the project
- Project Title: Service Excellence Global and Division
- Client, The success in every business lies with customer satisfaction
- As an initiative to let the customer measure the performance of the service provided, dashboard is built to showcase the live transactions of the entire
- Transport and Logistics operation in form of KPI(s)
- The dashboard also provides Yearly/Quarterly/ Monthly analysis of the performance and enables live tracking of customer’s product
- Tools: Microsoft Power BI Desktop, Microsoft Power BI service, Snowflake
- Tabular SSAS, Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements
- Importing the data from data sources and preparing the data (Query
- Editor) as per user requirement
- Created cube using SSAS (Tabular Model) and used it as a source for the dashboard
- Created, used extensive Bookmarks, Filters, and Calculated Measures as per requirements
- Integrated Custom Visuals based on business requirements using
- Power BI desktop
- Developed complex calculated measures using Data Analysis
- Expression language (DAX)
- Publish reports and dashboards to the Power BI service and share the dashboards among multiple users in the group
- Project Title: Inventory and Warehouse Management
- Client Multiple Clients (TVS Logistics Services, Project Description:
- While we maintain a warehouse, understanding what you have, where it is in the warehouse, and when stock is going in and out can help lower costs, speed up fulfilment, and prevent fraud
- Upon analyzing the importance of inventory and warehouse management, a dashboard built to display the stage part availability, part location, task allocation, count of incoming vehicle and work force deployment
- The dashboard helps the warehouse
- Managers in resource planning and allocation
- It helps the management to
- Analysesand controlthevarious warehouse performance on day-to-daybasis
- Tools: Microsoft Power BI desktop, Power BI Service, SQL, Report Builder and SSIS
Power BI Developer, Cognos Report Developer
- Developing Power BI Dashboard that help management to optimize decision-making processes
- Converting all operational excel report into Power BI Reports
- Developed analysis reports and visualization using DAX functions like table function, aggregation function and iteration functions
- Created Reports using Charts, Gauges, Tables, matrix and with Custom
- Visuals
- Created all kind of reports for monitoring Yearly, Quarterly, Monthly, and
- Daily basis
- Configuring access to dashboards and app workspaces, creating Row
- Level Security
- Project Title: Warehouse Operations Tracking (MSYS)
- Client Husqvarna, NSK, TVSMC and General Electric
- Project Description:
- Control Tower Warehouse operations team obtains data from the various warehouse clients of the company to monitor In House operations in the warehouse
- The major purpose of this project is to automate the process of getting the data files from suppliers on daily basis and to regulate the work force at client warehouse
- Data was extracted from SQL Server and Flat Files
- Cleaned, Transformed & Loaded in a separated data base using SSIS, The
- Enterprise Data Warehouse was built to implement a centralized the database that collects and organizes and stores data from different operational systems, integrate and historical data for the purpose of end user reporting
- Tools: Cognos Analytics, Framework Manager and Snowflake, SSIS
- Role, Extensively worked with list, chart & crosstab reports using Report studio
- Involved in design documentation for the present reports
- Created layout and Query Calculations
- Developed list reports by applying cascading functionality to restrict data fetch
- Developed Drill Through, Master Detail Relationship and Conditional
- Formatting Reports
- Developed filters, calculations, prompts, and conditions using report studio for users
- Involved in Unit Testing, Data validation Testing
- Schedule the Reports using Cognos connection
- Maintaining regular backups of the developed reports.
Deputy Manager
TVS Supply Chain Solutions
Madurai, Tamilnadu
02.2017 - 10.2023
- EXPERTISE/SKILLS
- Reporting Tools Power BI, Power Apps, Report Builder, Cognos.X versions
- Database MS SQL Server 2016
- Languages SQL, DAX
- Version Control Azure Cloud
- Project Profile
- Project Title: Supply Chain Operations KPI Dashboard
- Client, This project is to track the performance of different operations of the company among different verticals
- Major verticals includes Transport
- Integrated Logistics (Service quality, profit incurred, truck maintenance, trip planning), Warehouse and Finance
- Tools: Microsoft Power BI Desktop, Power BI Service and Snowflake
Process Engineer
HIYA Tech Solutions Pvt Ltd
06.2014 - 08.2016
Education
Bachelor of Commerce - undefined
NMS Sermathai Vasan College
2014
Master of Business Administration - undefined
MKU
2017
Certification/Accomplishments Microsoft PL-300 certification (Microsoft Power BI Data Analyst). Microsoft DA-100 certification using the free Power BI Desktop. Learn Power Query, DAX, M–Udemy - undefined
Work Preference
Work Type
Full TimeLocation Preference
RemoteImportant To Me
Work from home optionTimeline
Deputy Manager
TVS Supply Chain Solutions
02.2017 - 10.2023
Process Engineer
HIYA Tech Solutions Pvt Ltd
06.2014 - 08.2016
Bachelor of Commerce - undefined
NMS Sermathai Vasan College
Master of Business Administration - undefined
MKU
Certification/Accomplishments Microsoft PL-300 certification (Microsoft Power BI Data Analyst). Microsoft DA-100 certification using the free Power BI Desktop. Learn Power Query, DAX, M–Udemy - undefined
Power BI Developer
TVS Supply Chain Solutions
Power BI Developer, Cognos Report Developer
Similar Profiles
V GOKULASELVANV GOKULASELVAN
HSE Officer at TVS MOTOR COMPANY - TVS Supply Chain Solutions LtdHSE Officer at TVS MOTOR COMPANY - TVS Supply Chain Solutions Ltd
R.Manikandan R.Manikandan null
Plant Head at TVS Supply Chain Solutions, TVS MotorsPlant Head at TVS Supply Chain Solutions, TVS Motors
Praveen Kumar SPraveen Kumar S
Zone Supervisor at TVS Supply Chain SolutionsZone Supervisor at TVS Supply Chain Solutions
Senthilnath BaskaranSenthilnath Baskaran
Team Leader – Technical Deployment & Maintenance at TVS Supply Chain SolutionsTeam Leader – Technical Deployment & Maintenance at TVS Supply Chain Solutions
Hugo CerdaHugo Cerda
Coordinator Corporate Solutions LATAM at Hershey MexicoCoordinator Corporate Solutions LATAM at Hershey Mexico