I can guide your DATA to build your DECISIONS . A skillful and passionate Data Analyst pursuing masters in INFORMATION TECHNOLOGY & MANAGEMENT. TECHNICAL SKILLS Analytical Tools: Tableau, SAS EM, Power BI, QlikView, SAP Business Objects, Crystal Reports, SAP Lumira, SAP Analysis for Office, Advance Excel, SAP BEx Query Designer, Predictive Analysis using SAP Software’s: Toad, Nexus Query Chameleon, SAP NetWeaver, IBM Netezza, SSIS, HP ALM, JIRA, Kanban board Programming Languages: SQL, Apache Hive – HQL, Python-Pandas, HTML, CSS Database: Big Data – Hadoop System, SAP S/4 HANA, Microsoft SQL Server, RDBMS. BUSINESS EXPERIENCE CHARLES SCHWAB & CO. Digital Services Analyst Intern - Analytics Business Insights -Built 5+ Tableau Dashboard for Digital Accelerators querying approx. 1M data loaded into the Big Data – Hadoop system from Adobe Analytics Database with the help of Apache Hive - HQL scripting in Nexus Query Chameleon gaining 99% accurate insights. -Automated the Web Analytics Dashboards with the help of 19 UNIX and 26 SQL jobs, which ran through manual intervention before, saving 67% of the time & saving approximately $2.5M. TATA CONSULTANCY SERVICES (I) Bank of Montreal as SQL Analyst and IT Business Operations Data Analyst. (II) DellEMC as a Data Analyst. - Conducted ETL of the Data from the delimited files to OLAP DB for approximately 10,000 records. -Designed 167 SQL QA queries accessing the company’s Enterprise Data Warehouse applying various kinds of transformations which saved approximately 15% time to compare Business and production Data. -Analyzed dataset in MS Excel & worked as a liaison with BI to communicate requirement gathering. -Acquired structured and unstructured data, prepared it for analysis and built Reports, Dashboards using Tableau Reporting tool and PowerBI with 99% accurate insights. -Generated various kinds of visualizations using Matplotlib and NumPy library for analysis in Python. Thanks for viewing.
[email protected] ©