Kalyan S. Email & Phone Number

United States

San Diego, California, United States

• Cleansed, extracted, and analyzed business data daily and prepared ad-hoc analytical reports using Excel and T-SQL• Participated in cross-functional internal and external training programs covering leadership, ethics & professionalism, retirement benefits, property & casualty insurance, taxation, financial reporting, client management, and international actuarial developments• Perform annual and quarterly Vendor Management due diligence reviews and risk assessments on potential new relationships.• Involved in data modeling to define the table structure (Domain and Reference Masters) in the MDM system.• Building, and publishing customized interactive reports and dashboards, report scheduling using Tableau server.• Worked on all data management activities on the project data sources and data migration.

New York City Metropolitan Area

• Used Pandas as API to put the data as time series and tabular format for manipulation and retrieval of data.• Helped with the migration from the old server to the Jira database (Matching Fields) with Python scripts for transferring and verifying the information.• Analyze Format data using a Machine Learning algorithm by Python Scikit-Learn. • Experience in python, Jupyter, Scientific computing stack (numpy, scipy, pandasand matplotlib). • Perform troubleshooting, fixed and deployed many Python bug fixes of the two main applications that were a main source of data for both customers and the internal customer service team. • Write Python scripts to parse JSON documents and load the data into a database. • Generating various capacity planning reports (graphical) using Python packages like Numpy and Matplotlib. • Analyzing various logs that are been generating and predicting/forecasting the next occurrence of an event with various Python libraries. • Created Autosys batch processes to fully automate the model to pick the latest as well as the best bond that fits best for that market. • Created a framework using Plotly, dash, and Flask for visualizing the trends and understanding patterns for each market using the history data.

Houston, Texas, United States

• Involved in requirement gathering and data analysis and Interacted with Business users to understand the reporting requirements, and analyze BI needs for user community.• Involved in logical and physical designs and transforming logical models into physical implementations.• Normalized the data up to 3rd Normal form. Created Entity/Relationship Diagrams, grouped and created the tables, validated the data and identified PKs for lookup tables.• Involved in modeling (Star Schema methodologies) in building and designing the logical data model into Dimensional Models.• Documented the source to target mappings for both data integration as well as web services• Experience working with the MDM team with various business operations involved in the organization. Worked on different data models for Claims, Members, and Providers for different claim types, for different Health Partner Incentive programs.• Formulated the ER diagrams of Property and Casualty data and data flow diagrams to interact with database developers.• Utilized Erwin's forward/reverse engineering tools and target database schema conversion process.• Designed the data marts in dimensional data modeling using star and snowflake schemas. Redefined attributes and relationships in the reverse-engineered model and cleansed unwanted tables/columns as part of data analysis responsibilities.• Involved in collaborating with ETL/Informatica teams to source data, and perform data analysis to identify gaps.• Developed ETL routines using SSIS packages, to plan an effective package development process, and design the control flow within the packages.• Presented the Dashboard to Business users and cross-functional teams, defined KPIs (Key Performance Indicators), and identified data sources.• Examined key Performance Indicators KPI for Property and Casualty such as Loss Ratio and general Operating Expense Ratio.

Hyderabad, Telangana, India

• Data Analysis, logical and physical. Data Modeling for OLAP systems.• ER Modeling - Developing Entity Relationship Diagrams (ERD).• Normalizing the tables/relationships to arrive at effective Relational Schemas.• Identifying the facts & dimensions; grain of fact, aggregate tables for Dimensional Models.• Developing Snowflake Schemes by normalizing the dimension tables as appropriate.• Implementation of Business Rules in the Database using Constraints and triggers.• Dimensional Data Modeling to deliver Multi-Dimensional STAR schemas.• Requirements & Business Process Analysis; Rapid Audit of the requirements and existing systems.• Design & Implementation of Data Mart; DBA coordination; DDL & DML Generation & usage.• Metadata & Data Dictionary Management; Data Profiling; Data Mapping.• Normalization techniques to arrive at effective Relational Schemas.• Performed data quality in Talend Open Studio Conducted design reviews and validated data models and was involved in MDM (Master Data Management).• Analyzed, verified, and modified UNIX and Python scripts to improve data quality and performance.• Used Python script to generate the data and load them to hdfs and create the tables in hive Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.• Applied Data Governance rules (primary qualifier, Class words, and valid abbreviation in Table name and Column names).• Worked with statisticians in analyzing the credit risk and modeling on the Basel Parameter Model (PD, LGD, EAD).