Created ETL processes using Informatica having source and target systems as SQL server and Teradata.
Working on ETL tools like Informatica (Power Center) Designer, Repository Manager and Workflow Manager.
Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like SQL server, Flat files and Teradata.
Created number of Informatica mapplets and accelerators to enhance the reusability of general functions in the mappings.
Created the SCD Type 1 and SCD Type 2 mappings in Informatica to keep the historical data in the warehouse.
Writing several Teradata SQL Queries using Teradata SQL Assistant for Ad Hoc Data Pull request.
Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union Updated numerous BTEQ/SQL scripts, making appropriate DDL changes and completed unit and system test.
Involved in reverse-engineering of the existing Informatica code, Teradata BTEQ scripts and metadata to understand the existing process and relationships between the data.
Developed impromptu reports on Tableau including the details about the jobs running in the applications Used utilities of FLOAD, MLOAD, FEXP of Teradata and created batch jobs using BTEQ.
05/2014 to 12/2014
Intern- DeveloperTech Data － Clearwater, Florida
Developed highly customized SharePoint website using SharePoint Designer, InfoPath Forms, jQuery and CSS.
Created Workflows, custom forms, web parts, views, permissions, graphics as needed, based on requirements.
Communicated on the daily basis with the stakeholders to discuss about the requirements and validation of the development.
08/2013 to 05/2014
Teaching AssistantUniversity of South Florida － Tampa, Florida
Problem Solving on Business Statistics, Working on Statistix tool, Project/Exam grading.
Tutor students on basic Statistics 1.
07/2011 to 06/2013
Software EngineerHSBC Software Development Ltd Pune
Gained Experience on the technologies like JAVA, JSP, WebSphere Portal Server, HTML, CSS, WebSphere MQ, Portlets, XML, Hibernate and Spring.
Developed 2 modules which include Renewal and Maturity Instruction, Close Account.
Integrated Receipt and Form printing functionality to over 40 functions in the Assisted 1.0 application.
Provided System Acceptance Testing support for the modules and printing functionality.
Implemented FATCA changes for customer detail related functions in HFE which is the HSBC Banking staff application currently live in over 60 countries.
80% reduction in the defect count of the existing HFE customer functions.
Enhanced and integrated the Verbal Quiz function, which is used by the call center representative of HSBC to the Assisted 1.2 application.
Master of Science: Management Information SystemUniversity of South Florida － Tampa, Florida, U.S.GPA: GPA: 3.92/4.00 Teaching Assistant Scholarship for Fall 2013 and Spring 2014
Devi Ahilya Vishwavidyalaya Indore
Management Information System GPA: 3.92/4.00
Teaching Assistant Scholarship for Fall 2013 and Spring 2014
Bachelor of Engineering: Information TechnologyDevi Ahilya Vishwavidyalaya － Indore, MP, India
Information Technology 76/100
Publication - LAYERED SECURITY APPROACH IN CLOUD Proc. of Int. Conf. on Advances in Recent Technologies in Communication and Computing 2011 November 15, 2011
Business/Intelligence Tools -Informatica
9.X, Teradata, Microsoft SSIS and SSRS, Tableau