Now you can Instantly Chat with Sharadh!
About Me
Ten years of Experience in Data warehousing and reporting. Four years of experience as Tableau consultant including one and half years of US experience. Have worked across all phases of the Data warehouse project life cycle and well versed with the c...
Show MoreSkills
Portfolio Projects
Description
Involved in development and enhancement of Department and Employee dashboards.Responsibilities:Develop various customized charts using calculated fields, parameters and filters etc.Involved in defect fixing and finding work-around solutions,Deployed dashboards in Server,Involved in end-to-end testing of the reports.Environment: Tableau Desktop 2018.1.4, Tableau Server 2018.1.4, Hive, MS office.
Show More Show LessDescription
In this project our main aim is to convert the reports in SSRS to TableauResponsibilties:Involved in requirement analysis/ GAP Analysis,Prepared Business requirements document,Prepared Functional specifications document,Recommended visualizations and key metrics to be used,Designed dashboards according to business needs,Prepared interactive dashboards using calculated fields, parameters, filters and hierarchies,Linked dashboards using Filter actions and URL actions,Involved in writing SQL queries and views,Published the dashboards in Tableau Server.Assigned tasks to team and fixed the issues team faced.Involved in end-to-end testing of the reports,
Show More Show LessDescription
The Client wanted to start a Global Data Warehouse (GDW) to meet its analytical reporting and decision support requirements. Main objective of the GDW is to Increase business efficiency through a centralized global view of holdings.Responsibilities:Involved in requirement analysis,Worked on preparing BRD/FRD documents,Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.Good Experience in publishing reports and dashboards to Tableau server.Used Aggregations, Table calculations, Grand Totals, Percentages using Key Performance Measures ( KPIs).Interact professionally with diverse group of professionals in the organization including managers and executives.Extensively used data blending for combining data from different data sources.Scheduled extract for reports in Tableau.Environment: MS Visio, Tableau Desktop 9.0, Tableau Server 9.0, MS Windows, Oracle 12g, MS Excel, SQL Developer, Agile.
Show More Show LessDescription
To provide product suite pre-approvals for Bank increasing product actualization, improving customer experience and providing a foundation to pre-approve customers for additional products in the futures. The idea is to evaluate credit score and risk for customer data and pre-approve the customers for different products based on their score levels. The evaluation will be based on house holding rules credit payment history and exclusion rules. Analyze and Extract the data from TSOI (Mainframe COBOL data set) flat files and populate Using Informatica ETL tool and load all data accurately to the datamart Database (Oracle). The frequency of the load is Weekly. Before loading the data the PL/SQL script deletes the last week entries.Responsibilities:Creating various Transformations like Expression, Filter, Sequence generator, Union, Normalizer, Joiner and Lookup to migrate clean and consistent data,Using Informatica Application for Extraction Transformation and Loading (ETL) of Data Warehouse,Using Workflow Manager to create the session and worklets,Creating procedures for constraint (parent-child relationship) based deletions,Involved in the customization of the mappings by analysing the data.Environment: Informatica 8.6, Oracle 10g, SQL Developer, MS Office.
Show More Show LessDescription
The purpose of Property & Casualty Maintenance is to build a data warehouse to implement strategic reporting and analytic capabilities to support decision making for consumers of P&C data and replace legacy reporting systems, enabling improved time to market best-in-class products by providing integrated, consistent, timely, and accurate data. This would be a single source of information for Actuaries, Marketing, Underwriters and other users. The data is moved to staging data store by Informatica tool. SDS tables are populated from Source tables/flat files/xml by running daily and weekly workflows.Responsibilities:Designed ETL process from source to target,Created database objects like staging tables, target tables, synonyms, sequences and stored procedures to move data to target,Developed Informatica mappings, Unit testing - ETL mapping codes and validate the result set data,Document validation rules and exception processing of the mappings,Migrated ETL codes from Development to Test to Production.Environment: Informatica 8.1.1, Oracle 9i, DB2, TOAD, Putty.
Show More Show LessDescription
Parts Planning System is service parts management software package for Motorola customer to link all major distribution centers in all regions to facilitate inventory sharing, centralized purchasing, automated forecasting and making an effective planning using industry standard methods. Servigistics is a web based application for planning and forecasting. Servigistics does the calculation for forecasting by taking data from Servigistics tables. Servigistics tables are populated from Source tables/flat files/xml by running daily and weekly workflows.Responsibilities:Studied and analyzed existing mappings/sessions and identified performance bottlenecks,Worked on the change requests from clients as well as their reporting needs.Modified dimension and fact tables and modified ETL mappings as per business requirements.Performance tuning of the sessions using Workflow Manager Statistics and front end query tools.
Show More Show LessDescription
As part of the Auto Finance IT team our goal was to figure out usage of the services provided within US territories user base and also to replace our existing reporting facilities. BOA only finances new or used cars purchased from franchise dealers of auto manufacturers such as Ford, General Motors, Honda and Others. Using Tableau dashboards were created to represent region wise distribution of customers for new,used, refinance and leased cars.Responsibilities:Actively involved as part of a team for gathering and analyzing the needs of end user requirements and system specifications.Scheduled extract synchronization with database.Designed various Data visualizations, charts, dashboards, prototypes and demos, published it in Tableau Server.Worked closely with the business users to identify various KPIs and designed solutions to enhance business decision-making.Involved in generating daily/weekly finance trending reports using Tableau.Successfully administered user, user groups, and scheduled instances for reports in Tableau.Improved performance by tuning dashboards.Worked on various complex SQL queries and views to implement the business logic.Worked on Integration testing of the reports.Environment: Tableau Desktop 8, Tableau Server 8, Oracle 11g, SQL Developer
Show More Show LessDescription
Analyzing the user requirements, preparing documents and developing specifications,Created mappings, mapplets and workflow design,Performance Tuning of the Workflow, Session and Mapping,Involved in in Data Extraction from Oracle and flat file data sources to load the extracts into the target warehouse,Involved in unit testing.Environment: MS OFFICE, Informatica 8.6, SQL Developer, Oracle 11g.
Show More Show LessDescription
Order Management System is used to track the history of each ORDER. OMS maintains entire life cycle
of each order. Every order progresses from draft order created to order delivered status. Orders are
Classified according to their order types. There are multiple order types like Add-on, Conversion,
Multisite, Resale etc. Summary dashboard lists the number of orders in each status and order type. The
First drill down provides information on how many orders are in an order date for particular status and
Order type. The second drill down provides order progress of orders for selected order date. The third drill
down provides details for selected order.
Responsibilities:
- Recommended visualizations and key metrics to be used,
- Prepared interactive dashboards using calculated fields, parameters, filters and hierarchies,
- Linked dashboards using actions,
- Deployed dashboards in Server,
- Used data blending functionality to combine data from two data sources,
- Involved in writing SQL queries and views,
- Key Metrics used in the project include Year to date, Churn Percentage, Year-on-Year Percentage etc,
- Involved in end-to-end testing of the reports.
Description
Responsibities:
- Recommended visualizations and key metrics to be used,
- Develop interactive dashboards using parameter, filters, hieararchies etc.
- Deployed dashboards in Server.
- Involved in end-to-end testing of the reports
Environment: Tableau Desktop 2018.1, Tableau Server 2018.1, Azure Hive, MS office.
Show More Show LessDescription
- Involved in requirement analysis,
- Involved in preparation of Business requirements document,
- Worked on preparation of Functional requirements document,
- Recommended visualizations and key metrics to be used,
- Prepared interactive dashboards using calculated fields, parameters, filters and hierarchies,
- Linked dashboards using actions,
- Deployed dashboards in Server,
- Used data blending functionality to combine data from two data sources,
- Involved in writing SQL queries and views,
- Key Metrics used in the project include Year to date, Churn Percentage, Year-on-Year Percentage etc,
Involved in end-to-end testing of the reports.
Show More Show LessDescription
- Involved in requirement analysis/ GAP Analysis,
- Prepared Business requirements document,
- Prepared Functional specifications document,
- Recommended visualizations and key metrics to be used,
- Designed dashboards according to business needs,
- Prepared interactive dashboards using calculated fields, parameters, filters and hierarchies,
- Linked dashboards using Filter actions and URL actions,
- Involved in writing SQL queries and views,
- Published the dashboards in Tableau Server.
- Assigned tasks to team and fixed the issues team faced.
- Involved in end-to-end testing of the reports,
Description
- Actively involved as part of a team for gathering and analyzing the needs of end user requirements and system specifications.
- Scheduled extract synchronization with database.
- Designed various Data visualizations, charts, dashboards, prototypes and demos, published it in Tableau Server.
- Worked closely with the business users to identify various KPI's and designed solutions to enhance business decision-making.
- Involved in generating daily/weekly finance trending reports using Tableau.
- Successfully administered user, user groups, and scheduled instances for reports in Tableau.
- Improved performance by tuning dashboards.
- Worked on various complex SQL queries and views to implement the business logic.
- Worked on Integration testing of the reports.
Description
- Analyzing the user requirements, preparing documents and developing specifications,
- Created mappings, mapplets and workflow design,
- Performance Tuning of the Workflow, Session and Mapping,
- Involved in in Data Extraction from Oracle and flat file data sources to load the extracts
into the target warehouse,
- Involved in unit testing.
Description
Responsibilities:
- Develop various customized charts using calculated fields, parameters and filters etc.
- Involved in defect fixing and finding work-around solutions,
- Deployed dashboards in Server,
- Involved in end-to-end testing of the reports.
Environment: Tableau Desktop 2018.1.4, Tableau Server 2018.1.4, Hive, MS office.
Show More Show LessDescription
Fannie Mae is an independent regulatory agency, which oversee the components of the secondary mortgage market and their goal is keep the customers and the overall housing finance system healthy. HexaView will provide a wide range of technical, business and operational metrics with advanced analytics and benchmarking. We build this project for Fannie Mae. It will take inputs from different sources like ALM tools – TFS, Jira powered by .Net and Oracle.Most of the clients who have moved their execution model from traditional to Agile have challenges in measuring productivity, predictability, quality, managing risks, measuring Agile maturity and ROI. HexaView deals with analytics and data comparisons against the industry standards which helps clients understand the performance of the team.Responsibilities:Collected and framed data for analysis,Understand clients requirements to define business solutions in analytics,Designed Key Performance Indicators(KPIs) for different levels of claims as per clients requirements,Measured the performance and challenges in Productivity, Predictability, Quality level,Created reporting Templates, Interactive dashboards and work sheets as per client requirements,Gathering and documentation of the requirements corresponding to each module,Used Parameters, Actions and calculated fields to filtering the data for better understanding of the data.
Show More Show Less