Summary
Overview
Work History
Education
Skills
Certification
Interests
Awards
Timeline
Generic
Niranjan Dubey

Niranjan Dubey

Solution manager (People Analytics)
Greater Noida

Summary

Dynamic Solution Manager with extensive expertise in People Analytics, integrating deep functional and technical knowledge of HR business processes. Proven ability to gather and analyze business requirements, translating them into clear development specifications while effectively managing product roadmaps for end-to-end project delivery. Skilled in leading development teams through sprint planning and daily standup Meeting , ensuring timely and defect-free releases through rigorous system integration testing and UAT coordination. Strong communicator adept at conducting product demos, aligning stakeholders, and supporting SOX compliance and L3 incident resolution, driving operational improvements and fostering collaborative work cultures in fast-paced environments.

Overview

14
14
years of professional experience
2
2
Certifications
2
2
Languages

Work History

Solution Domain Manager(People Analytics)

ST Microelectronics Pvt. Ltd.
01.2015 - Current
  • Currently managing Stromboli – HR Analytics Project as Solution Domain Manager, which is company’s key Digital transformation initiative piloting new technologies (POWER BI/Microsoft Azure (Cloud based backbone)) for BI HRDWH modernization and agile way of working with direct collaboration with WW Business End Users to generate data-driven decision-making solutions in the company
  • Indepth understanding of the principles and processes of HR analytics and workforce planning
  • Experience in utilizing a wide range of People analytics tools and software, such as Power BI,SAP Business Objects, & MS Excel, Microsoft Azure Db, Analysis Services,Talend, Oracle Sql , PL SQL
  • Managed and motivated employees to be productive and engaged in work.
  • Accomplished multiple tasks within established timeframes.
  • Maximized performance by monitoring daily activities and mentoring team members.
  • Enhanced customer satisfaction by resolving disputes promptly, maintaining open lines of communication, and ensuring high-quality service delivery.
  • Highly skilled in researching, analyzing, and interpreting data to provide actionable insights
  • Defining Product Roadmap & Full release planning and Tracking, effort estimation of tasks, regular follow ups with development team
  • Documentation, Glossary, Data Catalog and preparation of Training material
  • Obtaining Business and CFC approvals, preparation of HP/ALM Reports, security reviews for SOX Compliance
  • Adept at creating reports and dashboards to visualize data and monitor progress
  • Conducting Sprint planning meetings with Development Team, Application Manager, Architects
  • Supporting Business users for ad hoc reporting and analysis or Self BI needs
  • Communication to key stakeholders about project Status, Product roadmap & ongoing activities/deliveries
  • Developed innovative dashboards and reporting solutions to enable HR teams to visualize data and evaluate trends
  • Conducting Daily Standup meetings with Development Team
  • Business Requirements Gathering & Analysis, directly working with key users/requestors to capture business requirements
  • Managing multiple task in parallel ensuring consistent, on- time and high quality deliveries of my work
  • Good Functional knowledge & technical skills, creativity, and agility to answer complex and rapidly changing work scenarios & analytical needs with challenging and strict timelines
  • Excellent communication and interpersonal skills to build relationships with taught across the institution
  • Knowledge of various subjects and multidisciplinary approach

Senior Data Engineer

CenturyLink Technologies India Pvt. Ltd
11.2012 - 01.2015
  • Analyzed the business requirements and functional specifications.
  • Used Informatica Power Center 9.1 for extraction, transformation and load (ETL) of data in the data warehouse.
  • Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
  • Developed complex mappings in Informatica to load the data from various sources.
  • Ensured data quality through rigorous testing, validation, and monitoring of all data assets, minimizing inaccuracies and inconsistencies.
  • Reengineered existing ETL workflows to improve performance by identifying bottlenecks and optimizing code accordingly.
  • Championed the adoption of agile methodologies within the team, resulting in faster delivery times and increased collaboration among team members.
  • Collaborated with cross-functional teams to define requirements and develop end-to-end solutions for complex data engineering projects.
  • Optimized data pipelines by implementing advanced ETL processes and streamlining data flow.
  • Mentored junior team members in best practices for software development, code optimization, and troubleshooting techniques.

DWH software engineer

Rsystems International.
10.2011 - 11.2012
  • Creation of SQL Scripts as per requirement
  • Developed ETL scripts and pipelines
  • ETL processes performance tuning
  • Data Modelling & data engineering
  • Creation of triggers,procedures,functions in pl/sql
  • Creation of Shell scripts as per requirement
  • New User Creation and Deactivation
  • Privilege and Role Management , Database Export and Import
  • Oracle 9i and 10g installation on Server and Client Side.
  • Troubleshooting Oracle NET Server Configuration files such as tnsnames.ora and sqlnet.ora
  • Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
  • Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
  • Creation of PL/SQL Packages, Procedure and Functions as a part of Enhancement of the application.
  • Created packages to Purge data from the database for the outages.
  • Tuning the SQL Queries.
  • Creation of shell Scripts in Unix.
  • Creation of Schedules/ jobs on Control-M application.
  • Prepared documentation to describe program development, logic, coding, testing, changes and corrections
  • Data modelling
  • Developed scalable and maintainable code, ensuring long-term stability of the software.
  • Integrated new technologies into existing systems, increasing capabilities and improving overall performance.

Education

Bachelor of Technology - Computer Science

Ajay Kumar Garg Engineering College
Ghaziabad, Uttar Pradesh
08.2010

Diploma - Computer Science

MG Polytechnic
Hathras, UP
06.2007

SSC - Mathemetics, Science, English

Krishna Devi Public School
Sahtawar, Uttar Pradesh
07.2004

Skills

Certification

oracle 9i OCA Certification. oracle niranjan-oracleDBAcertlink August 2011

Interests

Technology Book Blog Reading, Travelling, Listening Indian Classical music, Cricket

Awards

Award 2 centurylink November 2013

ABCD Awards in ST microelectronics Jul'2018

Timeline

Scrum Master- Scrum Alliance October 2023

09-2023

Solution Domain Manager(People Analytics)

ST Microelectronics Pvt. Ltd.
01.2015 - Current

Senior Data Engineer

CenturyLink Technologies India Pvt. Ltd
11.2012 - 01.2015

DWH software engineer

Rsystems International.
10.2011 - 11.2012
oracle 9i OCA Certification. oracle niranjan-oracleDBAcertlink August 2011
05-2011

Diploma - Computer Science

MG Polytechnic

Bachelor of Technology - Computer Science

Ajay Kumar Garg Engineering College

SSC - Mathemetics, Science, English

Krishna Devi Public School
Niranjan DubeySolution manager (People Analytics)