About Me
I have a vast experience of working from scratch to the complete deployment of Reports into power bi service. Complete ETL in Power Query, working with various data sources. Work with complex Datasets, Creating Data Mode…
I have a vast experience of working from scratch to the complete deployment of Reports into power bi service. Complete ETL in Power Query, working with various data sources. Work with complex Datasets, Creating Data Modelling, complete Transform of Data per report requirements. Implement Smart methods / employ parameters for Data sources to trigger connectivity to production database after publishing reports to power bi service etc
Experience
Tech SME
I have a vast experience of working from scratch to the complete deployment of Reports into power bi service. Complete ETL in Power Query, working with various data sources. Work with complex Datasets, Creating Data Modelling, complete Transform of Data per report requirements. Implement Smart methods / employ parameters for Data sources to trigger connectivity to production database after publishing reports to power bi service etc
Technical SME & Data Management
Work with Servers / Systems / Database.
Maintain Database using SSMS (SQL Server).
Query the tables per project requirement using Microsoft SQL Server Management Studio.
Create tables, reports, views, and stored procedures.
Set up jobs to populate the tables for updated data via stored procedures.
Query Azure SQL Database tables per project requirement.
Analyze the datatype and data structure of columns in the tables.
Work on complete ETL in Power Query (M Queries).
Work with various data sources and data structures to do complete ETL in Power Query itself.
Create data models based on project / report requirements.
Work on DAX for measures wherever necessary.
Tweak the data types, column sets, and tables by merge, append, and other required changes.
Publish reports to Enterprise Gateway.
Deploy complete automation of reports.
Work with Power BI Dataflow to create, reuse, and modify.
Work with complex datasets for complete ETL, including data cleaning, normalization, transformation, and manipulation.
Create data models consisting of tables from different data sources.
Address complex challenges pertaining to data models, different data sources combined to make reports, gateways, and connectivity to data sources.
Find sustainable solutions to speed up or reduce report refresh time when reports connect with data sources for updates.
Make visuals per business requirements via constant engagement with stakeholders.
Perform complete back-end and front-end development of Power BI.
Work with Document Management System (Adept).
Engage with clients globally.
Analyse business requirements and deliver the work as required.
Technical SME & Data Management
Work with Servers / Systems / Database
Maintain Database using SSMS (SQL Server)
Team Leader Operations
Manage ecommerce projects and work on database using SQL (SSMS).
Maintain regular communication with client and discuss performance based on relational data reports / charts.
Handle the team and project of the client.
Update client on day-to-day progress / productivity on eCommerce Website (Philips.com).
Manage operations of daily activities.
Discuss regularly with team members and work on improvement spots wherever required.
Senior Content Writer
Write and proofread content based on the requirements.
Create unique content for products and services.
Write unique blogs for company website.
Make presentations and proposals for existing and new clients.
Make business quotations for existing and new clients USA.
Ensure no plagiarism while creating content for website and blogs.
Prioritize standards of SEO throughout the content.
Senior Associate Operations
Communicate to the Project Manager, stakeholders, and clients regularly on project updates.
Engage with clients and stakeholders to discuss and fix issues pertaining to website functionality of web pages created/published regularly.
Maintain SLA and CSAT of productivity.
Communicate with global translators to get the content translated whenever necessary for non-English regional pages.
Update the title, meta descriptions, and keywords of web pages based on SEO analysis to CMS (Content Management System - SharePoint).
Work on productivity queue via SharePoint Administration.
Customer Care Executive
Interact with all SME clients.
Create content for clients to publish on websites.
Write content based on the products.
Prioritize SEO standards throughout content.
Ensure content uniqueness and avoid plagiarism.
Team Leader Operations
Manage ecommerce projects and work on Database using SQL (SSMS)
Maintain regular communication with client and discuss about performance based on Relational Data Reports / Charts
Handling the team and project of the client and update to client on day-to-day progress / productivity on eCommerce Website (Philips.com)
Manage Operations of Daily Activities
Regular discussion with team members and work on Improvement spots wherever required
Senior Content Writer
Write and proofread content based on the requirements
Unique content creation of products and services
Writing unique blogs for company website
Make Presentations and Proposals for Existing and new clients
Make Business Quotation for Existing and new clients USA
Ensure no plagiarism while creating content for website and blogs
Prioritize standards of SEO throughout the Content
Senior Associate Operations
Communicate to the Project Manager, Stakeholders, Clients regularly on project updates
Engage with the clients and stakeholders to discuss and fix issues pertaining to website functionality of Web pages created/published regularly
Maintain SLA and CSAT of productivity
Communicating with Global translators to get the content translated whenever necessary for non-English regional pages
Updating the title, Meta descriptions and keywords (Meta Data) of Web pages based on SEO Analysis to CMS (Content Management System - SharePoint)
Experience in working on Productivity Queue via SharePoint Administration
Customer Care Executive
Interaction with all SME clients
Content Creation for clients to publish on websites
Writing Content based on the products
Prioritize SEO standard throughout content
Ensure content uniqueness / avoid plagiarism if any