Experience

My Group Australia

• Australia
• Business Consulting and Services
• 1 - 100 Employee

• Data Analyst - My group, Australia

  • Jan 2021 - Present

  • I have worked on the mini-project using SSIS package imported data from the different sources like flat files, excel and integrating with the CRM database. Imported the data related to sales, salesperson, location, budgeting from 2017, 2018, 2019 years. • Using different transformations to Data Conversion, Derived column, Fuzzy lookup, etc to transform and validate the data before the data is imported to the database. • Used the different method of transformation in SSIS created the stage tables and Data Warehouse. •Strong business Analysis experience • Designing for-each loop to import and using variables to export multiple files in different formats. • Designing Stage Database and Data Warehouse, creating DIM and Fact tables. • Creating ETL and Data profiling. •Data modelling and Data Analysis •Big Data platform skills • Loading the data from destination server using the SQL, bulk insert, look up transformation for update and increment load. Data Analysis, Database management, Data visualization, reporting. • Developed the tabular reports and ad-hoc using the SSRS Report designer. • Parameterized reports, Linked reports, Snapshots, Drilldown, and Drill through reports using different versions of SQL. • Handling the sub reports. •Documenting problem spaces with multiple solution options. • Worked on Power BI loading the data from Excel or Database appending, merging, visualization and DAX. • Designing the OLTP Database, Tables, Store Procedures, Triggers, using recursive CTEs, CTE, temp tables. • Designing the Data warehouse from scratch, creating DIM and Fact tables. Creating Star or Snowflake schema based on client requirements.



Service NSW

• Australia
• Government Administration
• 700 & Above Employee

• Customer Support Officer

  • Dec 2021 - May 2022



St.George Advance Coaching Centre

• Primary Education Tutor

  • Feb 2019 - Dec 2020

   Private Tutoring of students outside school settings and training preparations for examinations.  Researching learning methods  Preparing learning resources  Assessing student needs  Identifying weak areas  Monitoring student performance  Private Tutoring of students outside school settings and training preparations for examinations.  Researching learning methods  Preparing learning resources  Assessing student needs  Identifying weak areas  Monitoring student performance



The Smith Family

• Non-profit Organizations
• 700 & Above Employee

• Program Coordinator

  • Jan 2018 - Feb 2019

   Microsoft CRM data entry  Printing and collating documents for mailing or filing  Scanning documents into soft copies and uploading on OneDrive  Bulk emailing tertiary students and families  Assisting in event or program organization, for example graduation ceremonies, student inductions, Sydney University Camp and Open Day, UTS Summer School Camp  Enhancing relationship between students and The Smith Family by calling students as per scheduled student touch points  Following up on tertiary students’ outstanding documents by phone, texting and email. These documents include; student results, confirmation of enrolments and updating bank details in CONNECT  Pulling out data from CRM database and sort out into Excel spreadsheets as requested  Setting up appointments for Tertiary Coordinators  Managing document archiving and destruction  Receiving and sorting out Learning Club materials according to grades  Updating Learning Club resources and The Smith Family Library  Staff training and development.



Plumpton Public School

• Australia
• Higher Education
• 1 - 100 Employee

• Learning Club Tutoring

  • Jun 2018 - Dec 2018

   Aid in literacy and numeracy to students  Assisting students in developing skills and knowledge subject areas through school based tasks.  Assisting in setting up Learning Club each week  Assisting with goal setting in collaboration with student and LC coordinator and The Smith Family staff and record progress of student development  Assisting students with resources provided to increase literacy & numeracy  Aid in literacy and numeracy to students  Assisting students in developing skills and knowledge subject areas through school based tasks.  Assisting in setting up Learning Club each week  Assisting with goal setting in collaboration with student and LC coordinator and The Smith Family staff and record progress of student development  Assisting students with resources provided to increase literacy & numeracy



WPT College

• Programming Language instructor/Freelancer

  • Jan 2015 - Feb 2018