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 Pradesh08.2010
Diploma - Computer Science
MG Polytechnic
Hathras, UP06.2007
SSC - Mathemetics, Science, English
Krishna Devi Public School
Sahtawar, Uttar Pradesh07.2004
Skills
Power BI expertise
SAP Business Objects expertise
Oracle Database
SQL & PL SQL
Data Modelling
MS Excel
Team leadership
Decision-making
Workforce management
Project planning
Agile Methodologies
CODEX
Data analysis
Analytical thinking
Work Planning and Prioritization
Analytical 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