Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Extracurricular Activities
Timeline
Generic

Mohanapriya Rathinam

Merrylands,NSW

Summary

Experienced IT professional with a solid 3 year background in Data Warehousing, coding, and testing. Proficient in Informatica, SQL Server 2008, and SSIS, specializing in the seamless migration of data from Excel to structured databases through SSIS packages. Recent transition to a data analyst role with 1 year of dedicated experience, showcasing expertise in collecting, analyzing, and reporting data using tools such as SAP BI, Power BI and Microsoft Excel. Proven ability to deliver key statistics, identify trends, and provide actionable insights vital for supporting critical business decisions.

Overview

12
12
years of professional experience
1
1
Certification

Work History

Junior Data Analyst

Techieclues
10.2022 - Current
  • Proficient in creating interactive and visually compelling reports and dashboards using Power BI Desktop.
  • Utilized Power Query for data transformation and cleaning, enhancing data quality for reporting purposes.
  • Created calculated columns and measures using DAX for customized and dynamic data calculations. Use Filter, Slicer, Hierarchy, Drill through, and Custom Visualizations techniques.
  • Develop Power BI reports, KPI reports, and dashboards from multiple data sources using data blending and migrating existing reports on the BI platform.
  • Proficient in data cleaning and manipulation using SQL queries, ensuring data accuracy and integrity.
  • Created and maintained database structures, including tables, views, and indexes, to organize and streamline data storage.
  • Executed SQL queries to clean and preprocess raw data, resolving inconsistencies, and handling missing or erroneous information.
  • Utilized Excel for data cleaning tasks, including filtering, sorting, and applying formulas to ensure data completeness and accuracy.
  • Skilled in Microsoft Office suite, including Word, Excel, PowerPoint, and Outlook.
  • Used these tools proficiently to improve work processes, create documents, handle data, and enhance communication.

Programmer Analyst

Cognizant Technology Solutions
08.2011 - 12.2014
  • Led end-to-end ETL design, coding, and testing processes with a focus on business requirements alignment.
  • Developed and tested interfaces, ensuring validation of Informatica mappings against predefined ETL design standards.
  • Produced comprehensive documentation, including Unit Test Plan, Unit Testing Document, SIT Plan, System Integration Testing, and Bug Fix Document, meeting stringent deadlines.
  • Executed successful data migration from Excel to SQL Server using SSIS, demonstrating proficiency in crafting TSQL scripts, Stored Procedures, and functions for the Application Environment.
  • Managed DB backup/restore and security requests on demand, contributing to the overall system integrity.
  • Collaborated closely with the Onsite Coordinator for requirement clarification and implementation coordination.
  • Successfully resolved production and UAT issues, maintaining meticulous documentation of daily challenges and resolutions.
  • Spearheaded the consolidation and migration of DB objects to the production environment, optimizing overall database efficiency.
  • Developed foundational skills in retrieving reports from SAP BI, with a focus on basic navigation within the reporting modules.
  • Executed fundamental queries within SAP BI to retrieve specific data points, aligning with the diverse reporting needs of various business units.

Education

Bachelor of Engineering -

Bannari Amman Institute of Technology
India
05.2011

Skills

  • SQL
  • Informatica
  • MS Excel
  • Power BI
  • Problem-Solving
  • Analytical Skills
  • Data Cleaning
  • Data Visualization
  • Data Analysis
  • SQL and Databases
  • ResQue

Accomplishments

    Received Employee of the month from Cognizant

Certification

  • Certified for the completion of Microsoft Excel – Advanced excel formulas and functions from Udemy
  • Certified on Completion of Power BI Desktop course by Udemy.

Extracurricular Activities

Coordinated and hosted a company-wide hackathon, fostering innovation and collaboration among teams to develop creative solutions for specific challenges.

Timeline

Junior Data Analyst

Techieclues
10.2022 - Current

Programmer Analyst

Cognizant Technology Solutions
08.2011 - 12.2014

Bachelor of Engineering -

Bannari Amman Institute of Technology

Similar Profiles

CREATE PROFILE
Mohanapriya Rathinam