P Subramanyam Email & Phone Number

Bengaluru, Karnataka, India

Citi Bank Financial Services is an IT service provider for the CITIBANK Services& Insurance for CITI Customers. It has different business areas like Contact centre, Fraud apps, Collections and Recovery etc.,The objective of this project is to develop complex reports for Collections & Recovery Application. The Data Loading happens every day after USA Business Hours and Reports are made available by every day morning with latest data and Finance reports after Month End Loading. There are… Show more Citi Bank Financial Services is an IT service provider for the CITIBANK Services& Insurance for CITI Customers. It has different business areas like Contact centre, Fraud apps, Collections and Recovery etc.,The objective of this project is to develop complex reports for Collections & Recovery Application. The Data Loading happens every day after USA Business Hours and Reports are made available by every day morning with latest data and Finance reports after Month End Loading. There are multiple disparate sources for information about the company’s products, customers and distribution channels. I was engaged in extraction, cleansing, transformation, integration and loading of data into warehouse for policy transactions sending into DW System, and created Reports to analyze the business. Show less

Bengaluru, Karnataka, India

· Connect the data source in direct mode and import mode.· Cleansing activities using Power Query editor in the Power BI.· Worked on improving the performance of reports.· Creating Relationship between the tables using Modelling in Power BI.· Created calculated columns and calculated measures as per the business needs. Writing DAX functions like Filter functions, aggregation functions, iteration functions, period comparisons.· Developing visual reports, dashboard and sharing… Show more · Connect the data source in direct mode and import mode.· Cleansing activities using Power Query editor in the Power BI.· Worked on improving the performance of reports.· Creating Relationship between the tables using Modelling in Power BI.· Created calculated columns and calculated measures as per the business needs. Writing DAX functions like Filter functions, aggregation functions, iteration functions, period comparisons.· Developing visual reports, dashboard and sharing in Power BI Desktop & Power BI report server as is OBIEE reports.· Have created Dimension tables and Fact tables based on business requirement.· Created Relationships at database level and Tabular Model for custom dimension.· Create complex DAX queries as per the requirement.· Apply dynamic RLS for the users.· Schedule the reports according to client requirements using Power BI report server.· Given solution for unsolved issues from long time.· Made use of Joins to combine data within a data source and also performed Cross Database Joins. Used data blending to join different data sources at worksheet level.· Used advanced charts like Waterfall chart, Donut chart, Dumbbell chart and Spark lines to represent information using Tableau desktop.· Created the mappings using Data Flow transformations such as the Derived Column, Conditional Split, Pivot, Lookup and SCD etc by using SSIS.· Used Control Flow elements like For Each loop and Sequence container, Execute SQL Task, Execute Package Task, Script Task, File System Task and Send Mail Task.· Extensively used Derived Column, Data Conversion, Conditional Split and Aggregate. Show less

· Connecting to various data sources and importing data and transforming using Power query in excel and power bi, distilling data into insights in power bi for Business Intelligence.· Connect the data source in direct mode.· Writing DAX functions like Filter functions, aggregation functions, iteration functions, period comparisons, calculated measures, and calculated columns.· Developing visual reports, dashboard and sharing in Power BI Desktop & Power BI Service· Used Power BI… Show more · Connecting to various data sources and importing data and transforming using Power query in excel and power bi, distilling data into insights in power bi for Business Intelligence.· Connect the data source in direct mode.· Writing DAX functions like Filter functions, aggregation functions, iteration functions, period comparisons, calculated measures, and calculated columns.· Developing visual reports, dashboard and sharing in Power BI Desktop & Power BI Service· Used Power BI Gateways to keep the dashboards and reports up to date.· Cleansing activities using Power Query in the Power BI.· Creating Relationship b/w the tables using Modelling in Power BI.· Created calculated columns and calculated measures as per the business needs.· Created Power BI reports and Dash Boards with various visualizations.· Having experience on creating Power BI Gateway and scheduling refreshing data as per requirement.· Sharing the Reports and Dash Boards to end user.· Have created staging tables, Dimension tables and Fact tables based on business requirement.· Created Relationships at database level and Tabular Model for custom dimension.· Having experience in Dynamic direct query parameter.· To attend meetings with business users on weekly sprint meetings to demo and discuss about the work being executed.· Creating stories on Jaira board and updating them on timely manner there by effectively working in an Agile environment.· For the ETL process used Power query and SSIS.· Most of the functionalities that were converted from SSRS to Power BI Reports and the new enhancements also added.· Used SSRS for the validation of the the reports to be converted to Power BI.· To perform ad hoc changes on existing dashboards to incorporate new data points. To validate the data in the reports by cross checking at data base level and maintaining data integrity. Show less

· Development of packages according to the specifications according to the specifications according to client requirements using Power BI report server as is OBIEE reports.· Have created Dimension tables and Fact tables based on business requirement.· Created Relationships at database level and Tabular Model for custom dimension.· Create complex DAX queries as per the requirement.· Apply dynamic RLS for the users.· Schedule the reports according to client requirements using… Show more · Development of packages according to the specifications according to the specifications according to client requirements using Power BI report server as is OBIEE reports.· Have created Dimension tables and Fact tables based on business requirement.· Created Relationships at database level and Tabular Model for custom dimension.· Create complex DAX queries as per the requirement.· Apply dynamic RLS for the users.· Schedule the reports according to client requirements using Power BI report server.· Given solution for unsolved issues from long time.· Made use of Joins to combine data within a data source and also performed Cross Database Joins. Used data blending to join different data sources at worksheet level.· Used advanced charts like Waterfall chart, Donut chart, Dumbbell chart and Spark lines to represent information using Tableau desktop.· Created the mappings using Data Flow transformations such as the Derived Column, Conditional Split, Pivot, Lookup and SCD etc by using SSIS.· Used Control Flow elements like For Each loop and Sequence container, Execute SQL Task, Execute Package Task, Script Task, File System Task and Send Mail Task.· Extensively used Derived Column, Data Conversion, Conditional Split and Aggregate. Show less

· Worked as Software Engineer (SE) in CGI

Masters In Computer Science, Computer Science, Grade-1

Activities and Societies: Active in Legal societies in india and follows the sports regionalism in india. Participated in the oratory.

Master, Computers Applications

Bachelor Of Science