Sweta Kumari

• Drove innovation within the organization by encouraging creative problem-solving techniques among employees.
• Company venture in this business consists of multiple Business Tableau/BI Dashboards with Azure Data ,SQL using power bi Desktop. It Primarily involves the database storage, analysis the data using JDE Data, Visualization of data using power bi dashboard.

Key Responsibilities:

Created dashboard in Power BI using DAX and identify KPI's to provide business insights.

• Created automation dashboard in tableau using tableau prep and saved 50 hr of manual effort.
• Done the automation of existing process which create a PDF file of a dashboard from server in NDM path folder using python script.
• Wrote sql queries to achieve the logics as per requirements.

• Reviewing and functional testing of all BI reports before handover to the client.

• Performed the Automation in Existing all BI dashboard

• Prepared Analytical test Documents and Functional Specifications (FS) document as per business requirements.

Tech Stack: Tableau, Power BI Desktop,SQL,Tableau prep,Pandas

• Company venture in this business consists of multiple Power BI Dashboard reports and Azure data bricks notebook.
• It Primarily involves the database storage, analysis the data using snowflakes, Visualization of data using power bi dashboard and monitoring and scheduling jobs for different applications
• Client: OTIES, Inc
• (USA) Key Responsibilities:
• Created dashboard in Power BI using DAX and identify KPI's to provide business insights
• Migrated the Azure data bricks scripts in snowflakes.
• Reviewing and functional testing of all BI reports before publishing on Power BI report server and analytics portal
• Created the measures and expressions in tabular model for new reporting demand, data integration and analytical needs as per business requirements
• Prepared the Functional Specifications (FS) document as per business requirements
• Involved in design and development of tabular cube and dashboard visualization
• Developed Control -M jobs for scheduling & monitoring jobs from different application
• Tech Stack: MS SQL Server, SQL, Snowflakes, Azure data Bricks and power bi

• Company venture in this business consists of multiple tabular models and Power BI Dashboard reports with SSAS scripts store procedure and control -M job scheduling
• It Primarily involves the database storage, analysis the data using SAS Tabular cube, Visualization of data using power bi dashboard and monitoring and scheduling jobs for different applications
• Client: Anthem, Inc
• (USA) Key Responsibilities:
• Created dashboard in Power BI using DAX and identify KPI's to provide business insights
• Reviewing and functional testing of all BI reports before publishing on Power BI report server and analytics portal
• Created the measures and expressions in tabular model for new reporting demand, data integration and analytical needs as per business requirements
• Prepared the Functional Specifications (FS) document as per business requirements
• Involved in design and development of tabular cube and dashboard visualization
• Developed Control -M jobs for scheduling & monitoring jobs from different application
• Tech Stack: MS SQL Server, SQL, SAS Tabular cube Power BI, SSMS, SSDT, Control-M

• Company venture in this business consists of multiple modules/SSIS applications, SSRS reports with python scripts, Store Procedure and packages SQL Server, U-SQL, T-SQL technologies
• It primarily involves the maintenance and support of the following applications: SSIS ETL applications, SSRS reports and migrated data using python script
• Client: Altria(USA) Key Responsibilities:
• Created reports in Power BI using DAX and identify KPI's to provide business insights
• Reviewing and functional testing of all BI reports before publishing on Power BI report server and analytics portal
• Outline the functional specifications of the applications for new reporting demand, data integration and analytical needs as per business requirements
• Tech Stack: MS SQL Server, SQL, T-SQL, U-SQL, SSIS, SSRS, Python, Power BI, SSMS, SSDT

• Company Ventures in the business of Mobile application development, website development, Open source customization, custom software development and Graphics designing
• Key Responsibilities:
• Has contributed in preparing technical requirements and design document
• Testing, debugging and correcting errors and faults in an applications programming language within established testing protocols, guidelines and quality standards to ensure programs and applications Perform to specification
• Has contributed in developing utility software using JAVA and PL/SQL technologies
• Has contributed in designing and enhancing software applications based on customer requirement
• Tech Stack: Unix, J2EE, MS SQL Server, PL-SQL, JDK 1.7, Eclipse, Apache Tomcat