Skills
Technical Skills
Tools:Tableau, MS Power BI, MS Excel, Alteryx, Dataiku, Databricks, Confluence, JIRA.
Programming:Python, R, ASP. Net, PL/SQL, JavaScript, HTML, CSS.
Certification Tableau Data Analyst, Google Business Intelligence Professional, Google Digital Analytic.
Databases /Big data MS SQL, Snowflake, Azure SQL, GCP, Oracle Toad, Hadoop, Hive, SSIS, RDBMS.
About
• Results oriented professional with 9+ years of experience with business intelligence, data analytics and visualization in Retail, CPG, Finance, Banking, Capital Markets and Marketing Highly skilled in System Analysis, ER/Dimensional Data Modeling, Database design and implementing RDBMS specific features.
• Experience in DBMS/RDBMS implementation using object-oriented concept and database toolkit.
• Led stakeholder domain and collaborated with supply and demand SME workstreams to migrate data from on-premises warehouse to AWS Redshift and reporting architecture.
• Designed and implemented data engineering functions on AWS cloud, creating end-to-end data pipelines.
• Automated ETL processes using Python scripts, reducing reporting overhead by over 75%.
• Automated monthly reporting in Tableau, saving 20% team time.
• Gathered stakeholder requirements, creating 8+ Tableau visualizations supporting strategic decisions.
• Conducted data exploratory analysis using Python, R, SQL in Databricks, providing insights on consumer transactions.
• Experience in identifying critical information in process automation supply chain analytics,
• building vendor relationships manufacturing losses reduction, marketing analytics and building claims forecasting models Extracted and processed data from Data lakes, developed Python scripts in Databricks.
• Connected Snowflake to Databricks, collaborated with customer analytics teams, and designed dashboards to analyze homepage load times.
• Interacted with stakeholders, proficient in Tableau, and snowflake using SQL for dashboard development.
• Developed ETL workflows in Alteryx, performed data validation, and prepared technical specifications.
• Generated BI reports, developed Tableau and Power BI dashboards translating stakeholder requirements.
• Developed complex visualizations, prepared technical documentation, and automated report generation using Python.
• Created SQL queries, stored procedures, views, and conducted SQL server maintenance.
• Led requirements gathering for sales and marketing KPIs, translating requirements into intuitive dashboards.
• Utilized Azure ML Studio, Dataiku, and Alteryx for data analysis and visualization.
• Working with RDBMS includes MS SQL Server - Oracle 8i, 9i, 10g, 11g, 12c and MS-Access.
• Experience on building OLAP Cubes in SQL Server Analysis Services (SSAS) and reports on it.
• Experience in quantitative analysis and data mining using Excel, SAS and SSAS.
• Knowledge on Azure Data bricks, Data Lake and Data analytical engine works.
• Engineered ASP.NET web applications for financial decisions, conducted data analysis, and utilized JavaScript, HTML, CSS for dashboards.
• Developed WPF components, used ADO.NET for data manipulation, and deployed applications on Azure.
• Strong experience on MS SQL Server - using SQL, MS SQL, SSIS and T-SQL. Have worked on ETL using SSIS and DTS packages.
• Experience translating business requirements into technical requirements and enable decision making by retrieving and aggregating data from multiple sources.
• Strong time management skills to manage work plans, handle tight deadlines and multiple projects.
Profile Photo
