Akram Pathan Email & Phone Number

Jersey City, Nj, Us

New York, United States

•Executed data analysis using Python and SQL to extract, clean, and transform datasets, ensuring high data quality and consistency, improving the accuracy of over 10 internal reports.•Conducted user research and analysis, developing 3+ Tableau dashboards to visualize user interactions, which informed design decisions and enhanced UI clarity and user satisfaction.•Collaborated with cross-functional teams to translate data insights into intuitive AI chatbot designs, optimizing user interactions and boosting engagement by aligning the product with user needs.•Led 5+ user testing sessions, analyzed results, and presented findings through data visualizations to drive design refinements, resulting in advanced usability and refined user experience.

Mumbai, Maharashtra, India

•Consolidated financial data from transactional databases, accounting systems, and financial reporting platforms into a unified repository, managing over 1 million records to ensure comprehensive data coverage.•Engineered and implemented complex SQL queries to extract, merge, and integrate financial data into Oracle databases, ensuring data completeness and accuracy across all datasets. •Harnessed pandas for advanced numerical computations and sophisticated data manipulation tasks, including dataset merging, data filtering, and the creation of 20 new calculated fields relevant to financial metrics and performance indicators. •Crafted insightful visual representations using Power BI, effectively translating complex financial data patterns, correlations, and trends into easily digestible formats for stakeholder comprehension. •Constructed dynamic, interactive dashboards in Power BI to visualize key financial performance indicators, revenue growth, expense analysis, and profitability metrics, providing stakeholders with real-time insights. •Formulated detailed Excel reports featuring pivot tables, charts, and summaries to communicate analytical findings and financial recommendations effectively. •Orchestrated AWS services including EC2 for scalable computing resources, S3 for secure and durable data storage, Lambda for serverless data processing tasks, RDS for relational database management, and RedShift for data warehousing and complex query execution. •Spearheaded project lifecycles using Agile methodologies, collaborating with cross-functional teams to ensure timely delivery of project milestones and objectives related to financial performance analysis. •Employed GitHub for version control, ensuring proper tracking of changes and collaboration with development teams to maintain the integrity and accuracy of financial data analysis processes across 5+ projects.

India

•Utilized Python to extract, transform, and analyze sales data from multiple sources, developing automated scripts that cut data processing time by 50 hours per month and boosted the overall efficiency of the sales data analysis workflow.•Designed and optimized MySQL databases to store and manage large volumes of sales data, implementing indexing strategies and query optimizations that enhanced data retrieval speed.•Created comprehensive, interactive dashboards and reports using Power BI and MS Excel, translating intricate sales data patterns into visually compelling presentations that drove strategic decision-making across sales departments.•Managed code repositories for the sales data analysis project using Git, tracking changes, and maintaining code integrity throughout the development lifecycle of 12 analytical models and data pipelines.•Conducted thorough data cleansing and quality assurance processes on the sales data, applying statistical methods and custom algorithms to identify and rectify data anomalies, resulting in increased data accuracy and reliability for critical sales reports.•Performed advanced statistical analyses on sales data using NumPy and other Python libraries, including regression modeling, hypothesis testing, and time series analysis, to uncover key business insights that contributed to operational efficiency in sales processes.

Master Of Science - Ms, Data Science, 3.7/ 4.0

Bachelor Of Technology - Btech, Computer Science, 3.6 / 4.0

Xi- Xii, Hsc(Higher Secondary Certificate), 83.23%

V-X, 93.20%