| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Candidate's Name
Senior Business/Data Analyst
EMAIL AVAILABLE
PHONE NUMBER AVAILABLE
Linkedin
PROFESSIONAL SUMMARY
Possessing over 10 years of extensive experience as a Senior Business/Data Analyst, excelling in complex
data-driven decision-making.
Advanced proficiency in SQL and MySQL for database management, performing complex data analysis
to support strategic business decisions.
Expertise in using Microsoft Excel for data manipulation and analysis, utilizing advanced formulas to
derive actionable insights from data sets.
Skilled in creating dynamic visualizations and dashboards with Tableau, enhancing data presentation and
business decision-making processes.
Proficient in using Talend Open Studio for data integration, facilitating effective data transformations
and workflow automation.
Experienced in version control management with Git, ensuring consistency and collaboration across
various analytics projects.
Utilized Docker to establish reproducible environments for data analysis projects, ensuring consistency
across team outputs.
Leveraged Jupyter Notebooks for exploratory data analysis, providing a versatile platform for data
manipulation and visualization.
Applied ANSI SQL skills to maintain and query large-scale databases, enhancing data retrieval and
reporting capabilities.
Utilized Pivot tables in Excel to analyze and summarize large datasets, enabling data-driven decision-
making.
Created dynamic Pivot charts to visualize trends and patterns, providing actionable insights to
stakeholders.
Utilized Python for statistical analysis and predictive modeling, driving insights and forecasts that inform
business strategies.
Gathered and analyzed business requirements to implement and optimize solutions using Microsoft
Dynamics 365 (D365).
Employed SAS for detailed statistical analysis, supporting business decisions with robust data-driven
evidence.
Developed interactive and real-time business intelligence dashboards using Power BI, facilitating deeper
insights into corporate performance metrics.
Utilized MATLAB for mathematical modeling, providing support for complex quantitative analyses and
operational research.
Managed project collaboration and documentation using Trello, streamlining project tracking and
enhancing team productivity.
Facilitated effective remote collaboration and project management using Webex, ensuring timely
communication across distributed teams.
Enhanced data storage and management using SQL Server, supporting enterprise-level database
management and development.
Utilized Vita to manage project documentation, ensuring clear and organized records of business
requirements and analysis.
Collaborated with stakeholders using Vita to gather and document business requirements, ensuring
alignment with project goals.
Integrated R for comprehensive statistical analysis and data visualization, enabling detailed data study
and interpretation.
Managed large datasets using HDFS, improving data accessibility and analysis in distributed computing
environments.
Implemented Snowflake for cloud-based data warehousing, enabling scalable, secure, and cost-effective
data storage solutions.
Utilized AWS S3 for robust data storage solutions, enhancing data accessibility and security in cloud
environments.
Developed business intelligence solutions with AWS QuickSight, providing fast, cloud-powered analytics
to drive business decisions.
Streamlined documentation and project management using Confluence, enhancing knowledge sharing
and collaboration among stakeholders.
Created detailed process maps and technical workflows using Lucid Chart, aiding in the visualization of
complex processes for better understanding.
Managed project requirements and issue tracking using JIRA, ensuring thorough project control and
timely resolution of issues.
Developed technical specifications and process enhancements with Microsoft Visio, providing clear and
structured diagrams for project planning.
Utilized Agile/Scrum methodologies for project management, ensuring flexible, iterative progress
towards project goals and timely delivery of solutions.
TECHNICAL SKILLS
Programming and Scripting HTML, DHTML, CSS, Java Script, XML, R/R Studio, SAS Enterprise Guide,
SAS, Python (NumPy, SciPy, Pandas, Gensim, Keras), R (Caret, Weka,
Ggplot), MATLAB, Mathematica
No SQL Databases Cassandra, HBase, MongoDB, MariaDB
Business Analysis Tools BPMN, SWOT Analysis, Competitive Analysis
Data Analysis Tools SQL, R, Microsoft Excel, PostgreSQL, Jupyter Notebooks, Tableau, Power
BI, SAS
Data Visualization Power BI, QlikView, Looker, Tableau Server, Tableau Reader, Splunk, SAP
Business intelligence, QlikView, Amazon Redshift or Azure Data
Warehouse, Microsoft Excel, Python, D3.js, AWS QuickSight
Data Processing Apache Hadoop, Spark
Business Modeling Microsoft Visio, Lucid chart, UML, BPMN
Database Management SQL Server, MySQL Workbench, ANSI SQL, Snowflake, Azure Data
Warehousing, PostgreSQL, MySQL 4.x/5.x, Oracle 11g,12c, DB2,
Teradata, Netezza
ETL Processes Informatica, SQL Server Integration Services (SSIS)
Version Control GIT, Bitbucket, AWS Code Comit, Gitlab, GitHub, Docker
Collaboration Tools SharePoint, Slack, Microsoft Teams, Webex, Confluence
Statistical Modeling Python, R, Power BI, Tableau, MATLAB, SAS
Testing Manual testing (UAT, SIT)
Cloud Technologies and Azure Blob Storage, Azure Analytics, AWS Services, ServiceNow, HDFS,
Storage Solutions Snowflake
Documentation Tools and Microsoft PowerPoint, Microsoft Teams, Webex, Microsoft Excel,
Communication Confluence, MS Word, MS Visio, Outlook, Crystal Reports XI, SSRS,
Cognos 7.0/6.0
Security Management Azure Security Protocols
Software Testing JIRA, Junit, Selenium, QTest, Postman, Bitbucket
Development Methodologies Scrum, Agile, UML 2.5, Design Pattens, Waterfall
Operating Systems All versions of Windows, UNIX, LINUX, Macintosh HD, Sun Solaris
PROFESSIONAL EXPERIENCE
Kollabio, Ashburn, VA Oct 2023 till now
Senior Business/Data Analyst
Responsibilities:
Collaborated with supply chain management and business intelligence teams to understand and
define reporting requirements, ensuring alignment with operational goals.
Leveraged Apache Sqoop for efficient data transfers between Hadoop and relational databases,
facilitating seamless integration of diverse data sources.
Participated in all phases of analytics, from data collection and preprocessing to advanced statistical
analysis, using Python, R, and Jupyter notebooks, to support supply chain optimization efforts.
Implemented machine learning algorithms using Python and R to segment suppliers, predict
demand, and identify inefficiencies in the supply chain.
Developed and optimized MapReduce jobs in Java for data cleaning, preprocessing, and aggregation,
enhancing data quality and analysis efficiency.
Installed, configured, and managed Apache Flume setups for data ingestion, ensuring reliable and
timely data flow from various sources.
Served as an administrator for Pig, Hive, and HBase, managing updates, patches, and upgrades to
maintain a robust data infrastructure.
Performed a major upgrade of the Hadoop cluster from CDH3u6 to CDH4.4.0, improving
performance and capabilities of the data processing environment.
Used Apache Hive to create databases and tables, load data, and query data efficiently, supporting
detailed analysis and reporting requirements.
Developed complex HiveQL queries to extract insights and support decision-making processes
related to inventory management, demand forecasting, and logistics optimization.
Automated data workflows with Apache Oozie to enhance data availability and processing efficiency,
ensuring timely and accurate data for analysis.
Utilized Apache Kafka for real-time data streaming and processing, enabling real-time monitoring
and analytics of supply chain activities.
Environment: Apache Sqoop 1.4.7, Python 3.8, R 4.0.0, Jupyter notebooks 6.0, Apache Flume 1.9.0,
Pig 0.17.0, Hive 3.1.2, HBase 2.3, Apache Oozie 5.1.0, Apache Kafka 0.10, and Java MapReduce 3.0.
Broadridge, Lake Success, NY July 2021 Sep 2023
Senior Business/Data Analyst
Responsibilities:
Analyzed business requirements and translated them into detailed technical specifications using
SQL, Lucid Chart and BPMN.
Led the enhancement of financial models and developed new solutions, incorporating JIRA,
SharePoint and Microsoft Visio for process improvements.
Focused on testing and validation of business processes and solutions, utilizing Microsoft Excel,
PowerPoint and Power BI to ensure reporting accuracy.
Managed documentation and reporting tasks with precision, using Git, Teams and Confluence to
maintain data integrity and accessibility.
Enhanced team collaboration and project management by effectively implementing Agile/Scrum
practices, which improved productivity and met critical deadlines.
Coordinated and conducted requirement gathering sessions, effectively utilizing BPMN to map and
document business processes.
Developed and maintained technical specifications and project documentation using Lucid Chart and
Microsoft Visio, ensuring clarity and consistency.
Streamlined communication and project coordination using Microsoft Teams, enhancing team
interactions and project visibility.
Analyzed and tracked project progress in Vita, providing regular updates and insights to the project
management team.
Created detailed business process models in Vita, facilitating a clear understanding of workflows
and system interactions.
Conducted comprehensive business analysis and data validation to support strategic decision-
making, employing SQL for data extraction and analysis.
Led the development and implementation of business enhancements, using JIRA to track progress
and manage changes.
Automated data processing and report generation using Pivot tables, reducing manual effort and
increasing efficiency.
Analyzed financial and operational data using Pivot tables, identifying key performance indicators
and areas for improvement.
Collaborated with stakeholders to identify gaps and areas for improvement in existing D365
solutions.
Facilitated the creation and maintenance of project reports and dashboards using Power BI,
providing stakeholders with real-time business insights.
Ensured compliance with project standards and procedures, using SharePoint to organize and share
project documents securely.
Performed detailed business process analysis to identify improvement opportunities, applying
Microsoft Excel to analyze and present data findings.
Developed and revised project workflows to enhance efficiency, using Agile/Scrum methodologies
to adapt to changing project requirements.
Managed testing and validation phases to ensure the alignment of final products with business
requirements, utilizing Confluence for documentation.
Provided technical and process training to team members and stakeholders, using PowerPoint to
create engaging and informative presentations.
Optimized business processes by designing and implementing new solutions that addressed specific
business needs, using BPMN for process modeling.
Monitored and reported on project status and milestones, employing Git for version control and
historical tracking of project deliverables.
Organized and led project meetings and discussions, ensuring effective stakeholder engagement
and communication.
Analyzed and interpreted business data to provide insights into business performance and areas for
improvement, using SQL and Power BI.
Developed business cases for new technology implementations, outlining benefits, costs, and
strategic alignment.
Coordinated cross-functional teams to ensure seamless integration of new systems and processes,
fostering a collaborative project environment.
Documented and addressed project issues and risks, using JIRA to ensure timely resolution and
mitigation strategies.
Facilitated the adoption of new technologies and processes by conducting training sessions and
workshops, utilizing Teams and PowerPoint for delivery.
Maintained project documentation and ensured adherence to governance and compliance
standards, using Confluence to archive all project-related information.
Environment: SQL, Lucid Chart, BPMN, JIRA, SharePoint, Microsoft Visio, Microsoft Excel,
PowerPoint, Power BI, Git, Teams, Confluence.
Alaska Airlines, Seattle, WA Aug 2019 Jun 2021
Business/Data Analyst
Responsibilities:
Integrated with airline's operational systems (flight schedules, weather data, airport operations) to
gather real-time flight status information for service quality, operational efficiency, business
performance.
Implemented APIs and data feeds to ensure up-to-date information availability for customer
satisfaction, operational efficiency, cost savings, regulatory compliance, and stronger competitive
position in market.
Developed a robust notification engine to send proactive alerts to customers regarding flight delays,
cancellations, gate changes, and boarding updates for operational efficiency, regulatory compliance.
Supported multiple communication channels (like SMS, email, mobile app push notifications) based on
customer preferences for satisfaction, competitive advantage.
Designed intuitive user interfaces for both airline staff (operational dashboard) and customers (mobile
app, web portal)
Ensured ease of access to relevant flight information and self-service options for customers to enhance
satisfaction, operational efficiency, and overall business performance.
Implemented analytics capabilities to track key performance indicators (KPIs) such as on-time
performance, customer satisfaction, notification effectiveness for improvement, long-term
sustainability.
Generated reports and dashboards for stakeholders to analyse trends and made data-driven decisions
for transparency, accountability, more effective operations and improved competitive positioning.
Ensured compliance with aviation regulations (Like FAA guidelines) and data protection laws (Like
GDPR, CCPA) for maintaining legal standing, protecting passenger and employee safety, building
customer trust, managing risks, and enhancing overall operational efficiency.
Implemented robust security measures to protect customer data and system integrity for manage risks,
safeguard data, and maintain a secure environment for passengers, employees, and stakeholders alike.
Environment: APIs, RabbitMQ, RESTful services, Twilio (SMS), React.js, Power BI, R, Azure, DynamoDB,
Azure Event Grid, SSL, Azure Security Center, CCPA, Scrum, Confluence, IAM tools.
Chesapeake Energy, Oklahoma City, OK Jan 2017 July 2019
Business Analyst
Responsibilities:
Conducted workshops with stakeholders to gather requirements for the monitoring system in the
business.
Analysed current monitoring processes and identified gaps and areas for improvement, efficiency,
reduce costs, ensure compliance, improve accuracy, and drive overall business performance and growth.
Documented detailed functional and non-functional requirements for clarity, guiding design and
development, managing changes, quality, and facilitating effective project management,
communication.
Collaborated with IT and engineering teams to design the architecture of the monitoring system for
technical feasibility, align the system with business objectives, optimize resources, mitigate risks,
incorporate best practices, and enhance communication and stakeholder support.
Developed use cases and user stories for the development team for user needs and expectations while
facilitating effective collaboration and communication.
Assisted in selecting the appropriate technologies and tools to the system for robust, efficient, secure,
and aligned with their long-term strategic objectives.
Worked with data engineers to integrate data from various sources (sensors, IoT devices, SCADA
systems) into the monitoring platform.
Ensured data quality, integrity, and consistency for operational excellence, strategic success, and long-
term sustainability in business.
Developed data models and schemas to support analytics for decision-making, operational efficiency,
and competitive advantage.
Design and develop dashboards and reports to visualize production data and Implement algorithms and
analytics models to detect anomalies and predict potential issues.
Ensure the system provides actionable insights to stakeholders and develop comprehensive test plans
and test cases for the monitoring system.
Coordinate and conduct system testing and user acceptance testing (UAT) and Identify and resolve
defects and issues during testing phases.
Create training materials and conduct training sessions for end-users and Provide ongoing support and
troubleshooting assistance post-implementation.
Gather user feedback to continuously improve the system and ensure the system complies with industry
regulations and standards.
Identify potential risks related to data security and operational disruptions and Develop and implement
strategies to mitigate identified risks.
Environment: Apache Kafka, AWS IoT, SQL, Tableau, AWS, Python, Agile, Jira, Confluence, Git, ISO
standards.
Infonaya Software, India Mar 2014 Sep 2016
Business Analyst
Responsibilities:
Analysed data trends and provided insights that influenced key business decisions using SQL,
Python, and Tableau.
Developed statistical analyses and predictive models to forecast business trends and performance,
utilizing SAS, MATLAB, and Excel.
Crafted detailed business recommendations based on thorough analysis of data patterns and
statistical outputs.
Produced high-quality documentation and led requirement gathering meetings to ensure
alignment of business goals with technical solutions.
Facilitated collaborative teamwork settings, ensuring effective communication and project
alignment through requirement meetings.
Led the development of business dashboards, using Tableau and Python to visualize data trends
and drive business decisions.
Performed root cause analysis on business performance issues using SQL and SAS, providing
effective solutions and strategies.
Conducted predictive modelling projects to anticipate market trends, utilizing Python and MATLAB
for accurate forecasts.
Developed and maintained project documentation using collaborative tools and practices,
ensuring all team members had access to necessary information.
Engaged in statistical analysis to support business case developments, using Excel and SAS to
manipulate and interpret data.
Organized and facilitated cross-functional meetings to gather requirements and discuss business
needs, enhancing project outcomes.
Implemented new business processes based on data insights, using Python and MATLAB to support
decision-making.
Streamlined data collection and analysis processes using SQL and Python, increasing efficiency and
accuracy.
Created interactive reports for stakeholder presentations, using Tableau and D3.js to effectively
communicate findings.
Monitored and reported on the progress of business analysis projects, ensuring deadlines were
met and objectives achieved.
Conducted training sessions on new technologies and analytical techniques, empowering team
members with the skills needed for ongoing projects.
Managed stakeholder expectations and communications, using comprehensive data analyses and
presentations to support business objectives.
Evaluated the effectiveness of newly implemented business strategies, using statistical tools to
measure performance and suggest improvements.
Environment: SQL, Python, Tableau, SAS, MATLAB, Excel, D3.js.
EDUCATION DETAILS
Bachelor of Technology Aug 2010 May 2014
Computer Science and Engineering
JNTUH, Hyderabad, India
|
