Somasree Gandham

+1-331-***-****

ad4vcz@r.postjobfree.com

www.linkedin.com/in/somag1

SUMMARY

Experienced Data and Business Analyst looking for a position that requires an outside-the-box approach and the ability to identify problems and develop cost-effective solutions to keep projects on track.

EDUCATION

VALPARAISO UNIVERSITY, Valparaiso, IN May 2023

Master of Science in Information Technology

JYOSHMATHI ENGINEERING COLLEGE & TECHNOLOGY, INDIA March 2014

Bachelor of Electronics and communication Engineering

TECHNICAL SKILLS:

Programming languages: JIRA, Python, SQL, Power BI, and Tableau.

Assembly Languages: Microprocessor 8086 & Microcontroller 8051.

Networking: Subnetting and OSI Model, LAN/WAN, TCP/IP, BGP, OSPF

Operating System: Windows, Linux, Microsoft Excel, Lucid chart, Microsoft purview.

Elicitation Techniques: Data Analysis, Brainstorming sessions, Workshops and Business process Modelling.

Extensive experience in providing technical support and troubleshooting in a related field.

Exceptional communication and interpersonal skills, effectively conveying technical issues to diverse audiences.

Strong analytical and problem-solving abilities, proficient in resolving network issues.

In-depth knowledge and hands-on experience with SQL and MySQL authentication protocols.

Proficient in Python, utilizing client-side scripting and fundamental web development concepts for ServiceNow integrations and customizations.

Identified and mitigated audit risks by leveraging data analytics, achieving data automation, reconciliation, traceability, lineage, and transparency.

Strong ability to collaborate effectively with cross-functional teams, adapting to dynamic priorities in a fast-paced environment.

Employed Data Binning and K-means Clustering techniques to derive insights and enhance decision-making.

Expertise in collecting, cleansing, and analyzing data in large volumes and then translate to meaningful insights.

Manipulating and processing data using statistical techniques, data mining, and machine learning algorithms to extract meaningful insights and patterns.

Demonstrated working knowledge of core financial processes, related risks and controls, and underlying data structures, contributing to improved financial performance and risk management.

Data Visualization: Creating visualizations such as charts, graphs, and dashboards to present data in a clear and understandable format for stakeholders.

Trend Identification: Identifying trends, patterns, and correlations within data sets to help stakeholders make informed decisions.

Data Management: Developing and maintaining databases, data dictionaries, and data governance policies to ensure data quality, security, and compliance.

Requirements Gathering: Collaborating with stakeholders to elicit, analyze, and document business requirements for projects and initiatives.

Process Analysis: Analyzing existing business processes and workflows to identify areas for improvement and optimization.

Solution Design: Developing and proposing solutions, strategies, and systems to address business challenges and achieve organizational goals.

Business Case Development: Creating business cases and cost-benefit analyses to justify investments in new initiatives and projects.

Stakeholder Management: Facilitating communication and collaboration between business stakeholders, project teams, and IT departments to ensure alignment and successful project delivery.

PROFESSIONAL EXPERIENCE

TATA CONSULTANCY SERVICES (TCS), INDIA Sep 2018 – May 2022

Client: PEPSICO USA

Role: Data Analyst.

Collected, cleansed, and integrated healthcare data from various sources such as electronic health records (EHRs), medical claims, and patient surveys.

Manipulated and adjusted external data points to align with internal validation requirements.

Utilized statistical analysis, data mining, and predictive modeling to identify trends and patterns within healthcare data.

Analyzed clinical outcomes, patient demographics, and treatment protocols to derive actionable insights for clinical decision-making and quality improvement.

Developed performance metrics, KPIs, and dashboards to monitor healthcare outcomes and operational efficiency.

Generated reports and visualizations to communicate findings to healthcare stakeholders and support evidence-based decision-making.

Collaborated with healthcare professionals and stakeholders to design study protocols and disseminate research findings.

Implemented data governance frameworks and security protocols to protect patient privacy while facilitating data sharing for healthcare purposes using data techniques.

Accenture, INDIA Dec 2017 – July 2018

Client: FedEx Express

Role: Sr. Business Analyst

Contributed to the design and architecture of the vendor onboarding system, ensuring that it meets the functional and technical requirements identified during the analysis phase.

Worked with technical teams to define data models, workflows, integrations, and other system components.

Coordinated testing activities, including functional testing, integration testing, and user acceptance testing.

Utilized problem-solving skills to address complex business needs and recommend solutions that optimize the vendor onboarding process.

Utilized negotiation skills to manage vendor expectations, ensure alignment with contractual agreements, and drive continuous improvement in vendor performance.

Amazon, INDIA Sep 2016- Nov 2017

Role: Business Analyst

Segmented Amazon's customer base to personalize marketing strategies and improve customer engagement.

Utilized customer data (purchase history, browsing behavior, demographics, etc.) to segment customers into distinct groups.

Developed dashboards and reports to visualize sales metrics and trends using tools like Tableau or Power BI.

Managed project planning, escalations, data processing, email troubleshooting, and specialized testing of Alexa and Fire TV devices.

Contact this candidate