PAWAN PRASAD

Home No.*, Street No.*

Jai Bharat Enclave, Mohan Nagar Ghaziabad, U.P-201007

Mobile: +91-706*******

Mail id: acz64y@r.postjobfree.com

SUMMARY

Expertise in working with Informatica, Designer, Work Flow Manager, Work Flow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer, Worklet Designer, Gant Chart, Task View, Mapplets, Mappings, Workflows, Sessions, Re-usable Transformations, Shortcuts, Import and Export utilities.

Experienced in Data Warehousing, Dimensional Modelling concepts with experience in Designing, developing & maintaining ETL(Informatica).

Have excellent knowledge of Data Warehousing design and principals.

Having experience in converting PLSQL code into Informatica mapping.

Expertise in working with Informatica, Designer, Work Flow Manager, Work Flow Monitor.

Experienced in SQL queries, Stored procedures, Triggers and UNIX Scripts.

Having knowledge of BI reporting tools Qlickview.

Experience creating custom formatted reports from flatfiles by using Java Apache POI.

Experience in using various database interaction utilities like AQT, SQL Developer etc.

Experience in developing JAVA tools related to Informatica.

Experience in Performance tuning of Informatica (sources, mappings, targets and sessions), tuning the SQL queries and database performance tuning..

EXPERIENCE

Software Engineer, LexisNexis

Gurgaon, Nov 2016 – Present

Working as Software Engineer in LexisNexis® which is a leading global provider of content-enabled workflow solutions designed specifically for professionals in the legal, risk management. The current role requires to implement different stages of ETL and conversion process with Informatica mappings and workflows, Informatica DT codes, Java and Perl scripts.

Roles and Responsibility

•Creating ETL application to fetch the data from different sources and send the converted data into centralized Data warehouse to deliver the content online.

•Creating ETL mappings and workflow to implement the different stages of conversion process.

•Writing Informatica DT codes to transform the data into new schemas.

•Writing Perl script for data massaging.

•Implementing the conversion instruction change on the existing Informatica DT code.

•Developed a JAVA tool to validate the XML against XSDs.

•Created a Java tool to automate rerunning failed process and implemented SFTP using Java.

Programmer Analyst, Cognizant Technology Solution

Kolkata, West Bengal JUN,2015 – NOV,2016

Worked as ETL (Informatica) and Data Warehouse developer in insurance domain for the client METLIFE, the role required understanding the data model, designing the model for Enterprise Data warehouse(EDW), developing UNIX Script, Informatica mapping and running the ETL jobs.

Roles and Responsibilities

•Participate in all phases of Data Warehousing like Analysis, requirement gathering and Design and Development of Mappings.

•Understanding the data model and creating the data model for staging layer and reporting layer for Data warehouse.

•Understand the ETL specifications and build the ETL applications like Mappings on daily basis.

•Writing complex SQL to DB like Oracle, MySQL Server and DB2 for analysis.

•Converting PLSQL codes into Informatica Mappings.

•Create the mappings, sessions and Workflows, as per requirement of business to implement the logic.

•Scheduling the Jobs on Maestro Scheduler.

•Creating UNIX script to trigger the workflow according to the different scenarios using PMCMD and PMREP commands.

•Create a JAVA application to automate the Informatica object validation across different environments.

•Creating custom formatted reports from flatfiles by using Java Apache POI.

•Using Informatica B2B Data Transformation to extract the data from different sources.

Consultant, Ericsson

Noida, SEP, 2014 - APR, 2015

Worked as GNOC personnel and responsible for monitoring Aircel’s six circles for BTS and NODE outage to avoid Interruption in Aircel GSM services and 3G services and creating reports using SQL to analysis purpose.

Roles and Responsibilities

•Network monitoring.

•Communications management.

•Creating OSS health report.

•Using SQL to create reports for analysis purpose.

EDUCATION

2014 B. Tech (Electronics and Communication) H.R Institute of Technology, UPTU 70.1%

2010 AISSCE, Swami Vivekanad Sarswati Vidhay Mandir, Ghaziabad, CBSE, 74%

2008 AISSE, Swami Vivekanad Sarswati Vidhay Mandir, Ghaziabad, 78%

SKILLS

Data Warehousing/ETL Tools: Informatica Power Center

Databases: MS-SQL Server, ORACLE and DB2

Data Modeling: Star Schema and Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.

Programming Languages: JAVA, UNIX Shell Scripting.

Contact this candidate