• Around 7 years of professional & academic experience in different capacities such as Business Intelligence Analyst, IT Business Analyst, QA Analyst, Data Analyst & IT Operations Analyst • Helped business reduce the operational cost by 57% relative to the last quarter for 3 different regions using Tableau, SSMS, SSRS, SSIS for Auto-finance startup • Improved the query performance by 47% by employing different mechanisms such as indexing, partitioning, distribution etc. to help faster data retrieval for client-facing reports & dashboards • Adept at understanding the business process and documenting requirements & creating data models across different tools, a strong understanding of SDLC, agile SCRUM, waterfall & KANBAN development as well as software testing methodologies. • Experienced in statistically analyzing data through statistical tools, SQL, Microsoft Excel and well versed in generating ad-hoc live reports as well as dashboards (using rollup & drill-down mechanism) • Helped in designing the conceptual & logical dimensional model after requirement gathering. Perform impact analysis by creating & maintaining the metadata excel sheet to accurately identify the mapping across different systems & accurately identify the SCD type to create the data lineage across different systems. Architect the data pipelines in the reporting layer as well as in the database for several business stakeholders & analyst to consume across the board & do analysis as required • Business Analysis: SDLC, requirement gathering, database modeling, data warehouse modeling, and software testing, Microsoft Visio for UML modeling, Microsoft Project for Project Management, HP QC ALM, JIRA, Microsoft TFS • DBMS: Microsoft SQL Server, MS-ACCESS, Amazon Redshift, Amazon Athena, NoSQL & PostgreSQL. • Business Intelligence/OLTP/Visualization Tools: Tableau, Tableau Server, Tableau Online, Tableau Bridge Client, Tabcmd Qlick Sense, Google Analytics, Power BI, Quicksight. • Programming Skills: SQL, HTML, Object Oriented Programming, R programming, VBA. • Statistical tools: Statistics, Microsoft Excel, SPSS, XL Miner, MEXL. • Conceptual Knowledge: Big Data, Pig, Hive, Map Reduce, Hadoop, SAS, MySQL.Soft Skills: Excellent verbal & written communication skills, critical thinking, problem-solving, leadership, experienced with delivering professional presentations and seminars to C-suite executives, SVP, Directors.