Sameer Mohammed Email & Phone Number

Proberta, Ca, Us

Dallas, Texas, United States

• Helped the client in retiring two of the UDAs (User Developed Applications) by automating them to IT- supported systems.• Converted SAS code into NZSQL queries and created dashboards.• Worked with the EMM business team and helped them with creating multiple dashboards and ad-hoc reports based on the requirement.• Worked with the EPP team as a Payments Analyst and helped them with Cost Per Transaction Analysis of different payment gateways like Zelle, Wires, Funds transfer, and Bill Pay.• Created reports in Excel according to the team’s needs.• Build Pivot tables and VLOOKUP’s and do deeper analysis as per the requirement• Built Dashboards using Power BI and exported data to create Excel dashboards based on urgent requirements.• Worked with the ESM team as Power BI Developer and built dashboards from scratch using existing SAS code and converted the SAS code into SQL queries.• Involved in Tableau dashboard lifecycle which begins with understanding the clientele needs and requirements gathering and data analysis and creating the dashboards and publishing them to the tableau server along with scheduling the refreshes accordingly.• Involved in analyzing and reviewing data from various sources like Netezza, Excel, and CSV and performed joins and data blending techniques accordingly.• Built complex dashboards according to the client requirements and published them to the Tableau Servers, Worked as Site admin as well.

Hyderabad, Telangana, India

• Read source data from various databases including Azure SQL DB, CSV, Oracle, and SQL Server using Power BI. Additionally, read different formats of source data from Hive such as JSON, ORC, and TXT• Hands-on experience in Tableau, adept at crafting dynamic dashboards, reports, and visualizations to extract actionable insights from complex datasets. Skilled in data preparation, manipulation, and analysis, utilizing Tableau's features to uncover trends, patterns, and correlations, thereby facilitating informed decision-making processes.• Implemented efficient context and data source filters for managing large data volumes. Utilized various DAX functions, including aggregation and logical operations, for effective source data analysis. Employed DAX table functions like FILTER and ALL. Utilized Z-order in Power BI for enhanced report visualization. Developed data analysis prototypes using Power BI and Power Pivot, visualized through Power View and Power Map. Customized a variety of visualizations, including charts, slicers, maps, tables, and gauges. Published and made Power BI reports accessible to web clients, ensuring their currency via Power BI Gateways.• Created multiple data model and used it as a common data source for the reporting purpose. • Utilized SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS), involved in crafting, enhancing, and fine-tuning ETL procedures and multidimensional databases to support effective data warehousing and business intelligence initiatives.• Collaborated closely with the ETL team to implement Copy activity and Custom Azure Data Factory Pipeline Activities for On-cloud ELT processing. Engaged in ETL processes, developing source-to-target data mappings, integration workflows, and load processes. Conducted data quality assessment of source system data using SQL queries. Designed ETL processes and developed source-to-target data mappings,

Hyderabad, Telangana, India

• Gathered and analyzed the business requirements and then translated them to technical specifications and designed documents for development.• Actively participated in interaction with Users, Team leads, DBA, and Technical Managers to fully understand the requirements of the system.• Worked extensively using EXCEL to validate the data and use them as the source data files.• Analyzed the data using statistical features in Tableau to develop Trend Analysis.• Provided mock-up visuals to speed up the requirement visualizations.• Hands-on experience in creating and modifying worksheets and data visualization dashboards.• Created LOD(Level of Detail) expressions data source columns that are computed for each row in the underlying data.• Created Data Source Level Filter, Context Filter, and Cascading Filters to improve performance and user flexibility.• Performed tuning of reports and resolving issues with Tableau Server.• Created Side by Sidebars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps, and Symbol Maps according to deliverable specifications.• Used Trend Lines, Log Axes, Groups, Hierarchies, and Sets to create a detail-level summary report and Dashboard using KPIs.• Involved in fixing the bugs and handled the CR (Change Requests) & interacted with clients for the requirement for different CRs and bug fixing after client site testing.• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.• Knowledge of Tableau servers such as Hosting and Embedding the views in a web page.• Created Relationships, Actions, Data Blending, Filters, Parameters, Hierarchies, Calculated Fields, Sorting, Groupings, and Live connections In-memory in both Tableau and Excel.• Worked extensively with Advance analysis Actions, Background images, and Maps.• Worked as a Developer in creating complex Stored Procedures, Triggers, Tables, and other SQL code and SQL Joins for applications.

Hyderabad, Telangana, India

• Worked directly with Business lines in Customer care, Loans, Management Information Systems, and Card management to gather dashboard requirements for development.• Extensive experience in reviewing those business requirements and analyzing data sources from Excel/ Oracle SQL Server to Design, Develop, test reporting, and analyze projects within Tableau Desktop.• Created views in Tableau Desktop that were published to the internal team for review and further data analysis and customization using Filters and Actions.• Created Heat Maps showing current service subscribers by the color that was broken into regions allowing business Users to understand where we have the most users vs. least users.• Projected and forecasted future growth by developing reports to show in detail.• Converted charts into Crosstabs for further underlying data analysis in MS Excel.• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle, SQL Server, and MS Excel.• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.• Combined various workbooks into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.• Reviewed basic SQL Queries and edited inner, left, and right Joins in Tableau Desktop by connecting Live/Dynamic and Static datasets.• Developed storytelling dashboards in Tableau Desktop and published them on• Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on-demand needed information.• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.

Education record

Bachelor Of Technology - Btech, Computer Science, B