Asst. Manager - Accenture Pvt Ltd - Gurgaon, India
(2023-11)
Working at Client Location: NatWest Group, Gurgaon. Participated in a long-term project on Business Analytics solutions & OAC Solution for various clients, involved in development as well as support of the customer reports for appropriate business solutions, connecting with client for requirement & solution.
- Participate in the OBIA activity what ever is required in the project.
- Engaged in multiple tasks, including various developments (Dash boards, Reports, etc.), Code Migration, created Presentation Variables, cache management (to purge the cache) and ensured UAT readiness.
- In the initial project designed/developed custom reports for Banking Customer, collecting data from Flat Files, as source, to structure the Data Warehouse, enabling the Client to gain both Managerial and Operational Excellence by using Reports.
- Developed a custom Dashboard with prompts for client review & decision making as well as developed Metrics & Measures, using different aggregation rules, in the BMM layer.
- Handling BI Publisher Dashboard Reports with the international Clients.
Lead Software Engineer - Virtusa Consulting Services Pvt. Ltd. - Gurgaon, India
(2021-05 - 2023-11)
Working at Client Location: NatWest Group, Gurgaon. Participated in a long term projects on Business Analytics solutions for various clients, Involved in development as well as support of the customer reports for appropriate business solutions, connecting with client for requirement & solution.
- Developed a custom Dashboard with prompts for client review & decision making as well as developed Metrics & Measures, using different aggregation rules, in the BMM layer.
- Engaged in multiple tasks, including various developments (Dash boards, Reports, etc.), Code Migration, created Presentation Variables, Cache management (to purge the cache) and ensured UAT readiness.
- In the initial project designed/developed custom reports for Banking Customer, collecting data from Flat Files, as source, to structure the Data Warehouse, enabling the Client to gain both Managerial and Operational Excellence by using Reports.
Sr. Software Engineer - AWC Software Pvt. Ltd. - Noida, India
(2014-10 - 2021-05)
Working at Client Location: Sapient Consulting Gurgaon. Participated in a couple of long-term projects on Business Analytics solutions for various clients, including migration of reporting as well as development of the custom reports for appropriate business decision making.
- In the last project migrated PL/SQL & HTML reporting into OBI Reporting system, involving 300 reports (HR Reports, Financial Reports, Internal System data Reports, etc.), by creating Repository with new metadata.
- Developed a custom Dashboard with prompts for client review & decision making as well as developed Metrics & Measures, using different aggregation rules, in the BMM layer.
- Engaged in multiple tasks, including various developments (Dash boards, Reports, etc.), Code Migration, created Presentation Variables, cache management (to purge the cache) and ensured UAT readiness.
- In the initial project designed/developed custom reports for HR & Finance department, collecting data from Flat Files, as source, to structure the Data Warehouse, enabling the Client to gain both Managerial and Operational Excellence by using Reports.
- Performed Repository level changes, introducing the new metadata for the development, while created custom Dashboards, with prompts, for review by the client management.
- Implementing Security (Object Level as well as Data Level), for establishing users, groups, access privileges, etc., at the same time developed Dashboard & Report level prompts.
- Created Dashboards for the reports also using Guided Navigation & Links as well as implemented Time Series Function to Show MTD, QTD and YTD values.
Sr. Software Engineer - Eastern Software Systems Pvt. Ltd. - Noida, India
(2011-12 - 2014-10)
Participated as solution developer in multiple (3) projects, for various national clients, for development of business solutions, based on SQL & PL/SQL as well as for development of Reports.
- Developed Database Functions, PL/SQL Procedures as well as in coding, using PL/SQL, on a Norms Monitoring System, for a national automotive client, with Oracle as back-end and Windows platform.
- The application took care of all those things that are needed for developing the projects, storing all the information, for vehicles, spares, dealer/retailer, starting date & expiry date, etc.
- In another project developed Customer Care Administration solution, with table design/database scripts, creating backend procedures/stored procedures (for retrieving/updating data) and functions/triggers for Oracle, while prepared Test Cases against the Basic functionality.
- The solution was used for managing all the accommodation of mobile & sim card that was provided by the client, to their employees, based on their designations.
- In the initial project, developed an application for a world leading Airway (delivering innovation in transportation & entertainment), to gain both Managerial and Operational Excellence, by using OBIEE & OBIA solution, for Services.
- Created Interactive Dashboards with drill-down capabilities, using of Dashboards prompts & Presentation variables as well as Logical Joins/Keys Initialization Blocks, Repository variables, Set levels to support Drill-down etc.
