| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
BUSINESS INTELLIGENCE ANALYSTLocation: CT Phone: PHONE NUMBER AVAILABLE Email: EMAIL AVAILABLE LinkedInExperienced Business Intelligence Analyst with around 3 Years, specializing in leveraging complex data to support strategic decision- making, enabling companies to achieve key operational insights.Expert in Python and SQL, adept at managing and manipulating large datasets across multiple databases including MySQL, Oracle, MongoDB, and SQL Server, ensuring data integrity and accessibility.Utilizes Microsoft Azure to enhance data management and analytical capabilities, optimizing data storage, processing, and retrieval processes to support business needs.Proficient in utilizing advanced data analysis libraries such as NumPy and Pandas, conducting complex statistical analysis to uncover underlying patterns and insights.Creates compelling visual narratives using industry-leading tools like Tableau, Power BI, and MS Excel, transforming raw data into understandable and actionable visual reports.Conducts in-depth cost/benefit, GAP, risk, and SWOT analyses, providing critical analysis that informs strategic business decisions and risk management.Experienced in both Agile project management methodologies, effectively collaborating using tools such as Git, GitHub, and Jira to maintain project timelines and deliver high-quality results efficiently.Programming Languages: Python, SQL.Databases: MySQL, Oracle, MongoDB, SQL Server.Cloud Technologies: Azure (Data Lake, Data Factory, Synapse, SQL Data Base, Azure Monitoring).Libraries: NumPy, Pandas, Matplotlib.Data Visualization: Tableau, Power BI, MS Excel.Analytical Skills: Cost/benefit analysis, Impact analysis, GAP analysis, Risk analysis, SWOT analysis, Data Cleaning, Data Wrangling, Data WarehousingDocumentation Skills: FRD, BRD, SRSMethodologies: Agile (Scrum).Version Control & Other Skills: Git, GitHub, Jira.Soft Skills: Time management, Leadership, Problem-solving, Negotiation,Decision-Making, Documentation and Presentation, Verbal communication.University Of Bridgeport Connecticut,USAMasters in Analytics And Systems (Business Analytics) Sep 2022 - Dec 2023Osmania University Hyderabad, IndiaBachelor in Business Administration Aug 2017 - Jul 2020Data Analyst mar 2024 CurrentTekcel INC. VAEnhanced the accuracy of financial forecasts and improved report generation efficiency, contributing to more accurate financial planning and faster reporting cycles.Managed and maintained databases in SQL Server, ensuring data integrity and security while optimizing data retrieval processes to handle thousands of transactions daily.Developed detailed visualizations and comprehensive financial dashboards using Power BI and MS Excel, facilitating data-driven decision-making for over 20 key stakeholders.Conducted over 10 SWOT analyses annually, leading to strategic insights that informed key projects and improving data quality through rigorous data cleaning processes.Gathered and documented business requirements through stakeholder interviews, workshops, and surveys, ensuring all project requirements were captured accurately and comprehensively.Developed over 15 BRDs and SRSs, defining project scopes and functionalities that aligned with strategic business goals, resulting in high stakeholder approval rates.Created mockups and wireframes using Balsamiq and Lucidchart to visualize and refine user interfaces, ensuring alignment with user requirements and enhancing the design and functionality of financial applications.Employed various requirement elicitation techniques, such as stakeholder interviews, workshops, focus groups, and surveys, to gather and clarify project requirements, ensuring comprehensive understanding and accurate documentation.Facilitated Agile ceremonies including daily stand-ups, sprint planning, retrospectives, and reviews, enhancing team coordination, project transparency, and timely delivery of solutions.Coordinated sprint reviews and retrospectives, gathering feedback to continuously improve the process and deliverables, ensuring the teams alignment with project goals and stakeholder expectations.Collaborated closely with cross-functional teams using GitHub and Jira, enhancing project transparency, communication, and reducing project delivery times significantly.Performed Quality Assurance (QA) testing to ensure solutions met business requirements and quality standards, identifying and resolving defects early in the development process.Led User Acceptance Testing (UAT) sessions to validate solutions with end-users, ensuring delivered solutions met their needs and expectations, facilitating a smooth transition to production.Collaborated with QA teams to develop and execute test plans, ensuring thorough testing of new features and bug fixes, and maintaining high software quality.Data Quality Analyst Apr 2020- Apr 2022Avis Budget Group. Hyderabad, IndiaRevitalized intricate financial models, expertly assessing diverse scenarios and formulating strategic recommendations for optimal financial outcomes, resulting in a significant increase in profit margins.Engaged with senior leadership and business counterparts to integrate financial plans seamlessly with organizational goals, contributing to the accomplishment of pivotal milestones and notably decreasing operational costs.Leveraged strong relationship-building skills to work seamlessly with cross-functional teams, fostering a positive team spirit and contributing to the team's overall success, which improved overall project delivery efficiency.Led financial planning and analysis (FP&A) activities, providing valuable insights into business performance and driving data-driven decision-making processes, resulting in a notable increase in revenue.Conducted in-depth financial analysis, identifying trends, risks, and opportunities to aid strategic decision-making, resulting in improved forecast accuracy.Demonstrated expertise in Microsoft Office, particularly Excel, utilizing advanced functions including Pivot Tables, SUMIFS, VLOOKUPs, and Macros to streamline financial reporting processes and enhance data accuracy, significantly reducing reporting time.Managed the Agile product backlog, prioritizing tasks based on stakeholder impact and ensuring that the team focused on high-priority features to deliver maximum value.Business Intelligence Analyst Oct 2019 - Mar 2020ADP. IndiaUtilized Python and SQL to develop and optimize complex data queries, supporting analytics and reporting functions across various departments, handling datasets of up to 100,000 records to ensure accurate data retrieval and analysis.Managed large datasets within MySQL databases, improving data integrity during audits and optimizing storage solutions to enhance performance.Employed data analysis libraries such as NumPy and Pandas to perform detailed statistical analysis and data manipulation, uncovering trends and insights that informed business strategies, particularly in drug efficacy and market trends.Developed custom dashboards and reports in Tableau and Excel, visualizing key metrics that improved stakeholder decision-making time and enhanced data-driven strategies, delivering over 10 interactive dashboards and 20 detailed reports.Conducted thorough cost/benefit, impact, GAP, and risk analyses to assess potential business decisions and their implications on company operations and financials, leading to more informed strategic planning for drug development projects.Developed and implemented Functional Requirements Documents (FRD) and Business Requirements Documents (BRD) for 10+ major projects, aligning with strategic goals that led to successful project completions and improved project timelines.Configured and monitored Azure resources, ensuring scalability and reliability of BI solutions, utilizing Azure Data Factory and Azure SQL Database for streamlined data processing and analysis workflows, maintaining data pipelines for enhanced accessibility across multiple departments.Managed project lifecycles using Agile (Scrum), delivering business intelligence solutions efficiently by effectively coordinating tasks with Git and Jira, completing 5 project sprints on time.PROJECTSRailway Management SystemDeveloped seven tables with a sample size of 200 for each entity, implementing JOIN, GROUP BY, and UNIONS to construct intricate datasets.Executed comprehensive data analysis in SQL, ensuring accuracy, and communicated the findings adeptly, showcasing a mastery of complex table operations and result interpretation.ATP RANKINGSExported data from Kaggle to tableau and made necessary cleanup for smoother dashboard.Automated Tableau server report for the ATP Players performances using parameters, filters, and calculated sets-the dashboards allowed users to filter players based on country, rankings, total number of titles, and years.Expertly built robust forecasting using parameters, trend lines, and reference lines for easier access to view results.University Course Registration SystemDeveloped a web application for university courses registration requirement, Where various users (Data base admin, students, faculty,, staff ) can log in to add, drop, register, change the courses.SUMMARYTECHNICAL SKILLSEDUCATIONPROFESSIONAL EXPERIENCE |
