I can guide your DATA to build your DECISIONS ?.
A skillful and passionate Data Analyst pursuing masters in INFORMATION TECHNOLOGY & MANAGEMENT.
Analytical Tools: Tableau, SAS EM, Power BI, SAP Business Objects, Crystal Reports, SAP Lumira, SAP Analysis for Office, Advance Excel, SAP BEx Query Designer
Software’s: Toad, Nexus Query Chameleon, SAP NetWeaver, Netezza, SSIS, MS Project, JIRA, Kanban
Programming Languages: SQL, Apache Hive – HQL, HTML, CSS
Database: Big Data Environment – Hadoop System, SAP S/4 HANA, Microsoft SQL Server, RDBMS, IBM Netezza
CHARLES SCHWAB & CO
-Digital Services Analyst Intern - Analytics Business Insights
Queried approx. 1M data loaded into the Big Data Environment from Adobe Analytics Database with the help of Apache Hive - HQL scripting in Nexus Query Chameleon replicating the Adobe Data Structure.
Converted HQL scripts to SQL and used Custom SQL Editor of Tableau to build 6 insightful Dashboards gaining 97% efficient results.
Automated these Web Analytics Dashboards with the help of UNIX and Report Tracker, which ran through manual intervention before, saving 87% of the time and saving approximately $2.5M.
TATA CONSULTANCY SERVICES.
-SQL Analyst – Bank of Montreal
Developed ETL Mappings using Netezza SQL to extract the data from flat files, CSV files and transformed it to the Staging area, EDW and then to the Data Marts (OLAP DB) for approximately 10,000 records.
Analyzed ETL Mappings & Designed 167 SQL QA queries based on Facts & Dimensions from Source to target tables for directs moves and indirect moves based on transformation rules & lookup tables comparing Business and production Data with the accuracy and efficiency of 99%.
-Data Analyst – DELL-EMC
Analyzed dataset in MS Excel and worked as a liaison with BI to communicate requirement gathering.
Built Tableau Dashboards from structured and unstructured data with 99% accurate insights.
Thanks for viewing.