Now you can Instantly Chat with Pravalika!
About Me
Having 4+ Years of IT experience in development as a MSBI Developer. Experience on SSIS 2012/2014, SSRS 2012/2014, MS SQL Server, Power BI Worked with various transformations (Lookup, Multicast, Conditional splits, Derived column, Aggregate, Merge, B...
Show MoreSkills
Portfolio Projects
Description
Dillards inc. is one of the leading super markets in North America. The project includes zonal wise analysis of sales, margins and annual growth is to be compared in a period of time. The source data for this project comes from sales application system. The target is SQL Server database where the sales data will exists as an integrated data from different sources at enterprise level. Data is extracted from different OLTP source systems, cleansed, transformed and loaded into warehouse.
Show More Show LessDescription
Dillard’s inc. is one of the leading super markets in North America. The project includes zonal wise analysis of sales, margins and annual growth is to be compared in a period of time. The source data for this project comes from sales application system. The target is SQL Server database where the sales data will exists as an integrated data from different sources at enterprise level. Data is extracted from different OLTP source systems, cleansed, transformed and loaded into warehouse.
Show More Show LessDescription
The NYC client is one of the biggest revenue generating government bodies in the world and the project involved implementing and customizing the data warehousing solution for the client using an ERP product bundle. The combined data warehousing solution used Pervasive Data Integrator for ETL, Business Objects for reporting with Java providing the framework and Oracle the database. The data warehouse would be built using the existing product offering from the company but customized heavily to suit the reporting needs of the client. This project helps state and local governments turn distributed information into value-added knowledge. With integrated access across the organization, configurable reporting options, sophisticated data access and drill-down capabilities.
Show More Show Less