syamala devireddy

Created the conceptual model for the data warehouse using Erwin data modeling tool. Part of team conducting logical data analysis and data modeling JAD sessions, communicated data-related standards implementing Data modeling, Erwin, Dimensional Modeling, Ralph Kimball Approach, Star/Snowflake Modeling, Data marts, OLAP, FACT & Dimensions tables, Physical & Logical data modeling and Oracle Design

Created the conceptual model for the data warehouse using Erwin data modeling tool.
Part of team conducting logical data analysis and data modeling JAD sessions.
Communicated data-related standards implementing Data modeling, Erwin, Dimensional Modeling, Ralph Kimball Approach, Star/Snowflake Modeling, Data marts, OLAP, FACT & Dimensions tables, Physical & Logical data modeling and Oracle Design.
Created Use-Cases and business Use-Case Model after accessing the status and scope of the project and understanding the business processes.
Designed Data Flow Diagrams (DFD's), Entity Relationship Diagrams (ERD's), and web page mock-ups using modeling tools.
Performed the Integration and System testing on the ETL jobs.
Utilized Agile/ SCRUM PMI methodologies to monitor, steer develop project objectives.
Conceptualized primary process flow diagrams using Microsoft Visio Case Wise tool sets.
Documented functional specifications for multiple components for achieving the ability to send and receive currency or cash via various Electronic Funds Transfer System.
Automated monthly financial reports using Tableau, reducing report generation time, and providing senior management with timely insights to support strategic decision-making.
Reinforced development implementing of databases (ETL) in SSIS of a company to optimize efficiency of system and operations by 8% along with identification of KPIs.
Involved in the entire data science project life cycle and actively involved in all the phases including data cleaning, data extraction and data visualization with large data sets of structured and unstructured data, created ER diagrams and schema.
Leveraged cloud-based data solutions using Microsoft Azure Data Platform to enhance data storage, processing, and analytics capabilities.
Established cross-functional teams involved in risk management, fostering collaboration and knowledge sharing among departments such as credit risk, finance, accounting, and regulatory compliance.
Managed business stakeholders including dashboard/report requirement gathering, recommending options, and presenting end analytics and insights to executives.
Collaborated with Digital Marketing team to discuss the results of customer insights and performance metrics.
Structured the complex receivables for the customers by reconciling developing Mobile Collection, Automated Direct Debit and integrating the reports with Online Systems and Clients ERPs for banking sector.
Developed various solution driven views and dashboards by developing different chart types including Pie Charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, Scatter Plots in Power BI.
Created dashboard for Transportation system financial information which includes revenue and expenditure by routes.
Specialized in transforming data into user-friendly visualization to give business users a complete view of their business using Power BI.
Used various sources to pull data into Power BI such as Azure SQL Server and Oracle.
Involved in installation of Power BI Report Server.
Developed and published reports and dashboards using Power BI and written effective DAX formulas.
Worked on Snowflake for writing SQL queries to design a star schema.
Created Power BI Reports using the Tabular SSAS models as source data in Power BI desktop and publish reports to service.
Designed different types of KPI's for percentage growth in different fields and compared over a period and designed aggregations and pre-calculations in SSAS.
Over 5 years of hands-on experience in cross-functional data teams, specializing in data modeling, data warehousing and database design.
Extensive experience of 5+ years in Python and other programming languages for application development, package management, dependency handling, and deployment.
Developed robust and scalable data solutions using Python, ensuring efficient data processing and analysis.
Strong command over SQL for ETL (Extract, Transform, Load), DBT (Data Build Tool), and data analysis.
Analyzed large datasets including electronic health records (EHRs), claims data, and operational data to extract actionable insights and inform strategic decision-making.
Developed and maintained data pipelines for extracting, transforming, and loading (ETL) healthcare data from disparate sources into reports.
Collaborated with cross-functional teams including clinicians, administrators, and IT professionals to define data requirements and ensure alignment with business objectives.
Ensured compliance with regulatory requirements such as HIPAA by implementing data security measures and privacy protocols.

Implemented Supply chain financial Budget Supply chain analytics application for a retail store client.
Tackled highly unorganized dataset using under sampling, oversampling with SMOTE and cost sensitive algorithms with Python Scikit-learn.
Focused on the collection, integration, and analysis of data from different sources to support decision making.
Explored and transformed data in the form of reports and visualizations to business users.
Performed data manipulation, data preparation, normalization, and predictive modelling.
Improved efficiency and accuracy by evaluating models in Python and R.
Used Python and R for programming for improvement of model.
Upgraded the entire models for improvement of the product.
Wrote complex SQL queries for validating the data against different kinds of reports generated by Cognos.
Worked with Data Architects on Dimensional Model with both Star and Snowflake Schemas utilized.
Created ETL solution using Informatica tool to read Product & Order data from files on shared network into SQL Server database.
Created Database designs through data-mapping using ER diagrams and normalization up to the 3rd normal form and extracted relevant data whenever required using joins in Postgre SQL and Microsoft SQL Server.
Conducted data preparation and outlier detection using Python.
Taken the Business Requirement from the supply chain stakeholders and created reports in accordance.
Worked with SQL to massage the data in order to get accuracy in the Power BI reports.
Updated the SQL Tables for reporting purposes.
Massaged records at source level either Flat Files (Excel, CSV, SharePoint, Access, etc.).
Connected Power BI with different sources and did the Data Modelling in Power BI mainly using SQL, SharePoint, Excel, and CSV files.
Used Import query version in Power BI to extract, load, and transform data in Power Query Editor / Report View to create reports.
Configured Personal gateways to schedule reports.
Utilized Power BI embedded for non-Power BI users to interact with reports in the custom application.
Set up parameters to limit the locations in the report.
Used DAX expressions to create measures and calculated columns.
Used DAX and Branch Method to created the n number of top levels in the visuals for result.
Created Row Level Security using the branch method of Path and Path Contain Function in the calculated column and managing the role using DAX.
Applied DAX to various types of reports including Time Intelligence, Cost and Benefit analysis.
Created the Running Total for the Monthly Billing.
Applied DAX creating different measures and calculated columns.
Created Call summary reports on Power BI with the implementation of Data Analysis Expressions and worked deep with the M-Language to fix bugs and issues in Power Query editor.
Worked on extracting the data into the database and automating the reports on the SharePoint Page to have scheduled updates.
Used Power BI, Power Pivot to develop Data Analysis prototype and used Power View and Power Map to visualize reports.
Presented reports at different platforms such as SharePoint, web or incorporating any platform independent designed page.
Set the timer job in the Auto Schedule Report in Power BI cloud app.powerbi.com.
Provided support on SharePoint to create the site, list, libraries, permissions and to set up an audience to get to the SharePoint Page.
Applied data modelling techniques including UML, Data Flow Diagram, and Flowchart techniques to analyze and improvise already created SharePoint solutions.