Mar 2019 – Jul 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.

Jan 2017 – Feb 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.

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

Dec 2014 – Dec 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

Nov 2013 – Nov 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

Aug 2011 – Nov 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

Nov 2010 – Jul 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.

Aug 2010 – Oct 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.

Aug 2008 – Aug 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.