Karthik E Email & Phone Number

Johnston, Rhode Island, United States

- Collaborated with business users to gather requirements and analyze data needs for reporting.- Designed logical and physical data models, including Entity/Relationship Diagrams and Dimensional Models.- Documented source-to-target mappings for data integration and web services.- Worked with Master Data Management (MDM) teams on various business operations.- Designed data models for Claims, Members, Providers, and Property & Casualty data.- Utilized Erwin for forward/reverse engineering and schema conversion.- Developed ETL routines using SSIS packages and designed data flows.- Presented dashboards to business users and defined Key Performance Indicators (KPIs).- Implemented and updated data governance procedures and standards.- Conducted data profiling and provided insights to business users.- Designed and developed IDQ solutions for MDM projects.- Created and maintained logical and dimensional data models.- Optimized SSIS performance and implemented custom Slowly Changing Dimensions (SCDs).- Cleansed, extracted, and analyzed business data using Excel and T-SQL.- Participated in cross-functional training programs covering various topics.- Conducted Vendor Management due diligence reviews and risk assessments.- Built interactive reports and dashboards using Tableau.- Managed data migration activities and created DDL/DML scripts.- Performed query tuning and index maintenance for performance improvement.- Collaborated with production support and testing teams and provided support documentation.

Tampa, Florida, United States

- Designed, developed, and implemented data solutions, including architecture design and prototyping.- Studied in-house requirements for the data warehouse and performed logical and physical data modelling.- Normalized tables/relationships and identified facts & dimensions for Dimensional Models.- Collaborated with data compliance and governance teams to maintain data models and dictionaries.- Participated in technical and data analyst meetings to provide updates on data governance.- Conducted rapid audits of requirements and existing systems, and performed business process analysis.- Collected and analyzed product information and shopping history data for sales planning.- Produced quarterly attribution analysis reports for senior management using Excel and PowerPivot.- Generated periodic reports and dashboards using SQL Server Reporting Services (SSRS) and Tableau.- Designed and implemented ETL jobs for extracting, transforming, and loading data into Data Marts.- Utilized Informatica for ETL processing in a complex Enterprise Data Warehouse (EDW).- Conducted data profiling and collected data demographics from source systems.- Developed and implemented Data Warehouse and MDM hub conceptual, logical, and physical data models.- Converted models from CA ERwin to ER/Studio and developed macros for automation.- Extracted data from various RDBMS using SAS/ACCESS and SAS/SQL.- Used Python for data extraction, transformation, and loading tasks, and automation.- Created DataStage Server jobs for loading data from various sources.- Designed workflows, activity hierarchies, and process flows, and documented using UML diagrams.- Assisted developers in performance tuning and discussed high-level application design patterns.

Glen Allen, Virginia, United States

- Conducted JAD sessions, documented meeting minutes, and gathered requirements from business users.- Analyzed requirements and designed Data marts using Star Schema methodology.- Designed Context Flow Diagrams, Structure Chart, and ER-diagrams.- Developed and tested solutions in the Oracle environment, using ERwin 4.0 and Power Designer for data modeling.- Created tables, views, procedures, and SQL scripts following organizational standards.- Analyzed trends, forecasting, and KPIs affecting consumer awareness and product management.- Implemented BI reporting solutions using Denodo, including advanced excel functions and dashboards in power pivot.- Optimized performance of complex views in Denodo and monitored Denodo components.- Facilitated business requirements gathering sessions and oversaw the creation of Use Cases/Activity Diagrams and Functional Specifications.- Documented business metadata definitions and integrated high-level business rules with the code.- Developed SSIS packages for ETL processes and automated them using VBScripts and windows scheduler.- Maintained documentation for all responsibilities and supported a portfolio of development projects.- Conducted design reviews, validated data models, and implemented metadata standards, data governance, and master data management.- Applied organizational best practices to ensure accurate, timely, and consistent data structures.- Conducted peer reviews of completed data models to ensure quality and integrity.

Newton, Massachusetts, United States

- Analyzed business requirements and translated them into logical and physical data models, using tools like Erwin.- Managed Teradata database activities such as performance tuning, query optimization, and space management.- Conducted gap analysis between data models and collaborated with Teradata MDM.- Implemented data governance frameworks and maintained version control standards.- Developed complex mappings and transformations for ETL processes using Informatica PowerCenter.- Collaborated with business analysts to design reports using Cognos and performed data validation using PL/SQL scripts.- Implemented Informatica MDM processes for loading and managing customer/product data.- Configured MDM systems including data models, hierarchy, business rules, and workflows.- Utilized Denodo for data virtualization and integration with Tableau for reporting purposes.- Built transformation rules engine and documented designs for process understanding and change management.- Conducted thorough verification and validation of design specifications through review walkthroughs with stakeholders.

India

- Conducted data analysis and developed logical and physical data models for OLAP systems.- Designed Entity Relationship Diagrams (ERD) and normalized tables to create effective Relational Schemas.- Identified facts & dimensions and developed Dimensional Models, including Snowflake Schemas.- Implemented Business Rules using database constraints and triggers.- Conducted Requirements & Business Process Analysis and audited existing systems.- Designed and implemented Data Marts, coordinated with DBAs, and generated DDL & DML.- Managed Metadata & Data Dictionary, performed Data Profiling, and Data Mapping.- Ensured data quality using Talend Open Studio and validated data models for Master Data Management (MDM).- Analyzed and optimized UNIX and Python scripts to improve data quality and performance.- Utilized Python scripts to generate and load data to HDFS and create tables in Hive.- Created dashboards and worksheets in Tableau and applied Data Governance rules.- Collaborated with statisticians on credit risk analysis and Basel Parameter Modeling.- Developed data collection systems to optimize statistical efficiency and data quality.- Captured data lineage and definitions in data models and imported and cleansed data from various sources.- Performed Data Massaging and Analysis using R, and automated processes in R environment.- Transformed datasets using SAS Proc and SQL for complex ETL requirements.- Conducted machine learning-based predictive modeling for business decision-making.- Used machine learning algorithms to identify optimal predictors for broker-dealers.- Designed and implemented ETL processes using Oracle Warehousing Builder, SQL, and PL/SQL.- Conducted performance tuning for databases, SQL, and ETL processes.- Documented SQL statements and designed data flows and system interfaces.

India

- Collaborated with business units to develop Business Requirement Documents (BRDs) and acted as the main liaison between business managers and the IT division throughout the Software Development Life Cycle (SDLC).- Led requirement gathering sessions such as JAD sessions, interviews, and surveys, and conducted various analyses including feasibility and impact assessments.- Developed Fast Load and Fast Export scripts to manage data loading and extraction in Teradata.- Utilized Talend ETL tool for moving data from Data Warehouse to Data Marts and loading data from files to staging tables.- Assisted Actuaries in query development and Excel spreadsheet design to streamline calculations and reduce manual work.- Leveraged Teradata's capabilities to analyze large datasets and solve complex business problems.- Applied advanced Teradata techniques like OLAP functions (CSUM, MAVG, MSUM, MDIFF) for data analysis.- Familiarized with various Teradata table types for handling larger Adhoc SQL requests.- Contributed to documenting the data governance framework and processes for ensuring data accuracy and validity.- Developed physical data models and created DDL scripts for database schema and objects.- Prepared user requirement documents based on functional specifications.- Designed and implemented database objects including tables, stored procedures, triggers, views, and functions.- Created SSIS Packages utilizing transformations for data loading and processing.- Wrote SQL scripts for query tuning and optimization.- Extracted and transformed data from various sources like flat files and Excel before loading them into the Data Warehouse.- Scheduled batch processing jobs using SSIS packages.- Conducted performance tuning to optimize SQL queries and maintained indexes for efficient reporting processes.- Collaborated with design teams to develop mappings using SQL Server Integration Services (SSIS) based on Design Specifications Document (DLD).

Master Of Science - Ms, Computer Science, 3.6

Bachelor'S Degree, Computer Science