- Estimate, document, review and evaluate reporting and dashboard requirements and specifications- Work with data & business analysts or end users to gather project requirements, analyze needs and process flow and develop user-oriented data solutions- Perform data entry, either manually or using scanning technology, when needed or required- Work in a team environment offering assistance, advice and technical expertise to peers- Interact regularly with management and clients to… Show more - Estimate, document, review and evaluate reporting and dashboard requirements and specifications- Work with data & business analysts or end users to gather project requirements, analyze needs and process flow and develop user-oriented data solutions- Perform data entry, either manually or using scanning technology, when needed or required- Work in a team environment offering assistance, advice and technical expertise to peers- Interact regularly with management and clients to constantly improve ETL processes, data marts, reporting and dashboard services- Translate business requirements into specifications that will be used to implement the required reports and dashboards, created from potentially multiple data sources- Transition data marts, developed reports, and dashboards to operational and business teams- Provide production support as required to ensure the availability and performance of developed reports and dashboards for both external and internal users- Perform basic statistical analyses for projects and reports- Generate routine and ad hoc reports- Ensure proper configuration management and change controls are implemented for BI data marts and reports- Provide technical assistance and cross-training to other team members- Provide training and assistance to users for generation of ad-hoc reports- Design and implement technology best practices, guidelines and repeatable processes- Acquire and abstract primary or secondary data from existing internal or external data sources- In collaboration with others, interpret data and develop recommendations based on findings- Develop graphs, reports, and presentations of project results- Create and present quality dashboards- Proficient in SAP with a focus on Market to Order (M2O) and Order to Cash (O2C) processes.- Utilized SAP to extract, analyze, and interpret complex datasets, providing actionable insights to drive business decisions and strategy. Show less

- Involved in KT sessions and different Controllers meeting to understand the Business.- Publishing Power BI reports on dashboards in Power BI server. - Modified existing dashboards as per new requirements in Power BI.- Recreated reports from MS Excel to Power BI. - Developed analytics solutions by defining and translating business requirements into dashboard &reporting solutions and implementing them within Microsoft Power BI Desktop and visualizations - Used Power BI… Show more - Involved in KT sessions and different Controllers meeting to understand the Business.- Publishing Power BI reports on dashboards in Power BI server. - Modified existing dashboards as per new requirements in Power BI.- Recreated reports from MS Excel to Power BI. - Developed analytics solutions by defining and translating business requirements into dashboard &reporting solutions and implementing them within Microsoft Power BI Desktop and visualizations - Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.- Designed reports/graphs/presentations using Tableau for specified projects. Produced accurate analysis of project datasets as defined by the required specification.- Involved in dealing with the backend data retrieval team, data mart team to guide the proper structuring of data for Power BI reporting.-Developed and implemented advanced SAP reporting tools and dashboards, facilitating data-driven decision-making and enhancing visibility into key business metrics.- Performed tasks like execute SQL task, data flow task, file system task for ETL process. - Added required measures, calculated columns, keeping unnecessary columns hidden from reporting view in Power BI application.- Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel- Worked a great extent with the design and development of Tableau visualizations which includes Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies etc.- Installed and upgraded Tableau server and server performance tuning for optimization.- Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.- Created Users, User Groups and Projects through Tableau Server Web and assigned roles and permissions for Tableau Users. Show less

- Analysis of Project Requirements and functional specifications of the project.- Gained experience in Business Requirements Gathering, GAP Analysis, Data Modeling, Development, Testing, Implementations and Documentation. - Published reports using Power BI service and used gateways to refresh data when needed.- Understand customer requirement and translate it into appropriate solution.- Deployed the Power BI reports to Power BI services and pinned visuals to improve… Show more - Analysis of Project Requirements and functional specifications of the project.- Gained experience in Business Requirements Gathering, GAP Analysis, Data Modeling, Development, Testing, Implementations and Documentation. - Published reports using Power BI service and used gateways to refresh data when needed.- Understand customer requirement and translate it into appropriate solution.- Deployed the Power BI reports to Power BI services and pinned visuals to improve visualizations and presentations. - Design and development of Tableau visualizations including preparing dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau 2019.- Created dashboards in line with the analytical uniformity using the advanced analysis features of Power BI Desktop.- Creation and delivery of detailed technical presentations.- Created data visualizations using various visual objects (Line chart, Bar chart, Tree map, Single card, KPI, Map, Pie chart, custom visuals).- Experienced on writing complex queries, performance tuning and optimized SQL queries using D-SQL T-SQL, SQL Profiler in SQL Server 2012/2014/2016 and deployed code in cloud base environment like AWS.- Shared dashboards and reports with user groups by using Power BI App and content packs.- Involved in design and development of SSIS (ETL) packages.- Effectively used data blending feature in Tableau.- Prepared and published customized reports/dashboards.- Created Tableau scorecards, dashboards using Stack bars, bar graphs, scattered plots, geographical maps- Utilized Power Query to pivot and UN pivot the tables for data cleansing and data manipulation.- Created SSIS packages to load various Dimensions and Fact tables based on complex business requirements.- Understand and translate business needs into data models.- Established DAX while creating data models in Power BI.- Converted SQL Query code into DAX code for reports.- Utilized Slicers and Filters in Power BI Show less

- Gathered, analyzed and defined business rules used and produced requirement documents to define the scope of the various analytical reports - Collaborated with senior management, subject matter experts, and IT teams to define business requirements- Created SSIS packages to extract data from different sources from legacy systems for individual data set requirements.- Created User groups with required access privileges, hidden the database access information and data source and… Show more - Gathered, analyzed and defined business rules used and produced requirement documents to define the scope of the various analytical reports - Collaborated with senior management, subject matter experts, and IT teams to define business requirements- Created SSIS packages to extract data from different sources from legacy systems for individual data set requirements.- Created User groups with required access privileges, hidden the database access information and data source and datasets in SSRS. - Created Shared Data Source, Shared Dataset and reports using SSRS Business Intelligence Development Studio - Build the project, deploy to the report server and access the reports using web.- Designed and developed views for aggregating and drilling across the fact tables- Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server.- Always ensured to eliminate NULL and Blank values on the Dashboards/Reports for the best end user experience - Conducted complicated calculation to develop KPI reports/dashboards according to clients' requirement- Scheduled the Dashboard’s at regular intervals to make sure data refresh is up to date.- Designed and implemented the ETL processes using SSIS which involved collection of data from sources like SQL Server.- Involved in generating and maintaining SQL scripts.- Developing of business reports using SSRS.- Performance tuning of reports and dashboard’s using power analyzer from Interworks and there by taking extra steps to remove the unnecessary column, calculations and getting only required data for analysis- Perform unit testing on all datasets and dashboards to ensure proper implementation.- Created various reports such as drilldown, drill through, parameterized, cascading parameterized chart, and freeform reports with reporting services (SSRS). Show less

- Worked with project teams and business analysts to outline project requirements.- Created logical and physical design phases of the database utilizing Erwin as data modeler tool.- Participated in all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.- Created staging procedures to load and migrate data for report databases with multiple features.- Extracting data from source table by writing SQL query at dataset level.-… Show more - Worked with project teams and business analysts to outline project requirements.- Created logical and physical design phases of the database utilizing Erwin as data modeler tool.- Participated in all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.- Created staging procedures to load and migrate data for report databases with multiple features.- Extracting data from source table by writing SQL query at dataset level.- Extensively involved in Calculations at dataset level.- Deployment and Scheduling of reports (Subscription).- Taking care of project post the deployment to production.- Wrote SQL queries and stored procedures to generate data for reports from various sources.- Created custom Incident, Change, Problem, Request reports using Crystal Reports XI Software.- Delivered daily/weekly/monthly reports on time to the customers.- CRD Application, Crystal Reports, Opas v2 and v3.- Managing the CRD applications so that the automated reports are delivered on time.- Generated OPASV3 data Reports using Crystal Report XI Software.- Worked on CRD Application to Schedule, Create & Modify Packages in CRD (Crystal Report Distributor Enterprise Edition 7.1 Version).- Provided L1 support (On-Call). Handled Incidents, Work Orders and Requests.- Deployed Power BI gateway to keep dashboards and reports up-to-date with on premise Data Source’s.- Administered project related documents and scripts in Team Foundation Server (TFS). Show less