Bhargav Yannam
Jersey City,NJ
Summary
Dynamic data professional with over 8 years of experience in data warehousing, data quality, and data acquisition. Expertise includes design, data modeling, ad-hoc and critical report development, implementation, business analysis, project management, support, and visualization. Proven ability to deliver impactful solutions across diverse industries, including insurance, annuities, supply chain, and consumer goods. Skilled at transforming complex data into actionable insights to drive business success.
Overview
9
9
years of professional experience
Work History
Sr. Data Analyst
Chubb Insurance , ACE INA Holdings
Jersey City, NJ
12.2022 - Current
- Analyzed complex datasets to identify trends, enhancing decision-making processes across departments.
- Developed predictive models using advanced statistical techniques to support risk assessment initiatives.
- Collaborated with cross-functional teams to streamline reporting processes, improving data accessibility and accuracy.
- Mentored junior analysts, fostering skill development and promoting best practices in data analysis methodologies.
- Manage high volumes of data analysis activities, including interpreting data, assessing gaps, identifying trends, and delivering ongoing reporting to support business decision-making.
- Prepare, maintain, and enhance documentation related to data structures, processing flows, data models, and technical dependencies to ensure clarity, consistency, and governance.
- Develop data mapping and technical specifications for development teams, ensuring business requirements are accurately translated into actionable deliverables.
- Serve as a liaison between domain teams and data platform teams to capture issues, define requirements, and produce detailed technical specifications and design documentation.
- Create, prioritize, and maintain Jira backlogs in collaboration with domain and data platform stakeholders, aligning delivery plans with business value and strategic objectives.
- Support the development and implementation of data ingestion pipelines, ensuring source data models are accurately reflected in key deliverables and downstream outputs.
- Draft and refine user stories for technical team members, helping maintain a structured and efficient workflow across the team. Provide business information and analytical support to ensure key data objectives are clearly defined, effectively communicated, and supported by relevant stakeholders.
- Respond to data-related inquiries from both business and technical teams, while analyzing, documenting, and maintaining data lineage to support transparency and traceability.
- Identify, escalate, and help mitigate impediments in data and process flows that may affect sprint execution, release readiness, or achievement of team goals.
- Act as a Subject Matter Expert (SME) for data-related processes, providing guidance, insight, and decision support to cross-functional teams.
- Support team coordination and delivery by helping align priorities, remove blockers, and ensure work progresses smoothly across stakeholders and technical contributors.
- Contribute to continuous improvement efforts by recommending enhancements to data processes, documentation standards, and delivery practices.
Data Quality Analyst/I.T Analyst
Tata Consultancy Services North America
10.2021 - 12.2022
- Built complex SQL queries in Business Objects to audit Commission payments for the complete organization.
- Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookups, Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union to Python scripts.
- Created Analytical reports for the Finance and agent related data using Business Objects.
- Worked extensively on disparate data sources like Flat files, Spreadsheets, Database/Data warehouse objects, multiple data marts and API’s to consolidate the data into a common format model.
- Worked as a liaison between technical team and business team to understand and interpret data correctly.
- Standardized similar domain reports across multiple source systems.
- Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
- Collaborated between the IT department and Business users or End Consumers of the applications.
- Communicating the requirements to the Developers and report to key stake holders and senior management.
- Collaborated with different teams along with numerous client facing roles in order to establish Data Quality rules and maintain enterprise data standards.
- Worked extensively on relational databases including PostgreSQL, MySQL, Microsoft SQL server, IBM AS/400.
- Well versed with different tools of Microsoft Office suite of applications including Excel and PowerPoint.
- Analyzed and defined Data Quality rules to improve quality of enterprise data as well as traced quality issues and their root causes across different domains and performed Data Quality Control.
- Conducted Unit Testing and troubleshooting, collaborated with teams to integrate systems and reports.
- Aggregated multiple sources of data and generated Ad-hoc reports harvesting Insights for the Business users.
- Defined Business Objects Classes, Objects, in the Universe, defined Cardinalities, Contexts, Joins and Aliases and resolved loops in Universes using table aliases and contexts.
- Good Understanding of Insurance, Finance and Annuities Domain along with Producer, Party, commission payout and finance related reports.
- Analyzed Product/Contract requirements and define key deliverables along with Writing Test cases and performed UAT before every release which translated to minimal failure to none in Production.
- Solely responsible to maintain and update project related documents on confluence.
- TOOLS: Power Designer, Data Grip, PostgreSQL, Python 3.9, ServiceNow, Oracle SQL Assistant, Microsoft Office, Oracle 11g, SAP Information Data Steward, Informatica PowerCenter, Bitbucket, GitHub, SharePoint, Confluence, BMC Control-M, SAP Business Objects, PostgreSQL, MySQL, Microsoft SQL server, IBM AS/400, Amazon S3.
Business Intelligence/Data-Business Analyst/Data Modeling Associate
Denken Solutions Inc
Irvine, CA
08.2017 - 10.2021
- Collaborated with business teams, enterprise data architect and subject-matter experts to define strategy for data warehousing and business analytics, develop models, procedures, and protocols for reporting in concert with the requirements.
- Autonomously lead projects from start to finish, including Identifying Opportunities, Structuring Analyses, Gathering Data, Generating Insights, communicating recommendations, and Influencing Stakeholders for execution.
- Created PowerPoint presentations for the reports generated to high level executives across supply chain team.
- Supported rapid turnaround for ad-hoc analysis, developed SQL Scripts and use cases. Created key performance metrics/KPI’s on SQL queries and Tables.
- Good understanding and working experience of RDBMS.
- Responsible for Data Modeling and building a Star Schema model in ER Studio.
- Designed, built and deployed BI solutions that provide accessible information for Decision Making.
- Worked on multiple subject areas for Supply chain projects like Delivery, Sales, Orders, Customer, Material and Shipments. Created/ updated the common format designs.
- Ability to grasp new ideas quickly as well as training colleagues across teams.
- Established and maintained business/Master data related elements, requirements and data standards in EDW. Identified and proposed standard process for data model reviews and project plans.
- Facilitated transition of logical data models into the physical database design and recommended technical approaches for good data management practices.
- Created Source to Target(STM)/ Field Mapping Documents(FMD) and lineage mapping documents of different data sources which will be consumed by different layers of the Data Warehouse including Semantic layer access by the end uses from their reporting tools (Business Objects, Tableau, Micro Strategy, Crystal Reports).
- Developed and executed database queries and conducted analyses. Created visualization and reports to support business decision making and business performance monitoring.
- Enhanced and modified existing crystal reports by creating new formulas, parameters etc., well versed at using global and shared variables across crystal reports.
- Building and publishing customized interactive reports like frequency reports, Summary reports, drilldown and ad-hoc reports and dashboards using both Crystal reports and Tableau server. Creating User-Stories in tableau / scheduling reports directly to users using Crystal Management console and publishing them online.
- Generated Sub reports, Standard, Mailing labels, cross tab reports and graph reports by using chart expert of Crystal Reports.
- TOOLS: ER Studio Data Architect V16 /V18, Rapid SQL, Teradata 16.0, Amazon Web Services(Redshift, S3, Dynamo DB and EC2), Crystal Reports 8.5/9/10, Crystal Enterprise 8.5/9/10 , Teradata SQL Assistant, Microsoft Office, Alteryx 2019, Power BI Desktop, Tableau Desktop, Tableau Data Prep, Alation, Python and R (beginner), Azure DevOps, Trello, GitHub, SharePoint, Teams.
Education
M.S. - Engineering Management (Project Management and Analytics)
University of Houston Clear Lake
Houston, Texas05.2017
B.Tech - Electronics and Communication Engineering
Sree Vidyanikethan Engineering College
Tirupathi, India01-2014
Skills
- SQL programming
- Advanced Excel
- Data warehousing
- Business intelligence
Timeline
Sr. Data Analyst
Chubb Insurance , ACE INA Holdings
12.2022 - Current
Data Quality Analyst/I.T Analyst
Tata Consultancy Services North America
10.2021 - 12.2022
Business Intelligence/Data-Business Analyst/Data Modeling Associate
Denken Solutions Inc
08.2017 - 10.2021
B.Tech - Electronics and Communication Engineering
Sree Vidyanikethan Engineering College
M.S. - Engineering Management (Project Management and Analytics)
University of Houston Clear Lake