Profile
Dynamic Business Intelligence (BI) Analyst with over 5 years of experience in leveraging data-driven insights to drive business improvements and optimize overall performance. Proficient in a range of BI tools and technologies, with a proven track record of designing and deploying dashboards, data visualization, and advanced analytics solutions.
Professional Experience
Business Intelligence Analyst, BNY Mellon 09/2022 – present USA
•Spearheaded the agile transformation initiative, resulting in a 20% improvement in project delivery times by managing various functional roles and implementing best practices.
•Supervised the use of Jira across 5 major projects, improving task tracking efficiency by 30%. Regularly conducted training sessions, raising team Jira proficiency by 50%.
•Actively interfaced with cross-functional teams, ensuring that over 90% of business needs were accurately translated into detailed BI requirements.
•Utilized Python libraries to preprocess data from multiple diverse sources, increasing data accuracy by 25% and making insights more reliable.
•Analyzed data using SQL, revealing patterns that led to the implementation of 3 key business strategies with projected revenue impacts of over $5 million.
•Developed SSAS multidimensional cubes, resulting in a 35% improvement in data retrieval times for complex analytical tasks.
•Tweaked and optimized DAX calculations in Power BI reports, achieving a 40% reduction in report loading times and enhancing the user experience for 500+ internal users.
•Managed and maintained Snowflake data warehouses, ensuring 99.9% uptime and consistently high data integrity.
Business Intelligence Analyst, Boost FinCrop Group 08/2018 – 07/2021 India
•Utilized SAP ERP systems for ETL processes on datasets, reducing data processing times by 25% and enhancing the efficiency of subsequent reporting.
•Pioneered methodologies that extracted data from sources, consolidating it into a central database that increased repurchase pattern recognition by 15%.
•Employed Python scripts to automate routine data tasks, decreasing manual interventions by 40% and bolstering data accuracy by 20%.
•Oversaw the design, development, and maintenance of key BI solutions, ensuring 98% uptime and addressing real-time operational needs.
•Provided troubleshooting support for BI tools, reducing downtime by 30% and consistently receiving positive feedback for quick issue resolution.
•Developed dashboards using Snowflake's BI capabilities, resulting in a 50% increase in stakeholder engagement and more effective decision-making.
•Collaborated with 5 different departments to understand and address their unique data needs, leading to the successful completion of inter-departmental BI projects.
•Hosted stakeholder meetings annually, refining BI tools based on feedback and ensuring a 90% satisfaction rate with the implemented tools and dashboards.
•Designed and launched collaborative Tableau dashboards, leading to a 20% reduction in data retrieval times and boosting overall data accessibility for over 200 users. Tejas Patil Business Intelligence Analyst
ad3mmq@r.postjobfree.com 551-***-**** NJ, USA LinkedIn
Business Intelligence Analyst, Draxo Infotech 07/2017 – 07/2018 India
•Enhanced ETL processes from SAP ERP systems, reducing data processing times by 25%, thereby facilitating more timely and efficient reporting on business metrics.
•Leveraged Python for ETL on datasets, improving process efficiency by 20% and ensuring a 15% increase in data accuracy, benefitting downstream analytics.
•Developed interactive Power BI dashboards, resulting in a 30% increase in data accessibility and enhancing stakeholder decision-making speed by 25%.
•Utilized VLOOKUP and other advanced Excel functions to integrate data from sources, reducing reconciliation efforts by 50% and saving an average of 10 hours per week.
•Achieved a 98% accuracy rate for integrated data, ensuring that the insights delivered to stakeholders were consistently reliable.
•Conducted analyses on key business processes, pinpointing 3 major bottlenecks and providing recommendations that were adopted in 2 process improvement initiatives.
•Worked with distinct business units, collecting and addressing detailed BI requirements, which directly influenced the creation of 10+ tailored BI solutions.
•Held bi-weekly meetings with department heads and IT professionals, leading to a 20% improvement in BI tool functionality based on feedback and ensuring alignment with evolving business needs. Skills
Programming & Scripting (Python (Pandas, NumPy, Scikit-learn), R, SQL, VBA for Excel) Databases (SQL Server, MySQL, Oracle, PostgreSQL)
ETL & Warehouses (Informatica, Talend, SSIS, Apache NiFi, Snowflake, Amazon Redshift, Google BigQuery, Teradata, Apache Hadoop, Apache Spark, Hive)
Reporting & Visualization (Tableau, Power BI, DAX, Google Data Studio) Tools (JIRA, GitHub, SAS, MS Excel, MS PowerPoint, Trello, Asana) Others (Analytical Skills, Problem-solving, Data Modeling, Data Visualization, Project Management, Statistical Analysis, Decision-making, SDLC, Agile Methodology, Waterfall Model) Education
Master of Science, Pace University 09/2021 – 12/2022 New York, USA Information Systems
Bachelor of Technology, Mumbai University 08/2012 – 05/2015 Mumbai, India Electronics & Telecommunication