Manoj Kumar
Buffalo Grove,USA
Summary
Results-driven IT consultant with over 20 years of experience in managed services, consulting, and account management. Demonstrates extensive project management and system analysis capabilities in financial forecasting and business intelligence reporting. Proficient in IBM Planning Analytics/TM1, IBM Cognos Analytics, Oracle PL/SQL, and ServiceNow, consistently enhancing customer satisfaction through efficient problem resolution. Aiming to leverage strategic insight and technical expertise at Discover Financial Services for impactful project delivery.
Overview
21
21
years of professional experience
1
1
Certification
Work History
Lead Architect
Cognizant Technology Solutions US Corp
11.2023 - Current
- Actively participating in requirement gathering and functional/specifications with business stakeholders for requirement analysis which involves a review of existing system and operating methodologies so as to create a technical plan for data migration considering all aspects required for it
- Data Analysis and architect the technical requirement by converting business needs to technical implementation and documentation of technical requirement document considering end-to-end data migration from source system to target system
- Data migration Implementation using the Oracle 12.9 taking data from Source system to Target System, moving all data along with security and Audit data
- Ensure post data migration, Target system is operational as per regular business process with no impact on Business functionalities
- Perform data reconciliation for each table for which data is migrated to make sure data flow is intact and no data loss happened
- Planning and execution of end-to-end process from development till project rollouts/deployment into production that includes in-depth data analysis using Oracle SQL Queries, Database Objects like Procedures, Functions, Sequences etc and identifying the root cause in case of any issue and then implementing the permanent fix
- It also involves defining the test cases and successful execution of it along with documentation for debugging, unit testing, system testing and then User acceptance testing to be executed by business users
- Coordinate with Business users, SQA team for project documentations using KNEAT to make sure all required documentations are in place for Audit purpose
Manager - Projects
Cognizant Technology Solutions US Corp
10.2014 - Current
- Managed various projects using the SDLC process in scope during tenure, which includes: Text Translation Al Project, Operating System upgrade, Application Data Archival and Decommissioning, New application onboarding in system following SLC process and documentations
- Actively participating in initiating Security Assessment Review (SAR) and Dynamic Application Security testing (DAST) processes in ServiceNow for DSS GxP Software applications (On-Prem or On-Cloud) under Information Research Area in Abbie and gathering required information as per ask from SQA team to complete the security assessment for the requested application
- It includes informing all business stakeholders for security requirements, which involves a review of existing systems and operating methodologies to create a technical plan to complete the assessments considering all aspects required for it
- Per business needs, evaluate the Application security implementation currently in place and to reach out to the Business System Owner to showcase the security implemented and request them to perform a penetration test to find out any loophole in security in a Non-Production Environment
- This requires coordinating with the Application Support Team to provide a production replica of the application in a non-production setup i.e
- QA/DEV environment
- Then, perform a Security Analysis on security test results and document the test results to share with the Security team
- Lead to ensure that the technical specifications of security implementation meet business standards as well as GxP standards, coordination with various teams and stakeholders is necessary to verify that system security adheres to these standards
- Work with the SQA team to suggest fixes in the event of any vulnerabilities
- This information should also be communicated to the application support team to address any issues that require coordination with other teams to implement fixes through a Change Request, maintaining communication until the closure of the Change Request
- Plan and execute the end-to-end process from creating SAR/DAST SNOW requests to completing the assessment review and security testing
- This involves various meetings with business stakeholders, the SQA team, the application support team, the security team, and others
- Share the status of all ongoing SAR/DAST requests with upper management on a weekly basis
Technical Lead - Managed Services
Cognizant Technology Solutions US Corp
10.2014 - 11.2023
- Actively participating in requirement gathering and functional/specifications with business representative for requirement Analysis, which involves a review of existing systems and operating methodologies as well understanding of evolving business needs
- Project Management by putting together the timelines and sharing same with Business Stakeholder to oversee the project delivery to business by coordinating with developers, testers, business user for acceptance testing, and to make sure deliveries are rolled out following scheduled project plan by following the Waterfall/Agile Methodologies
- Define, Design, and architect the IBM Planning Analytics on Cloud/TM1 budgeting and planning applications like cube design, Turbo Integrator process creation, dynamic business logic using Rules definition, automation of process run via Chores and Autosys, and interface design using PAfE/PAW/PAX/TM1 perspective, Cafe and TM1 web
- It involves the development of IBM PA on cloud /TM1 objects like cubes, TI Process, Rules, workbooks, Websheets, PAX Templates and Dashboards
- Data Integration using Oracle queries and integrating all database queries to have an end-to-end data flow from source systems to target systems
- Also, to create business intelligence reporting solutions out of developed applications in Planning Analytics on cloud /TM1 through IBM Cognos Analytics BI/PAW workbooks and MS PowerBl reports/dashboards
- To work with business on data analysis by identifying the data needs from business stakeholders and providing data extract and assisting business on data analytics mostly for Month-end activities, Long Range/Plan/Benchmark/Last Best Estimates financial planning
- Ensure technical specifications meet the business and functional requirements
- This also includes coordination with Cognizant's team of developers and centers of excellence representatives to ensure best practices standards are followed
- Architect and implement end-to-end process from development till project rollouts/deployment into production that includes in-depth data analysis and identifying the root cause in case of any issue and then implementing the permanent fix
- It also involves defining the test cases and successful execution of it along with documentation for debugging, unit testing, system testing, and then User acceptance testing to be executed by business users
- Proactively anticipate, identify, track, and resolve issues and risks affecting the business operations and maintain system operational
- Various automation implementation using TM1Py (Python) language that includes Compression/Decompression of files to transfer over IBM cloud setup, data pull from PA on cloud cubes for the reporting purpose to outbound on-prem reporting applications
- Coordinate with various teams and stakeholders to ensure systems are operational with no issues
- On a day-to-day basis, to work on incident management and problem resolution by coordinating with teams and provide status report to business COE
System Analyst
Titan Technologies Inc.
03.2014 - 10.2014
- Interaction with business representatives for requirement analysis and define business and functional specifications
- Requirement Confirmation document designing for TM1 application development
- Actively involved in requirements gathering, Architecture designing and Technical Implementation, and Project planning
- Defining and designing TM1 Cube Architecture, Turbo Integrator process and Business logic implementation (using TM1 Architect, Perspective, Active Forms and TM1 Web) and testing to make sure all developed by team is as per standard
- As a TM1 consultant, to develop technical objects as well such as TI process, Rules, Web-sheets in TM1 as per project plan
- Implementation of security at object level as well at data level with integration with Organization level security protocol followed
- Developing and delivering BI Reports out of TM1 application to provide BI analytics and Reporting capabilities to customers
- Designing and Execution of Test cases for TM1 application testing along with documentations
- Provide fix to the problems, requests / bugs raised by Customer
- TM1 server administration and upgrade to latest versions
IT - Architect
Tata Consultancy Services Limited
02.2008 - 03.2014
- Interaction with business representatives for requirement analysis and define business and functional specifications
- Requirement Confirmation documentation for TM1 application development
- Actively Involved in requirements gathering, Architecture designing and Technical Implementation, Project planning, Onshore-offshore coordination
- Defining and designing TM1 Cube Architecture, Turbo Integrator process and Business logic implementation (using TM1 Architect, Perspective, Active Forms and TM1 Web) and testing to make sure all developed by team is as per standard
- As a lead developer, to develop technical objects as well such as TI process, Rules, Web-sheets in TM1 as per project plan
- Developing and delivering Business Intelligence Reports out of TM1 application to provide IBM Cognos BI Analytics and Reporting capabilities to customers
- Coordinating within the team for the clarification on Business requirement and with any technical aspects
- Collecting enhancements planned on ongoing basis by interaction with end users
- Designing and Execution of Test case documents for TM1 application testing
- Handling of critical issues/changes and providing production support to end users
- Handling of Change order tickets
- CR Estimation and Impact Analysis
- Handling critical issues/changes and providing production support to end users
- Provide fix to the problem requests / bugs raised by Customer
- Weekly status report updates for all the project issues handled by the team members and share the same with customer
- TM1 server administration and upgrade to latest versions
Sr. System Engineer
IBM India Pvt Ltd
10.2007 - 02.2008
- Preparation of Manuals for Maintenance Reference
- Preparation of Test Cases and performing Unit/System Testing
- Code review and testing of IBM TM1 developed Objects i.e TI Process, Rules
- Analysis of Design of Cubes, dimensions etc
- Security Implementation of Canned/Ad-hoc Cognos BI Reports developed in Cognos BI Suite
System Engineer
AON Hewitt (FORMERLY HEWITT INDIA PVT LTD.)
04.2006 - 10.2007
- Analysis of BRD and TRD of Business intelligence report assigned for development
- To create Unit Test cases (UTC) of reports based on requirement documents i.e
- BRD, TRD and DD
- Development of models/reports using Cognos BI Suite based on BRD, TRD and DD, using data pull from DWH built based on DWH concept (Star/Star-snow flake schema)
- Updating of Unit Test Cases based on Review comments
- Creating Unit Test Script (UTS)
- Complete Unit testing of report before releasing to QA
- Unit Test Plan update after Unit Testing
- Production support
BI Consultant
Enigma Consulting
02.2004 - 04.2006
Education
Master - Computer Application (Computer Science)
Gurukula Kangri University
06.2004
Bachelor - Science (H) Mathematics
Delhi University
06.2001
Skills
- IBM Planning Analytics/TM1
- IBM Cognos Analytics/Business Intelligence Suite
- Oracle PL/SQL 10g/11g/12
- Informatica
- Data Stage
- TOAD
- PL/SQL Developer
- Quest Central
- AQT
- TM1Py
- Python Programming
- ServiceNow for Managed Services
Certification
- Coursera Certified Generative AI with Large Language Models Using Python and AWS, Coursera
- Coursera Certified Data Analysis using PySpark, Coursera
- Softcrylic Certificate of Completion for Microsoft PowerBI - Dashboard in a Day, Softcrylic
- IBM Certification for TM1/Planning Analytics, IBM
- IBM Certification for Cognos Analysis/BI Reporting Suite, IBM
Timeline
Lead Architect
Cognizant Technology Solutions US Corp
11.2023 - Current
Manager - Projects
Cognizant Technology Solutions US Corp
10.2014 - Current
Technical Lead - Managed Services
Cognizant Technology Solutions US Corp
10.2014 - 11.2023
System Analyst
Titan Technologies Inc.
03.2014 - 10.2014
IT - Architect
Tata Consultancy Services Limited
02.2008 - 03.2014
Sr. System Engineer
IBM India Pvt Ltd
10.2007 - 02.2008
System Engineer
AON Hewitt (FORMERLY HEWITT INDIA PVT LTD.)
04.2006 - 10.2007
BI Consultant
Enigma Consulting
02.2004 - 04.2006
- Coursera Certified Generative AI with Large Language Models Using Python and AWS, Coursera
- Coursera Certified Data Analysis using PySpark, Coursera
- Softcrylic Certificate of Completion for Microsoft PowerBI - Dashboard in a Day, Softcrylic
- IBM Certification for TM1/Planning Analytics, IBM
- IBM Certification for Cognos Analysis/BI Reporting Suite, IBM
Master - Computer Application (Computer Science)
Gurukula Kangri University
Bachelor - Science (H) Mathematics
Delhi University
Similar Profiles
BHUVANESWARI SUBRAMANIANBHUVANESWARI SUBRAMANIAN
Delivery Manager at Cognizant Technology Solutions US CorpDelivery Manager at Cognizant Technology Solutions US Corp
Rajesh RamachandranRajesh Ramachandran
IT Senior Manager - Projects at Cognizant Technology Solutions, US CorpIT Senior Manager - Projects at Cognizant Technology Solutions, US Corp
Rakkappan ChandrasekaranRakkappan Chandrasekaran
Technology Architect at Cognizant Technology Solutions US Corp.Technology Architect at Cognizant Technology Solutions US Corp.