Shivaram kuppareddy

Business Engagement Lead/Data Analyst/Tableau Developer

AAA

Jun 2025 - Current (1 year 3 months)

• Involved in gathering requirements for Guideware Policy Center data in ACE Claims Business migration project. • Working on Data flow document / Project overview document for migration of reports from Business Objects to Tableau and Hadoop To AWS. • Experience in Leading the team in creating stories, assigning stories, adding sub tasks in Jira Board. • Gathering updates in the everyday standing up, doing analysis of problems, sharing questions with the client for any issues. • Experience in maintaining and tracking of reports through different environments ( DEV, UAT), assigning DEV, UAT dates by co-ordinating with Team. • Worked on updating new custom SQL for new sources , doing data analysis, mapping old and new source , validation

F

Power BI Developer

Fanniemae,

Jan 2024 - May 2025 (1 year 5 months)

• Experience in Reports from data dictionaries using reporting tools like Power BI. • Identify the requirements and develop custom charts accordingly. • Study, analyze and understand business requirements in context to business intelligence. • Design and map data models to shift raw data into meaningful insights. • Utilize Power BI to build interactive and visually appealing dashboards and reports. • Spot key performance indicators (KPI) with apt objectives. • Analyze previous and present data for better decision making. • Transform business requirements into technical publications and understanding cross filtering behavior (single vs both direction), context transition, and filter propagation. • Involving in Retro, Adding points t

F

Data Modeler//Cloud Data Architect

FannieMae

Jan 2024 - May 2025 (1 year 5 months)

• Involved in JAD sessions with the Business Analyst/SME and other management team in the finalization of the Public Sector Business Requirements • Develop Database design, Architecture, creation, optimization, deriving conversion and migration methods for existing data and developing automated conversion and migration methods. • Experience in working in Agile Process by providing daily updates on multiple projects. • Develop, enhance, and integrate Database, Data Marts, and BI Solutions. • Providing Data Governance, Data Migration, designing the modeling in Different Databases. • Providing Insight into the changing database storage and utilization requirements for the company and offering suggestions for solutions. • Created and mai

Power BI/Tableau Developer/SSRS

Ameriprise Financial

Dec 2013 - Nov 2023 (10 years)

copy clone, time travel and understanding how to use these features. • Develop strong data documentation about algorithms, parameters, models.

A

Cloud Data Architect/Data Modeler Business Analyst

Ameriprise Financial Inc

Dec 2013 - Nov 2023 (10 years)

• Involved in the preparation business use case for Data Warehousing projects after liaising with stakeholders. • Involved in project planning, coordination and project execution tasks. • Daily and Weekly status reports shared to clients and higher management. • Peer Review of the scripts and made recommendations for updates if any. • Prepared project metrics on sprint compliance and velocity and shared to higher management and client. • Collecting several metrics and coming up with corrective measures to be presented to senior management. • Participated in User Acceptance testing (UAT) review and involved in UA test cases review. • Extensively interacted with Developers, to make them understand RLBI project business requirements an

Data Architect/Data Modeler

Capital One

Apr 2013 - Nov 2013 (8 months)

• Involved in JAD sessions with the Business Analyst and other management team in the finalization of the Business Requirements • Experience in designing the LDM and PDM models using Data Modeling Tools like Erwin • Experience in identifying entities required for Conceptual Data Model and designing Logical and Physical Model for the Credit Card, Mortgage, Accounts section. • Creating and maintaining Logical Data Model (LDM) and Physical Model ( PDM) for the OLTP and OLAP projects which includes documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc. • Experience in the Creating tables, triggers, sequence and synonyms by forward Engine

D

Data Modeler

Delta Airlines, Inc,

Feb 2012 - Jan 2013 (1 year)

• Involved in JAD sessions with the Business Analyst and Application Team in gathering Business Requirements. • Experience in designing the LDM and PDM models in Data Modeling Tools like Visio, Erwin etc. • Experience in designing Logical and Physical Model for OLTP and OLAP projects like REA (Regional Elite), TIPS, Technician Self Assessment, Threshold Manager, Campaign Model, RAIDER Implement New Overbooking Model, VSOW (Vendor Scope of work) Application, FABTR (Fare Base Award Ticket Redemption) Project, RBMA Application. • Experience in Normalizing the Data and Developing the Relational database for the different Subject areas (Flight, Maintenance, Finance, Information Technology, Inventory, Tickets, Pricing, Employee, Customer, Sal

C

Data modeler

Comerica Bank,

Jun 2011 - Jan 2012 (8 months)

• Involved in JAD sessions with the Business Analyst and other management team in the finalization of the Business Requirements • Experience in designing the LDM and PDM models in Data Modeling Tools like Visio, Power Designer etc. • Involved in creating high performance Data marts in Data warehouse which consists of high volumes of CRM, Loans, Customers and his financial account data, Sales Data, ERM, and Customer Credit Card Data. • Experience in Unstructured Data and Hierarchical modeling in the Data warehouse. • Knowledge in assisting in the design of the services that will send data across the Enterprise Data in support of Application. • Experience in identifying entities, attributes and understanding the relationships between th

E

Relational Data modeler

Express-Scripts Inc,

Jul 2010 - Oct 2010 (4 months)

E

Modeler/Data Architect

Express Scripts,

Jun 2010 - Aug 2010 (3 months)

• Involved in JAD sessions with the Business Analyst and other management team in the finalization of the Business Requirements • Experience in designing the LDM and PDM models in Data Modeling Tools like Visio, Power Designer etc. • Knowledge of IBM Unified Data Model for Healthcare (UDMH) and FHIR (Fast Healthcare Interoperability Resources) and HL7 standards. • Experience in identifying entities required for Conceptual Data Model and designing Logical and Physical Model for the Humira, Event Management, Multiprogram and Hepc Projects in Rxspecialty. • Experience in claims/payer, provider, pharmacy, clinical services, transactional etc data. • Creating and maintaining Logical Data Model (LDM) and Physical Model ( PDM) for the OLTP a

Shivaram kuppareddy

About

Detail

Timeline

Résumé