| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
PHONE NUMBER AVAILABLEEMAIL AVAILABLEBusiness Analyst /Data AnalystPROFESSIONAL SUMMARY:Over 7 years of experience in business analysis,DATA Analytics leveraging SQL and PostgreSQL for complex data queries and database management.Proficient in using Microsoft Excel for advanced data analysis, financial modeling, and dashboard creation.Skilled in implementing and optimizing Power BI for business intelligence solutions and data visualization.Expert in utilizing QlikView to design and deploy interactive dashboards that enhance decision-making processes.Experienced in integrating Apache Hadoop and Spark for processing large datasets and performing big data analytics.Utilized GIT for version control in software development projects, enhancing team collaboration and code quality.Developed comprehensive CRM solutions using Salesforce, improving customer interactions and sales strategies.Employed Adobe Analytics for digital marketing insights and customer journey optimization in the insurance domain.Conducted in-depth business analytics using Qualtrics and Typeform to capture and analyze customer feedback effectively.Designed and managed interactive dashboards using Qlik Sense to provide real-time data visualization in the biotechnology sector.Leveraged Looker for business intelligence and data analytics, making complex datasets accessible for strategic decision-making.Utilized MATLAB for complex mathematical computations, supporting advanced research and development in biotechnology.Implemented Matplotlib alongside Python for detailed statistical visualizations, enhancing analytical reports.Managed Azure SQL databases and utilized Azure Stream Analytics for real-time data processing and analytics.Experienced in using R for statistical analysis and predictive modeling in financial and biotechnological applications.Orchestrated project management using Trello, enhancing project tracking and team productivity.Facilitated remote team collaborations and project management using Webex, optimizing communication across departments.Implemented and managed SQL Server environments to support financial data management and complex querying.Developed and monitored performance metrics using SQL, creating a foundation for data-driven business improvements.Applied SWOT analysis framework extensively to identify strategic opportunities and mitigate risks in business planning.Utilized Gantt charts for detailed project scheduling and resource allocation, ensuring timely project completions.Enhanced business processes and customer relationship management through effective CRM and ERP system integrations.Expert in documentation and reporting, utilizing standard tools to maintain transparency and compliance in data handling.Conducted competitive analysis and market trends research to guide strategic business developments and positioning.Continuously updated technological skills, staying ahead in utilizing modern tools for data analysis and business intelligence.TECHNICAL SKILLS:Data Analysis : SQL, PostgreSQL, Microsoft ExcelBusiness Intelligence : Power BI, QlikView, Tableau, Qlik Sense, LookerCRM and ERP Systems : Salesforce, CRM AnalyticsProject Management : Trello, Webex, GanttStatistical Analysis : Python, R, MATLAB, MatplotlibCloud Services : Azure SQL, Azure Stream Analytics, Microsoft AzureProgramming and Databases : SQL, PostgreSQL, GITDocumentation and Reporting : Microsoft Excel, Standard Reporting ToolsPROFESSIONAL EXPERIENCE:Client: Edward Jones, St. Louis, MORole: Business /DATA Analyst Duration: Dec 2022 to PresentRoles & Responsibilities:Developed strategic business plans by employing SWOT analysis and integrating market trends to identify new investment opportunities and capitalize on market shifts.Analyzed large datasets using SQL to derive insights that enhanced decision-making, customer service delivery, and capital allocation strategies.Employed R for in-depth statistical analysis, supporting sophisticated financial strategies, portfolio management, and capital planning.Managed multiple projects using Trello, ensuring on-time delivery and high standards of financial service solutions.Conducted detailed competitive market analysis to strategically position Edward Jones in the competitive financial services industry and optimize capital investment.Created dynamic SQL-based tools to analyze performance metrics, continually improving business processes and informing capital expenditure decisions.Utilized Power BI to develop interactive dashboards that provided real-time insights into key performance indicators, including capital performance.Streamlined project management and communication using Webex, facilitating effective remote collaboration.Developed and maintained SQL Server databases to ensure robust data management and integrity across financial operations, including capital tracking.Implemented GIT within an Agile framework to manage source code and ensure high-quality project documentation.Analyzed current market trends to develop effective business strategies, adapt to evolving market conditions, and optimize capital usage.Utilized the Gantt chart to track project progress and ensure efficient resource allocation and deadline compliance.Employed competitive analysis to develop market insights that informed business strategy, operational improvements, and capital deployment.Configured and managed R environments for detailed statistical analyses, enhancing data-driven decision-making related to capital investments.Utilized SQL to perform complex data queries that supported financial analyses, capital planning, and business reporting.Developed business intelligence solutions using Power BI to visualize financial data, capital expenditures, and improve transparency.Managed CRM strategies using Salesforce, enhancing customer engagement and optimizing sales processes.Utilized Microsoft Excel to perform financial modeling, scenario analysis, and capital budgeting activities.Accurately mapped and migrated data from the source to the target system, ensuring compatibility and integrity across different formats.Rigorously tested migrated data for completeness, accuracy, and functionality in the target environment to ensure successful migration.Implemented a robust backup and rollback plan to safeguard against data loss or corruption during the data migration process.Conducted performance metrics analysis to identify areas for improvement and drive business process optimization, including capital efficiency.Contributed to the development of an AFS vision by implementing advanced forecasting models using SQL and Power BI, providing actionable insights to optimize capital allocation and drive strategic investment decisions.Streamlined financial forecasting processes by integrating AFS tools, enhancing the accuracy of capital planning and forecasting, and improving decision-making through real-time data visualization.Developed comprehensive business reports using SQL and Power BI, providing stakeholders with actionable insights into capital utilization.Implemented Agile methodologies using Trello to enhance project flexibility and adapt to changing requirements.Streamlined data management processes using SQL Server, improving data accuracy, accessibility, and capital management.Created detailed documentation for financial processes, capital management, and data practices, ensuring compliance and knowledge sharing.Utilized Webex for conducting remote meetings and workshops, enhancing team collaboration and project communication.Maintained and updated project documentation using GIT, ensuring all project stakeholders had access to current files and reports.Environment: SWOT analysis, SQL, R, Trello, competitive market analysis, Power BI, Webex, SQL Server, GIT, Agile methodologies, Gantt chart, Salesforce, Microsoft Excel, capital management.Client: Regeneron Pharmaceuticals, Rensselaer, NY May 2021 to Jun 2022Role: Business AnalystRoles & Responsibilities:Led SQL-driven data analysis projects that supported critical biotechnology research and development initiatives.Developed real-time interactive dashboards using Qlik Sense to visualize scientific data, enhancing research outcomes.Utilized Looker to integrate comprehensive data insights into daily operations, making complex datasets accessible for strategic decision-making.Implemented MATLAB for complex biotechnological computations, supporting drug discovery and development projects.Managed extensive data warehousing solutions using Microsoft Azure, ensuring secure and compliant storage of research data.Configured and maintained Azure SQL databases for robust data management and streamlined analytics processes.Employed Matplotlib alongside R to create detailed statistical visualizations, supporting data analysis in clinical trials.Utilized Power BI to develop interactive dashboards for monitoring research data, improving visibility and decision-making.Developed and maintained data integration pipelines using Azure Stream Analytics, facilitating real-time data processing.Conducted complex data analyses using SQL to extract actionable insights from large datasets in the biotech sector.Implemented MATLAB scripts for data manipulation and analysis, aiding in the simulation of drug interactions.Utilized R for statistical modeling of experimental data, enhancing the accuracy and reliability of clinical outcomes.Created Looker dashboards to provide ongoing monitoring of biotechnological experiments and research data.Maintained rigorous documentation standards using Microsoft Excel, ensuring clear recording of research methodologies and results.Utilized Microsoft Azure for cloud-based data storage and analytics, ensuring scalability and security of biotechnology data.Configured SQL Server Integration Services (SSIS) to automate data loading and transformation processes.Developed extensive data reports using Excel and Power BI, delivering critical insights to research teams and stakeholders.Managed data security and compliance using Azures security features, ensuring protection of sensitive research data.Employed GIT for version control in collaborative research projects, enhancing code management across the research team.Integrated Qlik Sense analytics with existing biotechnological data platforms, improving the comprehensiveness of data analysis.Utilized Azure SQL for managing and querying large-scale biotechnological datasets, ensuring efficient data operations.Orchestrated the migration of research databases to Azure Cloud, improving data accessibility and collaboration among researchers.Environment: SQL, Qlik Sense, Looker, MATLAB, Microsoft Azure, Azure SQL, Matplotlib, R, Power BI, Azure Stream Analytics, Microsoft Excel, SQL Server Integration Services (SSIS), GIT.Client: Delta Dental, Chicago, IL. Jan 2019 to Apr 2021Role: Data AnalystRoles & Responsibilities:Enhanced CRM functionalities by integrating Salesforce, optimizing customer interactions and data management.Developed SQL queries for in-depth analysis of insurance claims, supporting business decisions and operational efficiency.Implemented Adobe Analytics to track user behavior on digital platforms, improving customer engagement strategies.Utilized Microsoft Excel for financial modeling, aiding in the prediction of insurance trends and customer behavior.Conducted customer feedback analysis using Qualtrics and Typeform, directly influencing product development and customer service improvements.Developed comprehensive CRM reports using Salesforce, enhancing data-driven decision-making across the insurance domain.Configured Adobe Analytics dashboards to monitor marketing campaigns, optimizing digital marketing efforts and ROI.Leveraged SQL to extract and analyze customer data, supporting targeted marketing strategies and customer segmentation.Utilized Microsoft Excel to streamline budget tracking and expense reporting, improving financial accuracy and accountability.Integrated customer survey data from Qualtrics into CRM, enhancing customer profiles and improving service delivery.Worked closely with multiple agencies, vendors, and departments within a large enterprise environment to ensure seamless operations and integration of services.Gained over 6 years of experience in direct customer interaction, ensuring high levels of customer satisfaction and loyalty.Developed and maintained telecommunications strategies, ensuring robust communication infrastructures across multiple network platforms and lines of service within the enterprise.Worked closely with multiple agencies, vendors, and departments within a large enterprise environment to ensure seamless operations and integration of services.Provided excellent customer service and communication, effectively disseminating information to technical teams, customers, and managers, ensuring clarity and alignment across all stakeholders.Worked extensively with various network platforms, including WAN, MLAN, WLAN, security, voice, and videoconferencing, understanding and managing the complexities of a large enterprise network environment.Managed database updates and maintenance using SQL, ensuring data integrity and security for insurance operations.Implemented Typeform to streamline the collection of customer testimonials, enhancing marketing materials and public relations efforts.Analyzed social media interactions using Sprout Social, providing insights into customer preferences and trends.Conducted competitive analysis using Salesforce data, identifying opportunities for market expansion and product enhancement.Utilized Microsoft Excel to conduct risk assessments, supporting the development of new insurance products and services.Developed and maintained touchpoint dashboards in Salesforce, providing real-time insights into customer interactions across channels.Utilized SQL for creating custom reports and dashboards, enhancing the visibility of key performance indicators.Implemented Adobe Analytics for detailed tracking of customer journey analytics, optimizing user experience and conversion rates.Environment: Salesforce, SQL, Adobe Analytics, Microsoft Excel, Qualtrics, Typeform, Sprout Social.Client: Synechron INC, Hyderabad, India Mar 2017 to Dec 2018Role: Data analystRoles& Responsibilities:Managed and optimized PostgreSQL databases to support high-volume data transactions and ensure data integrity.Developed ETL processes using Informatica, ensuring efficient data transformation and loading for analytics purposes.Created dynamic dashboards in Power BI, providing actionable insights into transaction metrics and business performance.Utilized Apache Hadoop and Spark for big data analytics, processing large datasets to drive business decisions.Implemented version control with GIT in a collaborative development environment, enhancing code management and team collaboration.Designed and documented data workflows in Microsoft Excel, ensuring clarity and consistency in data handling procedures.Utilized SQL for database management and complex data queries, supporting business intelligence and analytics initiatives.Developed and maintained data integration pipelines using Apache Spark, enhancing data availability and analysis capabilities.Conducted data visualization and reporting using Power BI, transforming complex data sets into understandable business insights.Managed source code and documentation using GIT, ensuring version control and historical tracking of development projects.Leveraged PostgreSQL for database administration, optimizing performance and ensuring scalability of data operations.Implemented data backup and recovery procedures using Informatica, safeguarding critical business data against loss.Utilized Apache Hadoop for distributed data processing, supporting scalable analytics across large data sets.Developed reports and dashboards in QlikView, enabling real-time data visualization and decision-making support.Conducted performance tuning of PostgreSQL databases, improving response times and operational efficiency.Environment: PostgreSQL, Informatica, Power BI, Apache Hadoop, Apache Spark, GIT, Microsoft Excel, SQL, QlikView.Education:Master's in Project Management Missouri State University |
