Pranshu Chawla

317-***-****(Indianapolis, IN) adbhir@r.postjobfree.com https://www.linkedin.com/in/pranshu-chawla-709a4019/

PROFESSIONAL SUMMARY

Around 9 years of experience in field of requirement gathering, analysis, solutioning, designing, development, testing, support and maintenance of Data Warehouse solutions

Versatile, hardworking Team lead & Solution architect with excellent learning, analytical and communication skills

Well versed with Extraction, Transformation and Loading of Data involving Informatica PowerCenter 8.6.1/9.1.6/9.6.1/10.1.0, Rule Point, Teradata V2R12/V2R13, Oracle10g/12c and UNIX Scripting.

Experience of designing Mapping, Mapplet, Session, Workflow, Worklet and other tasks of Informatica PowerCenter.

Experience in projects developed using both Agile and Waterfall methodologies.

Worked on the Performance Tuning at Mapping and Session Level.

Worked on the advance features like Push down Optimization, Concurrent processing unique to Informatica PowerCenter to improve the mapping performance using system Capabilities.

Have learning and training exposure to CICD pipeline and various DevOps tools like GitHub, Jenkins, Ansible, Docker, Docker-Compose, Kubernetes.

Hands on AWS and Google Cloud.

Experience and Knowledge of Teradata 12.0 Architecture and Components.

Worked on different Teradata 12.0 Utilities such as BTEQ, Multiload etc.

Successfully Completed the Teradata 12 Professional Certificate.

Experience in understanding critical business requirements and writing SQL as per the requirement and performance tuning of Queries.

Ability to work independently, and in a group, good interpersonal skills, commitment, result-oriented, hard working with a quest, and zeal to learn new technologies

PROFESSIONAL EXPERIENCE

Tata Consultancy Services Limited (TCS) Mar 2011 – Present

Solution Architect of Analytics, Big Data, and Information Management (ABIM) Practice of TCS’

Onsite Coordinator, Team Lead & Solution Architect – Pharmaceutical Client, Indianapolis Jan 2016 – Present

Analyze the requirements or identify the business pain area, work on RFP’s and develop detailed specifications for development of new modules/system from Onsite.

Effort and Resource Estimation for Client Requirements.

Resolution of user queries and adhoc requests for information.

Identify areas of improvement and prepare improvement plans.

Handled End to End deliveries of projects which include of requirement gathering, analysis, solutioning, designing, development, testing, support and maintenance

Follow up with various support groups, vendor and outside agencies for fixing problems.

Understanding the impact of changes to be made on existing system.

Technical and Validation documentation preparation.

Offshore-Onsite co-ordination.

Developing reusable components for the system.

Designed end-to-end solution for code migration from informatica PowerCenter 9.1 & 9.6 to 10.1 version.

Application and Workflow Development, Code review and testing. Adherence to quality standards and software engineering practices.

Sr. Developer and Team Lead – Pharmaceutical Client, Noida Nov 2013 – Dec 2015

Data analysis, data lineage – source to target mapping, data transformation rules.

Designing and development of end to end automated loading process(orchestration) for the system using shell scripting, Informatica objects and CA WA Scheduler

Played a major Role in Performance Tuning at Mapping Level, Session Level and Oracle Query level.

Performing data profiling on source data at ETL level.

Creating mappings for the specific business requirements.

Debug the sessions by utilizing the logs of the sessions.

Using Informatica Client tools- Source Analyzer, Mapping Designer, Mapplet Designer and Transformation Developer for defining Sources and Target Definitions and coding the process of data flow from source system to data warehouse.

Utilize company standards, templates, and process documentation to ensure successful delivery of projects or tasks.

Software Testing including Unit, System and System Integration Testing, Test case/data preparation, execution and verification of the test results.

Developer & Sr. Developer – Insurance Client, Bengaluru Mar 2011 – Oct 2013

Creating mappings for the specific business requirements.

Doing testing and writing queries in the Teradata SQL to ensure the correct loading of the data.

Debug the sessions by utilizing the logs of the sessions.

Using Informatica Client tools- Source Analyzer, Mapping Designer, Mapplet Designer and Transformation Developer for defining Sources and Target Definitions and coding the process of data flow from source system to data warehouse.

Independently delivered couple of Small enhancement projects in various releases.

Using various Teradata Utilities such as BTEQ, MultiLoad, FastLoad and FastExport to load and export data to and from the data warehouse.

Utilize company standards, templates, and process documentation to ensure successful delivery of projects or tasks.

Providing support for IUT (Integration Unit Testing), System Testing, Regression testing & Post production.

Act as a Single point of contact between EDW team and testing team.

SKILLS, TRAINING

Workbench: Informatica PowerCenter 8.6.1, 9.x, 10.x, Oracle 10g/12c, Teradata TD12/13, Informatica Cloud Services (ICS), Informatica Rule Point, MS-Office, CAWA Scheduler and TIVOLI.

Technical: UNIX - Shell Scripting, Oracle, Sql Server, Teradata SQL, Python.

DevOps & Cloud: GitHub, Jenkins, Ansible, Docker, Docker-Compose, Kubernetes, AWS and Google Cloud.

Business: Business Analytics, Business operations, Tool estimation, Pre-Sales, IT Delivery, Offshoring.

Education

Bachelor of Technology with specialization in Computer Science from Maharshi Dayanand University, Rohtak (Haryana) India, 2010

Personal Details

Date of Birth October 09, 1988

Sex Male

Nationality Indian

Marital Status Single

Designation Assistant Consultant (AST)

Current Location Indianapolis, Indiana (US)

Contact this candidate