surendra vadagandla

Data Analyst/Reporting System Analyst

Reporting SystemANALYST (JUL 2017 – Dec 2017) Company: Maxis Broad Band SDN BHD, Client: Maxis Broad Band SDN BHD Responsibilities: (ETL/Python/R and Qlikview Developer)

Reporting SystemANALYST (Sep 2015 – May 2016) Company: Virtusa Software Services, Client:Affinion Responsibilities: (Python/R and ETL Developer)

Responsibilities: (ETL Developer) • Setting up new environment (Informatica & Vertica) for both HPE and HPI. • Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like SQL server and Flat files

Responsibilities: (R and ETL Developer) • Lead and Coordinate the team’s daily activities • By using Informatica MDM, reading from and writing to diverse bigdata sources and targets • Performed data replication on a Hadoop cluster • Performed data lineage on bigdata sources

• Developed the mappings to extract, transform and load data into data Mart. • Used Control-M to schedule and monitor the jobs. • Involving in performance tuning of Informatica map-pings/oracle packages • Working on the tickets to resolve the issues raised by Business users • Upgrading Informatica from 8.6 to 9.0

• Analyzing the requirements based on BRD and involved in preparing FRD • Coordinating with onsite team and leading the offshore team on assigning the tasks and responsible for delive-rables • Developed ETL mappings to extract the data from mul-tiple source systems like Oracle, SQL server and Flat files • Performance tuning and overall system testing • Preparing the test case documents. • Preparing the Deployment document and Database scripts.

ETL Developer SAS Developer

ETL Developer