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

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.
• 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.
• 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.
• 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.

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.

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.

Education record

Bachelor Of Technology - Btech, Computer Science, B