نبذة عني
Tableau Certified Developer with around 2 years of experience in Data Visualization and Business Intelligence. Hands on experience in using various tools like SQL, PL/SQL, Tableau, Power BI, MS Reporting Services, MS SQL…
Tableau Certified Developer with around 2 years of experience in Data Visualization and Business Intelligence. Hands on experience in using various tools like SQL, PL/SQL, Tableau, Power BI, MS Reporting Services, MS SQL Server, MS Excel(advanced), Fivetran, PPT & Python. Proven ability to undertake BI/Analytics projects right from requirements gathering, Designing, Development and production support. Competent to write complex SQLs and performance tune the long running reports, SQLs and Data load jobs by identifying bottlenecking SQLs and tunning them with suitable performance optimization technique. Good understanding of Software Development Life Cycle (SDLC) models such as Waterfall and Agile. Excellent understanding of various Data Warehousing concepts like Star Schema, Snowflake Schema and SCDs. Possess strong analytical and problem-solving skills with the ability to draw conclusions and provide explanations and make recommendations based on analysis. Expertise in Architectural design, creating Technical, Functional and Non-Functional Requirement documents, High Level and Detailed Design Documents, User Guides and Technical Uptake documents. Strong work ethic, curious and persistent determination in reviewing and reconciling variances. Ability to adjust to a fluctuating workload, changing priorities and aggressive deadlines. Highly organized and detail-oriented and can initiate proactively. Excellent verbal and written communication skills. Creative problem solver and strategic thinker with a strong work ethic and ability to work independently in a fast-paced environment
الخبرة
Salesforce Data Analyst (remote)
Performed data cleansing on Leads data set by splitting given names into first name, middle name and Last name.
Brought all phone numbers and dates in uniform format.
Imported excel data into SQL server landing table.
Performed data profiling to assess the usefulness of the data and performed imputation and transformations as per requirements and loaded the data into final reporting table.
Wrote SQLs to QA loaded data and get data in required format to create data visualizations.
Created Dashboard in Tableau to report critical KPIs like Leads Count, MQL, SAL and ARR.
Created and executed unit test cases to QA dashboard.
Created documentation for end users so that they can use dashboard effectively.
Worked on other Salesforce object analytics like Opportunity, Cases and Accounts.
Contractor
Ingested data from various sources like Google Spreadsheets, Salesforce, NetSuite, SQL Server into Snowflake data warehouse and configured daily refresh using Fivetran.
Developed Dashboards to monitor critical KPIs for Marketing and Finance departments using Tableau.
Created Bar chart, Scatter plot, Box plot, Gantt chart, Histograms, Maps and others.
Created visualizations for forecast using historical data.
Developed Extract based dashboards to make data available offline as well and configured daily extract refresh.
Authored stories in tableau and presented actionable insights to operations team.
Implemented database views wherever required to extract weekly/monthly summary information.
Wrote SQLs on daily basis to serve Adhoc data requests from operations team using concepts like Join, Sub-query, Corelated Subquery, Inline Views, WITH clause, Partition By, Regular expressions and various String, Date, Summary and Analytical functions.
Created reports in excel using VLOOUP, XLOOKUP and various other excel functions.
Performed data maintenance activities using Salesforce data loader tool.
Wrote user manual for developed dashboards and reports.