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

Description

DRAW is a centralized repository that provides key stakeholders with the tools for strategic data-driven decision making. Its primary goal is to drive operational analysis for all digital display campaigns.

Responsibilities

• Involved in architecture changes, and introduced SQL 2012 and its usage
• Migrated SQL 2008 databases, SSIS packages to SQL 2012
• Created PowerShell script, to automate deployment of databases, SSIS packages to 2012 servers
• Developed C# tool to update and populate destination tables schema coming from Excel files
• Involved in requirement gathering and calls with clients
• Communicate to client on sprint basis for development update and confirmations
• Developed Excel PowerView, PowerQuery and PowerPivot dashboards for data analysis
• Created DAX and VB scripts for Excel reporting and calculated members
• Used SSIS extensively for data loading with different source and destination connections
• Used various transformations like UNION, MERGE, LOOKUP, CONVERSION, DERIVED COLUMN, AGGREGATIONS
• Used SFTP components in fetching files from FTP servers
• Wrote PowerShell script for downloading and archiving files from FTP server
• Created tabular SSAS cubes for fast retrieval of data
• Created perspectives in tabular SSAS cube
• Created roles in tabular SSAS cube for security
• Involved in complete understanding of business requirement and involved in analyzing, Data profiling the sources to load.
• Designed Sources to Targets mappings from Excel files to SQL
• Responsible for Defining Mapping parameters and variables and Session parameters according to the requirements and performance related issues.
• Wrote test plans and executed it at Unit testing and also supported for system testing, volume testing and User testing. Also provided production support by monitoring the processes running daily
• Identifying and documenting the technical issues and the approach to resolve the same.
• Followed agile project methodology to discuss with team every day, and with client on sprint basis

Operating System Windows 7

Languages T SQL, SQL Server 2008 R2, SQL Server 2012, MSBI Tools, .NET

Software Visual Studio, Team Foundation Server, SQL Server Management Studio, SQL

Description

Cloud and Enterprise system is for reporting and analyzing views and clicks information of sites and its url's

Developed different kind charts to analyze views, visits and clicks w.r.t. various sections like end actions, locale, country and site

Responsibilities

• Lead a team of 3 people, and interacted with client every day
• Developed Excel PowerView and PowerPivot reports for data analysis
• Involved in requirement gathering and calls with clients
• Created Coded UI solutions for daily refreshing of Excel files from source
• Scheduled Coded UI solutions from windows task scheduler
• Involved in complete understanding of business requirement and involved in analyzing, Data profiling the sources to load.
• Designed Sources to Targets mappings from Excel files to SQL using SSIS
• Responsible for developing complex transformation mappings using different types of transformations like UNION transformation, Connected and Unconnected LOOKUP transformations, and Update strategy transformations for large volumes of Datasets.
• Implemented slowly changing dimension Type 1 and Type 2
• Responsible for Defining Mapping parameters and variables and Session parameters according to the requirements and performance related issues.
• Wrote test plans and executed it at UNIT testing and also supported for system testing, volume testing and User testing. Also provided production support by monitoring the processes running daily
• Developed tabular models for Excel PowerPivot reporting
• Created stored procedures as per business logic to populate mart
• Created dimensions and facts based on star schema
• Extensive usage of SQL Profiler and Analytics for query optimization and maintenance
• Created multidimensional cube with dimensions and facts for PowerView reports
• Created Reporting database from mart which contains separate tables as per chart needs
• Worked on handling performance issues, Troubleshooting of Mappings, evaluating current logic for tuning possibilities.
• Identifying and documenting the technical issues and the approach to resolve the same.

Operating System Windows 8, Windows Server 2012 R2

Languages T SQL, SQL Server 2012, MSBI Tools, HTML5, CSS, JavaScript, .Net

Software Visual Studio, Team Foundation Server, SQL Server Management Studio, SQL

Responsibilities

• Analyzed requirements, suggested new implementation processes
• Followed Agile methodology in project delivery
• Worked on all aspects of MSBI (SSIS, SSAS) , Power pivot, Power view
• Developed tabular models with star schema
• Involved in performance tuning of tabular models
• Worked on UI technologies .Net, SharePoint, HTML, JavaScipt and CSS
• Communicating with the client for collecting the requirement, document them, implementation the same.
• Identifying and documenting the technical issues and the approach to resolve the same.
• Migrated databases

Operating System Windows 7, Windows Server 2008

Languages T SQL, SQL Server 2008 R2, MSBI Tools, HTML, CSS, JavaScript, .NET

Software Visual Studio, Team Foundation Server, SQL Server Management Studio

Description

Objective of this stream is to develop dashboard/ reports requested by different subsidiaries of stake holders. This involves creation of data mart from different data sources and development of reports on top of it

Responsibilities

• Worked on all aspects of MSBI (SSIS, SSAS) , Power pivot
• Implemented Cube Security, ETL mails
• Created tabular models with dynamic partitions
• Responsible for supporting the project for various BR’s and CR’s
• Communicating with the client for collecting the requirement, document them, implementation the same.
• Identifying and documenting the technical issues and the approach to resolve the same.
• Scheduled daily refresh jobs from SQL Server agent, and provided support in case off ETL failure
• Synced up with source teams regularly and fixed ETL issues
• Provided support to down streams regularly who are using reports
• Implementing slowly changing dimensions to maintaining Historical data in required dimension table.
• Wrote Stored Procedures and functions.
• Involved in Performance Tuning.
• Unit tested the packages.

Operating System Windows 7, Windows Server 2008

Languages T-SQL, SQL Server 2008/2008R2, SSIS, SSAS, MDX, HTML5, CSS, JavaScript, .NET

Software Visual Studio, Team Foundation Server, SQL Server Management Studio, SQL Profiler

Responsibilities

• Worked on all aspects of MSBI (SSIS, SSAS), Power pivot
• Supported tabular models, and fixed issues related to column mappings
• Involved in end to end system development and design of the project
• Provided solutions to automate ETL
• Supporting the in project set up and meeting if needed
• Identifying the issues and trying to resolve them

Operating System Windows 7

Languages T SQL, SQL Server 2008, SSIS, Excel PowerPivot

Software Visual Studio, Team Foundation Server, SQL Server Management Studio