Experience

Matrix IFS
• United States
• IT Services and IT Consulting
• 100 - 200 Employee
• Senior ETL Consultant

  • Apr 2015 - Present

Nomura
• Financial Services
• 700 & Above Employee
• ETL Developer

  • Apr 2015 - Present


Jagged Peak

• United States
• Software Development
• 1 - 100 Employee

• BI Intern

  • Aug 2014 - Mar 2015

  • Developed SSRS reports to display the shipment details of various carriers on a heat map by calculating Geospatial data. • Created SSIS packages to load the data from various clients into the database and automate the process for data loads that are done manually. • Working in SSAS and OLAP data cube to develop Analytical reports. • Developed SSRS reports to display the shipment details of various carriers on a heat map by calculating Geospatial data. • Created SSIS packages to load the data from various clients into the database and automate the process for data loads that are done manually. • Working in SSAS and OLAP data cube to develop Analytical reports.



PCGS, University Of South Florida

• Application Developer

  • Jun 2014 - Aug 2014

  • Worked with business in defining requirements and prepared the business requirement document and technical design document. • Developing a C# WPF application using MVVM pattern which computes the water needs and demands of a city and provide recommendations. • Created many Custom controls and User controls to improve code re-usability. • Worked with business in defining requirements and prepared the business requirement document and technical design document. • Developing a C# WPF application using MVVM pattern which computes the water needs and demands of a city and provide recommendations. • Created many Custom controls and User controls to improve code re-usability.



Infosys

• India
• IT System Custom Software Development
• 1 - 100 Employee

• Senior System Engineer

  • Dec 2012 - Dec 2013

  • Designed and analyzed microstrategy reports, very large production data sets for discrepancies in data.• Traced data within the system to solve business problems.• Designed and administered backup recovery process in case of a production failure.• Performed Statistical Analysis of business data.• Analyzed the root cause of the defects in production environment

• System Engineer

  • Nov 2010 - Nov 2012

  • Responsible for designing and developing of mappings, mapplets, sessions and work flows for load the data from source(Provided by Vantage Server) to target database using Informatica Power Center for Cognos Report generation and tuned mappings for improving performance. • Involved in ETL process from development to testing and migrate to production environments.• Extracted data from various sources like Flat files, Oracle and loaded it into Target systems using Informatica 9.1, Netezza. • Developed mappings using various transformations like update strategy, lookup, stored procedure, router, joiner, sequence generator and expression transformation. • Developed and Tuned SQL scripts and stored procedures in Oracle and Netezza for better performance and efficiency. • Created reusable shell scripts in UNIX environment. • Developed Netezza scripts that replaced informatica mappings to reduce the time taken for ETL by one day. Show less

• Software Engineer intern

  • Jun 2010 - Nov 2010

  Trained in various concepts such as C, PL/SQL, Oracle, Informatica , HTML,C++, Java basics, UNIX and Perl, Software engineering.