Power BI Consultant
Intertec Systems
مجموع سنوات الخبرة :1 years, 11 أشهر
Provided one stop solution to visualise the sales by each team, LoBs and sales person, their corresponding targets and actuals through the Booking Dashboard, comprising of sources from Microsoft dynamics CRM, SQL server and excel files
Built the Business Requirements Document upon discussion from clients and defined the scope of the project.
Worked with business analysts and got the Functional Specification document approved.
Developed HLD and LLD for the identified business requirements
Handled complex data models with multiple many to many relationships, applied cross filters
Implemented Row Level Security, restricting data based on LOBs and Teams
Developed dynamic measures, chart titles based on visual selections, conditional formatting
Exploited bookmarks for various purposes to hide and show the visuals by request
Configured the Power BI gateway server and datasets through the gateway
Published reports and shared it across multiple users, scheduled daily refresh
Created hierarchy and developed drill through reports
Used complex DAX measures with several functions such as intersect, cross join and time intelligence functions
Created slicers, visual, report level and page level filters for flexibility, used top N and relative date filters
Developed KPI cards for showing the efficiency by weekly and monthly
Built ETL technical specifications and mapping documents with transformation rules
Planned for the organization flow viz., control flow, workflows.
Handled text file, csv source and customized source files, performed data cleansing
Worked on lookups, conditional splits, Aggregate, joins, DB stages
Developed trend reports showing weekly sales
Created SQL procedures to store weekly sales data history
Published reports in Power BI App
Created MDX queries and developed cubes and performed analysis in SSAS
Documented all the requirements, functionality and test scenarios
Customer-facing, acted as a single point of contact for weekly meetings with clients
Gathered business requirements for change requests and other projects in the pipeline
Managed a team of 6, assigned tasks and decided on the deadlines after considering the risks involved
Worked with the project team to prepare high level and low level technical design documents
Follow up with team members for the overall progress and status through emails, meetings and conference calls
Responsible for providing technical support in ETL and BI solutions
Coordinated with all the stakeholders, business users and development team for the user acceptance testing
As a Release manager delivered change requests on time, provided constant communication to clients during weekly, month-end maintenance activities
Supported project manager in hiring the right candidate and help in orientation, coordinating with HR
Supported project manager in budget and cost estimation, building proposals and contracts
Received appreciation from European clients on Linkedin for the excellence in project planning and on time delivery despite the cultural barrier
Environment: IBM Infosphere DataStage, DB2, Flat files, UNIX, Cognos
لقد تم حذف الرابط بسبب انتهاكه لسياسة الموقع. يرجى التواصل مع قسم الدعم لمزيد من المعلومات.