Now you can Instantly Chat with Mahesh Chandra!
About Me
Desiring senior managerial opportunities utilizing skills & experience, earned so far, to drive DWH/BI initiatives, resulting in Growth of the Organization A proactive and senior IT Project Professional, offering over 19 years of enriched development...
Show MoreSkills
Portfolio Projects
Description
As a Informatica Practice Lead at ATCI :
- Responsible for Capability development of new Informatica products like EDC, Axon and Secure@Source
- Own offering development using Informatica stack of products. Responsible for Compliance offering
- Support RFPs in terms of estimation and solutioning
Description
A project to migrate Northern Trust trading platform from Algo to Murex. The project also require development of Murex data mart and Credit Risk Data warehouseA project to migrate Northern Trust trading platform from Algo to Murex. The project also require development of Murex data mart and Credit Risk Data warehouse
As a Data Architect primarily responsible for coming up with data model for Murex Data mart and Credit Data warehouse. Responsible for ETL architecture
Show More Show LessDescription
- The project was to migrate Salespage application, of the client, to SFDC. This was a global implementation of Salesforce and involved migrating data for APAC, EALA and North America region.
- Complete ownership of Data migration stream from requirement gathering to implementation
Description
- Headed a Project Team with 80 resources as Onshore Delivery Manager for NAGE Enterprise Data Services Team and managed the Knowledge Transfer plan
- Brought down Incident Backlog from 130 to single digits within 4 months’ span of joining service delivery operations of CYBK
- Slashed Development Time by 50% by developing reusable assets for loading data from multiple files to database while working on DW project
- Successfully accomplished 30+ projects simultaneously
- Ensured smooth transition of application from CYBG to Accenture while delivering solutions within preset budget & timelines
- Performing high level design for ETL
- Ensuring that solution developed meets the reporting requirement
Description
- A data warehousing solution developed in parallel with AIS, and with concurrent go-live dates, for reporting data from other sources such as claims from the Claims Components System (CCS), and for providing interfaces and data feeds to other systems, by extracting Data daily from AIS and loading into a data warehouse for historical records
- Responsible for requirement gathering and ETL design
Description
- An Application to provide business intelligence solution to UBS Equities Group, by selectively extracting Data from various sources, relating transforming and loading same into the Oracle database using Informatica Power Center ETL tool, to create analytical based on different dimensions using Business Object intelligence tool
- Responsible for Data Modeling and ETL design
Description
- Project to provide off-shore support in offering full range of operational, financial and analytic support, developing customized marketing programs designed to increase sales and customer loyalty for private-label credit cards, commercial programs and card-related financial services for hundreds of retailers across North America
- Responsible for Application Maintainance of Consumer data warehouse