Developer Real Estate
Resume:
Kishore Pradeep Anbazhagan
****************@*****.***
Skype ID : Kishore.Pradeep
SUMMARY
EIGHT plus Years of Experience in Designing, Development and Implementation of Data Warehouses & Datamarts using Informatica Power Center.
Have been involved with Big Data world for the past ONE year with exposure to HIVE and DMXPRESS
Fine Analytical, inter-personal & Communication skills with experience in giving presentations and interacting with clients, multiple user groups and managing team activities
Thorough understanding of Software Development LifeCycle (SDLC) including requirements analysis, system analysis, design, development, documentation, testing, implementation and post-implementation review.
Possess wide range of IT industry experience with Real Estate, Airline and hospitality Domain etc.
Good knowledge of Informatica Web services (WSDL/XML), XML mappings and xml sources.
Hands on experience in implementing both REST and SOAP web services in informatica.
Extensive experience with ETL tool Informatica in designing the Workflows,, Mappings and scheduling the Workflows and sessions using Informatica Power Center 9.x and 8.x
Proficient in Extracting, Cleaning, Transforming and Loading the data using all the Transformations in the ETL tool Informatica.
Involved in Data extraction from various sources like Microsoft CRM, Salesforce, LDAP, Webservices, UI based system, Oracle system, SQL server, flat files, XML etc
Vast experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, JAVA, WebService Consumer, XML parser, HTTP, Normalizer, Transaction Control, Router, Filter, Expression, Aggregator, Joiner, etc.
Involved in debugging and Performance tuning of targets, sources, mappings and sessions.
Experience in integrating various application with Third party software using informatica
Extensive experience in developing reusable transformations embedding the business logic.
Extensive experience on using informatica to load data to Teradata using Teradata utilities.
Closely worked with the DBA in creating tables, migrating tables to different environments and obtaining permissions on various tables.
Involved in preparing migration documents to move the mappings from development to production repositories.
Good Knowledge on using scheduling tools to automate running of Informatica workflows.
Involved in UNIX shell scripting, FTP and file management in various UNIX environments
Have worked on data encryption process using PGP algorithm
Experience in writing Integration and System Test Scripts.
Have been involved in prescreening of candidates for the projects and been a part Cognizant North America technical interview Panel.
Proven experience in meeting deadlines and appreciation from clients.
TECHNICAL SKILLS
ETL Tools: Informatica 9.x, 8.x, DMExpress
Database: SQL Server, Teradata, Oracle, Hive
Scripting : UNIX/Linux Scripting, Batch scripting
Scheduling Tool : Control M, Autosys
Platforms: Microsoft Windows 2008 Server, Unix, Linux.
EXPERIENCE
Organization : Cognizant Technology Solutions Ltd Sep 2016 - Current
Location :Atlanta, USA
Client : – InterContinental Hotels Group Hotel group
Role : Informatica Lead and Developer
Technology: Informatica Powercenter 9.6.1, Teradata, Shell Scripting, Hive, DMExpress
Roles Played:
Onsite Lead and Developer
oInvolved in full lifecycle of several projects including requirements gathering, analysis, design, development, testing and debugging.
oLead a group of junior and senior developers across geographies (UK and India) on a variety of development projects which involved moving data from different sources to Reporting layer.
oExtensively used mapping parameters and variables, created Informatica workflows to automate the creation of parameter files
oDeveloped ETL process which audit’s ETL loads, passes incremental parameters
oDeveloped ETL components in Big Data environment using DMExpress ( i.e Data load from HDFS to Hive)
oActively involved in standardizing Informatica code practices and documenting the standards followed enterprise wide
oWorked extensively on developing re-usable logics which are used in multiple projects
oCreated ETL mappings in Informatica, SQL’s/ DB objects in Teradata and UNIX shell scripts to implement the business logic.
oCreated BTEQ, Mload and fast load scripts and testing them in UNIX server.
oInvolved in performance tuning of legacy informatica and DB codes.
Organization : Cognizant Technology Solutions Ltd Feb 2014 - Sep 2016
Location : Lombard, USA
Client : Jones Lang LaSalle – Real Estate
Role : Informatica Lead and Developer
Technology: Informatica Powercenter 9.6.1, SQL server, Control M, Informatica DIH, Batch Scripting
Roles Played:
Onsite Lead and Developer
oInvolved in full lifecycle of several projects including requirements gathering, analysis, design, development, testing and debugging.
oHave developed ETL process that retrieves data from external web services and have loaded the same to the relational tables.
oContribute to the project estimation process
oWas involved as an ETL lead developer in the implementation of their Data warehouse
oLead a group of junior and senior developers across geographies (Singapore, UK and India) on a variety of development projects which involved moving data from different sources to Reporting Layer.
oExtensively used mapping parameters and variables, created Informatica workflows to automate the creation of parameter files
oDeveloped ETL process which audit’s ETL loads, file checks and others
oDeveloped and deployed REST components using IDQ
oDeveloped and deployed informatica DVO components for validation of data.
oActively involved in standardizing Informatica code practices and documenting the standards followed enterprise wide
oPart of Code review and design review boards responsible for making sure the codes adhere to the JLL standards and signing off the Informatica solutions before development, respectively
oUsed deployment groups, repository queries and labels to actively deploy Informatica code from one environment to the other
oWorked extensively on developing re-usable logics which are used in multiple projects
Organization : Cognizant Technology Solutions Ltd Sept 2011 - Feb 2014
Location : Bangalore, India
Client : Delta Airlines – Airlines
Role : Module Lead and Developer
Technology: Informatica Powercenter 9.6.1, Teradata V13, Mainframes, Unix Scripting
Roles Played:
Module Lead and Developer
oInvolved in analysis and design
oProvide necessary functional & design documentation as to how the EDW module will be designed.
oAnalyze technical requirements of the project and gather source system information to achieve it.
oDiscuss design & development progress with the onsite team.
oContribute to the project estimation process
oCreated ETL mappings in Informatica, SQL’s/ DB objects in Teradata and UNIX shell scripts to implement the business logic.
oCreated BTEQ, Mload and fast load scripts and testing them in UNIX server.
oIdentify and resolve technical problems related to performance, functionality and coordinate with end users as necessary.
oHandling Primary Production support by monitoring jobs, Defect Resolution and Analysis /Clarification and provide prompt response to job failures.
oFix on errors – Deployment of code and data fixes by performing root cause analysis, and application performance improvements.
oEnhanced existing Scripts to adhere to new EDW Standards provided by Delta IT in projects executed.
oWorked on process design documentation as a part of the day-to-day project implementation.
Organization : Cognizant Technology Solutions Ltd Dec 2009 - Sept 2011
Location : Bangalore, India
Client : RCI – Hospitality
Role : Developer and Production Support
Technology: Informatica Powercenter 9.6.1, Oracle 10g, Autosys
Roles Played:
Developer and Production Support
oProvide necessary functional & design documentation as to how the DW module will be designed.
oDesign Phase– Prepare Approach, Technical Design Documents, ETL Specification Docs, and Release Docs.
oCreated ETL mappings in Informatica to implement the business logic.
oSchedule the jobs using Autosys
oProduction Support: Fixed Bugs and identified the root cause of the bugs reported, Code changes and worked on Change requests.
oProvide necessary functional & design documentation as to how the Change request would be implemented.
oFix on errors – Deployment of code and data fixes by performing root cause analysis, and application performance improvements.
oIdentify and resolve technical problems related to performance, functionality and coordinate with end users as necessary.
oPreparing the test cases for the developed code
oInvolved in preparing migration docs from one environment to other ex.SIT to UAT.
oCoordinate deployment of project related objects to Production.
Notable Accomplishments
Received appreciation from CIO of the real estate client for ensuring a smooth delivery of the application Integration efforts
Received STAR performer award from CTS vertical team for seamless delivery for an Airline project.
Won multiple quiz events conducted by Cognizant as a part of its employee engagement programs
EDUCATION
Bachelor of Engineering, ECE
Sapthagiri College of Engineering, Karnataka, Karnataka
Visvesvaraya Technological University
Year of Completion : 2009
Higher Diploma in French,
Bangalore University, Bangalore
Year of Completion : 2012
Skills
Tool:
-Informatica 9.6.1
-Informatica DIH
-Informatica DVO
-Informatica IDQ
-DMExpress
Database:
- Oracle 10g
- Teradata v13
- SQL Server 2012
Storage:
HDFS
Package:
-Hive
Programming Languages:
-SQL
-T-SQL
-PL/SQL
-BTEQ/Mload
-Tpump
Scripting Language
-Unix/Linux
-Batch Scripting
Utilities:
- SQL Assistant
-Goanywhere
-Quality Center
-Visio
-MS Office Suite
-HP Quality Center
Scheduling tools:
-Control M
-Autosys
Webservices:
-SOAP UI
-REST
- Informatica Webservice Hub(WSH)
Version Control :
TFS
GIT
Others :
Diploma in French
Contact this candidate