Software Engineer

CGI

February 2015 to Actually working here

System Engg.

Tata Consultancy Services

July 2012 to Actually working here

Project 2 Description: The Honeywell CPS Data team to be extract and load the data from the various sources like Oracle, SQL Server, DB2, Database and SAP GUI. The CP/S program is so large running 14 super tankers sources and 20+ projects at any time it is very important that we have a common reporting structure for the data management of all projects within the program. We leverage the same utility database as with the data processes and centrally locate all project plan details in a central set of tables and provide reporting to the deployment leads, data leads and full data team for activity management, follow-up, and issue resolution. Roles/Responsibilities: ? Coding, and testing to meet client requirements, performance tuning of Code. ? Update the deliverable documents. ? Development and Enhancement in the existing mappings. ? Develop and maintain appropriate documentation for knowledge management. ? Knowledge Transfer (KT) & Training to Support Team. ? Daily, Status call with the clients for Project updates. ? Worked on HPQC tool for completing the scripts. ? Highly, involved giving Technical Training to the Fresher?s. ? Worked as Data Analyst for loading data in SAP Technical Activities: ? Extensive experience in ETL using Informatica. ? Worked with different data sources like Flat Files and Databases like SQL Server,DB2 etc. ? Worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Union, Update Strategy, Aggregator, Rank and Sorter. ? Worked on Material Unreservations using SAP Application. ? Involved Functional training session on Manufacturing. ? Worked on Manufacturing loads process from Oracle database to SAP. ? Involved in development and enhancement of Scorecards and their workflows. ? Hands on experience in designing and developing mappings, sessions and workflow management ? Thorough knowledge on data warehouse concepts like Star Schema, Snowflake, Dimension and Fact tables

System Engineer

TCS

April 2012 to June 2012

Project 1 Description: Honeywell Aerospace data was initially present in Legacy System's. This data was to be then loaded into Oracle Database. The data from Legacy Systems was received in the form of Flat Files and then these Files were loaded in the Oracle Databases. Roles/Responsibilities: ? Direct interaction with the Process Team (PT) for any clarification about the assigned Incident. ? Regularly, Update Work order status (Work In Progress/Waiting for Input/Ready for Testing) in Remedy tool to make clients aware about the progress of Work Order ?Issues?. ? Coding, and testing to meet client requirements, performance tuning of Code. ? Development and Enhancement in the existing mappings. ? Develop and maintain appropriate documentation for knowledge management. Technical Activities: ? Experience in ETL using Informatica. ? Worked with different data sources like Flat Files and Databases like SQL Server,DB2 etc. ? Worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Union, Aggregator, Sorter and Rank. ? Experience in designing and developing mappings, sessions and workflows. ? Involved in handling the project related sessions. ? Thorough knowledge on data warehouse concepts like Star Schema, Snowflake, Dimension and Fact tables. ? Developed effective working relationships with client teams to understand support requirements.

Bachelor of Engineering (BE)

2007 to 2011

Career Goals

Industries of interest

Areas of interest

Availability to travel and work outside the city

Yes

Interests and hobbies