Description
Giant Eagle is a supermarket chain with stores in the U.S. states of Pennsylvania, Ohio, West Virginia, Indiana and Maryland. We manage complete retail sales information of all independent and corporate stores of Giant Eagle. We process the data, and generate/ develop various kind of reports as per business needs
Responsibilities
- Involve in software development Life cycle (SDLC) and participated in scrum meetings with team
- Involve in requirement gathering and calls with clients
- Communicate to business users on sprint basis for development update and confirmations
- Develop Excel PowerView, PowerQuery and PowerPivot dashboards for data analysis
- Developed complex SSIS packages for data retrieval and cube processing automation
- Deployed SSIS packages to Automic UC4 tool, for automation and scheduling
- Create DAX and VB scripts for Excel reporting and calculated members
- Use SSIS for data processing on daily basis and automation
- Create tabular SSAS cubes for fast retrieval of data
- Extensive usage of SQL Profiler and Analytics for query optimization and maintenance
- Understand legacy OBIEE reports, and coming up with data points
- Re write complete legacy OBIEE reports in new technology using PowerPivot and tabular models
- Created multiple SSRS reports
- Create test and verification documents
- Create understanding and guidelines documents for business users
- Complete deployment to production and verification
- Use Microsoft Team Foundation Server for maintaining code
- Use SharePoint for maintaining reports, documents and project details
Operating System Windows 7 Enterprise
Languages T SQL, SQL Server 2012, SSIS, SSAS, SSRS, Oracle 11g, Oracle Exadata, SharePoint, Tabular, Excel PowerPivot
Software Visual Studio, Team Foundation Server, SQL Server Management Studio, SQL Profiler, Atomic UC4, Oracle SQL Developer