Rajesh Boyapati

CEO

Hyderabad, Telangana, India17 yrs 2 mos experience
Most Likely To SwitchHighly Stable

Key Highlights

  • 16 years of experience as a Solutions Architect.
  • Expert in Hadoop and Big Data technologies.
  • Proven track record in Data Warehousing and ETL solutions.
Stackforce AI infers this person is a Big Data Solutions Architect with extensive experience in Data Warehousing and ETL processes.

Contact

Skills

Core Skills

EtlData WarehousingData AnalyticsHadoop

Other Skills

Big DataBusiness AnalysisBusiness RequirementsBusiness RulesCoding StandardsCommunicationConsultingData AnalysisData IntegrationData MigrationData ModelingData ModelsDatabase DesignDatabasesDesign Standards

About

• Ambitious and accomplished 16 years of Experienced Solutions Architect with a demonstrated working in the information technology and services industry. Skilled in Databases SQL Server, Teradata, Greenplum, Data Warehousing, Business Intelligence, and different integration tools like SAS and ETL Tools in Informatica, SAP Data Services. Having Experience in Bigdata technologies like Hadoop, Hive, Impala, Sqoop and Flume. • Leading in Hadoop solutions, including data acquisition, storage, transformation, analysis, business intelligence,IoT and integration with other frameworks for tailor made solutions to meet specific business needs using Hadoop technology stack + security implementation expert. • Key vision and focus is to help customer to establish Data Platforms in Big Data and Cloud based solutions. Proven technical/ solutions architect with a history of working in different domains – Banking, Finance, Retail, Insurance and Pharmacy.

Experience

17 yrs 2 mos
Total Experience
2 yrs 10 mos
Average Tenure
4 yrs 10 mos
Current Experience

Chubb business services india

Technical Lead

Aug 2021Present · 4 yrs 10 mos · India

Data ModelsPL/SQLRequirements GatheringBusiness RulesScrumETL Tools+21

Cargill

2 roles

Data And Solutions Architect

Promoted

Mar 2019Jul 2021 · 2 yrs 4 mos

  • Involved in gathering & analyzing the requirements and understood the architectural design of the project in a step by step process along with the data flow.
  • Experience spanning across the horizontal practice of Design & Development, ETL, Enterprise Data Warehousing, Datalake Implementation, Data Analytics, Business Intelligence and Requirement Analysis.
  • Experienced in developing Conceptual, logical models and physical database design for OLTP and OLAP systems using ER Studio, Visio and SQL Power Architect.
  • Experience in integration of various relational and non-relational sources such as Teradata, Oracle, SQL Server, SAP HANA to Hadoop.
  • Hands on experience with Hadoop distributions like Cloudera, Hortonworks, Hadoop architecture and technology stack (Hive, Map Reduce, Sqoop, HDFS, Oozie and Informatica Bigdata Edition, Kafka, Spark). • Designed and developed data flow/solution architecture with flexible schema to handle structured/unstructured data for real time and batch processing using Oracle, SQL Server, Hive, SQOOP, SPARK, KAFKA etc.
  • Extensive experience in data modeling, data and solution architecture, data warehousing & business intelligence.
  • Extensive working experience in architecture design of ETL/ELT methodology using Informatica Power Center, SSIS and SAP BODS.
  • Experience in integrating SAAS based applications to Big data Hadoop (HDFS) using StreamSets.
  • Experience in handling huge volume of data in/out from Teradata/Big Data.
  • Experience in using PL/SQL to write Stored Procedures, Functions.
  • Extensively used ER Studio Data Architect as the tool for modeling along with Visio.
  • Designed and developed data Marts/Data warehousing with different schemas like Star Schema, Snow-Flake Schema based on project requirement.
  • Designed various practical Data Visualizations, Charts, Dashboards, Prototypes for Analytical Projects using QLIKVIEW and Power BI.
Data ModelsPL/SQLRequirements GatheringBusiness RulesScrumETL Tools+21

Senior Data Engineer

Jan 2017Feb 2019 · 2 yrs 1 mo

  •  Gathering & understanding business requirements and converting them into functional specifications and technical requirements.
  •  Involved in preparation of ETL mapping specification document.
  •  Involved in migrating tasks from SAP HANA to Hadoop (Cloudera).
  •  Involved in productivity through automation (Rundeck) and process improvement.
  •  Involved in Extracting, Transforming and Loading data from different source systems.
  •  Involved in providing SAP Audit results to corporate audit team.
  •  Involved and provided results for various Data desk activities.
Data ModelsPL/SQLRequirements GatheringBusiness RulesScrumETL Tools+22

Sreeraj agrotech

Entrepreneur

Apr 2018Present · 8 yrs 2 mos · Jammidornala, Dornala, Prakasam Dt, AndhraPradesh, India

Emc corporation

Consultant

Dec 2014Dec 2016 · 2 yrs · Bangalore Area, India

  •  Having 8 years of IT experience, including around 6 years of experience in Data Modelling and DWH solutions using Informatica 9.x, Teradata, Greenplum and QlikView and Bigdata Tools
  •  Experienced in different phases of ETL projects such as Requirement gathering, Analysis, Design, Development, Testing and Documentation along with Client Communication and Knowledge Transfer activities
  •  2 Years of hands on experience in Hadoop Ecosystem, tools like Pig, Hive, Sqoop, Oozie, and MPP Databases like Teradata and Greenplum (PostgreSQL)
  •  High-level data architecture documentation, which illustrates the source and destination of data to and/or from approved data sources
  •  Involved in Relational and dimensional data modelling (Logical & Physical)
  •  Extensively used ETL methodology for Data Extraction, transformations, loading using Informatica, Sqoop, Flume and SSIS
  •  Working experience with mapplets and mappings using different transformations like Expression, Lookup, Filter, Router, Union, Aggregator, Joiner, Update Strategy, Sequence generator
  •  Involved in performance tuning of Informatica mappings
  •  Designed the QlikView data model which sourced from different data sources like databases, flat files, excel etc
  •  Created Dashboard using different components of QlikView like List boxes, Multi boxes, slider, and buttons, Input Box and charts (Bar, Line, Combo, Scatter, Pie and Straight/Pivot table) etc
  •  Involved in implementing ETL data from different data sources in Qlikview
  •  Different ETL script statements like Resident, Concatenate, Join, Keep, Mapping Load, etc
  •  Worked on Incremental load and SET Analysis
  •  Worked towards optimal development of data model by resolving loops using aliases and joins in Qlikview
  •  Experience in Validating Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users
Data ModelsPL/SQLRequirements GatheringBusiness RulesScrumETL Tools+23

Slk

Senior Software Engineer

Nov 2013Nov 2014 · 1 yr · Bangalore

  •  Gathering & understanding business requirements and converting them into functional specifications and technical requirements
  •  Designed and Developed Database in Teradata
  •  Designed Database detail document for the project
  •  Involved in preparation of ETL mapping specification document
  •  Developed mappings in Informatica to validate the quality checks
  •  Wrote efficient and complex SQL queries to validate the results
  •  Created stored procedures in Teradata
  •  Involved in UNIT testing of ETL mappings
  •  Involved in creating and setting up the jobs for this project
PL/SQLRequirements GatheringBusiness RulesETL ToolsRequirements AnalysisTeradata Data Warehouse+18

Mu sigma

3 roles

Senior Business Analyst

Aug 2011Nov 2013 · 2 yrs 3 mos

  •  Gathering & understanding business requirements and converting them into functional specifications and technical requirements
  •  Involving in QlikView Development - Creating QVD extracts and Dashboard/report reloads
  •  Strong organizational, time-management and planning skills to deliver projects on time/budget, despite intense pressure and aggressive timelines
  •  Involved in BRS preparation and HLD
  •  Prepared functional requirement specification
  •  Involved in ETL design sessions
  •  Extensively used ETL methodology for Data Extraction, transformations, loading using Informatica
  •  Involved in UNIT testing of Qlikview Dashboard and ETL mappings
  •  Created Autosys jobs to create and refresh QVD’s and Dashboard
PL/SQLRequirements GatheringBusiness RulesETL ToolsRequirements AnalysisTeradata Data Warehouse+17

Business Analyst

Nov 2010Jul 2011 · 8 mos

  •  Gathering & understanding business requirements and converting them into functional specifications and technical requirements.
  •  Designed and Developed Database in Teradata.
  •  Involved in preparation of ETL mapping specification document.
  •  Involved in QlikView Development - Creating QVD extracts and Dashboard/report reloads.
  •  Created stored procedures in Teradata to lock or unlock or delay Autosys Jobs.
  •  Involved in UNIT testing of ETL mappings and Java application.
  •  Developed mappings in Informatica to load fact tables.
  •  Designed and created Qlikview Dashboard for ISVN and IAE modules.
PL/SQLRequirements GatheringBusiness RulesETL ToolsRequirements AnalysisSAS+17

Contractor

Aug 2010Oct 2010 · 2 mos

  •  Understanding the business requirements and converting them into functional specifications and technical requirements.
  •  Developed Database models in SQL Server 2008 and uploaded to Teradata using the Informatica.
  •  Implemented the ETLs using Informatica to export/import data from/to Teradata.
  •  Worked closely with Business Analysts and Marketing Officers of Home Depot to resolve the issues.
  •  Led the 5 member team and deliver the requirements on time.
PL/SQLRequirements GatheringBusiness RulesRequirements AnalysisSASTeradata Data Warehouse+15

Real estate company

Software Engineer

Aug 2008Aug 2010 · 2 yrs · Hyderabad, Telangana, India

  •  Understanding the user requirements, functional specifications and technical requirements.
  •  Designed ETL packages using SSIS 2008.
  •  Involved in Database model in SQL Server 2008.
  •  Prepared test cases for the application.
  •  Involved in Unit testing.
PL/SQLRequirements GatheringBusiness RulesRequirements AnalysisSASExtract, Transform, Load (ETL)+14

Education

Acharya Nagarjuna University

Master of Computer Applications (MCA) — Computer Science

Jan 2005Jan 2008

Acharya Nagarjuna University

Bachelor’s Degree — Electronics and Communications

Jan 2002Jan 2005

Sri Prathibha Junior College

Associate’s Degree

Jan 2000Jan 2002

B.V. Subbaiah Residential School, Ongole

High School

Jan 1999Jan 2000

Stackforce found 100+ more professionals with Etl & Data Warehousing

Explore similar profiles based on matching skills and experience