Qc Engineer Etl Tester

Big Data & Hadoop KRUTIBASH RATH

Contact no: 090********/891-***-****

E-mail:*************@*****.***

PAN No: BDIPR6699N PASSPORT No: J3704802

Career Objective

To apply my skill and knowledge in a progressive organization where growth prospects are unlimited which would enhance my skill, provide opportunity to work on cutting edge technology and give ample exposure.

Functional Area

IT Software deployment, Reporting Monitoring Services police.

IT Program Management. (BI & BO )

IT business ( Technical Support )

ETL,UNIX, Oracle tool deployment testing Monitoring. Hadoop

ITIL tool Management.

IT Vendor Management & Follow-up.

Software Development & Testing.

Team Management

Work Experience

Total Experience: -9 Year 2 Month.

Current Professional Details: -4 Year 4 Months at FINACUS SOLUTION PRIVATE LIMITED from (18 April 2017 to Still).

* Client : Odisha State Co-op Bank Ltd(GOVT Bank) & 17 DCCBs & Urban Bank.

* Role : SR Software Implementation Engineer.(Project Manager)

* Project : SWITCH,Core Banking,NFS

*Project Name : INTERNET BANKING.UPI, IMPS, NFS.ATM.POS. Rupay/Master Card

* Skill : ETL,DWH, Shell Script, DBA,UNIX, SQL, PLSQL. Big Data. Swift, ISO 20022. Interface implementation

Responsibilities during this period included:-Production support:

Senior ETL/DataStage Developer/Lead responsible for development, maintenance, and support of ETL jobs to load source system data into Oracle warehouse for initial, daily, and monthly loads, provide DataStage expertise, and mentor other developers, following Best Practices and Standards.

Utilize DataStage/PX 7.5.1 to design, build, and support jobs used to populate Oracle warehouse.

Manage all data warehouse operations for this project, including but not limited to testing, migrations (both DataStage and Oracle), job scheduling, trouble shooting, and production support.

Utilize SQL Programmer and SQL Plus to create, modify, and query Oracle tables for loading, debugging, and data mining.

Utilize DB2 Connect and IBM Mainframe to query DB2 source tables for data verification, profiling, and data mining.

Mentor developers on proper usage of DataStage and best practices and standards.

Work in conjunction with Data Modelers and Architects to implement/modify data models for Stage, Hub, Hub Prime, and Data Mart environments as required to support Data Warehouse reporting and modeling needs.

Utilize Exceed to access Unix components. Extensively Used Datastage (ETL Tool), Oracle PL/SQL, UNIX, MS Products to Extract, Cleanse, Transform and load data to target systems with right format and level of detail.

Used the Datastage Designer to develop the ETL processes for extracting, cleansing, transforming and integrating the EDW data into datamarts.

Used Star Schema and Dimensional modeling for creating data mappings between various BOA data sources to the EDW Data marts.

BO, switch Implementation, designing, developing, testing, troubleshooting and debugging of the applications with good knowledge of all Hadoop,Big Data,JAVA,UNIX Shell Script, and Linux.MapReduce Management. Analysis, Design, Development, Testing and Implementation of Software Applications using Oracle

Programming, analytical, organizational, effective communication, administrative, problem resolution, training, leadership, administrative, project management.UAT testing.

Provide UAT support, system maintenance for the major implementation of systems as assigned by IT management.Liaise with vendor(s) and users, identify the problems in the system, troubleshooting and resolution.Conduct periodic IT check and troubleshooting implementation of patches. Assist with data management of process of testing in preparation of patching.

Project 2: Channel Banking (POS/ATM/E-COM/IMPS/MOBILE & SMS BANKING,FI GATEWAY ).

The ATM Specialist is responsible for performing operational support duties of the ATM Department. Assists the ATM Manager as directed, performs account reconciliation duties, monitors ATM status and currency usage, assists in the proposal and installation process, and investigates ATM related electronic fund transfer (EFT) customer disputes or fraudulent issues in accordance with state and federal regulations. Performs a variety of routine daily tasks, reviews reports, prepares correspondence, and participates in special department projects.

Responsibilities:

(Unit testing, functional, integrated, volume, stress and user acceptance) of implementation projects and Go-Live activities

Day to Day maintenance ATM & SMS server.

Performs account reconciliation daily basic process.

Performs a variety of routine daily tasks duties like (DMS)

Daily basis reviews reports, prepares correspondence.

Customer disputes or fraudulent issues in accordance with 18 banks.

Support all type of technical issue and disputes Management System of all type of Transaction i:e ( ISSUER/ACQUIER/POS/ONUS).

Previous Professional Details: -1 year 3 Months at PHARMA project in May 31, 2015 to Dec 22, 2016)

* Client : Debug Services (Payroll)

* Role : Software analysis

* Project : IMAGECOMPARE (Europe’s)

*Project Name : Artwork Management.

* Skill : ETL,Microsoft SQL-Server 2012 Express Edition, UNIX Shell Script, C++, and LINUX.

Gained exposure:-

Informatica,ETL TESTER & ADMINISTRATOR/DEVELOPER/DWH DESIGN.

Recycle production OLTP server.

Checking CRM OLAP & OLTP DR sync status by mail.

Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using ETL tool informatics Power Center.

Experience in integration of various data sources like Oracle, flat files into staging area.

SQL Development for data integration, data maintenance

BI Analytical/Data Modelling

Analyse user requirement and design BI reporting solution.

Analyse system/data requirement and design data model.

Proactively engage with business to provide innovative solutions.

Manage engagements with external vendors on projects

BI Reporting and Support

Implemented various Data Transformations using Slowly Changing Dimensions

Excellent knowledge and experience in creating source to target mapping.

Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatics Designer.

Technical Profile:

ETL :Informatics 8.x

Databases (OLTP) : ORACLE 8i, 9i, 10g,MSSQL SERVER,Oracle forms

Programming Languages : SQL,UNIX Shell Script, PLSQL, and LINUX.MY SQL.

Operating Systems :Windows XP, Windows NT & 2000, UNIX

Previous Professional Details: -8 Months at SMARTNET SOFTWARE PVT LTD from Mumbai (08-July-2014 to 10-March -2015)

* Client : SAP.

* Role: Sr. Software Developer.

*Project:Team Global.

*Project Name: CRM.

* Skill : ETL, UNIX Shell Script, PLSQL, LINUX. SQL Server 2010

Gained exposure in designing, developing, testing, troubleshooting and debugging of the applications with good knowledge of all Oracle, MS SQL, PL/SQL UNIX Sell Script, and Linux.

Data migration: giving support to central prepaid activation & audit team to retrieve their large volume of data by making SQL Query in Access Platform.

ETL task are monitor through DAC client (Complete ETL, Morning ETL, Evening ETL), Need stop & start services before/after complete ETL.

Data integration and ETL tool that was previously known as ActaWorks. Newer versions of the software include data quality features and are named SAP BODS (Business Objects Data Services). The Data Integrator product consists primarily of a Data Integrator Job Server and the Data Integrator Designer. It is commonly used for building data, ODS systems and data warehouses, etc.

Monitors Siebel Application servers,Database servers, Web servers & Server recycling

Skilful in providing post-implementation, application maintenance and enhancement support with regard to the product / software application; requirement gathering, system analysis as well as finalization of technical / functional specifications.

Deft in functional and technical analysis, configuration, training, workshops and testing of new development and customization of existing systems involving techno-functional expertise in different modules of Oracle

Oracle Data Integrator (ODI),data transformation and merging processes, metadata database which is accessible for the applications responsible for transformation, project development, and integration and information redistribution. Other architecture components are the topology manager. Designer, security manager, operator, agent, scheduler and Metadata navigator.

Adept at testing the prepared modules and thereby starting the implementation of the same.

Possesses knowledge of Oracle (11, 10g, and 9i), SQL, PL/SQL, Toad, and Developer Version 2.1.1.64.

Excellent problem solving skills, good communication and interpersonal skills.

Responsibilities during this period included:-Production support:

Develop the pre-processor and post-processor scripts in PERL for the Mercer Funds files to create the index files for the incoming zip files and to update corresponding pl/sql tables during the post ingestion process

Participate in the Oracle ShareLink project to recommend necessary changes in OnDemand system and testing the loading of PDF files through the new archive, 000INVS

Take part in streamlining the code migration process by syncing up the application scripts between different environments like Production, QA, Dev and UAT. Sync up the Autosys boxes between QA and PROD

Develop the post-processor script in PERL for Team global ingestion process to move the pdf files to the NAS mounted directory structur based on the config file format.

Monitored production database server to resolve performance issues of the applications, related to long-running processes or database-locks and worked with DBA in resolving the issue.

14 Months at Regenersis (India) Ltd formally Digicomp Complete Solution Ltdfrom Mumbai (25-Apr-2013 to 07-July-2014).

* Client : ASUS Technology ltd.

* Role : QC Engineer.

* Project Name : WTP (Windows Testing Programmer)

* Skill : ETL,PL/SQL, UNIX Shell Script, LINUX.

* Industry Practice : IT hardware & electronics.

Responsibilities during this period included: -Application Production support:

Developed Perl scripts to automate frequent reports for the users.

Checking Computer & Electronics device rectifying system software, update to operating system,bios Version,all utility,resolving windows related,operating system windows 7,windows 8, Developed wrapper scripts in Unix shell script

Checking the all related WTP Errors re solved that errors.Developed Perl scripts to load data feeds into system and to generate feeds for the downstream systems

Participated in optimization of stored procedures and SQL queries to reduce the run time of the batch jobs

Reporting Asus technical team all result wtp pass or fail or finally log report.

Giving support to central prepaid activation & audit team to retrieve their large volume of data by

Windows Testing Programmer (WTP) Resolving Error making SQL Query in Access Platform.

Quality control in all warranty policy of company fallow rules and tools & software’s.

Handling 5 engineer For Qc section.

Data transfer from local HDD to web FTP site.

Update all details regarding QC Activities & keep the track of all daily activities.

Previous Professional Details: -11 Months at Kaizen IT Services Private LimitedfromMumbai (01-May-2012 to 16-Feb 2013).

* Client : IBM.

* Project : TATA MOTORS.

* Project Name : ETL Warehousing.

* Role : DC Engineer.

* Skill : ETL, PL/SQL, Oracle forms, LINUX, UNIX, SQL,ODI

* Industry Practice: Automobile services domain

Responsibilities during this period included:-Application Production support:

Developed wrapper scripts in Unix shell script for the AUTOSYS batch jobs

Developed and modified many stored procedures in Sybase to apply the business logic and to generate complex reports

Used BCP extensively for export and import table data, loading CSV files into tables

Responsible for application development and reporting environment administration tasks supporting the Mumbai Warehouse. Technical environment includes Oracle/Unix data warehouse/ data marts sourced from SAP R/3 application environments. MicroStrategy. OLAP and Seagate Crystal Info/Reports are deployed as the decision support and end user access reporting solutions, including web-based data analysis and reporting for over 1500 users.

Data integration and ETL tool that was previously known as ActaWorks. Newer versions of the software include data quality features and are named SAP BODS (Business Objects Data Services). The Data Integrator product consists primarily of a Data Integrator Job Server and the Data Integrator Designer. It is commonly used for building data, ODS systems and data warehouses, etc.

Oracle Data Integrator (ODI), Oracle Warehouse Builder(OWB)data transformation and merging processes, metadata database which is accessible for the applications responsible for transformation, project development, and integration and information redistribution. Other architecture components are the topology manager. Designer, security manager, operator, agent, scheduler and Metadata navigator.

Monitors Siebel Application servers,Database servers, Web servers & Server recycling

Monitoring daily, weekly & Monthly backup through AIX via TIVOLI STORAGE MANAGER.

Recycle production OLTP server.

Checking CRM OLAP & OLTP DR sync status by mail.

Remote Administrations: Telnet, Putty.

Created advanced reports using subreports, parameters, selection criteria, formulas, conditional formatting, running totals, graphs and grouping.

Worked with the development teams, product management teams, executive level, to provide data analysis and reporting.

Shutdown & startups the services of all app (AIX) & gateway servers.

Publish the daily, weekly, monthly & online reports.

Removing log file that are not required and free up disk space.

Maintaining Medias & conducting quarterly,yearly audit Through PSM process via E-TOC tool

Next Previous Employer:-.

1 Year 5 Month Experience at Web Development Company Ltd (WDC) from Mumbai (31-Dec-2010 to 28-Apr-2012).

* Client : IBM.

* Project : Vodafone.

* Project Name : OmniDocs.

* Role : Software Developer.

* Skill :PL/SQL, UNIX Shell Script, SQL Server 2008.ODI

* Industry Practice: Telecommunications services domain.

Responsibilities during this period included:-Application support:

. Responsible for gathering requirements, creating specs, testing and writing reports.

As being part of IT worked with the development teams and Data Warehouse to provide data analysis and reporting.Created Stored Procedures using Query Analyzer, toad and Safesource.

Created advanced reports using sub reports, parameters, selection criteria, formulas, conditional formatting, SQL query, running totals, and On-demand grouping.

Created complex reports using advanced formulas to calculate time differences while excluding weekends.

Created Audit reports to compare present to history.

Responsible for Installing Crystal Report 11 and creating ODBC connection to SQL Server.

Responsible for updating Oracle tnsnamesOra file.

Converted reports from oracle database to sql database.

Responsibility

Purpose

Descriptions

Backup

Database Image Backup Migration

After backup, the HDD handed over to local network team for LTO transfer/backup.

Rectifying Query

Error Rectification

Identifying & resolving backup errors by making SQL Query using SQL Developer.

Error Job scheduling

Resolving Error

Tracing successful document to continue backup process as per company policy.

Data Retrieval

Central Prepaid Team

Giving support to central prepaid activation & audit team to retrieve their large volume of data by making SQL Query in Access Platform.

Checking OmniDocsWebDAV Server

Resolving Error

J2EE and XML-based Application Server Identifying & resolving, JSP error detected

Next Previous Employer:-1 Year and 5 months experience at INGRAM MICROIndia. Ltd from Mumbai (10-Jun-2009 to 20-Dec-2010).

* Client : HPIndia.Ltd.

* Project Name : Impulse.

* Role : Software Engineer.

* Skill : C,C PL/SQL,UNIX Shell, SQL Server 2008

* Industry Practice: IT services domain

* Operating System. : Windows XP (PC).

. Responsibilities during this period included:-Production support:

Assisted lead pl/sql with database script development and maintenance.

Developed validation scripts to ensure referential integrity of data loads.

Prepared production change control documentation.

Developed structure and data to support application development.

Utilized Oracle’s export and import utilities to extract and load sample data.

Utilized Oracle’s sqlloader to load into development and test environments.

Created control files to be used by sqlloader utility.

Developed pl/sql scripts to manage growth of historical data

Created UNIX control files.

Checking CRM OLAP & OLTP DR sync

Developed validation scripts to ensure referential integrity of data loads.

Prepared production change control documentation.

Developed structure and data to support application development.

Utilized Oracle’s export and import utilities to extract and load sample data.

Utilized Oracle’s sqlloader to load into development and test environments.

Created control files to be used by sqlloader utility.

Developed pl/sql scripts to manage growth of historical data

Created UNIX control files.

: Tracing successful document to continue backup process as per company policy.

: Checking IMPULSE WebDAV Server, Resolving the Error,

: J2EE and XML-based Application Server Identifying & resolving, JSP error detected Maintain to store procedures,

Migration support Application: Identifying & resolving backup errors by making SQL Query using SQL Developer.

Academic Qualifications

QUALIFICATION

BOARD/ UNIVERSITY & INSTITUTION

YEAR OF PASSING

MARKS OBTAINED MCA

IBSE,Delhi

2015

63%

DIPLOMA In IT Engineer

S.C.T.E & V.T.

S.I.T.E., Balangir

2009

72%(Avg)

Graduation

S.B.S. College

Berhampur Univ.

2006

50 %(Avg)

12TH

S.B.S. College

C.H.S.E.

2003

44 %

10TH

S.M. High School

S.H.C

2001

41%

PROFFESIONAL & COMPUTING SKIL

Languages known : C, C++,C# & Data Structures, Basic Java, Java Script,

Operating Systems : MS DOS, Windows ’98, 2000, XP,UNIX,LINUX,

Databases: RDBMS, Oracle 9i, PL\SQL, SQL,DBA

Web Design Tools : Photoshop, HTML,CSS,PHP

Microsoft Certified

Lotus Notes 6.5, 7, 8.5 Domino & Client Knowledge.

Hardware & Networking.

Project

Banking Related Application made using C++language.

OSI certified project made using C++ & C

Extra-curricular activities

Participated in technical quiz competition.

Participated in college annual function

Interests and Hobbies

Reading IT Books.

Net surfing.Playing Computer Games.

Assets

Positive thinking, Honesty.

Ability to work in difficult conditions.

Personal Details

Date of Birth : 7th July 1985

Father's Name : Mr Debendranath Rath

Sex : Male

Nationality : Indian

Language known : English, Hindi, Oriya.

Contact Address : 203,CO AJAYA DIXIT,RAGHUNATH NAGAR, BHUBANESWAR,ODISHA

Declaration

I hereby declare that all the above details given by me are true to the best of my knowledge.

Place:

Date: Krutibash Rath

Contact this candidate