Ashish Ranjan

Experience

• 

  Wipro

  Sept 2008 - Jul 2010

  S/W Engineer

   Project Planning and Tracking, Configuration Management (CVS tool), Code Reviews, troubleshooting & Defect prevention, Coordinating with the Onsite team and client for the optimization & automation of jobs to save the more efforts required for support Coordinating with other BSA for requirement gathering and understand business processes. Update the status of the work and deliverables to the client.

• 

  Teradata

  Jul 2010 - Dec 2012

  Associate Technical consultant

  Working as a Associate Technical Consultant at Teradata India Pvt. Ltd. The technologies include Teradata 12/13, Mainframe and Datastage 8.1, HPQC.

• 

  Cognizant

  Dec 2012 - now

  Associate

  --> Involved in requirement gathering and creating High level, Low level design and mapping specification document Design & Development of ETL mappings to consolidate data from various data sources required for DETICA reporting LDM to PDM reconciliation and validations Source system analyzing, designing and loading strategy at STAGE/ODS layer Effort estimation of Informatica Mappings  Developed reusable informatica components and SQL procedures Performance tuning of ETL code, identifying bottleneck and resolution of performance Issues SIT/UAT Deployments, Defect fix and support Coordination with onshore team, BA on various fronts e.g. planning, effort estimations, discussions, process improvements, challenges etc. Dynamic parameter file generations using shell scripts Show less

• 

  ING

  Feb 2016 - now

  Senior IT Specialist