Apr 2022 – Mar 2024 · 1 yr 11 mos · Bengaluru, Karnataka, India

Jun 2019 – Mar 2022 · 2 yrs 9 mos · Bengaluru, Karnataka, India

• Create and maintain optimal data pipeline architecture,
• Assemble large, complex data sets that meet functional / non-functional business requirements.
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
• Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and AWS ‘big data’ technologies.
• Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency, and other key business performance metrics.
• Work with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs.
• Work with data and analytics experts to strive for greater functionality in our data systems.

Mar 2015 – Jun 2019 · 4 yrs 3 mos · bangalore

Jul 2013 – Mar 2015 · 1 yr 8 mos

• A dynamic software professional with 1.8 yrs. of work experience in data warehousing projects. Currently, employed with Symphony Teleca Corp, Bangalore as a Software Engineer.
• Data processing knowledge in implementing Data Warehouse applications, mainly Transformation processes using ETL tool INFORMATICA POWER CENTER.
• Worked with Business Analyst and the Business users to understand the user requirements, layout, and look and feel of the application to be developed
• Have adequate knowledge in data modelling using Star Schema Modelling, and Snowflake modelling, FACT and Dimensions tables, physical and logical modeling.
• Data blending implemented on URA databases and generated interactive dashboards.
• Created adhoc reports to users in RPM by connecting various data sources
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Good knowledge of data warehousing models, RDBMS concepts and SQL.
• Good working knowledge in Oracle and Pl/SQL.
• Adequate knowledge on UNIX.
• Extensive experience with Data Extraction, Transformation, and Loading (ETL) from different Data sources like
• Oracle and Worked on integrating data from flat files.
• Extensive experience in development &enhancement of BI applications on Telecom domain.
• Actively involved and contributed during various stages of SDLC process (worked in both AGILE and WATERFALL frameworks) such as design, development, testing, debugging, deployment and maintenance.

Jul 2013 – Mar 2015 · 1 yr 8 mos

• Extracting and loading of data from flat file to vertica database (target warehouse)
• Transformations in the mappings. Extensively used Talend Component like TMAP, TJOIN, Aggregator, Expression, Sequence Generator, SQL and TRow etc.
• Created Pre and Post Session Scripts for checking file existence.
• Load data on Amazon S3 from vertica db by the help of talend .
• Load data on Red Shift from S3 though talend.
• Performed Unit testing and Integration testing on the mappings and documented the entire ETL process.
• Review the mappings developed by other team members.
• Checking In the code into SVN whenever code has to move from Dev to test/Pre-Prod/Prod for versioning.
• Used Jira tool for Agile based Effort Tracking.
• Supporting to Production team until stabilize the code.
• Involved to preparing the Documentation for the mappings based on the Business Requirement.
• Involved in creating and visualizing dashboards using Tableau Desktop.
• Generated Tableau combination charts using Tableau visualization software.
• Generated interactive dashboards.
• Created adhoc reports to users in Tableau by connecting various data sources.
• Generated Tableau dashboards with combination charts for clear understanding
• Involved in discussing Requirement Clarifications with multiple technical and Business teams.
• Created Technical Design Document from the functional specification documents
• performance.
• Prepared and executed Test plans for unit testing, System Testing and User Acceptance Testing (UAT).