Hi all
I have following points in my roles and responsibilities letter provided by employer in the company letter head.
TO WHOMSOEVER IT MAY CONCERN
This is to certify that Mr. xxxxxxxxxxx was full time employed with xxxxxxxxxxxx from xxxxxx to xxxxxxxxx.
While leaving our organization, he was designated as an xxxxxxxxxxxxxx.
During his employment with xxxxxxxxxxxxxxxxx, he was responsible for the following:-
1. Performing SAS, SQL and Hadoop development within a financial services environment.
2. Migrating SAS applications from UNIX and mainframe systems to distributed LINUX system within a financial services environment.
3. Performing data warehousing, data extraction, transformation and writing SQL scripts for loading enterprise warehouse, for analytics data preparation and creating model ready data and reports.
4. Performing SAS development and support within multiple data sources using Base SAS, SAS Macros, SAS/STAT, SAS/ACCESS, and SAS HPA, development within SAS Enterprise Guide, SAS Enterprise Miner, and SAS DI studio within UNIX/LINUX/legacy systems and SAS Model Manager for creating, managing, deploying, monitoring and operationalizing analytical models.
5. Performing data manipulation using MapReduce, database query interface development using Hive(HQL), Pig for writing scripts, Greenplum databases for query optimizer conversion and PostgreSQL for database development.
He utilized skills including:-
1. Windows, Mainframes, UNIX, Linux.
2. Base SAS, SAS macros, SAS/STAT, SAS/ACCESS, SAS HPA, SAS Model Manager; MapReduce, Hive (HQL), Pig, Greenplum and PostgreSQL, JCL, Shell scripting.
(Please note: Skills and responsibilities specified are as declared by the employee and approved by the last supervisor. This information is to the best of our knowledge and without prejudice).
We wish him all the best for his future endeavors.
I have the following questions.
1) Can some experts review the above responsibilities and point out the missing pieces with reference to CIC. I know CIC format expects few more things like salary in addition to responsibilities in the letter? It would really helpful if someone points them so that I can work on getting the letter in the expected format. I got this letter for a different purpose and unfortunately my company issues the skill letter only once.
2) I have seen people mentioning salary should be mentioned in the letter. If so, is it enough to have last drawn salary alone? My work location spans across India and US for the same company, and my last drawn salary is in USD. Will it be fine to mention the last drawn USD salary alone if last salary is needed?
3) I am yet to create CIC profile. I am guessing work location would be required when I fill the EE application. My work experience spans across India and US. However my company has given only one letter for entire experience and it mentions their Indian HQ address/contacts. Is that okay?
4) I am targeting the NOC 2174. Can someone gone through the PR phase comment on the suitability of the letter for responsibilities of the computer programmer NOC? Just a feedback would be helpful. Because I am slightly worried that all my responsibilities mentioned in the letter focus purely on development and programming, and doesn't talk much requirement gathering and documentation part mentioned (although I do them in my job) in the list of responsibilities. I am planning to write to the NOC email id that has been earlier suggested and get a NOC match from them. But still I am bit worried if missing the things like req gathering, documentation etc would make think the officer that I don't suit the NOC as it doesn't have 60% match with their responsibilities.
5) As I mentioned earlier, my company issues the letter only once in their letterhead. I am planning to get another letter that exhaustively covers my responsibilities along with other missing points from my previous manager in CIC format and submit his id card and company hierarchy along with it. I am planning to write a letter of explanation for this. Is it okay to do that? If so, is it enough if I just mention that my company issues letter only in the specified format once or do I need to provide any proof for that claim too. Also by any chance will CIC think that I got a letter just to suit the immigration purposes as it happens to be a second letter listing my responsibilities?
6) One final question. NOC 2174 says Computer programmers and interactive media developers. My guess people who are working as computer programmers as well as interactive media developers can claim this NOC, and one need not be working on both to claim it. Just wanted to confirm if my understanding is correct.
Thanks so much in advance for any feedback on above queries.