Ramesh Karamsetty Email & Phone Number

Us

Experience focusing on Data warehousing, Data modeling, Data integration, Data Migration, ETL process and Business Intelligence. Proficient in Talend open studio ETLAnalysed the user requirements, functional specifications, and Use Case documents and created the Test Plans, Test cases for different modules of projectData Analysis using SQL and create data mapping document, and technical requirements as per business logics. Work with development team in creating dimensional model for the reporting system by identifying required dimensions and facts and implement Slowly Changing Dimensions - Type I & IIExtensive experience in Data Integration with DW tools like IBM Datastage, Informatica, SSIS & Pentaho Data Integration for developing complex ETL process.Experience in DW design, dev, implementation, support using IBM Datastage tool 11.7.Experience in implementation of ETL process in Datastage Enterprise Edition (Parallel Extender).SSIS packages to move data from various sources into destination flat files and databasesExtensive knowledge in Data Modeling concepts & Dimensional Modeling concepts (Star Schema, Snowflake Schema, Dim & Fact)Experience with Agile ScrumExperience building Reports& Dashboards using TableauAnalyzed and Enhanced mainframe elements (PROC,COBOL&JCL)Automate mainframe batch job processing and email the resultPerformed mainframes testing by fileaid&DB2 toolExtensively worked in UNIX Shell script &CTL M designingSolutioning and implementing analytical capabilities using the Azure Data Analytics platform including, Azure Data Factory, Azure SQL DWH/Synapse, Azure Data Lake is highly Experienced migration design and implementation .Experience with enterprise architecture data modellingExperience in using GitHubExperience in user batch scheduling like Autosys, Airflow and TWSPerformed Development lead activities, preparation of FS, estimates, LLD and code, daily & weekly status presentation to customers, Project Metrics Management.

Preparation of Test Plan and Test scripts.Lead the team in most critical deadlines and delivered the project successfullyUnderstanding the Data mapping document and Data model to prepare Functional System Document (FSD).Creation, reviewing, preparing and executing test cases and test scriptsExecute the Test cases stored in Rally as per scheduleProviding KT in required areas in the Testing life cycle.Used Microsoft Access to tool for the data validations as per the business requirement.Used Pivot table functionality for the reporting purpose.Creation of Test Summary reportProvided Daily Status report, check list documents and weekly status reportsReporting Defects on daily basis, Logging identified defects in Test defect report.Coordination with testing team for fixing defects.Writing test cases in ALM and Rally as per the requirements.Scheduling Peer Review, Internal walkthrough, and External walkthrough for test cases with the entire Project Team.Performed System testing, database testing, ETL testing, Mainframe testing and regression testing for Datastage application