Keerthi

Keerthi Mohan – Senior Software Developer Email:-, Mobile: -, - Professional Summary: 7.3 years of IT experience as ETL Developer and Business Analyst focusing on Data warehousing, Data modeling, Data integration, Data Migration, ETL process, Business Intelligence and Enterprise Reporting technologies covering domains of Cable Services, Telecommunications and Life Insurance. Experienced in using data mining and statistical technologies on huge volume of data and data extraction, data cleansing, data transformations, data validation and data loading for data warehouses and data marts. Good knowledge in understanding source systems and its data, analyze and identify different data issues and its root causes, develop innovative solutions to business challenges and streamlining operations. Proven ability to deliver projects in both agile and waterfall methods Academic Profile: B-Tech in Computer Science from Gates, JNT University, Anantapur, Andhra Pradesh. PUC from Shakthan Thampuran College, Thrissur, Kerala. SSC from St. Mary’s High School, Anantapur, Andhra Pradesh Professional Experience: Working as Data Migration Developer for Sapiens technologies Pvt Ltd from March 2019 to till date Worked as a Technology Analyst for Infosys Ltd from Sep 23,2013 to Feb,2019 Project Details: Project #1: Consolidation Master Data Migration Client: Leading Insurance company Duration: Mar 2019 to Present Role: Data Migration Developer Responsibilities: Working in Agile Project as a Scrum Team Member. Working in end to end data migration process from receiving the source files, validation, transformation, loading, reconciliation and post validation reports. Communicated with business customers to discuss the requirements and issues. Expertise in new data migration/ETL tool K2View and its implementation in data migration process Project #2: AX-Upgrade: Reengineer the current SSIS process in Informatica to provide extracts to comply with change in source system from A4.0 to Dynamics 365. ​ Client: Leading US Fashion Retailer Role: ​ Business Analyst and ETL developer Responsibilities: Responsible to understand the current system and provide the mapping document. Responsible for requirement analysis and design of the new requirement Responsible to perform Gap Analysis of the Product Module Involved in Mappings development in Informatica to load the Stage, Work and Data tables Project #3: Federate mart: Handling the data repository of all the tracks and maintaining the flow from the source to the end user. Client: Leading US Television Company​ Role: ​ Business Analyst and ETL developer Responsibilities: Responsible for proactively working on the Analysis, Design and Coding Phases Responsible for root cause analysis in data issues and preparing the SQL scripts for the same. Responsible for integrating distinct data sources and maintaining it into a single version. Analysis and providing quick resolution for any data issues in data warehouse or any other ETL layer Identifying risks on poor data quality for testing, incomplete application interfaces and late change requests Involved in changes in the data models changes (as a part of enhancements) KEY SKILLS: Good communication skills, strong decision making and organizational skills along with outstanding analytical and problem-solving skills to undertake challenging jobs. Quick learning skills and keen to learn new technologies Able to work well independently and also in a team by helping to troubleshoot technology and business-related problems. DOMAIN & TECHNICAL EXPERTISE: Domain Skills Business Intelligence Project Management Agile and Waterfall Methodology of software development and delivery ETL Tools K2viewStudio, Informatica, SSIS BI Reporting Tools Cognos, MicroStrategy, and Tableau (completed Infosys Internal Trainings). Done a POC on Waste Management System using Tableau Platforms Unix, Windows (All) Database Oracle 18c, MySQL, Netezza 4.0 Others ETL, Relational Database Management System, SQL Database, MSBI, Teradata, SQL, SSIS, SSAS, Informatica, SQLite, PHP