SUMMARY **********@*****.***
Analytical and Eloquent Data Analyst with 5+ years competent in Data Modelling, Data Mining, Data Cleaning /Pre-processing, Scalable Data pipeline, applied empirical data analytics, statistical modelling, complex quantitative analysis for established retail company. Boosted our client Sales by 4% by structuring data, providing key data insights and attain compliance by enhancing data accuracy.
Centerton, AR
linkedin.com/in/shamili-kv
EXPERIENCE
SKILLS
Senior Data Analyst
HCL For Astrazeneca Bio-Pharmaceutical company / Aug 2015 – Jan 2018
• Architect and built efficient & reliable new data models and schemas to enable analysis and provide insights on Daily Sales using Python & Shell Scripting.
• Analyzed Data using Advanced SQL and running A/B testing experiments to create a deeper understanding of our users and their purchases.
• Built Analytical dashboards using data visualization tool like Tableau & Python – Seaborn & Matplotlib libraries that provide insight around Business key metrics it helped in fixing the anomalies and enhanced accuracy by another 3%.
• Developed high-performance algorithms for precision targeting, testing and implemented those algorithms in scalable, product-ready code that conform to design requirements and thereby helping sale capitalized by 4%.
• Created Analytical Reports on Sales data using Python and automated the data pipelines for those reports using Airflow DAGs.
Scripting Language:
Python, Shell Scripting
Frameworks:
NumPy, Pandas, SQL
Data Warehousing tools:
GCP BigQuery, Hadoop
Workflow & Orchestration Tools:
Airflow
Data Visualization & Analytic Tools:
Tableau
Analyst, Data Engineer
HCL For Micron Technology – Semiconductor manufacturing company / Sep 2013 – July 2015
• Designed & Developed Multiple ETL Data Pipeline from Informix to Bigdata using Python and Shell Scripting.
• Gathered and reconciled unstructured forms of data from different sources, identified gaps in the data and fixed to provide a clean and meaningful data for business reports from Hadoop, also it boosted accuracy and reliability of Data from 90.68% to 97.23%.
• Proposed a ETL data pipeline for our retail customer on their Claims reconciliation process using Python that accomplished in efficiently building, scaling, and maintaining our ETL pipelines with reduced efforts in infrastructure deployments and maintenance, that saved unapplied cash about 1.8 million daily on reconciliation process with ledger data due to manual errors.
• Conducted empirical data analysis from complex, disparate data sources to recognize and correcting those patterns using Python that strengthened ETL process performance by 36%.
EDUCATION
Bachelor of Engineering / Electronics &
Instrumentation
Anna University, India
2009 - 2013
Google Data Analytics Professional
Certification
DOMAIN
Health and Wellness
Compensation
HRMS
PeopleSystems
Lead Data Analyst
Business Gateway International – CAHOOT/ Feb 2018 – Nov 2019
• Lead team of 5 members in creating a Scalable data pipeline using Python and scheduled the workflows through Airflow DAGs.
• Partnered with Data Scientists and Cross functional teams to discover, collect, cleanse and refined the data needed for analysis and modelling. SHAMILI KASI VISWANATH
Data Analyst