Devesh Ojha
Software Engineer
Pune
Summary
Enthusiastic Associate Director polished in optimizing systems to address dynamic needs, improve collaboration and strengthen security. Weighs finance business and IT needs against procedural limitations to assess roadmaps for optimal functions. Forward-thinking professional offering 13 years of experience working for IT consulting firms on configuration projects. Trained in Finance with extensive ETL skills and history of proactivity. Dedicated to solution-oriented problem-solving.
Overview
14
14
years of professional experience
6
6
years of post-secondary education
Work History
Associate Director
TIAA Global Capabilities
Pune
08.2017 - Current
- Collaborate with finance leaders and stakeholders to understand strategic objectives and defined roadmap for finance ETL platform aligned with business goals
- Define architecture and design principles for finance ETL platform, considering scalability, performance, data governance, security, and compliance requirements specific to finance domain.
- Evaluate and select appropriate technologies, tools, and frameworks for finance ETL platform, considering factors such as data volume, complexity, integration capabilities, and industry best practices.
- Improved overall Cost efficiency by doing multiple innovation.
- Leveraged data and analytics to make informed decisions drive business improvements.
- Implementation of Data governance in project with vendor products
Senior Technical Consultant
DerivIT Technologies
05.2014 - 08.2017
- Integrated the various source system & working as Team lead for Cross team collaboration QA, DevOps, and Support to ensure seamless end-to-end Product delivery process
- Translated technical concepts and information into terms parties could easily comprehend
- Helped with solution to generate the future cash flow based on nature of finance Product & Analyzing the granularity of raw data available in source system & reporting capability
- Advised management, business and technical staff on solutions using ALM domains or technology
- Offered input on technical and platform-related strategic planning initiatives
- Working closely with business users for Production related issue and resolution
Consultant Specialist
KPIT Technologies Mumbai
07.2014 - 05.2015
- Managed client relationships through regular check-ins and updates on project progress.
- Provided ongoing support to clients post-implementation, ensuring long-term success of implemented solutions.
- Renegotiated outsourcing contracts to save considerable costs.
- Integrated technology and business operations to identify targeted solutions to customer issues.
- Streamlined internal processes to enhance team efficiency and improve overall project outcomes.
Senior Software Engineer
HSBC GLT
04.2012 - 07.2014
- Working closely with business analysts, users and other system developers to define data sources
- Managed ETL technological issues for assigned projects, increasing customer satisfaction ratings
- Designing the data mart, database schema & outline business rules for Regulatory reporting systems
- Lead the development of source to target ETL mapping design specification
- Understanding and interpretation of functional and non-functional specifications providing appropriate solutions.
- Providing the Accuracy and timeliness of delivering solutions using IBM coding standards and best practices
- Designing appropriate technical solution by creating Technical Impact Analysis document based on business solution
Software Engineer
Patni Computer Systems Ltd.
05.2010 - 04.2012
- Analyzing the business logic of the application
- Monitoring ETL loads, specifying abend, ensuring timely kick off and completion of jobs as per schedule
- Data clean up in GDW on load Failure
- Code Migration from one environment to another
- Performing special runs on demand
- Finding the cause of failure and restarting the job as required
- Communicate to the support group with the details of reject files created after each process
- To analyze the records in the rejects file and suggest corrective actions – Delete, Reload, Ignore
Education
B.E - Computer Science
Rajeev Gandhi Technical University, Bhopal
Mandsaur 01.2005 - 06.2009
HSC -
M.P Board
07.2004 - 04.2005
SSC -
M.P Board
07.2002 - 04.2003
Skills
ETL : AWS Glue, IBM DataStage, Informatica, Snaplogic
undefinedAccomplishments
- Passed FRM level 1 exam
- Received the Rising star award for Q4 2013
- Revived the Team award for Q3’ 2013
- Received the Rising star award for the Q2’ 2013
- Received the ‘Valuable Contribution Award’ for excellence of work and performance. Q3’ 2011
- Received the ‘Pat on the Back’ for data analysis and successful on boarding of Malaysian market. Q4’ 2010
Personal Information
- Father's Name: Mr. Sudhir Ojha
- Date of Birth: 10/23/88
Extracurricular Activities
Attended 10 days training on advanced C/C++ in HCL during academic years Participated in inter college AD Mad competition and Secured 2nd position Participated in state level Science Fair
Projects
ALM(Asset Liability Management), Standard Chartered Bank, Windows, Linux, Liquidity Risk, Datastage 9.1, Oracle, FERMAT, OBIEE,PL-SQL, Senior Consultant Specialist, Asset and Liability management (ALM) is the SCB Internal project of managing risks that arise due to mismatches between the assets and liabilities. project produces the dashboard which states the health of the liquidity and risk profile of the bank by providing the information of expected Future Cash Flow.
It also help bank to do the regulatory reporting of Basel III Risk, It aims at providing the LCR information to sustain the bank in stress period of 30 days. Interest rate risk in banking book provides the information on risk involved when interest rates changes with 25 bps, 50 bps and 100 bps., Feasibility study & understanding requirements mentioned in the RFP, Integrating the various source system, Working as Project lead coordination with other downstream for change., Providing a proposed solution to generate the future cash flow based on nature of banking Product., Analyzing the granularity of raw data available in source system & reporting capability, Design & Maintenance of centralized Data warehouse, Working as a SME and providing the IA of the change, Working closely with business users for Production related issue and resolution., Creating Project plan for regression & SIT testing, Coordinating release management & Change related process KGOC PM & BI Implementation, KGOC (Kuwait Gulf Oil Corporation), Windows, Linux, Energy - Oil, Datastage 9.1, IBM Cognos, TM1, Oracle, Senior Consultant Specialist, The KGOC PM & BI Implementation solution is to integrate the different source systems and provide an integrated view of information to KGOC which will provide KGOC with a reliable decision making platform.
Solution comprises of building a scalable data repository to store both operational and business data that is needed to support the requirements outlined in the RFP. Data from a variety of operational and business data sources will be integrated into this data repository through a flexible data integration layer comprising InfoSphere family of products. A visualization layer on top of the data repository will support BI reporting, balanced scorecards, dashboards, and many other features. Solution also comprises of a planning component that will support an integrated and collaborative planning process where authorized users can contribute and approve through an easy to use interface., Feasibility study & understanding KGOC’s requirements mentioned in the RFP, Analyzing the pain area in current business process., Providing a proposed solution which will meet the current needs and at the same time create a flexible environment which will grow and evolve with KGOC business requirements., Analyzing the granularity of raw data available in source system & reporting capability, Designing a Data warehouse architecture, Creating & defining Scope of Work document, Working closely with business users for gathering the requirements & detailed business rules., Creating a Conceptual Data Model, Working with IT system users to define data sources for ETL layer, Creating a logical & Physical data Model using ER Win Group Limit Exposure & Activity Management (GLEAM), HTSE (HSBC Technology Services Europe), Windows, UNIX, Basel 3 – Credit Risk, Datastage, HP Quality Center, Control-M Scheduler, IBM Algorithmic, DB2, Teradata, Team Member, The Group Limit Exposure & Activity Management program is a part of Credit & Finance Strategic Development Program which has the following three main objectives:
To reduce cost and increase efficiency by simplifying the Credit and Finance processes.
To introduce advanced methods of Risk assessment that will improve the identification and management of Risk, Pricing, Capital Allocation and optimization of Risk Adjusted Returns.
To enhance management information capabilities that will improve Decision Making, Portfolio Management and Regulatory Reporting.
The GLEAM project has the overall objective of allowing Group Credit and Risk (GHQ CRF) to manage more the HSBC Group’s credit risk appetite effectively and to support Group Finance (GHQ FIN) with Regulatory Reporting, in particular to meet the requirements of the Basel 2 Accord. GLEAM is one of the flagship projects in HSBC Group. GLEAM Project is divided as GLEAM Daily (Based on Mainframe and GLEAM Monthly (Based on RS6000 and Unix Platform)., Working closely with business analysts, users and other system developers to define data sources and Detailed business rules for Regulatory Reporting systems, Lead the development of source to target ETL mapping design specification, Designing the data mart & database schema, Analyzing and providing level 1 estimate and input to test plans and testing strategies, Providing input to design discussions forum, Understanding and interpretation of functional and non-functional specifications providing appropriate solutions., Providing the Accuracy and timeliness of delivering solutions using IBM coding standards and best practices, Designing appropriate technical solution by creating Technical Impact Analysis document based on business solution., Mapping of complex business solution in ETL with the help of Datastage, Unix, PL-SQL., Working as Module lead and handling of all technical issue for a specific module., Creating the test plan for UAT and System testing., Review of all affected components and providing handover for them., Creation of UNIX Shell & PL-SQL Scripts based on requirements., Analyzing all Environment failures & Live issue and providing appropriate solution for them., Providing the System test, UAT and Live Support during code release phase., Analysis of all the defects occurred in the end of release and providing the solution to prevent them, Migration of the all affected components from one environment to other, Analyzing the quality defects and fixing of those as well, Working on productivity and process improvement program. COREP Reporting (RCT), HSBC UK, Windows, UNIX, Datastage, MKS, HP Quality Center, Control-M scheduler, 20, Team member, The objective of Report Consolidation Tool (RCT) project is to consolidate the data and provides the Regulatory Reporting capability for HSBC Group and UK Bank to the UKFSA and other regulators. The Risk Weight results held in Datamart supplemented with data from other source systems is fed in to RCT, which consolidates the Risk Weighted Assets and contributes to the Credit Risk portion of the FSA and Basel 2 Pillar 3 reports
The initial focus of this data warehouse is to provide a technical solution for COREP reporting which satisfies the lenders need and able to consolidate all the credit risk data for reporting purpose., Analyzing the business logic of the application, Acting as a Subject matter expert and helping business to design solution, Analyzing the business solution documents and creating the Software document specification, Part of CRD IV implementation., Mapping of business solution in ETL with the help of Datastage., Assist in the estimating and planning of given module., Analyzing the Live issue and providing appropriate solution, Providing the System test, UAT and Live Support during code release cycle, Peer to peer code and UTP review, Migration of the all affected components from one environment to other, Analyzing the quality defects and fixing of those as well, Provide Support development, system test team during implementation of release. Datastage Operation Support & Maintenance, McDonalds, Windows, UNIX, Datastage, Teradata, Clear Case, Service Center, Hummingbird scheduler, Team member, The objective of Global Data Warehouse (GDW) projects is to build data warehouse architecture that will consolidate and transform data into useful information for the purpose of analyzing global corporate data. The initial focus of this data warehouse will be to provide a technical solution, which satisfies the clients need.
Data Stage Operation Support is a 24x7 Production support project.
Primary goal of project is to provide data for analysis purpose in Microstrategy reporting environment using Datastage as an ETL tool. There are various service level agreements which govern the execution of project., Analyzing the business logic of the application, Monitoring ETL loads, specifying abend, ensuring timely kick off and completion of jobs as per schedule, Data clean up in GDW on load Failure, Code Migration from one environment to another, Performing special runs on demand, Finding the cause of failure and restarting the job as required, Communicate to the support group with the details of reject files created after each process, To analyze the records in the rejects file and suggest corrective actions – Delete, Reload, Ignore Root Cause Analysis & Break-Fix, McDonalds, Windows, UNIX, Data Stage, Teradata, Service Center, Microstrtagy, Teradata Viewpoint, IM, GBL tool, Team member, The project deals with end to end implementation of Global data warehouse within McDonalds.
Objective of RCA and Break-Fix is to provide detail analysis of issues reported by McDonald’s various business users in timely manner and Enhancing the production system performance. The initial focus of this is to identify various issues that occur during migration of the International data warehouse which was in informatica to GDW in datastage and provide technical solutions, which satisfies the clients need., Identifying the issue (ETL side or reporting side), analyzing and fixing the same, Requirement analysis defining the scope of requirement (enhancement or bug fix), Creation and testing of SQL, UNIX scripts., Mapping the Business requirements in ETL., Communication with the stake holders and business user of McDonalds involving data related issues, Based on nature of incident, fixing of ETL code ,Unix and SQL scripts, Customization and creation of reports based on business request being enhancement or bug fix, Process improvement, Data profiling
Disclaimer
I consider myself familiar with Computer Science and Engineering Aspects. I am also confident of my ability to work in a team. I hereby declare that the information furnished above is true to the best of my knowledge.
Timeline
Associate Director
TIAA Global Capabilities
08.2017 - Current
Consultant Specialist
KPIT Technologies Mumbai
07.2014 - 05.2015
Senior Technical Consultant
DerivIT Technologies
05.2014 - 08.2017
Senior Software Engineer
HSBC GLT
04.2012 - 07.2014
Software Engineer
Patni Computer Systems Ltd.
05.2010 - 04.2012
B.E - Computer Science
Rajeev Gandhi Technical University, Bhopal
01.2005 - 06.2009
HSC -
M.P Board
07.2004 - 04.2005
SSC -
M.P Board
07.2002 - 04.2003
Similar Profiles
Ishita GuptaIshita Gupta
ASSOCIATE, SPECIALIST - FULL STACK DEVELOPMENT at TIAA Global CapabilitiesASSOCIATE, SPECIALIST - FULL STACK DEVELOPMENT at TIAA Global Capabilities
Yashraj MohiteYashraj Mohite
Senior Associates at TIAA Global Capabilities Pvt LtdSenior Associates at TIAA Global Capabilities Pvt Ltd
Harpreet MinhasHarpreet Minhas
Sr.Associate/Manager at TIAA Global CapabilitiesSr.Associate/Manager at TIAA Global Capabilities