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.• Prioritized and handled multiple projects.• Have very strong analytical skills that are required for BI analyst such as thorough understanding of how to interpret business needs and translate them in to application and operational requirement.• Identified process improvement opportunities within the application by developing new strategies and improving processes as well as performances.• Utilized knowledge of SQL programming, BI Software such as SAP Crystal Reports, IBM Cognos, Tableau etc., Excel and other optimization methods to perform quantitative and qualitative data analysis.• Worked with business to capture requirement and conceptualize solution• Worked with technical groups to create, implement solutions and maintain reporting processes.• Conducted acceptance testing of reporting solutions.• Created and delivered Ad-hoc reports as needed.

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.• Prioritized and handled multiple projects.• Have very strong analytical skills that are required for BI analyst such as thorough understanding of how to interpret business needs and translate them in to application and operational requirement.• Identified process improvement opportunities within the application by developing new strategies and improving processes as well as performances.• Utilized knowledge of SQL programming, BI Software such as SAP Crystal Reports, IBM Cognos, Tableau etc., Excel and other optimization methods to perform quantitative and qualitative data analysis.• Worked with business to capture requirement and conceptualize solution• Worked with technical groups to create, implement solutions and maintain reporting processes.• Conducted acceptance testing of reporting solutions.• Created and delivered Ad-hoc reports as needed.

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.• Extensive experience in developing stored procedures, functions, Views and Triggers, Complex queries using SQL Server and Oracle PL/SQL.• Experience in resolving on-going maintenance issues and bug fixes; monitoring Datastage sessions as well as performance tuning of mappings and sessions.• Experience in system analysis, design, coding and testing. Extensive experience in the Data Warehousing implementations and Data Migration.• Experience in Database Development mainly using Oracle database. • Experience with Data Cleansing, Data Profiling and Data analysis through SQL and PL/SQL coding.• Performance Tuning of Datastage Mapping and workflow.

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• Implemented minor enhancements to enhance user experience and reducing clarification calls.• Ensure all the Online & Batch processes goes well for BOSS round the clock.• Timely delivery of manually generated adhoc reports from the database. • Involved in regular discussion with Onsite team/clients in every stage of the project to look proactively so as not to have any changes in the later stages of the project which might affect both cost and schedule of the delivery• Allocating and monitoring of the work-items given to the team• Delivered Analysis / Research / Data Reports/ Root Cause Analysis timely.• Provided Daily/weekly status updates to Client Managers.