Komal Singh

Email: adlslu@r.postjobfree.com

Linked In: https://www.linkedin.com/in/komal-singh-72bbb8183/

GitHub: https://github.com/komalsingh13

Mobile: 798*******/897-***-****

Overall, 5.8 years of IT experience in software analysis, design and development for various software applications in client-server environment which includes more than 5.3 years of experience in Informatica Power center and Data Warehousing in ENU domain and 1 year of experience in IDQ

Hands on experience in developing complex Mappings and preparing Technical design document (HLD & LLD)

Hands on experience in application development using Oracle and stored procedures in PL/SQL programming.

Strong knowledge of IPC ETL transformations such as Lookup, Filter, Aggregator etc

Strong knowledge on management of Data Warehousing and DW solutions.

Strong knowledge of all phases of SDLC (Software Development Life Cycle)

Exposure in writing shell script for different applications.

Exposure in working with CDC (Change Data Capture) structure.

Extensive experience in Designing, Developing Informatica based applications in ENU Domain.

Exposure in databases such as Oracle to manage tables, views, indexes, sequences, stored procedures, functions, triggers and packages.

Exposure to the various compression and serialization techniques used in Mapping for Performance & memory optimization.

Hands on Experience in Teradata. Exposure in working with M-Load, Fast load, B-TEQ etc.

Hands on Experience in writing Oracle, SQL, Stored Procedures, Functions in Relational Database.

Having basic development skills on Tableau Reporting tool and making in corporate Dashboards.

Proficient in understanding business processes/requirements of esteemed claim industry and translating them into technical requirements. Understanding of SDLC, worked on waterfall model and agile model.

Expertise and well versed with various Transformations, Partitions, Dataset and Database components.

Having exposure in Data Integration and hands on experience in Data Conversions and Migrations.

Exposure in handling production failure and troubleshooting the application failure through log

Ability to understand long-term project development issues at all levels, from interpersonal relationships to the details of coding scripts with strong analytical, organizational, presentation and problem-solving skills.

Roles Performed:

Developer

Production Support Analyst

CORE COMPETENCIES

Informatica Power center – v9.1, v9.6, v10.1, v10.4 and IDQ

OS – Windows, Linux

Languages- PL SQL

Data Stage

Terdata

UNIX

SAP BPC 7.5 MS version

DB – Oracle, MS SQL, Teradata.

Scripting - Shell Scripting

Scheduling tool – VL trader

Data Warehousing

Task scheduler

Python Scripting

PROFESSIONAL EXPERIENCE

WIPRO Technologies LTD.

Project Name: eBilling BP Dec 2017 to till date

Project Description:

The objective of the Project is to deliver a customer focused web based e-billing solution that will address the Customer requirements for the presentment of invoices. There is a requirement for a new Interface to be built for Users, the agent who handles Invoice Data transactions

To implement the requirement, we have to manipulate the database tables and need to implement Informatica IDQ, and a HTTPS file transfer workflow will be created Via CLEO

Job Responsibilities:

As a developer and support team member, I am responsible for

Leading the team from Offshore and Analyzing the Requirement Specifications.

Supporting the jobs in Production for loading the daily transactions in to the Warehouse.

Supporting the Monthly jobs in Production to derive the KPI’s

Client Appreciation for Delivery within SLA

Enhance the new Business requirement

Development of Informatica components as per requirement

Unit Testing including the preparation of test castes

Handling Important Mappings, File write process.

To Deliver Defect free code on Time.

Developed automation how to resend to data if there is requirement at customer end.

Project Name: ANZ_ BP_INF_Production_Support April 2016 to Dec 2017

As a Developer, I was responsible for,

Gathering the requirements and getting clarified from the Client directly. Preparation of the understanding document.

Developed the ETL code based on the requirement, Unit test and Delivery of the code.

Involved in UAT support as part of delivery and post-production activities.

Involved in enhancements to create/modify the ETL jobs in various applications based on client requirements using ETL tools Informatica powercenter and IDQ and SQL Server and UNIX.

Project Name: SAP BPC Production Support Mar 2016 to Jun 2016

Job Responsibilities:

As a Systems Analyst, I am responsible for,

Gathering the requirements and getting clarified from the Client directly. Preparation of the understanding document.

Involved in UAT support as part of delivery and post-production activities.

Involved in Requirement gathering/Analysis for project, design, development, testing, and production rollover,

Involved in development, designing the report, Migration activity

Understand the requirements and functionality of the application from specifications and Analyzing systems and source database,

Project Name: SAP BPC Migration Nov 2015 to MAR 2016

Job Responsabilités:

As a Senior Developer, I am responsible for

Walk-Through with Business Analysts on the new Requirement.

Analyzing the new Requirement and to provide the Estimates.

Development of Informatica mappings and sessions based on user requirements.

Preparation of Technical design and developing MAPS based on it.

Unit/System testing in warranty support

Used IIS for renewal of server certification

Automation and New development on SAP BPC

Project Name: Internal Stock Transaction, Delivery & Reporting August 2015 to Nov 2015

As a DEVELOPER responsible for:

Preparation low level design documents after thorough analysis on existing and to be system

Development of Informatica components as per requirement from the scratch

Unit Testing including the preparation of test castes

Handling Important Mappings, File write process.

To Deliver Defect free code on Time.

Client appreciation for on time delivery

Generated report via SSRS

EDUCATION

Bachelor of Computer Application from west Bengal University in 2015

Master’s in Software Engineering from Birla Institute of Technology and Science Pilani.

CERTIFICATIONS & AWARDS

s

You Made a Difference recognition award from Wipro Jan’2019.

Received Round of Applause award in Dec’2019 from Wipro Technologies.

Received Round of Applause recognition award in Apr’2020 from Wipro Technologies.

Personal Information

Name : Komal Singh

Date of Birth : September 2nd, 1993

Nationality : Indian

Languages Known : Hindi, English, and Bengali

Permanent Address : Asansol 713325, Dist. Burdwan, West Bengal

Contact this candidate