Vikas K Email & Phone Number

Texas, United States

Data Mapping and Validation: Analyzed source and target data, validated Kafka data streams across multiple systems.Kafka Configuration and SSL Authentication: Configured mutual SSL authentication for Kafka connectivity within the Vertex network.Agile Development Collaboration: Contributed to Agile sprint cycles, organizing tasks and collaborating effectively.Data Processing and Warehousing: Developed requirements, performed data collection, cleansing, transformation, and loading for data warehousing.Metadata Management: Created MDM & RDM metadata dictionaries, ensuring standardized naming conventions across the enterprise.Model Management and Productivity: Used Erwin's Model Mart for efficient model management and design for productivity enhancement.Cloud Solutions Development: Designed, deployed, and managed Cloud solutions on Azure, utilizing various underlying technologies.ETL Development and Database Management: Developed ETL processes, managed databases, and optimized performance through SSAS, OLAP cubes, and SQL procedures.

Chicago, Illinois, United States

Data Modeling and Analysis: Created source-to-target data mappings, developed data models using Erwin, and resolved Data Governance issues for enterprise-wide data consistency.Agile Methodology Implementation: Utilized Agile methodologies within 2-week sprints to deliver project milestones.ETL Development and Redundancy Prevention: Streamlined ETL development by creating reusable transformations and mapplets, preventing redundancy in processes.Cloud Solutions Expertise: Worked extensively on AWS services (EC2, S3, RDS, Redshift, Glue, Lambda) for data integration, migration strategies, and architecture design.BI and Visualization: Built visualizations and dashboards using Power BI and Tableau, enabling effective data presentation.Big Data Technologies Utilization: Implemented solutions for data ingestion and processing utilizing various Big Data technologies such as Spark, Hive, HBase, Pig, and MapReduce.Database Development and Optimization: Developed, tuned, and troubleshooted databases like Snowflake, using SQL, PL/SQL, and normalization techniques for performance optimization.Data Transformation and Integration: Transformed, cleansed, and integrated data across platforms using tools like Informatica PowerCenter, Sqoop, and Python scripts, enhancing data analysis capabilities.

Nashville, Tennessee, United States

Data Analysis and Reporting: Conducted data analysis, generated ad hoc reports, metrics, charts, and graphs in Excel, and created PowerPoint content for presentations.ETL Implementation and Data Management: Implemented ETL techniques for data conversion, extraction, mapping, and loading processes across different applications, ensuring data integrity.Metadata Management and Database Development: Established naming standards for data attributes, created data dictionaries, and developed SQL procedures to build summary tables, maintaining consistency and efficiency in the database.Collaboration and BI Solutions: Collaborated with BI teams, performed data profiling, mined and transformed data, and provided solutions for data challenges while implementing OLAP and OLTP models.Tool Proficiency and Scripting: Proficiently utilized tools like Informatica, SSRS, Tableau, and Unix Shell scripting for data loading, reporting, performance tuning, and extraction from various sources into databases.

Columbus, Ohio Metropolitan Area

Key Metrics and Dashboard Creation: Defined, created, and monitored key indicators and metrics by building reports and dashboards for data-driven insights and decision-making.Data Integrity and Quality Evaluation: Collaborated with data management engineers to ensure data integrity, evaluating data quality across various sources, including handling inaccurate data.GIS Data Analysis and Reporting: Loaded monthly extracts into GIS, conducting detailed data analysis on policy metrics, claims, quotes, conversions, and geographical mapping, enabling in-depth insights.Visualization and Reporting Tools: Utilized IBM Cognos Analytics and Oracle SQL Developer to create and maintain reports, visualizations, and datasets, supporting competitor analysis and business strategy formulation.Business Insights Delivery: Generated and delivered maps, datasets, and reports to agents and different departments, facilitating better business decisions, enabling trend analysis, and providing market insights to retain and improve customer base.

Dublin, Ohio, United States

Requirement Gathering and Documentation: Gathered end-user requirements and created functional and technical design documents for reports, ensuring clarity in project objectives.Data Analysis and Management: Conducted conceptual analysis, managed spreadsheets, and maintained data accuracy, utilizing pivot tables and modifications to achieve analytical goals.Technical Expertise and Supervision: Developed technical specifications using Microsoft Visio, provided technical supervision to project team members, and presented prototypes for new client onboarding.Specialized Technical Skills: Demonstrated expertise in working with mainframes, databases, and applications, utilizing Spark-Streaming APIs and Scala scripts for real-time data transformations from Kafka to Cassandra while configuring and maintaining Kafka clusters.