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.
• 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.

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.

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.