Manikanth Reddy Vanga

Having 4+ years of total IT experience in all phases of software development life cycle, 3+ years of industry experience in Data Warehouse as Data Engineer, involved in design and development of distributed systems using Hive, Spark and Python. Experience in developing SQL scripts to Upload, Retrieve, Manipulate and handle sensitive data in MySQL and SQL Server Management Studio. Used SQL and Excel to ensure data quality and integrity, Identified and eliminated duplicates and inaccurate data records. Experienced with different Python module libraries, packages like NumPy, Pandas data frame. Expertise in creating optimized Hive tables using proper partitioning, bucketing for faster I/O, implementing Change Data Capture (CDC), Dedup, Incremental load, Data quality governance, balance and control. Developed a tableau dashboard to monitor real-time monthly & quarterly transactional pattern of clients based on business unit, transaction type and sector. Experience in Python scripting. Experience on calculations using different type of functions like logical, Number, String, Aggregate, date functions. Proficient in AWS services like EC2, S3, ELB, RDS, IAM, Aws Glue, Athena, CloudWatch, Lambda. Experience in functional/database testing using selenium/webdriver, pytest. Created test scripts using python scripting methodologies. Strong experience in creating CI/CD pipeline for continues integration testing. Experience in Performing Database/Backend testing by writing SQL/Oracle Queries for data validation and integrity. Strong knowledge of Software Development Life Cycle and expertise in detailed design documentation, Experience in working with agile team. Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data. Seasoned collaborator experienced in meeting needs, improving processes and exceeding requirements in team environments. Diligent worker with strong communication and task prioritization skills.