Database & MIS Management
• Managed and maintained Oracle HRMS databases, project MIS platforms, and HR reporting
systems for a large public-sector workforce.
• Developed and maintained complex Oracle SQL/PL-SQL queries for employee data extraction,
assignment tracking, tenure calculations, and pay scale analysis.
• Conducted routine data quality checks, verification, and cleaning to ensure accuracy,
completeness, consistency, and timeliness of HR and payroll data.
• Supported automation and digitization of HR data management processes, reducing manual
reporting time.
Data Analysis & Visualization
• Analyzed quantitative HR and payroll data to generate actionable insights for management
decision-making.
• Produced trend analyses, performance reports, and data summaries on employee
assignments, tenure, and grade/scale distribution.
• Built and maintained Excel-based dashboards and data visualization products for HR reporting.
• Identified data gaps, anomalies, and patterns (e.g., dual assignments, prolonged postings) to
support organizational decision-making.
• Conducted ad hoc analyses and custom queries to meet management and departmental
reporting requirements.
Reporting & Information Management
• Prepared periodic (monthly, quarterly, annual) HR and management reports for senior
leadership.
• Maintained indicator tracking tools and performance monitoring systems for employee records
and assignments.
• Supported management teams in interpreting and utilizing HR data for planning and policy
decisions.
• Presented findings through structured reports and data summaries; ensured proper
documentation and archiving of datasets.
Systems Support & Capacity Building
• Supported implementation and maintenance of Oracle-based HR/MIS systems, coordinating
with IT teams on enhancements and reporting needs.
• Developed reusable, automated SQL reporting templates for recurring HR reporting
requirements.
• Supported database management and data integration activities across HR modules.
• Provided technical guidance and informal training to colleagues on data entry standards,
reporting tools, and Oracle-based queries.
• Documented lessons learned and best practices for recurring data management tasks.
- Company industry:
- Electric Power Production & Transmission
