Python, AWS, AirflowResponsibilities -Created python Scripts for connecting different sources to S3 bucketCreated Scripts for converting files from Data frame to CSVCreate scripts for connecting (S3) to SnowflakeCreated pipelines using Airflow DAGsWriting Stored procedures for joining tables in snowflakeFinancial News Classification- CIBC CanadaCreated Python process for web crawling for a UK bank while extracting daily news for its' counter-parties Post extraction classified news items into High/Low/No impact and displayed in webpage This helped in getting any early warning to the bank for all of its counterpartiesSkills – Python, SQL, Machine learning, NLPAnalyzing various business risk elements in Data Analytics role across BFSI domainCreating POC’s/POV’Implementing automation of manual tasks through Machine Learning / NLP in client environmentsIdentifying news areas of business where Machine Learning can be implemented like News AnalyticsAnalyzing datasets to extract hidden and meaningful information from the data and build predictive analytics modelsScheduling meetings for project estimations, client delivery, issue tracking, RTM review, project dashboard etcFollowed Agile methodology to reduce TAT while interacting with other applications for improving deliverable qualitiesSetting up Jobs using Apache AirflowCredit Worthiness Check- CIBC CanadaBased on Demographic and Credit Bureau datasets available for Customers checked the credit worthiness of a customer and created an application scoreboard to get the cut-off Achieved an accuracy of 75%Skills – Machine Learning, SQL, UnixSetting up Jobs using UnixData Migration from Sybase to Oracle- CIBC CanadaNov 2015- Oct2018Data migration involves migration from Sybase to oracle Sybase is a outdated database hence need to be migrated to a recent database (Oracle)Skills – SQL, UnixResponsibilitiesStudying the BRD, SRS and STM Understanding the requirementAnalyzing customer requirements and functional areas of the existing system and preparing Test Scenarios/CasesUnderstanding ETL architecture, Data flow and integration logics involved in EDW & Data MartUnderstanding Informatica Maps, Workflows/SQLscripts involved in ETL layerPreparing Test plan, Traceability matrix, Test case Design Document using requirement documentsWriting scripts and Queries to validate the transformation logicExecuting Test cases from QC & Defect LoggingHandling and coordinating Defect Status meeting with Development TeamStatus Reporting to Customer & Internal stake holderCasual Analysis of defect and prevention activitiesVikram kumarSKILLSPython, AWS (EC2, S3, Redshift, Airflow, snowflakePROGRAMMING SKILLSPython, SQL, Shell ScriptingCLOUD TECHNOLOGIESRedshift, S3, EC2, Glue, Athena, GlacierDATABASESOracle, Sql server, PostgresCLOUD SERVICESAWSPROCESS TOOLSGitlab