Sreeram

Responsibilities:
• Interacted with the client as part of the Requirements Engineering team to finalize the project scope.
• Implemented Tableau for visualizations and views including scatter plots, box plots, heat maps, tree maps, donut charts, highlight tables, word clouds, reference lines, etc.
• Created Power BI reports from scratch, getting requirements, data modeling and reporting.
• Worked on Power BI reports with new visualizations and adding more data sets into the reports.
• Designed Data Stage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Developed and maintained Python scripts to automate deployment processes, configuration management, and infrastructure provisioning.
• Involved in Managing Data modeling project from Logical design and implementation of Sybase Database.
• Worked on Changing the visualization and look over of all the old reports so that all the Power BI reports look consistent throughout the company.
• Developed and maintained Python-based tools for log analysis, performance monitoring, and .
• Published and maintained workspaces in Power BI Service, allotted the time refresh for the data, maintained the apps and workbooks.
• Translate/map business productivity challenges into available IT toolsets and enforce site level Python user groups and assigned appropriate permissions with Central Admin server and application management tasks.
• Worked on DAX table functions including FILTER, ALL, VALUES, DISTINCT and RELATEDTABLE.
• Involved in developing reports and dashboards in Power BI.
• Utilized Python frameworks like Flask or Django to build RESTful APIs for integrating various systems and services.
• Worked on One Drive for storing different versions of Power BI report.
• Created different visualization (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer, Time Brush etc.) in Power BI according to the requirements.
• Implemented monitoring and alerting solutions using Python libraries such as Prometheus, Grafana, or ELK Stack.
• Worked as a Hadoop Developer / Administrator with big data stack design architecture research team to build a strong data repository by developing, installing and configuring Hadoop ecosystem components that moved data from individual servers to HDFS.
• Working with hive warehouse directory and hive tables and services.

Interacted with the client as part of the Requirements Engineering team to finalize the project scope.
Implemented Tableau for visualizations and views including scatter plots, box plots, heat maps, tree maps, donut charts, highlight tables, word clouds, reference lines, etc.
Created Power BI reports from scratch, getting requirements, data modeling and reporting.
Worked on Power BI reports with new visualizations and adding more data sets into the reports.
Designed Data Stage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
Developed and maintained Python scripts to automate deployment processes, configuration management, and infrastructure provisioning.
Involved in Managing Data modeling project from Logical design and implementation of Sybase Database.
Worked on Changing the visualization and look over of all the old reports so that all the Power BI reports look consistent throughout the company.
Developed and maintained Python-based tools for log analysis, performance monitoring, and .
Published and maintained workspaces in Power BI Service, allotted the time refresh for the data, maintained the apps and workbooks.
Translate/map business productivity challenges into available IT toolsets and enforce site level Python user groups and assigned appropriate permissions with Central Admin server and application management tasks.
Worked on DAX table functions including FILTER, ALL, VALUES, DISTINCT and RELATEDTABLE.
Involved in developing reports and dashboards in Power BI.
Utilized Python frameworks like Flask or Django to build RESTful APIs for integrating various systems and services.
Worked on One Drive for storing different versions of Power BI report.
Created different visualization (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer, Time Brush etc.) in Power BI according to the requirements.
Implemented monitoring and alerting solutions using Python libraries such as Prometheus, Grafana, or ELK Stack.
Worked as a Hadoop Developer / Administrator with big data stack design architecture research team to build a strong data repository by developing, installing and configuring Hadoop ecosystem components that moved data from individual servers to HDFS.
Working with hive warehouse directory and hive tables and services.
Worked on automating the schedule refresh of Power BI reports using gateways.
Worked on DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Power BI.
Created data warehouse and data marts from scratch based on data structures and reporting needs.
Worked on writing ad hoc SQL scripts which are required for reporting purposes.
Worked on creating basic dashboards in Power BI connected to Azure SQL database for client reporting.
Worked on Power BI dash boards and ad hoc DAX queries for power bi.
Extensive back-end support for many various reports on Power BI.
Worked on creating POC for data movement in NiFi (Horton works), C# programming used in script task for SSIS and in Azure functions to create retrievers for data pull from API.
Integrated Python scripts with CI/CD pipelines (e.g., Jenkins, GitLab CI/CD) to automate testing, building, and deploying applications.
Worked on Applications Migration and App Development in AZURE.
Worked on Web jobs, AZURE data factory, Logic Apps for application and project development in Azure.
Write Hive query for ad-hoc analysis report to analyze the customer feedback.
Involved in the execution of multiple business plans and projects Ensures business needs are being met Interpret data to identify trends to go across future data sets

Worked on Design and Gap Analysis, Business Requirements, Systems Requirements, Test Criteria, and Implementation to have the outputs of project dealt with the automation of correspondence directed to Clients.
Gathered Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
Worked with DBAs to design and implement Conceptual data model, Physical Data Model, SSIS mappings and workflows to meet business requirements.
Implemented Data Lake in Azure Blob Storage, Azure Data Lake, Azure Analytics, Data bricks Data load to Azure SQL Data warehouse using Poly base, Azure Data Factory
Designed and implemented effective Analytics solutions and models with Snowflake.
Involved in Data profiling, Data analysis, data mapping and Data architecture artifacts design.
Extensively created data pipelines in cloud using Azure Data Factory.
Leveraged Python libraries like boto3 to interact with cloud service providers' APIs (e.g., AWS, Azure, GCP) for infrastructure provisioning and management.
Worked with Azure Data Factory (ADF) since it’s a great SaaS solution to compose and orchestrate Azure data services.
Worked on python scripts to parse XML documents and load the data in database.
Designed, managed and supported Python Workflows and Info path Forms 2013 including Webparts, Out-of-the-box Workflows and Nintex Workflows 2013 and engaged in job shadowing to deliver feasible solution.
Worked on Erwin Data Modeler tool for relational database and dimensional data warehouse designs.
Designed data pipelines using Azure Data Factory, IBM Data Stage / Info sphere, Azure Copy, Poly base, Multi region data replication
Responsible for creating ETL mapping documents to define data flow from source system to target database.
Big data Architectural analysis and Hadoop eco system migration with vm.
Utilized Python-based configuration management tools like Ansible or Salt Stack to automate infrastructure configuration and software management.
Worked with Source system Subject Matter Expert SME to ensure that the extracts are properly mapped.
Writing the hive QL and manage hive meta store server to control different advanced activities.
Knowledge with LSR data aggregation changes from data center exa-data to Hadoop big data process
Created and maintained Python page for Lean Six Sigma using Power Queries for Plant Data and Audited the different projects in the company for Discrepancies.
Developed Extensive solutions within Python for better productivity using MS Power point, Access, Word, digital signature tools and OneNote Office apps.
Utilized Power BI to create various analytical dashboards that helps business users to get quick insight of the data.
Involving to manage logs and monitoring health check in hive meta store server
Created visualizations for logistics calculations and departmental spend analysis. Utilized sample data to create dashboard while ETL team were cleaning data from source systems, and was responsible for replacing the connection to Google Big-query later.
Implemented Tableau for visualizations and views including scatter plots, box plots, heat maps, tree maps, donut charts, highlight tables, word clouds, reference lines, etc.
Generated complex reports in Tableau using multiple functionalities including context filters, hierarchies, parameters, LOD Expressions, time intelligence, etc.
Worked on Built interacting and storytelling dashboards in Tableau workbooks using dashboard actions
Published Tableau workbook on Tableau Server and set report refresh
Created and maintained issue log where business users enter their feedback by working on dashboard in test environment. Implemented the feedback and incorporated the necessary changes.
Published the developed dashboards into production and ensured the data was up to date by scheduling extract refreshes, performed performance tuning of the dashboard and created tableau functional design document.
Participated in the retrospective meetings and next sprint planning meetings.
Involved in Onsite Offshore coordination to ensure the completeness of Deliverables.
Worked as a developer in developing relational database schema, creating complex Stored Procedures, triggers, tables, views and other SQL joins and statements for applications.

Designed and developed Scorecards and Dashboards using Power BI for various marketing organizational metrics and Key Performance Indicators (KPIs).
Gathered Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
Worked on the performance of Design to develop technical solutions from Analysis documents.
Possess and applied a broad knowledge of principles, practices and procedures of Marketing, Merchandizing subject area to the completion of various difficult assignments.
Proficient in Python programming language, utilizing it for automation, scripting, and infrastructure management tasks.
Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
Worked on business requirements into conceptual, logical data models and integration data models, model databases for integration applications in a highly available and performance configuration using ER/Studio.
Created Physical Data Model from the Logical Data Model using Compare and Merge Utility in ER/Studio and worked with the naming standards utility.
Performed GAP analysis with Teradata MDM and Drive SQL data models to get clear understanding of requirements.
Worked on understanding user requirements around technical data, interaction of data between systems and system dependencies.
Worked to ensure high levels of data consistency between systems.
Worked with ETL teams and used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories.
Developed and maintained data dictionary to create metadata reports for technical and business purpose.
Created action plans to track identified open issues and action items related to the project.
Designed complex risk reports, Score Cards, and Dash Boards using MicroStrategy.
Worked on exploring the dimensions such as Drill Down, Drill Up, Drill down and up on nested categories, filtering the data etc.
Designed filters, power prompts, and complex financial calculations for various analytical reports.
Arranged walkthrough sessions with the user group and QA teams to confirm that all the requirements have been captured and obtained sign off on the requirements documents.
Implemented security in reports according to employee groups and roles according to the requirement and Involved deployment process.