Kalyan Kumar
Data Vizualization Lead @American Family Insurance
Signup · Get unlimited contacts
WORK HISTORY
Data Vizualization Lead @American Family Insurance
EDUCATION
Texas A & M University - Commerce
Masters in Computer Science
SKILLS
ABOUT KALYAN KUMAR
Data Visualization Lead• Over 12 years of experience in Information technology with experience in complete life cycle of Software products involving Analysis, Design, Development, Implementation, Testing and support for various data warehousing applications including Power BI, Tableau, Business Objects, IBM Datastage & Informatica PowerCenter.• Experience in understanding Fact Tables, Dimension Tables, and Summary Tables.• Strong understanding of Data Warehouse concepts, OLAP, OLTP, Star and Snowflake Schemas, Data Modeling using Normalization techniques, Dimensional Data Modeling, Fact & Dimensions tables, slowly changing dimensions, Physical & Logical Data Modeling.• Experienced in building Dashboards through Power BI, Tableau, Dashboard Designer tool / XCelsius.• Hands on experience in Performance Tuning, Query Optimization• Strong Knowledge on Power BI to import data from various sources such as Oracle, SQL Server, MS Excel etc.• Developed analysis reports and visualization using DAX functions like table function, aggregation function and iteration functions in Power BI.• Working, Exploring & using Advance features in Tableau like Advance Table Calculations & Level of Detail Calculations(LOD’s).• Worked on features like Clustering, Custom Geo territory mapping and Cross Database Joins in Tableau.• Extensively worked on Cross-tab and Master detail reports and used reporting functionality like Breaks, Alerts, Filters, Sorts, Query Prompts and Drill filters and therefore used Calculation Contexts, Variable, Drill, Slice and Dice in making the reports easy for user analysis.• Experience with preparing functional Specifications, Low Level and High Level Design specification and Source to target mapping documents for the ETL programs/business processes.• Setup the Clustered Environment for the production.• Setup the Disaster Recovery Environment.• Experience with ETL process using Informatica Power Center 9.x/8.x/7.x, Power Exchange, Designer (Source Analyzer, Warehouse designer, Mapping designer, Metadata Manager, Mapplet Designer, Transformation Developer), Repository Manager, Repository Server, and Workflow Manager & Workflow Monitor.• Excellent experience in writing PL/SQL Stored Procedures, Functions, packages and Triggers using Oracle 11g/10g,SQL, PL/SQL, TOAD• Demonstrated success many times under aggressive project schedules and deadlines.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.