Ranjit Pesala
Senior Technical Analyst II
- Role
- Senior Technical Analyst Ii at Great American Insurance Group
- Location
- Cincinnati, OH, US
- LinkedIn followers
- 500 followers
About Ranjit Pesala
Over 9+ years of experience in Data Warehousing and Business Intelligence area in Property & Casualty, Healthcare Pharmacy DomainsArchitecture,designing,modeling, and managing high performance IT solutions and manipulating data into information warehouses, reporting databases, and operational data stores. Highly skilled in evaluating, prototyping, designing and implementing solutions using modern data-management technologies in the Big Data ecosystemStrong experience in building Data products and data pipelines for analytical and reporting requirementsSkilled at ETL Architecture/Design, data acquisition and integration life cycle, requirements gathering and analysis, feasibility study and recommendation, creation and implementation of various data quality measurements within ETL processes and deploying Data warehouse applications with life cycle implementation.Working knowledge of SQL and PL/SQL Programming,Proven ability to learn and implement latest technologies for data processingWorking knowledge of MPP and Distributed Data Management and Processing Platforms (Netezza, Teradata) and NoSQL MarklogicExperience with data integration with cloud-based database/SaaS such as Amazon Redshift and Salesforce.Involved in Full Life Cycle Development of Reporting Projects, which included requirements gathering/analysis, design, development, testing and production roll-outs.Specialties: Business Requirement AnalysisSource System Data Analysis and Source To Target Mapping (STM) ETL Design/BI Data warehouse ArchitectingConceptual,Logical and Physical Data ModelingDatabase - Teradata,Sql Server,Oracle,SQL Server, Marklogic,AWS RedshiftETL TOOLS : Informatica,SSIS,DatstageModeling Tool - Power Designer,ERwinData Visualization Tools : crystal reports,Cognos,Qlikview,TableauProgramming Languages: Python, CScripting : unixSVN : Tortoise SVN,GIT hubScheduling : Tidal, Uc4 automic
Experience
Senior Technical Analyst Ii
Great American Insurance Group
Mar 2025 — Present · Cincinnati, OH, US
Education
University of Colorado Denver
Masters
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.