Anish Shakya
I'm a
About Me
I'm Anish Shakya and Business Intelligence Analyst
I am a hardworking, ambitious, and self-taught data analyst. With a strong analytical mindset and keen attention to detail, I excel in SQL, data visualization, SSIS, and Excel. My expertise includes data cleaning and creating insightful visualizations. I am known for my ability to collaborate seamlessly with cross-functional teams. Proactive and eager to learn, I thrive on tackling new challenges. Additionally, I have developed a foundational understanding of the fintech industry.
Birthday: 15 nov 2001
Age: 22
Website: shakyaanish.com.np
Degree: Computer Science
Phone: +977-9849245269
City: Patan,Nepal
Email: [email protected]
Freelance: Available
SSIS ETL
SQL
Power BI
Excel
Education
2019 - Present
Bachelor in Computer Application
I am currently in my final year of pursuing a Bachelor's in Computer Application (BCA) at Sagarmatha College of Science and Technology, which is affiliated with Tribhuvan University
2017 - 2019
+2 in Management(computer science)
I completed my +2 from DAV College with good grades. I obtained a GPA of 3.62 in my +2 NEB Board examination, where I studied Management with Computer Science as my major subject. During high school, I focused on building my foundation in the field of Information Technology.
2003 - 2017
S.E.E
I achieved outstanding grades in my Secondary Education Examination (SEE) at Bhassara Secondary School, with a GPA of 3.55 in the SEE NEB Board examination.
Experience
2023 Dec - Present
Fintech Solutions Pvt. Ltd.
Business Intelligence Analyst
Data Analyst Intern
- Proficient in Advanced SQL window functions for complex data analysis tasks.
- Utilized SSIS for ETL (Extract, Transform, Load) processes, ensuring efficient data integration.
- Built SSIS ETL Pipeline to load CSV data to SQL server.
- Developed interactive and insightful dashboards using Power BI.
- Redesigned existing dashboards to enhance visual appeal and user experience.
- Implemented effective data modeling techniques in Power BI.
- Used DAX Studio to monitor data model performance and query benchmarks.
- Researched open-source products such as Elastic Stack (ELK), Metabase, and Grafana for potential data analysis tools.
- Familiarity with AWS services including S3, Athena, Glue, and QuickSight.
- Utilized AWS S3 for loading files, gaining practical experience in cloud data storage and retrieval.
2024 Mar - Present
ISEND GLOBAL
Business Intelligence Analyst
- Delivered comprehensive monthly financial insights based on transaction data to guide strategic decision-making.
- Monitored and analyzed key performance indicators (KPIs) to identify and highlight top-performing remittance corridors.
- Conducted in-depth Partner Fund analysis to optimize financial performance and partner relationships.
- Collaborated cross-functionally with Finance, Marketing, IT, Treasury, and Operations teams to gather and align business requirements.
- Extracted, cleaned, and transformed data from diverse sources to ensure accuracy and reliability for processing.
- Leveraged SQL and Power BI to convert complex data sets into actionable insights, delivering clear and impactful presentations to stakeholders.
- Utilized SQL Server Integration Services (SSIS) for efficient ETL (Extract, Transform, Load) processes, ensuring seamless data migration
2024 Jun - Present
ISEND GLOBAL
Business Intelligence and Development Analyst
-
In addition to the responsibilities listed in BI, my current role expanded to include:
- Oversaw business intelligence and development activities across Australia, New Zealand, and the Pacific Island jurisdictions.
- Generated leads and guided the marketing team using BI skills
- Maintained a centralized database for the BI team, ensuring data consistency and accessibility for analysis and reporting.
Other Courses
2022 - Coursera
Google Data Analytics Professional Certification
Status : Completed
2022 - Coursera
Essential Excel Certification
Status : Completed
2023 - DataCamp
Data Analyst on SQL
Status : Completed
Services
Data Analysis
As a data analyst, my service involves collecting and analyzing large datasets to extract insights and drive business decisions. I work closely with business teams to understand their data needs and provide them with accurate and actionable insights.
Data Cleaning
As a data cleaning specialist, my service involves working with large and complex datasets to ensure data quality and accuracy. I use various data cleaning techniques to identify and correct errors, inconsistencies, and missing values in datasets.
Dashboard Building
As a dashboard builder, my service involves creating interactive and visually appealing dashboards that enable organizations to track and analyze key metrics in real-time. My technical skills include proficiency in dashboard-building tool such as Power BI.
Problem Solving
As a problem solver, my service involves identifying, analyzing, and solving problems that organizations face using data. I can work closely with business teams and provide them valuable insights from my analysis.
Excel
As a Excel User, My service invloves working with large and complex datasets to ensure data quality and accuracy. I use various data cleaning techniques to identify and correct errors, inconsistencies, and missing values in datasets.
database
As a SQL developer, my service involves designing and developing efficient databases and Working with data manipulation using SQL-based technologies.
Latest Blog
Data Analysis
Lorem ipsum dolor sit amet consectetur adipisicing elit. Optio maiores ipsa perspiciatis culpa! Beatae id soluta fuga deleniti veniam dolorem quae. Facere vel voluptatibus esse quas quos totam deserunt placeat.
Data visualization
Lorem ipsum dolor sit amet consectetur adipisicing elit. Optio maiores ipsa perspiciatis culpa! Beatae id soluta fuga deleniti veniam dolorem quae. Facere vel voluptatibus esse quas quos totam deserunt placeat.
Excel
Lorem ipsum dolor sit amet consectetur adipisicing elit. Optio maiores ipsa perspiciatis culpa! Beatae id soluta fuga deleniti veniam dolorem quae. Facere vel voluptatibus esse quas quos totam deserunt placeat.