Premkumar Chandran Email & Phone Number

Chennai, TN, IN

Carlsbad, CA, US

Responsible for Executive dashboards & Operational reports for Global Fixed Broadband departments.

Mumbai, Maharashtra, IN

• Strong understanding of Mortgage Servicing business model and competitive/benchmark landscape; recommend and drive best practice adoption.
• Managed communications with internal leadership teams within the organization to identify requirements and scope of reporting project.
• Created and maintained reports & Dashboards through BI tools such as SAP Crystal Reports, IBM Cognos etc. by building Database Objects using PL/SQL as well as VB scripts.
• Monitored and ensured timely delivery of daily operational reports
• Analyzed MIS reports to provide feedback and made changes whenever needed.
• Assisted reporting manager in the design of business reporting templates/dashboards etc. and automation of reporting requirement either through BI tools as well as via SQL procedures.

Mumbai, Maharashtra, IN

• Strong understanding of Mortgage Servicing business model and competitive/benchmark landscape; recommend and drive best practice adoption.
• Managed communications with internal leadership teams within the organization to identify requirements and scope of reporting project.
• Created and maintained reports & Dashboards through BI tools such as SAP Crystal Reports, IBM Cognos etc. by building Database Objects using PL/SQL as well as VB scripts.
• Monitored and ensured timely delivery of daily operational reports
• Analyzed MIS reports to provide feedback and made changes whenever needed.
• Assisted reporting manager in the design of business reporting templates/dashboards etc. and automation of reporting requirement either through BI tools as well as via SQL procedures.

Mumbai, Maharashtra, IN

• Primarily focused on Data warehousing, Data modeling, Data integration, Data Migration, ETL process and Business Intelligence.
• Generating Reports using Business Intelligence tools such as SAP Crystal Reports.
• Strong Expertise in Datastage ETL and reporting tools. Deep understanding of the Data Warehousing SDLC and architecture of ETL, reporting and BI tools.
• Drawing on Experience in all aspects of analytics/data warehousing solutions (Database issues, Data modeling, Data mapping, ETL Development, metadata management, data migration and reporting solutions).
• Strong understanding of Data Modeling (Relational, dimensional, Star and Snowflake Schema), Data analysis, implementations of Data warehousing.
• Developed mappings in Datastage to load the data from various sources into the Data warehouse different transformations like Source Qualifier, Expression, Lookup, Aggregate, Update Strategy and Joiner.

Mumbai, Maharashtra, IN

• Ensured that Client’s applications are available and supported in line with defined system service level agreements.
• Acted as point of contact for Client application service interruptions; oversee all crisis and incident management processes.
• Implemented permanent bug fixes by doing root cause analysis and code changes for recurring issues.
• Analyzed production tickets assigned to group for all issues and made decision of permanent fix as code change.
• Coordinated with testing teams such as TCOE/CST to get the signoff for these changes.
• Ensure successful implementation of the changes by performing post implementation certifications as well as monitoring for the same