Chandra N Email & Phone Number

Involved in complete Agile Requirement Analysis, Development, System, and Integration Testing.• Designing and implementing data dashboards using Tableau and Power BI, enhancing the ability of executives to make data-driven decisions.• Create and maintain data dashboards and reports using Excel and SQL.• Conducting deep-dive analyses into customer behavior and transaction data, uncovering trends that informed marketing strategies and product development.• Automated reporting processes, reducing time spent on routine data tasks by 30%.• Assisted in the collection, processing, and analysis of large datasets to support banking operations.• Performed quality assurance checks to ensure data integrity and accuracy.• Supporting senior analysts in ad-hoc analysis and project work.• Wrote several complex SQL queries to extensively test the ETL process. Performing data analysis and maintenance on information stored in MySQL database.• Working on developing Python script for the whole data science project life cycle including data acquisition, data cleaning, data exploration, and data modeling.• Collaborate with stakeholders to gather requirements and define project objectives.• Working with NumPy, Pandas, Matplotlib, Seaborn, ggplot, Scikit-Learn libraries for developing various algorithms.• Designing and deploying dashboards with Tableau and providing complex reports to the team and stakeholders.• Successfully extracting data from multiple sources including flat files, MS Excel, and MS Access, employing data transformation techniques to ensure data accuracy and consistency, facilitating efficient data processing and analysis.

Involved in complete Agile Requirement Analysis, Development, System, and Integration Testing.• Perform data analysis and reporting tasks, utilizing SQL, Python, and Excel for data manipulation and analysis.• Migrating data to/from staging table in SQL from multiple data sources including Excel, CSV flat files, and other SQL servers.• Designed and developed data pipelines and ETL processes to extract, transform, and load data into cloud - based data warehousing solutions such as Amazon Redshift and Google Big Query.• Wrote calculated columns, Measures query's using DAX in Power BI to show good data analysis techniques.• Collaborate with stakeholders to gather requirements and define project objectives. Participate in meetings and discussions to understand business problems and provide data-driven insights.• Worked on database design and query optimization, as well as providing several periodic and custom reports, resulting in a 30% decrease in query execution time and improving database efficiency.• Conduct ad-hoc data analysis requests and provide timely deliverables. Prioritize and manage multiple analytical tasks to meet project deadlines.• Involved in the entire data science project life cycle and actively involved in all the phases including data extraction, data cleaning, statistical modeling, and data visualization with large data sets of structured and unstructured data, created ER diagrams and schema.• Integrated diverse data sources into a centralized Snowflake data warehouse, ensuring efficient and scalable storage of structured and semi-structured data (JSON, Avro, Parquet).• Designed and implemented structured data models to support RAG, enhancing data retrieval capabilities for complex queries related to patient care and hospital management.• Contribute to the development of data-driven strategies by providing insights and recommendations. Collaborate with team members to identify opportunities for leveraging data to drive business growth.

India

Used the Waterfall methodology to build the different phases of the Software Development Life Cycle.• Analyzed and transformed data using various SQL functionalities using MySQL server to generate data extracts and reports.• Conducted data analysis experiments, A/B testing, and statistical modeling to optimize business processes, improve customer experience, and increase operational efficiency.• Stayed up to date with the latest cloud technologies, data analytics tools, and industry trends, and recommended innovative solutions to enhance data analytics capabilities.• Worked on architecting, designing, and implementation of large-scale data and analytics solutions on Snowflake Cloud Data Warehouse.• Participated in collaborative team designing and developing a Snowflake data warehouse.• Developed data wrangling through data gathering and querying process over SQL and implemented data cleaning process with R and Python.• Developed sales reports using the on-premises data on Microsoft Excel and Power BI.• Utilized Power BI to create various analytical dashboards that help business users to get a quick insight into the data.• Provided support to end users for production issues and built custom SQL scripts for business needs.• Worked on data cleaning and reshaping, generated segmented subsets using NumPy, Pandas, matplotlib, and SciPy in Python,resulting in a 25% reduction in data errors.• Continuously improve data analysis processes and methodologies. Stay abreast of emerging technologies and industry best practices to enhance efficiency and effectiveness.• Led the development of test cases and test scenarios to ensure that changes were thoroughly tested and reviewed before deployment, resulting in a 90% reduction in post-deployment issues.