Rajesh Diwakar
Bangalore
Summary
Dynamic Principal Consultant with extensive experience at DXC Luxoft, specializing in data analytics and dashboard creation. Proven track record in enhancing reporting capabilities using IBM Cognos and Power BI, while effectively managing project timelines. Strong analytical skills combined with a results-driven approach to deliver high-quality solutions and support client needs.
Overview
16
16
years of professional experience
1
1
Certification
Work History
Principal Consultant
DXC Luxoft
07.2021 - Current
- As Principal Consultant and Data Engineer, working currently with the clients on the requirements/develop the reports as per the business requirements. Support for production deployments of various reports.
- Provide estimate for the each of the project and make sure all projects are completed within the timelines
- Develop new reports and dashboard as per business requirements using IBM Cognos Analytics tool.
- Develop the data model and dataset as per business needs and handle the deployment of the dashboard.
- Handle the complex report creation and update the schedules based on adhoc request.
- Upgrading the report from Cognos BI platform to Power BI platform for the better reporting experience and self service reporting.
- Develop the dashboard using Power BI Desktop and publish.
- Work on the cognos admin task to setup the cognos datasource connection.
- Setup the gateways in cognos connection for the cognos installation.
- Handle the complete the loan IQ migration to the latest version and update 300 plus reports to make them compatible with latest version.
- Develop the data model for the self service reporting so that user can create the reports for themselves without support of the developers.
- Create the dashboard for the better readability of the report and enhance he reporting experience.
- Address any production issues and help the support team in debugging the production issues and provide quick solution.
- Work on adhoc clients incidents and change requests.
- Support Loan IQ upgrade and enhance reports to support updated version.
- Follow Agile Methodology and deliver the stories assigned in the sprint.
- Work also on devops activites to make the application complaint with all the securities
Application Development Specialist
Accenture Services Pvt Ltd
02.2016 - 06.2021
- As Application Development Specialist, working on development of new reports as per the business requirements/ create the package for the reports. Enhancement of the existing reports. Support for the production deployment of various reports and manage the team to resolve any Adhoc issue.
- Develop reports using Cognos and tableau Analytics as per the business requirements
- Develop new reports using Tableau.
- Deploy the reports and packages to production environment.
- Handle the team and make sure all projects are delivered without any escalation and on time.
- Interact with clients directly on any new report requirements and gather the business information.
- Provide estimate for the each of the project and make sure all projects are completed within the timelines.
- Create the package using Cognos framework manager.
- Address any production issues and help the support team in debugging the production issues and provide quick solution.
- Create the active batch jobs to automate the process of loading data in tables.
- Create the status reports daily weekly and monthly.
- Accenture is a global management consulting, technology services and outsourcing company and is the largest consulting firm in the world. It is a Fortune Global 500 company with more than 300,000 people in 52 countries. Accenture's clients include 96 of the Fortune Global 100 and more than three quarters of the Fortune Global 500.
Application Development Senior Analyst
Accenture Services Pvt Ltd
08.2012 - 12.2016
- As a Application Development Senior Analyst, working on various development releases by creating new reports/ packages, enhancement of existing production report/ packages and also on resolving problem tickets logged as an Incident/ Service Call by business users. Working on operational support environment where in troubleshooting various issues reported by business users.
- Development of new reports in Cognos Analytics.
- Migration of reports from Cognos 8,4 to Cognos 10.1, Migrated around 100 reports from 8.4 to Cognos 10.
- Performing the administrative activities for the cognos environment and provide appropriate permissions to the users.
- Packaging the solution for the production deployment and provide end to end transition of the reports to the support team.
- Address any production issues and help the support team in debugging the production issues and provide quick solution.
- Training the team members on Cognos and also assisting the new joiner in the team to complete their task on time.
- Speak with the Business Analyst for the Requirement gathering and finalize the requirement for any report development.
- Working all the phases of the SDLC right from Analysis to UAT support.
- Creating Functional and Technical documents for the reports.
- Creating the new Model in Framework Manager and also updating the Fields in Framework Manager.
- Working on Cognos Insight and upgrading from Insight 1.0.1.1 to Insight 1.1.1.
- Knowledge Transfer to the Support team.
- Creating Unit test case, Peer review, Release Notes, Reporting Overview, Training Deck Documents.
Senior Programmer
Accenture Services Pvt Ltd
09.2010 - 08.2012
- As a Senior Programmer, working on various development releases by creating new reports/ packages, enhancement of existing production report/ packages and also on resolving problem tickets logged as an Incident/ Service Call by business users. Working on operational support environment where in troubleshooting various issues reported by business users.
- Worked on the development of Cognos reports/ packages under Health Management services and also for various products.
- Worked on enhancement of the Cognos reports/ packages for existing applications in production and also resolving the incident or problem tickets raised by business analysts.
- Interaction with the clients to understand and freeze the business requirements for any new work allocated.
- Involved in designing the estimations that calculates work hours for a particular incident or problem ticket to complete. It basically decides on the complexity of Cognos Reports, which is the number of objects involved in a given Reports.
- Created Analysis documents and Estimation plans based on the complexity of the Cognos reports.
- Unit test Plan and Unit test case documents are created for unit testing of Cognos reports and Review/ Design Checklist is maintained, if necessary.
- Worked on migration of Cognos reports from Cognos 7 to Cognos 8.2 environment and again from Cognos 8.2 to Cognos 8.4 environment.
- Ensured on time Delivery of deliverables to the intended clients on daily, weekly, monthly and quarterly basis.
- Proactively involved in the performance improvement of the existing Cognos reports in production by tuning from the reporting end.
- Created the Model in the Framework manager by relating all the imported tables.
- Created the Framework Manager Model in Cognos 8.4 taking into consideration all the cardinalities and published the package.
Programmer
Accenture Services Pvt Ltd
10.2009 - 09.2010
- As Associate Software Engineer, worked on developing various Cognos reports, Dashboards and also involved in the creation of Framework Manager Model packages.
- Created Dashboards in Cognos Report Studio for Provider Analytics.
- Created the Technical Design Document as per the requirement from the business.
- Created Dashboards in Cognos Report Studio and formed a Drill through mechanism to accomplish the desired flow logic.
- Worked on enhancement of the Cognos reports/ packages for existing applications in production and also resolving the incident or problem tickets raised by business analysts.
Programmer
Accenture Services Pvt Ltd
08.2009 - 09.2009
- Worked as a trainee in Accenture Services Pvt Ltd on Basics of SQL, PL/SQL, UNIX, Cognos and Datastage, Informatica, Business Objects.
Education
Bachelor of Engineering -
GM Institute of Technology Engineering College
Skills
- Data Analytics
- IBM Cognos Analytics
- Power BI
- Data Modelling
- Dashboard Creation
- Tableau
- Finastra Fusion Loan IQ Functional and Technical
- ETL Tools – Informatica and Data Manager
- Structured query Language( Advanced SQL)
- Loan IQ Reporting and Data model
- AWS cloud
- JIRA
- Service now
- Business analysis
- Cognos administration
- Cloud deployment
Certification
- IBM Cognos BI Author Certified
- Metadata Model Certified
- IBM Cognos Analytics Certified
- IBM Cognos Admin Certified
- Power BI Certified
- Finastra Certified Associate - Functional
- Finastra Certified Associate - Technical
- Amazon Certified Cloud Practitioner
- Oracle SQL Certified
Languages
- English
- Kannada
- Hindi
Personal Information
- Father's Name: Diwakar
- Date of Birth: 11/01/85
- Nationality: Indian
- Marital Status: Married
Timeline
Principal Consultant
DXC Luxoft
07.2021 - Current
Application Development Specialist
Accenture Services Pvt Ltd
02.2016 - 06.2021
Application Development Senior Analyst
Accenture Services Pvt Ltd
08.2012 - 12.2016
Senior Programmer
Accenture Services Pvt Ltd
09.2010 - 08.2012
Programmer
Accenture Services Pvt Ltd
10.2009 - 09.2010
Programmer
Accenture Services Pvt Ltd
08.2009 - 09.2009
Bachelor of Engineering -
GM Institute of Technology Engineering College