Vikram Agre Email & Phone Number

Bhandara, Mh, In

Mumbai, Maharashtra, India

Designed and implemented Data Integration and ETL processes utilizing SQL (DDL, DML), Talend.Implemented complex data integration jobs using Talend's components, including tMap, tSort, and tAggregate.Developed complex SQL queries to efficiently extract, transform, and load data using Talend components. (Data Quality, Data Mapping, Data Validation, Data Profiling).Created Test cases document to check Data integrity(Relation), Data completeness(Loading of data),Unit testing, Regression testing.Developed ingestion process from XL(Constituents) to Cloud, saving 10 hrs of manual ingestion efforts weekly. Automated processing of large data from Data vendors and improve real-time reporting for product layer views.Performed data analysis to troubleshoot issues, monitored ETL jobs using Autosys, TAC and resolved production problems, high system reliability, and assist in overall issue resolution for data warehousing processes.Automated data loading jobs with Autosys, improving efficiency by loading raw data from Excel into Unix directories and SQL databases. (Data Integration)Designed APIs for better access to AWS-Cloud tables data by increasing the data security to Production tables.Skilled in end-to-end ETL processes: extracting data from Hive then transforming with tMap and tFilter, and loading into target systems. Spearheaded on-premises to AWS cloud migration using Talend, optimizing ETL processes and resolving performance bottlenecks.

Pune, Maharashtra, India

Involved in maintenance and building user interfaces (UI/UX) for web applications using HTML, CSS, Javascript and React.js.Collaborated with development team to design UI/UX multiple dynamic component pages using JSX, DOM and Fundamentals +ES6.Executed shell scripting scripts in UNIX to add indexes to the production database.Implemented API using SWAGGER to streamline and automate API testing procedures. Investigated troubleshoot and resolved Production bugs with high priority incidents at the earliest against strict deadline.Executed manual, automated tests (QTEST) and impact analysis on dependent application changes to quantify the impact and provide actionable insights.Utilized SQL and Oracle for monthly data insertion tasks using the DataZap platform (TOAD).Streamlined data extraction and ingestion to Cloud, boosting productivity by 50%.Created automated data ingestion pipeline for manual ERM,Flat files, cutting ingestion time by 25%.Implemented Data Integration and a Data quality methodology for seamless source data ingestion.Performed data analysis required to troubleshoot data related issues and assist in the resolution of issues.Monitored ETL jobs using Autorep (Autosys) and resolved production issues for timely data delivery and high system reliability. (Data Warehousing).Performed data analysis to troubleshoot issues, monitored ETL jobs using Autosys, TAC and resolved production problems, high system reliability, and assist in overall issue resolution for data warehousing processes.Implemented REDUX for centralized state management, ensuring efficient data flow within the components.

Pune, Maharashtra, India

Investigated troubleshoot and resolved Production incidents at the earliest using Agile methodology.Conducted unit testing, integration testing to test the indexes of applications and React js components.Monitored ETL jobs in Autorep(Autosys) and troubleshoot production issues to ensure timely delivery of data related to batch jobs.Utilized SQL and Oracle for monthly data insertion tasks (DATAZAP) using TOAD.Utilized Unix shell scripting proficiency to develop a streamlined pipeline for loading diverse files into databases from Unix directories.

Nagpur Area, India

Monitored and Analyzed social media platforms for criminal activities for public safety concern for Vidhan sabha election 2019 Nagpur .Made tools using python to fetch meaningful data in short time to disseminate critical information to the public.Monitored various Social Media platforms for discussions,sentiments and public reactions related to the Ayodhya Verdict 2019.Tracking misinformation, rumors and potential threats on Social Media.

Nagpur, Maharashtra, India