Datastage USA Client:
• In 11.7, Complex Logic developed If ID >= 90 than flag "N" and from that record onwards flag "N" till new name and same for every new name.

Informatica USA Client:
In 10.4.0, How to copy Workflow and run. History record copy to .dat file

Australia Client:
• Mentoring on Interview preparation or guidance on ETL Data Warehousing Testing requirement.

Malaysia Client:
• Mentoring on How to Execute .bat file using IBM Datastage 11.7 or sql file call in connector stage w.r.t. different approach 
• Datastage Admin activity done for kill the job which showing running state for a long time period more than 2-3 days.
• Mentor on ETL approach for Architecture role.

Develop or Understand script specialist in korn shell. But, try with other shell also possible.

USA Client:
• Develop script to display all users who have logged in during non-office Hours.

Australia Client:
• Developed Bash Script & session provided on n no. of time matlab command executed based on input run given and generated output file store in directory with new filename w.r.t. input run.

Indian Client :
• Guidance provided on how to understand unix shell script of Data Warehousing Projects or how to faster way to learn unix.
• Develop Script for calculate Age based on Date of Birth provided by user or input file
• Develop Script for Masking data based on input data or files i.e. after 4th character data should be mask for eg: abcd12345abcd based on input, output should be abcd********
• Develop Script for capture all the data between two string in file and re-format it based on user request

Automate process based on requirement.

USA Client:
• 1:1 Live help provided on task of client on RPA Uipath studiox i.e. Gather information from website and store in excel with email file.
• 1:1 Live Help provided using paid session and Job developed for access Google calendar with validation of login details.
• Quiz creation automation done i.e. quiz in xls format to Web portal based on task basis for School purpose.
• Data Extraction done w.r.t. given client format with help of RPA UiPath and IBM Datastage ETL tool based on per page milestone on Fixed price basis.
• Data Scrapping done of web portal based on task basis.
• 1:1 Live Help provided using paid session or automate Send Connection request in Linkedin Using Uipath

Indian Client: ( Mumbai )
• Capture stock details value in txt file based on input by user and given format of txt file with user stock filename.
• Sum of Amount for particular company in given xls file and process with some criteria provided by users. Prepared new xls file with today date with specific format provided by user.

USA Client :
• Oracle Pl/Sql Trigger Provider for if quantity value less than zero while insert into table than Trigger will log error like date, trigger name and exception message.
• Postgres Sql Query provider for Full listing of all tables and all columns in all tables in a Postgres database
• Provided step to view blob data of pdf or word using Oracle Sql Developer with demo
• Data Model Technical Design Document Prepared.

Indian Client: ( Delhi )
• Develop Store Procedure for How to pass multiple value as parameter in Oracle Pl/Sql.

USA Client:
• Data Model Technical Design Document Prepared

16+ Year Of IT Prof. Expr. in AnyWhere In The World - Remotely. 

Jigna N. Mer 

#CSV, #XML, #HTML, #JSON , Transpose CSV vice versa convert in one utility using #unix #shell #script. Total 10 choice and user friendly just choose choice and give result without using any third party tool.


All Converter in One Utility using Unix shell script !!! 

Employee Tracker or Manage using Python !!! 
Feature: Have a choice. Add, delete, update data w. r. t user choice without any writing code. 

Employee Tracker or Manage using Python !!! 

Features:
• User Friendly as want to play with computer or not
• Also, user preference as want X or O choose option
• Unlimited to play with count of how many times play game.
• Score board display for each count of X win or O win including Draw as well.
• Two player have color. X have green or O have Red.
• After play unlimited who final winner etc.

Including existing things as well.

1) Unlimited time you can play i.e. Do you want play again option available. 

2) By mistake, already filled things also take care by logic.

3) Game Tie also handled.

Need any help or are you stuck on Unix Shell Script or need 1:1 Live help or session or your task solution in Unix shell script. Just DM me

Colorful Tic-tac-toe game in Unix !!!

TiC-Tac-Toe game implemented using UiPath tool. 

Following things handled by Uipath for Tic-Tac-Toe game. Game board used Notepad.

1) Unlimited time you can play i.e. Do you want play again option available

2) By mistake, already filled things also take care by logic.

3) Game Tie also handled.

Need ready made code or want to learn or understand, plz. free to DM me.

Tic-Tac-Toe Game Using RPA Uipath

How To Pass Multiple Values (IN Clause Query) in Stored Procedure of Oracle DB

Cursor Movement on Unix !!! 

Calculate BMI and identify are you obesity, over weight etc. using Unix shell script.

Beautiful Christmas Tree On Unix !! 

Write a bash script that will:
loop through the videos from video_texts.csv and for each row/video will:
update sections.json
display out/{video_name}.mp4

Personal details

Jigna M.

Summary

Technical skills

Personal Projects